APPS.IEU_WP_ACTION_PVT dependencies on DUAL

Line 51: select IEU_wp_action_maps_S1.NEXTVAL into l_action_map_id from sys.dual;

47: INTO l_count USING l_responsibility_id, l_application_id, rec_obj.action_param_set_id,
48: rec_obj.action_map_code, rec_obj.action_map_type_code;
49:
50: IF (l_count = 0) then
51: select IEU_wp_action_maps_S1.NEXTVAL into l_action_map_id from sys.dual;
52: x_msg_data :=x_msg_data || ' , INSERT INTO maps table with id '|| l_action_map_id;
53: sql_stmt := 'insert INTO IEU_wp_action_mapS'||
54: ' (WP_ACTION_MAP_ID,'||
55: ' OBJECT_VERSION_NUMBER,'||

Line 808: select IEU_wp_act_param_sets_b_S1.NEXTVAL into l_new_param_set_id from sys.dual;

804:
805:
806:
807: if l_wp_maction_def_id is not null then
808: select IEU_wp_act_param_sets_b_S1.NEXTVAL into l_new_param_set_id from sys.dual;
809: /* TYPE IEU_WP_ACT_PARAM_SETS_SEED_PKG.WP_ACT_PARAM_SETS_rec_type IS RECORD (
810: ACTION_PARAM_SET_ID NUMBER(15),
811: WP_ACTION_DEF_ID NUMBER(15),
812: ACTION_PARAM_SET_LABEL VARCHAR2(128),

Line 844: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;

840: OPEN c_cur;
841: Loop
842: FETCH c_cur INTO c_rec;
843: EXIT WHEN c_cur%NOTFOUND;
844: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;
845: /*TYPE IEU_WP_PARAM_PROPS_SEED_PKG.wp_param_props_rec_type IS RECORD (
846: PARAM_PROPERTY_ID NUMBER(15),
847: ACTION_PARAM_SET_ID NUMBER,
848: PARAM_ID NUMBER,

Line 907: select IEU_WP_ACTION_MAPS_S1.NEXTVAL into l_wp_action_map_id from sys.dual;

903: END if;
904:
905:
906: --INSERT one RECORD WITH responsibility_id = -1
907: select IEU_WP_ACTION_MAPS_S1.NEXTVAL into l_wp_action_map_id from sys.dual;
908: EXECUTE immediate
909: ' insert INTO IEU_WP_ACTION_MAPS ' ||
910: ' (WP_ACTION_MAP_ID, '||
911: ' CREATED_BY, '||

Line 951: select IEU_WP_ACTION_MAPS_S1.NEXTVAL into l_wp_action_map_id from sys.dual;

947: l_temp_map_sequence, r_dev_data_flag;
948:
949:
950: --INSERT one RECORD WITH responsibility_id IS null
951: select IEU_WP_ACTION_MAPS_S1.NEXTVAL into l_wp_action_map_id from sys.dual;
952: v_responsibility_id := null;
953: EXECUTE immediate
954: ' insert INTO IEU_WP_ACTION_MAPS '||
955: ' (WP_ACTION_MAP_ID, '||

Line 1185: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;

1181: LOOP
1182: FETCH c_ref2 INTO l_property_id, l_property_value,l_value_override_flag,l_not_valid_flag;
1183: EXIT WHEN c_ref2%NOTFOUND;
1184:
1185: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;
1186: /*TYPE IEU_WP_PARAM_PROPS_SEED_PKG.wp_param_props_rec_type IS RECORD (
1187: PARAM_PROPERTY_ID NUMBER(15),
1188: ACTION_PARAM_SET_ID NUMBER,
1189: PARAM_ID NUMBER,

Line 1567: select IEU_wp_act_param_sets_b_S1.NEXTVAL into l_new_param_set_id from sys.dual;

1563: into l_wp_maction_def_id using r_param_set_id, r_wp_action_key;
1564:
1565:
1566: if l_wp_maction_def_id is not null then
1567: select IEU_wp_act_param_sets_b_S1.NEXTVAL into l_new_param_set_id from sys.dual;
1568: /* TYPE IEU_WP_ACT_PARAM_SETS_SEED_PKG.WP_ACT_PARAM_SETS_rec_type IS RECORD (
1569: ACTION_PARAM_SET_ID NUMBER(15),
1570: WP_ACTION_DEF_ID NUMBER(15),
1571: ACTION_PARAM_SET_LABEL VARCHAR2(128),

Line 1602: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;

1598: OPEN c_cur;
1599: Loop
1600: FETCH c_cur INTO c_rec;
1601: EXIT WHEN c_cur%NOTFOUND;
1602: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;
1603: /*TYPE IEU_WP_PARAM_PROPS_SEED_PKG.wp_param_props_rec_type IS RECORD (
1604: PARAM_PROPERTY_ID NUMBER(15),
1605: ACTION_PARAM_SET_ID NUMBER,
1606: PARAM_ID NUMBER,

Line 1644: select IEU_WP_ACTION_MAPS_S1.NEXTVAL into l_wp_action_map_id from sys.dual;

1640: FETCH c_cur2 INTO c_rec2;
1641: EXIT WHEN c_cur2%NOTFOUND;
1642: l_temp_map_sequence := 1;
1643: --INSERT one RECORD WITH responsibility_id = -1
1644: select IEU_WP_ACTION_MAPS_S1.NEXTVAL into l_wp_action_map_id from sys.dual;
1645: EXECUTE immediate
1646: ' insert INTO IEU_WP_ACTION_MAPS '||
1647: ' (WP_ACTION_MAP_ID, '||
1648: ' CREATED_BY, '||