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

2756: AND pel.encumbrance_date between
2757: hou.date_from and nvl(hou.date_to,pel.encumbrance_date);
2758:
2759: -- bug fix 1671938
2760: l_orig_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
2761: l_orig_org_id number;
2762:
2763: -- End of Get org id cursor Ravindra
2764: / *

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

2815: AND poa.set_of_books_id = p_set_of_books_id
2816: AND p_distribution_date BETWEEN poa.start_date_active AND
2817: nvl(poa.end_date_active,p_distribution_date); Bug 2056877.* /
2818: organization_account_id = p_organization_account_id; --Added for bug 2056877.
2819: l_organization_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
2820: l_organization_id NUMBER(15);
2821: l_rowid ROWID;
2822: l_assignment_id NUMBER(9);
2823: l_encumbrance_date DATE;

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

2843: l_dr_summary_amount NUMBER := 0;
2844: l_cr_summary_amount NUMBER := 0;
2845: l_dr_cr_flag VARCHAR2(1);
2846: l_effective_date DATE;
2847: x_susp_failed_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
2848: x_susp_failed_status VARCHAR2(50);
2849: x_susp_failed_date DATE;
2850: x_lines_glccid NUMBER(15);
2851: x_susp_nf_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration

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

2847: x_susp_failed_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
2848: x_susp_failed_status VARCHAR2(50);
2849: x_susp_failed_date DATE;
2850: x_lines_glccid NUMBER(15);
2851: x_susp_nf_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
2852: x_susp_nf_date DATE;
2853: l_return_status VARCHAR2(10);
2854: l_group_id NUMBER:=p_group_id; -- bug fix 1570575
2855: l_rec_cnt NUMBER := 0;

Line 3400: l_orig_org_name hr_all_organization_units_tl.name%TYPE;

3396: l_encumbrance_date DATE;
3397: l_lines_glccid NUMBER(15);
3398: l_organization_account_id NUMBER(9);
3399: l_susp_glccid NUMBER(15);
3400: l_orig_org_name hr_all_organization_units_tl.name%TYPE;
3401: l_orig_org_id NUMBER(15);
3402: l_cnt_gl_interface NUMBER;
3403: l_gl_project_flag VARCHAR2(1);
3404: l_suspense_ac_failed VARCHAR2(1);

Line 3407: l_organization_name hr_all_organization_units_tl.name%TYPE;

3403: l_gl_project_flag VARCHAR2(1);
3404: l_suspense_ac_failed VARCHAR2(1);
3405: l_suspense_ac_not_found VARCHAR2(1);
3406: l_susp_ac_found VARCHAR2(10);
3407: l_organization_name hr_all_organization_units_tl.name%TYPE;
3408: l_organization_id NUMBER(15);
3409: l_return_value VARCHAR2(30);
3410: l_effective_date DATE;
3411: no_profile_exists EXCEPTION;

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

5108: hou.date_from and nvl(hou.date_to,pel.encumbrance_date);
5109:
5110:
5111:
5112: l_orig_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
5113: l_orig_org_id number;
5114:
5115: -- End of Get org id cursor Ravindra
5116: / * CURSOR assign_susp_ac_cur(P_ENC_SUMMARY_LINE_ID IN NUMBER) IS

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

5168: nvl(poa.end_date_active,p_encumbrance_date); Bug 2056877 * /
5169: organization_account_id = p_organization_account_id; --Added for bug 2056877.
5170:
5171:
5172: l_organization_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
5173: l_organization_id NUMBER(15);
5174: l_rowid ROWID;
5175: l_assignment_id NUMBER(9);
5176: l_encumbrance_date DATE;

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

5198: l_orig_trx_reference VARCHAR2(30);
5199: l_enc_ref VARCHAR2(30);
5200: l_effective_date DATE;
5201:
5202: x_susp_failed_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
5203: x_susp_failed_reject_code VARCHAR2(30);
5204: x_susp_failed_date DATE;
5205: x_susp_nf_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
5206: x_susp_nf_date DATE;

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

5201:
5202: x_susp_failed_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
5203: x_susp_failed_reject_code VARCHAR2(30);
5204: x_susp_failed_date DATE;
5205: x_susp_nf_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
5206: x_susp_nf_date DATE;
5207: l_return_status VARCHAR2(10);
5208: l_no_run NUMBER;
5209: l_susp_glccid NUMBER(15);

Line 5850: l_orig_org_name hr_all_organization_units_tl.name%TYPE;

5846: l_lines_glccid NUMBER(15);
5847: l_organization_account_id NUMBER(9);
5848: l_susp_glccid NUMBER(15);
5849: l_new_gl_code_combination_id NUMBER(15);
5850: l_orig_org_name hr_all_organization_units_tl.name%TYPE;
5851: l_orig_org_id NUMBER(15);
5852: l_cnt_gl_interface NUMBER;
5853: l_autopop_status VARCHAR2(1);
5854: l_gl_project_flag VARCHAR2(1);

Line 5858: l_organization_name hr_all_organization_units_tl.name%TYPE;

5854: l_gl_project_flag VARCHAR2(1);
5855: l_suspense_ac_failed VARCHAR2(1);
5856: l_suspense_ac_not_found VARCHAR2(1);
5857: l_susp_ac_found VARCHAR2(10);
5858: l_organization_name hr_all_organization_units_tl.name%TYPE;
5859: l_organization_id NUMBER(15);
5860: l_return_value VARCHAR2(30);
5861: l_autopop_error VARCHAR2(30);
5862: l_effective_date DATE;