eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_AUTO_BANK_MATCH dependencies on CE_AVAILABLE_TRANSACTIONS_TMP

Line 374: -- bug 5350073 ce_available_transactions_tmp is not populated when manually reconcile IBY batches

370: b.rowid = trx_rowid
371: AND nvl(c.status_lookup_code, 'NEGOTIABLE') <> 'VOIDED'
372: FOR UPDATE OF c.check_id, b.checkrun_id NOWAIT;*/
373:
374: -- bug 5350073 ce_available_transactions_tmp is not populated when manually reconcile IBY batches
375: CURSOR CHECK_AMOUNTS (X_batch_id NUMBER) IS
376: SELECT SUM(bank_account_amount)
377: FROM CE_200_TRANSACTIONS_V
378: --FROM ce_available_transactions_tmp

Line 378: --FROM ce_available_transactions_tmp

374: -- bug 5350073 ce_available_transactions_tmp is not populated when manually reconcile IBY batches
375: CURSOR CHECK_AMOUNTS (X_batch_id NUMBER) IS
376: SELECT SUM(bank_account_amount)
377: FROM CE_200_TRANSACTIONS_V
378: --FROM ce_available_transactions_tmp
379: WHERE batch_id = X_batch_id
380: AND nvl(status, 'NEGOTIABLE') <> 'VOIDED'
381: AND application_id = 200;
382: --AND NVL(reconciled_status_flag, 'N') = 'N';

Line 807: FROM ce_available_transactions_tmp catv

803: CE_AUTO_BANK_MATCH.trx_legal_entity_id,
804: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id,
805: CE_AUTO_BANK_MATCH.gt_seq_id
806: --FROM ce_185_transactions_v catv
807: FROM ce_available_transactions_tmp catv
808: WHERE catv.trx_type = tx_type
809: AND catv.legal_entity_id = nvl(CE_AUTO_BANK_REC.G_legal_entity_id, catv.legal_entity_id)
810: --AND catv.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
811: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id

Line 867: FROM ce_available_transactions_tmp catv

863: CE_AUTO_BANK_MATCH.trx_legal_entity_id,
864: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id,
865: CE_AUTO_BANK_MATCH.gt_seq_id
866: --FROM ce_999_transactions_v catv
867: FROM ce_available_transactions_tmp catv
868: WHERE catv.trx_type = tx_type
869: --AND catv.org_id = CE_AUTO_BANK_REC.G_org_id
870: --AND catv.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
871: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id

Line 1645: FROM ce_available_transactions_tmp catv

1641: catv.deposit_date,
1642: catv.legal_entity_id,
1643: catv.seq_id
1644: --FROM ce_260_cf_transactions_v catv
1645: FROM ce_available_transactions_tmp catv
1646: WHERE catv.trx_type = tx_type
1647: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
1648: AND catv.legal_entity_id = nvl(CE_AUTO_BANK_REC.G_legal_entity_id , catv.legal_entity_id)
1649: --AND catv.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id

Line 1679: FROM ce_available_transactions_tmp catv

1675: catv.deposit_date,
1676: catv.legal_entity_id,
1677: catv.seq_id
1678: --FROM ce_260_cf_transactions_v catv
1679: FROM ce_available_transactions_tmp catv
1680: WHERE catv.trx_type = tx_type
1681: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
1682: AND catv.legal_entity_id = nvl(CE_AUTO_BANK_REC.G_legal_entity_id, catv.legal_entity_id)
1683: --AND catv.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id

Line 1716: FROM ce_available_transactions_tmp catv

1712: catv.deposit_date,
1713: catv.legal_entity_id,
1714: catv.seq_id
1715: --FROM ce_260_cf_transactions_v catv
1716: FROM ce_available_transactions_tmp catv
1717: WHERE catv.trx_type = tx_type
1718: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
1719: --AND catv.legal_entity_id = CE_AUTO_BANK_REC.G_legal_entity_id
1720: --AND catv.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id

Line 2013: FROM ce_available_transactions_tmp catv

2009: CE_AUTO_BANK_MATCH.trx_group,
2010: CE_AUTO_BANK_MATCH.trx_org_id,
2011: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id
2012: --FROM ce_801_EFT_transactions_v catv
2013: FROM ce_available_transactions_tmp catv
2014: WHERE upper(catv.batch_name) =
2015: upper(CE_AUTO_BANK_MATCH.csl_bank_trx_number)
2016: AND catv.trx_date = CE_AUTO_BANK_MATCH.csl_trx_date
2017: AND catv.org_id = nvl(CE_AUTO_BANK_REC.G_org_id, catv.org_id)

Line 2792: FROM ce_available_transactions_tmp catv

2788: no_of_currencies_ap,
2789: trx_curr_amount_ap,
2790: CE_AUTO_BANK_MATCH.csl_match_type
2791: --FROM ce_200_transactions_v catv
2792: FROM ce_available_transactions_tmp catv
2793: WHERE catv.batch_id = CE_AUTO_BANK_MATCH.trx_id
2794: AND nvl(catv.status, 'NEGOTIABLE') <> 'VOIDED'
2795: AND catv.application_id = 200
2796: AND NVL(catv.reconciled_status_flag, 'N') = 'N';

Line 2817: FROM ce_available_transactions_tmp catv

2813: no_of_currencies_ce,
2814: trx_curr_amount_ce,
2815: CE_AUTO_BANK_MATCH.csl_match_type
2816: --FROM ce_260_cf_transactions_v catv
2817: FROM ce_available_transactions_tmp catv
2818: WHERE catv.batch_id = CE_AUTO_BANK_MATCH.trx_id
2819: AND nvl(catv.status, 'CANCELED') <> 'CANCELED'
2820: AND catv.application_id = 261
2821: AND NVL(catv.reconciled_status_flag, 'N') = 'N';

Line 3038: FROM ce_available_transactions_tmp catv

3034: CE_AUTO_BANK_MATCH.trx_cleared_amount,
3035: no_of_currencies,
3036: CE_AUTO_BANK_MATCH.trx_curr_amount,
3037: CE_AUTO_BANK_MATCH.csl_match_type
3038: FROM ce_available_transactions_tmp catv
3039: WHERE catv.batch_id = CE_AUTO_BANK_MATCH.trx_id
3040: AND nvl(catv.status, 'NEGOTIABLE') <> 'VOIDED'
3041: AND catv.application_id = 200
3042: AND NVL(catv.reconciled_status_flag, 'N') = 'N'

Line 3866: FROM ce_available_transactions_tmp catv

3862: CE_AUTO_BANK_MATCH.trx_org_id,
3863: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id,
3864: CE_AUTO_BANK_MATCH.gt_seq_id
3865: --FROM ce_801_transactions_v catv
3866: FROM ce_available_transactions_tmp catv
3867: WHERE catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
3868: AND catv.bank_account_amount = CE_AUTO_BANK_MATCH.csl_amount
3869: AND catv.org_id = nvl(CE_AUTO_BANK_REC.G_org_id, catv.org_id)
3870: --AND catv.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id

Line 3915: FROM ce_available_transactions_tmp catv

3911: CE_AUTO_BANK_MATCH.trx_exchange_rate_date,
3912: CE_AUTO_BANK_MATCH.trx_exchange_rate_type,
3913: CE_AUTO_BANK_MATCH.gt_seq_id
3914: --FROM ce_101_transactions_v catv
3915: FROM ce_available_transactions_tmp catv
3916: WHERE catv.trx_type = tx_type
3917: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
3918: AND catv.trx_number = CE_AUTO_BANK_MATCH.csl_bank_trx_number
3919: AND catv.application_id = 101

Line 3975: FROM ce_available_transactions_tmp catv

3971: CE_AUTO_BANK_MATCH.trx_legal_entity_id,
3972: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id,
3973: CE_AUTO_BANK_MATCH.gt_seq_id
3974: --FROM ce_185_transactions_v catv
3975: FROM ce_available_transactions_tmp catv
3976: WHERE catv.trx_type = tx_type
3977: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
3978: AND catv.legal_entity_id = nvl(CE_AUTO_BANK_REC.G_legal_entity_id,CE_AUTO_BANK_REC.G_legal_entity_id)
3979: --AND catv.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id

Line 4025: FROM ce_available_transactions_tmp catv

4021: CE_AUTO_BANK_MATCH.trx_exchange_rate_type,
4022: CE_AUTO_BANK_MATCH.trx_legal_entity_id,
4023: CE_AUTO_BANK_MATCH.gt_seq_id
4024: --FROM ce_999_transactions_v catv
4025: FROM ce_available_transactions_tmp catv
4026: WHERE catv.trx_type = tx_type
4027: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4028: --AND catv.legal_entity_id = nvl(CE_AUTO_BANK_REC.G_legal_entity_id,CE_AUTO_BANK_REC.G_legal_entity_id)
4029: --AND catv.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id

Line 4206: FROM ce_available_transactions_tmp catv

4202: catv.org_id,
4203: catv.CE_BANK_ACCT_USE_ID,
4204: catv.seq_id
4205: --FROM ce_222_transactions_v catv
4206: FROM ce_available_transactions_tmp catv
4207: WHERE DECODE(tx_type,'CASH',
4208: DECODE(catv.trx_type,'MISC',
4209: 'CASH',
4210: catv.trx_type),

Line 4270: FROM ce_available_transactions_tmp catv

4266: CE_AUTO_BANK_MATCH.trx_org_id,
4267: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id,
4268: CE_AUTO_BANK_MATCH.gt_seq_id
4269: --FROM ce_222_transactions_v catv
4270: FROM ce_available_transactions_tmp catv
4271: WHERE DECODE(tx_type,'CASH',
4272: DECODE(catv.trx_type,'MISC',
4273: 'CASH',
4274: catv.trx_type),

Line 4337: FROM ce_available_transactions_tmp catv

4333: CE_AUTO_BANK_MATCH.trx_org_id,
4334: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id,
4335: CE_AUTO_BANK_MATCH.gt_seq_id
4336: --FROM ce_200_transactions_v catv
4337: FROM ce_available_transactions_tmp catv
4338: WHERE catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4339: AND catv.org_id = nvl(CE_AUTO_BANK_REC.G_org_id, catv.org_id)
4340: --AND catv.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
4341: AND catv.check_number =

Line 4391: FROM ce_available_transactions_tmp catv

4387: CE_AUTO_BANK_MATCH.trx_org_id,
4388: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id,
4389: CE_AUTO_BANK_MATCH.gt_seq_id
4390: --FROM ce_200_transactions_v catv
4391: FROM ce_available_transactions_tmp catv
4392: WHERE catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4393: --AND catv.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
4394: AND catv.org_id = nvl(CE_AUTO_BANK_REC.G_org_id,catv.org_id)
4395: AND catv.trx_number =

Line 4557: FROM ce_available_transactions_tmp catv

4553: catv.exchange_rate_date,
4554: catv.exchange_rate_type,
4555: catv.seq_id
4556: --FROM ce_260_transactions_v catv
4557: FROM ce_available_transactions_tmp catv
4558: WHERE catv.trx_id <> CE_AUTO_BANK_MATCH.csl_statement_line_id
4559: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4560: AND nvl(catv.trx_number, '-99999') =
4561: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '-99999')

Line 4621: FROM ce_available_transactions_tmp v, ce_available_transactions_tmp catv

4617: v.org_id,
4618: v.CE_BANK_ACCT_USE_ID,
4619: v.seq_id
4620: --FROM ce_222_transactions_v v, ce_260_transactions_v catv
4621: FROM ce_available_transactions_tmp v, ce_available_transactions_tmp catv
4622: WHERE catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4623: AND nvl(catv.trx_number, '-99999') =
4624: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number,'-99999')
4625: AND (nvl(catv.invoice_text, '-99999') =

Line 4722: FROM ce_available_transactions_tmp v, ce_available_transactions_tmp catv

4718: v.org_id,
4719: v.CE_BANK_ACCT_USE_ID,
4720: v.seq_id
4721: --FROM ce_222_transactions_v v, ce_260_transactions_v catv
4722: FROM ce_available_transactions_tmp v, ce_available_transactions_tmp catv
4723: WHERE catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4724: AND nvl(catv.trx_number, '-99999') =
4725: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number,'-99999')
4726: AND (nvl(catv.invoice_text, '-99999') =

Line 4810: FROM ce_available_transactions_tmp v2, ce_available_transactions_tmp catv

4806: v2.org_id,
4807: v2.CE_BANK_ACCT_USE_ID,
4808: v2.seq_id
4809: --FROM ce_200_transactions_v v2, ce_260_transactions_v catv
4810: FROM ce_available_transactions_tmp v2, ce_available_transactions_tmp catv
4811: WHERE catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4812: AND nvl(catv.trx_number, '-99999') =
4813: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number,'-99999')
4814: AND (nvl(catv.invoice_text, '-99999') =

Line 5287: FROM ce_available_transactions_tmp v, gl_daily_conversion_types glcc,

5283: v.org_id,
5284: v.CE_BANK_ACCT_USE_ID,
5285: v.seq_id
5286: --FROM ce_222_transactions_v v, gl_daily_conversion_types glcc,
5287: FROM ce_available_transactions_tmp v, gl_daily_conversion_types glcc,
5288: ar_cash_receipt_history_all ar, ce_statement_headers h,
5289: ce_statement_reconcils_all r, ce_statement_lines l
5290: WHERE h.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
5291: AND nvl(l.bank_trx_number,'-9999') =

Line 5402: FROM ce_available_transactions_tmp v2, gl_daily_conversion_types glcc,

5398: v2.org_id,
5399: v2.CE_BANK_ACCT_USE_ID,
5400: v2.seq_id
5401: --FROM ce_200_transactions_v v2, gl_daily_conversion_types glcc,
5402: FROM ce_available_transactions_tmp v2, gl_daily_conversion_types glcc,
5403: ce_statement_headers h,
5404: ce_statement_reconcils_all r, ce_statement_lines l
5405: WHERE h.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
5406: AND nvl(l.bank_trx_number,'-9999') =

Line 6446: from ce_available_transactions_tmp

6442: begin
6443: select 'Y'
6444: into misc_exists
6445: --from ce_222_transactions_v
6446: from ce_available_transactions_tmp
6447: where trx_number = CE_AUTO_BANK_MATCH.csl_bank_trx_number || '/NSF'
6448: and trx_type = 'MISC'
6449: and rownum = 1
6450: and application_id = 222

Line 7608: FROM ce_available_transactions_tmp catv

7604: CE_AUTO_BANK_MATCH.trx_exchange_rate_type,
7605: CE_AUTO_BANK_MATCH.trx_legal_entity_id,
7606: CE_AUTO_BANK_MATCH.gt_seq_id
7607: --FROM ce_260_cf_transactions_v catv
7608: FROM ce_available_transactions_tmp catv
7609: WHERE catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
7610: AND catv.TRX_ID = CE_AUTO_BANK_MATCH.csl_cashflow_id
7611: AND catv.legal_entity_id = nvl(CE_AUTO_BANK_REC.G_legal_entity_id,catv.legal_entity_id)
7612: AND catv.application_id = 261

Line 7700: -- update the reconciled_status_flag of the GT table, ce_available_transactions_tmp,

7696: X_reversed_receipt_flag => CE_AUTO_BANK_MATCH.reversed_receipt_flag);
7697:
7698: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
7699:
7700: -- update the reconciled_status_flag of the GT table, ce_available_transactions_tmp,
7701: -- to 'Y'
7702: update_gt_reconciled_status (CE_AUTO_BANK_MATCH.gt_seq_id, 'Y');
7703:
7704: ELSE

Line 7742: | populate ce_available_transactions_tmp for auto reconciliation |

7738: | PUBLIC PROCEDURE |
7739: | populate_available_gt |
7740: | |
7741: | DESCRIPTION |
7742: | populate ce_available_transactions_tmp for auto reconciliation |
7743: | |
7744: | CALLED BY |
7745: | match_process |
7746: | |

Line 7768: delete ce_available_transactions_tmp;

7764: BEGIN
7765: cep_standard.debug('>>CE_AUTO_BANK_MATCH.populate_available_gt');
7766:
7767: -- clean up the temp table
7768: delete ce_available_transactions_tmp;
7769:
7770: -- first check if there's any stmt line that has cashflow_id
7771: -- if so, populate from ce_260_cf_transactions_v,
7772: -- this is because in autoreconciliation, if a line has cashflow_id,

Line 7786: insert into ce_available_transactions_tmp

7782:
7783: IF l_cf > 0 THEN -- some line has cashflow_id
7784: IF CE_AUTO_BANK_MATCH.av_260_cf_inserted_flag = 'N' THEN
7785: cep_standard.debug('inserting data from ce_260_cf_transactions_v');
7786: insert into ce_available_transactions_tmp
7787: (seq_id,
7788: ROW_ID,
7789: MULTI_SELECT,
7790: BANK_ACCOUNT_ID,

Line 7962: insert into ce_available_transactions_tmp

7958: IF CE_AUTO_BANK_MATCH.av_200_inserted_flag = 'N' THEN -- AP data has not been inserted into the GT table
7959:
7960: cep_standard.debug('inserting data from ce_200_transactions_v');
7961:
7962: insert into ce_available_transactions_tmp
7963: (seq_id,
7964: ROW_ID,
7965: MULTI_SELECT,
7966: BANK_ACCOUNT_ID,

Line 8112: insert into ce_available_transactions_tmp

8108:
8109: IF CE_AUTO_BANK_MATCH.av_222_inserted_flag = 'N' THEN -- AP data has not been inserted into the GT table
8110: cep_standard.debug('inserting data from ce_222_transactions_v');
8111:
8112: insert into ce_available_transactions_tmp
8113: (seq_id,
8114: ROW_ID,
8115: MULTI_SELECT,
8116: BANK_ACCOUNT_ID,

Line 8264: insert into ce_available_transactions_tmp

8260: IF av_260_inserted_flag = 'N' THEN
8261:
8262: cep_standard.debug('inserting data from ce_260_transactions_v');
8263:
8264: insert into ce_available_transactions_tmp
8265: (seq_id,
8266: ROW_ID,
8267: MULTI_SELECT,
8268: BANK_ACCOUNT_ID,

Line 8417: insert into ce_available_transactions_tmp

8413: END IF;
8414: */
8415: IF CE_AUTO_BANK_MATCH.av_260_cf_inserted_flag = 'N' THEN
8416: cep_standard.debug('inserting data from ce_260_cf_transactions_v');
8417: insert into ce_available_transactions_tmp
8418: (seq_id,
8419: ROW_ID,
8420: MULTI_SELECT,
8421: BANK_ACCOUNT_ID,

Line 8578: insert into ce_available_transactions_tmp

8574: IF CE_AUTO_BANK_MATCH.av_101_inserted_flag = 'N' THEN
8575:
8576: cep_standard.debug('inserting data from ce_101_transactions_v');
8577:
8578: insert into ce_available_transactions_tmp
8579: (seq_id,
8580: ROW_ID,
8581: MULTI_SELECT,
8582: BANK_ACCOUNT_ID,

Line 8733: insert into ce_available_transactions_tmp

8729: IF CE_AUTO_BANK_MATCH.av_999_inserted_flag = 'N' THEN
8730:
8731: cep_standard.debug('inserting data from ce_999_transactions_v');
8732:
8733: insert into ce_available_transactions_tmp
8734: (seq_id,
8735: ROW_ID,
8736: MULTI_SELECT,
8737: BANK_ACCOUNT_ID,

Line 8882: insert into ce_available_transactions_tmp

8878: ELSIF l_trx_source = 'PAY' THEN
8879: IF CE_AUTO_BANK_MATCH.av_801_inserted_flag = 'N' THEN
8880: cep_standard.debug('inserting data from ce_801_transactions_v');
8881:
8882: insert into ce_available_transactions_tmp
8883: (seq_id,
8884: ROW_ID,
8885: MULTI_SELECT,
8886: BANK_ACCOUNT_ID,

Line 9031: insert into ce_available_transactions_tmp

9027: ELSIF l_trx_source = 'PAY_EFT' THEN
9028: IF CE_AUTO_BANK_MATCH.av_801_eft_inserted_flag = 'N' THEN
9029: cep_standard.debug('inserting data from ce_801_eft_transactions_v');
9030:
9031: insert into ce_available_transactions_tmp
9032: (seq_id,
9033: ROW_ID,
9034: MULTI_SELECT,
9035: BANK_ACCOUNT_ID,

Line 9181: insert into ce_available_transactions_tmp

9177: IF l_trx_type IN ('MISC_CREDIT', 'MISC_DEBIT') THEN
9178: IF l_matching_against IN ('STMT', 'MS', 'SM') THEN
9179: IF CE_AUTO_BANK_MATCH.av_260_inserted_flag = 'N' THEN
9180: cep_standard.debug('inserting data from ce_260_transactions_v');
9181: insert into ce_available_transactions_tmp
9182: (seq_id,
9183: ROW_ID,
9184: MULTI_SELECT,
9185: BANK_ACCOUNT_ID,

Line 9337: insert into ce_available_transactions_tmp

9333:
9334: IF l_matching_against IN ('MISC', 'MS', 'SM') THEN
9335: IF CE_AUTO_BANK_MATCH.av_222_inserted_flag = 'N' THEN
9336: cep_standard.debug('inserting data from ce_222_transactions_v');
9337: insert into ce_available_transactions_tmp
9338: (seq_id,
9339: ROW_ID,
9340: MULTI_SELECT,
9341: BANK_ACCOUNT_ID,

Line 9487: insert into ce_available_transactions_tmp

9483: ELSIF l_trx_type IN ('REJECTED', 'NSF') THEN
9484: IF CE_AUTO_BANK_MATCH.av_222_inserted_flag = 'N' THEN
9485: cep_standard.debug('inserting data from ce_222_transactions_v');
9486:
9487: insert into ce_available_transactions_tmp
9488: (seq_id,
9489: ROW_ID,
9490: MULTI_SELECT,
9491: BANK_ACCOUNT_ID,

Line 9650: | ce_available_transactions_tmp |

9646: | update_gt_reconciled_status |
9647: | |
9648: | DESCRIPTION |
9649: | update the reconciled_status_flag of table |
9650: | ce_available_transactions_tmp |
9651: | |
9652: | CALLED BY |
9653: | match_process |
9654: | match_stmt_line_JE |

Line 9665: update ce_available_transactions_tmp

9661: --------------------------------------------------------------------- */
9662: PROCEDURE update_gt_reconciled_status(p_seq_id NUMBER,
9663: p_status VARCHAR2) IS
9664: BEGIN
9665: update ce_available_transactions_tmp
9666: set reconciled_status_flag = p_status
9667: where seq_id = p_seq_id;
9668: EXCEPTION
9669: WHEN OTHERS THEN

Line 9681: | ce_available_transactions_tmp |

9677: | update_gt_reconciled_status |
9678: | |
9679: | DESCRIPTION |
9680: | update the reconciled_status_flag of table |
9681: | ce_available_transactions_tmp |
9682: | mainly used to update the status to 'N' during unreconciliation |
9683: | |
9684: | CALLED BY |
9685: | CE_AUTO_BANK_CLEAR1.unclear_process |

Line 9694: update ce_available_transactions_tmp

9690: PROCEDURE update_gt_reconciled_status(p_application_id NUMBER,
9691: p_trx_id NUMBER,
9692: p_reconciled_status VARCHAR2) IS
9693: BEGIN
9694: update ce_available_transactions_tmp
9695: set reconciled_status_flag = p_reconciled_status
9696: where application_id = p_application_id
9697: and trx_id = p_trx_id;
9698: EXCEPTION

Line 9710: | ce_available_transactions_tmp |

9706: | update_gt_reconciled_status |
9707: | |
9708: | DESCRIPTION |
9709: | update the reconciled_status_flag of table |
9710: | ce_available_transactions_tmp |
9711: | mainly used to update the status to 'N' during |
9712: | auto unreconciliation |
9713: | |
9714: | CALLED BY |

Line 9722: update ce_available_transactions_tmp

9718: | 11-MAY-2006 Xin Wang Created |
9719: --------------------------------------------------------------------- */
9720: PROCEDURE update_gt_reconciled_status(p_reconciled_status VARCHAR2) IS
9721: BEGIN
9722: update ce_available_transactions_tmp
9723: set reconciled_status_flag = p_reconciled_status;
9724: EXCEPTION
9725: WHEN OTHERS THEN
9726: cep_standard.debug('EXCEPTION: update_gt_reconciled_status');

Line 10250: -- update the ce_available_transactions_tmp.reconciled_status_flag

10246:
10247: CE_AUTO_BANK_CLEAR.reconcile_process;
10248:
10249: -- after a match and reconcilation,
10250: -- update the ce_available_transactions_tmp.reconciled_status_flag
10251: IF (CE_AUTO_BANK_MATCH.gt_seq_id is not null) AND
10252: (CE_AUTO_BANK_MATCH.gt_seq_id <> -1) THEN
10253: update_gt_reconciled_status (CE_AUTO_BANK_MATCH.gt_seq_id, 'Y');
10254: --update ce_available_transactions_tmp

Line 10254: --update ce_available_transactions_tmp

10250: -- update the ce_available_transactions_tmp.reconciled_status_flag
10251: IF (CE_AUTO_BANK_MATCH.gt_seq_id is not null) AND
10252: (CE_AUTO_BANK_MATCH.gt_seq_id <> -1) THEN
10253: update_gt_reconciled_status (CE_AUTO_BANK_MATCH.gt_seq_id, 'Y');
10254: --update ce_available_transactions_tmp
10255: --set reconciled_status_flag = 'Y'
10256: --where seq_id = CE_AUTO_BANK_MATCH.gt_seq_id;
10257: END IF;
10258:

Line 10261: --update ce_available_transactions_tmp

10257: END IF;
10258:
10259: IF CE_AUTO_BANK_MATCH.gt_seq_id2 is not null THEN
10260: update_gt_reconciled_status (CE_AUTO_BANK_MATCH.gt_seq_id2, 'Y');
10261: --update ce_available_transactions_tmp
10262: --set reconciled_status_flag = 'Y'
10263: --where seq_id = CE_AUTO_BANK_MATCH.gt_seq_id2;
10264: END IF;
10265: