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

Line 2767: FROM hr_all_organization_units hou, psp_organization_accounts poa

2763: -- Get the Organization details ...
2764:
2765: CURSOR get_susp_org_cur(P_ORG_ID IN VARCHAR2) IS
2766: SELECT hou.organization_id, hou.name, poa.gl_code_combination_id
2767: FROM hr_all_organization_units hou, psp_organization_accounts poa
2768: WHERE hou.organization_id = poa.organization_id
2769: AND poa.business_group_id = p_business_group_id
2770: AND poa.set_of_books_id = p_set_of_books_id
2771: AND poa.organization_account_id = p_org_id;

Line 2775: FROM hr_all_organization_units hou,

2771: AND poa.organization_account_id = p_org_id;
2772: / *
2773: CURSOR get_org_id_cur(P_LINE_ID IN NUMBER) IS
2774: SELECT hou.organization_id, hou.name
2775: FROM hr_all_organization_units hou,
2776: per_assignments_f paf,
2777: psp_enc_lines pel
2778: WHERE pel.enc_summary_line_id = p_line_id
2779: AND pel.assignment_id = paf.assignment_id

Line 2789: FROM hr_all_organization_units hou,

2785:
2786:
2787: CURSOR get_org_id_cur(P_ROWID IN ROWID) IS
2788: SELECT hou.organization_id, hou.name
2789: FROM hr_all_organization_units hou,
2790: per_assignments_f paf,
2791: psp_enc_lines pel
2792: WHERE
2793: -- pel.enc_summary_line_id = p_line_id

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 3393: FROM hr_all_organization_units hou,

3389: ORDER BY 5, 6, 7, 8, 3;
3390:
3391: CURSOR get_susp_org_cur(P_ORG_ID IN VARCHAR2) IS
3392: SELECT hou.organization_id, hou.name, poa.gl_code_combination_id
3393: FROM hr_all_organization_units hou,
3394: psp_organization_accounts poa
3395: WHERE hou.organization_id = poa.organization_id
3396: AND poa.business_group_id = p_business_group_id
3397: AND poa.set_of_books_id = p_set_of_books_id

Line 3402: FROM hr_all_organization_units hou,

3398: AND poa.organization_account_id = p_org_id;
3399:
3400: CURSOR get_org_id_cur(P_ROWID IN ROWID) IS
3401: SELECT hou.organization_id, hou.name
3402: FROM hr_all_organization_units hou,
3403: per_assignments_f paf,
3404: psp_enc_lines pel
3405: WHERE pel.rowid=p_rowid
3406: AND pel.assignment_id = paf.assignment_id

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 5259: FROM hr_all_organization_units hou, psp_organization_accounts poa

5255: -- Get the Organization details ...
5256:
5257: CURSOR get_susp_org_cur(P_ORG_ID IN VARCHAR2) IS
5258: SELECT hou.organization_id, hou.name
5259: FROM hr_all_organization_units hou, psp_organization_accounts poa
5260: WHERE hou.organization_id = poa.organization_id
5261: AND poa.business_group_id = p_business_group_id
5262: AND poa.set_of_books_id = p_set_of_books_id
5263: AND poa.organization_account_id = p_org_id;

Line 5267: FROM hr_all_organization_units hou,

5263: AND poa.organization_account_id = p_org_id;
5264: / *
5265: CURSOR get_org_id_cur(P_LINE_ID IN NUMBER) IS
5266: SELECT hou.organization_id, hou.name
5267: FROM hr_all_organization_units hou,
5268: per_assignments_f paf,
5269: psp_enc_lines pel
5270: WHERE pel.enc_summary_line_id = p_line_id
5271: AND pel.assignment_id = paf.assignment_id

Line 5281: FROM hr_all_organization_units hou,

5277: * /
5278:
5279: CURSOR get_org_id_cur(P_ROWID IN ROWID) IS
5280: SELECT hou.organization_id, hou.name
5281: FROM hr_all_organization_units hou,
5282: per_assignments_f paf,
5283: psp_enc_lines pel
5284: WHERE
5285: -- pel.enc_summary_line_id = p_line_id

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 5967: FROM hr_all_organization_units hou,

5963: ORDER BY 5, 6, 7, 8, 9, 10, 11, 12, 3;
5964:
5965: CURSOR get_susp_org_cur(P_ORG_ID IN VARCHAR2) IS
5966: SELECT hou.organization_id, hou.name, poa.gl_code_combination_id
5967: FROM hr_all_organization_units hou,
5968: psp_organization_accounts poa
5969: WHERE hou.organization_id = poa.organization_id
5970: AND poa.business_group_id = p_business_group_id
5971: AND poa.set_of_books_id = p_set_of_books_id

Line 5976: FROM hr_all_organization_units hou,

5972: AND poa.organization_account_id = p_org_id;
5973:
5974: CURSOR get_org_id_cur(P_ROWID IN ROWID) IS
5975: SELECT hou.organization_id, hou.name
5976: FROM hr_all_organization_units hou,
5977: per_assignments_f paf,
5978: psp_enc_lines pel
5979: WHERE pel.rowid=p_rowid
5980: AND pel.assignment_id = paf.assignment_id

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;