DBA Data[Home] [Help]

APPS.OKS_COVERAGES_PVT dependencies on OKS_COVERAGES_PVT

Line 1: PACKAGE BODY OKS_COVERAGES_PVT AS

1: PACKAGE BODY OKS_COVERAGES_PVT AS
2: /* $Header: OKSRMCVB.pls 120.21 2010/04/16 07:13:00 spingali ship $*/
3:
4: ---------------------------------------------------------------------------
5: -- PROCEDURE Validate_svc_line_id

Line 2476: OKS_COVERAGES_PVT.Validate_Line_id(p_line_id,l_return_status);

2472: -- End of Bug:4535339 by Jvorugan
2473:
2474: x_return_status:=OKC_API.G_Ret_Sts_Success;
2475:
2476: OKS_COVERAGES_PVT.Validate_Line_id(p_line_id,l_return_status);
2477: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2478: -- IF NOT l_Return_Status ='S' THEN
2479: RETURN;
2480: END IF;

Line 2525: OKS_COVERAGES_PVT.INIT_BILL_RATE_LINE(l_brs_tbl_in);

2521:
2522:
2523: FOR BRS_REC IN CUR_GET_BRS_ID(l_line_id) LOOP
2524:
2525: OKS_COVERAGES_PVT.INIT_BILL_RATE_LINE(l_brs_tbl_in);
2526: l_brs_id:= brs_rec.brs_line_id ;
2527: l_brs_tbl_in(1).id := l_brs_id ;
2528:
2529:

Line 3133: Oks_Coverages_Pvt.UNDO_EVENTS (P_line_Id ,

3129: END IF;
3130: END IF;
3131:
3132:
3133: Oks_Coverages_Pvt.UNDO_EVENTS (P_line_Id ,
3134: l_Return_Status ,
3135: l_msg_data ) ;
3136: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS) then
3137: RAISE e_Error;

Line 3140: Oks_Coverages_Pvt.UNDO_Counters (P_line_Id ,

3136: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS) then
3137: RAISE e_Error;
3138: end if;
3139:
3140: Oks_Coverages_Pvt.UNDO_Counters (P_line_Id ,
3141: l_Return_Status ,
3142: l_msg_data ) ;
3143: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS) then
3144: RAISE e_Error;

Line 4321: Oks_Coverages_Pvt.UNDO_EVENTS (P_line_Id ,

4317: END IF;
4318: END IF;
4319:
4320:
4321: Oks_Coverages_Pvt.UNDO_EVENTS (P_line_Id ,
4322: l_Return_Status ,
4323: l_msg_data ) ;
4324: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS)
4325: then

Line 4329: Oks_Coverages_Pvt.UNDO_Counters (P_line_Id ,

4325: then
4326: RAISE e_Error;
4327: end if;
4328:
4329: Oks_Coverages_Pvt.UNDO_Counters (P_line_Id ,
4330: l_Return_Status ,
4331: l_msg_data ) ;
4332: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS)
4333: then

Line 5491: l_ac_rec_in OKS_COVERAGES_PVT.ac_rec_type;

5487: l_Source_contract_Line_Id CONSTANT NUMBER := P_Source_contract_Line_Id;
5488: l_Target_contract_Line_Id CONSTANT NUMBER := P_Target_contract_Line_Id;
5489: l_Actual_coverage_id NUMBER;
5490: l_api_name CONSTANT VARCHAR2(30) := 'create_adjusted_coverage';
5491: l_ac_rec_in OKS_COVERAGES_PVT.ac_rec_type;
5492:
5493: -----------------------------------------
5494: BEGIN
5495:

Line 5536: OKS_COVERAGES_PVT.CREATE_ACTUAL_COVERAGE(

5532: IF (G_DEBUG_ENABLED = 'Y') THEN
5533: okc_debug.log('Before create_actual_coverage', 2);
5534: END IF;
5535:
5536: OKS_COVERAGES_PVT.CREATE_ACTUAL_COVERAGE(
5537: p_api_version => l_api_version,
5538: p_init_msg_list => 'F',
5539: x_return_status => l_return_status,
5540: x_msg_count => l_msg_count,

Line 6113: G_PKG_NAME VARCHAR2(80):= 'OKS_COVERAGES_PVT' ;

6109: l_return_status VARCHAR2(1);
6110: l_msg_count NUMBER;
6111: l_msg_data VARCHAR2(2000):=null;
6112: l_api_name VARCHAR2(80):= 'OKS_MIGRATE_BILLRATES';
6113: G_PKG_NAME VARCHAR2(80):= 'OKS_COVERAGES_PVT' ;
6114:
6115: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type ;
6116: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type ;
6117: BEGIN

Line 6259: G_PKG_NAME VARCHAR2(80):= 'OKS_COVERAGES_PVT' ;

6255: l_return_status VARCHAR2(1);
6256: l_msg_count NUMBER;
6257: l_msg_data VARCHAR2(2000):=null;
6258: l_api_name VARCHAR2(80):= 'OKS_BILLRATE_MAPPING';
6259: G_PKG_NAME VARCHAR2(80):= 'OKS_COVERAGES_PVT' ;
6260:
6261: l_bill_rate_tbl_in OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE ;
6262: x_bill_rate_tbl_out OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE ;
6263: l_clev_tbl_in OKC_CONTRACT_PUB.clev_tbl_type ;

Line 6911: G_PKG_NAME VARCHAR2(80):= 'OKS_COVERAGES_PVT' ;

6907: l_msg_index_out Number;
6908:
6909: l_msg_data VARCHAR2(2000):=null;
6910: l_api_name VARCHAR2(80):= 'OKS_COPY_COVERAGE';
6911: G_PKG_NAME VARCHAR2(80):= 'OKS_COVERAGES_PVT' ;
6912: l_validate_yn VARCHAR2(1):= 'N';
6913: l_orig_sys_id1 NUMBER;
6914: i NUMBER:= 0;
6915: l_bp_id NUMBER;

Line 8460: x_days_overlap OUT NOCOPY oks_coverages_pvt.billrate_day_overlap_type,

8456: END ;
8457: --============================================================================
8458:
8459: PROCEDURE VALIDATE_COVERTIME(p_tze_line_id IN NUMBER,
8460: x_days_overlap OUT NOCOPY oks_coverages_pvt.billrate_day_overlap_type,
8461: x_return_status OUT NOCOPY VARCHAR2)
8462: IS
8463: G_PKG_NAME VARCHAR2(40):= 'OKS_COVERAGES_PVT';
8464:

Line 8463: G_PKG_NAME VARCHAR2(40):= 'OKS_COVERAGES_PVT';

8459: PROCEDURE VALIDATE_COVERTIME(p_tze_line_id IN NUMBER,
8460: x_days_overlap OUT NOCOPY oks_coverages_pvt.billrate_day_overlap_type,
8461: x_return_status OUT NOCOPY VARCHAR2)
8462: IS
8463: G_PKG_NAME VARCHAR2(40):= 'OKS_COVERAGES_PVT';
8464:
8465: TYPE covertime_schedule_rec IS RECORD
8466: (start_time NUMBER,
8467: end_time NUMBER);

Line 11246: END OKS_COVERAGES_PVT;

11242: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
11243: ROLLBACK to copy_standard_coverage;
11244:
11245: END COPY_STANDARD_COVERAGE;
11246: END OKS_COVERAGES_PVT;
11247: