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);
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;
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:
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);
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;
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;
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);