DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_API

Line 40: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

36:
37: ---------------------------------------------------------------------------
38: -- GLOBAL MESSAGE CONSTANTS
39: ---------------------------------------------------------------------------
40: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
41: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
42: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
43: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
44: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

Line 41: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;

37: ---------------------------------------------------------------------------
38: -- GLOBAL MESSAGE CONSTANTS
39: ---------------------------------------------------------------------------
40: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
41: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
42: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
43: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
44: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
45: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

Line 42: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;

38: -- GLOBAL MESSAGE CONSTANTS
39: ---------------------------------------------------------------------------
40: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
41: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
42: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
43: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
44: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
45: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
46: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

Line 43: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;

39: ---------------------------------------------------------------------------
40: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
41: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
42: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
43: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
44: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
45: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
46: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
47: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

Line 44: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

40: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
41: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
42: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
43: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
44: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
45: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
46: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
47: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
48: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

Line 45: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

41: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
42: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
43: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
44: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
45: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
46: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
47: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
48: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
49: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

Line 46: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

42: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
43: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
44: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
45: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
46: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
47: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
48: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
49: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
50: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';

Line 47: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

43: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
44: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
45: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
46: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
47: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
48: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
49: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
50: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
51: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

Line 48: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

44: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
45: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
46: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
47: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
48: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
49: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
50: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
51: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
52: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

Line 49: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

45: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
46: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
47: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
48: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
49: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
50: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
51: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
52: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
53: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UPPERCASE_REQ';

Line 63: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

59:
60: -- GLOBAL VARIABLES
61: ---------------------------------------------------------------------------
62: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_COPY_CONTRACT_PVT';
63: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
64: g_rulv_rec rulv_rec_type;
65: ---------------------------------------------------------------------------
66:
67: TYPE api_components_rec IS RECORD(id NUMBER,

Line 96: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

92: x_new_lse_ids OUT NOCOPY VARCHAR2);
93:
94: PROCEDURE copy_components(
95: p_api_version IN NUMBER,
96: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
97: x_return_status OUT NOCOPY VARCHAR2,
98: x_msg_count OUT NOCOPY NUMBER,
99: x_msg_data OUT NOCOPY VARCHAR2,
100: p_from_chr_id IN NUMBER,

Line 121: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

117:
118:
119: PROCEDURE copy_contract(
120: p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,
124: x_msg_data OUT NOCOPY VARCHAR2,
125: p_commit IN VARCHAR2 DEFAULT 'F',

Line 141: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

137: x_chr_id OUT NOCOPY NUMBER);
138:
139: PROCEDURE copy_contract_lines(
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_from_cle_id IN NUMBER,

Line 146: p_to_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_from_cle_id IN NUMBER,
146: p_to_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
147: p_to_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
148: p_to_template_yn IN VARCHAR2,
149: p_copy_reference IN VARCHAR2,
150: p_copy_line_party_yn IN VARCHAR2,

Line 147: p_to_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_from_cle_id IN NUMBER,
146: p_to_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
147: p_to_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
148: p_to_template_yn IN VARCHAR2,
149: p_copy_reference IN VARCHAR2,
150: p_copy_line_party_yn IN VARCHAR2,
151: p_renew_ref_yn IN VARCHAR2,

Line 160: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

156: -- topline during update service
157:
158: PROCEDURE copy_contract_header(
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_from_chr_id IN NUMBER,

Line 179: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

175: x_chr_id OUT NOCOPY NUMBER);
176:
177: PROCEDURE copy_contract_line(
178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
180: x_return_status OUT NOCOPY VARCHAR2,
181: x_msg_count OUT NOCOPY NUMBER,
182: x_msg_data OUT NOCOPY VARCHAR2,
183: p_from_cle_id IN NUMBER,

Line 185: p_to_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

181: x_msg_count OUT NOCOPY NUMBER,
182: x_msg_data OUT NOCOPY VARCHAR2,
183: p_from_cle_id IN NUMBER,
184: p_from_chr_id IN NUMBER,
185: p_to_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
186: p_to_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
187: p_lse_id IN NUMBER,
188: p_to_template_yn IN VARCHAR2,
189: p_copy_reference IN VARCHAR2 DEFAULT 'COPY',

Line 186: p_to_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

182: x_msg_data OUT NOCOPY VARCHAR2,
183: p_from_cle_id IN NUMBER,
184: p_from_chr_id IN NUMBER,
185: p_to_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
186: p_to_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
187: p_lse_id IN NUMBER,
188: p_to_template_yn IN VARCHAR2,
189: p_copy_reference IN VARCHAR2 DEFAULT 'COPY',
190: p_copy_line_party_yn IN VARCHAR2,

Line 200: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

196: -- topline during update service
197:
198: PROCEDURE copy_party_roles(
199: p_api_version IN NUMBER,
200: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
201: x_return_status OUT NOCOPY VARCHAR2,
202: x_msg_count OUT NOCOPY NUMBER,
203: x_msg_data OUT NOCOPY VARCHAR2,
204: p_cpl_id IN NUMBER,

Line 205: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

201: x_return_status OUT NOCOPY VARCHAR2,
202: x_msg_count OUT NOCOPY NUMBER,
203: x_msg_data OUT NOCOPY VARCHAR2,
204: p_cpl_id IN NUMBER,
205: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
206: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
207: p_rle_code IN VARCHAR2,
208: x_cpl_id OUT NOCOPY NUMBER);
209:

Line 206: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

202: x_msg_count OUT NOCOPY NUMBER,
203: x_msg_data OUT NOCOPY VARCHAR2,
204: p_cpl_id IN NUMBER,
205: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
206: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
207: p_rle_code IN VARCHAR2,
208: x_cpl_id OUT NOCOPY NUMBER);
209:
210: PROCEDURE copy_articles(

Line 212: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

208: x_cpl_id OUT NOCOPY NUMBER);
209:
210: PROCEDURE copy_articles(
211: p_api_version IN NUMBER,
212: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
213: x_return_status OUT NOCOPY VARCHAR2,
214: x_msg_count OUT NOCOPY NUMBER,
215: x_msg_data OUT NOCOPY VARCHAR2,
216: p_cat_id IN NUMBER,

Line 217: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

213: x_return_status OUT NOCOPY VARCHAR2,
214: x_msg_count OUT NOCOPY NUMBER,
215: x_msg_data OUT NOCOPY VARCHAR2,
216: p_cat_id IN NUMBER,
217: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
218: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
219: p_sav_sav_release IN VARCHAR2 DEFAULT NULL,
220: x_cat_id OUT NOCOPY NUMBER);
221:

Line 218: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

214: x_msg_count OUT NOCOPY NUMBER,
215: x_msg_data OUT NOCOPY VARCHAR2,
216: p_cat_id IN NUMBER,
217: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
218: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
219: p_sav_sav_release IN VARCHAR2 DEFAULT NULL,
220: x_cat_id OUT NOCOPY NUMBER);
221:
222: PROCEDURE copy_latest_articles(

Line 224: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

220: x_cat_id OUT NOCOPY NUMBER);
221:
222: PROCEDURE copy_latest_articles(
223: p_api_version IN NUMBER,
224: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
225: x_return_status OUT NOCOPY VARCHAR2,
226: x_msg_count OUT NOCOPY NUMBER,
227: x_msg_data OUT NOCOPY VARCHAR2,
228: p_cat_id IN NUMBER,

Line 229: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

225: x_return_status OUT NOCOPY VARCHAR2,
226: x_msg_count OUT NOCOPY NUMBER,
227: x_msg_data OUT NOCOPY VARCHAR2,
228: p_cat_id IN NUMBER,
229: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
230: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
231: x_cat_id OUT NOCOPY NUMBER);
232:
233: PROCEDURE copy_events(

Line 230: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

226: x_msg_count OUT NOCOPY NUMBER,
227: x_msg_data OUT NOCOPY VARCHAR2,
228: p_cat_id IN NUMBER,
229: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
230: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
231: x_cat_id OUT NOCOPY NUMBER);
232:
233: PROCEDURE copy_events(
234: p_api_version IN NUMBER,

Line 235: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

231: x_cat_id OUT NOCOPY NUMBER);
232:
233: PROCEDURE copy_events(
234: p_api_version IN NUMBER,
235: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
236: x_return_status OUT NOCOPY VARCHAR2,
237: x_msg_count OUT NOCOPY NUMBER,
238: x_msg_data OUT NOCOPY VARCHAR2,
239: p_cnh_id IN NUMBER,

Line 240: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

236: x_return_status OUT NOCOPY VARCHAR2,
237: x_msg_count OUT NOCOPY NUMBER,
238: x_msg_data OUT NOCOPY VARCHAR2,
239: p_cnh_id IN NUMBER,
240: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
241: p_to_template_yn IN VARCHAR2,
242: x_cnh_id OUT NOCOPY NUMBER);
243:
244: PROCEDURE copy_rules(

Line 246: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

242: x_cnh_id OUT NOCOPY NUMBER);
243:
244: PROCEDURE copy_rules(
245: p_api_version IN NUMBER,
246: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
247: x_return_status OUT NOCOPY VARCHAR2,
248: x_msg_count OUT NOCOPY NUMBER,
249: x_msg_data OUT NOCOPY VARCHAR2,
250: p_rgp_id IN NUMBER,

Line 251: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

247: x_return_status OUT NOCOPY VARCHAR2,
248: x_msg_count OUT NOCOPY NUMBER,
249: x_msg_data OUT NOCOPY VARCHAR2,
250: p_rgp_id IN NUMBER,
251: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
252: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
253: p_to_template_yn IN VARCHAR2,
254: x_rgp_id OUT NOCOPY NUMBER);
255:

Line 252: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

248: x_msg_count OUT NOCOPY NUMBER,
249: x_msg_data OUT NOCOPY VARCHAR2,
250: p_rgp_id IN NUMBER,
251: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
252: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
253: p_to_template_yn IN VARCHAR2,
254: x_rgp_id OUT NOCOPY NUMBER);
255:
256: -- Bug 2950549 Added following 2 procedures add_concurrent and