eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_COVERAGES_PVT dependencies on OKS_ACTION_TIME_TYPES

Line 737: FROM OKS_ACTION_TIME_TYPES

733:
734: CURSOR CUR_GET_ACTION_TYPES(p_cle_id IN NUMBER) IS
735: SELECT ID,
736: ACTION_TYPE_CODE
737: FROM OKS_ACTION_TIME_TYPES
738: WHERE cle_id = p_cle_id ;
739:
740:
741: CURSOR CUR_GET_ACTION_TIMES(p_cov_act_type_id IN NUMBER) IS

Line 1527: p_oks_action_time_types_v_tbl => l_act_type_tbl_in,

1523: p_init_msg_list => l_init_msg_list,
1524: x_return_status => l_return_status,
1525: x_msg_count => l_msg_count,
1526: x_msg_data => l_msg_data,
1527: p_oks_action_time_types_v_tbl => l_act_type_tbl_in,
1528: x_oks_action_time_types_v_tbl => l_act_type_tbl_out);
1529:
1530: IF (G_DEBUG_ENABLED = 'Y') THEN
1531: okc_debug.log('After OKS_ACT_PVT INSERT_ROW'||l_return_status, 2);

Line 1528: x_oks_action_time_types_v_tbl => l_act_type_tbl_out);

1524: x_return_status => l_return_status,
1525: x_msg_count => l_msg_count,
1526: x_msg_data => l_msg_data,
1527: p_oks_action_time_types_v_tbl => l_act_type_tbl_in,
1528: x_oks_action_time_types_v_tbl => l_act_type_tbl_out);
1529:
1530: IF (G_DEBUG_ENABLED = 'Y') THEN
1531: okc_debug.log('After OKS_ACT_PVT INSERT_ROW'||l_return_status, 2);
1532: END IF;

Line 2345: FROM OKS_ACTION_TIME_TYPES

2341: AND dnz_chr_id =p_dnz_chr_id;
2342:
2343: CURSOR Action_type_Csr (p_ID IN NUMBER,p_DNZ_CHR_ID IN NUMBER) IS
2344: SELECT ID,DNZ_CHR_ID
2345: FROM OKS_ACTION_TIME_TYPES
2346: WHERE cle_id = p_iD
2347: AND dnz_chr_id =p_dnz_chr_id;
2348:
2349: CURSOR Action_times_Csr (p_ID IN NUMBER,p_DNZ_CHR_ID IN NUMBER) IS

Line 2829: p_oks_action_time_types_v_tbl => l_actv_tbl_in);

2825: p_init_msg_list => l_init_msg_list,
2826: x_return_status => l_return_status,
2827: x_msg_count => l_msg_count,
2828: x_msg_data => l_msg_data,
2829: p_oks_action_time_types_v_tbl => l_actv_tbl_in);
2830:
2831:
2832:
2833: IF NOT (l_return_status = OKC_API.G_RET_STS_SUCCESS) then

Line 4535: OKS_ACTION_TIME_TYPES act,

4531: NVL(acm.fri_duration,0) fri_duration,
4532: NVL(acm.sat_duration,0) sat_duration
4533: FROM OKC_K_LINES_B lines,
4534: OKS_K_LINES_V oksl,
4535: OKS_ACTION_TIME_TYPES act,
4536: OKS_ACTION_TIMES acm
4537: WHERE lines.cle_id = p_cle_id
4538: AND lines.lse_id IN (4,17,22)
4539: AND oksl.cle_id = lines.id

Line 7114: FROM OKS_ACTION_TIME_TYPES

7110: SELECT ID,
7111: DNZ_CHR_ID,
7112: ACTION_TYPE_CODE,
7113: OBJECT_VERSION_NUMBER
7114: FROM OKS_ACTION_TIME_TYPES
7115: WHERE CLE_ID = P_RT_ID
7116: AND DNZ_CHR_ID = P_DNZ_CHR_ID;
7117:
7118: CURSOR Get_Old_Act_Times_Cur (p_act_pvt_ID IN NUMBER,P_Act_Dnz_Chr_ID IN NUMBER) IS

Line 7883: p_oks_action_time_types_v_tbl => l_act_pvt_tbl_in,

7879: p_init_msg_list => l_init_msg_list,
7880: x_return_status => l_return_status,
7881: x_msg_count => l_msg_count,
7882: x_msg_data => l_msg_data,
7883: p_oks_action_time_types_v_tbl => l_act_pvt_tbl_in,
7884: x_oks_action_time_types_v_tbl => l_act_pvt_tbl_out);
7885:
7886: IF (G_DEBUG_ENABLED = 'Y') THEN
7887: okc_debug.log('After oks_act_pvt insert_row'||l_return_status, 2);

Line 7884: x_oks_action_time_types_v_tbl => l_act_pvt_tbl_out);

7880: x_return_status => l_return_status,
7881: x_msg_count => l_msg_count,
7882: x_msg_data => l_msg_data,
7883: p_oks_action_time_types_v_tbl => l_act_pvt_tbl_in,
7884: x_oks_action_time_types_v_tbl => l_act_pvt_tbl_out);
7885:
7886: IF (G_DEBUG_ENABLED = 'Y') THEN
7887: okc_debug.log('After oks_act_pvt insert_row'||l_return_status, 2);
7888: END IF;

Line 9023: DELETE OKS_ACTION_TIME_TYPES_H

9019: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
9020:
9021: BEGIN
9022:
9023: DELETE OKS_ACTION_TIME_TYPES_H
9024: WHERE dnz_chr_id = l_chr_id;
9025:
9026: DELETE OKS_ACTION_TIMES_H
9027: WHERE dnz_chr_id = l_chr_id;

Line 9122: DELETE OKS_ACTION_TIME_TYPES_H

9118: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
9119: END IF;
9120:
9121:
9122: DELETE OKS_ACTION_TIME_TYPES_H
9123: WHERE dnz_chr_id = l_chr_id
9124: And major_version = -1;
9125:
9126: DELETE OKS_ACTION_TIMES_H

Line 9391: Select id,dnz_chr_id,object_version_number from OKS_ACTION_TIME_TYPES

9387:
9388:
9389:
9390: cursor cur_act_time_type (p_id NUMBER) IS
9391: Select id,dnz_chr_id,object_version_number from OKS_ACTION_TIME_TYPES
9392: where cle_id = p_id
9393: AND ACTION_TYPE_CODE IN ('RCN', 'RSN');
9394:
9395:

Line 9771: p_oks_action_time_types_v_tbl => l_act_type_tbl_in,

9767: p_init_msg_list => l_init_msg_list,
9768: x_return_status => l_return_status,
9769: x_msg_count => l_msg_count,
9770: x_msg_data => l_msg_data,
9771: p_oks_action_time_types_v_tbl => l_act_type_tbl_in,
9772: x_oks_action_time_types_v_tbl => l_act_type_tbl_out);
9773: End if;
9774:
9775: cnt1 :=0;

Line 9772: x_oks_action_time_types_v_tbl => l_act_type_tbl_out);

9768: x_return_status => l_return_status,
9769: x_msg_count => l_msg_count,
9770: x_msg_data => l_msg_data,
9771: p_oks_action_time_types_v_tbl => l_act_type_tbl_in,
9772: x_oks_action_time_types_v_tbl => l_act_type_tbl_out);
9773: End if;
9774:
9775: cnt1 :=0;
9776: -- End Update oks_action_types line