DBA Data[Home] [Help]

APPS.OKL_COPY_CONTRACT_PVT dependencies on OKL_API

Line 17: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;

13:
14: ---------------------------------------------------------------------------
15: -- GLOBAL MESSAGE CONSTANTS
16: ---------------------------------------------------------------------------
17: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
18: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
19: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
20: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
21: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

Line 18: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;

14: ---------------------------------------------------------------------------
15: -- GLOBAL MESSAGE CONSTANTS
16: ---------------------------------------------------------------------------
17: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
18: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
19: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
20: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
21: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
22: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

Line 19: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;

15: -- GLOBAL MESSAGE CONSTANTS
16: ---------------------------------------------------------------------------
17: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
18: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
19: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
20: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
21: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
22: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
23: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

Line 20: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;

16: ---------------------------------------------------------------------------
17: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
18: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
19: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
20: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
21: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
22: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
23: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
24: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

Line 21: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

17: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
18: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
19: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
20: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
21: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
22: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
23: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
24: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
25: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

Line 22: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

18: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
19: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
20: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
21: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
22: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
23: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
24: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
25: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
26: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

Line 23: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

19: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
20: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
21: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
22: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
23: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
24: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
25: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
26: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
27: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';

Line 24: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

20: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
21: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
22: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
23: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
24: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
25: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
26: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
27: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';
28: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

Line 25: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

21: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
22: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
23: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
24: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
25: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
26: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
27: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';
28: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
29: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

Line 26: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

22: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
23: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
24: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
25: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
26: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
27: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';
28: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
29: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
30: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UPPERCASE_REQ';

Line 42: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

38:
39: -- GLOBAL VARIABLES
40: ---------------------------------------------------------------------------
41: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_COPY_CONTRACT_PVT';
42: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
43: ---------------------------------------------------------------------------
44:
45: TYPE api_components_rec IS RECORD(id NUMBER,
46: to_k NUMBER,

Line 72: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

68: x_new_lse_count OUT NOCOPY NUMBER,
69: x_new_lse_ids OUT NOCOPY VARCHAR2);
70: PROCEDURE copy_components(
71: p_api_version IN NUMBER,
72: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
73: x_return_status OUT NOCOPY VARCHAR2,
74: x_msg_count OUT NOCOPY NUMBER,
75: x_msg_data OUT NOCOPY VARCHAR2,
76: p_from_chr_id IN NUMBER,

Line 92: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

88: x_chr_id OUT NOCOPY NUMBER);
89:
90: PROCEDURE copy_contract(
91: p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_commit IN VARCHAR2 DEFAULT 'F',

Line 108: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

104: x_chr_id OUT NOCOPY NUMBER);
105:
106: PROCEDURE copy_lease_contract(
107: p_api_version IN NUMBER,
108: p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_commit IN VARCHAR2 DEFAULT 'F',

Line 125: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

121: x_chr_id OUT NOCOPY NUMBER);
122:
123: PROCEDURE copy_lease_contract_new(
124: p_api_version IN NUMBER,
125: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_msg_count OUT NOCOPY NUMBER,
128: x_msg_data OUT NOCOPY VARCHAR2,
129: p_commit IN VARCHAR2 DEFAULT 'F',

Line 143: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

139: p_rbk_date IN DATE DEFAULT NULL);
140:
141: Procedure copy_contract_lines(
142: p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
144: x_return_status OUT NOCOPY VARCHAR2,
145: x_msg_count OUT NOCOPY NUMBER,
146: x_msg_data OUT NOCOPY VARCHAR2,
147: p_from_cle_id IN NUMBER,

Line 158: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

154: x_cle_id OUT NOCOPY NUMBER);
155:
156: PROCEDURE copy_rules(
157: p_api_version IN NUMBER,
158: p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_rgp_id IN NUMBER,

Line 163: p_cle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,

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

Line 164: p_chr_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,

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

Line 170: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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

Line 175: p_cle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,

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

Line 176: p_chr_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,

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

Line 182: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

178: x_cpl_id OUT NOCOPY NUMBER);
179:
180: PROCEDURE copy_articles(
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_cat_id IN NUMBER,

Line 187: p_cle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,

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

Line 188: p_chr_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,

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

Line 194: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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

Line 199: p_cle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,

195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2,
198: p_cat_id IN NUMBER,
199: p_cle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
200: p_chr_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
201: x_cat_id OUT NOCOPY NUMBER);
202:
203: -- bug 3630858

Line 200: p_chr_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,

196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2,
198: p_cat_id IN NUMBER,
199: p_cle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
200: p_chr_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
201: x_cat_id OUT NOCOPY NUMBER);
202:
203: -- bug 3630858
204: PROCEDURE copy_product_options

Line 206: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

202:
203: -- bug 3630858
204: PROCEDURE copy_product_options
205: (p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
207: x_return_status OUT NOCOPY VARCHAR2,
208: x_msg_count OUT NOCOPY NUMBER,
209: x_msg_data OUT NOCOPY VARCHAR2,
210: p_new_khr_id IN NUMBER,