APPS.ZPB_BUSAREA_MAINT dependencies on ZPB_BUSAREA_ATTRIBUTES

Line 64: insert into ZPB_BUSAREA_ATTRIBUTES

60: p_logical_dim_id IN NUMBER, -- "Consistent Dimension"
61: p_attribute_id IN NUMBER)
62: is
63: begin
64: insert into ZPB_BUSAREA_ATTRIBUTES
65: (VERSION_ID,
66: LOGICAL_DIM_ID, -- "Consistent Dimension"
67: ATTRIBUTE_ID,
68: CREATION_DATE,

Line 725: delete from ZPB_BUSAREA_ATTRIBUTES

721:
722: delete from ZPB_BUSAREA_LEVELS
723: where VERSION_ID = p_version_id;
724:
725: delete from ZPB_BUSAREA_ATTRIBUTES
726: where VERSION_ID = p_version_id;
727:
728: delete from ZPB_BUSAREA_CONDITIONS
729: where VERSION_ID = p_version_id;

Line 1153: insert into ZPB_BUSAREA_ATTRIBUTES

1149: FND_GLOBAL.USER_ID
1150: from ZPB_BUSAREA_LEVELS
1151: where VERSION_ID = l_from_version_id;
1152:
1153: insert into ZPB_BUSAREA_ATTRIBUTES
1154: (VERSION_ID,
1155: LOGICAL_DIM_ID, -- "Consistent Dimension"
1156: ATTRIBUTE_ID,
1157: CREATION_DATE,

Line 1170: from ZPB_BUSAREA_ATTRIBUTES

1166: FND_GLOBAL.USER_ID,
1167: FND_GLOBAL.LOGIN_ID,
1168: sysdate,
1169: FND_GLOBAL.USER_ID
1170: from ZPB_BUSAREA_ATTRIBUTES
1171: where VERSION_ID = l_from_version_id;
1172:
1173: insert into ZPB_BUSAREA_CONDITIONS
1174: (VERSION_ID,

Line 1622: delete from ZPB_BUSAREA_ATTRIBUTES

1618: p_logical_dim_id IN NUMBER, -- "Consistent Dimension"
1619: p_attribute_id IN NUMBER)
1620: is
1621: begin
1622: delete from ZPB_BUSAREA_ATTRIBUTES
1623: where VERSION_ID = p_version_id
1624: and LOGICAL_DIM_ID = p_logical_dim_id -- "Consistent Dimension"
1625: and ATTRIBUTE_ID = p_attribute_id;
1626: end REMOVE_ATTRIBUTE;

Line 1703: from ZPB_BUSAREA_ATTRIBUTES

1699:
1700: -- "Consistent Dimension"
1701: cursor c_dim_attr_curs is
1702: select ATTRIBUTE_ID
1703: from ZPB_BUSAREA_ATTRIBUTES
1704: where VERSION_ID = p_version_id
1705: AND LOGICAL_DIM_ID = p_logical_dim_id;
1706:
1707: l_dim_attr c_dim_attr_curs%ROWTYPE;