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_SUM_TRAN dependencies on HR_ALL_ORGANIZATION_UNITS_TL

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

2798: AND pel.encumbrance_date between
2799: hou.date_from and nvl(hou.date_to,pel.encumbrance_date);
2800:
2801: -- bug fix 1671938
2802: l_orig_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
2803: l_orig_org_id number;
2804:
2805: -- End of Get org id cursor Ravindra
2806: / *

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

2857: AND poa.set_of_books_id = p_set_of_books_id
2858: AND p_distribution_date BETWEEN poa.start_date_active AND
2859: nvl(poa.end_date_active,p_distribution_date); Bug 2056877.* /
2860: organization_account_id = p_organization_account_id; --Added for bug 2056877.
2861: l_organization_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
2862: l_organization_id NUMBER(15);
2863: l_rowid ROWID;
2864: l_assignment_id NUMBER(9);
2865: l_encumbrance_date DATE;

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

2885: l_dr_summary_amount NUMBER := 0;
2886: l_cr_summary_amount NUMBER := 0;
2887: l_dr_cr_flag VARCHAR2(1);
2888: l_effective_date DATE;
2889: x_susp_failed_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
2890: x_susp_failed_status VARCHAR2(50);
2891: x_susp_failed_date DATE;
2892: x_lines_glccid NUMBER(15);
2893: x_susp_nf_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration

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

2889: x_susp_failed_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
2890: x_susp_failed_status VARCHAR2(50);
2891: x_susp_failed_date DATE;
2892: x_lines_glccid NUMBER(15);
2893: x_susp_nf_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
2894: x_susp_nf_date DATE;
2895: l_return_status VARCHAR2(10);
2896: l_group_id NUMBER:=p_group_id; -- bug fix 1570575
2897: l_rec_cnt NUMBER := 0;

Line 3442: l_orig_org_name hr_all_organization_units_tl.name%TYPE;

3438: l_encumbrance_date DATE;
3439: l_lines_glccid NUMBER(15);
3440: l_organization_account_id NUMBER(9);
3441: l_susp_glccid NUMBER(15);
3442: l_orig_org_name hr_all_organization_units_tl.name%TYPE;
3443: l_orig_org_id NUMBER(15);
3444: l_cnt_gl_interface NUMBER;
3445: l_gl_project_flag VARCHAR2(1);
3446: l_suspense_ac_failed VARCHAR2(1);

Line 3449: l_organization_name hr_all_organization_units_tl.name%TYPE;

3445: l_gl_project_flag VARCHAR2(1);
3446: l_suspense_ac_failed VARCHAR2(1);
3447: l_suspense_ac_not_found VARCHAR2(1);
3448: l_susp_ac_found VARCHAR2(10);
3449: l_organization_name hr_all_organization_units_tl.name%TYPE;
3450: l_organization_id NUMBER(15);
3451: l_return_value VARCHAR2(30);
3452: l_effective_date DATE;
3453: no_profile_exists EXCEPTION;

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

5291: hou.date_from and nvl(hou.date_to,pel.encumbrance_date);
5292:
5293:
5294:
5295: l_orig_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
5296: l_orig_org_id number;
5297:
5298: -- End of Get org id cursor Ravindra
5299: / * CURSOR assign_susp_ac_cur(P_ENC_SUMMARY_LINE_ID IN NUMBER) IS

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

5351: nvl(poa.end_date_active,p_encumbrance_date); Bug 2056877 * /
5352: organization_account_id = p_organization_account_id; --Added for bug 2056877.
5353:
5354:
5355: l_organization_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
5356: l_organization_id NUMBER(15);
5357: l_rowid ROWID;
5358: l_assignment_id NUMBER(9);
5359: l_encumbrance_date DATE;

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

5381: l_orig_trx_reference VARCHAR2(30);
5382: l_enc_ref VARCHAR2(30);
5383: l_effective_date DATE;
5384:
5385: x_susp_failed_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
5386: x_susp_failed_reject_code VARCHAR2(30);
5387: x_susp_failed_date DATE;
5388: x_susp_nf_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
5389: x_susp_nf_date DATE;

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

5384:
5385: x_susp_failed_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
5386: x_susp_failed_reject_code VARCHAR2(30);
5387: x_susp_failed_date DATE;
5388: x_susp_nf_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
5389: x_susp_nf_date DATE;
5390: l_return_status VARCHAR2(10);
5391: l_no_run NUMBER;
5392: l_susp_glccid NUMBER(15);

Line 6033: l_orig_org_name hr_all_organization_units_tl.name%TYPE;

6029: l_lines_glccid NUMBER(15);
6030: l_organization_account_id NUMBER(9);
6031: l_susp_glccid NUMBER(15);
6032: l_new_gl_code_combination_id NUMBER(15);
6033: l_orig_org_name hr_all_organization_units_tl.name%TYPE;
6034: l_orig_org_id NUMBER(15);
6035: l_cnt_gl_interface NUMBER;
6036: l_autopop_status VARCHAR2(1);
6037: l_gl_project_flag VARCHAR2(1);

Line 6041: l_organization_name hr_all_organization_units_tl.name%TYPE;

6037: l_gl_project_flag VARCHAR2(1);
6038: l_suspense_ac_failed VARCHAR2(1);
6039: l_suspense_ac_not_found VARCHAR2(1);
6040: l_susp_ac_found VARCHAR2(10);
6041: l_organization_name hr_all_organization_units_tl.name%TYPE;
6042: l_organization_id NUMBER(15);
6043: l_return_value VARCHAR2(30);
6044: l_autopop_error VARCHAR2(30);
6045: l_effective_date DATE;