APPS.FII_GL_JE_B_C dependencies on BIS_COLLECTION_UTILITIES

Line 111: g_phase := 'Calling BIS_COLLECTION_UTILITIES.WriteMissingRateHeader to write out report header';

107: FII_UTIL.put_line('Calling procedure: REPORT_MISSING_RATES');
108: FII_UTIL.put_line('');
109: end if;
110:
111: g_phase := 'Calling BIS_COLLECTION_UTILITIES.WriteMissingRateHeader to write out report header';
112: if g_debug_flag = 'Y' then
113: FII_UTIL.put_line(g_phase);
114: FII_UTIL.put_line('');
115: end if;

Line 117: BIS_COLLECTION_UTILITIES.WriteMissingRateHeader;

113: FII_UTIL.put_line(g_phase);
114: FII_UTIL.put_line('');
115: end if;
116:
117: BIS_COLLECTION_UTILITIES.WriteMissingRateHeader;
118:
119: g_phase := 'Calling BIS_COLLECTION_UTILITIES.WriteMissingRate to write out report contents';
120: if g_debug_flag = 'Y' then
121: FII_UTIL.put_line(g_phase);

Line 119: g_phase := 'Calling BIS_COLLECTION_UTILITIES.WriteMissingRate to write out report contents';

115: end if;
116:
117: BIS_COLLECTION_UTILITIES.WriteMissingRateHeader;
118:
119: g_phase := 'Calling BIS_COLLECTION_UTILITIES.WriteMissingRate to write out report contents';
120: if g_debug_flag = 'Y' then
121: FII_UTIL.put_line(g_phase);
122: FII_UTIL.put_line('');
123: end if;

Line 127: BIS_COLLECTION_UTILITIES.writemissingrate(

123: end if;
124:
125: /*
126: FOR rate_record in PrimMissingRate LOOP
127: BIS_COLLECTION_UTILITIES.writemissingrate(
128: g_prim_rate_type_name,
129: rate_record.functional_currency,
130: g_prim_currency,
131: rate_record.effective_date);

Line 135: BIS_COLLECTION_UTILITIES.writemissingrate(

131: rate_record.effective_date);
132: END LOOP;
133:
134: FOR rate_record in SecMissingRate LOOP
135: BIS_COLLECTION_UTILITIES.writemissingrate(
136: g_sec_rate_type_name,
137: rate_record.functional_currency,
138: g_sec_currency,
139: rate_record.effective_date);

Line 145: BIS_COLLECTION_UTILITIES.writemissingrate(

141: */
142: FOR rate_record in PSMissingRate LOOP
143:
144: IF rate_record.prim_effective_date IS NOT NULL THEN
145: BIS_COLLECTION_UTILITIES.writemissingrate(
146: g_prim_rate_type_name,
147: rate_record.functional_currency,
148: g_prim_currency,
149: rate_record.prim_effective_date);

Line 153: BIS_COLLECTION_UTILITIES.writemissingrate(

149: rate_record.prim_effective_date);
150: END IF;
151:
152: IF rate_record.sec_effective_date IS NOT NULL THEN
153: BIS_COLLECTION_UTILITIES.writemissingrate(
154: g_sec_rate_type_name,
155: rate_record.functional_currency,
156: g_sec_currency,
157: rate_record.sec_effective_date);

Line 220: g_phase := 'Calling BIS_COLLECTION_UTILITIES.WriteMissingRateHeader to write out report header';

216: FII_UTIL.put_line('Calling procedure: REPORT_MISSING_RATES');
217: FII_UTIL.put_line('');
218: end if;
219:
220: g_phase := 'Calling BIS_COLLECTION_UTILITIES.WriteMissingRateHeader to write out report header';
221: if g_debug_flag = 'Y' then
222: FII_UTIL.put_line(g_phase);
223: FII_UTIL.put_line('');
224: end if;

Line 226: BIS_COLLECTION_UTILITIES.WriteMissingRateHeader;

222: FII_UTIL.put_line(g_phase);
223: FII_UTIL.put_line('');
224: end if;
225:
226: BIS_COLLECTION_UTILITIES.WriteMissingRateHeader;
227:
228: g_phase := 'Calling BIS_COLLECTION_UTILITIES.WriteMissingRate to write out report contents';
229: if g_debug_flag = 'Y' then
230: FII_UTIL.put_line(g_phase);

Line 228: g_phase := 'Calling BIS_COLLECTION_UTILITIES.WriteMissingRate to write out report contents';

224: end if;
225:
226: BIS_COLLECTION_UTILITIES.WriteMissingRateHeader;
227:
228: g_phase := 'Calling BIS_COLLECTION_UTILITIES.WriteMissingRate to write out report contents';
229: if g_debug_flag = 'Y' then
230: FII_UTIL.put_line(g_phase);
231: FII_UTIL.put_line('');
232: end if;

Line 235: BIS_COLLECTION_UTILITIES.writemissingrate(

231: FII_UTIL.put_line('');
232: end if;
233:
234: FOR rate_record in PrimMissingRate LOOP
235: BIS_COLLECTION_UTILITIES.writemissingrate(
236: g_prim_rate_type_name,
237: rate_record.functional_currency,
238: g_prim_currency,
239: rate_record.trx_date);

Line 243: BIS_COLLECTION_UTILITIES.writemissingrate(

239: rate_record.trx_date);
240: END LOOP;
241:
242: FOR rate_record in SecMissingRate LOOP
243: BIS_COLLECTION_UTILITIES.writemissingrate(
244: g_sec_rate_type_name,
245: rate_record.functional_currency,
246: g_sec_currency,
247: rate_record.trx_date);

Line 3310: IF (NOT BIS_COLLECTION_UTILITIES.setup('FII_GL_JE_B_C')) THEN

3306: );
3307:
3308: return;
3309: ELSIF p_program_type = 'I' THEN
3310: IF (NOT BIS_COLLECTION_UTILITIES.setup('FII_GL_JE_B_C')) THEN
3311: raise_application_error(-20000,errbuf);
3312: return;
3313: END IF;
3314: ELSIF p_program_type = 'L' THEN

Line 3315: IF (NOT BIS_COLLECTION_UTILITIES.setup('FII_GL_JE_B_L')) THEN

3311: raise_application_error(-20000,errbuf);
3312: return;
3313: END IF;
3314: ELSIF p_program_type = 'L' THEN
3315: IF (NOT BIS_COLLECTION_UTILITIES.setup('FII_GL_JE_B_L')) THEN
3316: raise_application_error(-20000,errbuf);
3317: return;
3318: END IF;
3319: END IF;

Line 3424: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_GL_JE_B_C',

3420: -----------------------------------------------------------------
3421: -- When running in Incremental mode, the values of the parameters
3422: -- are derived in the program
3423: -----------------------------------------------------------------
3424: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_GL_JE_B_C',
3425: l_last_start_date,
3426: l_last_end_date,
3427: l_last_period_from,
3428: l_last_period_to);

Line 3902: BIS_COLLECTION_UTILITIES.wrapup(p_status => TRUE,

3898: ----------------------------------------------------------------
3899: -- Calling BIS API to record the range we collect. Only do this
3900: -- when we have a successful collection
3901: ----------------------------------------------------------------
3902: BIS_COLLECTION_UTILITIES.wrapup(p_status => TRUE,
3903: p_period_from => l_period_start_date,
3904: p_period_to => l_period_end_date);
3905:
3906: IF (l_ret_code = 'N') THEN