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