[Home] [Help]
PACKAGE: APPS.ARP_PAY_REL_CUST_PKG
Source
1 PACKAGE ARP_PAY_REL_CUST_PKG AUTHID CURRENT_USER AS
2 /* $Header: ARPRCPKS.pls 120.3 2011/04/10 07:19:01 amitshuk noship $ */
3
4 G_PAY_UNRELATED VARCHAR2(1);
5
6 /*-------------------------------------------------------------------------+
7 | PUBLIC PROCEDURE |
8 | build_for_automatch() |
9 | |
10 | DESCRIPTION |
11 | This procedure populates the ar_potential_customers_gt |
12 | table for each worker of the receipt automatch feature.
13 | It uses the list of receipts in ar_cash_remit_refs_interim and
14 | collects all related customers for
15 | the intended receipts.
16 | |
17 | Note that this routine is currently called by each worker.
18 |
19 | REQUIRES |
20 | P_WORKER_NUMBER
21 | |
22 | RETURNS |
23 | |
24 | NOTES |
25 | |
26 | EXAMPLE |
27 | |
28 | MODIFICATION HISTORY |
29 | 18-JAN-2011 M Raymond Bug 9919720 - Revised to completion.
30 |
31 +-------------------------------------------------------------------------*/
32 PROCEDURE build_for_automatch(p_worker_number IN NUMBER DEFAULT NULL);
33
34 /*-------------------------------------------------------------------------+
35 | PUBLIC PROCEDURE |
36 | build_for_lockbox() |
37 | |
38 | DESCRIPTION |
39 | This procedure populates the ar_potential_customers_gt |
40 | table for specific lockbox runs. It uses the list of customers
41 | in ar_payments_interface and collects all related customers for
42 | the intended receipts.
43 | |
44 | REQUIRES |
45 | P_TRANSMISSION_ID, P_PAYMENT_REC_TYPE, P_PAY_UNRELATED_INVOICES |
46 | |
47 | RETURNS |
48 | |
49 | NOTES |
50 | |
51 | EXAMPLE |
52 | |
53 | MODIFICATION HISTORY |
54 | 01-DEC-2010 M Raymond Bug 10146717 - Created
55 |
56 +-------------------------------------------------------------------------*/
57 PROCEDURE build_for_lockbox(
58 p_transmission_id IN VARCHAR2,
59 p_payment_rec_type IN VARCHAR2,
60 p_pay_unrelated_invoices IN VARCHAR2);
61
62 /*-------------------------------------------------------------------------+
63 | PUBLIC PROCEDURE |
64 | build_for_app_lov() |
65 | |
66 | DESCRIPTION |
67 | This procedure populates the ar_potential_customers_gt |
68 | table for specific customers. It takes the current receipt
69 | customer and apply_date and collects all related customers for
70 | the intended receipt.
71 |
72 | This routine is used by both receipt apply_to LOV and mass apply
73 | logic.
74 | |
75 | REQUIRES |
76 | P_CUSTOMER_ID, P_PAY_UNRELATED_INVOICES, P_APPLY_DATE |
77 | |
78 | RETURNS |
79 | |
80 | NOTES |
81 | |
82 | EXAMPLE |
83 | |
84 | MODIFICATION HISTORY |
85 | 01-FEB-2010 M Raymond Bug 11676945 - Created
86 |
87 +-------------------------------------------------------------------------*/
88 PROCEDURE build_for_app_lov(
89 p_customer_id IN NUMBER,
90 p_pay_unrelated_invoices IN VARCHAR2,
91 p_apply_date IN DATE);
92
93 PROCEDURE clear_table;
94
95 END ARP_PAY_REL_CUST_PKG;