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_ACTION_MAPS

Line 20: act_map_obj SYSTEM.IEU_wp_action_maps_OBJ;

16: l_source_lang VARCHAR2(4);
17: l_return_status VARCHAR2(4);
18: l_msg_count NUMBER(2);
19: l_msg_data VARCHAR2(2000);
20: act_map_obj SYSTEM.IEU_wp_action_maps_OBJ;
21: act_map_obj1 SYSTEM.IEU_wp_action_maps_OBJ;
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;

Line 21: act_map_obj1 SYSTEM.IEU_wp_action_maps_OBJ;

17: l_return_status VARCHAR2(4);
18: l_msg_count NUMBER(2);
19: l_msg_data VARCHAR2(2000);
20: act_map_obj SYSTEM.IEU_wp_action_maps_OBJ;
21: act_map_obj1 SYSTEM.IEU_wp_action_maps_OBJ;
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;

Line 23: l_temp_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;

19: l_msg_data VARCHAR2(2000);
20: act_map_obj SYSTEM.IEU_wp_action_maps_OBJ;
21: act_map_obj1 SYSTEM.IEU_wp_action_maps_OBJ;
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;

Line 24: l_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;

20: act_map_obj SYSTEM.IEU_wp_action_maps_OBJ;
21: act_map_obj1 SYSTEM.IEU_wp_action_maps_OBJ;
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;

Line 25: l_panel_sec_cat_code IEU_WP_ACTION_MAPS.PANEL_SEC_CAT_CODE%type;

21: act_map_obj1 SYSTEM.IEU_wp_action_maps_OBJ;
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);

Line 28: l_action_map_type_code IEU_WP_ACTION_MAPS.ACTION_MAP_TYPE_CODE%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;
32: name_fail_exception EXCEPTION;

Line 51: FROM ieu_wp_action_maps

47: where sel_enum_id = p_enum_id;
48:
49: -- check if this node already have a action with same label
50: SELECT count(*) INTO l_duplicate
51: FROM ieu_wp_action_maps
52: where action_param_set_id = p_param_set_id
53: /*******************ADD FOR FORWARD PORT BUG5585922 BY MAJHA**********************/
54:
55: --and application_id = p_mapping_application

Line 64: from ieu_wp_action_maps m,

60: IF l_duplicate > 0 then
61: RAISE name_fail_exception;
62: else
63: select max(m.action_map_sequence) into l_temp_map_sequence
64: from ieu_wp_action_maps m,
65: ieu_uwq_maction_defs_b db,
66: ieu_wp_act_param_sets_b sb
67: -- where m.application_id = p_mapping_application
68: where m.action_map_type_code = 'NODE'

Line 104: act_map_obj := SYSTEM.IEU_wp_action_maps_OBJ(null, p_param_set_id,

100: end if;
101:
102:
103:
104: act_map_obj := SYSTEM.IEU_wp_action_maps_OBJ(null, p_param_set_id,
105: p_mapping_application, null, 'NODE',
106: l_enum_uuid, l_map_sequence, l_panel_sec_cat_code,
107: 'N', 'Y');
108:

Line 112: act_map_obj1 := SYSTEM.IEU_wp_action_maps_OBJ(null, p_param_set_id,

108:
109: CREATE_action_map(x_return_status,x_msg_count, x_msg_data, act_map_obj);
110:
111:
112: act_map_obj1 := SYSTEM.IEU_wp_action_maps_OBJ(null, p_param_set_id,
113: p_mapping_application, -1, 'NODE',
114: l_enum_uuid, l_map_sequence, l_panel_sec_cat_code,
115: 'N', 'Y');
116:

Line 358: rec_obj IN SYSTEM.IEU_WP_ACTION_MAPS_OBJ

354:
355: PROCEDURE CREATE_action_map (x_return_status OUT NOCOPY VARCHAR2,
356: x_msg_count OUT NOCOPY NUMBER,
357: x_msg_data OUT NOCOPY VARCHAR2,
358: rec_obj IN SYSTEM.IEU_WP_ACTION_MAPS_OBJ
359: ) AS
360:
361: l_action_map_id NUMBER(15);
362: BEGIN

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 366: insert INTO IEU_wp_action_mapS

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,
369: CREATED_BY,
370: CREATION_DATE,

Line 435: l_temp_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;

431: l_msg_data VARCHAR2(2000);
432: l_maction_def_id IEU_UWQ_MACTION_DEFS_B.MACTION_DEF_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;

Line 436: l_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;

432: l_maction_def_id IEU_UWQ_MACTION_DEFS_B.MACTION_DEF_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);

Line 438: act_map_obj SYSTEM.IEU_wp_action_maps_OBJ;

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;
442: l_section_map_sequence IEU_WP_NODE_SECTION_MAPS.SECTION_MAP_SEQUENCE%type;

Line 439: act_map_obj1 SYSTEM.IEU_wp_action_maps_OBJ;

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;
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;

Line 443: l_panel_sec_cat_code IEU_WP_ACTION_MAPS.PANEL_SEC_CAT_CODE%type;

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();
447: x_return_status := fnd_api.g_ret_sts_success;

Line 444: l_action_map_type_code IEU_WP_ACTION_MAPS.ACTION_MAP_TYPE_CODE%type;

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();
447: x_return_status := fnd_api.g_ret_sts_success;
448: FND_MSG_PUB.initialize;

Line 599: from ieu_wp_action_maps m, ieu_uwq_maction_defs_b db,

595: end if;
596: if (p_maction_def_type_flag <> 'F') then
597:
598: select max(m.action_map_sequence) into l_temp_map_sequence
599: from ieu_wp_action_maps m, ieu_uwq_maction_defs_b db,
600: ieu_wp_act_param_sets_b sb
601: --where m.application_id = rec_obj.application_id
602: where m.action_map_type_code = 'NODE'
603: --and m.application_id = db.application_id

Line 722: l_temp_map_sequence ieu_wp_action_maps.action_map_sequence%type;

718: l_value_override_flag varchar(5);
719: v_numrows1 NUMBER;
720: l_new_param_set_id NUMBER(15);
721: l_wp_action_map_id NUMBER(15);
722: l_temp_map_sequence ieu_wp_action_maps.action_map_sequence%type;
723:
724:
725: cursor c_cur is
726: SELECT

Line 929: FROM ieu_wp_action_maps

925: if ( l_def_type_flag <> 'F' and l_def_type_flag <> 'N' and l_def_type_flag <> 'M') then
926:
927: SELECT count(unique(action_map_code))
928: INTO l_num_map_entries
929: FROM ieu_wp_action_maps
930: WHERE action_map_type_code = 'NODE' AND action_param_set_id = x_param_set_id;
931:
932: elsif ( l_def_type_flag ='F') then
933:

Line 936: FROM ieu_wp_action_maps

932: elsif ( l_def_type_flag ='F') then
933:
934: SELECT count(unique(action_map_code))
935: INTO l_num_map_entries
936: FROM ieu_wp_action_maps
937: WHERE action_map_type_code = 'NODE_DS' AND action_param_set_id = x_param_set_id;
938:
939:
940: end if;

Line 946: DELETE FROM ieu_wp_action_maps

942: --2.
943: if (x_node_id <> 0) then
944: if ( l_def_type_flag <> 'F') then
945:
946: DELETE FROM ieu_wp_action_maps
947: WHERE action_param_set_id = x_param_set_id AND
948: action_map_type_code = 'NODE' AND
949: action_map_code IN
950: (SELECT enum_type_uuid FROM ieu_uwq_sel_enumerators

Line 963: from ieu_wp_action_maps

959: end if;
960:
961: l_count_map := 0;
962: select count(distinct action_param_set_id) into l_count_map
963: from ieu_wp_action_maps
964: where action_map_type_code = 'NODE'
965: AND action_map_code IN
966: (SELECT enum_type_uuid FROM ieu_uwq_sel_enumerators
967: WHERE sel_enum_id = x_node_id)

Line 987: DELETE FROM ieu_wp_action_maps

983: end if;
984:
985: elsif ( l_def_type_flag ='F') then
986:
987: DELETE FROM ieu_wp_action_maps
988: WHERE action_param_set_id = x_param_set_id AND
989: action_map_type_code = 'NODE_DS' AND
990: action_map_code IN
991: (SELECT ds.NODE_DS_ID FROM ieu_uwq_sel_enumerators e, ieu_uwq_node_ds ds

Line 1060: from IEU_WP_ACTION_MAPS m

1056: COMMIT;
1057:
1058: if (l_def_type_flag <> 'F' and l_def_type_flag <> 'N' and l_def_type_flag <> 'M') then
1059: select count(m.WP_ACTION_MAP_ID) into l_count_map
1060: from IEU_WP_ACTION_MAPS m
1061: where m.ACTION_MAP_CODE = (select ENUM_TYPE_UUID from
1062: ieu_uwq_sel_enumerators where SEL_ENUM_ID = x_node_id)
1063: and m.ACTION_MAP_TYPE_CODE = 'NODE';
1064: