APPS.BIC_SUMMARY_EXTRACT_PKG dependencies on BIC_PERIODS

Line 68: -- refresh bic_periods table

64: END debug;
65: procedure extract_calendar(errbuf out NOCOPY varchar2,
66: retcode out NOCOPY number ) is
67: begin
68: -- refresh bic_periods table
69: delete from bic_periods;
70: insert into bic_periods
71: ( ACT_PERIOD_NAME ,
72: LAST_UPDATE_DATE ,

Line 69: delete from bic_periods;

65: procedure extract_calendar(errbuf out NOCOPY varchar2,
66: retcode out NOCOPY number ) is
67: begin
68: -- refresh bic_periods table
69: delete from bic_periods;
70: insert into bic_periods
71: ( ACT_PERIOD_NAME ,
72: LAST_UPDATE_DATE ,
73: CREATION_DATE ,

Line 70: insert into bic_periods

66: retcode out NOCOPY number ) is
67: begin
68: -- refresh bic_periods table
69: delete from bic_periods;
70: insert into bic_periods
71: ( ACT_PERIOD_NAME ,
72: LAST_UPDATE_DATE ,
73: CREATION_DATE ,
74: LAST_UPDATED_BY ,

Line 107: --------- Bic_periods table refreshed.

103: AND PERIOD_TYPE=FND_PROFILE.VALUE('CRMBIS:PERIOD_TYPE')
104: ;
105: commit;
106:
107: --------- Bic_periods table refreshed.
108: end;
109:
110: --------------- functions / procedures new addition-------------
111: procedure generate_error(p_measure_code varchar2 default null, msg varchar2) is