APPS.PAY_USER_COLUMN_INSTANCES_PKG dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 22: from pay_user_column_instances_f

18: from sys.dual ;
19:
20: cursor c2 is
21: select rowid
22: from pay_user_column_instances_f
23: where user_column_instance_id = p_user_column_instance_id ;
24: --
25: begin
26: --

Line 31: insert into PAY_USER_COLUMN_INSTANCES_F

27: open c1 ;
28: fetch c1 into p_user_column_instance_id ;
29: close c1 ;
30:
31: insert into PAY_USER_COLUMN_INSTANCES_F
32: ( USER_COLUMN_INSTANCE_ID,
33: EFFECTIVE_START_DATE,
34: EFFECTIVE_END_DATE,
35: USER_ROW_ID,

Line 70: update PAY_USER_COLUMN_INSTANCES_F

66: p_legislation_subgroup in varchar2,
67: p_value in varchar2 ) is
68: begin
69: --
70: update PAY_USER_COLUMN_INSTANCES_F
71: set USER_COLUMN_INSTANCE_ID = p_user_column_instance_id,
72: EFFECTIVE_START_DATE = p_effective_start_date ,
73: EFFECTIVE_END_DATE = p_effective_end_date ,
74: USER_ROW_ID = p_user_row_id,

Line 88: delete from PAY_USER_COLUMN_INSTANCES_F

84: procedure delete_row(p_rowid in varchar2) is
85: --
86: begin
87: --
88: delete from PAY_USER_COLUMN_INSTANCES_F
89: where ROWID = p_rowid;
90: --
91: end delete_row;
92: --

Line 105: from PAY_USER_COLUMN_INSTANCES_F

101: p_legislation_subgroup in varchar2,
102: p_value in varchar2 ) is
103: --
104: cursor C is select *
105: from PAY_USER_COLUMN_INSTANCES_F
106: where rowid = p_rowid
107: for update of USER_COLUMN_INSTANCE_ID NOWAIT ;
108: --
109: rowinfo C%rowtype;