[Home] [Help]
PACKAGE: APPS.OKS_ATTR_DEFAULTS_PVT
Source
1 Package OKS_ATTR_DEFAULTS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKSRDFTS.pls 120.4.12000000.1 2007/01/16 22:10:16 appldev ship $*/
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE header_lines_rec_type IS RECORD (
7 chr_id NUMBER ,
8 cle_id NUMBER ,
9 header_sto VARCHAR2(150) ,
10 header_bto VARCHAR2(150) ,
11 header_dates VARCHAR2(150) ,
12 header_arl VARCHAR2(150) ,
13 header_ire VARCHAR2(150) ,
14 header_tax VARCHAR2(150) ,
15 header_exception_number VARCHAR2(150) ,
16 -- IKON ENHANCEMENT --
17 header_bca VARCHAR2(150) ,
18 header_sca VARCHAR2(150) ,
19 -- IKON ENHANCEMENT --
20 --Fixed bug#4026268 --gbgupta
21 header_tax_code_id NUMBER,
22 header_tax_code VARCHAR2(150) ,
23 header_sales_credits VARCHAR2(150),
24 header_billto_contact VARCHAR2(150),
25 billto_id VARCHAR2(150) ,
26 billing_profile VARCHAR2(150),
27 billing_profile_id NUMBER,
28 calculate_tax VARCHAR2(3),
29 payment_method VARCHAR2(3),
30 price_uom VARCHAR2(150), -- hkamdar 8/23/05 R12 PPE project
31 price_list VARCHAR2(150), -- hkamdar 8/23/05 R12 PPE project
32 header_tax_cls_code VARCHAR2(50) /* nechatur 12-07-06 bug#5380870 Increased the header_tax_cls_code length from 30 to 50 */
33
34 );
35 TYPE header_lines_tbl_type IS TABLE OF header_lines_rec_type
36 INDEX BY BINARY_INTEGER;
37
38 TYPE lines_sublines_rec_type IS RECORD (
39 chr_id NUMBER ,
40 cle_id NUMBER ,
41 subline_id NUMBER ,
42 line_irt VARCHAR2(150) ,
43 line_renewal VARCHAR2(150) ,
44 line_inv_print VARCHAR2(150) ,
45 line_dates VARCHAR2(150) ,
46 line_cov_eff VARCHAR2(150) ,
47 header_to_lines VARCHAR2(1),
48 price_uom VARCHAR2(150) -- hkamdar 8/23/05 R12 PPE project
49 );
50
51 TYPE lines_sublines_tbl_type IS TABLE OF lines_sublines_rec_type
52 INDEX BY BINARY_INTEGER;
53
54 TYPE attr_msg_rec_type IS RECORD (
55 status varchar2(150),
56 description varchar2(2000)
57
58 );
59
60 TYPE attr_msg_tbl_type IS TABLE OF attr_msg_rec_type
61 INDEX BY BINARY_INTEGER;
62
63 -- GCHADHA --
64 -- BUG 4093005 --
65 TYPE lines_id_rec_type IS RECORD (
66 id NUMBER );
67
68 TYPE lines_id_tbl_type IS TABLE OF lines_id_rec_type
69 INDEX BY BINARY_INTEGER;
70 -- END GCHADHA --
71
72
73 ---------------------------------------------------------------------------
74 -- GLOBAL MESSAGE CONSTANTS
75 ---------------------------------------------------------------------------
76 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
77 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
78 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
79 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
80 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
81 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
82 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
83 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
84 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
85 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
86 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
87 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
88 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
89 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UPPERCASE_REQUIRED';
90 ---------------------------------------------------------------------------
91 -- GLOBAL VARIABLES
92 ---------------------------------------------------------------------------
93 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_ATTR_DEFAULTS_PVT';
94 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
95 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
96 G_REQUEST_ID CONSTANT NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
97 G_PROGRAM_APPLICATION_ID CONSTANT NUMBER := FND_GLOBAL.PROG_APPL_ID;
98 G_PROGRAM_ID CONSTANT NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
99
100 --transfer mnagement
101 G_APP_NAME_OKS CONSTANT VARCHAR2(3) := 'OKS';
102 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_UNEXP_ERROR;
103 --transfer mnagement
104
105 Type rule_rec_type Is RECORD
106 (
107 OBJECT_VERSION_NUMBER NUMBER,
108 SFWT_FLAG VARCHAR2(3),
109 OBJECT1_ID1 VARCHAR2(40),
110 OBJECT2_ID1 VARCHAR2(40),
111 OBJECT3_ID1 VARCHAR2(40),
112 OBJECT1_ID2 VARCHAR2(200),
113 OBJECT2_ID2 VARCHAR2(200),
114 OBJECT3_ID2 VARCHAR2(200),
115 JTOT_OBJECT1_CODE VARCHAR2(30),
116 JTOT_OBJECT2_CODE VARCHAR2(30),
117 JTOT_OBJECT3_CODE VARCHAR2(30),
118 DNZ_CHR_ID NUMBER,
119 RGP_ID NUMBER,
120 PRIORITY NUMBER,
121 STD_TEMPLATE_YN VARCHAR2(3),
122 COMMENTS VARCHAR2(1995),
123 WARN_YN VARCHAR2(3),
124 CREATED_BY NUMBER,
125 CREATION_DATE DATE,
126 LAST_UPDATED_BY NUMBER,
127 LAST_UPDATE_DATE DATE,
128 LAST_UPDATE_LOGIN NUMBER,
129 TEXT CLOB,
130 RULE_INFORMATION_CATEGORY VARCHAR2(90),
131 RULE_INFORMATION1 VARCHAR2(450),
132 RULE_INFORMATION2 VARCHAR2(450),
133 RULE_INFORMATION3 VARCHAR2(450),
134 RULE_INFORMATION4 VARCHAR2(450),
135 RULE_INFORMATION5 VARCHAR2(450),
136 RULE_INFORMATION6 VARCHAR2(450),
137 RULE_INFORMATION7 VARCHAR2(450),
138 RULE_INFORMATION8 VARCHAR2(450),
139 RULE_INFORMATION9 VARCHAR2(450),
140 RULE_INFORMATION10 VARCHAR2(450),
141 RULE_INFORMATION11 VARCHAR2(450),
142 RULE_INFORMATION12 VARCHAR2(450),
143 RULE_INFORMATION13 VARCHAR2(450),
144 RULE_INFORMATION14 VARCHAR2(450),
145 RULE_INFORMATION15 VARCHAR2(450));
146
147 PROCEDURE Default_header_to_lines(header_lines_tbl IN header_lines_tbl_type
148 ,X_return_status OUT NOCOPY Varchar2
149 ,x_msg_tbl IN OUT NOCOPY attr_msg_tbl_type) ;
150
151 PROCEDURE update_line
152 (
153 p_clev_tbl IN okc_contract_pub.clev_tbl_type
154 ,x_clev_tbl OUT NOCOPY okc_contract_pub.clev_tbl_type
155 ,x_return_status OUT NOCOPY Varchar2
156 ,x_msg_count OUT NOCOPY Number
157 ,x_msg_data OUT NOCOPY Varchar2
158 );
159
160
161
162 PROCEDURE Default_lines_to_sublines(lines_sublines_tbl IN lines_sublines_tbl_type
163 ,X_return_status OUT NOCOPY Varchar2
164 ,x_msg_tbl IN OUT NOCOPY attr_msg_tbl_type);
165
166
167 PROCEDURE Rollback_Work;
168
169 --PROCEDURE populate_slh_record(x_slh_rec OUT OKS_BILL_SCH.streamhdr_type);
170 --PROCEDURE populate_sll_table(x_sll_tbl OUT OKS_BILL_SCH.streamLVL_tbl);
171
172 -- Bank Account Consolidation --
173 Procedure Delete_credit_Card
174 (p_trnx_ext_id IN NUMBER,
175 p_line_id IN NUMBER,
176 p_party_id IN NUMBER,
177 p_cust_account_id IN NUMBER ,
178 x_return_status OUT NOCOPY VARCHAR2 ,
179 x_msg_data OUT NOCOPY VARCHAR2);
180
181 Function Create_credit_Card
182 (p_line_id IN NUMBER,
183 p_party_id IN NUMBER,
184 p_org IN NUMBER,
185 p_account_site_id IN NUMBER,
186 p_cust_account_id IN NUMBER,
187 p_trnx_ext_id IN NUMBER,
188 x_return_status OUT NOCOPY VARCHAR2,
189 x_msg_data OUT NOCOPY VARCHAR2) RETURN NUMBER;
190 -- Bank Account Consolidation --
191
192 END OKS_ATTR_DEFAULTS_PVT;