APPS.PAY_ROLL_ACTS_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 5: delete from pay_payroll_actions

1: package body pay_roll_acts_pkg as
2: /* $Header: pypra01t.pkb 120.0.12020000.2 2012/07/05 02:25:33 amnaraya ship $ */
3: procedure delete_row ( p_rowid varchar2) is
4: begin
5: delete from pay_payroll_actions
6: where rowid = p_rowid;
7: end delete_row;
8:
9: procedure insert_row ( p_rowid IN out nocopy varchar2,

Line 40: select pay_payroll_actions_s.nextval

36: p_attribute17 varchar2, p_attribute18 varchar2,
37: p_attribute19 varchar2, p_attribute20 varchar2 ) is
38:
39: cursor c1 is
40: select pay_payroll_actions_s.nextval
41: from sys.dual;
42:
43: cursor c2 is
44: select rowid

Line 45: from pay_payroll_actions

41: from sys.dual;
42:
43: cursor c2 is
44: select rowid
45: from pay_payroll_actions
46: where payroll_action_id = p_payroll_action_id;
47:
48: begin
49:

Line 54: insert into pay_payroll_actions ( payroll_action_id,

50: open c1;
51: fetch c1 into p_payroll_action_id;
52: close c1;
53:
54: insert into pay_payroll_actions ( payroll_action_id,
55: action_type,
56: business_group_id,
57: consolidation_set_id,
58: payroll_id,

Line 149: from pay_payroll_actions

145: p_attribute19 varchar2, p_attribute20 varchar2 ) is
146:
147: cursor c is
148: select *
149: from pay_payroll_actions
150: where rowid = p_rowid for update of payroll_action_id nowait;
151: c_rec c%rowtype;
152:
153: begin

Line 313: update pay_payroll_actions

309: p_attribute15 varchar2, p_attribute16 varchar2,
310: p_attribute17 varchar2, p_attribute18 varchar2,
311: p_attribute19 varchar2, p_attribute20 varchar2 ) is
312: begin
313: update pay_payroll_actions
314: set payroll_action_id = p_payroll_action_id,
315: action_type = p_action_type,
316: business_group_id = p_business_group_id,
317: consolidation_set_id = p_consolidation_set_id,