DBA Data[Home] [Help]

APPS.PSP_SUM_ADJ dependencies on HR_ALL_ORGANIZATION_UNITS_TL

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

1695: AND run_id = nvl(g_run_id, run_id);
1696:
1697: gl_tie_back_rec gl_tie_back_cur%ROWTYPE;
1698:
1699: l_orig_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
1700: l_orig_org_id number;
1701:
1702: l_organization_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
1703: l_organization_id NUMBER(15);

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

1698:
1699: l_orig_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
1700: l_orig_org_id number;
1701:
1702: l_organization_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
1703: l_organization_id NUMBER(15);
1704: l_rowid ROWID;
1705: l_assignment_id NUMBER(9);
1706: l_distribution_date DATE;

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

2895: gms_interface_rec gms_interface_cursor%ROWTYPE;
2896: l_transaction_source VARCHAR2(30);
2897: l_expenditure_comment VARCHAR2(240);
2898: l_employee_number VARCHAR2(30);
2899: l_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
2900: l_segment1 VARCHAR2(25);
2901: l_task_number VARCHAR2(300); -- Bug 16391366 (27/03/2013)
2902: l_gms_batch_name VARCHAR2(10);
2903:

Line 3768: l_orig_org_name1 hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration

3764: from psp_summary_lines
3765: where payroll_control_id = p_payroll_control_id
3766: and gms_batch_name = p_gms_batch_name);
3767:
3768: l_orig_org_name1 hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3769: l_orig_org_id1 number;
3770:
3771: l_organization_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3772: l_organization_id NUMBER(15);

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

3767:
3768: l_orig_org_name1 hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3769: l_orig_org_id1 number;
3770:
3771: l_organization_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3772: l_organization_id NUMBER(15);
3773: l_rowid ROWID;
3774: l_assignment_id NUMBER(9);
3775: l_distribution_date DATE;

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

3796: l_trx_reject_code VARCHAR2(30);
3797: l_orig_trx_reference VARCHAR2(30);
3798: l_effective_date DATE;
3799:
3800: x_susp_failed_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3801: x_susp_failed_reject_code VARCHAR2(30);
3802: x_susp_failed_date DATE;
3803: x_susp_nf_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3804: x_susp_nf_date DATE;

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

3799:
3800: x_susp_failed_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3801: x_susp_failed_reject_code VARCHAR2(30);
3802: x_susp_failed_date DATE;
3803: x_susp_nf_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3804: x_susp_nf_date DATE;
3805: l_return_status VARCHAR2(10);
3806: l_msg_id number(9);
3807: x_update_count number(9);