APPS.MSC_HP_UTIL dependencies on MSC_HP_COL_DTLS

Line 36: delete from msc_hp_col_dtls where plan_id=p_plan_id;

32: return;
33: end if;
34:
35: if (p_refresh = 1) then
36: delete from msc_hp_col_dtls where plan_id=p_plan_id;
37: msc_phub_util.log('delete from msc_hp_col_dtls: '||sql%rowcount);
38: commit;
39: else
40: select count(*) into l_n

Line 37: msc_phub_util.log('delete from msc_hp_col_dtls: '||sql%rowcount);

33: end if;
34:
35: if (p_refresh = 1) then
36: delete from msc_hp_col_dtls where plan_id=p_plan_id;
37: msc_phub_util.log('delete from msc_hp_col_dtls: '||sql%rowcount);
38: commit;
39: else
40: select count(*) into l_n
41: from msc_hp_col_dtls

Line 41: from msc_hp_col_dtls

37: msc_phub_util.log('delete from msc_hp_col_dtls: '||sql%rowcount);
38: commit;
39: else
40: select count(*) into l_n
41: from msc_hp_col_dtls
42: where plan_id=p_plan_id;
43:
44: if (l_n > 0) then
45: return;

Line 49: insert into msc_hp_col_dtls(

45: return;
46: end if;
47: end if;
48:
49: insert into msc_hp_col_dtls(
50: plan_id,
51: bkt_start_date,
52: bkt_end_date,
53: seq_num,

Line 185: msc_phub_util.log('insert into msc_hp_col_dtls: '||sql%rowcount);

181: fnd_global.user_id, sysdate,
182: sysdate, fnd_global.user_id, fnd_global.login_id
183: from m
184: order by bucket_index;
185: msc_phub_util.log('insert into msc_hp_col_dtls: '||sql%rowcount);
186: commit;
187:
188: end prepare_col_dtls;
189:

Line 268: delete from msc_hp_col_dtls where plan_id=p_plan_id;

264: delete from msc_hp_row_dtls where plan_id=p_plan_id;
265: msc_phub_util.log('delete from msc_hp_row_dtls: '||sql%rowcount);
266: commit;
267:
268: delete from msc_hp_col_dtls where plan_id=p_plan_id;
269: msc_phub_util.log('delete from msc_hp_col_dtls: '||sql%rowcount);
270: commit;
271:
272: if (p_mode = sync_launch) then

Line 269: msc_phub_util.log('delete from msc_hp_col_dtls: '||sql%rowcount);

265: msc_phub_util.log('delete from msc_hp_row_dtls: '||sql%rowcount);
266: commit;
267:
268: delete from msc_hp_col_dtls where plan_id=p_plan_id;
269: msc_phub_util.log('delete from msc_hp_col_dtls: '||sql%rowcount);
270: commit;
271:
272: if (p_mode = sync_launch) then
273: prepare_col_dtls(p_plan_id, 1);