APPS.IEU_WORK_ACTION_PVT dependencies on DUAL

Line 149: select IEU_WP_NODE_SECTION_MAPS_S1.nextval into l_wp_node_section_map_id from sys.dual;

145:
146:
147: else
148:
149: select IEU_WP_NODE_SECTION_MAPS_S1.nextval into l_wp_node_section_map_id from sys.dual;
150:
151: insert INTO IEU_WP_NODE_SECTION_MAPS
152: (WP_NODE_SECTION_MAP_ID,
153: OBJECT_VERSION_NUMBER,

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

360:
361: l_action_map_id NUMBER(15);
362: BEGIN
363:
364: select IEU_wp_action_maps_S1.NEXTVAL into l_action_map_id from sys.dual;
365:
366: insert INTO IEU_wp_action_mapS
367: (WP_ACTION_MAP_ID,
368: OBJECT_VERSION_NUMBER,

Line 462: select IEU_UWQ_MACTION_DEFS_B_S1.NEXTVAL into l_maction_def_id from sys.dual;

458: l_msg_data,
459: rec_obj, 'Y', p_maction_def_type_flag, null);
460:
461: if (l_return_status = 'S') then
462: select IEU_UWQ_MACTION_DEFS_B_S1.NEXTVAL into l_maction_def_id from sys.dual;
463: if ( p_maction_def_type_flag = 'M' ) then
464: insert INTO IEU_UWQ_MACTION_DEFS_B
465: (MACTION_DEF_ID,
466: CREATED_BY,

Line 550: select IEU_WP_ACT_PARAM_SETS_B_S1.NEXTVAL into l_action_param_set_id from sys.dual;

546: 0
547: );
548:
549: if (p_maction_def_type_flag <> 'N' and p_maction_def_type_flag <> 'M') then
550: select IEU_WP_ACT_PARAM_SETS_B_S1.NEXTVAL into l_action_param_set_id from sys.dual;
551: insert INTO IEU_WP_ACT_PARAM_SETS_B
552: (ACTION_PARAM_SET_ID,
553: CREATED_BY,
554: CREATION_DATE,

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

748: x_msg_count ,
749: x_msg_data ,
750: r_label, r_param_set_id);
751: if x_return_status = 'S' then
752: select IEU_wp_act_param_sets_b_S1.NEXTVAL into l_new_param_set_id from sys.dual;
753:
754: insert into IEU_WP_ACT_PARAM_SETS_B
755: ( ACTION_PARAM_SET_ID,
756: CREATED_BY,

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

794: 1);
795:
796: FOR c_rec in c_cur LOOP
797: begin
798: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;
799: insert INTO IEU_WP_PARAM_PROPS_B
800: (PARAM_PROPERTY_ID,
801: CREATED_BY,
802: CREATION_DATE,