[Home] [Help]
PACKAGE: APPS.ARI_PROCESS_VALIDATE
Source
1 PACKAGE ARI_PROCESS_VALIDATE AUTHID CURRENT_USER AS
2 /*$Header: ARI_PROCESS_VALIDATE_S.pls 120.2 2011/07/29 07:33:45 mbolli noship $*/
3
4 /*========================================================================+
5 | Declare PUBLIC Data Types and Variables
6 +========================================================================*/
7
8 TYPE PAYMENT_SCHEDULE_TBL IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
9 TYPE TRX_NUMBER_TBL IS TABLE OF VARCHAR2(120) INDEX BY BINARY_INTEGER;
10
11
12 /*=========================================================================
13 || PUBLIC PROCEDURE VALIDATE_DISPUTE
14 ||
15 || DESCRIPTION
16 || Overview: This procedure validates the transaction before disputing
17 ||
18 ||
19 || PSEUDO CODE/LOGIC
20 ||
21 || PARAMETERS
22 || Parameter: p_cust_account_id => Cust Account ID of the customer
23 || p_cust_site_use_id => Site Use ID of the Account
24 || p_session_id => Current session from AR_IREC_USER_ACCT_SITES_ALL
25 || p_payment_schedule_tbl => Table of Payment Schedule ID of Transaction's
26 || p_trx_number_tbl => Table of Trx Numbers for Display
27 ||
28 || Return values:
29 || x_fail_payment_schedule_tbl => Table of failed Payment Schedule ID
30 || x_return_status => 'S' Validation Success
31 || 'E' Validation Error
32 || x_msg_count => Message Count
33 || x_msg_data => Validating Error Message
34 ||
35 || Return value:
36 || standard
37 || KNOWN ISSUES
38 ||
39 || NOTES
40 ||
41 || MODIFICATION HISTORY
42 || Date Author Description of Changes
43 || 28-JUL-2011 kasreeni Bug#12800095 - Created
44 *=======================================================================*/
45 procedure VALIDATE_DISPUTE(p_cust_account_id IN NUMBER
46 ,p_cust_site_use_id IN NUMBER
47 ,p_session_id IN NUMBER
48 ,p_payment_schedule_tbl IN ARI_PROCESS_VALIDATE.PAYMENT_SCHEDULE_TBL
49 ,p_trx_number_tbl IN ARI_PROCESS_VALIDATE.TRX_NUMBER_TBL
50 ,x_fail_payment_schedule_tbl OUT NOCOPY ARI_PROCESS_VALIDATE.PAYMENT_SCHEDULE_TBL
51 ,x_return_status OUT NOCOPY VARCHAR2
52 ,x_msg_count OUT NOCOPY NUMBER
53 ,x_msg_data OUT NOCOPY VARCHAR2);
54
55
56 /*=========================================================================
57 || PUBLIC PROCEDURE VALIDATE_PAYMENT
58 ||
59 || DESCRIPTION
60 || Overview: This procedure validates the transaction before payment
61 ||
62 ||
63 || PSEUDO CODE/LOGIC
64 ||
65 || PARAMETERS
66 || Parameter: p_cust_account_id => Cust Account ID of the customer
67 || p_cust_site_use_id => Site Use ID of the Account
68 || p_session_id => Current session from AR_IREC_USER_ACCT_SITES_ALL
69 || p_payment_schedule_tbl => Table of Payment Schedule ID of Transaction's
70 || p_trx_number_tbl => Table of Trx Numbers for Display
71 ||
72 || Return values:
73 || x_fail_payment_schedule_tbl => Table of failed Payment Schedule ID
74 || x_return_status => 'S' Validation Success
75 || 'E' Validation Error
76 || x_msg_count => Message Count
77 || x_msg_data => Validating Error Message
78 ||
79 || Return value:
80 || standard
81 || KNOWN ISSUES
82 ||
83 || NOTES
84 ||
85 || MODIFICATION HISTORY
86 || Date Author Description of Changes
87 || 28-JUL-2011 kasreeni Bug#12800095 - Created
88 *=======================================================================*/
89 procedure VALIDATE_PAYMENT(p_cust_account_id IN NUMBER
90 ,p_cust_site_use_id IN NUMBER
91 ,p_session_id IN NUMBER
92 ,p_payment_schedule_tbl IN ARI_PROCESS_VALIDATE.PAYMENT_SCHEDULE_TBL
93 ,p_trx_number_tbl IN ARI_PROCESS_VALIDATE.TRX_NUMBER_TBL
94 ,x_fail_payment_schedule_tbl OUT NOCOPY ARI_PROCESS_VALIDATE.PAYMENT_SCHEDULE_TBL
95 ,x_return_status OUT NOCOPY VARCHAR2
96 ,x_msg_count OUT NOCOPY NUMBER
97 ,x_msg_data OUT NOCOPY VARCHAR2);
98
99
100 /*=========================================================================
101 || PUBLIC PROCEDURE VALIDATE_PRINT
102 ||
103 || DESCRIPTION
104 || Overview: This procedure validates the transaction before printing
105 ||
106 ||
107 || PSEUDO CODE/LOGIC
108 ||
109 || PARAMETERS
110 || Parameter: p_cust_account_id => Cust Account ID of the customer
111 || p_cust_site_use_id => Site Use ID of the Account
112 || p_session_id => Current session from AR_IREC_USER_ACCT_SITES_ALL
113 || p_payment_schedule_tbl => Table of Payment Schedule ID of Transaction's
114 || p_trx_number_tbl => Table of Trx Numbers for Display
115 ||
116 || Return values:
117 || x_fail_payment_schedule_tbl => Table of failed Payment Schedule ID
118 || x_return_status => 'S' Validation Success
119 || 'E' Validation Error
120 || x_msg_count => Message Count
121 || x_msg_data => Validating Error Message
122 ||
123 || Return value:
124 || standard
125 || KNOWN ISSUES
126 ||
127 || NOTES
128 ||
129 || MODIFICATION HISTORY
130 || Date Author Description of Changes
131 || 28-JUL-2011 kasreeni Bug#12800095 - Created
132 *=======================================================================*/
133 procedure VALIDATE_PRINT(p_cust_account_id IN NUMBER
134 ,p_cust_site_use_id IN NUMBER
135 ,p_session_id IN NUMBER
136 ,p_payment_schedule_tbl IN ARI_PROCESS_VALIDATE.PAYMENT_SCHEDULE_TBL
137 ,p_trx_number_tbl IN ARI_PROCESS_VALIDATE.TRX_NUMBER_TBL
138 ,x_fail_payment_schedule_tbl OUT NOCOPY ARI_PROCESS_VALIDATE.PAYMENT_SCHEDULE_TBL
139 ,x_return_status OUT NOCOPY VARCHAR2
140 ,x_msg_count OUT NOCOPY NUMBER
141 ,x_msg_data OUT NOCOPY VARCHAR2);
142
143
144 END ARI_PROCESS_VALIDATE;