APPS.IGS_PS_GEN_001 dependencies on DUAL

Line 280: FROM DUAL;

276: -- Removed cursor gc_revseg_rec as part of Enh# 2831572.
277:
278: CURSOR gc_ref_num IS
279: SELECT IGS_GE_NOTE_RF_NUM_S.NEXTVAL
280: FROM DUAL;
281: CURSOR gc_coo_seq_num IS
282: SELECT IGS_PS_OFR_OPT_COO_ID_S.NEXTVAL
283: FROM DUAL;
284:

Line 283: FROM DUAL;

279: SELECT IGS_GE_NOTE_RF_NUM_S.NEXTVAL
280: FROM DUAL;
281: CURSOR gc_coo_seq_num IS
282: SELECT IGS_PS_OFR_OPT_COO_ID_S.NEXTVAL
283: FROM DUAL;
284:
285: -- procedure for inserting new IGS_GE_NOTE and IGS_PS_OFR_OPT_NOTE records
286: PROCEDURE crsp_ins_coon_rec (
287: p_new_course_cd IGS_PS_VER.course_cd%TYPE,

Line 410: FROM DUAL;

406: BEGIN
407: -- select the next sequence_number from the system
408: SELECT IGS_PS_OFR_PAT_COP_ID_S.NEXTVAL
409: INTO gv_cop_seq_num
410: FROM DUAL;
411: -- get the latest grading schema version number
412: OPEN c_latest_gs_version (
413: gv_cop_rec.grading_schema_cd);
414: FETCH c_latest_gs_version INTO v_gs_version_number;

Line 923: FROM DUAL;

919: v_posp_seq_num IGS_PS_PAT_STUDY_PRD.sequence_number%TYPE;
920: v_posu_seq_num IGS_PS_PAT_STUDY_UNT.sequence_number%TYPE;
921: CURSOR c_pos_seq_num IS
922: SELECT IGS_PS_PAT_OF_STUDY_POS_NUM_S.NEXTVAL
923: FROM DUAL;
924: CURSOR c_posp_seq_num IS
925: SELECT IGS_PS_PAT_STUDY_UNT_POSPSEQ_S.NEXTVAL
926: FROM DUAL;
927: CURSOR c_posu_seq_num IS

Line 926: FROM DUAL;

922: SELECT IGS_PS_PAT_OF_STUDY_POS_NUM_S.NEXTVAL
923: FROM DUAL;
924: CURSOR c_posp_seq_num IS
925: SELECT IGS_PS_PAT_STUDY_UNT_POSPSEQ_S.NEXTVAL
926: FROM DUAL;
927: CURSOR c_posu_seq_num IS
928: SELECT IGS_PS_PAT_STUDY_UNT_SEQ_NUM_S.NEXTVAL
929: FROM DUAL;
930: CURSOR c_pos IS

Line 929: FROM DUAL;

925: SELECT IGS_PS_PAT_STUDY_UNT_POSPSEQ_S.NEXTVAL
926: FROM DUAL;
927: CURSOR c_posu_seq_num IS
928: SELECT IGS_PS_PAT_STUDY_UNT_SEQ_NUM_S.NEXTVAL
929: FROM DUAL;
930: CURSOR c_pos IS
931: SELECT pos.cal_type,
932: pos.sequence_number,
933: pos.location_cd,

Line 1631: FROM DUAL;

1627: v_cst_seq_num IGS_PS_STAGE.sequence_number%TYPE;
1628: v_new_rul_seq_num IGS_PS_STAGE_RU.rul_sequence_number%TYPE;
1629: CURSOR c_cst_seq_num IS
1630: SELECT IGS_PS_STAGE_SEQ_NUM_S.NEXTVAL
1631: FROM DUAL;
1632: CURSOR c_cst IS
1633: SELECT cst.sequence_number,
1634: cst.course_stage_type,
1635: cst.description,

Line 1786: FROM DUAL;

1782: WHERE dms.course_cd = p_old_course_cd AND
1783: dms.version_number = p_old_version_number;
1784: CURSOR c_dms_seq IS
1785: SELECT IGS_RE_DFLT_MS_SET_SEQ_NUM_S.NEXTVAL
1786: FROM DUAL;
1787: BEGIN
1788: FOR v_dms_rec IN c_dms LOOP
1789: BEGIN
1790: OPEN c_dms_seq;

Line 3666: SELECT IGS_GE_NOTE_RF_NUM_S.NEXTVAL INTO lnnote_ref_number FROM dual;

3662: IF cur_c_unt_ofr_opt_n_new%NOTFOUND THEN
3663: --insert a record in the igs_ge_note table corresponding to the reference number create
3664: -- for unit section note.
3665:
3666: SELECT IGS_GE_NOTE_RF_NUM_S.NEXTVAL INTO lnnote_ref_number FROM dual;
3667:
3668: igs_ge_note_pkg.insert_row(
3669: x_rowid => lv_gerowid,
3670: x_reference_number => lnnote_ref_number ,