[Home] [Help]
PACKAGE: APPS.IEX_DISPUTE_PUB
Source
1 PACKAGE IEX_DISPUTE_PUB AUTHID CURRENT_USER AS
2 /* $Header: iexpdiss.pls 120.18.12020000.2 2012/07/24 19:03:18 schekuri ship $ */
3 /*#
4 Creates a dispute.
5 @rep:scope public
6 @rep:product IEX
7 @rep:displayname Create Dispute
8 @rep:category BUSINESS_ENTITY IEX_COLLECTION_DISPUTE
9 */
10
11 TYPE DISP_HEADER_REC IS RECORD(
12 CUST_TRX_ID NUMBER
13 ,LINE_CREDIT_FLAG VARCHAR2(10)
14 ,LINE_AMT NUMBER
15 ,TAX_AMT NUMBER
16 ,FREIGHT_AMT NUMBER
17 ,CM_REASON_CODE VARCHAR2(100)
18 ,COMMENTS VARCHAR2(2000)
19 ,INTERNAL_COMMENT varchar2(2000) --Added for bug#7376422 by PNAVEENK on 9-sep-2008
20 ,ORIG_TRX_NUMBER VARCHAR2(100)
21 ,TAX_EX_CERT_NUM VARCHAR2(100)
22 ,REQUEST_URL VARCHAR2(1000)
23 ,TRANSACTION_URL VARCHAR2(1000)
24 ,TRANS_ACT_URL VARCHAR2(1000)
25 ,DELINQUENCY_ID NUMBER
26 ,DISPUTE_SECTION VARCHAR2(25)
27 ,ATTRIBUTE_CATEGORY VARCHAR2(30)
28 ,ATTRIBUTE1 VARCHAR2(150)
29 ,ATTRIBUTE2 VARCHAR2(150)
30 ,ATTRIBUTE3 VARCHAR2(150)
31 ,ATTRIBUTE4 VARCHAR2(150)
32 ,ATTRIBUTE5 VARCHAR2(150)
33 ,ATTRIBUTE6 VARCHAR2(150)
34 ,ATTRIBUTE7 VARCHAR2(150)
35 ,ATTRIBUTE8 VARCHAR2(150)
36 ,ATTRIBUTE9 VARCHAR2(150)
37 ,ATTRIBUTE10 VARCHAR2(150)
38 ,ATTRIBUTE11 VARCHAR2(150)
39 ,ATTRIBUTE12 VARCHAR2(150)
40 ,ATTRIBUTE13 VARCHAR2(150)
41 ,ATTRIBUTE14 VARCHAR2(150)
42 ,ATTRIBUTE15 VARCHAR2(150));
43
44 TYPE DISPUTE_LINE_REC IS RECORD
45 (customer_trx_line_id ra_customer_trx_lines.Customer_trx_line_id%type,
46 extended_amount ra_customer_trx_lines.Extended_amount%type,
47 quantity_credited NUMBER,
48 ATTRIBUTE_CATEGORY ra_customer_trx_lines.ATTRIBUTE_CATEGORY%type,
49 ATTRIBUTE1 ra_customer_trx_lines.ATTRIBUTE1%type,
50 ATTRIBUTE2 ra_customer_trx_lines.ATTRIBUTE2%type,
51 ATTRIBUTE3 ra_customer_trx_lines.ATTRIBUTE3%type,
52 ATTRIBUTE4 ra_customer_trx_lines.ATTRIBUTE4%type,
53 ATTRIBUTE5 ra_customer_trx_lines.ATTRIBUTE5%type,
54 ATTRIBUTE6 ra_customer_trx_lines.ATTRIBUTE6%type,
55 ATTRIBUTE7 ra_customer_trx_lines.ATTRIBUTE7%type,
56 ATTRIBUTE8 ra_customer_trx_lines.ATTRIBUTE8%type,
57 ATTRIBUTE9 ra_customer_trx_lines.ATTRIBUTE9%type,
58 ATTRIBUTE10 ra_customer_trx_lines.ATTRIBUTE10%type,
59 ATTRIBUTE11 ra_customer_trx_lines.ATTRIBUTE11%type,
60 ATTRIBUTE12 ra_customer_trx_lines.ATTRIBUTE12%type,
61 ATTRIBUTE13 ra_customer_trx_lines.ATTRIBUTE13%type,
62 ATTRIBUTE14 ra_customer_trx_lines.ATTRIBUTE14%type,
63 ATTRIBUTE15 ra_customer_trx_lines.ATTRIBUTE15%type,
64 INTERFACE_LINE_CONTEXT ra_customer_trx_lines.INTERFACE_LINE_CONTEXT%type,
65 INTERFACE_LINE_ATTRIBUTE1 ra_customer_trx_lines.INTERFACE_LINE_ATTRIBUTE1%type,
66 INTERFACE_LINE_ATTRIBUTE2 ra_customer_trx_lines.INTERFACE_LINE_ATTRIBUTE2%type,
67 INTERFACE_LINE_ATTRIBUTE3 ra_customer_trx_lines.INTERFACE_LINE_ATTRIBUTE3%type,
68 INTERFACE_LINE_ATTRIBUTE4 ra_customer_trx_lines.INTERFACE_LINE_ATTRIBUTE4%type,
69 INTERFACE_LINE_ATTRIBUTE5 ra_customer_trx_lines.INTERFACE_LINE_ATTRIBUTE5%type,
70 INTERFACE_LINE_ATTRIBUTE6 ra_customer_trx_lines.INTERFACE_LINE_ATTRIBUTE6%type,
71 INTERFACE_LINE_ATTRIBUTE7 ra_customer_trx_lines.INTERFACE_LINE_ATTRIBUTE7%type,
72 INTERFACE_LINE_ATTRIBUTE8 ra_customer_trx_lines.INTERFACE_LINE_ATTRIBUTE8%type,
73 INTERFACE_LINE_ATTRIBUTE9 ra_customer_trx_lines.INTERFACE_LINE_ATTRIBUTE9%type,
74 INTERFACE_LINE_ATTRIBUTE10 ra_customer_trx_lines.INTERFACE_LINE_ATTRIBUTE10%type,
75 INTERFACE_LINE_ATTRIBUTE11 ra_customer_trx_lines.INTERFACE_LINE_ATTRIBUTE11%type,
76 INTERFACE_LINE_ATTRIBUTE12 ra_customer_trx_lines.INTERFACE_LINE_ATTRIBUTE12%type,
77 INTERFACE_LINE_ATTRIBUTE13 ra_customer_trx_lines.INTERFACE_LINE_ATTRIBUTE13%type,
78 INTERFACE_LINE_ATTRIBUTE14 ra_customer_trx_lines.INTERFACE_LINE_ATTRIBUTE14%type,
79 INTERFACE_LINE_ATTRIBUTE15 ra_customer_trx_lines.INTERFACE_LINE_ATTRIBUTE15%type
80 );
81
82 TYPE DISPUTE_LINE_TBL IS TABLE OF DISPUTE_LINE_REC INDEX BY binary_integer;
83
84 G_MISS_DISP_HEADER_REC IEX_DISPUTE_PUB.DISP_HEADER_REC ;
85 G_MISS_DIPSUTE_LINE_TBL IEX_DISPUTE_PUB.DISPUTE_LINE_TBL ;
86
87 /*#
88 Enters a header level dispute.
89 @rep:scope public
90 @rep:displayname Create Header Dispute Record
91 @rep:category BUSINESS_ENTITY IEX_COLLECTION_DISPUTE
92 */
93 FUNCTION init_disp_rec RETURN DISP_HEADER_REC;
94
95 /*#
96 Enters a line level dispute.
97 @rep:scope public
98 @rep:displayname Create Line Level Dispute
99 @rep:category BUSINESS_ENTITY IEX_COLLECTION_DISPUTE
100 */
101 FUNCTION init_disp_line_tbl RETURN DISPUTE_LINE_TBL;
102
103 /*#
104 * Use this procedure to creates a new dispute.
105 *
106 * @param p_api_version API version number
107 * @param p_init_msg_list Intialize Message Stack
108 * @param p_commit Commit flag
109 * @param x_return_status API return status
110 * @param x_msg_count Number of error messages
111 * @param x_msg_data Error message data
112 * @param x_request_id request identifier
113 * @param p_disp_header_rec PL/SQL record containing promise details
114 * @param p_disp_line_tbl PL/SQL record returning the line details for the dispute.
115 * @rep:scope public
116 * @rep:lifecycle active
117 * @rep:displayname Create Dispute
118 * @rep:compatibility S
119 * @rep:businessevent DISPUTE
120 * @rep:category BUSINESS_ENTITY IEX_COLLECTION_DISPUTE
121 */
122 PROCEDURE Create_Dispute(p_api_version IN NUMBER,
123 p_init_msg_list IN VARCHAR2,
124 p_commit IN VARCHAR2,
125 p_disp_header_rec IN IEX_DISPUTE_PUB.DISP_HEADER_REC ,
126 p_disp_line_tbl IN IEX_DISPUTE_PUB.DISPUTE_LINE_TBL,
127 x_request_id OUT NOCOPY NUMBER,
128 x_return_status OUT NOCOPY VARCHAR2,
129 x_msg_count OUT NOCOPY NUMBER,
130 x_msg_data OUT NOCOPY VARCHAR2,
131 p_skip_workflow_flag IN VARCHAR2 DEFAULT 'N',
132 p_batch_source_name IN VARCHAR2 DEFAULT NULL,
133 p_dispute_date IN DATE DEFAULT NULL);
134
135 /*#
136 * Use this procedure to check if a delinquency is already disputed.
137 * @param p_api_version API Version Number
138 * @param p_init_msg_list Intialize Message Stack
139 * @param p_delinquency_id Delinquency Identifier
140 * @param x_return_status API return status
141 * @param x_msg_count Number of error messages
142 * @param x_msg_data Error message data
143 * @rep:scope public
144 * @rep:lifecycle active
145 * @rep:displayname Create Dispute
146 * @rep:compatibility S
147 */
148 PROCEDURE is_delinquency_dispute(p_api_version IN NUMBER ,
149 p_init_msg_list IN VARCHAR2,
150 p_delinquency_id IN NUMBER,
151 x_return_status OUT NOCOPY VARCHAR2,
152 x_msg_count OUT NOCOPY NUMBER,
153 x_msg_data OUT NOCOPY VARCHAR2);
154
155 --Start bug 6856035 gnramasa 28th May 08
156 PROCEDURE CANCEL_DISPUTE (p_api_version IN NUMBER,
157 p_commit IN VARCHAR2,
158 p_dispute_id IN NUMBER,
159 p_cancel_comments IN VARCHAR2,
160 x_return_status OUT NOCOPY VARCHAR2,
161 x_msg_count OUT NOCOPY NUMBER,
162 x_msg_data OUT NOCOPY VARCHAR2);
163 --End bug 6856035 gnramasa 28th May 08
164
165 END IEX_DISPUTE_PUB ;