eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.SSP_SMP_SUPPORT_PKG dependencies on DBMS_JOB

Line 2718: DBMS_JOB.SUBMIT(l_job_no,'ssp_ssp_pkg.ssp_control('||r_affected_absences.absence_id||');');

2714:
2715: hr_utility.trace('Processing SSP absence: '||r_affected_absences.absence_id);
2716: --6800788 begin
2717: --ssp_ssp_pkg.ssp_control(r_affected_absences.absence_id);
2718: DBMS_JOB.SUBMIT(l_job_no,'ssp_ssp_pkg.ssp_control('||r_affected_absences.absence_id||');');
2719: l_count := l_count + 1;
2720: l_tbl_job(l_count).job_no := l_job_no;
2721: l_tbl_job(l_count).person_id := r_affected_absences.person_id;
2722: l_tbl_job(l_count).absence_id := r_affected_absences.absence_id;

Line 2796: DBMS_JOB.SUBMIT(l_job_no,'ssp_smp_pkg.smp_control('||r_affected_maternities.maternity_id||',FALSE);');

2792: --6800788 begin
2793: -- ssp_smp_pkg.smp_control(p_maternity_id => r_affected_maternities.maternity_id,
2794: -- p_deleting => FALSE);
2795:
2796: DBMS_JOB.SUBMIT(l_job_no,'ssp_smp_pkg.smp_control('||r_affected_maternities.maternity_id||',FALSE);');
2797: l_mat_count := l_mat_count + 1;
2798: l_count := l_count + 1;
2799: l_tbl_job(l_count).job_no := l_job_no;
2800: l_tbl_job(l_count).person_id := r_affected_maternities.person_id;

Line 2861: DBMS_JOB.SUBMIT(l_job_no,'ssp_sap_pkg.sap_control('||r_affected_adoption.maternity_id||',FALSE);');

2857: --6800788 begin
2858: -- ssp_sap_pkg.sap_control(p_maternity_id => r_affected_adoption.maternity_id,
2859: -- p_deleting => FALSE);
2860:
2861: DBMS_JOB.SUBMIT(l_job_no,'ssp_sap_pkg.sap_control('||r_affected_adoption.maternity_id||',FALSE);');
2862: l_adop_count := l_adop_count + 1;
2863: l_count := l_count + 1;
2864: l_tbl_job(l_count).job_no := l_job_no;
2865: l_tbl_job(l_count).person_id := r_affected_adoption.person_id;

Line 2924: DBMS_JOB.SUBMIT(l_job_no,'ssp_pad_pkg.pad_control('||r_affected_pat_adop.maternity_id||',FALSE);');

2920: --6800788 begin
2921: -- ssp_pad_pkg.pad_control(p_maternity_id => r_affected_pat_adop.maternity_id,
2922: -- p_deleting => FALSE);
2923:
2924: DBMS_JOB.SUBMIT(l_job_no,'ssp_pad_pkg.pad_control('||r_affected_pat_adop.maternity_id||',FALSE);');
2925: l_pat_adop_count := l_pat_adop_count + 1;
2926: l_count := l_count + 1;
2927: l_tbl_job(l_count).job_no := l_job_no;
2928: l_tbl_job(l_count).person_id := r_affected_pat_adop.person_id;

Line 2990: DBMS_JOB.SUBMIT(l_job_no,'ssp_pab_pkg.pab_control('||r_affected_pat_Birth.maternity_id||',FALSE);');

2986: --6800788 begin
2987: -- ssp_pab_pkg.pab_control(p_maternity_id => r_affected_pat_Birth.maternity_id,
2988: -- p_deleting => FALSE);
2989:
2990: DBMS_JOB.SUBMIT(l_job_no,'ssp_pab_pkg.pab_control('||r_affected_pat_Birth.maternity_id||',FALSE);');
2991: l_pat_Birth_count := l_pat_birth_count + 1;
2992: l_count := l_count + 1;
2993: l_tbl_job(l_count).job_no := l_job_no;
2994: l_tbl_job(l_count).person_id := r_affected_pat_Birth.person_id;

Line 3057: DBMS_JOB.REMOVE(l_tbl_job(I).job_no);

3053:
3054: IF l_fail > 0
3055: THEN
3056: l_fail_count := l_fail_count + 1;
3057: DBMS_JOB.REMOVE(l_tbl_job(I).job_no);
3058: commit;
3059: p_job_err(l_fail_count) := ' Process Failed for person id '||l_tbl_job(I).person_id||' with absence id '||l_tbl_job(I).absence_id;
3060: hr_utility.trace(' Job '||l_tbl_job(I).job_no||' Failed for person id '||l_tbl_job(I).person_id||' with absence id '||l_tbl_job(I).absence_id);
3061: -- DBMS_OUTPUT.PUT_LINE(' Job '||l_tbl_job(I).job_no||' Failed for person id '||l_tbl_job(I).person_id||' with absence id '||l_tbl_job(I).absence_id);