DBA Data[Home] [Help]

APPS.OKS_COVERAGE_MIGRATION dependencies on OKS_ACTION_TIME_TYPES

Line 1459: p_oks_action_time_types_v_tbl => l_actv_tbl_in,

1455: IF l_actv_tbl_in.count > 0 THEN
1456: OKS_ACT_PVT.insert_row
1457: (
1458: x_return_status => l_return_status,
1459: p_oks_action_time_types_v_tbl => l_actv_tbl_in,
1460: p_api_version =>1,
1461: p_init_msg_list => null,
1462: x_msg_count => x_msg_count,
1463: x_msg_data => x_msg_data,

Line 1464: x_oks_action_time_types_v_tbl => X_actv_tbl_in

1460: p_api_version =>1,
1461: p_init_msg_list => null,
1462: x_msg_count => x_msg_count,
1463: x_msg_data => x_msg_data,
1464: x_oks_action_time_types_v_tbl => X_actv_tbl_in
1465: );
1466: END IF;
1467:
1468: l_actv_tbl_in.DELETE;

Line 1555: FROM oks_action_time_types_v TYP,

1551: RIN.DURATION DURATION,
1552: TIM.DAY_OF_WEEK DAY_OF_WEEK,
1553: TIM.TVE_TYPE TVE_TYPE,
1554: Rul.ID RUL_ID
1555: FROM oks_action_time_types_v TYP,
1556: okc_rule_groups_V RGP,okc_rules_v RUL,
1557: okc_timevalues_v TIM,okc_react_intervals RIN
1558: WHERE RGP.CLE_ID = TYP.CLE_ID
1559: AND RGP.DNZ_CHR_ID = TYP.DNZ_CHR_ID

Line 4355: FROM OKS_ACTION_TIME_TYPES

4351: WHERE ID = P_ID;
4352:
4353: CURSOR Get_Action_Time_Types (p_Cle_Id IN NUMBER)Is
4354: Select ID
4355: FROM OKS_ACTION_TIME_TYPES
4356: WHERE CLE_ID = p_Cle_ID;
4357:
4358: CURSOR Get_Action_Type_Id (p_Id IN NUMBER) IS
4359: SELECT CLE_ID,object_version_number --CLE_ID

Line 4679: FROM oks_action_time_types_h TYP,

4675: TIM.DAY_OF_WEEK DAY_OF_WEEK,
4676: TIM.TVE_TYPE TVE_TYPE,
4677: Rul.ID RUL_ID,
4678: Rul.major_version Rul_major_version
4679: FROM oks_action_time_types_h TYP,
4680: okc_rule_groups_bh RGP,okc_rules_bh RUL,
4681: okc_timevalues_bh TIM,okc_react_intervals_h RIN
4682: WHERE RGP.CLE_ID = TYP.CLE_ID
4683: AND RGP.DNZ_CHR_ID = TYP.DNZ_CHR_ID