APPS.ARP_PAY_REL_CUST_PKG dependencies on AR_POTENTIAL_CUSTOMERS_GT

Line 25: | This procedure populates the ar_potential_customers_gt |

21: | PUBLIC PROCEDURE |
22: | build_for_automatch() |
23: | |
24: | DESCRIPTION |
25: | This procedure populates the ar_potential_customers_gt |
26: | table for each worker of the receipt automatch feature.
27: | It uses the list of receipts in ar_cash_remit_refs_interim and
28: | collects all related customers for
29: | the intended receipts.

Line 110: 'INSERT INTO ar_potential_customers_gt' || CRLF ||

106:
107: /* l_ins_sql is the full insert with all of the UNION clauses
108: appended */
109: l_ins_sql :=
110: 'INSERT INTO ar_potential_customers_gt' || CRLF ||
111: ' (cust_account_id, related_cust_account_id)' || CRLF ||
112: 'SELECT distinct customer_id, customer_id' || CRLF ||
113: 'FROM ar_cash_remit_refs_interim' || CRLF ||
114: 'WHERE customer_id IS NOT NULL' || CRLF ||

Line 258: | This procedure populates the ar_potential_customers_gt |

254: | PUBLIC PROCEDURE |
255: | build_for_lockbox() |
256: | |
257: | DESCRIPTION |
258: | This procedure populates the ar_potential_customers_gt |
259: | table for specific lockbox runs. It uses the list of customers
260: | in ar_payments_interface and collects all related customers for
261: | the intended receipts.
262: | |

Line 350: 'INSERT INTO ar_potential_customers_gt' || CRLF ||

346:
347: /* l_ins_sql is the full insert with all of the UNION clauses
348: appended */
349: l_ins_sql :=
350: 'INSERT INTO ar_potential_customers_gt' || CRLF ||
351: ' (cust_account_id, related_cust_account_id)' || CRLF ||
352: 'SELECT distinct customer_id, customer_id' || CRLF ||
353: 'FROM ar_payments_interface' || CRLF ||
354: 'WHERE customer_id IS NOT NULL' || CRLF ||

Line 504: | This procedure populates the ar_potential_customers_gt |

500: | PUBLIC PROCEDURE |
501: | build_for_app_lov() |
502: | |
503: | DESCRIPTION |
504: | This procedure populates the ar_potential_customers_gt |
505: | table for specific customers. It takes the current receipt
506: | customer and apply_date and collects all related customers for
507: | the intended receipt.
508: |

Line 574: from ar_potential_customers_gt

570: the table */
571: BEGIN
572: select 'found'
573: into l_is_cust_there
574: from ar_potential_customers_gt
575: where cust_account_id = p_customer_id;
576:
577: IF PG_DEBUG in ('Y','C') THEN
578: arp_debug.debug(' Customer already loaded');

Line 609: 'INSERT INTO ar_potential_customers_gt' || CRLF ||

605:
606: /* l_ins_sql is the full insert with all of the UNION
607: clauses appended */
608: l_ins_sql :=
609: 'INSERT INTO ar_potential_customers_gt' || CRLF ||
610: ' (cust_account_id, related_cust_account_id)' || CRLF ||
611: 'SELECT :customer_id1, :customer_id2' || CRLF ||
612: 'FROM dual' || CRLF ||
613: 'UNION ' || CRLF ||

Line 752: delete from ar_potential_customers_gt;

748: IF PG_DEBUG in ('Y','C') THEN
749: arp_debug.debug('arp_pay_rel_cust_pkg.clear_table()+');
750: END IF;
751:
752: delete from ar_potential_customers_gt;
753:
754: IF PG_DEBUG in ('Y','C') THEN
755: arp_debug.debug('arp_pay_rel_cust_pkg.clear_table()-');
756: END IF;