27: ac_rec_in ac_rec_type;
28: ---------------------------------------------------------------------------
29: -- GLOBAL MESSAGE CONSTANTS
30: ---------------------------------------------------------------------------
31: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
32: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
33: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
34: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
35: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
28: ---------------------------------------------------------------------------
29: -- GLOBAL MESSAGE CONSTANTS
30: ---------------------------------------------------------------------------
31: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
32: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
33: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
34: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
35: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
36: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
29: -- GLOBAL MESSAGE CONSTANTS
30: ---------------------------------------------------------------------------
31: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
32: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
33: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
34: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
35: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
36: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
37: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
30: ---------------------------------------------------------------------------
31: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
32: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
33: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
34: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
35: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
36: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
37: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
38: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
31: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
32: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
33: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
34: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
35: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
36: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
37: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
38: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
39: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
32: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
33: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
34: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
35: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
36: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
37: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
38: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
39: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
40: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
33: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
34: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
35: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
36: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
37: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
38: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
39: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
40: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
41: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXP_ERROR';
34: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
35: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
36: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
37: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
38: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
39: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
40: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
41: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXP_ERROR';
42: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
35: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
36: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
37: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
38: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
39: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
40: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
41: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXP_ERROR';
42: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
43: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
36: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
37: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
38: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
39: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
40: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
41: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXP_ERROR';
42: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
43: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
44: ------------------------------------------------------------------------------------
50:
51: -- GLOBAL VARIABLES
52: ---------------------------------------------------------------------------
53: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_COVERAGES_PVT';
54: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
55: ---------------------------------------------------------------------------
56:
57: G_DEBUG_ENABLED VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
58:
67: p_line_id IN NUMBER,
68: x_return_status OUT NOCOPY VARCHAR2);
69: PROCEDURE CREATE_ACTUAL_COVERAGE(
70: p_api_version IN NUMBER,
71: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
72: x_return_status OUT NOCOPY VARCHAR2,
73: x_msg_count OUT NOCOPY NUMBER,
74: x_msg_data OUT NOCOPY VARCHAR2,
75: p_ac_rec_in IN ac_rec_type,
76: p_restricted_update IN VARCHAR2 DEFAULT 'F',
77: x_Actual_coverage_id OUT NOCOPY NUMBER);
78: PROCEDURE Undo_Header(
79: p_api_version IN NUMBER,
80: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
81: x_return_status OUT NOCOPY VARCHAR2,
82: x_msg_count OUT NOCOPY NUMBER,
83: x_msg_data OUT NOCOPY VARCHAR2,
84: P_Header_id IN NUMBER);
83: x_msg_data OUT NOCOPY VARCHAR2,
84: P_Header_id IN NUMBER);
85: PROCEDURE Undo_Line(
86: p_api_version IN NUMBER,
87: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
88: x_return_status OUT NOCOPY VARCHAR2,
89: x_msg_count OUT NOCOPY NUMBER,
90: x_msg_data OUT NOCOPY VARCHAR2,
91: P_Line_Id IN NUMBER);
92:
93: /* New one with validate status */
94: PROCEDURE Undo_Line(
95: p_api_version IN NUMBER,
96: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
97: p_validate_status IN VARCHAR2 DEFAULT 'N',
98: x_return_status OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,
100: x_msg_data OUT NOCOPY VARCHAR2,
108: x_Return_Status OUT NOCOPY VARCHAR2,
109: x_msg_data OUT NOCOPY VARCHAR2);
110: PROCEDURE Update_COVERAGE_Effectivity(
111: p_api_version IN NUMBER,
112: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
113: x_return_status OUT NOCOPY VARCHAR2,
114: x_msg_count OUT NOCOPY NUMBER,
115: x_msg_data OUT NOCOPY VARCHAR2,
116: p_service_Line_Id IN NUMBER,
136:
137:
138: PROCEDURE CREATE_ADJUSTED_COVERAGE(
139: p_api_version IN NUMBER,
140: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
144: P_Source_contract_Line_Id IN NUMBER,
245: x_return_status OUT NOCOPY VARCHAR2);
246:
247: PROCEDURE OKS_MIGRATE_BILLRATES(
248: p_api_version IN NUMBER,
249: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
250: x_return_status OUT NOCOPY VARCHAR2,
251: x_msg_count OUT NOCOPY NUMBER,
252: x_msg_data OUT NOCOPY VARCHAR2);
253:
276:
277:
278: PROCEDURE OKS_BILLRATE_MAPPING(
279: p_api_version IN NUMBER ,
280: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
281: p_business_process_id IN NUMBER,
282: p_time_labor_tbl_in IN time_labor_tbl,
283: x_return_status OUT NOCOPY VARCHAR2,
284: x_msg_count OUT NOCOPY NUMBER,
284: x_msg_count OUT NOCOPY NUMBER,
285: x_msg_data OUT NOCOPY VARCHAR2);
286:
287: PROCEDURE Copy_Coverage(p_api_version IN NUMBER,
288: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
289: x_return_status OUT NOCOPY VARCHAR2,
290: x_msg_count OUT NOCOPY NUMBER,
291: x_msg_data OUT NOCOPY VARCHAR2,
292: p_contract_line_id IN NUMBER);
304: PROCEDURE INIT_OKS_ACT_TIME(x_act_type_tbl OUT NOCOPY OKS_ACM_PVT.oks_action_times_v_tbl_type);
305:
306:
307: PROCEDURE MIGRATE_PRIMARY_RESOURCES(p_api_version IN NUMBER,
308: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
309: x_return_status OUT NOCOPY VARCHAR2,
310: x_msg_count OUT NOCOPY NUMBER,
311: x_msg_data OUT NOCOPY VARCHAR2) ;
312:
384:
385:
386: Procedure CHECK_COVERAGE_MATCH
387: ( p_api_version IN NUMBER,
388: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
389: x_return_status OUT NOCOPY VARCHAR2,
390: x_msg_count OUT NOCOPY NUMBER,
391: x_msg_data OUT NOCOPY VARCHAR2,
392: P_Source_contract_Line_Id IN NUMBER,
395:
396: -- The Following API checks for the Business Procees Line Id IF Time Zone Exists.Returns 'Y' If exists else 'N'
397: Procedure CHECK_TimeZone_Exists
398: ( p_api_version IN NUMBER,
399: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
400: x_return_status OUT NOCOPY VARCHAR2,
401: x_msg_count OUT NOCOPY NUMBER,
402: x_msg_data OUT NOCOPY VARCHAR2,
403: P_BP_Line_ID IN NUMBER,
444: p_chr_id IN NUMBER);
445:
446: PROCEDURE COPY_K_HDR_NOTES
447: (p_api_version IN NUMBER ,
448: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
449: p_chr_id IN NUMBER,
450: x_return_status OUT NOCOPY VARCHAR2,
451: x_msg_count OUT NOCOPY NUMBER,
452: x_msg_data OUT NOCOPY VARCHAR2);
458: p_dnz_chr_id IN NUMBER);
459:
460:
461: PROCEDURE Create_K_coverage_ext(p_api_version IN NUMBER,
462: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
463: p_src_line_id IN NUMBER,
464: p_tgt_line_id IN NUMBER,
465: x_return_status OUT NOCOPY VARCHAR2,
466: x_msg_count OUT NOCOPY NUMBER,
467: x_msg_data OUT NOCOPY VARCHAR2);
468:
469: PROCEDURE COPY_NOTES
470: (p_api_version IN NUMBER ,
471: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
472: p_line_id IN NUMBER,
473: x_return_status OUT NOCOPY VARCHAR2,
474: x_msg_count OUT NOCOPY NUMBER,
475: x_msg_data OUT NOCOPY VARCHAR2);
475: x_msg_data OUT NOCOPY VARCHAR2);
476: --New procedure for copy coverage functionality
477: PROCEDURE COPY_STANDARD_COVERAGE(
478: p_api_version IN NUMBER,
479: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
480: x_return_status OUT NOCOPY VARCHAR2,
481: x_msg_count OUT NOCOPY NUMBER,
482: x_msg_data OUT NOCOPY VARCHAR2,
483: P_old_coverage_id IN NUMBER,