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 3402: l_orig_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration

3398: AND paf.organization_id = hou.organization_id
3399: AND pel.effective_date between
3400: hou.date_from and nvl(hou.date_to,pel.effective_date);
3401:
3402: l_orig_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3403: l_orig_org_id number;
3404: l_superceded_line_id number;
3405:
3406: -- End of Get org id cursor Ravindra

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

3466: nvl(poa.end_date_active,p_encumbrance_date); Bug 2056877.* /
3467: organization_account_id = p_organization_account_id; --Added for bug 2056877.
3468: End of comment for Enh. Removal of suspense posting in Liquidation *****/
3469:
3470: -- l_organization_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3471: -- l_organization_id NUMBER(15);
3472: -- l_rowid ROWID;
3473: -- l_assignment_id NUMBER(9);
3474: -- l_encumbrance_date DATE;

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

3494: -- l_dr_cr_flag VARCHAR2(1);
3495: -- l_effective_date DATE;
3496:
3497: /***** Commented for Enh. 2768298 Removal of suspense posting in Liquidation
3498: x_susp_failed_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3499: x_susp_failed_status VARCHAR2(50);
3500: x_susp_failed_date DATE;
3501: x_susp_nf_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3502: x_susp_nf_date DATE;

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

3497: /***** Commented for Enh. 2768298 Removal of suspense posting in Liquidation
3498: x_susp_failed_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3499: x_susp_failed_status VARCHAR2(50);
3500: x_susp_failed_date DATE;
3501: x_susp_nf_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3502: x_susp_nf_date DATE;
3503: End of comment for Enh. 2768298 Removal of suspense posting in Liquidation *****/
3504: /***** Commented for bug fix 4625734
3505: x_lines_glccid NUMBER(15);

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

5019: -- l_enc_type_id NUMBER(15);
5020: l_tr_source VARCHAR2(30);
5021: -- l_exp_comment VARCHAR2(240);
5022: -- l_emp_num VARCHAR2(30);
5023: -- l_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
5024: -- l_seg1 VARCHAR2(25);
5025: -- l_task_number VARCHAR2(25);
5026: ----l_gms_batch_name VARCHAR2(10); replaced usage with global var for 3473294
5027: l_exp_end_dt DATE;

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

5995: AND paf.organization_id = hou.organization_id
5996: AND pel.effective_date between
5997: hou.date_from and nvl(hou.date_to,pel.effective_date);
5998:
5999: l_orig_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
6000: l_orig_org_id number;
6001: l_superceded_line_id number;
6002:
6003: -- End of Get org id cursor Ravindra

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

6059: nvl(poa.end_date_active,p_encumbrance_date); Bug 2056877 * /
6060: organization_account_id = p_organization_account_id; --Added for bug 2056877.
6061: End of comment for Enh. 2768298 Removal of suspense postingin liquidation *****/
6062:
6063: l_organization_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
6064: l_organization_id NUMBER(15);
6065: l_rowid ROWID;
6066: l_assignment_id NUMBER(9);
6067: l_encumbrance_date DATE;

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

6093: l_effective_date DATE;
6094: End of comment for bug fix 4625734 *****/
6095:
6096: /***** Commented for Enh. 2768298 Removal of suspense posting in Liquidation
6097: x_susp_failed_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration;
6098: x_susp_failed_reject_code VARCHAR2(30);
6099: x_susp_failed_date DATE;
6100: x_susp_nf_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
6101: x_susp_nf_date DATE;

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

6096: /***** Commented for Enh. 2768298 Removal of suspense posting in Liquidation
6097: x_susp_failed_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration;
6098: x_susp_failed_reject_code VARCHAR2(30);
6099: x_susp_failed_date DATE;
6100: x_susp_nf_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
6101: x_susp_nf_date DATE;
6102: End of comment for Enh. 2768298 Removal of suspense posting in Liquidation *****/
6103:
6104: l_return_status VARCHAR2(10);