APPS.IEU_SEED_DATA_LOADER_PKG dependencies on IEU_WP_NODE_SECTION_MAPS

Line 992: l_wp_node_section_map_id ieu_wp_node_section_maps.wp_node_section_map_id%type;

988: user_id number := FND_GLOBAL.USER_ID;
989: created_id number := FND_GLOBAL.USER_ID;
990: l_temp_map_sequence ieu_wp_action_maps.action_map_sequence%type;
991: l_section_id ieu_wp_sections_b.section_id%type;
992: l_wp_node_section_map_id ieu_wp_node_section_maps.wp_node_section_map_id%type;
993: l_sequence number:=0;
994: l_def_flag ieu_uwq_maction_defs_b.maction_def_type_flag%type;
995: l_last_updated_by ieu_wp_action_maps.last_updated_by%type;
996: begin

Line 1134: update ieu_wp_node_section_maps

1130: end if;
1131:
1132: if l_section_id is not null then
1133: begin
1134: update ieu_wp_node_section_maps
1135: set LAST_UPDATED_BY = user_id,
1136: LAST_UPDATE_DATE = decode(P_LAST_UPDATE_DATE, null,SYSDATE,to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD')),
1137: LAST_UPDATE_LOGIN = 0,
1138: OBJECT_VERSION_NUMBER = nvl(object_version_number,0) +1

Line 1151: select IEU_WP_NODE_SECTION_MAPS_S1.NEXTVAL into l_wp_node_section_map_id from sys.dual;

1147:
1148: exception
1149: when NO_DATA_FOUND then
1150:
1151: select IEU_WP_NODE_SECTION_MAPS_S1.NEXTVAL into l_wp_node_section_map_id from sys.dual;
1152: insert into ieu_wp_node_section_maps
1153: ( wp_node_section_map_id ,
1154: CREATED_BY,
1155: CREATION_DATE,

Line 1152: insert into ieu_wp_node_section_maps

1148: exception
1149: when NO_DATA_FOUND then
1150:
1151: select IEU_WP_NODE_SECTION_MAPS_S1.NEXTVAL into l_wp_node_section_map_id from sys.dual;
1152: insert into ieu_wp_node_section_maps
1153: ( wp_node_section_map_id ,
1154: CREATED_BY,
1155: CREATION_DATE,
1156: LAST_UPDATED_BY,