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_WP_ACTION_PVT dependencies on IEU_UWQ_SEL_ENUMERATORS

Line 363: r_sel_enum_id IN IEU_UWQ_SEL_ENUMERATORS.sel_enum_id%type,

359: x_msg_data OUT NOCOPY VARCHAR2,
360: r_action_param_set_id IN IEU_WP_ACTION_MAPS.action_param_set_id%type,
361: r_MACTION_DEF_TYPE_FLAG IN IEU_UWQ_MACTION_DEFS_B.MACTION_DEF_TYPE_FLAG %type,
362: r_application_id IN IEU_WP_ACTION_MAPS.application_id%type,
363: r_sel_enum_id IN IEU_UWQ_SEL_ENUMERATORS.sel_enum_id%type,
364: r_action_map_sequence IN IEU_WP_ACTION_MAPS.action_map_sequence%type,
365: r_not_valid_flag IN IEU_WP_ACTION_MAPS.not_valid_flag%type
366: ) AS
367:

Line 374: v_sel_enum_id ieu_uwq_sel_enumerators.sel_enum_id%type;

370: v_ver_number ieu_wp_action_maps.object_version_number%type;
371: v_MACTION_DEF_TYPE_FLAG ieu_uwq_maction_defs_b.MACTION_DEF_TYPE_FLAG%type;
372: v_action_param_set_id ieu_wp_action_maps.action_param_set_id%type;
373: v_application_id ieu_wp_action_maps.application_id%type;
374: v_sel_enum_id ieu_uwq_sel_enumerators.sel_enum_id%type;
375: CURSOR c_cursor is
376: select m.WP_ACTION_MAP_ID, m.object_version_number
377: from ieu_wp_action_maps m, ieu_uwq_maction_defs_b db,
378: ieu_wp_act_param_sets_b sb

Line 387: FROM ieu_uwq_sel_enumerators

383: and sb.action_param_set_id= m.action_param_set_id
384: and m.action_param_set_id = v_action_param_set_id
385: --and m.APPLICATION_ID = v_application_id
386: and m.ACTION_MAP_CODE = (select ENUM_TYPE_UUID
387: FROM ieu_uwq_sel_enumerators
388: where sel_enum_id = v_sel_enum_id);
389: c_rec c_cursor%ROWTYPE;
390: CURSOR c_cursor2 is
391: select m.WP_ACTION_MAP_ID, m.object_version_number

Line 403: FROM ieu_uwq_sel_enumerators

399: and m.action_param_set_id =v_action_param_set_id
400: --and m.APPLICATION_ID = v_application_id
401: and m.ACTION_MAP_CODE = to_char(ds.NODE_DS_ID)
402: and ds.ENUM_TYPE_UUID = (select ENUM_TYPE_UUID
403: FROM ieu_uwq_sel_enumerators
404: where sel_enum_id = v_sel_enum_id);
405: c_rec2 c_cursor2%ROWTYPE;
406: BEGIN
407: fnd_msg_pub.delete_msg();

Line 744: v_enumId ieu_uwq_sel_enumerators.sel_enum_id%type;

740: v_CursorID INTEGER;
741: v_Dummy INTEGER;
742: v_param_set_id ieu_wp_param_props_b.action_param_set_id%type;
743: v_language ieu_wp_param_props_tl.language%type;
744: v_enumId ieu_uwq_sel_enumerators.sel_enum_id%type;
745: v_responsibility_id ieu_wp_action_maps.responsibility_id%type;
746: cursor c_cur is
747: SELECT
748: PARAM_ID, PROPERTY_ID,property_value

Line 761: where action_map_code in (select enum_type_uuid from ieu_uwq_sel_enumerators

757: and b.language = v_language
758: and c.maction_def_id = a.wp_action_def_id
759: and a.action_param_set_id in (select action_param_set_id
760: from ieu_wp_action_maps
761: where action_map_code in (select enum_type_uuid from ieu_uwq_sel_enumerators
762: where sel_enum_id =v_enumId
763: )
764: )
765: );

Line 781: and action_map_code in (select enum_type_uuid from ieu_uwq_Sel_enumerators

777: and b.action_param_set_id = v_param_set_id
778: and c.maction_def_key = LTRIM(RTRIM(v_wp_action_key))
779: and b.language = v_language
780: and c.maction_def_id = a.wp_action_def_id)
781: and action_map_code in (select enum_type_uuid from ieu_uwq_Sel_enumerators
782: where sel_enum_id =v_enumId);
783:
784:
785: c_rec c_cur%ROWTYPE;

Line 1295: v_enumId ieu_uwq_Sel_enumerators.sel_enum_id%type;

1291: r_applId IN NUMBER,
1292: r_panel IN VARCHAR2)
1293: As
1294:
1295: v_enumId ieu_uwq_Sel_enumerators.sel_enum_id%type;
1296: v_applId ieu_wp_action_maps.application_id%type;
1297: v_panel ieu_uwq_maction_defs_b.maction_def_type_flag%type;
1298:
1299: cursor c_cur is

Line 1302: from ieu_uwq_Sel_enumerators a, ieu_wp_action_maps b,

1298:
1299: cursor c_cur is
1300: select d.action_param_set_label, b.action_map_sequence,
1301: d.action_param_set_desc , e.action_user_label, b.not_valid_flag,c.action_param_set_id
1302: from ieu_uwq_Sel_enumerators a, ieu_wp_action_maps b,
1303: ieu_wp_act_param_sets_b c, ieu_wp_act_param_sets_tl d,
1304: ieu_uwq_maction_defs_tl e , ieu_uwq_maction_defs_b f
1305: where a.sel_enum_id =v_enumId
1306: and f.maction_def_type_flag = v_panel

Line 1325: from ieu_uwq_Sel_enumerators a, ieu_wp_action_maps b,

1321:
1322: cursor c_cur2 is
1323: select d.action_param_set_label, b.action_map_sequence,
1324: d.action_param_set_desc , e.action_user_label, b.not_valid_flag,c.action_param_set_id
1325: from ieu_uwq_Sel_enumerators a, ieu_wp_action_maps b,
1326: ieu_wp_act_param_sets_b c, ieu_wp_act_param_sets_tl d,
1327: ieu_uwq_maction_defs_tl e , ieu_uwq_maction_defs_b f, ieu_uwq_node_ds ds
1328: where a.sel_enum_id =v_enumId
1329: and f.maction_def_type_flag = v_panel

Line 1376: ' from ieu_uwq_sel_enumerators '||

1372: /*********************************************************************************/
1373: ' and action_map_code in (select to_char(node_ds_id) ' ||
1374: ' from ieu_uwq_node_ds ' ||
1375: ' where enum_type_uuid in (select enum_type_uuid '||
1376: ' from ieu_uwq_sel_enumerators '||
1377: ' where sel_enum_id = :5 '||
1378: ' ) '||
1379: ' ) '
1380: --USING l_count, r_applId,'NODE_DS', c_rec2.action_param_set_id, r_enumId ;

Line 1395: ' from ieu_uwq_sel_enumerators '||

1391: /*********************************************************************************/
1392: ' and action_map_code in (select to_char(node_ds_id) '||
1393: ' from ieu_uwq_node_ds '||
1394: ' where enum_type_uuid in (select enum_type_uuid '||
1395: ' from ieu_uwq_sel_enumerators '||
1396: ' where sel_enum_id = :6'||
1397: ' ) '||
1398: ' )'
1399: --USING l_count, r_applId, c_rec2.action_map_sequence,'NODE_DS', c_rec2.action_param_set_id,

Line 1426: ' from ieu_uwq_sel_enumerators '||

1422: /*******************ADD FOR FORWARD PORT BUG5585922 BY MAJHA**********************/
1423: --' and action_param_set_id = :3 '||
1424: /*********************************************************************************/
1425: ' and action_map_code in (select enum_type_uuid '||
1426: ' from ieu_uwq_sel_enumerators '||
1427: ' where sel_enum_id = :3) '
1428: --USING l_count,r_applId, c_rec.action_param_set_id, r_enumId ;
1429: USING l_count, c_rec.action_param_set_id, r_enumId ;
1430: ELSE

Line 1440: ' from ieu_uwq_sel_enumerators '||

1436: /*******************ADD FOR FORWARD PORT BUG5585922 BY MAJHA**********************/
1437: -- ' and action_param_set_id = :4 '||
1438: /*********************************************************************************/
1439: ' and action_map_code in (select enum_type_uuid '||
1440: ' from ieu_uwq_sel_enumerators '||
1441: ' where sel_enum_id = :4) '
1442: --USING l_count , r_applId, c_rec.action_map_sequence, c_rec.action_param_set_id, r_enumId;
1443: USING l_count , c_rec.action_map_sequence, c_rec.action_param_set_id, r_enumId;
1444: END IF ;

Line 1501: v_enumId ieu_uwq_sel_enumerators.sel_enum_id%type;

1497: v_CursorID INTEGER;
1498: v_Dummy INTEGER;
1499: v_param_set_id ieu_wp_act_param_sets_tl.action_param_set_id%type;
1500: v_language ieu_wp_act_param_sets_tl.language%type;
1501: v_enumId ieu_uwq_sel_enumerators.sel_enum_id%type;
1502: l_security_group_id NUMBER(15);
1503:
1504: cursor c_cur is
1505: SELECT

Line 1519: where action_map_code in (SELECT to_char(ds.NODE_DS_ID) FROM ieu_uwq_sel_enumerators e,

1515: and b.language = v_language
1516: and c.maction_def_id = a.wp_action_def_id
1517: and a.action_param_set_id in (select action_param_set_id
1518: from ieu_wp_action_maps
1519: where action_map_code in (SELECT to_char(ds.NODE_DS_ID) FROM ieu_uwq_sel_enumerators e,
1520: ieu_uwq_node_ds ds
1521: WHERE e.sel_enum_id = v_enumId
1522: and e.ENUM_TYPE_UUID = ds.ENUM_TYPE_UUID)
1523: )

Line 1543: and action_map_code in (SELECT to_char(ds.NODE_DS_ID) FROM ieu_uwq_sel_enumerators e, ieu_uwq_node_ds ds

1539: and b.action_param_set_id = v_param_set_id
1540: and c.maction_def_key = LTRIM(RTRIM(v_wp_action_key))
1541: and b.language = v_language
1542: and c.maction_def_id = a.wp_action_def_id)
1543: and action_map_code in (SELECT to_char(ds.NODE_DS_ID) FROM ieu_uwq_sel_enumerators e, ieu_uwq_node_ds ds
1544: WHERE e.sel_enum_id = v_enumId
1545: and e.ENUM_TYPE_UUID = ds.ENUM_TYPE_UUID);
1546: c_rec c_cur%ROWTYPE;
1547: c_rec2 c_cur2%ROWTYPE;