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 7919: OKS_ACM_PVT.insert_row(

7915: l_acm_pvt_tbl_in(f).SECURITY_GROUP_ID:= Get_Old_Act_Times_Rec.SECURITY_GROUP_ID;
7916: l_acm_pvt_tbl_in(f).OBJECT_VERSION_NUMBER := Get_Old_Act_Times_Rec.OBJECT_VERSION_NUMBER;
7917:
7918:
7919: OKS_ACM_PVT.insert_row(
7920: p_api_version => l_api_version,
7921: p_init_msg_list => l_init_msg_list,
7922: x_return_status => l_return_status,
7923: x_msg_count => l_msg_count,

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

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

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

8424: x_act_time_tbl(1).last_update_date := OKC_API.G_MISS_DATE;
8425: x_act_time_tbl(1).last_update_login := OKC_API.G_MISS_NUM;
8426: END ;
8427: --===============================================================================
8428: PROCEDURE INIT_OKS_ACT_TIME(x_act_type_tbl OUT NOCOPY OKS_ACM_PVT.oks_action_times_v_tbl_type)
8429:
8430: IS
8431: BEGIN
8432:

Line 8826: l_return_Status := OKS_ACM_PVT.Create_Version(

8822:
8823: IF l_return_Status <> 'S' THEN
8824: RAISE G_EXCEPTION_HALT_VALIDATION;
8825: END IF;
8826: l_return_Status := OKS_ACM_PVT.Create_Version(
8827: p_id => l_chr_id,
8828: p_major_version =>l_major_version);
8829:
8830: IF l_return_Status <> 'S' THEN

Line 8929: l_return_Status := OKS_ACM_PVT.Restore_Version(

8925: IF l_return_Status <> 'S' THEN
8926: RAISE G_EXCEPTION_HALT_VALIDATION;
8927: END IF;
8928:
8929: l_return_Status := OKS_ACM_PVT.Restore_Version(
8930: p_id => l_chr_id,
8931: p_major_version =>l_major_version);
8932:
8933: IF l_return_Status <> 'S' THEN

Line 9345: l_act_time_tbl_in OKS_ACM_PVT.OKS_ACTION_TIMES_V_TBL_TYPE;

9341: -- Reaction Time --
9342: l_act_type_tbl_in OKS_ACT_PVT.OksActionTimeTypesVTblType;
9343: l_act_type_tbl_out OKS_ACT_PVT.OksActionTimeTypesVTblType;
9344:
9345: l_act_time_tbl_in OKS_ACM_PVT.OKS_ACTION_TIMES_V_TBL_TYPE;
9346: l_act_time_tbl_out OKS_ACM_PVT.OKS_ACTION_TIMES_V_TBL_TYPE;
9347:
9348: -- End Reaction Time --
9349:

Line 9346: l_act_time_tbl_out OKS_ACM_PVT.OKS_ACTION_TIMES_V_TBL_TYPE;

9342: l_act_type_tbl_in OKS_ACT_PVT.OksActionTimeTypesVTblType;
9343: l_act_type_tbl_out OKS_ACT_PVT.OksActionTimeTypesVTblType;
9344:
9345: l_act_time_tbl_in OKS_ACM_PVT.OKS_ACTION_TIMES_V_TBL_TYPE;
9346: l_act_time_tbl_out OKS_ACM_PVT.OKS_ACTION_TIMES_V_TBL_TYPE;
9347:
9348: -- End Reaction Time --
9349:
9350: -- Preffered Resource --

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

9788: End if;
9789: End LOOP;
9790: End LOOP;
9791: If cnt1>0 Then
9792: OKS_ACM_PVT.UPDATE_ROW( p_api_version => l_api_version,
9793: p_init_msg_list => l_init_msg_list,
9794: x_return_status => l_return_status,
9795: x_msg_count => l_msg_count,
9796: x_msg_data => l_msg_data,