7: SUBTYPE clev_tbl_type IS OKL_COPY_CONTRACT_PVT.clev_tbl_type;
8: ---------------------------------------------------------------------------
9: -- GLOBAL MESSAGE CONSTANTS
10: ---------------------------------------------------------------------------
11: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
12: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
13: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
14: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
15: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
8: ---------------------------------------------------------------------------
9: -- GLOBAL MESSAGE CONSTANTS
10: ---------------------------------------------------------------------------
11: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
12: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
13: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
14: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
15: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
16: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
9: -- GLOBAL MESSAGE CONSTANTS
10: ---------------------------------------------------------------------------
11: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
12: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
13: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
14: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
15: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
16: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
17: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
10: ---------------------------------------------------------------------------
11: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
12: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
13: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
14: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
15: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
16: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
17: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
18: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
11: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
12: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
13: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
14: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
15: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
16: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
17: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
18: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
19: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
12: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
13: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
14: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
15: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
16: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
17: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
18: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
19: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
20: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
13: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
14: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
15: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
16: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
17: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
18: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
19: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
20: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
21: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
14: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
15: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
16: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
17: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
18: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
19: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
20: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
21: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
22: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
15: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
16: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
17: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
18: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
19: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
20: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
21: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
22: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
23: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
16: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
17: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
18: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
19: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
20: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
21: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
22: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
23: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
24: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UPPERCASE_REQ';
30:
31: -- GLOBAL VARIABLES
32: ---------------------------------------------------------------------------
33: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_COPY_CONTRACT_PUB';
34: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
35: ---------------------------------------------------------------------------
36:
37:
38: SUBTYPE api_components_tbl IS OKL_COPY_CONTRACT_PVT.api_components_tbl;
51: x_new_lse_ids OUT NOCOPY VARCHAR2);
52:
53: PROCEDURE copy_components(
54: p_api_version IN NUMBER,
55: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
56: x_return_status OUT NOCOPY VARCHAR2,
57: x_msg_count OUT NOCOPY NUMBER,
58: x_msg_data OUT NOCOPY VARCHAR2,
59: p_from_chr_id IN NUMBER,
71: x_chr_id OUT NOCOPY NUMBER);
72:
73: PROCEDURE copy_lease_contract(
74: p_api_version IN NUMBER,
75: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
76: x_return_status OUT NOCOPY VARCHAR2,
77: x_msg_count OUT NOCOPY NUMBER,
78: x_msg_data OUT NOCOPY VARCHAR2,
79: p_commit IN VARCHAR2 DEFAULT 'F',
87: x_chr_id OUT NOCOPY NUMBER);
88:
89: PROCEDURE copy_lease_contract(
90: p_api_version IN NUMBER,
91: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
92: x_return_status OUT NOCOPY VARCHAR2,
93: x_msg_count OUT NOCOPY NUMBER,
94: x_msg_data OUT NOCOPY VARCHAR2,
95: p_commit IN VARCHAR2 DEFAULT 'F',
104: x_chr_id OUT NOCOPY NUMBER);
105:
106: PROCEDURE copy_lease_contract_new(
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',
121: p_rbk_date IN DATE DEFAULT NULL);
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',
138: x_chr_id OUT NOCOPY NUMBER);
139:
140: PROCEDURE copy_contract(
141: p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_commit IN VARCHAR2 DEFAULT 'F',
153: x_chr_id OUT NOCOPY NUMBER);
154:
155: PROCEDURE copy_contract(
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
158: x_return_status OUT NOCOPY VARCHAR2,
159: x_msg_count OUT NOCOPY NUMBER,
160: x_msg_data OUT NOCOPY VARCHAR2,
161: p_commit IN VARCHAR2 DEFAULT 'F',
169: x_chr_id OUT NOCOPY NUMBER);
170:
171: PROCEDURE copy_contract_lines(
172: p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
176: x_msg_data OUT NOCOPY VARCHAR2,
177: p_from_cle_id IN NUMBER,
184: x_cle_id OUT NOCOPY NUMBER);
185:
186: PROCEDURE copy_rules(
187: p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
189: x_return_status OUT NOCOPY VARCHAR2,
190: x_msg_count OUT NOCOPY NUMBER,
191: x_msg_data OUT NOCOPY VARCHAR2,
192: p_rgp_id IN NUMBER,
189: x_return_status OUT NOCOPY VARCHAR2,
190: x_msg_count OUT NOCOPY NUMBER,
191: x_msg_data OUT NOCOPY VARCHAR2,
192: p_rgp_id IN NUMBER,
193: p_cle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
194: p_chr_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
195: p_to_template_yn IN VARCHAR2,
196: x_rgp_id OUT NOCOPY NUMBER);
197:
190: x_msg_count OUT NOCOPY NUMBER,
191: x_msg_data OUT NOCOPY VARCHAR2,
192: p_rgp_id IN NUMBER,
193: p_cle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
194: p_chr_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
195: p_to_template_yn IN VARCHAR2,
196: x_rgp_id OUT NOCOPY NUMBER);
197:
198: PROCEDURE copy_party_roles(
196: x_rgp_id OUT NOCOPY NUMBER);
197:
198: PROCEDURE copy_party_roles(
199: p_api_version IN NUMBER,
200: p_init_msg_list IN VARCHAR2 DEFAULT OKL_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,
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 OKL_API.G_MISS_NUM,
206: p_chr_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
207: P_rle_code IN VARCHAR2,
208: x_cpl_id OUT NOCOPY NUMBER);
209:
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 OKL_API.G_MISS_NUM,
206: p_chr_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
207: P_rle_code IN VARCHAR2,
208: x_cpl_id OUT NOCOPY NUMBER);
209:
210: PROCEDURE copy_articles(
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 OKL_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,
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 OKL_API.G_MISS_NUM,
218: p_chr_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
219: p_sav_sav_release IN VARCHAR2 DEFAULT NULL,
220: x_cat_id OUT NOCOPY NUMBER);
221:
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 OKL_API.G_MISS_NUM,
218: p_chr_id IN NUMBER DEFAULT OKL_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(
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 OKL_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,
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 OKL_API.G_MISS_NUM,
230: p_chr_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
231: x_cat_id OUT NOCOPY NUMBER);
232:
233: END okl_copy_contract_pub;
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 OKL_API.G_MISS_NUM,
230: p_chr_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
231: x_cat_id OUT NOCOPY NUMBER);
232:
233: END okl_copy_contract_pub;