1 PACKAGE XNB_BILL_SUMMARIES_PKG as
2 /* $Header: XNBTBSS.pls 120.2 2006/04/06 01:59:19 ksrikant noship $ */
3 /*#
4 * This is the public interface of TBI that is used for inserting, creating, or populating
5 * new Bill Summary records into Oracle Applications from external Billing systems.
6 * @rep:scope public
7 * @rep:product XNB
8 * @rep:displayname Create Bill Summary
9 * @rep:lifecycle active
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY XNB_ADD_BILLSUMMARY
12 */
13
14 -- Start of Comments
15 -- Package name : XNB_BILL_SUMMARIES_PKG
16 -- Purpose : Defines public APIs to insert/update records into XNB BILL SUMMARIES schema
17 -- History :
18 -- DATE AUTHOR COMMENTS
19 -- 23-Aug-2004 dbhagat Create table handler
20 -- 04-Feb-2005 DPUTHIYE Added p_api_version parameter to APIs. (Fixed bug 4159395).
21 -- NOTE :
22 -- End of Comments
23
24 TYPE v_number IS VARRAY(10000) OF NUMBER;
25 TYPE v_date IS VARRAY(10000) OF DATE;
26 TYPE v_var30 IS VARRAY(10000) OF VARCHAR2(30);
27 TYPE v_var240 IS VARRAY(10000) OF VARCHAR2(240);
28 TYPE v_var150 IS VARRAY(10000) OF VARCHAR2(150);
29
30 /*
31 * Record structure of XNB_BILL_SUMMARIES table
32 */
33 TYPE bill_summaries_rec IS RECORD (
34 ACCOUNT_NUMBER VARCHAR2(30), -- mandatory for insert and update
35 TOTAL_AMOUNT_DUE VARCHAR2(30),
36 ADJUSTMENTS VARCHAR2(30),
37 UNRESOLVED_DISPUTES VARCHAR2(30),
38 BILL_NUMBER VARCHAR2(30), -- mandatory for insert and update
39 BILL_CYCLE_START_DATE DATE,
40 BILL_CYCLE_END_DATE DATE,
41 DUE_DATE DATE,
42 NEW_CHARGES VARCHAR2(30),
43 PAYMENT VARCHAR2(30),
44 BALANCE VARCHAR2(30),
45 PREVIOUS_BALANCE VARCHAR2(30),
46 BILLING_VENDOR_NAME VARCHAR2(240),
47 BILL_LOCATION_URL VARCHAR2(240),
48 DUE_NOW VARCHAR2(30),
49 CREATED_BY NUMBER,
50 LAST_UPDATED_BY NUMBER,
51 LAST_UPDATE_LOGIN NUMBER,
52 ATTRIBUTE_CATEGORY VARCHAR2(30),
53 ATTRIBUTE1 VARCHAR2(150),
54 ATTRIBUTE2 VARCHAR2(150),
55 ATTRIBUTE3 VARCHAR2(150),
56 ATTRIBUTE4 VARCHAR2(150),
57 ATTRIBUTE5 VARCHAR2(150),
58 ATTRIBUTE6 VARCHAR2(150),
59 ATTRIBUTE7 VARCHAR2(150),
60 ATTRIBUTE8 VARCHAR2(150),
61 ATTRIBUTE9 VARCHAR2(150),
62 ATTRIBUTE10 VARCHAR2(150),
63 ATTRIBUTE11 VARCHAR2(150),
64 ATTRIBUTE12 VARCHAR2(150),
65 ATTRIBUTE13 VARCHAR2(150),
66 ATTRIBUTE14 VARCHAR2(150),
67 ATTRIBUTE15 VARCHAR2(150)
68 );
69
70 /*
71 * Table type for holding multiple records/ rows of XNB_BILL_SUMMARIES table data
72 */
73 TYPE bill_summaries_table IS TABLE OF bill_summaries_rec INDEX BY BINARY_INTEGER;
74
75
76 /*
77 * insert bulk rows of data
78 * Usage example:
79 * api_version NUMBER;
80 * bill_summaries XNB_BILL_SUMMARIES_PKG.bill_summaries_table;
81 * api_version = 1.0;
82 * bill_summaries(i).ACCOUNT_NUMBER := '1001';
83 * XNB_BILL_SUMMARIES_PKG.Insert_Row_Batch(api_version, bill_summaries, x_return_status, x_msg_data);
84 */
85
86 --Date:04-Feb-2005 Author:DPUTHIYE Bug#:4159395
87 --Change: Added parameter p_api_version to comply to Business API standards.
88 --Other Files Impact: None.
89
90 /*#
91 * This is the public interface of TBI that is used for inserting
92 * new Bill Summary records into Oracle Applications from external Billing systems.
93 * @param p_api_version API version used to check call compatibility
94 * @param p_bill_summaries Bill Summary Records
95 * @param x_return_status Returns the status of transaction
96 * @param x_msg_data Returns Error Message
97 * @rep:scope public
98 * @rep:lifecycle active
99 * @rep:displayname Insert Bill Summary
100 */
101 PROCEDURE Insert_Row_Batch(
102 p_api_version IN NUMBER,
103 p_bill_summaries IN bill_summaries_table,
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_data OUT NOCOPY VARCHAR2
106 );
107
108 /*
109 * update bulk rows of data
110 * Usage example:
111 * api_version NUMBER;
112 * bill_summaries XNB_BILL_SUMMARIES_PKG.bill_summaries_table;
113 * api_version = 1.0;
114 * bill_summaries(i).ACCOUNT_NUMBER := '1001';
115 * XNB_BILL_SUMMARIES_PKG.Update_Row_Batch(api_version, bill_summaries, x_return_status, x_msg_data);
116 */
117
118 --Date:04-Feb-2005 Author:DPUTHIYE Bug#:4159395
119 --Change: Added parameter p_api_version to comply to Business API standards.
120 --Other Files Impact: None.
121
122 /*#
123 * This is the public interface of TBI that is used for updating
124 * existing Bill Summary records in Oracle Applications from external Billing systems.
125 * @param p_api_version API version used to check call compatibility
126 * @param p_bill_summaries Bill Summary Records
127 * @param x_return_status Returns the status of transaction
128 * @param x_msg_data Returns Error Message
129 * @rep:scope public
130 * @rep:lifecycle active
131 * @rep:displayname Update Bill Summary
132 */
133 PROCEDURE Update_Row_Batch(
134 p_api_version IN NUMBER,
135 p_bill_summaries IN bill_summaries_table,
136 x_return_status OUT NOCOPY VARCHAR2,
137 x_msg_data OUT NOCOPY VARCHAR2
138 );
139
140 End XNB_BILL_SUMMARIES_PKG;