APPS.ZPB_AC_OPS dependencies on ZPB_CYCLE_DATASETS

Line 264: INSERT INTO zpb_cycle_datasets

260: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
261: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
262: IS
263: BEGIN
264: INSERT INTO zpb_cycle_datasets
265: (ANALYSIS_CYCLE_ID,
266: DATASET_CODE,
267: ORDER_ID,
268: CREATED_BY,

Line 281: FROM zpb_cycle_datasets

277: SYSDATE,
278: fnd_global.USER_ID,
279: SYSDATE,
280: fnd_global.LOGIN_ID
281: FROM zpb_cycle_datasets
282: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in;
283:
284: END copy_cycle_datasets_recs;
285:

Line 1171: DELETE FROM zpb_cycle_datasets

1167:
1168: DELETE FROM zpb_ac_param_values
1169: WHERE analysis_cycle_id = ac_id_in;
1170:
1171: DELETE FROM zpb_cycle_datasets
1172: WHERE analysis_cycle_id = ac_id_in;
1173:
1174: DELETE FROM zpb_analysis_cycles
1175: WHERE analysis_cycle_id = ac_id_in;

Line 2613: ds_rec zpb_cycle_datasets%rowtype;

2609: procedure create_datasets( p_ac_id in number,
2610: dataset_list in varchar2,
2611: p_apps_user_id in number) AS
2612:
2613: ds_rec zpb_cycle_datasets%rowtype;
2614: order_id zpb_cycle_datasets.order_id%type;
2615: dataset varchar2(100);
2616: i integer;
2617: j integer;

Line 2614: order_id zpb_cycle_datasets.order_id%type;

2610: dataset_list in varchar2,
2611: p_apps_user_id in number) AS
2612:
2613: ds_rec zpb_cycle_datasets%rowtype;
2614: order_id zpb_cycle_datasets.order_id%type;
2615: dataset varchar2(100);
2616: i integer;
2617: j integer;
2618:

Line 2641: INSERT INTO zpb_cycle_datasets(ANALYSIS_CYCLE_ID,

2637: ds_rec.dataset_code := dataset;
2638: ds_rec.order_id := order_id;
2639: order_id := order_id + 1;
2640:
2641: INSERT INTO zpb_cycle_datasets(ANALYSIS_CYCLE_ID,
2642: DATASET_CODE,
2643: ORDER_ID,
2644: LAST_UPDATE_LOGIN,
2645: LAST_UPDATE_DATE,