[Home] [Help]
PACKAGE: APPS.OKC_CONTRACT_SEQ_PVT
Source
1 package okc_contract_seq_pvt AUTHID CURRENT_USER as
2 /* $Header: OKCCKSQS.pls 120.0 2005/05/25 18:04:57 appldev noship $ */
3
4 subtype ksqv_rec_type is okc_ksq_pvt.ksqv_rec_type;
5 subtype ksqv_tbl_type is okc_ksq_pvt.ksqv_tbl_type;
6 subtype lsqv_rec_type is okc_lsq_pvt.lsqv_rec_type;
7 subtype lsqv_tbl_type is okc_lsq_pvt.lsqv_tbl_type;
8
9 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
10 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
11 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
12 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
13 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
14 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
15 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
16 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
17 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_SEQ_PVT';
18 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
19
20 PROCEDURE create_seq_header(
21 p_api_version IN NUMBER,
22 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
23 x_return_status OUT NOCOPY VARCHAR2,
24 x_msg_count OUT NOCOPY NUMBER,
25 x_msg_data OUT NOCOPY VARCHAR2,
26 p_ksqv_rec IN ksqv_rec_type,
27 x_ksqv_rec OUT NOCOPY ksqv_rec_type);
28
29 PROCEDURE create_seq_header(
30 p_api_version IN NUMBER,
31 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
32 x_return_status OUT NOCOPY VARCHAR2,
33 x_msg_count OUT NOCOPY NUMBER,
34 x_msg_data OUT NOCOPY VARCHAR2,
35 p_ksqv_tbl IN ksqv_tbl_type,
36 x_ksqv_tbl OUT NOCOPY ksqv_tbl_type);
37
38 PROCEDURE update_seq_header(
39 p_api_version IN NUMBER,
40 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
41 x_return_status OUT NOCOPY VARCHAR2,
42 x_msg_count OUT NOCOPY NUMBER,
43 x_msg_data OUT NOCOPY VARCHAR2,
44 p_ksqv_rec IN ksqv_rec_type,
45 x_ksqv_rec OUT NOCOPY ksqv_rec_type);
46
47 PROCEDURE update_seq_header(
48 p_api_version IN NUMBER,
49 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
50 x_return_status OUT NOCOPY VARCHAR2,
51 x_msg_count OUT NOCOPY NUMBER,
52 x_msg_data OUT NOCOPY VARCHAR2,
53 p_ksqv_tbl IN ksqv_tbl_type,
54 x_ksqv_tbl OUT NOCOPY ksqv_tbl_type);
55
56 PROCEDURE delete_seq_header(
57 p_api_version IN NUMBER,
58 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_msg_count OUT NOCOPY NUMBER,
61 x_msg_data OUT NOCOPY VARCHAR2,
62 p_ksqv_rec IN ksqv_rec_type);
63
64 PROCEDURE delete_seq_header(
65 p_api_version IN NUMBER,
66 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
67 x_return_status OUT NOCOPY VARCHAR2,
68 x_msg_count OUT NOCOPY NUMBER,
69 x_msg_data OUT NOCOPY VARCHAR2,
70 p_ksqv_tbl IN ksqv_tbl_type);
71
72 PROCEDURE lock_seq_header(
73 p_api_version IN NUMBER,
74 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
75 x_return_status OUT NOCOPY VARCHAR2,
76 x_msg_count OUT NOCOPY NUMBER,
77 x_msg_data OUT NOCOPY VARCHAR2,
78 p_ksqv_rec IN ksqv_rec_type);
79
80 PROCEDURE lock_seq_header(
81 p_api_version IN NUMBER,
82 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2,
86 p_ksqv_tbl IN ksqv_tbl_type);
87
88 PROCEDURE validate_seq_header(
89 p_api_version IN NUMBER,
90 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
91 x_return_status OUT NOCOPY VARCHAR2,
92 x_msg_count OUT NOCOPY NUMBER,
93 x_msg_data OUT NOCOPY VARCHAR2,
94 p_ksqv_rec IN ksqv_rec_type);
95
96 PROCEDURE validate_seq_header(
97 p_api_version IN NUMBER,
98 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2,
102 p_ksqv_tbl IN ksqv_tbl_type);
103
104 PROCEDURE create_seq_lines(
105 p_api_version IN NUMBER,
106 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
107 x_return_status OUT NOCOPY VARCHAR2,
108 x_msg_count OUT NOCOPY NUMBER,
109 x_msg_data OUT NOCOPY VARCHAR2,
110 p_lsqv_rec IN lsqv_rec_type,
111 x_lsqv_rec OUT NOCOPY lsqv_rec_type);
112
113 PROCEDURE create_seq_lines(
114 p_api_version IN NUMBER,
115 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
116 x_return_status OUT NOCOPY VARCHAR2,
117 x_msg_count OUT NOCOPY NUMBER,
118 x_msg_data OUT NOCOPY VARCHAR2,
119 p_lsqv_tbl IN lsqv_tbl_type,
120 x_lsqv_tbl OUT NOCOPY lsqv_tbl_type);
121
122 PROCEDURE update_seq_lines(
123 p_api_version IN NUMBER,
124 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
125 x_return_status OUT NOCOPY VARCHAR2,
126 x_msg_count OUT NOCOPY NUMBER,
127 x_msg_data OUT NOCOPY VARCHAR2,
128 p_lsqv_rec IN lsqv_rec_type,
129 x_lsqv_rec OUT NOCOPY lsqv_rec_type);
130
131 PROCEDURE update_seq_lines(
132 p_api_version IN NUMBER,
133 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
134 x_return_status OUT NOCOPY VARCHAR2,
135 x_msg_count OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2,
137 p_lsqv_tbl IN lsqv_tbl_type,
138 x_lsqv_tbl OUT NOCOPY lsqv_tbl_type);
139
140 PROCEDURE delete_seq_lines(
141 p_api_version IN NUMBER,
142 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_msg_count OUT NOCOPY NUMBER,
145 x_msg_data OUT NOCOPY VARCHAR2,
146 p_lsqv_rec IN lsqv_rec_type);
147
148 PROCEDURE delete_seq_lines(
149 p_api_version IN NUMBER,
150 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
151 x_return_status OUT NOCOPY VARCHAR2,
152 x_msg_count OUT NOCOPY NUMBER,
153 x_msg_data OUT NOCOPY VARCHAR2,
154 p_lsqv_tbl IN lsqv_tbl_type);
155
156 PROCEDURE lock_seq_lines(
157 p_api_version IN NUMBER,
158 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_msg_data OUT NOCOPY VARCHAR2,
162 p_lsqv_rec IN lsqv_rec_type);
163
164 PROCEDURE lock_seq_lines(
165 p_api_version IN NUMBER,
166 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
167 x_return_status OUT NOCOPY VARCHAR2,
168 x_msg_count OUT NOCOPY NUMBER,
169 x_msg_data OUT NOCOPY VARCHAR2,
170 p_lsqv_tbl IN lsqv_tbl_type);
171
172 PROCEDURE validate_seq_lines(
173 p_api_version IN NUMBER,
174 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
175 x_return_status OUT NOCOPY VARCHAR2,
176 x_msg_count OUT NOCOPY NUMBER,
177 x_msg_data OUT NOCOPY VARCHAR2,
178 p_lsqv_rec IN lsqv_rec_type);
179
180 PROCEDURE validate_seq_lines(
181 p_api_version IN NUMBER,
182 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
183 x_return_status OUT NOCOPY VARCHAR2,
184 x_msg_count OUT NOCOPY NUMBER,
185 x_msg_data OUT NOCOPY VARCHAR2,
186 p_lsqv_tbl IN lsqv_tbl_type);
187
188 PROCEDURE Is_K_Autogenerated(
189 p_scs_code Varchar2,
190 x_return_status OUT NOCOPY Varchar2);
191
192 PROCEDURE Get_K_Number(
193 p_scs_code IN VARCHAR2,
194 p_contract_number_modifier IN VARCHAR2,
195 x_contract_number OUT NOCOPY VARCHAR2,
196 x_return_status OUT NOCOPY VARCHAR2);
197
198 END OKC_CONTRACT_SEQ_PVT;