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 7879: p_oks_action_time_types_v_tbl => l_act_pvt_tbl_in,

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

Line 7880: x_oks_action_time_types_v_tbl => l_act_pvt_tbl_out);

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

Line 9013: DELETE OKS_ACTION_TIME_TYPES_H

9009: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
9010:
9011: BEGIN
9012:
9013: DELETE OKS_ACTION_TIME_TYPES_H
9014: WHERE dnz_chr_id = l_chr_id;
9015:
9016: DELETE OKS_ACTION_TIMES_H
9017: WHERE dnz_chr_id = l_chr_id;

Line 9112: DELETE OKS_ACTION_TIME_TYPES_H

9108: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
9109: END IF;
9110:
9111:
9112: DELETE OKS_ACTION_TIME_TYPES_H
9113: WHERE dnz_chr_id = l_chr_id
9114: And major_version = -1;
9115:
9116: DELETE OKS_ACTION_TIMES_H

Line 9381: Select id,dnz_chr_id,object_version_number from OKS_ACTION_TIME_TYPES

9377:
9378:
9379:
9380: cursor cur_act_time_type (p_id NUMBER) IS
9381: Select id,dnz_chr_id,object_version_number from OKS_ACTION_TIME_TYPES
9382: where cle_id = p_id
9383: AND ACTION_TYPE_CODE IN ('RCN', 'RSN');
9384:
9385:

Line 9761: p_oks_action_time_types_v_tbl => l_act_type_tbl_in,

9757: p_init_msg_list => l_init_msg_list,
9758: x_return_status => l_return_status,
9759: x_msg_count => l_msg_count,
9760: x_msg_data => l_msg_data,
9761: p_oks_action_time_types_v_tbl => l_act_type_tbl_in,
9762: x_oks_action_time_types_v_tbl => l_act_type_tbl_out);
9763: End if;
9764:
9765: cnt1 :=0;

Line 9762: x_oks_action_time_types_v_tbl => l_act_type_tbl_out);

9758: x_return_status => l_return_status,
9759: x_msg_count => l_msg_count,
9760: x_msg_data => l_msg_data,
9761: p_oks_action_time_types_v_tbl => l_act_type_tbl_in,
9762: x_oks_action_time_types_v_tbl => l_act_type_tbl_out);
9763: End if;
9764:
9765: cnt1 :=0;
9766: -- End Update oks_action_types line