[Home] [Help]
PACKAGE: APPS.AR_PUBLIC_UTILS
Source
1 PACKAGE AR_PUBLIC_UTILS AUTHID CURRENT_USER AS
2 /* $Header: ARXPUTLS.pls 120.4 2005/10/30 04:28:15 appldev noship $ */
3
4 /*=======================================================================+
5 | Declare PUBLIC Data Types and Variables
6 +=======================================================================*/
7
8 TYPE application_tbl_type IS TABLE of ar_receivable_applications%ROWTYPE
9 INDEX BY BINARY_INTEGER;
10
11 /*=======================================================================+
12 | Declare PUBLIC Exceptions
13 +=======================================================================*/
14
15 /*========================================================================
16 | PUBLIC Procedure get_payment_info
17 |
18 | DESCRIPTION
19 | This function retunrs the receipt and application details for a
20 | payment server order number passed.
21 |
22 | PSEUDO CODE/LOGIC
23 |
24 | PARAMETERS
25 | IN
26 | p_payment_server_order_num
27 | p_application_type -Valid values APP,UNAPP,ACC,OTHER ACC,ACTIVITY
28 | OUT NOCOPY
29 | p_receipt_header - Receipt Header Rowtype
30 | p_app_rec - Application Rowtype
31 | x_return_status - Standard return status
32 | x_msg_data - Standard msg data
33 | x_msg_count - Standard msg count
34 |
35 |
36 | RETURNS
37 | nothing
38 |
39 | KNOWN ISSUES
40 |
41 |
42 |
43 | NOTES
44 |
45 |
46 | MODIFICATION HISTORY
47 | Date Author Description of Changes
48 | 22-Jan-2002 S.Nambiar Created
49 | 22-Jan-2002 S.Nambiar Bug 2195124 - CRM-iPayment needs to get
50 | the invoice informations for a payment
51 | server order number.
52 |
53 *=======================================================================*/
54 PROCEDURE get_payment_info(
55 p_payment_server_order_num IN
56 ar_cash_receipts.payment_server_order_num%TYPE,
57 p_application_type IN ar_receivable_applications.status%TYPE DEFAULT 'APP',
58 p_receipt_header OUT NOCOPY ar_cash_receipts%ROWTYPE,
59 p_app_rec OUT NOCOPY application_tbl_type,
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_msg_count OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2
63 );
64
65 /*========================================================================
66 | PUBLIC Function Check_Prepay_Payment_Term
67 |
68 | DESCRIPTION
69 | If the passed payment term is a prepayment payment term,this
70 | function returns value 'Y' else 'N'.
71 |
72 | PSEUDO CODE/LOGIC
73 |
74 | PARAMETERS
75 | IN
76 | p_payment_term_id
77 |
78 |
79 | RETURNS
80 | Returns value 'Y' or 'N'.
81 |
82 | KNOWN ISSUES
83 |
84 |
85 |
86 | NOTES
87 | A stub version of this routine is provided to product team which
88 | access the prepayment_flag from ra_terms view.Stub version always
89 | returns 'N'.
90 |
91 | MODIFICATION HISTORY
92 | Date Author Description of Changes
93 | 22-Jan-2002 S.Nambiar Created
94 | 21-Feb-2002 S.Nambiar Removed direct reference to table
95 | columns and replace with NUMBER.
96 |
97 *=======================================================================*/
98 FUNCTION Check_Prepay_Payment_Term
99 (p_payment_term_id IN NUMBER)
100 RETURN VARCHAR2;
101
102 /*========================================================================
103 | PUBLIC Function Check_Prepay_Transaction
104 |
105 | DESCRIPTION
106 | If the transaction is a prepaid transaction,function returns value 'Y'
107 | else 'N'.
108 |
109 | PSEUDO CODE/LOGIC
110 |
111 | PARAMETERS
112 | IN
113 | p_customer_trx_id
114 |
115 |
116 | RETURNS
117 | Returns value 'Y' or 'N'.
118 |
119 | KNOWN ISSUES
120 |
121 |
122 |
123 | NOTES
124 | A stub version of this routine is provided to product teams which
125 | access the prepayment_flag from ra_customer_trx view.Stub version
126 | always returns 'N'.
127 |
128 | MODIFICATION HISTORY
129 | Date Author Description of Changes
130 | 22-Jan-2002 S.Nambiar Created
131 | 21-Feb-2002 S.Nambiar Removed direct reference to table
132 | columns and replace with NUMBER.
133 |
134 *=======================================================================*/
135 FUNCTION Check_Prepay_Transaction
136 (p_customer_trx_id IN NUMBER)
137 RETURN VARCHAR2;
138
139 END AR_PUBLIC_UTILS;