I am trying to call "Mass Additions Create" program from "Payables Transfer to General ledger" program.
Actually the "Payables Transfer to General ledger" program is a Oracle report.so i am trying to call that program using FND_REQUEST.SUBMIT_REQUEST.
But i am facing a error
Cause: FDPSTP failed due to ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'MASS_ADDITIONS_CREATE'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
But i have passed both the mandatory parameters GL_DATE and BOOK, even though im facing the error.
Here it is my script
cursor c1 is select sysdate from dual;
cursor c2 is select FND_PROFILE.VALUE('ORG_ID') from dual;
cursor c3 is SELECT BOOK_TYPE_CODE FROM AP_FA_TABLE WHERE ORG_ID=v_org_id;
where upper(user_name) = 'CLOVER1';
select responsibility_id, application_id
into v_resp_id_abc, v_appl_id_abc
where upper(responsibility_name) ='SEBI HO PAYABLES'
and language = 'US';