APPS.FEM_DIM_ATTRIBUTES_UTIL_PKG dependencies on FEM_DIM_ATTRIBUTES_B

Line 165: FROM fem_dim_attributes_b

161: /* Validate that the Attribute Varchar Label does not already exist
162: for the specified dimension */
163: SELECT count(*)
164: INTO v_count
165: FROM fem_dim_attributes_b
166: WHERE attribute_varchar_label = p_attr_varchar_label
167: AND dimension_id = v_dimension_id ;
168:
169: IF v_count > 0 THEN

Line 250: SELECT fem_dim_attributes_b_s.nextval

246:
247: ELSE RAISE e_invalid_attr_data_type_code;
248: END IF; /* attr_data_type_code validation */
249:
250: SELECT fem_dim_attributes_b_s.nextval
251: INTO v_attribute_id
252: FROM dual;
253:
254: SELECT fem_dim_attr_versions_b_s.nextval

Line 573: FROM fem_dim_attributes_b

569: attribute_value_column_name
570: INTO v_attr_id,
571: v_attr_dim_id,
572: v_attr_val_col
573: FROM fem_dim_attributes_b
574: WHERE attribute_varchar_label = p_attribute_varchar_label
575: AND dimension_id = v_dim_id;
576: EXCEPTION
577: WHEN no_data_found THEN

Line 648: FROM fem_dim_attributes_b

644: INTO v_attr_ver_id
645: FROM fem_dim_attr_versions_b
646: WHERE attribute_id =
647: (SELECT attribute_id
648: FROM fem_dim_attributes_b
649: WHERE attribute_id = v_attr_id
650: AND dimension_id = v_dim_id)
651: AND default_version_flag = 'Y';
652: EXCEPTION

Line 668: FROM fem_dim_attributes_b

664: INTO v_attr_ver_id
665: FROM fem_dim_attr_versions_b
666: WHERE attribute_id =
667: (SELECT attribute_id
668: FROM fem_dim_attributes_b
669: WHERE attribute_id = v_attr_id
670: AND dimension_id = v_dim_id)
671: AND version_display_code = p_attr_version_display_code;
672: EXCEPTION

Line 686: ' fem_dim_attributes_b B'||

682: THEN
683: v_sql_stmt :=
684: 'SELECT '||v_attr_val_col||
685: ' FROM '||v_attr_tab||' A,'||
686: ' fem_dim_attributes_b B'||
687: ' WHERE B.attribute_id = :b_attr_id'||
688: ' AND A.attribute_id = B.attribute_id'||
689: ' AND A.value_set_id = :b_vs_id'||
690: ' AND A.version_id = :b_attr_ver_id'||

Line 708: ' fem_dim_attributes_b B'||

704: ELSE
705: v_sql_stmt :=
706: 'SELECT '||v_attr_val_col||
707: ' FROM '||v_attr_tab||' A,'||
708: ' fem_dim_attributes_b B'||
709: ' WHERE B.attribute_id = :b_attr_id'||
710: ' AND A.attribute_id = B.attribute_id'||
711: ' AND A.version_id = :b_attr_ver_id'||
712: ' AND A.'||v_mem_col||' = :b_mem_id';

Line 1066: FROM fem_dim_attributes_b

1062: attribute_value_column_name
1063: INTO v_attr_id,
1064: v_attr_dim_id,
1065: v_attr_val_col
1066: FROM fem_dim_attributes_b
1067: WHERE attribute_varchar_label = p_attribute_varchar_label
1068: AND dimension_id = v_dim_id;
1069: EXCEPTION
1070: WHEN no_data_found THEN

Line 1141: FROM fem_dim_attributes_b

1137: INTO v_attr_ver_id
1138: FROM fem_dim_attr_versions_b
1139: WHERE attribute_id =
1140: (SELECT attribute_id
1141: FROM fem_dim_attributes_b
1142: WHERE attribute_id = v_attr_id
1143: AND dimension_id = v_dim_id)
1144: AND default_version_flag = 'Y';
1145: EXCEPTION

Line 1161: FROM fem_dim_attributes_b

1157: INTO v_attr_ver_id
1158: FROM fem_dim_attr_versions_b
1159: WHERE attribute_id =
1160: (SELECT attribute_id
1161: FROM fem_dim_attributes_b
1162: WHERE attribute_id = v_attr_id
1163: AND dimension_id = v_dim_id)
1164: AND version_display_code = p_attr_version_display_code;
1165: EXCEPTION

Line 1474: FROM fem_dim_attributes_b

1470: allow_multiple_versions_flag
1471: INTO v_attr_id,
1472: v_attr_req_flg,
1473: v_mult_ver_flg
1474: FROM fem_dim_attributes_b
1475: WHERE attribute_varchar_label = p_attribute_varchar_label
1476: AND dimension_id = v_dim_id;
1477: EXCEPTION
1478: WHEN no_data_found THEN

Line 1697: FROM fem_dim_attributes_b

1693: allow_multiple_versions_flag
1694: INTO v_attr_id,
1695: v_attr_req_flg,
1696: v_mult_ver_flg
1697: FROM fem_dim_attributes_b
1698: WHERE attribute_varchar_label = p_attribute_varchar_label
1699: AND dimension_id = v_dim_id;
1700: EXCEPTION
1701: WHEN no_data_found THEN