eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEU_WORK_ACTION_PVT dependencies on IEU_WP_NODE_SECTION_MAPS

Line 26: l_section_id IEU_WP_NODE_SECTION_MAPS.SECTION_ID%type;

22: l_enum_uuid IEU_UWQ_SEL_ENUMERATORS.ENUM_TYPE_UUID%type;
23: l_temp_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;
24: l_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;
25: l_panel_sec_cat_code IEU_WP_ACTION_MAPS.PANEL_SEC_CAT_CODE%type;
26: l_section_id IEU_WP_NODE_SECTION_MAPS.SECTION_ID%type;
27: l_section_map_sequence IEU_WP_NODE_SECTION_MAPS.SECTION_MAP_SEQUENCE%type;
28: l_action_map_type_code IEU_WP_ACTION_MAPS.ACTION_MAP_TYPE_CODE%type;
29: l_count NUMBER(5);
30: l_duplicate NUMBER(5);

Line 27: l_section_map_sequence IEU_WP_NODE_SECTION_MAPS.SECTION_MAP_SEQUENCE%type;

23: l_temp_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;
24: l_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;
25: l_panel_sec_cat_code IEU_WP_ACTION_MAPS.PANEL_SEC_CAT_CODE%type;
26: l_section_id IEU_WP_NODE_SECTION_MAPS.SECTION_ID%type;
27: l_section_map_sequence IEU_WP_NODE_SECTION_MAPS.SECTION_MAP_SEQUENCE%type;
28: l_action_map_type_code IEU_WP_ACTION_MAPS.ACTION_MAP_TYPE_CODE%type;
29: l_count NUMBER(5);
30: l_duplicate NUMBER(5);
31: l_wp_node_section_map_id IEU_WP_NODE_SECTION_MAPS.WP_NODE_SECTION_MAP_ID%type;

Line 31: l_wp_node_section_map_id IEU_WP_NODE_SECTION_MAPS.WP_NODE_SECTION_MAP_ID%type;

27: l_section_map_sequence IEU_WP_NODE_SECTION_MAPS.SECTION_MAP_SEQUENCE%type;
28: l_action_map_type_code IEU_WP_ACTION_MAPS.ACTION_MAP_TYPE_CODE%type;
29: l_count NUMBER(5);
30: l_duplicate NUMBER(5);
31: l_wp_node_section_map_id IEU_WP_NODE_SECTION_MAPS.WP_NODE_SECTION_MAP_ID%type;
32: name_fail_exception EXCEPTION;
33:
34: BEGIN
35:

Line 129: from IEU_WP_NODE_SECTION_MAPS

125:
126: if (upper(p_maction_def_type_flag) <> 'G' ) then
127:
128: select count(*) into l_count
129: from IEU_WP_NODE_SECTION_MAPS
130: where ENUM_TYPE_UUID = l_enum_uuid
131: and APPLICATION_ID = p_mapping_application
132: AND SECTION_ID = l_section_id;
133:

Line 136: update IEU_WP_NODE_SECTION_MAPS set

132: AND SECTION_ID = l_section_id;
133:
134: if (l_count > 0) then
135:
136: update IEU_WP_NODE_SECTION_MAPS set
137: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
138: LAST_UPDATE_DATE = SYSDATE,
139: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
140: RESPONSIBILITY_ID = null,

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 151: insert INTO IEU_WP_NODE_SECTION_MAPS

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,
154: CREATED_BY,
155: CREATION_DATE,

Line 437: l_wp_node_section_map_id IEU_WP_NODE_SECTION_MAPS.WP_NODE_SECTION_MAP_ID%type;

433: l_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%TYPE;
434: l_enum_uuid IEU_UWQ_SEL_ENUMERATORS.ENUM_TYPE_UUID%type;
435: l_temp_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;
436: l_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;
437: l_wp_node_section_map_id IEU_WP_NODE_SECTION_MAPS.WP_NODE_SECTION_MAP_ID%type;
438: act_map_obj SYSTEM.IEU_wp_action_maps_OBJ;
439: act_map_obj1 SYSTEM.IEU_wp_action_maps_OBJ;
440: l_count NUMBER(5);
441: l_section_id IEU_WP_NODE_SECTION_MAPS.SECTION_ID%type;

Line 441: l_section_id IEU_WP_NODE_SECTION_MAPS.SECTION_ID%type;

437: l_wp_node_section_map_id IEU_WP_NODE_SECTION_MAPS.WP_NODE_SECTION_MAP_ID%type;
438: act_map_obj SYSTEM.IEU_wp_action_maps_OBJ;
439: act_map_obj1 SYSTEM.IEU_wp_action_maps_OBJ;
440: l_count NUMBER(5);
441: l_section_id IEU_WP_NODE_SECTION_MAPS.SECTION_ID%type;
442: l_section_map_sequence IEU_WP_NODE_SECTION_MAPS.SECTION_MAP_SEQUENCE%type;
443: l_panel_sec_cat_code IEU_WP_ACTION_MAPS.PANEL_SEC_CAT_CODE%type;
444: l_action_map_type_code IEU_WP_ACTION_MAPS.ACTION_MAP_TYPE_CODE%type;
445: BEGIN

Line 442: l_section_map_sequence IEU_WP_NODE_SECTION_MAPS.SECTION_MAP_SEQUENCE%type;

438: act_map_obj SYSTEM.IEU_wp_action_maps_OBJ;
439: act_map_obj1 SYSTEM.IEU_wp_action_maps_OBJ;
440: l_count NUMBER(5);
441: l_section_id IEU_WP_NODE_SECTION_MAPS.SECTION_ID%type;
442: l_section_map_sequence IEU_WP_NODE_SECTION_MAPS.SECTION_MAP_SEQUENCE%type;
443: l_panel_sec_cat_code IEU_WP_ACTION_MAPS.PANEL_SEC_CAT_CODE%type;
444: l_action_map_type_code IEU_WP_ACTION_MAPS.ACTION_MAP_TYPE_CODE%type;
445: BEGIN
446: fnd_msg_pub.delete_msg();

Line 953: -- delete related records in IEU_WP_NODE_SECTION_MAPS.

949: action_map_code IN
950: (SELECT enum_type_uuid FROM ieu_uwq_sel_enumerators
951: WHERE sel_enum_id = x_node_id);
952: -- algupta modified on 8/31/04, if no action/information,
953: -- delete related records in IEU_WP_NODE_SECTION_MAPS.
954: if (l_def_type_flag = 'W' or l_def_type_flag = 'I') then
955: if (l_def_type_flag = 'W') then
956: l_section_id := 10002;
957: else

Line 977: delete from IEU_WP_NODE_SECTION_MAPS

973: from ieu_uwq_maction_defs_b
974: where maction_def_type_flag = l_def_type_flag
975: ));
976: if (l_count_map = 0) then
977: delete from IEU_WP_NODE_SECTION_MAPS
978: where ENUM_TYPE_UUID IN
979: (SELECT enum_type_uuid FROM ieu_uwq_sel_enumerators
980: WHERE sel_enum_id = x_node_id)
981: and SECTION_ID = l_section_id;