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_WORKPANEL_PVT dependencies on IEU_WP_NODE_SECTION_MAPS

Line 638: l_wp_node_section_map_id IEU_WP_NODE_SECTION_MAPS.WP_NODE_SECTION_MAP_ID%type;

634: l_temp_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;
635:
636: l_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;
637:
638: l_wp_node_section_map_id IEU_WP_NODE_SECTION_MAPS.WP_NODE_SECTION_MAP_ID%type;
639:
640: act_map_obj SYSTEM.IEU_wp_action_maps_OBJ;
641:
642: act_map_obj1 SYSTEM.IEU_wp_action_maps_OBJ;

Line 646: l_section_id IEU_WP_NODE_SECTION_MAPS.SECTION_ID%type;

642: act_map_obj1 SYSTEM.IEU_wp_action_maps_OBJ;
643:
644: l_count NUMBER(5);
645:
646: l_section_id IEU_WP_NODE_SECTION_MAPS.SECTION_ID%type;
647:
648: l_section_map_sequence IEU_WP_NODE_SECTION_MAPS.SECTION_MAP_SEQUENCE%type;
649:
650: l_panel_sec_cat_code IEU_WP_ACTION_MAPS.PANEL_SEC_CAT_CODE%type;

Line 648: l_section_map_sequence IEU_WP_NODE_SECTION_MAPS.SECTION_MAP_SEQUENCE%type;

644: l_count NUMBER(5);
645:
646: l_section_id IEU_WP_NODE_SECTION_MAPS.SECTION_ID%type;
647:
648: l_section_map_sequence IEU_WP_NODE_SECTION_MAPS.SECTION_MAP_SEQUENCE%type;
649:
650: l_panel_sec_cat_code IEU_WP_ACTION_MAPS.PANEL_SEC_CAT_CODE%type;
651:
652: l_action_map_type_code IEU_WP_ACTION_MAPS.ACTION_MAP_TYPE_CODE%type;

Line 897: from IEU_WP_NODE_SECTION_MAPS

893:
894: if (p_maction_def_type_flag <> 'G') then
895:
896: select count(*) into l_count
897: from IEU_WP_NODE_SECTION_MAPS
898: where ENUM_TYPE_UUID = l_enum_uuid
899: and APPLICATION_ID = rec_obj.application_id
900: AND SECTION_ID = l_section_id;
901:

Line 904: update IEU_WP_NODE_SECTION_MAPS set

900: AND SECTION_ID = l_section_id;
901:
902: if (l_count > 0) then
903:
904: update IEU_WP_NODE_SECTION_MAPS set
905: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
906: LAST_UPDATE_DATE = SYSDATE,
907: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
908: RESPONSIBILITY_ID = null,

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

913:
914:
915: else
916:
917: select IEU_WP_NODE_SECTION_MAPS_S1.nextval into l_wp_node_section_map_id from sys.dual;
918:
919: insert INTO IEU_WP_NODE_SECTION_MAPS
920: (WP_NODE_SECTION_MAP_ID,
921: OBJECT_VERSION_NUMBER,

Line 919: insert INTO IEU_WP_NODE_SECTION_MAPS

915: else
916:
917: select IEU_WP_NODE_SECTION_MAPS_S1.nextval into l_wp_node_section_map_id from sys.dual;
918:
919: insert INTO IEU_WP_NODE_SECTION_MAPS
920: (WP_NODE_SECTION_MAP_ID,
921: OBJECT_VERSION_NUMBER,
922: CREATED_BY,
923: CREATION_DATE,

Line 1247: -- delete related records in IEU_WP_NODE_SECTION_MAPS

1243: (SELECT enum_type_uuid FROM ieu_uwq_sel_enumerators
1244: WHERE sel_enum_id = x_node_id);
1245:
1246: -- dolee modified on 8/27/04, if no action/information,
1247: -- delete related records in IEU_WP_NODE_SECTION_MAPS
1248: if (l_def_type_flag = 'W' or l_def_type_flag = 'I') then
1249: if (l_def_type_flag = 'W') then
1250: l_section_id := 10002;
1251: else l_section_id := 10001;

Line 1271: delete from IEU_WP_NODE_SECTION_MAPS

1267: where maction_def_type_flag = l_def_type_flag
1268: )
1269: );
1270: if (l_count_map = 0) then
1271: delete from IEU_WP_NODE_SECTION_MAPS
1272: where ENUM_TYPE_UUID IN
1273: (SELECT enum_type_uuid FROM ieu_uwq_sel_enumerators
1274: WHERE sel_enum_id = x_node_id)
1275: and SECTION_ID = l_section_id;

Line 2724: l_section_id IEU_WP_NODE_SECTION_MAPS.SECTION_ID%type;

2720:
2721: l_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;
2722:
2723: l_panel_sec_cat_code IEU_WP_ACTION_MAPS.PANEL_SEC_CAT_CODE%type;
2724: l_section_id IEU_WP_NODE_SECTION_MAPS.SECTION_ID%type;
2725: l_section_map_sequence IEU_WP_NODE_SECTION_MAPS.SECTION_MAP_SEQUENCE%type;
2726: --l_panel_sec_cat_code IEU_WP_ACTION_MAPS.PANEL_SEC_CAT_CODE%type;
2727: l_action_map_type_code IEU_WP_ACTION_MAPS.ACTION_MAP_TYPE_CODE%type;
2728: l_count NUMBER(2);

Line 2725: l_section_map_sequence IEU_WP_NODE_SECTION_MAPS.SECTION_MAP_SEQUENCE%type;

2721: l_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;
2722:
2723: l_panel_sec_cat_code IEU_WP_ACTION_MAPS.PANEL_SEC_CAT_CODE%type;
2724: l_section_id IEU_WP_NODE_SECTION_MAPS.SECTION_ID%type;
2725: l_section_map_sequence IEU_WP_NODE_SECTION_MAPS.SECTION_MAP_SEQUENCE%type;
2726: --l_panel_sec_cat_code IEU_WP_ACTION_MAPS.PANEL_SEC_CAT_CODE%type;
2727: l_action_map_type_code IEU_WP_ACTION_MAPS.ACTION_MAP_TYPE_CODE%type;
2728: l_count NUMBER(2);
2729: l_wp_node_section_map_id IEU_WP_NODE_SECTION_MAPS.WP_NODE_SECTION_MAP_ID%type;

Line 2729: l_wp_node_section_map_id IEU_WP_NODE_SECTION_MAPS.WP_NODE_SECTION_MAP_ID%type;

2725: l_section_map_sequence IEU_WP_NODE_SECTION_MAPS.SECTION_MAP_SEQUENCE%type;
2726: --l_panel_sec_cat_code IEU_WP_ACTION_MAPS.PANEL_SEC_CAT_CODE%type;
2727: l_action_map_type_code IEU_WP_ACTION_MAPS.ACTION_MAP_TYPE_CODE%type;
2728: l_count NUMBER(2);
2729: l_wp_node_section_map_id IEU_WP_NODE_SECTION_MAPS.WP_NODE_SECTION_MAP_ID%type;
2730:
2731:
2732:
2733: BEGIN

Line 2826: from IEU_WP_NODE_SECTION_MAPS

2822:
2823:
2824: if (p_maction_def_type_flag <> 'G') then
2825: select count(*) into l_count
2826: from IEU_WP_NODE_SECTION_MAPS
2827: where ENUM_TYPE_UUID = l_enum_uuid
2828: and APPLICATION_ID = p_application
2829: AND SECTION_ID = l_section_id;
2830:

Line 2832: update IEU_WP_NODE_SECTION_MAPS set

2828: and APPLICATION_ID = p_application
2829: AND SECTION_ID = l_section_id;
2830:
2831: if (l_count > 0) then
2832: update IEU_WP_NODE_SECTION_MAPS set
2833: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2834: LAST_UPDATE_DATE = SYSDATE,
2835: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
2836: RESPONSIBILITY_ID = null,

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

2838: where ENUM_TYPE_UUID = l_enum_uuid
2839: and APPLICATION_ID = p_application
2840: and SECTION_ID = l_section_id;
2841: else
2842: select IEU_WP_NODE_SECTION_MAPS_S1.nextval into l_wp_node_section_map_id from sys.dual;
2843: insert INTO IEU_WP_NODE_SECTION_MAPS
2844: (WP_NODE_SECTION_MAP_ID,
2845: OBJECT_VERSION_NUMBER,
2846: CREATED_BY,

Line 2843: insert INTO IEU_WP_NODE_SECTION_MAPS

2839: and APPLICATION_ID = p_application
2840: and SECTION_ID = l_section_id;
2841: else
2842: select IEU_WP_NODE_SECTION_MAPS_S1.nextval into l_wp_node_section_map_id from sys.dual;
2843: insert INTO IEU_WP_NODE_SECTION_MAPS
2844: (WP_NODE_SECTION_MAP_ID,
2845: OBJECT_VERSION_NUMBER,
2846: CREATED_BY,
2847: CREATION_DATE,