DBA Data[Home] [Help]

APPS.HRDPP_DELETE_ELEMENT_ENTRY dependencies on HR_PUMP_BATCH_LINES

Line 88: delete from hr_pump_batch_lines where batch_line_id = blid;

84: ,P_ELEMENT_ENTRY_USER_KEY in varchar2) is
85: blid number := p_data_pump_batch_line_id;
86: begin
87: if blid is not null then
88: delete from hr_pump_batch_lines where batch_line_id = blid;
89: delete from hr_pump_batch_exceptions
90: where source_type = 'BATCH_LINE' and source_id = blid;
91: end if;
92: insert into hr_pump_batch_lines

Line 92: insert into hr_pump_batch_lines

88: delete from hr_pump_batch_lines where batch_line_id = blid;
89: delete from hr_pump_batch_exceptions
90: where source_type = 'BATCH_LINE' and source_id = blid;
91: end if;
92: insert into hr_pump_batch_lines
93: (batch_id
94: ,batch_line_id
95: ,business_group_name
96: ,api_module_id

Line 105: ,nvl(blid,hr_pump_batch_lines_s.nextval)

101: ,pval002
102: ,pval006)
103: values
104: (p_batch_id
105: ,nvl(blid,hr_pump_batch_lines_s.nextval)
106: ,p_data_pump_business_grp_name
107: ,1384
108: ,'U'
109: ,p_user_sequence

Line 127: from hr_pump_batch_lines l

123: decode(l.pval003,cn,dn,d(l.pval003)) p3,
124: decode(l.pval004,cn,dn,d(l.pval004)) p4,
125: l.pval005 p5,
126: decode(l.pval006,cn,vn,l.pval006) p6
127: from hr_pump_batch_lines l
128: where l.batch_line_id = p_batch_line_id;
129: --
130: c cr%rowtype;
131: l_validate boolean := false;

Line 142: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');

138: open cr;
139: fetch cr into c;
140: if cr%notfound then
141: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
142: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
143: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
144: hr_utility.set_message_token('VALUE',p_batch_line_id);
145: hr_utility.raise_error;
146: end if;

Line 184: update hr_pump_batch_lines l set

180: else
181: c.p5 := 'FALSE';
182: end if;
183: --
184: update hr_pump_batch_lines l set
185: l.pval003 = decode(c.p3,null,cn,dc(c.p3)),
186: l.pval004 = decode(c.p4,null,cn,dc(c.p4)),
187: l.pval005 = decode(c.p5,null,cn,c.p5)
188: where l.rowid = c.myrowid;