[Home] [Help]
413: -- To_char(sysdate,'HHSSSS')
414: SELECT PAY_US_RPT_TOTALS_S.NEXTVAL INTO l_ppa_finder
415: FROM DUAL;
416: --Starting the request set
417: success := fnd_submit.set_request_set('PAY', 'PAYEXREP');
418: --Hard coded the values based on report or group
419: IF p_request_type = 'ER' then
420: l_request_name := 'Exception Report';
421: l_grp_request_code :=NULL;
487: -- 'Exception Report Preprocessor'
488: if ( success ) then
489: /* submit program PQPEXREP which is in stage STAGE1 */
490: IF TO_NUMBER(l_product_release) = 11 THEN
491: success := fnd_submit.submit_program('PQP','PQPEXREP','Exception Report Preprocessor'
492: ,argument1=>'ARCHIVE'
493: ,argument2=>'EXPREP'
494: ,argument3=>'DEFAULT'
495: ,argument4=> fnd_date.date_to_canonical(p_effective_date)
532: OPEN c_template_code;
533: FETCH c_template_code into l_temp_id;
534: CLOSE c_template_code;
535:
536: success := fnd_submit.submit_program('PQP','PQPEXREP','Exception Report Preprocessor'
537: ,argument1=>'ARCHIVE'
538: ,argument2=>'EXPREP'
539: ,argument3=>'DEFAULT'
540: ,argument4=> fnd_date.date_to_canonical(p_effective_date)
600: end if;
601:
602: -- 'Exception Report'
603: /* submit program PQPRPEXR which is in stage STAGE2 */
604: success := fnd_submit.submit_program('PQP','PQPXMLLAY', 'Payroll Exception Report'
605: ,argument1=>l_ppa_finder
606: ,argument2=>NULL
607: ,argument3=>p_business_group_id
608: ,argument4=>l_request_name --Select Report or Group
624: ELSE
625: hr_utility.set_location('Stage2 first submit success' ,50);
626: end if;
627: /* Submit the Request set */
628: req_id := fnd_submit.submit_set(null,FALSE);
629: hr_utility.set_location('Request ID:'||req_id ,50);
630: end if;
631: p_request_id := req_id;
632: p_return_status := 'S';