[Home] [Help]
928:
929: d_progress := 360;
930: SELECT Count(*)
931: INTO l_xd_present
932: FROM EGO_ACTION_DISPLAYS_B, EGO_ACTIONS_B
933: WHERE classification_code = p_template_id
934: AND attr_group_id = l_attr_group_id
935: AND execution_method = 'XD'
936: AND EGO_ACTION_DISPLAYS_B.action_id = EGO_ACTIONS_B.action_id;
932: FROM EGO_ACTION_DISPLAYS_B, EGO_ACTIONS_B
933: WHERE classification_code = p_template_id
934: AND attr_group_id = l_attr_group_id
935: AND execution_method = 'XD'
936: AND EGO_ACTION_DISPLAYS_B.action_id = EGO_ACTIONS_B.action_id;
937:
938: d_progress := 370;
939: IF l_xd_present <= 0 THEN
940: -- XD Function is not present and the ag need not be added
1257:
1258:
1259:
1260: CURSOR c_get_action_id(p_template_id NUMBER, p_attribute_group_id NUMBER, p_event VARCHAR2) IS
1261: SELECT EGO_ACTION_DISPLAYS_B.action_id FROM EGO_ACTION_DISPLAYS_B, EGO_ACTIONS_B
1262: WHERE classification_code = p_template_id
1263: AND attr_group_id = p_attribute_group_id
1264: AND execution_method = p_event
1265: AND EGO_ACTION_DISPLAYS_B.action_id = EGO_ACTIONS_B.action_id
1261: SELECT EGO_ACTION_DISPLAYS_B.action_id FROM EGO_ACTION_DISPLAYS_B, EGO_ACTIONS_B
1262: WHERE classification_code = p_template_id
1263: AND attr_group_id = p_attribute_group_id
1264: AND execution_method = p_event
1265: AND EGO_ACTION_DISPLAYS_B.action_id = EGO_ACTIONS_B.action_id
1266: ORDER BY SEQUENCE;
1267:
1268:
1269: l_pk_col_name_value_pairs_ind NUMBER;