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 355: -- bug 5350073 ce_available_transactions_tmp is not populated when manually reconcile IBY batches

351: b.rowid = trx_rowid
352: AND nvl(c.status_lookup_code, 'NEGOTIABLE') <> 'VOIDED'
353: FOR UPDATE OF c.check_id, b.checkrun_id NOWAIT;*/
354:
355: -- bug 5350073 ce_available_transactions_tmp is not populated when manually reconcile IBY batches
356: CURSOR CHECK_AMOUNTS (X_batch_id NUMBER) IS
357: SELECT SUM(bank_account_amount)
358: FROM CE_200_TRANSACTIONS_V
359: --FROM ce_available_transactions_tmp

Line 359: --FROM ce_available_transactions_tmp

355: -- bug 5350073 ce_available_transactions_tmp is not populated when manually reconcile IBY batches
356: CURSOR CHECK_AMOUNTS (X_batch_id NUMBER) IS
357: SELECT SUM(bank_account_amount)
358: FROM CE_200_TRANSACTIONS_V
359: --FROM ce_available_transactions_tmp
360: WHERE batch_id = X_batch_id
361: AND nvl(status, 'NEGOTIABLE') <> 'VOIDED'
362: AND application_id = 200;
363: --AND NVL(reconciled_status_flag, 'N') = 'N';

Line 811: FROM ce_available_transactions_tmp catv

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

Line 879: FROM ce_available_transactions_tmp catv

875: CE_AUTO_BANK_MATCH.trx_legal_entity_id,
876: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id,
877: CE_AUTO_BANK_MATCH.gt_seq_id
878: --FROM ce_999_transactions_v catv
879: FROM ce_available_transactions_tmp catv
880: WHERE catv.trx_type = tx_type
881: --AND catv.org_id = CE_AUTO_BANK_REC.G_org_id
882: --AND catv.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
883: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id

Line 1660: FROM ce_available_transactions_tmp catv

1656: catv.deposit_date,
1657: catv.legal_entity_id,
1658: catv.seq_id
1659: --FROM ce_260_cf_transactions_v catv
1660: FROM ce_available_transactions_tmp catv
1661: WHERE catv.trx_type = tx_type
1662: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
1663: AND catv.legal_entity_id = nvl(CE_AUTO_BANK_REC.G_legal_entity_id , catv.legal_entity_id)
1664: --AND catv.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id

Line 1694: FROM ce_available_transactions_tmp catv

1690: catv.deposit_date,
1691: catv.legal_entity_id,
1692: catv.seq_id
1693: --FROM ce_260_cf_transactions_v catv
1694: FROM ce_available_transactions_tmp catv
1695: WHERE catv.trx_type = tx_type
1696: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
1697: AND catv.legal_entity_id = nvl(CE_AUTO_BANK_REC.G_legal_entity_id, catv.legal_entity_id)
1698: --AND catv.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id

Line 1731: FROM ce_available_transactions_tmp catv

1727: catv.deposit_date,
1728: catv.legal_entity_id,
1729: catv.seq_id
1730: --FROM ce_260_cf_transactions_v catv
1731: FROM ce_available_transactions_tmp catv
1732: WHERE catv.trx_type = tx_type
1733: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
1734: --AND catv.legal_entity_id = CE_AUTO_BANK_REC.G_legal_entity_id
1735: --AND catv.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id

Line 2030: FROM ce_available_transactions_tmp catv

2026: CE_AUTO_BANK_MATCH.trx_group,
2027: CE_AUTO_BANK_MATCH.trx_org_id,
2028: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id
2029: --FROM ce_801_EFT_transactions_v catv
2030: FROM ce_available_transactions_tmp catv
2031: WHERE ltrim(upper(catv.batch_name)) =
2032: ltrim(upper(CE_AUTO_BANK_MATCH.csl_bank_trx_number))
2033: AND catv.trx_date = CE_AUTO_BANK_MATCH.csl_trx_date
2034: AND catv.org_id = nvl(CE_AUTO_BANK_REC.G_org_id, catv.org_id)

Line 2793: ce_available_transactions_tmp catv

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

Line 2821: ce_available_transactions_tmp catv

2817: no_of_currencies_ce,
2818: trx_curr_amount_ce,
2819: CE_AUTO_BANK_MATCH.csl_match_type
2820: FROM
2821: ce_available_transactions_tmp catv
2822: -- ce_260_cf_transactions_v catv
2823: WHERE
2824: catv.batch_id = CE_AUTO_BANK_MATCH.trx_id
2825: AND nvl(catv.status, 'CANCELED') <> 'CANCELED'

Line 3104: FROM ce_available_transactions_tmp catv

3100: CE_AUTO_BANK_MATCH.trx_cleared_amount,
3101: no_of_currencies,
3102: CE_AUTO_BANK_MATCH.trx_curr_amount,
3103: CE_AUTO_BANK_MATCH.csl_match_type
3104: FROM ce_available_transactions_tmp catv
3105: WHERE catv.batch_id = CE_AUTO_BANK_MATCH.trx_id
3106: AND nvl(catv.status, 'NEGOTIABLE') <> 'VOIDED'
3107: AND catv.application_id = 200
3108: AND NVL(catv.reconciled_status_flag, 'N') = 'N'

Line 3985: ce_available_transactions_tmp catv

3981: CE_AUTO_BANK_MATCH.gt_seq_id
3982:
3983: FROM
3984: -- ce_801_transactions_v catv
3985: ce_available_transactions_tmp catv
3986: WHERE
3987: catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
3988: AND catv.bank_account_amount = CE_AUTO_BANK_MATCH.csl_amount
3989: AND catv.org_id = nvl(CE_AUTO_BANK_REC.G_org_id, catv.org_id)

Line 4042: ce_available_transactions_tmp catv

4038: CE_AUTO_BANK_MATCH.trx_exchange_rate_type,
4039: CE_AUTO_BANK_MATCH.gt_seq_id
4040: FROM
4041: -- ce_101_transactions_v catv
4042: ce_available_transactions_tmp catv
4043: WHERE
4044: catv.trx_type = tx_type
4045: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4046: /* Bug 11727491 Added Ltrm(rtrim.. */

Line 4110: ce_available_transactions_tmp catv

4106: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id,
4107: CE_AUTO_BANK_MATCH.gt_seq_id
4108: FROM
4109: -- ce_185_transactions_v catv
4110: ce_available_transactions_tmp catv
4111: WHERE
4112: catv.trx_type = tx_type
4113: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4114: --8978548: changed the NVL clause to use catv.legal_enity_id if null

Line 4177: ce_available_transactions_tmp catv

4173: CE_AUTO_BANK_MATCH.trx_legal_entity_id,
4174: CE_AUTO_BANK_MATCH.gt_seq_id
4175: FROM
4176: -- ce_999_transactions_v catv
4177: ce_available_transactions_tmp catv
4178: WHERE
4179: catv.trx_type = tx_type
4180: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4181: AND catv.trx_number = CE_AUTO_BANK_MATCH.csl_bank_trx_number

Line 4364: ce_available_transactions_tmp catv

4360: catv.CE_BANK_ACCT_USE_ID,
4361: catv.seq_id
4362: FROM
4363: -- ce_222_transactions_v catv
4364: ce_available_transactions_tmp catv
4365: WHERE
4366: DECODE(tx_type,'CASH',DECODE(catv.trx_type,'MISC','CASH',catv.trx_type),catv.trx_type) = tx_type
4367: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4368: AND catv.org_id = nvl(CE_AUTO_BANK_REC.G_org_id, catv.org_id)

Line 4425: ce_available_transactions_tmp catv

4421: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id,
4422: CE_AUTO_BANK_MATCH.gt_seq_id
4423: FROM
4424: -- ce_222_transactions_v catv
4425: ce_available_transactions_tmp catv
4426: WHERE
4427: DECODE(tx_type,'CASH',DECODE(catv.trx_type,'MISC','CASH',catv.trx_type),catv.trx_type) = tx_type
4428: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4429: AND catv.org_id = nvl(CE_AUTO_BANK_REC.G_org_id, catv.org_id)

Line 4499: ce_available_transactions_tmp catv

4495: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id,
4496: CE_AUTO_BANK_MATCH.gt_seq_id
4497: FROM
4498: --ce_200_transactions_v catv
4499: ce_available_transactions_tmp catv
4500: WHERE
4501: catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4502: AND catv.check_number = to_number(LTRIM(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '0'))
4503: AND catv.application_id = 200

Line 4555: ce_available_transactions_tmp catv

4551: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id,
4552: CE_AUTO_BANK_MATCH.gt_seq_id
4553: FROM
4554: --ce_200_transactions_v catv
4555: ce_available_transactions_tmp catv
4556: WHERE
4557: catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4558: AND catv.org_id = CE_AUTO_BANK_REC.G_org_id
4559: AND catv.check_number = to_number(LTRIM(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '0'))

Line 4616: ce_available_transactions_tmp catv

4612: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id,
4613: CE_AUTO_BANK_MATCH.gt_seq_id
4614: FROM
4615: -- ce_200_transactions_v catv
4616: ce_available_transactions_tmp catv
4617: WHERE
4618: catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4619: AND catv.org_id = nvl(CE_AUTO_BANK_REC.G_org_id,catv.org_id)
4620: AND catv.trx_number = LTRIM(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '0')

Line 4804: FROM ce_available_transactions_tmp catv

4800: catv.exchange_rate_date,
4801: catv.exchange_rate_type,
4802: catv.seq_id
4803: --FROM ce_260_transactions_v catv
4804: FROM ce_available_transactions_tmp catv
4805: WHERE catv.trx_id <> CE_AUTO_BANK_MATCH.csl_statement_line_id
4806: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4807: AND nvl(catv.trx_number, '-99999') =
4808: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '-99999')

Line 4868: FROM ce_available_transactions_tmp v, ce_available_transactions_tmp catv

4864: v.org_id,
4865: v.CE_BANK_ACCT_USE_ID,
4866: v.seq_id
4867: --FROM ce_222_transactions_v v, ce_260_transactions_v catv
4868: FROM ce_available_transactions_tmp v, ce_available_transactions_tmp catv
4869: WHERE catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4870: AND nvl(catv.trx_number, '-99999') =
4871: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number,'-99999')
4872: AND (nvl(catv.invoice_text, '-99999') =

Line 4969: FROM ce_available_transactions_tmp v, ce_available_transactions_tmp catv

4965: v.org_id,
4966: v.CE_BANK_ACCT_USE_ID,
4967: v.seq_id
4968: --FROM ce_222_transactions_v v, ce_260_transactions_v catv
4969: FROM ce_available_transactions_tmp v, ce_available_transactions_tmp catv
4970: WHERE catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4971: AND nvl(catv.trx_number, '-99999') =
4972: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number,'-99999')
4973: AND (nvl(catv.invoice_text, '-99999') =

Line 5057: FROM ce_available_transactions_tmp v2, ce_available_transactions_tmp catv

5053: v2.org_id,
5054: v2.CE_BANK_ACCT_USE_ID,
5055: v2.seq_id
5056: --FROM ce_200_transactions_v v2, ce_260_transactions_v catv
5057: FROM ce_available_transactions_tmp v2, ce_available_transactions_tmp catv
5058: WHERE catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
5059: AND nvl(catv.trx_number, '-99999') =
5060: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number,'-99999')
5061: AND (nvl(catv.invoice_text, '-99999') =

Line 5534: FROM ce_available_transactions_tmp v, gl_daily_conversion_types glcc,

5530: v.org_id,
5531: v.CE_BANK_ACCT_USE_ID,
5532: v.seq_id
5533: --FROM ce_222_transactions_v v, gl_daily_conversion_types glcc,
5534: FROM ce_available_transactions_tmp v, gl_daily_conversion_types glcc,
5535: ar_cash_receipt_history_all ar, ce_statement_headers h,
5536: ce_statement_reconcils_all r, ce_statement_lines l
5537: WHERE h.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
5538: AND nvl(l.bank_trx_number,'-9999') =

Line 5649: FROM ce_available_transactions_tmp v2, gl_daily_conversion_types glcc,

5645: v2.org_id,
5646: v2.CE_BANK_ACCT_USE_ID,
5647: v2.seq_id
5648: --FROM ce_200_transactions_v v2, gl_daily_conversion_types glcc,
5649: FROM ce_available_transactions_tmp v2, gl_daily_conversion_types glcc,
5650: ce_statement_headers h,
5651: ce_statement_reconcils_all r, ce_statement_lines l
5652: WHERE h.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
5653: AND nvl(l.bank_trx_number,'-9999') =

Line 6667: FROM ce_available_transactions_tmp

6663: BEGIN
6664: SELECT 'Y'
6665: INTO misc_exists
6666: --FROM ce_222_transactions_v
6667: FROM ce_available_transactions_tmp
6668: WHERE trx_number = CE_AUTO_BANK_MATCH.csl_bank_trx_number || '/NSF'
6669: AND trx_type = 'MISC'
6670: AND rownum = 1
6671: AND application_id = 222

Line 7797: FROM ce_available_transactions_tmp catv

7793: CE_AUTO_BANK_MATCH.trx_gl_date,
7794: CE_AUTO_BANK_MATCH.trx_value_date,
7795: CE_AUTO_BANK_MATCH.trx_deposit_date
7796: /* 14834217: End */
7797: FROM ce_available_transactions_tmp catv
7798: WHERE catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
7799: AND catv.TRX_ID = CE_AUTO_BANK_MATCH.csl_cashflow_id
7800: AND catv.legal_entity_id = nvl(CE_AUTO_BANK_REC.G_legal_entity_id,catv.legal_entity_id)
7801: AND catv.application_id = 261

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

7941: X_reversed_receipt_flag => CE_AUTO_BANK_MATCH.reversed_receipt_flag);
7942:
7943: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
7944:
7945: -- update the reconciled_status_flag of the GT table, ce_available_transactions_tmp,
7946: -- to 'Y'
7947: update_gt_reconciled_status (CE_AUTO_BANK_MATCH.gt_seq_id, 'Y');
7948:
7949: ELSE

Line 7990: | populate ce_available_transactions_tmp for auto reconciliation |

7986: | PUBLIC PROCEDURE |
7987: | populate_available_gt |
7988: | |
7989: | DESCRIPTION |
7990: | populate ce_available_transactions_tmp for auto reconciliation |
7991: | |
7992: | CALLED BY |
7993: | match_process |
7994: | |

Line 8016: delete ce_available_transactions_tmp;

8012: BEGIN
8013: cep_standard.debug('>>CE_AUTO_BANK_MATCH.populate_available_gt');
8014:
8015: -- clean up the temp table
8016: delete ce_available_transactions_tmp;
8017:
8018: -- first check if there's any stmt line that has cashflow_id
8019: -- if so, populate from ce_260_cf_transactions_v,
8020: -- this is because in autoreconciliation, if a line has cashflow_id,

Line 8034: insert into ce_available_transactions_tmp

8030:
8031: IF l_cf > 0 THEN -- some line has cashflow_id
8032: IF CE_AUTO_BANK_MATCH.av_260_cf_inserted_flag = 'N' THEN
8033: cep_standard.debug('inserting data from ce_260_cf_transactions_v');
8034: insert into ce_available_transactions_tmp
8035: (seq_id,
8036: ROW_ID,
8037: MULTI_SELECT,
8038: BANK_ACCOUNT_ID,

Line 8210: insert into ce_available_transactions_tmp

8206: IF CE_AUTO_BANK_MATCH.av_200_inserted_flag = 'N' THEN -- AP data has not been inserted into the GT table
8207:
8208: cep_standard.debug('inserting data from ce_200_transactions_v');
8209:
8210: insert into ce_available_transactions_tmp
8211: (seq_id,
8212: ROW_ID,
8213: MULTI_SELECT,
8214: BANK_ACCOUNT_ID,

Line 8360: insert into ce_available_transactions_tmp

8356:
8357: IF CE_AUTO_BANK_MATCH.av_222_inserted_flag = 'N' THEN -- AP data has not been inserted into the GT table
8358: cep_standard.debug('inserting data from ce_222_transactions_v');
8359:
8360: insert into ce_available_transactions_tmp
8361: (seq_id,
8362: ROW_ID,
8363: MULTI_SELECT,
8364: BANK_ACCOUNT_ID,

Line 8512: insert into ce_available_transactions_tmp

8508: IF av_260_inserted_flag = 'N' THEN
8509:
8510: cep_standard.debug('inserting data from ce_260_transactions_v');
8511:
8512: insert into ce_available_transactions_tmp
8513: (seq_id,
8514: ROW_ID,
8515: MULTI_SELECT,
8516: BANK_ACCOUNT_ID,

Line 8665: insert into ce_available_transactions_tmp

8661: END IF;
8662: */
8663: IF CE_AUTO_BANK_MATCH.av_260_cf_inserted_flag = 'N' THEN
8664: cep_standard.debug('inserting data from ce_260_cf_transactions_v');
8665: insert into ce_available_transactions_tmp
8666: (seq_id,
8667: ROW_ID,
8668: MULTI_SELECT,
8669: BANK_ACCOUNT_ID,

Line 8826: insert into ce_available_transactions_tmp

8822: IF CE_AUTO_BANK_MATCH.av_101_inserted_flag = 'N' THEN
8823:
8824: cep_standard.debug('inserting data from ce_101_transactions_v');
8825:
8826: insert into ce_available_transactions_tmp
8827: (seq_id,
8828: ROW_ID,
8829: MULTI_SELECT,
8830: BANK_ACCOUNT_ID,

Line 8981: insert into ce_available_transactions_tmp

8977: IF CE_AUTO_BANK_MATCH.av_999_inserted_flag = 'N' THEN
8978:
8979: cep_standard.debug('inserting data from ce_999_transactions_v');
8980:
8981: insert into ce_available_transactions_tmp
8982: (seq_id,
8983: ROW_ID,
8984: MULTI_SELECT,
8985: BANK_ACCOUNT_ID,

Line 9130: insert into ce_available_transactions_tmp

9126: ELSIF l_trx_source = 'PAY' THEN
9127: IF CE_AUTO_BANK_MATCH.av_801_inserted_flag = 'N' THEN
9128: cep_standard.debug('inserting data from ce_801_transactions_v');
9129:
9130: insert into ce_available_transactions_tmp
9131: (seq_id,
9132: ROW_ID,
9133: MULTI_SELECT,
9134: BANK_ACCOUNT_ID,

Line 9279: insert into ce_available_transactions_tmp

9275: ELSIF l_trx_source = 'PAY_EFT' THEN
9276: IF CE_AUTO_BANK_MATCH.av_801_eft_inserted_flag = 'N' THEN
9277: cep_standard.debug('inserting data from ce_801_eft_transactions_v');
9278:
9279: insert into ce_available_transactions_tmp
9280: (seq_id,
9281: ROW_ID,
9282: MULTI_SELECT,
9283: BANK_ACCOUNT_ID,

Line 9429: insert into ce_available_transactions_tmp

9425: IF l_trx_type IN ('MISC_CREDIT', 'MISC_DEBIT') THEN
9426: IF l_matching_against IN ('STMT', 'MS', 'SM') THEN
9427: IF CE_AUTO_BANK_MATCH.av_260_inserted_flag = 'N' THEN
9428: cep_standard.debug('inserting data from ce_260_transactions_v');
9429: insert into ce_available_transactions_tmp
9430: (seq_id,
9431: ROW_ID,
9432: MULTI_SELECT,
9433: BANK_ACCOUNT_ID,

Line 9585: insert into ce_available_transactions_tmp

9581:
9582: IF l_matching_against IN ('MISC', 'MS', 'SM') THEN
9583: IF CE_AUTO_BANK_MATCH.av_222_inserted_flag = 'N' THEN
9584: cep_standard.debug('inserting data from ce_222_transactions_v');
9585: insert into ce_available_transactions_tmp
9586: (seq_id,
9587: ROW_ID,
9588: MULTI_SELECT,
9589: BANK_ACCOUNT_ID,

Line 9735: insert into ce_available_transactions_tmp

9731: ELSIF l_trx_type IN ('REJECTED', 'NSF') THEN
9732: IF CE_AUTO_BANK_MATCH.av_222_inserted_flag = 'N' THEN
9733: cep_standard.debug('inserting data from ce_222_transactions_v');
9734:
9735: insert into ce_available_transactions_tmp
9736: (seq_id,
9737: ROW_ID,
9738: MULTI_SELECT,
9739: BANK_ACCOUNT_ID,

Line 9898: | ce_available_transactions_tmp |

9894: | update_gt_reconciled_status |
9895: | |
9896: | DESCRIPTION |
9897: | update the reconciled_status_flag of table |
9898: | ce_available_transactions_tmp |
9899: | |
9900: | CALLED BY |
9901: | match_process |
9902: | match_stmt_line_JE |

Line 9913: update ce_available_transactions_tmp

9909: --------------------------------------------------------------------- */
9910: PROCEDURE update_gt_reconciled_status(p_seq_id NUMBER,
9911: p_status VARCHAR2) IS
9912: BEGIN
9913: update ce_available_transactions_tmp
9914: set reconciled_status_flag = p_status
9915: where seq_id = p_seq_id;
9916: EXCEPTION
9917: WHEN OTHERS THEN

Line 9929: | ce_available_transactions_tmp |

9925: | update_gt_reconciled_status |
9926: | |
9927: | DESCRIPTION |
9928: | update the reconciled_status_flag of table |
9929: | ce_available_transactions_tmp |
9930: | mainly used to update the status to 'N' during unreconciliation |
9931: | |
9932: | CALLED BY |
9933: | CE_AUTO_BANK_CLEAR1.unclear_process |

Line 9942: update ce_available_transactions_tmp

9938: PROCEDURE update_gt_reconciled_status(p_application_id NUMBER,
9939: p_trx_id NUMBER,
9940: p_reconciled_status VARCHAR2) IS
9941: BEGIN
9942: update ce_available_transactions_tmp
9943: set reconciled_status_flag = p_reconciled_status
9944: where application_id = p_application_id
9945: and trx_id = p_trx_id;
9946: EXCEPTION

Line 9958: | ce_available_transactions_tmp |

9954: | update_gt_reconciled_status |
9955: | |
9956: | DESCRIPTION |
9957: | update the reconciled_status_flag of table |
9958: | ce_available_transactions_tmp |
9959: | mainly used to update the status to 'N' during |
9960: | auto unreconciliation |
9961: | |
9962: | CALLED BY |

Line 9970: update ce_available_transactions_tmp

9966: | 11-MAY-2006 Xin Wang Created |
9967: --------------------------------------------------------------------- */
9968: PROCEDURE update_gt_reconciled_status(p_reconciled_status VARCHAR2) IS
9969: BEGIN
9970: update ce_available_transactions_tmp
9971: set reconciled_status_flag = p_reconciled_status;
9972: EXCEPTION
9973: WHEN OTHERS THEN
9974: cep_standard.debug('EXCEPTION: update_gt_reconciled_status');

Line 10365: -- update the ce_available_transactions_tmp.reconciled_status_flag

10361:
10362: CE_AUTO_BANK_CLEAR.reconcile_process;
10363:
10364: -- after a match and reconcilation,
10365: -- update the ce_available_transactions_tmp.reconciled_status_flag
10366: IF (CE_AUTO_BANK_MATCH.gt_seq_id is not null) AND (CE_AUTO_BANK_MATCH.gt_seq_id <> -1)
10367: THEN
10368: update_gt_reconciled_status (CE_AUTO_BANK_MATCH.gt_seq_id, 'Y');
10369: END IF;