APPS.ZPB_BUSAREA_MAINT dependencies on ZPB_BUSAREA_DATASETS

Line 139: insert into ZPB_BUSAREA_DATASETS

135: PROCEDURE ADD_DATASET (p_version_id IN NUMBER,
136: p_dataset_id IN NUMBER)
137: is
138: begin
139: insert into ZPB_BUSAREA_DATASETS
140: (VERSION_ID,
141: DATASET_ID,
142: CREATION_DATE,
143: CREATED_BY,

Line 734: delete from ZPB_BUSAREA_DATASETS

730:
731: delete from ZPB_BUSAREA_LEDGERS
732: where VERSION_ID = p_version_id;
733:
734: delete from ZPB_BUSAREA_DATASETS
735: where VERSION_ID = p_version_id;
736: end CLEAR_VERSION;
737:
738: -------------------------------------------------------------------------

Line 1199: insert into ZPB_BUSAREA_DATASETS

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,
1201: DATASET_ID,
1202: CREATION_DATE,
1203: CREATED_BY,

Line 1214: from ZPB_BUSAREA_DATASETS

1210: FND_GLOBAL.USER_ID,
1211: FND_GLOBAL.LOGIN_ID,
1212: sysdate,
1213: FND_GLOBAL.USER_ID
1214: from ZPB_BUSAREA_DATASETS
1215: where VERSION_ID = l_from_version_id;
1216:
1217: insert into ZPB_BUSAREA_LEDGERS
1218: (VERSION_ID,

Line 1676: delete from ZPB_BUSAREA_DATASETS

1672: PROCEDURE REMOVE_DATASET (p_version_id IN NUMBER,
1673: p_dataset_id IN NUMBER)
1674: is
1675: begin
1676: delete from ZPB_BUSAREA_DATASETS
1677: where VERSION_ID = p_version_id
1678: and DATASET_ID = p_dataset_id;
1679: end REMOVE_DATASET;
1680:

Line 2129: from ZPB_BUSAREA_DATASETS BA_DS

2125: where FDR_MAP.FUNC_DIM_SET_ID = FDR_SET.FUNC_DIM_SET_ID
2126: and FDR_SET.FUNC_DIM_SET_OBJ_DEF_ID = p_fdr_obj_def_id
2127: and DATA_LOC.TABLE_NAME = FDR_MAP.TABLE_NAME
2128: and NOT EXISTS (select BA_DS.DATASET_ID
2129: from ZPB_BUSAREA_DATASETS BA_DS
2130: where BA_DS.VERSION_ID = p_version_id
2131: and BA_DS.DATASET_ID = DATA_LOC.DATASET_CODE);
2132: BEGIN
2133: