DBA Data[Home] [Help]

APPS.OKS_COVERAGES_PVT dependencies on OKS_ACM_PVT

Line 840: l_act_time_tbl_in OKS_ACM_PVT.oks_action_times_v_tbl_type;

836:
837: l_act_type_tbl_in OKS_ACT_PVT.OksActionTimeTypesVTblType;
838: l_act_type_tbl_out OKS_ACT_PVT.OksActionTimeTypesVTblType;
839:
840: l_act_time_tbl_in OKS_ACM_PVT.oks_action_times_v_tbl_type;
841: l_act_time_tbl_out OKS_ACM_PVT.oks_action_times_v_tbl_type;
842:
843: covtim_ctr NUMBER := 0;
844: acttim_ctr NUMBER := 0;

Line 841: l_act_time_tbl_out OKS_ACM_PVT.oks_action_times_v_tbl_type;

837: l_act_type_tbl_in OKS_ACT_PVT.OksActionTimeTypesVTblType;
838: l_act_type_tbl_out OKS_ACT_PVT.OksActionTimeTypesVTblType;
839:
840: l_act_time_tbl_in OKS_ACM_PVT.oks_action_times_v_tbl_type;
841: l_act_time_tbl_out OKS_ACM_PVT.oks_action_times_v_tbl_type;
842:
843: covtim_ctr NUMBER := 0;
844: acttim_ctr NUMBER := 0;
845: l_cov_templ_yn VARCHAR2(1) := 'Y';

Line 1561: OKS_ACM_PVT.insert_row(p_api_version => l_api_version,

1557: l_act_time_tbl_in(act_time_ctr).fri_duration := act_time_rec.fri_duration;
1558: l_act_time_tbl_in(act_time_ctr).sat_duration := act_time_rec.sat_duration;
1559: END LOOP ; -- END LOOP FOR ACT_TIME_REC
1560:
1561: OKS_ACM_PVT.insert_row(p_api_version => l_api_version,
1562: p_init_msg_list => l_init_msg_list,
1563: x_return_status => l_return_status,
1564: x_msg_count => l_msg_count,
1565: x_msg_data => l_msg_data,

Line 1570: okc_debug.log('After OKS_ACM_PVT insert_row'||l_return_status, 2);

1566: p_oks_action_times_v_tbl => l_act_time_tbl_in,
1567: x_oks_action_times_v_tbl => l_act_time_tbl_out);
1568:
1569: IF (G_DEBUG_ENABLED = 'Y') THEN
1570: okc_debug.log('After OKS_ACM_PVT insert_row'||l_return_status, 2);
1571: END IF;
1572:
1573: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1574: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 2388: l_acmv_tbl_in OKS_ACM_PVT.oks_action_times_v_tbl_type;

2384: l_klev_tbl_in oks_kln_pvt.klnv_tbl_type;
2385: l_tzev_tbl_in OKS_CTZ_PVT.OksCoverageTimezonesVTblType;
2386: l_cvtv_tbl_in OKS_CVT_PVT.oks_coverage_times_v_tbl_type;
2387: l_actv_tbl_in OKS_ACT_PVT.OksActionTimeTypesVTblType;
2388: l_acmv_tbl_in OKS_ACM_PVT.oks_action_times_v_tbl_type;
2389: l_brsv_tbl_in OKS_BRS_PVT.OksBillrateSchedulesVTblType;
2390:
2391:
2392: l_api_version CONSTANT NUMBER := 1.0;

Line 2801: OKS_ACM_PVT.delete_row(

2797:
2798:
2799: IF l_acmv_tbl_in.COUNT > 0 THEN
2800:
2801: OKS_ACM_PVT.delete_row(
2802: p_api_version => l_api_version,
2803: p_init_msg_list => l_init_msg_list,
2804: x_return_status => l_return_status,
2805: x_msg_count => l_msg_count,

Line 2817: okc_debug.log('AFTER OKS_ACM_PVT delete_row', 2);

2813: END IF;
2814:
2815:
2816: IF (G_DEBUG_ENABLED = 'Y') THEN
2817: okc_debug.log('AFTER OKS_ACM_PVT delete_row', 2);
2818:
2819: END IF;
2820:
2821: IF l_actv_tbl_in.COUNT > 0 THEN

Line 6881: l_acm_pvt_tbl_in oks_acm_pvt.oks_action_times_v_tbl_type;

6877:
6878: l_act_pvt_tbl_in oks_act_pvt.OksActionTimeTypesVTblType;
6879: l_act_pvt_tbl_out oks_act_pvt.OksActionTimeTypesVTblType;
6880:
6881: l_acm_pvt_tbl_in oks_acm_pvt.oks_action_times_v_tbl_type;
6882: l_acm_pvt_tbl_out oks_acm_pvt.oks_action_times_v_tbl_type;
6883:
6884: l_new_Bp_line_Id NUMBER := NULL;
6885: l_new_TimeZone_Id NUMBER := NULL;

Line 6882: l_acm_pvt_tbl_out oks_acm_pvt.oks_action_times_v_tbl_type;

6878: l_act_pvt_tbl_in oks_act_pvt.OksActionTimeTypesVTblType;
6879: l_act_pvt_tbl_out oks_act_pvt.OksActionTimeTypesVTblType;
6880:
6881: l_acm_pvt_tbl_in oks_acm_pvt.oks_action_times_v_tbl_type;
6882: l_acm_pvt_tbl_out oks_acm_pvt.oks_action_times_v_tbl_type;
6883:
6884: l_new_Bp_line_Id NUMBER := NULL;
6885: l_new_TimeZone_Id NUMBER := NULL;
6886: l_new_contract_line_id NUMBER;

Line 7915: OKS_ACM_PVT.insert_row(

7911: l_acm_pvt_tbl_in(f).SECURITY_GROUP_ID:= Get_Old_Act_Times_Rec.SECURITY_GROUP_ID;
7912: l_acm_pvt_tbl_in(f).OBJECT_VERSION_NUMBER := Get_Old_Act_Times_Rec.OBJECT_VERSION_NUMBER;
7913:
7914:
7915: OKS_ACM_PVT.insert_row(
7916: p_api_version => l_api_version,
7917: p_init_msg_list => l_init_msg_list,
7918: x_return_status => l_return_status,
7919: x_msg_count => l_msg_count,

Line 7925: okc_debug.log('After OKS_ACM_PVT insert_row'||l_return_status, 2);

7921: p_oks_action_times_v_tbl => l_acm_pvt_tbl_in,
7922: x_oks_action_times_v_tbl => l_acm_pvt_tbl_out);
7923:
7924: IF (G_DEBUG_ENABLED = 'Y') THEN
7925: okc_debug.log('After OKS_ACM_PVT insert_row'||l_return_status, 2);
7926: END IF;
7927:
7928: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
7929: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 8418: PROCEDURE INIT_OKS_ACT_TIME(x_act_type_tbl OUT NOCOPY OKS_ACM_PVT.oks_action_times_v_tbl_type)

8414: x_act_time_tbl(1).last_update_date := OKC_API.G_MISS_DATE;
8415: x_act_time_tbl(1).last_update_login := OKC_API.G_MISS_NUM;
8416: END ;
8417: --===============================================================================
8418: PROCEDURE INIT_OKS_ACT_TIME(x_act_type_tbl OUT NOCOPY OKS_ACM_PVT.oks_action_times_v_tbl_type)
8419:
8420: IS
8421: BEGIN
8422:

Line 8816: l_return_Status := OKS_ACM_PVT.Create_Version(

8812:
8813: IF l_return_Status <> 'S' THEN
8814: RAISE G_EXCEPTION_HALT_VALIDATION;
8815: END IF;
8816: l_return_Status := OKS_ACM_PVT.Create_Version(
8817: p_id => l_chr_id,
8818: p_major_version =>l_major_version);
8819:
8820: IF l_return_Status <> 'S' THEN

Line 8919: l_return_Status := OKS_ACM_PVT.Restore_Version(

8915: IF l_return_Status <> 'S' THEN
8916: RAISE G_EXCEPTION_HALT_VALIDATION;
8917: END IF;
8918:
8919: l_return_Status := OKS_ACM_PVT.Restore_Version(
8920: p_id => l_chr_id,
8921: p_major_version =>l_major_version);
8922:
8923: IF l_return_Status <> 'S' THEN

Line 9335: l_act_time_tbl_in OKS_ACM_PVT.OKS_ACTION_TIMES_V_TBL_TYPE;

9331: -- Reaction Time --
9332: l_act_type_tbl_in OKS_ACT_PVT.OksActionTimeTypesVTblType;
9333: l_act_type_tbl_out OKS_ACT_PVT.OksActionTimeTypesVTblType;
9334:
9335: l_act_time_tbl_in OKS_ACM_PVT.OKS_ACTION_TIMES_V_TBL_TYPE;
9336: l_act_time_tbl_out OKS_ACM_PVT.OKS_ACTION_TIMES_V_TBL_TYPE;
9337:
9338: -- End Reaction Time --
9339:

Line 9336: l_act_time_tbl_out OKS_ACM_PVT.OKS_ACTION_TIMES_V_TBL_TYPE;

9332: l_act_type_tbl_in OKS_ACT_PVT.OksActionTimeTypesVTblType;
9333: l_act_type_tbl_out OKS_ACT_PVT.OksActionTimeTypesVTblType;
9334:
9335: l_act_time_tbl_in OKS_ACM_PVT.OKS_ACTION_TIMES_V_TBL_TYPE;
9336: l_act_time_tbl_out OKS_ACM_PVT.OKS_ACTION_TIMES_V_TBL_TYPE;
9337:
9338: -- End Reaction Time --
9339:
9340: -- Preffered Resource --

Line 9782: OKS_ACM_PVT.UPDATE_ROW( p_api_version => l_api_version,

9778: End if;
9779: End LOOP;
9780: End LOOP;
9781: If cnt1>0 Then
9782: OKS_ACM_PVT.UPDATE_ROW( p_api_version => l_api_version,
9783: p_init_msg_list => l_init_msg_list,
9784: x_return_status => l_return_status,
9785: x_msg_count => l_msg_count,
9786: x_msg_data => l_msg_data,