APPS.IEU_WORK_ACTION_PVT dependencies on IEU_WP_PARAM_PROPS_B

Line 709: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;

705: l_language VARCHAR2(4);
706: l_source_lang VARCHAR2(4);
707: l_msg_count NUMBER(2);
708: l_msg_data VARCHAR2(2000);
709: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;
710: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
711: v_cursor1 NUMBER;
712: sql_stmt varchar2(2000);
713: sql_stmt1 varchar2(2000);

Line 728: FROM ieu_wp_param_props_b

724:
725: cursor c_cur is
726: SELECT
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(+)

Line 798: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;

794: 1);
795:
796: FOR c_rec in c_cur LOOP
797: begin
798: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;
799: insert INTO IEU_WP_PARAM_PROPS_B
800: (PARAM_PROPERTY_ID,
801: CREATED_BY,
802: CREATION_DATE,

Line 799: insert INTO IEU_WP_PARAM_PROPS_B

795:
796: FOR c_rec in c_cur LOOP
797: begin
798: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;
799: insert INTO IEU_WP_PARAM_PROPS_B
800: (PARAM_PROPERTY_ID,
801: CREATED_BY,
802: CREATION_DATE,
803: LAST_UPDATED_BY,

Line 1012: (SELECT param_property_id FROM ieu_wp_param_props_b

1008:
1009: --b.
1010: DELETE FROM ieu_wp_param_props_tl
1011: WHERE param_property_id IN
1012: (SELECT param_property_id FROM ieu_wp_param_props_b
1013: WHERE
1014: action_param_set_id = x_param_set_id);
1015:
1016: DELETE FROM ieu_wp_param_props_b

Line 1016: DELETE FROM ieu_wp_param_props_b

1012: (SELECT param_property_id FROM ieu_wp_param_props_b
1013: WHERE
1014: action_param_set_id = x_param_set_id);
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;