[Home] [Help]
238: submission_start_date,
239: submission_end_date
240: from pay_jp_def_pact_v pact,
241: pay_assignment_actions paa,
242: pay_jp_def_assact_v assact
243: where assact.action_information_id = p_action_information_id
244: and paa.assignment_action_id = assact.assignment_action_id
245: and pact.payroll_action_id = paa.payroll_action_id;
246: l_pact_rec csr_pact%rowtype;
1225: -- |---------------------------------------------------------------------------|
1226: procedure lock_assact(
1227: p_action_information_id in number,
1228: p_object_version_number in number,
1229: p_rec out nocopy pay_jp_def_assact_v%rowtype)
1230: is
1231: begin
1232: select *
1233: into p_rec
1230: is
1231: begin
1232: select *
1233: into p_rec
1234: from pay_jp_def_assact_v
1235: where action_information_id = p_action_information_id
1236: for update nowait;
1237: --
1238: if p_rec.object_version_number <> p_object_version_number then
1254: p_action_information_id in number,
1255: p_object_version_number in out nocopy number)
1256: is
1257: c_proc constant varchar2(61) := c_package || 'do_new';
1258: l_assact_rec pay_jp_def_assact_v%rowtype;
1259: l_emp_rec pay_jp_def_emp_v%rowtype;
1260: l_entry_rec pay_jp_def_entry_v%rowtype;
1261: l_person_id number;
1262: l_business_group_id number;
1831: p_user_comments in varchar2)
1832: is
1833: c_proc constant varchar2(61) := c_package || 'do_finalize';
1834: l_submission_date date;
1835: l_assact_rec pay_jp_def_assact_v%rowtype;
1836: l_entry_rec pay_jp_def_entry_v%rowtype;
1837: l_emp_rec pay_jp_def_emp_v%rowtype;
1838: --
1839: cursor csr_entry(p_assignment_action_id in number) is
2012: p_object_version_number in out nocopy number,
2013: p_admin_comments in varchar2)
2014: is
2015: c_proc constant varchar2(61) := c_package || 'do_reject';
2016: l_assact_rec pay_jp_def_assact_v%rowtype;
2017: begin
2018: hr_utility.set_location('Entering : ' || c_proc, 10);
2019: --
2020: lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
2091: p_object_version_number in out nocopy number,
2092: p_admin_comments in varchar2)
2093: is
2094: c_proc constant varchar2(61) := c_package || 'do_return';
2095: l_assact_rec pay_jp_def_assact_v%rowtype;
2096: begin
2097: hr_utility.set_location('Entering : ' || c_proc, 10);
2098: --
2099: lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
2163: p_action_information_id in number,
2164: p_object_version_number in out nocopy number)
2165: is
2166: c_proc constant varchar2(61) := c_package || 'do_approve';
2167: l_assact_rec pay_jp_def_assact_v%rowtype;
2168: begin
2169: hr_utility.set_location('Entering : ' || c_proc, 10);
2170: --
2171: lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
2228: l_payroll_action_id number := fnd_number.canonical_to_number(p_payroll_action_id);
2229: cursor csr_assact is
2230: select aif.action_information_id,
2231: aif.object_version_number
2232: from pay_jp_def_assact_v aif,
2233: pay_assignment_actions paa
2234: where paa.payroll_action_id = l_payroll_action_id
2235: and paa.action_status = 'C'
2236: and aif.assignment_action_id = paa.assignment_action_id
2264: p_object_version_number in out nocopy number,
2265: p_create_session in boolean default true)
2266: is
2267: c_proc constant varchar2(61) := c_package || 'do_transfer';
2268: l_assact_rec pay_jp_def_assact_v%rowtype;
2269: l_entry_rec pay_jp_def_entry_v%rowtype;
2270: l_dep_rec pay_jp_def_dep_v%rowtype;
2271: l_dep_oe_rec pay_jp_def_dep_oe_v%rowtype;
2272: l_dep_os_rec pay_jp_def_dep_os_v%rowtype;
2470: per.full_name,
2471: asg.assignment_number
2472: from per_all_people_f per,
2473: per_all_assignments_f asg,
2474: pay_jp_def_assact_v assact,
2475: pay_assignment_actions paa
2476: where paa.payroll_action_id = l_payroll_action_id
2477: and paa.action_status = 'C'
2478: and assact.assignment_action_id = paa.assignment_action_id
2534: p_object_version_number in out nocopy number,
2535: p_create_session in boolean default true)
2536: is
2537: c_proc constant varchar2(61) := c_package || 'rollback_transfer';
2538: l_assact_rec pay_jp_def_assact_v%rowtype;
2539: l_entry_rec pay_jp_def_entry_v%rowtype;
2540: l_dep_rec pay_jp_def_dep_v%rowtype;
2541: l_dep_oe_rec pay_jp_def_dep_oe_v%rowtype;
2542: l_dep_os_rec pay_jp_def_dep_os_v%rowtype;
2731: p_object_version_number in out nocopy number,
2732: p_expiry_date in date)
2733: is
2734: c_proc constant varchar2(61) := c_package || 'do_expire';
2735: l_assact_rec pay_jp_def_assact_v%rowtype;
2736: l_year_end_date date;
2737: l_esd date;
2738: l_eed date;
2739: l_warning boolean;
2934: p_action_information_id in number,
2935: p_object_version_number in out nocopy number)
2936: is
2937: c_proc constant varchar2(61) := c_package || 'rollback_expire';
2938: l_assact_rec pay_jp_def_assact_v%rowtype;
2939: l_esd date;
2940: l_eed date;
2941: l_warning boolean;
2942: --
3138: is
3139: l_payroll_action_id number := fnd_number.canonical_to_number(p_payroll_action_id);
3140: cursor csr_assact is
3141: select paa.assignment_action_id
3142: from pay_jp_def_assact_v aif,
3143: pay_assignment_actions paa
3144: where paa.payroll_action_id = l_payroll_action_id
3145: and aif.assignment_action_id(+) = paa.assignment_action_id
3146: and nvl(aif.transaction_status, 'U') not in ('F', 'A');