[Home] [Help]
PACKAGE: APPS.IEX_DISPUTE_PUB
Source
1 PACKAGE IEX_DISPUTE_PUB AS
2 /* $Header: iexpdiss.pls 120.16.12010000.3 2008/09/22 12:13:31 pnaveenk 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
49 TYPE DISPUTE_LINE_TBL IS TABLE OF DISPUTE_LINE_REC INDEX BY binary_integer;
50
51 G_MISS_DISP_HEADER_REC IEX_DISPUTE_PUB.DISP_HEADER_REC ;
52 G_MISS_DIPSUTE_LINE_TBL IEX_DISPUTE_PUB.DISPUTE_LINE_TBL ;
53
54 /*#
55 Enters a header level dispute.
56 @rep:scope public
57 @rep:displayname Create Header Dispute Record
58 @rep:category BUSINESS_ENTITY IEX_COLLECTION_DISPUTE
59 */
60 FUNCTION init_disp_rec RETURN DISP_HEADER_REC;
61
62 /*#
63 Enters a line level dispute.
64 @rep:scope public
65 @rep:displayname Create Line Level Dispute
66 @rep:category BUSINESS_ENTITY IEX_COLLECTION_DISPUTE
67 */
68 FUNCTION init_disp_line_tbl RETURN DISPUTE_LINE_TBL;
69
70 /*#
71 * Use this procedure to creates a new dispute.
72 *
73 * @param p_api_version API version number
74 * @param p_init_msg_list Intialize Message Stack
75 * @param p_commit Commit flag
76 * @param x_return_status API return status
77 * @param x_msg_count Number of error messages
78 * @param x_msg_data Error message data
79 * @param x_request_id request identifier
80 * @param p_disp_header_rec PL/SQL record containing promise details
81 * @param p_disp_line_tbl PL/SQL record returning the line details for the dispute.
82 * @rep:scope public
83 * @rep:lifecycle active
84 * @rep:displayname Create Dispute
85 * @rep:compatibility S
86 * @rep:businessevent DISPUTE
87 * @rep:category BUSINESS_ENTITY IEX_COLLECTION_DISPUTE
88 */
89 PROCEDURE Create_Dispute(p_api_version IN NUMBER,
90 p_init_msg_list IN VARCHAR2,
91 p_commit IN VARCHAR2,
92 p_disp_header_rec IN IEX_DISPUTE_PUB.DISP_HEADER_REC ,
93 p_disp_line_tbl IN IEX_DISPUTE_PUB.DISPUTE_LINE_TBL,
94 x_request_id OUT NOCOPY NUMBER,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2,
98 p_skip_workflow_flag IN VARCHAR2 DEFAULT 'N',
99 p_batch_source_name IN VARCHAR2 DEFAULT NULL,
100 p_dispute_date IN DATE DEFAULT NULL);
101
102 /*#
103 * Use this procedure to check if a delinquency is already disputed.
104 * @param p_api_version API Version Number
105 * @param p_init_msg_list Intialize Message Stack
106 * @param p_delinquency_id Delinquency Identifier
107 * @param x_return_status API return status
108 * @param x_msg_count Number of error messages
109 * @param x_msg_data Error message data
110 * @rep:scope public
111 * @rep:lifecycle active
112 * @rep:displayname Create Dispute
113 * @rep:compatibility S
114 */
115 PROCEDURE is_delinquency_dispute(p_api_version IN NUMBER ,
116 p_init_msg_list IN VARCHAR2,
117 p_delinquency_id IN NUMBER,
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2);
121
122 --Start bug 6856035 gnramasa 28th May 08
123 PROCEDURE CANCEL_DISPUTE (p_api_version IN NUMBER,
124 p_commit IN VARCHAR2,
125 p_dispute_id IN NUMBER,
126 p_cancel_comments IN VARCHAR2,
127 x_return_status OUT NOCOPY VARCHAR2,
128 x_msg_count OUT NOCOPY NUMBER,
129 x_msg_data OUT NOCOPY VARCHAR2);
130 --End bug 6856035 gnramasa 28th May 08
131
132 END IEX_DISPUTE_PUB ;