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_ACT_PARAM_SETS_B

Line 10: p_param_set_id IN IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%type,

6: x_msg_count OUT NOCOPY NUMBER,
7: x_msg_data OUT NOCOPY VARCHAR2,
8: p_enum_id IN NUMBER,
9: p_mapping_application IN NUMBER,
10: p_param_set_id IN IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%type,
11: p_maction_def_type_flag IN VARCHAR2,
12: p_act_application IN NUMBER
13: ) as
14:

Line 66: ieu_wp_act_param_sets_b sb

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'
69: and m.action_map_code = l_enum_uuid
70: -- and m.application_id = db.application_id

Line 252: ieu_wp_act_param_sets_b s

248: l_set_id_count :=0;
249: temp_act_user_label := LTRIM(RTRIM(p_label));
250: select count(b.maction_def_id) into l_act_usr_lbl_count
251: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl,
252: ieu_wp_act_param_sets_b s
253: where
254: b.maction_def_id = tl.maction_def_id
255: and b.maction_def_type_flag = (select maction_def_type_flag
256: from ieu_uwq_maction_defs_b

Line 258: from ieu_wp_act_param_sets_b

254: b.maction_def_id = tl.maction_def_id
255: and b.maction_def_type_flag = (select maction_def_type_flag
256: from ieu_uwq_maction_defs_b
257: where maction_def_id = (select wp_action_def_id
258: from ieu_wp_act_param_sets_b
259: where action_param_set_id = p_param_set_id))
260: and s.wp_action_def_id = b.maction_def_id
261: and tl.language = l_language
262: and lower(tl.action_user_label) = lower(temp_act_user_label);

Line 266: ieu_wp_act_param_sets_b s,

262: and lower(tl.action_user_label) = lower(temp_act_user_label);
263:
264: select count(b.maction_def_id) into l_set_id_count
265: from ieu_uwq_maction_defs_b b,
266: ieu_wp_act_param_sets_b s,
267: ieu_wp_act_param_sets_tl stl
268: where
269: b.maction_def_type_flag = (select maction_def_type_flag
270: from ieu_uwq_maction_defs_b

Line 272: from ieu_wp_act_param_sets_b

268: where
269: b.maction_def_type_flag = (select maction_def_type_flag
270: from ieu_uwq_maction_defs_b
271: where maction_def_id = (select wp_action_def_id
272: from ieu_wp_act_param_sets_b
273: where action_param_set_id = p_param_set_id))
274: and s.wp_action_def_id = b.maction_def_id
275:
276: and s.action_param_set_id = stl.action_param_set_id

Line 433: l_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%TYPE;

429: l_return_status VARCHAR2(4);
430: l_msg_count NUMBER(2);
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;

Line 550: select IEU_WP_ACT_PARAM_SETS_B_S1.NEXTVAL into l_action_param_set_id from sys.dual;

546: 0
547: );
548:
549: if (p_maction_def_type_flag <> 'N' and p_maction_def_type_flag <> 'M') then
550: select IEU_WP_ACT_PARAM_SETS_B_S1.NEXTVAL into l_action_param_set_id from sys.dual;
551: insert INTO IEU_WP_ACT_PARAM_SETS_B
552: (ACTION_PARAM_SET_ID,
553: CREATED_BY,
554: CREATION_DATE,

Line 551: insert INTO IEU_WP_ACT_PARAM_SETS_B

547: );
548:
549: if (p_maction_def_type_flag <> 'N' and p_maction_def_type_flag <> 'M') then
550: select IEU_WP_ACT_PARAM_SETS_B_S1.NEXTVAL into l_action_param_set_id from sys.dual;
551: insert INTO IEU_WP_ACT_PARAM_SETS_B
552: (ACTION_PARAM_SET_ID,
553: CREATED_BY,
554: CREATION_DATE,
555: LAST_UPDATED_BY,

Line 600: ieu_wp_act_param_sets_b sb

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
604: and db.maction_def_type_flag = p_maction_def_type_flag

Line 731: from ieu_wp_act_param_sets_b a, ieu_wp_act_param_sets_tl b, ieu_uwq_maction_defs_b c

727: PARAM_ID, PROPERTY_ID,property_value, value_override_flag,not_valid_flag
728: FROM ieu_wp_param_props_b
729: WHERE action_param_set_id in
730: (select a.action_param_set_id
731: from ieu_wp_act_param_sets_b a, ieu_wp_act_param_sets_tl b, ieu_uwq_maction_defs_b c
732: where a.action_param_set_id = b.action_param_set_id(+)
733: and b.action_param_set_id = r_param_set_id
734: and c.maction_def_id = r_maction_def_id
735: and b.language = r_language

Line 752: select IEU_wp_act_param_sets_b_S1.NEXTVAL into l_new_param_set_id from sys.dual;

748: x_msg_count ,
749: x_msg_data ,
750: r_label, r_param_set_id);
751: if x_return_status = 'S' then
752: select IEU_wp_act_param_sets_b_S1.NEXTVAL into l_new_param_set_id from sys.dual;
753:
754: insert into IEU_WP_ACT_PARAM_SETS_B
755: ( ACTION_PARAM_SET_ID,
756: CREATED_BY,

Line 754: insert into IEU_WP_ACT_PARAM_SETS_B

750: r_label, r_param_set_id);
751: if x_return_status = 'S' then
752: select IEU_wp_act_param_sets_b_S1.NEXTVAL into l_new_param_set_id from sys.dual;
753:
754: insert into IEU_WP_ACT_PARAM_SETS_B
755: ( ACTION_PARAM_SET_ID,
756: CREATED_BY,
757: CREATION_DATE,
758: LAST_UPDATED_BY,

Line 891: l_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%type;

887: x_maction_def_flag IN VARCHAR2
888: ) is
889:
890: l_language VARCHAR2(4);
891: l_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%type;
892: l_maction_def_id IEU_UWQ_MACTION_DEFS_B.MACTION_DEF_ID%type;
893: l_num_map_entries NUMBER;
894: l_num_set_entries NUMBER;
895: l_count_map NUMBER;

Line 920: ieu_wp_act_param_sets_b sb

916: l_def_type_flag := x_maction_def_flag;
917: else
918: SELECT db.maction_def_type_flag into l_def_type_flag
919: FROM ieu_uwq_maction_defs_b db,
920: ieu_wp_act_param_sets_b sb
921: WHERE db.maction_def_id = sb.wp_action_def_id
922: AND sb.action_param_set_id = x_param_set_id;
923: end if;
924: --1.

Line 970: FROM ieu_wp_act_param_sets_b

966: (SELECT enum_type_uuid FROM ieu_uwq_sel_enumerators
967: WHERE sel_enum_id = x_node_id)
968: and action_param_set_id in
969: (SELECT action_param_set_id
970: FROM ieu_wp_act_param_sets_b
971: WHERE wp_action_def_id in
972: (select maction_def_id
973: from ieu_uwq_maction_defs_b
974: where maction_def_type_flag = l_def_type_flag

Line 1003: FROM ieu_wp_act_param_sets_b

999: if (l_def_type_flag <> 'N' and l_def_type_flag <>'M') then
1000: --a.
1001: SELECT wp_action_def_id, COUNT(*)
1002: INTO l_maction_def_id, l_num_set_entries
1003: FROM ieu_wp_act_param_sets_b
1004: WHERE wp_action_def_id IN
1005: (SELECT wp_action_def_id FROM ieu_wp_act_param_sets_b
1006: WHERE action_param_set_id = x_param_set_id)
1007: GROUP BY wp_action_def_id;

Line 1005: (SELECT wp_action_def_id FROM ieu_wp_act_param_sets_b

1001: SELECT wp_action_def_id, COUNT(*)
1002: INTO l_maction_def_id, l_num_set_entries
1003: FROM ieu_wp_act_param_sets_b
1004: WHERE wp_action_def_id IN
1005: (SELECT wp_action_def_id FROM ieu_wp_act_param_sets_b
1006: WHERE action_param_set_id = x_param_set_id)
1007: GROUP BY wp_action_def_id;
1008:
1009: --b.

Line 1022: DELETE FROM ieu_wp_act_param_sets_b

1018:
1019: DELETE FROM ieu_wp_act_param_sets_tl
1020: WHERE action_param_set_id = x_param_set_id;
1021:
1022: DELETE FROM ieu_wp_act_param_sets_b
1023: WHERE action_param_set_id = x_param_set_id;
1024:
1025: --c.
1026: IF (l_num_set_entries = 1) THEN