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.PSP_ENC_LIQ_TRAN dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 3459: l_orig_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration

3455: AND paf.organization_id = hou.organization_id
3456: AND pel.effective_date between
3457: hou.date_from and nvl(hou.date_to,pel.effective_date);
3458:
3459: l_orig_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3460: l_orig_org_id number;
3461: l_superceded_line_id number;
3462:
3463: -- End of Get org id cursor Ravindra

Line 3527: -- l_organization_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration

3523: nvl(poa.end_date_active,p_encumbrance_date); Bug 2056877.* /
3524: organization_account_id = p_organization_account_id; --Added for bug 2056877.
3525: End of comment for Enh. Removal of suspense posting in Liquidation *****/
3526:
3527: -- l_organization_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3528: -- l_organization_id NUMBER(15);
3529: -- l_rowid ROWID;
3530: -- l_assignment_id NUMBER(9);
3531: -- l_encumbrance_date DATE;

Line 3555: x_susp_failed_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration

3551: -- l_dr_cr_flag VARCHAR2(1);
3552: -- l_effective_date DATE;
3553:
3554: /***** Commented for Enh. 2768298 Removal of suspense posting in Liquidation
3555: x_susp_failed_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3556: x_susp_failed_status VARCHAR2(50);
3557: x_susp_failed_date DATE;
3558: x_susp_nf_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3559: x_susp_nf_date DATE;

Line 3558: x_susp_nf_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration

3554: /***** Commented for Enh. 2768298 Removal of suspense posting in Liquidation
3555: x_susp_failed_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3556: x_susp_failed_status VARCHAR2(50);
3557: x_susp_failed_date DATE;
3558: x_susp_nf_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3559: x_susp_nf_date DATE;
3560: End of comment for Enh. 2768298 Removal of suspense posting in Liquidation *****/
3561: /***** Commented for bug fix 4625734
3562: x_lines_glccid NUMBER(15);

Line 5088: -- l_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration

5084: -- l_enc_type_id NUMBER(15);
5085: l_tr_source VARCHAR2(30);
5086: -- l_exp_comment VARCHAR2(240);
5087: -- l_emp_num VARCHAR2(30);
5088: -- l_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
5089: -- l_seg1 VARCHAR2(25);
5090: -- l_task_number VARCHAR2(25);
5091: ----l_gms_batch_name VARCHAR2(10); replaced usage with global var for 3473294
5092: l_exp_end_dt DATE;

Line 6132: l_orig_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration

6128: AND paf.organization_id = hou.organization_id
6129: AND pel.effective_date between
6130: hou.date_from and nvl(hou.date_to,pel.effective_date);
6131:
6132: l_orig_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
6133: l_orig_org_id number;
6134: l_superceded_line_id number;
6135:
6136: -- End of Get org id cursor Ravindra

Line 6196: l_organization_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration

6192: nvl(poa.end_date_active,p_encumbrance_date); Bug 2056877 * /
6193: organization_account_id = p_organization_account_id; --Added for bug 2056877.
6194: End of comment for Enh. 2768298 Removal of suspense postingin liquidation *****/
6195:
6196: l_organization_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
6197: l_organization_id NUMBER(15);
6198: l_rowid ROWID;
6199: l_assignment_id NUMBER(9);
6200: l_encumbrance_date DATE;

Line 6230: x_susp_failed_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration;

6226: l_effective_date DATE;
6227: End of comment for bug fix 4625734 *****/
6228:
6229: /***** Commented for Enh. 2768298 Removal of suspense posting in Liquidation
6230: x_susp_failed_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration;
6231: x_susp_failed_reject_code VARCHAR2(30);
6232: x_susp_failed_date DATE;
6233: x_susp_nf_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
6234: x_susp_nf_date DATE;

Line 6233: x_susp_nf_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration

6229: /***** Commented for Enh. 2768298 Removal of suspense posting in Liquidation
6230: x_susp_failed_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration;
6231: x_susp_failed_reject_code VARCHAR2(30);
6232: x_susp_failed_date DATE;
6233: x_susp_nf_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
6234: x_susp_nf_date DATE;
6235: End of comment for Enh. 2768298 Removal of suspense posting in Liquidation *****/
6236:
6237: l_return_status VARCHAR2(10);