APPS.ZPB_AC_OPS dependencies on ZPB_TASK_ID_SEQ

Line 519: SELECT zpb_task_id_seq.NEXTVAL INTO target_task_id FROM DUAL;

515: copy_task := true;
516: end if;
517: if copy_task = true
518: then
519: SELECT zpb_task_id_seq.NEXTVAL INTO target_task_id FROM DUAL;
520: source_task_id := ac_task_rec.task_id;
521: ac_task_rec.analysis_cycle_id := target_ac_id_in;
522: ac_task_rec.task_id := target_task_id;
523: ac_task_rec.CREATED_BY := fnd_global.USER_ID;

Line 1001: SELECT zpb_task_id_seq.NEXTVAL INTO target_task_id FROM DUAL;

997:
998: DELETE FROM zpb_analysis_cycle_tasks
999: WHERE task_id = todelete_task_id;
1000:
1001: SELECT zpb_task_id_seq.NEXTVAL INTO target_task_id FROM DUAL;
1002: source_task_id := ac_task_rec.task_id;
1003: ac_task_rec.analysis_cycle_id := target_ac_id_in;
1004: ac_task_rec.task_id := target_task_id;
1005: ac_task_rec.CREATED_BY := fnd_global.USER_ID;

Line 3011: SELECT zpb_task_id_seq.NEXTVAL INTO load_task_id from dual;

3007: task_param_id zpb_task_parameters.param_id%TYPE;
3008: ac_task_rec zpb_analysis_cycle_tasks%rowtype;
3009: begin
3010:
3011: SELECT zpb_task_id_seq.NEXTVAL INTO load_task_id from dual;
3012:
3013: ac_task_rec.analysis_cycle_id := p_ac_id;
3014: ac_task_rec.task_id := load_task_id;
3015: ac_task_rec.sequence := 1;

Line 3077: SELECT zpb_task_id_seq.NEXTVAL INTO curinst_task_id from dual;

3073: task_param_id zpb_task_parameters.param_id%TYPE;
3074: ac_task_rec zpb_analysis_cycle_tasks%rowtype;
3075: begin
3076:
3077: SELECT zpb_task_id_seq.NEXTVAL INTO curinst_task_id from dual;
3078:
3079: ac_task_rec.analysis_cycle_id := p_ac_id;
3080: ac_task_rec.task_id := curinst_task_id;
3081: ac_task_rec.sequence := 2;