DBA Data[Home] [Help]

APPS.PSP_SUM_ADJ dependencies on HR_ALL_ORGANIZATION_UNITS_TL

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

1588: AND run_id = nvl(g_run_id, run_id);
1589:
1590: gl_tie_back_rec gl_tie_back_cur%ROWTYPE;
1591:
1592: l_orig_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
1593: l_orig_org_id number;
1594:
1595: l_organization_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
1596: l_organization_id NUMBER(15);

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

1591:
1592: l_orig_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
1593: l_orig_org_id number;
1594:
1595: l_organization_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
1596: l_organization_id NUMBER(15);
1597: l_rowid ROWID;
1598: l_assignment_id NUMBER(9);
1599: l_distribution_date DATE;

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

2758: gms_interface_rec gms_interface_cursor%ROWTYPE;
2759: l_transaction_source VARCHAR2(30);
2760: l_expenditure_comment VARCHAR2(240);
2761: l_employee_number VARCHAR2(30);
2762: l_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
2763: l_segment1 VARCHAR2(25);
2764: l_task_number VARCHAR2(25);
2765: l_gms_batch_name VARCHAR2(10);
2766: l_expenditure_ending_date DATE;

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

3405: from psp_summary_lines
3406: where payroll_control_id = p_payroll_control_id
3407: and gms_batch_name = p_gms_batch_name);
3408:
3409: l_orig_org_name1 hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3410: l_orig_org_id1 number;
3411:
3412: l_organization_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3413: l_organization_id NUMBER(15);

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

3408:
3409: l_orig_org_name1 hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3410: l_orig_org_id1 number;
3411:
3412: l_organization_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3413: l_organization_id NUMBER(15);
3414: l_rowid ROWID;
3415: l_assignment_id NUMBER(9);
3416: l_distribution_date DATE;

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

3437: l_trx_reject_code VARCHAR2(30);
3438: l_orig_trx_reference VARCHAR2(30);
3439: l_effective_date DATE;
3440:
3441: x_susp_failed_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3442: x_susp_failed_reject_code VARCHAR2(30);
3443: x_susp_failed_date DATE;
3444: x_susp_nf_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3445: x_susp_nf_date DATE;

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

3440:
3441: x_susp_failed_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3442: x_susp_failed_reject_code VARCHAR2(30);
3443: x_susp_failed_date DATE;
3444: x_susp_nf_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
3445: x_susp_nf_date DATE;
3446: l_return_status VARCHAR2(10);
3447: l_msg_id number(9);
3448: x_update_count number(9);