APPS.IEU_SEED_DATA_LOADER_PKG dependencies on IEU_WP_ACTION_MAPS

Line 990: l_temp_map_sequence ieu_wp_action_maps.action_map_sequence%type;

986: x_msg_count NUMBER:=0;
987: x_msg_data VARCHAR2(2000);
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;

Line 995: l_last_updated_by ieu_wp_action_maps.last_updated_by%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
997: --call UpdateParamProps to make sure all actions have all properties which they should have
998: IEU_WP_ACTION_PVT.UpdateParamProps(x_return_status ,x_msg_count ,x_msg_data, P_APPLICATION_ID );
999:

Line 1012: from ieu_wp_action_maps

1008:
1009: user_id := fnd_load_util.owner_id(P_OWNER);
1010:
1011: select last_updated_by into l_last_updated_by
1012: from ieu_wp_action_maps
1013: where wp_action_map_id = P_WP_ACTION_MAP_ID;
1014:
1015: -- dolee added on 2-03-03
1016: -- a. when upload seed data, don't change customerized sequence number

Line 1021: update ieu_wp_action_maps

1017: -- b. if there are new seed data, give max+1 sequence number.
1018:
1019: --a.
1020: if (l_last_updated_by = user_id) then
1021: update ieu_wp_action_maps
1022: set
1023: LAST_UPDATED_BY = user_id,
1024: LAST_UPDATE_DATE = decode(P_LAST_UPDATE_DATE, null,SYSDATE,to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD')),
1025: LAST_UPDATE_LOGIN = 0,

Line 1038: update ieu_wp_action_maps

1034: NOT_VALID_FLAG = P_NOT_VALID_FLAG,
1035: DEV_DATA_FLAG = P_DEV_DATA_FLAG
1036: where wp_action_map_id = P_WP_ACTION_MAP_ID;
1037: else
1038: update ieu_wp_action_maps
1039: set
1040: LAST_UPDATED_BY = user_id,
1041: LAST_UPDATE_DATE = decode(P_LAST_UPDATE_DATE, null,SYSDATE,to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD')),
1042: LAST_UPDATE_LOGIN = 0,

Line 1066: from ieu_wp_action_maps

1062: begin
1063:
1064: -- b.
1065: select max(action_map_sequence) into l_temp_map_sequence
1066: from ieu_wp_action_maps
1067: where application_id = P_APPLICATION_ID
1068: and action_map_type_code = P_ACTION_MAP_TYPE_CODE
1069: and action_map_code = P_ACTION_MAP_CODE;
1070:

Line 1077: insert into ieu_wp_action_maps

1073: else
1074: l_temp_map_sequence := l_temp_map_sequence + 1;
1075: end if;
1076:
1077: insert into ieu_wp_action_maps
1078: ( wp_action_map_id ,
1079: CREATED_BY,
1080: CREATION_DATE,
1081: LAST_UPDATED_BY,