APPS.FEM_SIGNAGE_PKG dependencies on FEM_EXT_ACCT_TYPES_ATTR

Line 74: FROM fem_ext_acct_types_attr

70: v_sql_cmd VARCHAR(32767);
71:
72: CURSOR c_member IS
73: SELECT distinct ext_account_type_code,dim_attribute_varchar_member
74: FROM fem_ext_acct_types_attr
75: WHERE attribute_id = v_type_attr
76: ORDER BY ext_account_type_code;
77:
78: e_no_sign_val EXCEPTION;

Line 250: 'DELETE FROM fem_ext_acct_types_attr'||

246: ----------------------------
247: -- Delete old signage values
248: ----------------------------
249: v_sql_cmd :=
250: 'DELETE FROM fem_ext_acct_types_attr'||
251: ' WHERE attribute_id = :b_sign_attr'||
252: ' AND version_id = :b_sign_vers';
253:
254: FEM_ENGINES_PKG.TECH_MESSAGE

Line 296: v_sql_cmd := 'INSERT INTO fem_ext_acct_types_attr'||

292: (p_severity => c_log_level_1,
293: p_module => v_block||'.sign_value',
294: p_msg_text => v_sign_val);
295:
296: v_sql_cmd := 'INSERT INTO fem_ext_acct_types_attr'||
297: '(attribute_id,version_id,ext_account_type_code'||
298: ',number_assign_value,creation_date,created_by'||
299: ',last_updated_by,last_update_date'||
300: ',object_version_number,aw_snapshot_flag)'||