DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PUB dependencies on OKC_API

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

29:
30: ---------------------------------------------------------------------------
31: -- GLOBAL MESSAGE CONSTANTS
32: ---------------------------------------------------------------------------
33: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
34: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
35: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
36: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
37: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

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

30: ---------------------------------------------------------------------------
31: -- GLOBAL MESSAGE CONSTANTS
32: ---------------------------------------------------------------------------
33: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
34: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
35: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
36: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
37: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
38: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

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

31: -- GLOBAL MESSAGE CONSTANTS
32: ---------------------------------------------------------------------------
33: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
34: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
35: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
36: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
37: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
38: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
39: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

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

32: ---------------------------------------------------------------------------
33: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
34: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
35: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
36: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
37: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
38: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
39: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
40: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

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

33: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
34: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
35: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
36: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
37: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
38: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
39: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
40: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
41: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

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

34: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
35: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
36: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
37: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
38: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
39: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
40: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
41: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
42: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

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

35: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
36: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
37: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
38: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
39: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
40: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
41: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
42: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
43: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';

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

36: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
37: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
38: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
39: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
40: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
41: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
42: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
43: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
44: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

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

37: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
38: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
39: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
40: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
41: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
42: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
43: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
44: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
45: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

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

38: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
39: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
40: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
41: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
42: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
43: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
44: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
45: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
46: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UPPERCASE_REQ';

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

52:
53: -- GLOBAL VARIABLES
54: ---------------------------------------------------------------------------
55: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_COPY_CONTRACT_PUB';
56: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
57: ---------------------------------------------------------------------------
58:
59:
60: SUBTYPE api_components_tbl IS OKC_COPY_CONTRACT_PVT.api_components_tbl;

Line 77: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

73: x_new_lse_ids OUT NOCOPY VARCHAR2);
74:
75: PROCEDURE copy_components(
76: p_api_version IN NUMBER,
77: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
78: x_return_status OUT NOCOPY VARCHAR2,
79: x_msg_count OUT NOCOPY NUMBER,
80: x_msg_data OUT NOCOPY VARCHAR2,
81: p_from_chr_id IN NUMBER,

Line 102: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

98: -- above procedure.
99:
100: PROCEDURE copy_contract(
101: p_api_version IN NUMBER,
102: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,
105: x_msg_data OUT NOCOPY VARCHAR2,
106: p_commit IN VARCHAR2 DEFAULT 'F',

Line 120: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 144: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

140: -- change of status of sublines of the topline during update service
141:
142: PROCEDURE copy_contract_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_from_cle_id IN NUMBER,

Line 149: p_to_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,
148: p_from_cle_id IN NUMBER,
149: p_to_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
150: p_to_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
151: p_to_template_yn IN VARCHAR2 DEFAULT 'N',
152: p_copy_reference IN VARCHAR2 DEFAULT 'COPY',
153: p_copy_line_party_yn IN VARCHAR2 DEFAULT 'Y',

Line 150: p_to_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,
148: p_from_cle_id IN NUMBER,
149: p_to_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
150: p_to_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
151: p_to_template_yn IN VARCHAR2 DEFAULT 'N',
152: p_copy_reference IN VARCHAR2 DEFAULT 'COPY',
153: p_copy_line_party_yn IN VARCHAR2 DEFAULT 'Y',
154: p_renew_ref_yn IN VARCHAR2 DEFAULT 'N',

Line 160: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

156: p_change_status IN VARCHAR2 DEFAULT 'Y');
157:
158: PROCEDURE copy_rules(
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_rgp_id IN NUMBER,

Line 165: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

161: x_return_status OUT NOCOPY VARCHAR2,
162: x_msg_count OUT NOCOPY NUMBER,
163: x_msg_data OUT NOCOPY VARCHAR2,
164: p_rgp_id IN NUMBER,
165: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
166: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
167: p_to_template_yn IN VARCHAR2,
168: x_rgp_id OUT NOCOPY NUMBER);
169:

Line 166: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

162: x_msg_count OUT NOCOPY NUMBER,
163: x_msg_data OUT NOCOPY VARCHAR2,
164: p_rgp_id IN NUMBER,
165: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
166: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
167: p_to_template_yn IN VARCHAR2,
168: x_rgp_id OUT NOCOPY NUMBER);
169:
170: PROCEDURE copy_party_roles(

Line 172: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

168: x_rgp_id OUT NOCOPY NUMBER);
169:
170: PROCEDURE copy_party_roles(
171: p_api_version IN NUMBER,
172: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
173: x_return_status OUT NOCOPY VARCHAR2,
174: x_msg_count OUT NOCOPY NUMBER,
175: x_msg_data OUT NOCOPY VARCHAR2,
176: p_cpl_id IN NUMBER,

Line 177: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

173: x_return_status OUT NOCOPY VARCHAR2,
174: x_msg_count OUT NOCOPY NUMBER,
175: x_msg_data OUT NOCOPY VARCHAR2,
176: p_cpl_id IN NUMBER,
177: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
178: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
179: P_rle_code IN VARCHAR2,
180: x_cpl_id OUT NOCOPY NUMBER);
181:

Line 178: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

174: x_msg_count OUT NOCOPY NUMBER,
175: x_msg_data OUT NOCOPY VARCHAR2,
176: p_cpl_id IN NUMBER,
177: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
178: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
179: P_rle_code IN VARCHAR2,
180: x_cpl_id OUT NOCOPY NUMBER);
181:
182: PROCEDURE copy_articles(

Line 184: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

180: x_cpl_id OUT NOCOPY NUMBER);
181:
182: PROCEDURE copy_articles(
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_cat_id IN NUMBER,

Line 189: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

185: x_return_status OUT NOCOPY VARCHAR2,
186: x_msg_count OUT NOCOPY NUMBER,
187: x_msg_data OUT NOCOPY VARCHAR2,
188: p_cat_id IN NUMBER,
189: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
190: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
191: p_sav_sav_release IN VARCHAR2 DEFAULT NULL,
192: x_cat_id OUT NOCOPY NUMBER);
193:

Line 190: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

186: x_msg_count OUT NOCOPY NUMBER,
187: x_msg_data OUT NOCOPY VARCHAR2,
188: p_cat_id IN NUMBER,
189: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
190: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
191: p_sav_sav_release IN VARCHAR2 DEFAULT NULL,
192: x_cat_id OUT NOCOPY NUMBER);
193:
194: PROCEDURE copy_latest_articles(

Line 196: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

192: x_cat_id OUT NOCOPY NUMBER);
193:
194: PROCEDURE copy_latest_articles(
195: p_api_version IN NUMBER,
196: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
197: x_return_status OUT NOCOPY VARCHAR2,
198: x_msg_count OUT NOCOPY NUMBER,
199: x_msg_data OUT NOCOPY VARCHAR2,
200: p_cat_id IN NUMBER,

Line 201: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

197: x_return_status OUT NOCOPY VARCHAR2,
198: x_msg_count OUT NOCOPY NUMBER,
199: x_msg_data OUT NOCOPY VARCHAR2,
200: p_cat_id IN NUMBER,
201: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
202: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
203: x_cat_id OUT NOCOPY NUMBER);
204:
205: -- Bug 2950549 - Added this procedure

Line 202: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

198: x_msg_count OUT NOCOPY NUMBER,
199: x_msg_data OUT NOCOPY VARCHAR2,
200: p_cat_id IN NUMBER,
201: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
202: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
203: x_cat_id OUT NOCOPY NUMBER);
204:
205: -- Bug 2950549 - Added this procedure
206: PROCEDURE copy_concurrent(errbuf out NOCOPY VARCHAR2,