APPS.PAY_JP_DEF_SS dependencies on PAY_JP_DEF_ENTRY_DEP_V

Line 316: p_dep_rec in out nocopy pay_jp_def_entry_dep_v%rowtype,

312: -- |----------------------------< transfer_entry >-----------------------------|
313: -- |---------------------------------------------------------------------------|
314: procedure transfer_entry(
315: p_rec in out nocopy pay_jp_def_entry_v%rowtype,
316: p_dep_rec in out nocopy pay_jp_def_entry_dep_v%rowtype,
317: p_business_group_id in number)
318: is
319: c_proc constant varchar2(61) := c_package || '.transfer_entry';
320: l_esd date;

Line 456: p_dep_rec in out nocopy pay_jp_def_entry_dep_v%rowtype,

452: -- |----------------------------< rollback_entry >-----------------------------|
453: -- |---------------------------------------------------------------------------|
454: procedure rollback_entry(
455: p_rec in out nocopy pay_jp_def_entry_v%rowtype,
456: p_dep_rec in out nocopy pay_jp_def_entry_dep_v%rowtype,
457: p_business_group_id in number)
458: is
459: c_proc constant varchar2(61) := c_package || '.rollback_entry';
460: l_esd date;

Line 1791: l_entry_dep_rec pay_jp_def_entry_dep_v%rowtype;

1787: and substrb(pjsn_v.act_district_code(+),1,5) = substrb(pjal_act.district_code,1,5)
1788: and substrb(pjal_rep.district_code(+),1,5) = pjsn_v.rep_district_code;
1789: --
1790: l_entry_rec pay_jp_def_entry_v%rowtype;
1791: l_entry_dep_rec pay_jp_def_entry_dep_v%rowtype;
1792: l_entry_os_rec pay_jp_def_entry_os_v%rowtype;
1793: --
1794: l_csr_emp csr_emp%rowtype;
1795: l_csr_household_head csr_household_head%rowtype;

Line 2377: l_entry_dep_rec pay_jp_def_entry_dep_v%rowtype;

2373: --
2374: l_submission_date date;
2375: l_assact_rec pay_jp_def_assact_v%rowtype;
2376: l_entry_rec pay_jp_def_entry_v%rowtype;
2377: l_entry_dep_rec pay_jp_def_entry_dep_v%rowtype;
2378: l_entry_os_rec pay_jp_def_entry_os_v%rowtype;
2379: l_emp_rec pay_jp_def_emp_v%rowtype;
2380: --
2381: cursor csr_entry(p_assignment_action_id in number)

Line 2391: from pay_jp_def_entry_dep_v

2387: --
2388: cursor csr_entry_dep(p_assignment_action_id in number)
2389: is
2390: select *
2391: from pay_jp_def_entry_dep_v
2392: where assignment_action_id = p_assignment_action_id
2393: for update nowait;
2394: --
2395: cursor csr_entry_os(p_assignment_action_id in number)

Line 2896: l_entry_dep_rec pay_jp_def_entry_dep_v%rowtype;

2892: c_proc constant varchar2(61) := c_package || 'do_transfer';
2893: --
2894: l_assact_rec pay_jp_def_assact_v%rowtype;
2895: l_entry_rec pay_jp_def_entry_v%rowtype;
2896: l_entry_dep_rec pay_jp_def_entry_dep_v%rowtype;
2897: l_dep_rec pay_jp_def_dep_v%rowtype;
2898: l_dep_oe_rec pay_jp_def_dep_oe_v%rowtype;
2899: l_dep_os_rec pay_jp_def_dep_os_v%rowtype;
2900: --

Line 2911: from pay_jp_def_entry_dep_v

2907: --
2908: cursor csr_entry_dep(p_assignment_action_id number)
2909: is
2910: select *
2911: from pay_jp_def_entry_dep_v
2912: where assignment_action_id = p_assignment_action_id
2913: for update nowait;
2914: --
2915: cursor csr_entry_os(p_assignment_action_id number)

Line 3251: l_entry_dep_rec pay_jp_def_entry_dep_v%rowtype;

3247: c_proc constant varchar2(61) := c_package ||'rollback_transfer';
3248: --
3249: l_assact_rec pay_jp_def_assact_v%rowtype;
3250: l_entry_rec pay_jp_def_entry_v%rowtype;
3251: l_entry_dep_rec pay_jp_def_entry_dep_v%rowtype;
3252: l_entry_os_rec pay_jp_def_entry_os_v%rowtype;
3253: l_dep_rec pay_jp_def_dep_v%rowtype;
3254: l_dep_oe_rec pay_jp_def_dep_oe_v%rowtype;
3255: l_dep_os_rec pay_jp_def_dep_os_v%rowtype;

Line 3267: from pay_jp_def_entry_dep_v

3263: --
3264: cursor csr_entry_dep(p_assignment_action_id number)
3265: is
3266: select *
3267: from pay_jp_def_entry_dep_v
3268: where assignment_action_id = p_assignment_action_id
3269: for update nowait;
3270: --
3271: cursor csr_entry_os(p_assignment_action_id number)