DBA Data[Home] [Help]

APPS.IEU_WORK_ACTION_PVT dependencies on IEU_WP_ACT_PARAM_SETS_TL

Line 267: ieu_wp_act_param_sets_tl stl

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
271: where maction_def_id = (select wp_action_def_id

Line 570: insert INTO IEU_WP_ACT_PARAM_SETS_TL

566: FND_GLOBAL.LOGIN_ID,
567: l_maction_def_id,
568: 0
569: );
570: insert INTO IEU_WP_ACT_PARAM_SETS_TL
571: (ACTION_PARAM_SET_ID,
572: CREATED_BY,
573: CREATION_DATE,
574: LAST_UPDATED_BY,

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 772: INSERT INTO ieu_WP_ACT_PARAM_SETS_tl

768: FND_GLOBAL.LOGIN_ID,
769: r_maction_def_id,
770: 1);
771:
772: INSERT INTO ieu_WP_ACT_PARAM_SETS_tl
773: ( ACTION_PARAM_SET_ID,
774: language,
775: created_by,
776: creation_date,

Line 1019: DELETE FROM ieu_wp_act_param_sets_tl

1015:
1016: DELETE FROM ieu_wp_param_props_b
1017: WHERE action_param_set_id = x_param_set_id;
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;