APPS.ZPB_BUSAREA_MAINT dependencies on ZPB_BUSAREA_CONDITIONS

Line 103: insert into ZPB_BUSAREA_CONDITIONS

99: p_value_set_id IN NUMBER,
100: p_operation IN VARCHAR2)
101: is
102: begin
103: insert into ZPB_BUSAREA_CONDITIONS
104: (VERSION_ID,
105: LOGICAL_DIM_ID, -- "Consistent Dimension"
106: ATTRIBUTE_ID,
107: VALUE,

Line 728: delete from ZPB_BUSAREA_CONDITIONS

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;
730:
731: delete from ZPB_BUSAREA_LEDGERS
732: where VERSION_ID = p_version_id;

Line 1173: insert into ZPB_BUSAREA_CONDITIONS

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,
1175: LOGICAL_DIM_ID, -- "Consistent Dimension"
1176: ATTRIBUTE_ID,
1177: VALUE,

Line 1196: from ZPB_BUSAREA_CONDITIONS

1192: FND_GLOBAL.USER_ID,
1193: FND_GLOBAL.LOGIN_ID,
1194: sysdate,
1195: FND_GLOBAL.USER_ID
1196: from ZPB_BUSAREA_CONDITIONS
1197: where VERSION_ID = l_from_version_id;
1198:
1199: insert into ZPB_BUSAREA_DATASETS
1200: (VERSION_ID,

Line 1649: delete from ZPB_BUSAREA_CONDITIONS

1645:
1646: is
1647: begin
1648: if (p_value_set_id is not null) then
1649: delete from ZPB_BUSAREA_CONDITIONS
1650: where VERSION_ID = p_version_id
1651: and LOGICAL_DIM_ID = p_logical_dim_id -- "Consistent Dimension"
1652: and ATTRIBUTE_ID = p_attribute_id
1653: and nvl(TRIM(VALUE), '*') = nvl(p_value, '*')

Line 1658: delete from ZPB_BUSAREA_CONDITIONS

1654: and VALUE_SET_ID = p_value_set_id
1655: and OPERATION = p_operation;
1656:
1657: else
1658: delete from ZPB_BUSAREA_CONDITIONS
1659: where VERSION_ID = p_version_id
1660: and LOGICAL_DIM_ID = p_logical_dim_id -- "Consistent Dimension"
1661: and ATTRIBUTE_ID = p_attribute_id
1662: and nvl(TRIM(VALUE), '*') = nvl(p_value, '*')