APPS.CE_AUTO_BANK_MATCH dependencies on ARP_CASHBOOK

Line 199: AND rec.reference_type(+) = decode(arp_cashbook.receipt_debit_memo_reversed(crh.cash_receipt_id), 'Y', 'DM REVERSAL', 'RECEIPT')

195: ce_statement_reconcils_all rec
196: WHERE cr.cash_receipt_id = crh.cash_receipt_id
197: AND crh.rowid = trx_rowid
198: AND rec.reference_id(+) = crh.cash_receipt_history_id
199: AND rec.reference_type(+) = decode(arp_cashbook.receipt_debit_memo_reversed(crh.cash_receipt_id), 'Y', 'DM REVERSAL', 'RECEIPT')
200: AND NVL(rec.status_flag,X_call_mode) = X_call_mode
201: AND NVL(rec.current_record_flag,'Y') = 'Y'
202: FOR UPDATE OF crh.cash_receipt_history_id,
203: cr.cash_receipt_id NOWAIT;

Line 6028: ARP_CASHBOOK.unclear(

6024: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_MATCH.stmtline_match');
6025:
6026: elsif CE_AUTO_BANK_MATCH.csl_match_type = 'RECEIPT' then
6027:
6028: ARP_CASHBOOK.unclear(
6029: p_cr_id => CE_AUTO_BANK_MATCH.trx_cash_receipt_id,
6030: p_trx_date => CE_AUTO_BANK_MATCH.trx_date,
6031: p_gl_date => CE_AUTO_BANK_REC.G_gl_date,
6032: p_actual_value_date => CE_AUTO_BANK_MATCH.csl_effective_date,

Line 6276: ARP_CASHBOOK.unclear(

6272: X_REQUEST_ID => to_number(NULL),
6273: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_MATCH.stmtline_match');
6274:
6275: elsif (loc_match_type = 'RECEIPT') then
6276: ARP_CASHBOOK.unclear(
6277: p_cr_id => loc_cash_receipt_id,
6278: p_trx_date => loc_trx_date,
6279: p_gl_date => CE_AUTO_BANK_REC.G_gl_date,
6280: p_actual_value_date => CE_AUTO_BANK_MATCH.csl_effective_date,

Line 10429: -- If Atleast one receipt was cleared during the autoreconciliation process, call the AR API ARP_CASHBOOK.refresh_risk_value

10425: END LOOP;
10426: CLOSE r_branch_cursor;
10427:
10428: -- Bug 16298972 Start
10429: -- If Atleast one receipt was cleared during the autoreconciliation process, call the AR API ARP_CASHBOOK.refresh_risk_value
10430: cep_standard.debug('CE_AUTO_BANK_CLEAR1.G_RECEIPT_PROCESSED_FLAG = ' || CASE WHEN CE_AUTO_BANK_CLEAR1.G_RECEIPT_PROCESSED_FLAG THEN 'TRUE' ELSE 'FALSE' END);
10431:
10432: IF CE_AUTO_BANK_CLEAR1.G_RECEIPT_PROCESSED_FLAG THEN
10433: cep_standard.debug('Calling AR API ARP_CASHBOOK.refresh_risk_value for Autorecon.');

Line 10433: cep_standard.debug('Calling AR API ARP_CASHBOOK.refresh_risk_value for Autorecon.');

10429: -- If Atleast one receipt was cleared during the autoreconciliation process, call the AR API ARP_CASHBOOK.refresh_risk_value
10430: cep_standard.debug('CE_AUTO_BANK_CLEAR1.G_RECEIPT_PROCESSED_FLAG = ' || CASE WHEN CE_AUTO_BANK_CLEAR1.G_RECEIPT_PROCESSED_FLAG THEN 'TRUE' ELSE 'FALSE' END);
10431:
10432: IF CE_AUTO_BANK_CLEAR1.G_RECEIPT_PROCESSED_FLAG THEN
10433: cep_standard.debug('Calling AR API ARP_CASHBOOK.refresh_risk_value for Autorecon.');
10434: ARP_CASHBOOK.refresh_risk_value;
10435: cep_standard.debug('Call to AR API ARP_CASHBOOK.refresh_risk_value ended successfully.');
10436: END IF;
10437: -- Bug 16298972 End

Line 10434: ARP_CASHBOOK.refresh_risk_value;

10430: cep_standard.debug('CE_AUTO_BANK_CLEAR1.G_RECEIPT_PROCESSED_FLAG = ' || CASE WHEN CE_AUTO_BANK_CLEAR1.G_RECEIPT_PROCESSED_FLAG THEN 'TRUE' ELSE 'FALSE' END);
10431:
10432: IF CE_AUTO_BANK_CLEAR1.G_RECEIPT_PROCESSED_FLAG THEN
10433: cep_standard.debug('Calling AR API ARP_CASHBOOK.refresh_risk_value for Autorecon.');
10434: ARP_CASHBOOK.refresh_risk_value;
10435: cep_standard.debug('Call to AR API ARP_CASHBOOK.refresh_risk_value ended successfully.');
10436: END IF;
10437: -- Bug 16298972 End
10438:

Line 10435: cep_standard.debug('Call to AR API ARP_CASHBOOK.refresh_risk_value ended successfully.');

10431:
10432: IF CE_AUTO_BANK_CLEAR1.G_RECEIPT_PROCESSED_FLAG THEN
10433: cep_standard.debug('Calling AR API ARP_CASHBOOK.refresh_risk_value for Autorecon.');
10434: ARP_CASHBOOK.refresh_risk_value;
10435: cep_standard.debug('Call to AR API ARP_CASHBOOK.refresh_risk_value ended successfully.');
10436: END IF;
10437: -- Bug 16298972 End
10438:
10439: cep_standard.debug('========== END MATCHING ========== ');