248: l_sub_retcode NUMBER := 0; -- Added for 1336492.
249:
250: BEGIN
251:
252: -- xtr_debug_pkg.enable_file_debug; -- RV 2293339 issue# 8
253: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
254: xtr_debug_pkg.debug ('Do_Journal_Process: ' || '>> Do Journal Process.');
255: END IF;
256:
249:
250: BEGIN
251:
252: -- xtr_debug_pkg.enable_file_debug; -- RV 2293339 issue# 8
253: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
254: xtr_debug_pkg.debug ('Do_Journal_Process: ' || '>> Do Journal Process.');
255: END IF;
256:
257: If (p_source_option is null) then
250: BEGIN
251:
252: -- xtr_debug_pkg.enable_file_debug; -- RV 2293339 issue# 8
253: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
254: xtr_debug_pkg.debug ('Do_Journal_Process: ' || '>> Do Journal Process.');
255: END IF;
256:
257: If (p_source_option is null) then
258:
275: Open BATCH_PERIOD;
276: Fetch BATCH_PERIOD into p_period_start, p_period_end, p_upgrade_batch;
277: Close BATCH_PERIOD;
278:
279: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
280: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_company_code = ' || p_company_code);
281: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_curr_batch_id = ' || p_curr_batch_id);
282: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_period_start = ' || p_period_start);
283: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_period_end = ' || p_period_end);
276: Fetch BATCH_PERIOD into p_period_start, p_period_end, p_upgrade_batch;
277: Close BATCH_PERIOD;
278:
279: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
280: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_company_code = ' || p_company_code);
281: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_curr_batch_id = ' || p_curr_batch_id);
282: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_period_start = ' || p_period_start);
283: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_period_end = ' || p_period_end);
284: END IF;
277: Close BATCH_PERIOD;
278:
279: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
280: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_company_code = ' || p_company_code);
281: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_curr_batch_id = ' || p_curr_batch_id);
282: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_period_start = ' || p_period_start);
283: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_period_end = ' || p_period_end);
284: END IF;
285:
278:
279: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
280: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_company_code = ' || p_company_code);
281: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_curr_batch_id = ' || p_curr_batch_id);
282: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_period_start = ' || p_period_start);
283: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_period_end = ' || p_period_end);
284: END IF;
285:
286: -- Issue warning if journals have already been generated for the current batch id.
279: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
280: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_company_code = ' || p_company_code);
281: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_curr_batch_id = ' || p_curr_batch_id);
282: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_period_start = ' || p_period_start);
283: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_period_end = ' || p_period_end);
284: END IF;
285:
286: -- Issue warning if journals have already been generated for the current batch id.
287: -- Proceed to next batch id in range.
342: Open FIND_USER(fnd_user_id);
343: Fetch FIND_USER into G_user;
344: Close FIND_USER;
345:
346: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
347: xtr_debug_pkg.debug ('Do_Journal_Process: ' || 'FND_GLOBAL.user_id = ' || to_char(fnd_user_id));
348: END IF;
349: --
350: -- Set sob info.
343: Fetch FIND_USER into G_user;
344: Close FIND_USER;
345:
346: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
347: xtr_debug_pkg.debug ('Do_Journal_Process: ' || 'FND_GLOBAL.user_id = ' || to_char(fnd_user_id));
348: END IF;
349: --
350: -- Set sob info.
351: --
373: else
374: l_retcode := greatest(l_retcode,g_gen_journal_retcode);
375: End If;
376: */
377: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
378: xtr_debug_pkg.debug ('Do_Journal_Process: ' || '<< Do Journal Process.');
379: END IF;
380: -- xtr_debug_pkg.disable_file_debug; -- RV 2293339 issue# 8
381:
374: l_retcode := greatest(l_retcode,g_gen_journal_retcode);
375: End If;
376: */
377: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
378: xtr_debug_pkg.debug ('Do_Journal_Process: ' || '<< Do Journal Process.');
379: END IF;
380: -- xtr_debug_pkg.disable_file_debug; -- RV 2293339 issue# 8
381:
382: End If; -- (NOT l_warn_flag)
376: */
377: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
378: xtr_debug_pkg.debug ('Do_Journal_Process: ' || '<< Do Journal Process.');
379: END IF;
380: -- xtr_debug_pkg.disable_file_debug; -- RV 2293339 issue# 8
381:
382: End If; -- (NOT l_warn_flag)
383:
384: -- Added for flex journals. 2404342. ekl
423: Open FIND_USER(fnd_user_id);
424: Fetch FIND_USER into G_user;
425: Close FIND_USER;
426:
427: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
428: xtr_debug_pkg.debug ('Do_Journal_Process: ' || 'FND_GLOBAL.user_id = ' || to_char(fnd_user_id));
429: END IF;
430: --
431: -- Set sob info.
424: Fetch FIND_USER into G_user;
425: Close FIND_USER;
426:
427: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
428: xtr_debug_pkg.debug ('Do_Journal_Process: ' || 'FND_GLOBAL.user_id = ' || to_char(fnd_user_id));
429: END IF;
430: --
431: -- Set sob info.
432: --
1278:
1279: -- End 1336492 additions.
1280:
1281: begin
1282: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1283: xtr_debug_pkg.debug('GEN_JOURNALS: ' || '>> Gen Journals.');
1284: END IF;
1285:
1286: -- Begin 1336492 additions.
1279: -- End 1336492 additions.
1280:
1281: begin
1282: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1283: xtr_debug_pkg.debug('GEN_JOURNALS: ' || '>> Gen Journals.');
1284: END IF;
1285:
1286: -- Begin 1336492 additions.
1287:
1312:
1313: ----------------------------------------------------------
1314: -- Start processing Q2 for all deal types except 'EXP'.
1315: ----------------------------------------------------------
1316: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1317: xtr_debug_pkg.debug('GEN_JOURNALS: ' || 'Opening Q2');
1318: END IF;
1319:
1320: Open Q2;
1313: ----------------------------------------------------------
1314: -- Start processing Q2 for all deal types except 'EXP'.
1315: ----------------------------------------------------------
1316: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1317: xtr_debug_pkg.debug('GEN_JOURNALS: ' || 'Opening Q2');
1318: END IF;
1319:
1320: Open Q2;
1321: Fetch Q2 INTO Q2_REC;
1326: l_prev_transaction_nbr := Q2_REC.transaction_number;
1327: l_prev_date_type := Q2_REC.date_type;
1328: l_prev_amount_date := Q2_REC.amount_date;
1329:
1330: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1331: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Entering Q2 loop.');
1332: END IF;
1333:
1334: WHILE Q2%FOUND LOOP
1327: l_prev_date_type := Q2_REC.date_type;
1328: l_prev_amount_date := Q2_REC.amount_date;
1329:
1330: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1331: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Entering Q2 loop.');
1332: END IF;
1333:
1334: WHILE Q2%FOUND LOOP
1335:
1332: END IF;
1333:
1334: WHILE Q2%FOUND LOOP
1335:
1336: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1337: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q2_REC.company_code);
1338: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q2_REC.deal_type);
1339: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q2_REC.deal_number));
1340: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q2_REC.transaction_number));
1333:
1334: WHILE Q2%FOUND LOOP
1335:
1336: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1337: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q2_REC.company_code);
1338: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q2_REC.deal_type);
1339: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q2_REC.deal_number));
1340: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q2_REC.transaction_number));
1341: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q2_REC.amount_date,'MM/DD/RRRR'));
1334: WHILE Q2%FOUND LOOP
1335:
1336: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1337: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q2_REC.company_code);
1338: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q2_REC.deal_type);
1339: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q2_REC.deal_number));
1340: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q2_REC.transaction_number));
1341: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q2_REC.amount_date,'MM/DD/RRRR'));
1342: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q2_REC.currency);
1335:
1336: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1337: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q2_REC.company_code);
1338: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q2_REC.deal_type);
1339: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q2_REC.deal_number));
1340: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q2_REC.transaction_number));
1341: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q2_REC.amount_date,'MM/DD/RRRR'));
1342: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q2_REC.currency);
1343: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q2_REC.deal_subtype);
1336: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1337: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q2_REC.company_code);
1338: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q2_REC.deal_type);
1339: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q2_REC.deal_number));
1340: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q2_REC.transaction_number));
1341: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q2_REC.amount_date,'MM/DD/RRRR'));
1342: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q2_REC.currency);
1343: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q2_REC.deal_subtype);
1344: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q2_REC.product_type);
1337: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q2_REC.company_code);
1338: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q2_REC.deal_type);
1339: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q2_REC.deal_number));
1340: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q2_REC.transaction_number));
1341: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q2_REC.amount_date,'MM/DD/RRRR'));
1342: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q2_REC.currency);
1343: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q2_REC.deal_subtype);
1344: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q2_REC.product_type);
1345: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q2_REC.portfolio_code);
1338: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q2_REC.deal_type);
1339: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q2_REC.deal_number));
1340: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q2_REC.transaction_number));
1341: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q2_REC.amount_date,'MM/DD/RRRR'));
1342: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q2_REC.currency);
1343: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q2_REC.deal_subtype);
1344: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q2_REC.product_type);
1345: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q2_REC.portfolio_code);
1346: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q2_REC.date_type);
1339: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q2_REC.deal_number));
1340: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q2_REC.transaction_number));
1341: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q2_REC.amount_date,'MM/DD/RRRR'));
1342: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q2_REC.currency);
1343: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q2_REC.deal_subtype);
1344: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q2_REC.product_type);
1345: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q2_REC.portfolio_code);
1346: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q2_REC.date_type);
1347: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q2_REC.amount_type);
1340: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q2_REC.transaction_number));
1341: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q2_REC.amount_date,'MM/DD/RRRR'));
1342: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q2_REC.currency);
1343: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q2_REC.deal_subtype);
1344: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q2_REC.product_type);
1345: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q2_REC.portfolio_code);
1346: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q2_REC.date_type);
1347: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q2_REC.amount_type);
1348: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q2_REC.dr_amount));
1341: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q2_REC.amount_date,'MM/DD/RRRR'));
1342: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q2_REC.currency);
1343: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q2_REC.deal_subtype);
1344: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q2_REC.product_type);
1345: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q2_REC.portfolio_code);
1346: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q2_REC.date_type);
1347: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q2_REC.amount_type);
1348: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q2_REC.dr_amount));
1349: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q2_REC.cr_amount));
1342: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q2_REC.currency);
1343: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q2_REC.deal_subtype);
1344: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q2_REC.product_type);
1345: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q2_REC.portfolio_code);
1346: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q2_REC.date_type);
1347: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q2_REC.amount_type);
1348: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q2_REC.dr_amount));
1349: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q2_REC.cr_amount));
1350: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q2_REC.ccid));
1343: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q2_REC.deal_subtype);
1344: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q2_REC.product_type);
1345: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q2_REC.portfolio_code);
1346: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q2_REC.date_type);
1347: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q2_REC.amount_type);
1348: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q2_REC.dr_amount));
1349: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q2_REC.cr_amount));
1350: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q2_REC.ccid));
1351: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Client Clr Acct = ' || Q2_REC.client_broker_clracct);
1344: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q2_REC.product_type);
1345: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q2_REC.portfolio_code);
1346: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q2_REC.date_type);
1347: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q2_REC.amount_type);
1348: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q2_REC.dr_amount));
1349: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q2_REC.cr_amount));
1350: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q2_REC.ccid));
1351: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Client Clr Acct = ' || Q2_REC.client_broker_clracct);
1352: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement Number = ' || to_char(Q2_REC.settlement_number));
1345: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q2_REC.portfolio_code);
1346: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q2_REC.date_type);
1347: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q2_REC.amount_type);
1348: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q2_REC.dr_amount));
1349: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q2_REC.cr_amount));
1350: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q2_REC.ccid));
1351: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Client Clr Acct = ' || Q2_REC.client_broker_clracct);
1352: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement Number = ' || to_char(Q2_REC.settlement_number));
1353: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Prin CCID flag = ' || Q2_REC.use_prin_ccid_flag);
1346: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q2_REC.date_type);
1347: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q2_REC.amount_type);
1348: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q2_REC.dr_amount));
1349: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q2_REC.cr_amount));
1350: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q2_REC.ccid));
1351: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Client Clr Acct = ' || Q2_REC.client_broker_clracct);
1352: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement Number = ' || to_char(Q2_REC.settlement_number));
1353: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Prin CCID flag = ' || Q2_REC.use_prin_ccid_flag);
1354: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Int CCID flag = ' || Q2_REC.use_int_ccid_flag);
1347: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q2_REC.amount_type);
1348: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q2_REC.dr_amount));
1349: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q2_REC.cr_amount));
1350: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q2_REC.ccid));
1351: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Client Clr Acct = ' || Q2_REC.client_broker_clracct);
1352: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement Number = ' || to_char(Q2_REC.settlement_number));
1353: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Prin CCID flag = ' || Q2_REC.use_prin_ccid_flag);
1354: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Int CCID flag = ' || Q2_REC.use_int_ccid_flag);
1355: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Cpty Bank Acct Nbr = ' || Q2_REC.cparty_account_no);
1348: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q2_REC.dr_amount));
1349: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q2_REC.cr_amount));
1350: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q2_REC.ccid));
1351: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Client Clr Acct = ' || Q2_REC.client_broker_clracct);
1352: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement Number = ' || to_char(Q2_REC.settlement_number));
1353: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Prin CCID flag = ' || Q2_REC.use_prin_ccid_flag);
1354: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Int CCID flag = ' || Q2_REC.use_int_ccid_flag);
1355: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Cpty Bank Acct Nbr = ' || Q2_REC.cparty_account_no);
1356: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Cpty Code = ' || Q2_REC.cparty_code);
1349: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q2_REC.cr_amount));
1350: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q2_REC.ccid));
1351: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Client Clr Acct = ' || Q2_REC.client_broker_clracct);
1352: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement Number = ' || to_char(Q2_REC.settlement_number));
1353: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Prin CCID flag = ' || Q2_REC.use_prin_ccid_flag);
1354: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Int CCID flag = ' || Q2_REC.use_int_ccid_flag);
1355: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Cpty Bank Acct Nbr = ' || Q2_REC.cparty_account_no);
1356: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Cpty Code = ' || Q2_REC.cparty_code);
1357: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q2_REC.action_code);
1350: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q2_REC.ccid));
1351: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Client Clr Acct = ' || Q2_REC.client_broker_clracct);
1352: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement Number = ' || to_char(Q2_REC.settlement_number));
1353: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Prin CCID flag = ' || Q2_REC.use_prin_ccid_flag);
1354: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Int CCID flag = ' || Q2_REC.use_int_ccid_flag);
1355: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Cpty Bank Acct Nbr = ' || Q2_REC.cparty_account_no);
1356: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Cpty Code = ' || Q2_REC.cparty_code);
1357: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q2_REC.action_code);
1358: END IF;
1351: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Client Clr Acct = ' || Q2_REC.client_broker_clracct);
1352: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement Number = ' || to_char(Q2_REC.settlement_number));
1353: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Prin CCID flag = ' || Q2_REC.use_prin_ccid_flag);
1354: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Int CCID flag = ' || Q2_REC.use_int_ccid_flag);
1355: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Cpty Bank Acct Nbr = ' || Q2_REC.cparty_account_no);
1356: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Cpty Code = ' || Q2_REC.cparty_code);
1357: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q2_REC.action_code);
1358: END IF;
1359:
1352: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement Number = ' || to_char(Q2_REC.settlement_number));
1353: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Prin CCID flag = ' || Q2_REC.use_prin_ccid_flag);
1354: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Int CCID flag = ' || Q2_REC.use_int_ccid_flag);
1355: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Cpty Bank Acct Nbr = ' || Q2_REC.cparty_account_no);
1356: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Cpty Code = ' || Q2_REC.cparty_code);
1357: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q2_REC.action_code);
1358: END IF;
1359:
1360: -- Begin bug 1336492 additions.
1353: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Prin CCID flag = ' || Q2_REC.use_prin_ccid_flag);
1354: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Int CCID flag = ' || Q2_REC.use_int_ccid_flag);
1355: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Cpty Bank Acct Nbr = ' || Q2_REC.cparty_account_no);
1356: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Cpty Code = ' || Q2_REC.cparty_code);
1357: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q2_REC.action_code);
1358: END IF;
1359:
1360: -- Begin bug 1336492 additions.
1361: -- Added condition to prevent cashflow entry creation when deal has not been validated and
1609: Q2_REC.transaction_number <> nvl(l_prev_transaction_nbr,-1) or
1610: Q2_REC.date_type <> nvl(l_prev_date_type,'@@@@@@@') or
1611: Q2_REC.amount_date <> l_prev_amount_date) then
1612:
1613: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1614: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Change in deal type, deal #, trans #, date type, or amt date.');
1615: END IF;
1616:
1617: --1336492 If (nvl(l_error_flag,'N') <> 'Y') then
1610: Q2_REC.date_type <> nvl(l_prev_date_type,'@@@@@@@') or
1611: Q2_REC.amount_date <> l_prev_amount_date) then
1612:
1613: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1614: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Change in deal type, deal #, trans #, date type, or amt date.');
1615: END IF;
1616:
1617: --1336492 If (nvl(l_error_flag,'N') <> 'Y') then
1618:
1618:
1619: -- 1336492 modification, replaces above l_error_flag condition.
1620: If (nvl(l_updt_flag,'Y') = 'Y') then
1621:
1622: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1623: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Update DDA journal created flag.');
1624: END IF;
1625:
1626: -- Update DDA to put BATCH_ID value once journal is generated
1619: -- 1336492 modification, replaces above l_error_flag condition.
1620: If (nvl(l_updt_flag,'Y') = 'Y') then
1621:
1622: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1623: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Update DDA journal created flag.');
1624: END IF;
1625:
1626: -- Update DDA to put BATCH_ID value once journal is generated
1627:
1646: Else
1647: -- Begin 1336492 additions.
1648: -- Deal/Trans not validated, bypass journal creation for this group of deal type, deal nbr, and trans nbr.
1649:
1650: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1651: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal/Trans not validated. Bypass entry creation.');
1652: END IF;
1653:
1654: --1336492 l_error_flag := 'Y';
1647: -- Begin 1336492 additions.
1648: -- Deal/Trans not validated, bypass journal creation for this group of deal type, deal nbr, and trans nbr.
1649:
1650: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1651: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal/Trans not validated. Bypass entry creation.');
1652: END IF;
1653:
1654: --1336492 l_error_flag := 'Y';
1655:
1679: End If; -- deal/trans validated or no validation required.
1680: END LOOP;
1681: Close Q2;
1682:
1683: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1684: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Exiting Q2.');
1685: END IF;
1686:
1687: --1336492 If (l_prev_deal_nbr is NOT NULL and nvl(l_error_flag,'N') <> 'Y') then
1680: END LOOP;
1681: Close Q2;
1682:
1683: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1684: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Exiting Q2.');
1685: END IF;
1686:
1687: --1336492 If (l_prev_deal_nbr is NOT NULL and nvl(l_error_flag,'N') <> 'Y') then
1688:
1689: -- 1336492.
1690: -- Modified condition to use l_updt_flag instead of l_error_flag.
1691: If (l_prev_deal_nbr is NOT NULL and nvl(l_updt_flag,'Y') = 'Y') then
1692:
1693: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1694: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Update last batch of Q2 data.');
1695: END IF;
1696:
1697: Update XTR_DEAL_DATE_AMOUNTS
1690: -- Modified condition to use l_updt_flag instead of l_error_flag.
1691: If (l_prev_deal_nbr is NOT NULL and nvl(l_updt_flag,'Y') = 'Y') then
1692:
1693: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1694: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Update last batch of Q2 data.');
1695: END IF;
1696:
1697: Update XTR_DEAL_DATE_AMOUNTS
1698: set batch_id = l_batch_id
1731: Fetch Q3 INTO Q3_REC;
1732:
1733: l_batch_id := in_batch_id;
1734:
1735: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1736: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Entering Q3 loop.');
1737: END IF;
1738:
1739: While Q3%FOUND LOOP
1732:
1733: l_batch_id := in_batch_id;
1734:
1735: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1736: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Entering Q3 loop.');
1737: END IF;
1738:
1739: While Q3%FOUND LOOP
1740: --
1737: END IF;
1738:
1739: While Q3%FOUND LOOP
1740: --
1741: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1742: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q3_REC.company_code);
1743: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q3_REC.deal_type);
1744: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q3_REC.deal_number));
1745: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q3_REC.trans_number));
1738:
1739: While Q3%FOUND LOOP
1740: --
1741: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1742: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q3_REC.company_code);
1743: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q3_REC.deal_type);
1744: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q3_REC.deal_number));
1745: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q3_REC.trans_number));
1746: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q3_REC.amount_date,'MM/DD/RRRR'));
1739: While Q3%FOUND LOOP
1740: --
1741: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1742: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q3_REC.company_code);
1743: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q3_REC.deal_type);
1744: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q3_REC.deal_number));
1745: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q3_REC.trans_number));
1746: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q3_REC.amount_date,'MM/DD/RRRR'));
1747: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q3_REC.currency);
1740: --
1741: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1742: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q3_REC.company_code);
1743: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q3_REC.deal_type);
1744: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q3_REC.deal_number));
1745: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q3_REC.trans_number));
1746: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q3_REC.amount_date,'MM/DD/RRRR'));
1747: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q3_REC.currency);
1748: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q3_REC.deal_subtype);
1741: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1742: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q3_REC.company_code);
1743: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q3_REC.deal_type);
1744: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q3_REC.deal_number));
1745: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q3_REC.trans_number));
1746: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q3_REC.amount_date,'MM/DD/RRRR'));
1747: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q3_REC.currency);
1748: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q3_REC.deal_subtype);
1749: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q3_REC.product_type);
1742: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q3_REC.company_code);
1743: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q3_REC.deal_type);
1744: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q3_REC.deal_number));
1745: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q3_REC.trans_number));
1746: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q3_REC.amount_date,'MM/DD/RRRR'));
1747: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q3_REC.currency);
1748: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q3_REC.deal_subtype);
1749: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q3_REC.product_type);
1750: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q3_REC.amount_type);
1743: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q3_REC.deal_type);
1744: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q3_REC.deal_number));
1745: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q3_REC.trans_number));
1746: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q3_REC.amount_date,'MM/DD/RRRR'));
1747: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q3_REC.currency);
1748: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q3_REC.deal_subtype);
1749: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q3_REC.product_type);
1750: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q3_REC.amount_type);
1751: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q3_REC.debit_amount));
1744: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q3_REC.deal_number));
1745: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q3_REC.trans_number));
1746: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q3_REC.amount_date,'MM/DD/RRRR'));
1747: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q3_REC.currency);
1748: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q3_REC.deal_subtype);
1749: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q3_REC.product_type);
1750: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q3_REC.amount_type);
1751: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q3_REC.debit_amount));
1752: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q3_REC.credit_amount));
1745: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q3_REC.trans_number));
1746: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q3_REC.amount_date,'MM/DD/RRRR'));
1747: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q3_REC.currency);
1748: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q3_REC.deal_subtype);
1749: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q3_REC.product_type);
1750: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q3_REC.amount_type);
1751: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q3_REC.debit_amount));
1752: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q3_REC.credit_amount));
1753: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q3_REC.type_ccid));
1746: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q3_REC.amount_date,'MM/DD/RRRR'));
1747: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q3_REC.currency);
1748: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q3_REC.deal_subtype);
1749: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q3_REC.product_type);
1750: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q3_REC.amount_type);
1751: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q3_REC.debit_amount));
1752: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q3_REC.credit_amount));
1753: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q3_REC.type_ccid));
1754: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Bank CCID = ' || to_char(Q3_REC.bank_ccid));
1747: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q3_REC.currency);
1748: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q3_REC.deal_subtype);
1749: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q3_REC.product_type);
1750: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q3_REC.amount_type);
1751: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q3_REC.debit_amount));
1752: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q3_REC.credit_amount));
1753: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q3_REC.type_ccid));
1754: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Bank CCID = ' || to_char(Q3_REC.bank_ccid));
1755: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement # = ' || to_char(Q3_REC.settlement_number));
1748: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q3_REC.deal_subtype);
1749: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q3_REC.product_type);
1750: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q3_REC.amount_type);
1751: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q3_REC.debit_amount));
1752: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q3_REC.credit_amount));
1753: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q3_REC.type_ccid));
1754: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Bank CCID = ' || to_char(Q3_REC.bank_ccid));
1755: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement # = ' || to_char(Q3_REC.settlement_number));
1756: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q3_REC.date_type);
1749: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q3_REC.product_type);
1750: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q3_REC.amount_type);
1751: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q3_REC.debit_amount));
1752: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q3_REC.credit_amount));
1753: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q3_REC.type_ccid));
1754: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Bank CCID = ' || to_char(Q3_REC.bank_ccid));
1755: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement # = ' || to_char(Q3_REC.settlement_number));
1756: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q3_REC.date_type);
1757: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q3_REC.action_code);
1750: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q3_REC.amount_type);
1751: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q3_REC.debit_amount));
1752: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q3_REC.credit_amount));
1753: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q3_REC.type_ccid));
1754: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Bank CCID = ' || to_char(Q3_REC.bank_ccid));
1755: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement # = ' || to_char(Q3_REC.settlement_number));
1756: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q3_REC.date_type);
1757: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q3_REC.action_code);
1758: END IF;
1751: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q3_REC.debit_amount));
1752: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q3_REC.credit_amount));
1753: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q3_REC.type_ccid));
1754: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Bank CCID = ' || to_char(Q3_REC.bank_ccid));
1755: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement # = ' || to_char(Q3_REC.settlement_number));
1756: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q3_REC.date_type);
1757: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q3_REC.action_code);
1758: END IF;
1759:
1752: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q3_REC.credit_amount));
1753: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q3_REC.type_ccid));
1754: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Bank CCID = ' || to_char(Q3_REC.bank_ccid));
1755: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement # = ' || to_char(Q3_REC.settlement_number));
1756: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q3_REC.date_type);
1757: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q3_REC.action_code);
1758: END IF;
1759:
1760: -- 1336492 additions.
1753: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q3_REC.type_ccid));
1754: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Bank CCID = ' || to_char(Q3_REC.bank_ccid));
1755: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement # = ' || to_char(Q3_REC.settlement_number));
1756: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q3_REC.date_type);
1757: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q3_REC.action_code);
1758: END IF;
1759:
1760: -- 1336492 additions.
1761: -- Added logic to determine validation status of EXP transaction.
2055: Fetch Q4 INTO Q4_REC;
2056:
2057: l_prev_rowid := l_row_id;
2058:
2059: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2060: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Entering Q4 loop.');
2061: END IF;
2062:
2063: While Q4%FOUND LOOP
2056:
2057: l_prev_rowid := l_row_id;
2058:
2059: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2060: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Entering Q4 loop.');
2061: END IF;
2062:
2063: While Q4%FOUND LOOP
2064: --
2061: END IF;
2062:
2063: While Q4%FOUND LOOP
2064: --
2065: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2066: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q4_REC.company_code);
2067: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q4_REC.deal_type);
2068: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q4_REC.deal_number));
2069: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q4_REC.trans_number));
2062:
2063: While Q4%FOUND LOOP
2064: --
2065: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2066: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q4_REC.company_code);
2067: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q4_REC.deal_type);
2068: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q4_REC.deal_number));
2069: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q4_REC.trans_number));
2070: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q4_REC.amount_date,'MM/DD/RRRR'));
2063: While Q4%FOUND LOOP
2064: --
2065: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2066: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q4_REC.company_code);
2067: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q4_REC.deal_type);
2068: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q4_REC.deal_number));
2069: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q4_REC.trans_number));
2070: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q4_REC.amount_date,'MM/DD/RRRR'));
2071: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q4_REC.currency);
2064: --
2065: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2066: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q4_REC.company_code);
2067: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q4_REC.deal_type);
2068: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q4_REC.deal_number));
2069: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q4_REC.trans_number));
2070: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q4_REC.amount_date,'MM/DD/RRRR'));
2071: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q4_REC.currency);
2072: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q4_REC.deal_subtype);
2065: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2066: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q4_REC.company_code);
2067: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q4_REC.deal_type);
2068: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q4_REC.deal_number));
2069: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q4_REC.trans_number));
2070: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q4_REC.amount_date,'MM/DD/RRRR'));
2071: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q4_REC.currency);
2072: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q4_REC.deal_subtype);
2073: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q4_REC.product_type);
2066: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q4_REC.company_code);
2067: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q4_REC.deal_type);
2068: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q4_REC.deal_number));
2069: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q4_REC.trans_number));
2070: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q4_REC.amount_date,'MM/DD/RRRR'));
2071: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q4_REC.currency);
2072: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q4_REC.deal_subtype);
2073: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q4_REC.product_type);
2074: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q4_REC.portfolio_code);
2067: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q4_REC.deal_type);
2068: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q4_REC.deal_number));
2069: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q4_REC.trans_number));
2070: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q4_REC.amount_date,'MM/DD/RRRR'));
2071: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q4_REC.currency);
2072: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q4_REC.deal_subtype);
2073: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q4_REC.product_type);
2074: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q4_REC.portfolio_code);
2075: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q4_REC.amount_type);
2068: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q4_REC.deal_number));
2069: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q4_REC.trans_number));
2070: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q4_REC.amount_date,'MM/DD/RRRR'));
2071: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q4_REC.currency);
2072: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q4_REC.deal_subtype);
2073: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q4_REC.product_type);
2074: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q4_REC.portfolio_code);
2075: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q4_REC.amount_type);
2076: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount = ' || to_char(Q4_REC.accrls_amount));
2069: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q4_REC.trans_number));
2070: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q4_REC.amount_date,'MM/DD/RRRR'));
2071: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q4_REC.currency);
2072: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q4_REC.deal_subtype);
2073: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q4_REC.product_type);
2074: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q4_REC.portfolio_code);
2075: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q4_REC.amount_type);
2076: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount = ' || to_char(Q4_REC.accrls_amount));
2077: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = ' || Q4_REC.credit_or_debit);
2070: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q4_REC.amount_date,'MM/DD/RRRR'));
2071: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q4_REC.currency);
2072: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q4_REC.deal_subtype);
2073: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q4_REC.product_type);
2074: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q4_REC.portfolio_code);
2075: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q4_REC.amount_type);
2076: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount = ' || to_char(Q4_REC.accrls_amount));
2077: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = ' || Q4_REC.credit_or_debit);
2078: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q4_REC.ccid));
2071: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q4_REC.currency);
2072: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q4_REC.deal_subtype);
2073: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q4_REC.product_type);
2074: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q4_REC.portfolio_code);
2075: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q4_REC.amount_type);
2076: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount = ' || to_char(Q4_REC.accrls_amount));
2077: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = ' || Q4_REC.credit_or_debit);
2078: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q4_REC.ccid));
2079: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q4_REC.date_type);
2072: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q4_REC.deal_subtype);
2073: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q4_REC.product_type);
2074: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q4_REC.portfolio_code);
2075: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q4_REC.amount_type);
2076: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount = ' || to_char(Q4_REC.accrls_amount));
2077: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = ' || Q4_REC.credit_or_debit);
2078: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q4_REC.ccid));
2079: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q4_REC.date_type);
2080: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q4_REC.action_code);
2073: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q4_REC.product_type);
2074: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q4_REC.portfolio_code);
2075: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q4_REC.amount_type);
2076: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount = ' || to_char(Q4_REC.accrls_amount));
2077: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = ' || Q4_REC.credit_or_debit);
2078: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q4_REC.ccid));
2079: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q4_REC.date_type);
2080: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q4_REC.action_code);
2081: END IF;
2074: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q4_REC.portfolio_code);
2075: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q4_REC.amount_type);
2076: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount = ' || to_char(Q4_REC.accrls_amount));
2077: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = ' || Q4_REC.credit_or_debit);
2078: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q4_REC.ccid));
2079: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q4_REC.date_type);
2080: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q4_REC.action_code);
2081: END IF;
2082:
2075: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q4_REC.amount_type);
2076: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount = ' || to_char(Q4_REC.accrls_amount));
2077: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = ' || Q4_REC.credit_or_debit);
2078: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q4_REC.ccid));
2079: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q4_REC.date_type);
2080: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q4_REC.action_code);
2081: END IF;
2082:
2083: If (Q4_REC.accrls_amount = 0) then
2076: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount = ' || to_char(Q4_REC.accrls_amount));
2077: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = ' || Q4_REC.credit_or_debit);
2078: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q4_REC.ccid));
2079: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q4_REC.date_type);
2080: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q4_REC.action_code);
2081: END IF;
2082:
2083: If (Q4_REC.accrls_amount = 0) then
2084: NULL;
2248: Fetch Q5 INTO Q5_REC;
2249:
2250: l_prev_rowid := l_row_id;
2251:
2252: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2253: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Entering Q5 loop.');
2254: END IF;
2255:
2256: While Q5%FOUND LOOP
2249:
2250: l_prev_rowid := l_row_id;
2251:
2252: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2253: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Entering Q5 loop.');
2254: END IF;
2255:
2256: While Q5%FOUND LOOP
2257: --
2254: END IF;
2255:
2256: While Q5%FOUND LOOP
2257: --
2258: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2259: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q5_REC.company_code);
2260: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q5_REC.deal_type);
2261: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q5_REC.deal_number));
2262: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q5_REC.trans_number));
2255:
2256: While Q5%FOUND LOOP
2257: --
2258: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2259: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q5_REC.company_code);
2260: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q5_REC.deal_type);
2261: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q5_REC.deal_number));
2262: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q5_REC.trans_number));
2263: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q5_REC.journal_date,'MM/DD/RRRR'));
2256: While Q5%FOUND LOOP
2257: --
2258: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2259: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q5_REC.company_code);
2260: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q5_REC.deal_type);
2261: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q5_REC.deal_number));
2262: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q5_REC.trans_number));
2263: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q5_REC.journal_date,'MM/DD/RRRR'));
2264: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q5_REC.reval_currency);
2257: --
2258: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2259: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q5_REC.company_code);
2260: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q5_REC.deal_type);
2261: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q5_REC.deal_number));
2262: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q5_REC.trans_number));
2263: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q5_REC.journal_date,'MM/DD/RRRR'));
2264: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q5_REC.reval_currency);
2265: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q5_REC.deal_subtype);
2258: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2259: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q5_REC.company_code);
2260: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q5_REC.deal_type);
2261: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q5_REC.deal_number));
2262: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q5_REC.trans_number));
2263: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q5_REC.journal_date,'MM/DD/RRRR'));
2264: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q5_REC.reval_currency);
2265: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q5_REC.deal_subtype);
2266: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q5_REC.product_type);
2259: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q5_REC.company_code);
2260: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q5_REC.deal_type);
2261: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q5_REC.deal_number));
2262: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q5_REC.trans_number));
2263: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q5_REC.journal_date,'MM/DD/RRRR'));
2264: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q5_REC.reval_currency);
2265: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q5_REC.deal_subtype);
2266: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q5_REC.product_type);
2267: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q5_REC.portfolio_code);
2260: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q5_REC.deal_type);
2261: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q5_REC.deal_number));
2262: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q5_REC.trans_number));
2263: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q5_REC.journal_date,'MM/DD/RRRR'));
2264: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q5_REC.reval_currency);
2265: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q5_REC.deal_subtype);
2266: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q5_REC.product_type);
2267: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q5_REC.portfolio_code);
2268: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q5_REC.amount_type);
2261: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q5_REC.deal_number));
2262: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q5_REC.trans_number));
2263: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q5_REC.journal_date,'MM/DD/RRRR'));
2264: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q5_REC.reval_currency);
2265: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q5_REC.deal_subtype);
2266: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q5_REC.product_type);
2267: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q5_REC.portfolio_code);
2268: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q5_REC.amount_type);
2269: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q5_REC.action_code);
2262: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q5_REC.trans_number));
2263: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q5_REC.journal_date,'MM/DD/RRRR'));
2264: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q5_REC.reval_currency);
2265: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q5_REC.deal_subtype);
2266: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q5_REC.product_type);
2267: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q5_REC.portfolio_code);
2268: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q5_REC.amount_type);
2269: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q5_REC.action_code);
2270: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = ' || to_char(Q5_REC.amount));
2263: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q5_REC.journal_date,'MM/DD/RRRR'));
2264: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q5_REC.reval_currency);
2265: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q5_REC.deal_subtype);
2266: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q5_REC.product_type);
2267: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q5_REC.portfolio_code);
2268: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q5_REC.amount_type);
2269: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q5_REC.action_code);
2270: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = ' || to_char(Q5_REC.amount));
2271: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q5_REC.ccid));
2264: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q5_REC.reval_currency);
2265: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q5_REC.deal_subtype);
2266: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q5_REC.product_type);
2267: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q5_REC.portfolio_code);
2268: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q5_REC.amount_type);
2269: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q5_REC.action_code);
2270: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = ' || to_char(Q5_REC.amount));
2271: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q5_REC.ccid));
2272: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = ' || Q5_REC.credit_or_debit);
2265: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q5_REC.deal_subtype);
2266: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q5_REC.product_type);
2267: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q5_REC.portfolio_code);
2268: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q5_REC.amount_type);
2269: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q5_REC.action_code);
2270: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = ' || to_char(Q5_REC.amount));
2271: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q5_REC.ccid));
2272: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = ' || Q5_REC.credit_or_debit);
2273: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q5_REC.date_type);
2266: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q5_REC.product_type);
2267: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q5_REC.portfolio_code);
2268: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q5_REC.amount_type);
2269: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q5_REC.action_code);
2270: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = ' || to_char(Q5_REC.amount));
2271: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q5_REC.ccid));
2272: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = ' || Q5_REC.credit_or_debit);
2273: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q5_REC.date_type);
2274: END IF;
2267: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q5_REC.portfolio_code);
2268: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q5_REC.amount_type);
2269: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q5_REC.action_code);
2270: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = ' || to_char(Q5_REC.amount));
2271: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q5_REC.ccid));
2272: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = ' || Q5_REC.credit_or_debit);
2273: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q5_REC.date_type);
2274: END IF;
2275:
2268: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q5_REC.amount_type);
2269: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q5_REC.action_code);
2270: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = ' || to_char(Q5_REC.amount));
2271: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q5_REC.ccid));
2272: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = ' || Q5_REC.credit_or_debit);
2273: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q5_REC.date_type);
2274: END IF;
2275:
2276: If (nvl(Q5_REC.amount,0) = 0) then
2269: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q5_REC.action_code);
2270: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = ' || to_char(Q5_REC.amount));
2271: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q5_REC.ccid));
2272: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = ' || Q5_REC.credit_or_debit);
2273: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q5_REC.date_type);
2274: END IF;
2275:
2276: If (nvl(Q5_REC.amount,0) = 0) then
2277: NULL;
2527: Fetch Q6 INTO Q6_REC;
2528:
2529: l_prev_rowid := l_row_id;
2530:
2531: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2532: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Entering Q6 loop.');
2533: END IF;
2534:
2535: While Q6%FOUND LOOP
2528:
2529: l_prev_rowid := l_row_id;
2530:
2531: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2532: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Entering Q6 loop.');
2533: END IF;
2534:
2535: While Q6%FOUND LOOP
2536: If nvl(l_q6_deal_no, -1) <> Q6_REC.deal_number then
2572: and l_CCYREAL = TRUE)) then
2573: NULL; -- Do not process this Revaluations record
2574: Else -- existing code
2575:
2576: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2577: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Company Code = '|| Q6_REC.company_code);
2578: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Type = ' || Q6_REC.deal_type);
2579: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q6_REC.deal_number));
2580: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q6_REC.trans_number));
2573: NULL; -- Do not process this Revaluations record
2574: Else -- existing code
2575:
2576: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2577: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Company Code = '|| Q6_REC.company_code);
2578: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Type = ' || Q6_REC.deal_type);
2579: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q6_REC.deal_number));
2580: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q6_REC.trans_number));
2581: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q6_REC.journal_date,'MM/DD/RRRR'));
2574: Else -- existing code
2575:
2576: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2577: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Company Code = '|| Q6_REC.company_code);
2578: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Type = ' || Q6_REC.deal_type);
2579: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q6_REC.deal_number));
2580: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q6_REC.trans_number));
2581: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q6_REC.journal_date,'MM/DD/RRRR'));
2582: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q6_REC.reval_currency);
2575:
2576: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2577: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Company Code = '|| Q6_REC.company_code);
2578: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Type = ' || Q6_REC.deal_type);
2579: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q6_REC.deal_number));
2580: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q6_REC.trans_number));
2581: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q6_REC.journal_date,'MM/DD/RRRR'));
2582: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q6_REC.reval_currency);
2583: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q6_REC.deal_subtype);
2576: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2577: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Company Code = '|| Q6_REC.company_code);
2578: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Type = ' || Q6_REC.deal_type);
2579: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q6_REC.deal_number));
2580: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q6_REC.trans_number));
2581: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q6_REC.journal_date,'MM/DD/RRRR'));
2582: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q6_REC.reval_currency);
2583: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q6_REC.deal_subtype);
2584: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q6_REC.product_type);
2577: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Company Code = '|| Q6_REC.company_code);
2578: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Type = ' || Q6_REC.deal_type);
2579: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q6_REC.deal_number));
2580: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q6_REC.trans_number));
2581: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q6_REC.journal_date,'MM/DD/RRRR'));
2582: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q6_REC.reval_currency);
2583: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q6_REC.deal_subtype);
2584: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q6_REC.product_type);
2585: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q6_REC.portfolio_code);
2578: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Type = ' || Q6_REC.deal_type);
2579: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q6_REC.deal_number));
2580: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q6_REC.trans_number));
2581: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q6_REC.journal_date,'MM/DD/RRRR'));
2582: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q6_REC.reval_currency);
2583: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q6_REC.deal_subtype);
2584: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q6_REC.product_type);
2585: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q6_REC.portfolio_code);
2586: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q6_REC.amount_type);
2579: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q6_REC.deal_number));
2580: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q6_REC.trans_number));
2581: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q6_REC.journal_date,'MM/DD/RRRR'));
2582: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q6_REC.reval_currency);
2583: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q6_REC.deal_subtype);
2584: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q6_REC.product_type);
2585: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q6_REC.portfolio_code);
2586: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q6_REC.amount_type);
2587: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q6_REC.action_code);
2580: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q6_REC.trans_number));
2581: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q6_REC.journal_date,'MM/DD/RRRR'));
2582: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q6_REC.reval_currency);
2583: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q6_REC.deal_subtype);
2584: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q6_REC.product_type);
2585: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q6_REC.portfolio_code);
2586: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q6_REC.amount_type);
2587: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q6_REC.action_code);
2588: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q6_REC.amount));
2581: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q6_REC.journal_date,'MM/DD/RRRR'));
2582: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q6_REC.reval_currency);
2583: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q6_REC.deal_subtype);
2584: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q6_REC.product_type);
2585: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q6_REC.portfolio_code);
2586: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q6_REC.amount_type);
2587: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q6_REC.action_code);
2588: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q6_REC.amount));
2589: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = '|| to_char(Q6_REC.ccid));
2582: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q6_REC.reval_currency);
2583: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q6_REC.deal_subtype);
2584: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q6_REC.product_type);
2585: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q6_REC.portfolio_code);
2586: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q6_REC.amount_type);
2587: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q6_REC.action_code);
2588: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q6_REC.amount));
2589: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = '|| to_char(Q6_REC.ccid));
2590: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = '|| Q6_REC.credit_or_debit);
2583: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q6_REC.deal_subtype);
2584: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q6_REC.product_type);
2585: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q6_REC.portfolio_code);
2586: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q6_REC.amount_type);
2587: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q6_REC.action_code);
2588: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q6_REC.amount));
2589: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = '|| to_char(Q6_REC.ccid));
2590: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = '|| Q6_REC.credit_or_debit);
2591: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = '|| Q6_REC.date_type);
2584: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q6_REC.product_type);
2585: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q6_REC.portfolio_code);
2586: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q6_REC.amount_type);
2587: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q6_REC.action_code);
2588: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q6_REC.amount));
2589: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = '|| to_char(Q6_REC.ccid));
2590: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = '|| Q6_REC.credit_or_debit);
2591: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = '|| Q6_REC.date_type);
2592: END IF;
2585: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q6_REC.portfolio_code);
2586: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q6_REC.amount_type);
2587: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q6_REC.action_code);
2588: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q6_REC.amount));
2589: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = '|| to_char(Q6_REC.ccid));
2590: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = '|| Q6_REC.credit_or_debit);
2591: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = '|| Q6_REC.date_type);
2592: END IF;
2593:
2586: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q6_REC.amount_type);
2587: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q6_REC.action_code);
2588: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q6_REC.amount));
2589: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = '|| to_char(Q6_REC.ccid));
2590: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = '|| Q6_REC.credit_or_debit);
2591: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = '|| Q6_REC.date_type);
2592: END IF;
2593:
2594: If (nvl(Q6_REC.amount,0) = 0) then
2587: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q6_REC.action_code);
2588: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q6_REC.amount));
2589: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = '|| to_char(Q6_REC.ccid));
2590: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = '|| Q6_REC.credit_or_debit);
2591: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = '|| Q6_REC.date_type);
2592: END IF;
2593:
2594: If (nvl(Q6_REC.amount,0) = 0) then
2595: NULL;
2817: Fetch Q7 INTO Q7_REC;
2818:
2819: l_prev_rowid := l_row_id;
2820:
2821: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2822: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Entering Q7 loop.');
2823: END IF;
2824:
2825: While Q7%FOUND LOOP
2818:
2819: l_prev_rowid := l_row_id;
2820:
2821: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2822: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Entering Q7 loop.');
2823: END IF;
2824:
2825: While Q7%FOUND LOOP
2826: --
2823: END IF;
2824:
2825: While Q7%FOUND LOOP
2826: --
2827: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2828: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Company Code = '|| Q7_REC.company_code);
2829: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Type = ' || Q7_REC.deal_type);
2830: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q7_REC.deal_number));
2831: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q7_REC.trans_number));
2824:
2825: While Q7%FOUND LOOP
2826: --
2827: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2828: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Company Code = '|| Q7_REC.company_code);
2829: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Type = ' || Q7_REC.deal_type);
2830: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q7_REC.deal_number));
2831: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q7_REC.trans_number));
2832: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q7_REC.journal_date,'MM/DD/RRRR'));
2825: While Q7%FOUND LOOP
2826: --
2827: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2828: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Company Code = '|| Q7_REC.company_code);
2829: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Type = ' || Q7_REC.deal_type);
2830: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q7_REC.deal_number));
2831: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q7_REC.trans_number));
2832: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q7_REC.journal_date,'MM/DD/RRRR'));
2833: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q7_REC.reval_currency);
2826: --
2827: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2828: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Company Code = '|| Q7_REC.company_code);
2829: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Type = ' || Q7_REC.deal_type);
2830: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q7_REC.deal_number));
2831: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q7_REC.trans_number));
2832: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q7_REC.journal_date,'MM/DD/RRRR'));
2833: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q7_REC.reval_currency);
2834: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q7_REC.deal_subtype);
2827: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2828: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Company Code = '|| Q7_REC.company_code);
2829: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Type = ' || Q7_REC.deal_type);
2830: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q7_REC.deal_number));
2831: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q7_REC.trans_number));
2832: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q7_REC.journal_date,'MM/DD/RRRR'));
2833: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q7_REC.reval_currency);
2834: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q7_REC.deal_subtype);
2835: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q7_REC.product_type);
2828: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Company Code = '|| Q7_REC.company_code);
2829: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Type = ' || Q7_REC.deal_type);
2830: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q7_REC.deal_number));
2831: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q7_REC.trans_number));
2832: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q7_REC.journal_date,'MM/DD/RRRR'));
2833: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q7_REC.reval_currency);
2834: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q7_REC.deal_subtype);
2835: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q7_REC.product_type);
2836: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q7_REC.portfolio_code);
2829: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Type = ' || Q7_REC.deal_type);
2830: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q7_REC.deal_number));
2831: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q7_REC.trans_number));
2832: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q7_REC.journal_date,'MM/DD/RRRR'));
2833: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q7_REC.reval_currency);
2834: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q7_REC.deal_subtype);
2835: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q7_REC.product_type);
2836: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q7_REC.portfolio_code);
2837: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q7_REC.amount_type);
2830: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q7_REC.deal_number));
2831: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q7_REC.trans_number));
2832: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q7_REC.journal_date,'MM/DD/RRRR'));
2833: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q7_REC.reval_currency);
2834: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q7_REC.deal_subtype);
2835: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q7_REC.product_type);
2836: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q7_REC.portfolio_code);
2837: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q7_REC.amount_type);
2838: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q7_REC.action_code);
2831: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q7_REC.trans_number));
2832: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q7_REC.journal_date,'MM/DD/RRRR'));
2833: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q7_REC.reval_currency);
2834: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q7_REC.deal_subtype);
2835: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q7_REC.product_type);
2836: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q7_REC.portfolio_code);
2837: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q7_REC.amount_type);
2838: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q7_REC.action_code);
2839: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q7_REC.amount));
2832: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q7_REC.journal_date,'MM/DD/RRRR'));
2833: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q7_REC.reval_currency);
2834: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q7_REC.deal_subtype);
2835: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q7_REC.product_type);
2836: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q7_REC.portfolio_code);
2837: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q7_REC.amount_type);
2838: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q7_REC.action_code);
2839: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q7_REC.amount));
2840: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = '|| to_char(Q7_REC.ccid));
2833: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q7_REC.reval_currency);
2834: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q7_REC.deal_subtype);
2835: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q7_REC.product_type);
2836: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q7_REC.portfolio_code);
2837: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q7_REC.amount_type);
2838: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q7_REC.action_code);
2839: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q7_REC.amount));
2840: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = '|| to_char(Q7_REC.ccid));
2841: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = '|| Q7_REC.credit_or_debit);
2834: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q7_REC.deal_subtype);
2835: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q7_REC.product_type);
2836: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q7_REC.portfolio_code);
2837: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q7_REC.amount_type);
2838: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q7_REC.action_code);
2839: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q7_REC.amount));
2840: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = '|| to_char(Q7_REC.ccid));
2841: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = '|| Q7_REC.credit_or_debit);
2842: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = '|| Q7_REC.date_type);
2835: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q7_REC.product_type);
2836: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q7_REC.portfolio_code);
2837: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q7_REC.amount_type);
2838: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q7_REC.action_code);
2839: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q7_REC.amount));
2840: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = '|| to_char(Q7_REC.ccid));
2841: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = '|| Q7_REC.credit_or_debit);
2842: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = '|| Q7_REC.date_type);
2843: END IF;
2836: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q7_REC.portfolio_code);
2837: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q7_REC.amount_type);
2838: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q7_REC.action_code);
2839: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q7_REC.amount));
2840: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = '|| to_char(Q7_REC.ccid));
2841: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = '|| Q7_REC.credit_or_debit);
2842: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = '|| Q7_REC.date_type);
2843: END IF;
2844:
2837: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q7_REC.amount_type);
2838: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q7_REC.action_code);
2839: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q7_REC.amount));
2840: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = '|| to_char(Q7_REC.ccid));
2841: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = '|| Q7_REC.credit_or_debit);
2842: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = '|| Q7_REC.date_type);
2843: END IF;
2844:
2845: If (nvl(Q7_REC.amount,0) = 0) then
2838: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q7_REC.action_code);
2839: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q7_REC.amount));
2840: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = '|| to_char(Q7_REC.ccid));
2841: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = '|| Q7_REC.credit_or_debit);
2842: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = '|| Q7_REC.date_type);
2843: END IF;
2844:
2845: If (nvl(Q7_REC.amount,0) = 0) then
2846: NULL;
3380:
3381:
3382: BEGIN
3383:
3384: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
3385: xtr_debug_pkg.debug ('>> PROCEDURE Journals.');
3386: END IF;
3387:
3388: l_cutoff_date := FND_DATE.Canonical_To_Date(p_cutoff_date);
3381:
3382: BEGIN
3383:
3384: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
3385: xtr_debug_pkg.debug ('>> PROCEDURE Journals.');
3386: END IF;
3387:
3388: l_cutoff_date := FND_DATE.Canonical_To_Date(p_cutoff_date);
3389: