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 3150: DBMS_JOB.SUBMIT(l_job_no,'ssp_ssp_pkg.ssp_control('||r_affected_absences.absence_id||');');

3146:
3147: hr_utility.trace('Processing SSP absence: '||r_affected_absences.absence_id);
3148: --6800788 begin
3149: --ssp_ssp_pkg.ssp_control(r_affected_absences.absence_id);
3150: DBMS_JOB.SUBMIT(l_job_no,'ssp_ssp_pkg.ssp_control('||r_affected_absences.absence_id||');');
3151: l_count := l_count + 1;
3152: l_tbl_job(l_count).job_no := l_job_no;
3153: l_tbl_job(l_count).person_id := r_affected_absences.person_id;
3154: l_tbl_job(l_count).absence_id := r_affected_absences.absence_id;

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

3224: --6800788 begin
3225: -- ssp_smp_pkg.smp_control(p_maternity_id => r_affected_maternities.maternity_id,
3226: -- p_deleting => FALSE);
3227:
3228: DBMS_JOB.SUBMIT(l_job_no,'ssp_smp_pkg.smp_control('||r_affected_maternities.maternity_id||',FALSE);');
3229: l_mat_count := l_mat_count + 1;
3230: l_count := l_count + 1;
3231: l_tbl_job(l_count).job_no := l_job_no;
3232: l_tbl_job(l_count).person_id := r_affected_maternities.person_id;

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

3289: --6800788 begin
3290: -- ssp_sap_pkg.sap_control(p_maternity_id => r_affected_adoption.maternity_id,
3291: -- p_deleting => FALSE);
3292:
3293: DBMS_JOB.SUBMIT(l_job_no,'ssp_sap_pkg.sap_control('||r_affected_adoption.maternity_id||',FALSE);');
3294: l_adop_count := l_adop_count + 1;
3295: l_count := l_count + 1;
3296: l_tbl_job(l_count).job_no := l_job_no;
3297: l_tbl_job(l_count).person_id := r_affected_adoption.person_id;

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

3352: --6800788 begin
3353: -- ssp_pad_pkg.pad_control(p_maternity_id => r_affected_pat_adop.maternity_id,
3354: -- p_deleting => FALSE);
3355:
3356: DBMS_JOB.SUBMIT(l_job_no,'ssp_pad_pkg.pad_control('||r_affected_pat_adop.maternity_id||',FALSE);');
3357: l_pat_adop_count := l_pat_adop_count + 1;
3358: l_count := l_count + 1;
3359: l_tbl_job(l_count).job_no := l_job_no;
3360: l_tbl_job(l_count).person_id := r_affected_pat_adop.person_id;

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

3418: --6800788 begin
3419: -- ssp_pab_pkg.pab_control(p_maternity_id => r_affected_pat_Birth.maternity_id,
3420: -- p_deleting => FALSE);
3421:
3422: DBMS_JOB.SUBMIT(l_job_no,'ssp_pab_pkg.pab_control('||r_affected_pat_Birth.maternity_id||',FALSE);');
3423: l_pat_Birth_count := l_pat_birth_count + 1;
3424: l_count := l_count + 1;
3425: l_tbl_job(l_count).job_no := l_job_no;
3426: l_tbl_job(l_count).person_id := r_affected_pat_Birth.person_id;

Line 3487: DBMS_JOB.SUBMIT(l_job_no,'ssp_apad_pkg.apad_control('||r_affected_apat_adop.maternity_id||',FALSE);');

3483: begin
3484: hr_utility.trace('Processing ASPP Adoption absence: '||r_affected_apat_adop.maternity_id);
3485:
3486:
3487: DBMS_JOB.SUBMIT(l_job_no,'ssp_apad_pkg.apad_control('||r_affected_apat_adop.maternity_id||',FALSE);');
3488: l_apat_adop_count := l_apat_adop_count + 1;
3489: l_count := l_count + 1;
3490: l_tbl_job(l_count).job_no := l_job_no;
3491: l_tbl_job(l_count).person_id := r_affected_apat_adop.person_id;

Line 3547: DBMS_JOB.SUBMIT(l_job_no,'ssp_apab_pkg.apab_control('||r_affected_apat_birth.maternity_id||',FALSE);');

3543: /* ASPP Adoption Control call block */
3544: begin
3545: hr_utility.trace('Processing ASPP Birth absence: '||r_affected_apat_birth.maternity_id);
3546:
3547: DBMS_JOB.SUBMIT(l_job_no,'ssp_apab_pkg.apab_control('||r_affected_apat_birth.maternity_id||',FALSE);');
3548: l_apat_birth_count := l_apat_birth_count + 1;
3549: l_count := l_count + 1;
3550: l_tbl_job(l_count).job_no := l_job_no;
3551: l_tbl_job(l_count).person_id := r_affected_apat_birth.person_id;

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

3612: IF l_fail > 1
3613: --Bug Fix 6870415 End
3614: THEN
3615: l_fail_count := l_fail_count + 1;
3616: DBMS_JOB.REMOVE(l_tbl_job(I).job_no);
3617: commit;
3618: 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;
3619: 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);
3620: -- 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);