APPS.FEM_DIM_ATTRIBUTES_UTIL_PKG dependencies on FEM_DIM_ATTR_VERSIONS_B

Line 254: SELECT fem_dim_attr_versions_b_s.nextval

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
255: INTO v_version_id
256: FROM dual;
257:
258: FEM_DIM_ATTRIBUTES_PKG.INSERT_ROW(

Line 645: FROM fem_dim_attr_versions_b

641: ------------------------------------
642: BEGIN
643: SELECT version_id
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

Line 665: FROM fem_dim_attr_versions_b

661: -----------------------------------------
662: BEGIN
663: SELECT version_id
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

Line 1138: FROM fem_dim_attr_versions_b

1134: ------------------------------------
1135: BEGIN
1136: SELECT version_id
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

Line 1158: FROM fem_dim_attr_versions_b

1154: -----------------------------------------
1155: BEGIN
1156: SELECT version_id
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

Line 1504: SELECT fem_dim_attr_versions_b_s.NEXTVAL

1500:
1501: ---------------------
1502: -- Create New Version
1503: ---------------------
1504: SELECT fem_dim_attr_versions_b_s.NEXTVAL
1505: INTO v_ver_id FROM dual;
1506:
1507: FEM_DIM_ATTR_VERSIONS_PKG.INSERT_ROW(
1508: x_rowid => v_row_id,

Line 1526: UPDATE fem_dim_attr_versions_b

1522: x_last_update_login => pc_last_update_login);
1523:
1524: IF (p_default_version_flag = 'Y')
1525: THEN
1526: UPDATE fem_dim_attr_versions_b
1527: SET default_version_flag='N'
1528: WHERE attribute_id = v_attr_id
1529: AND version_id <> v_ver_id;
1530: END IF;

Line 1717: FROM fem_dim_attr_versions_b

1713: ---------------------------
1714: BEGIN
1715: SELECT version_id
1716: INTO v_ver_id
1717: FROM fem_dim_attr_versions_b
1718: WHERE attribute_id = v_attr_id
1719: AND version_display_code = p_version_display_code;
1720: EXCEPTION
1721: WHEN no_data_found THEN

Line 1728: UPDATE fem_dim_attr_versions_b

1724:
1725: ---------------------------
1726: -- Update Attribute Default
1727: ---------------------------
1728: UPDATE fem_dim_attr_versions_b
1729: SET default_version_flag='N'
1730: WHERE attribute_id = v_attr_id
1731: AND version_id <> v_ver_id;
1732:

Line 1733: UPDATE fem_dim_attr_versions_b

1729: SET default_version_flag='N'
1730: WHERE attribute_id = v_attr_id
1731: AND version_id <> v_ver_id;
1732:
1733: UPDATE fem_dim_attr_versions_b
1734: SET default_version_flag='Y'
1735: WHERE attribute_id = v_attr_id
1736: AND version_id = v_ver_id;
1737: