[Home] [Help]
PACKAGE: APPS.CS_CONTINTF_PVT
Source
1 Package CS_CONTINTF_PVT AUTHID CURRENT_USER AS
2 /* $Header: csctcbis.pls 115.0 99/07/16 08:49:07 porting ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE ContIntf_Rec_Type IS RECORD (
7 contracts_interface_id NUMBER := NULL,
8 cp_service_transaction_id NUMBER := NULL,
9 cp_service_id NUMBER := NULL,
10 contract_id NUMBER := NULL,
11 ar_trx_type CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := NULL,
12 trx_start_date CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := NULL,
13 trx_end_date CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := NULL,
14 trx_date CS_CONT_BILL_IFACE.TRX_DATE%TYPE := NULL,
15 trx_amount NUMBER := NULL,
16 reason_code CS_CONT_BILL_IFACE.REASON_CODE%TYPE := NULL,
17 reason_comments CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := NULL,
18 contract_billing_id NUMBER := NULL,
19 cp_quantity NUMBER := NULL,
20 concurrent_process_id NUMBER := NULL,
21 created_by NUMBER := NULL,
22 creation_date CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := NULL,
23 object_version_number NUMBER := NULL);
24 G_MISS_contintf_rec ContIntf_Rec_Type;
25 TYPE ContIntf_Val_Rec_Type IS RECORD (
26 contracts_interface_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
27 cp_service_transaction_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
28 cp_service_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
29 contract_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
30 ar_trx_type CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
31 trx_start_date CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
32 trx_end_date CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
33 trx_date CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
34 trx_amount NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
35 reason_code CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
36 reason_comments CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
37 contract_billing_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
38 cp_quantity NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
39 concurrent_process_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
40 created_by NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
41 creation_date CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
42 object_version_number NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
43 G_MISS_contintf_val_rec ContIntf_Val_Rec_Type;
44 ---------------------------------------------------------------------------
45 -- GLOBAL MESSAGE CONSTANTS
46 ---------------------------------------------------------------------------
47 G_FND_APP CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FND_APP;
48 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_UNABLE_TO_RESERVE_REC;
49 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_DELETED;
50 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_CHANGED;
51 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_RECORD_LOGICALLY_DELETED;
52 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_REQUIRED_VALUE;
53 G_INVALID_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_INVALID_VALUE;
54 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_COL_NAME_TOKEN;
55 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_PARENT_TABLE_TOKEN;
56 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_CHILD_TABLE_TOKEN;
57 ---------------------------------------------------------------------------
58 -- GLOBAL VARIABLES
59 ---------------------------------------------------------------------------
60 G_PKG_NAME CONSTANT VARCHAR2(200) := 'CS_CONTINTF_PVT';
61 G_APP_NAME CONSTANT VARCHAR2(3) := TAPI_DEV_KIT.G_APP_NAME;
62 ---------------------------------------------------------------------------
63 -- Procedures and Functions
64 ---------------------------------------------------------------------------
65
66 PROCEDURE insert_row
67 (
68 p_api_version IN NUMBER,
69 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
70 p_validation_level IN NUMBER,
71 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
72 x_return_status OUT VARCHAR2,
73 x_msg_count OUT NUMBER,
74 x_msg_data OUT VARCHAR2,
75 p_contintf_rec IN ContIntf_Rec_Type := G_MISS_CONTINTF_REC,
76 x_contracts_interface_id OUT NUMBER,
77 x_object_version_number OUT NUMBER);
78 PROCEDURE insert_row
79 (
80 p_api_version IN NUMBER,
81 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
82 p_validation_level IN NUMBER,
83 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
84 x_return_status OUT VARCHAR2,
85 x_msg_count OUT NUMBER,
86 x_msg_data OUT VARCHAR2,
87 p_cp_service_transaction_id IN NUMBER := NULL,
88 p_cp_service_id IN NUMBER := NULL,
89 p_contract_id IN NUMBER := NULL,
90 p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := NULL,
91 p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := NULL,
92 p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := NULL,
93 p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := NULL,
94 p_trx_amount IN NUMBER := NULL,
95 p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := NULL,
96 p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := NULL,
97 p_contract_billing_id IN NUMBER := NULL,
98 p_cp_quantity IN NUMBER := NULL,
99 p_concurrent_process_id IN NUMBER := NULL,
100 p_created_by IN NUMBER := NULL,
101 p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := NULL,
102 p_object_version_number IN NUMBER := NULL,
103 x_contracts_interface_id OUT NUMBER,
104 x_object_version_number OUT NUMBER);
105 Procedure lock_row
106 (
107 p_api_version IN NUMBER,
108 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
109 p_validation_level IN NUMBER,
110 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
111 x_return_status OUT VARCHAR2,
112 x_msg_count OUT NUMBER,
113 x_msg_data OUT VARCHAR2,
114 p_contracts_interface_id IN NUMBER,
115 p_object_version_number IN NUMBER);
116 Procedure update_row
117 (
118 p_api_version IN NUMBER,
119 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
120 p_validation_level IN NUMBER,
121 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
122 x_return_status OUT VARCHAR2,
123 x_msg_count OUT NUMBER,
124 x_msg_data OUT VARCHAR2,
125 p_contintf_val_rec IN ContIntf_Val_Rec_Type := G_MISS_CONTINTF_VAL_REC,
126 x_object_version_number OUT NUMBER);
127 Procedure update_row
128 (
129 p_api_version IN NUMBER,
130 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
131 p_validation_level IN NUMBER,
132 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
133 x_return_status OUT VARCHAR2,
134 x_msg_count OUT NUMBER,
135 x_msg_data OUT VARCHAR2,
136 p_contracts_interface_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
137 p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
138 p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
139 p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
140 p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
141 p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
142 p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
143 p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
144 p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
145 p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
146 p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
147 p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
148 p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
149 p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
150 p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
151 p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
152 p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
153 x_object_version_number OUT NUMBER);
154 Procedure delete_row
155 (
156 p_api_version IN NUMBER,
157 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
158 p_validation_level IN NUMBER,
159 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
160 x_return_status OUT VARCHAR2,
161 x_msg_count OUT NUMBER,
162 x_msg_data OUT VARCHAR2,
163 p_contracts_interface_id IN NUMBER);
164 PROCEDURE validate_row
165 (
166 p_api_version IN NUMBER,
167 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
168 p_validation_level IN NUMBER,
169 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
170 x_return_status OUT VARCHAR2,
171 x_msg_count OUT NUMBER,
172 x_msg_data OUT VARCHAR2,
173 p_contintf_val_rec IN ContIntf_Val_Rec_Type := G_MISS_CONTINTF_VAL_REC);
174 PROCEDURE validate_row
175 (
176 p_api_version IN NUMBER,
177 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
178 p_validation_level IN NUMBER,
179 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
180 x_return_status OUT VARCHAR2,
181 x_msg_count OUT NUMBER,
182 x_msg_data OUT VARCHAR2,
183 p_contracts_interface_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
184 p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
185 p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
186 p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
187 p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
188 p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
189 p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
190 p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
191 p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
192 p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
193 p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
194 p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
195 p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
196 p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
197 p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
198 p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
199 p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
200 END CS_CONTINTF_PVT;