APPS.FV_REIMB_ACTIVITY_PROCESS dependencies on FV_REIMB_ACTIVITY_TEMP

Line 189: log(C_STATE_LEVEL, l_module, 'Deleting any previous records from FV_REIMB_ACTIVITY_TEMP .....');

185:
186: -- Delete all data from previous run. And populate it afresh.
187:
188: IF g_retcode = 0 THEN
189: log(C_STATE_LEVEL, l_module, 'Deleting any previous records from FV_REIMB_ACTIVITY_TEMP .....');
190: END IF;
191:
192: DELETE FROM FV_REIMB_ACTIVITY_TEMP;
193:

Line 192: DELETE FROM FV_REIMB_ACTIVITY_TEMP;

188: IF g_retcode = 0 THEN
189: log(C_STATE_LEVEL, l_module, 'Deleting any previous records from FV_REIMB_ACTIVITY_TEMP .....');
190: END IF;
191:
192: DELETE FROM FV_REIMB_ACTIVITY_TEMP;
193:
194:
195: --Check for Reimb Agreement segment values in the flexfield low and high range
196: --If it is not null then assign v_low_reimb_agree and v_high_reimb_agree

Line 228: INSERT INTO FV_REIMB_ACTIVITY_TEMP(Reimb_Agreement_Num,

224: --Bug8741007
225: END LOOP;
226: CLOSE agree_cur;
227:
228: INSERT INTO FV_REIMB_ACTIVITY_TEMP(Reimb_Agreement_Num,
229: Contract_Number,
230: Billing_Limit,
231: start_date,
232: end_date,

Line 335: FROM FV_REIMB_ACTIVITY_TEMP

331: segment28,
332: segment29,
333: segment30,
334: 'Y'
335: FROM FV_REIMB_ACTIVITY_TEMP
336: WHERE reported_flag = 'N'
337: GROUP BY
338: Reimb_Agreement_Num,
339: Contract_Number,

Line 395: DELETE FROM FV_REIMB_ACTIVITY_TEMP WHERE reported_flag = 'N';

391: --Bug8741007
392: --END LOOP;
393: --CLOSE agree_cur;
394:
395: DELETE FROM FV_REIMB_ACTIVITY_TEMP WHERE reported_flag = 'N';
396:
397: -- Submit the RXi Report
398: BEGIN
399: SELECT count(*)

Line 401: FROM FV_REIMB_ACTIVITY_TEMP;

397: -- Submit the RXi Report
398: BEGIN
399: SELECT count(*)
400: INTO l_rec_count
401: FROM FV_REIMB_ACTIVITY_TEMP;
402:
403: IF l_rec_count >0 THEN
404: l_req_id :=
405: FND_REQUEST.SUBMIT_REQUEST ('FV','RXFVRACR','','',FALSE,

Line 761: l_activity_rec FV_REIMB_ACTIVITY_TEMP%ROWTYPE;

757: l_amount VARCHAR2(50);
758: l_select_mod VARCHAR2(2000);
759: l_exec_ret INTEGER ;
760: l_count NUMBER(2);
761: l_activity_rec FV_REIMB_ACTIVITY_TEMP%ROWTYPE;
762: l_temp_segnumber VARCHAR2(10);
763: l_natural_balance_type VARCHAR2(10);
764: l_segment1 VARCHAR2(30);
765: l_segment2 VARCHAR2(30);

Line 1266: log(C_STATE_LEVEL, l_module, 'Inserting values to FV_REIMB_ACTIVITY_TEMP with reported_flag = N ');

1262: WHEN 11 THEN l_activity_rec.amount_receivable_balance := l_amount;
1263: END CASE;
1264:
1265: log(C_STATE_LEVEL, l_module, '************************************************');
1266: log(C_STATE_LEVEL, l_module, 'Inserting values to FV_REIMB_ACTIVITY_TEMP with reported_flag = N ');
1267: log(C_STATE_LEVEL, l_module, 'Reimb_Agreement_Num: '||l_trx_number);
1268: log(C_STATE_LEVEL, l_module, 'amount_obligation: '||nvl(l_activity_rec.amount_obligation,0));
1269: log(C_STATE_LEVEL, l_module, 'amount_expended: '||nvl(l_activity_rec.amount_expended,0));
1270: log(C_STATE_LEVEL, l_module, 'amount_unfilled_order: '||nvl(l_activity_rec.amount_unfilled_order,0));

Line 1311: INSERT INTO FV_REIMB_ACTIVITY_TEMP (Reimb_Agreement_Num,

1307: log(C_STATE_LEVEL, l_module, 'segment29: '||l_activity_rec.segment29);
1308: log(C_STATE_LEVEL, l_module, 'segment30: '||l_activity_rec.segment30);
1309: log(C_STATE_LEVEL, l_module, '************************************************');
1310:
1311: INSERT INTO FV_REIMB_ACTIVITY_TEMP (Reimb_Agreement_Num,
1312: Contract_Number,
1313: Billing_Limit,
1314: start_date,
1315: end_date,