APPS.HRDPP_DELETE_EXTERNAL_EFFORT_L dependencies on HR_PUMP_BATCH_LINES

Line 87: delete from hr_pump_batch_lines where batch_line_id = blid;

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

Line 91: insert into hr_pump_batch_lines

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

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

99: ,pval001
100: ,pval002)
101: values
102: (p_batch_id
103: ,nvl(blid,hr_pump_batch_lines_s.nextval)
104: ,p_data_pump_business_grp_name
105: ,3801
106: ,'U'
107: ,p_user_sequence

Line 120: from hr_pump_batch_lines l

116: cursor cr is
117: select l.rowid myrowid,
118: decode(l.pval001,cn,nn,n(l.pval001)) p1,
119: decode(l.pval002,cn,vn,l.pval002) p2
120: from hr_pump_batch_lines l
121: where l.batch_line_id = p_batch_line_id;
122: --
123: c cr%rowtype;
124: l_validate boolean := false;

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

129: open cr;
130: fetch cr into c;
131: if cr%notfound then
132: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
133: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
134: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
135: hr_utility.set_message_token('VALUE',p_batch_line_id);
136: hr_utility.raise_error;
137: end if;

Line 155: update hr_pump_batch_lines l set

151: ,P_OBJECT_VERSION_NUMBER => c.p1);
152: hr_data_pump.api_trc_off;
153:
154: --
155: update hr_pump_batch_lines l set
156: l.pval001 = decode(c.p1,null,cn,c.p1)
157: where l.rowid = c.myrowid;
158: --
159: close cr;