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_UWQ_SEL_ENUMERATORS

Line 93: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl

89: if (p_maction_def_type_flag <> 'F' and p_maction_def_type_flag <> 'N' and p_maction_def_type_flag <> 'M' ) then
90:
91: select count(b.maction_def_id) into l_act_usr_lbl_count
92: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
93: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl
94: where e. sel_enum_id = rec_obj.enum_id
95: -- and e.application_id = m.application_id
96: and e.enum_type_uuid = m.action_map_code
97: and b.maction_def_id = tl.maction_def_id

Line 119: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl

115:
116:
117: select count(b.maction_def_id) into l_set_id_count
118: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
119: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl
120: where e. sel_enum_id = rec_obj.enum_id
121: --and e.application_id = m.application_id
122: and e.enum_type_uuid = m.action_map_code
123: and b.maction_def_id = tl.maction_def_id

Line 139: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e,

135: elsif (p_maction_def_type_flag = 'F') then
136:
137: select count(b.maction_def_id) into l_act_usr_lbl_count
138: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
139: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e,
140: ieu_wp_act_param_sets_tl stl, ieu_uwq_node_ds ds
141: where e. sel_enum_id = rec_obj.enum_id
142: --and e.application_id = m.application_id
143: and e.enum_type_uuid = ds.ENUM_TYPE_UUID

Line 160: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e,

156:
157:
158: select count(b.maction_def_id) into l_set_id_count
159: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
160: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e,
161: ieu_wp_act_param_sets_tl stl, ieu_uwq_node_ds ds
162: where e. sel_enum_id = rec_obj.enum_id
163: --and e.application_id = m.application_id
164: and e.enum_type_uuid = ds.ENUM_TYPE_UUID

Line 378: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl

374: if(p_maction_def_type_flag <> 'F') then
375:
376: select count(b.maction_def_id) into l_act_usr_lbl_count
377: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
378: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl
379: where e. sel_enum_id = p_enum_id
380: -- and e.application_id = m.application_id
381: and e.enum_type_uuid = m.action_map_code
382: and b.maction_def_id = tl.maction_def_id

Line 397: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl

393: --DBMS_OUTPUT.PUT_LINE(' maction lable count : '||l_act_usr_lbl_count);
394:
395: select count(b.maction_def_id) into l_set_id_count
396: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
397: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl
398: where e. sel_enum_id = p_enum_id
399: --and e.application_id = m.application_id
400: and e.enum_type_uuid = m.action_map_code
401: and b.maction_def_id = tl.maction_def_id

Line 416: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl,

412: elsif (p_maction_def_type_flag = 'F') then
413:
414: select count(b.maction_def_id) into l_act_usr_lbl_count
415: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
416: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl,
417: IEU_UWQ_NODE_DS ds
418: where e. sel_enum_id = p_enum_id
419: --and e.application_id = m.application_id
420: and e.enum_type_uuid = ds.ENUM_TYPE_UUID

Line 438: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl, IEU_UWQ_NODE_DS ds

434:
435:
436: select count(b.maction_def_id) into l_set_id_count
437: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
438: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl, IEU_UWQ_NODE_DS ds
439: where e. sel_enum_id = p_enum_id
440: --and e.application_id = m.application_id
441: and e.enum_type_uuid = ds.ENUM_TYPE_UUID
442: and b.maction_def_id = tl.maction_def_id

Line 631: l_enum_uuid IEU_UWQ_SEL_ENUMERATORS.ENUM_TYPE_UUID%type;

627: l_maction_def_id IEU_UWQ_MACTION_DEFS_B.MACTION_DEF_ID%TYPE;
628:
629: l_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%TYPE;
630:
631: l_enum_uuid IEU_UWQ_SEL_ENUMERATORS.ENUM_TYPE_UUID%type;
632:
633:
634: l_temp_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;
635:

Line 797: from ieu_uwq_sel_enumerators

793: -- DBMS_OUTPUT.PUT_LINE('inserted in param sets tl: ');
794:
795:
796: select enum_type_uuid into l_enum_uuid
797: from ieu_uwq_sel_enumerators
798: where sel_enum_id = rec_obj.enum_id;
799:
800: if (p_maction_def_type_flag <> 'F') then
801:

Line 886: update IEU_UWQ_SEL_ENUMERATORS set

882:
883: if (p_maction_def_type_flag <> 'F') then
884:
885:
886: update IEU_UWQ_SEL_ENUMERATORS set
887: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
888: LAST_UPDATE_DATE = SYSDATE,
889: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
890: WORK_PANEL_REGISTERED_FLAG = 'Y'

Line 1243: (SELECT enum_type_uuid FROM ieu_uwq_sel_enumerators

1239: DELETE FROM ieu_wp_action_maps
1240: WHERE action_param_set_id = x_param_set_id AND
1241: action_map_type_code = 'NODE' AND
1242: action_map_code IN
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

Line 1259: (SELECT enum_type_uuid FROM ieu_uwq_sel_enumerators

1255: select count(distinct action_param_set_id) into l_count_map
1256: from ieu_wp_action_maps
1257: where action_map_type_code = 'NODE'
1258: AND action_map_code IN
1259: (SELECT enum_type_uuid FROM ieu_uwq_sel_enumerators
1260: WHERE sel_enum_id = x_node_id)
1261: and action_param_set_id in
1262: (SELECT action_param_set_id
1263: FROM ieu_wp_act_param_sets_b

Line 1273: (SELECT enum_type_uuid FROM ieu_uwq_sel_enumerators

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;
1276: end if;
1277: end if;

Line 1284: (SELECT to_char(ds.NODE_DS_ID) FROM ieu_uwq_sel_enumerators e, ieu_uwq_node_ds ds

1280: DELETE FROM ieu_wp_action_maps
1281: WHERE action_param_set_id = x_param_set_id AND
1282: action_map_type_code = 'NODE_DS' AND
1283: action_map_code IN
1284: (SELECT to_char(ds.NODE_DS_ID) FROM ieu_uwq_sel_enumerators e, ieu_uwq_node_ds ds
1285: WHERE e.sel_enum_id = x_node_id
1286: and e.ENUM_TYPE_UUID = ds.ENUM_TYPE_UUID);
1287:
1288: end if;

Line 1353: ieu_uwq_sel_enumerators where SEL_ENUM_ID = x_node_id)

1349: if (l_def_type_flag <> 'F') then
1350: select count(m.WP_ACTION_MAP_ID) into l_count_map
1351: from IEU_WP_ACTION_MAPS m
1352: where m.ACTION_MAP_CODE = (select ENUM_TYPE_UUID from
1353: ieu_uwq_sel_enumerators where SEL_ENUM_ID = x_node_id)
1354: and m.ACTION_MAP_TYPE_CODE = 'NODE';
1355:
1356: if (l_count_map = 0) then
1357:

Line 1358: update IEU_UWQ_SEL_ENUMERATORS set

1354: and m.ACTION_MAP_TYPE_CODE = 'NODE';
1355:
1356: if (l_count_map = 0) then
1357:
1358: update IEU_UWQ_SEL_ENUMERATORS set
1359: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1360: LAST_UPDATE_DATE = SYSDATE,
1361: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1362: WORK_PANEL_REGISTERED_FLAG = null

Line 2568: l_enum_uuid IEU_UWQ_SEL_ENUMERATORS.ENUM_TYPE_UUID%type;

2564:
2565: l_return_status VARCHAR2(4);
2566:
2567:
2568: l_enum_uuid IEU_UWQ_SEL_ENUMERATORS.ENUM_TYPE_UUID%type;
2569:
2570:
2571:
2572: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;

Line 2633: l_enum_uuid IEU_UWQ_SEL_ENUMERATORS.ENUM_TYPE_UUID%type;

2629:
2630: l_return_status VARCHAR2(4);
2631:
2632:
2633: l_enum_uuid IEU_UWQ_SEL_ENUMERATORS.ENUM_TYPE_UUID%type;
2634:
2635:
2636:
2637: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;

Line 2717: l_enum_uuid IEU_UWQ_SEL_ENUMERATORS.ENUM_TYPE_UUID%type;

2713: act_map_obj SYSTEM.IEU_wp_action_maps_OBJ;
2714:
2715: act_map_obj1 SYSTEM.IEU_wp_action_maps_OBJ;
2716:
2717: l_enum_uuid IEU_UWQ_SEL_ENUMERATORS.ENUM_TYPE_UUID%type;
2718:
2719: l_temp_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;
2720:
2721: l_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;

Line 2745: from ieu_uwq_sel_enumerators

2741:
2742:
2743:
2744: select enum_type_uuid into l_enum_uuid
2745: from ieu_uwq_sel_enumerators
2746: where sel_enum_id = p_enum_id;
2747:
2748: select max(m.action_map_sequence) into l_temp_map_sequence
2749: from ieu_wp_action_maps m, ieu_uwq_maction_defs_b db,

Line 2816: update IEU_UWQ_SEL_ENUMERATORS set

2812:
2813: /* dolee add on 8/26/04 mapped action should set registered flag to 'y' */
2814: if (p_maction_def_type_flag <> 'F') then
2815:
2816: update IEU_UWQ_SEL_ENUMERATORS set
2817: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2818: LAST_UPDATE_DATE = SYSDATE,
2819: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
2820: WORK_PANEL_REGISTERED_FLAG = 'Y'