DBA Data[Home] [Help]

APPS.IGS_PS_GEN_008 dependencies on IGS_AS_UNITASS_ITEM_SEQ_NUM_S

Line 1632: SELECT IGS_AS_UNITASS_ITEM_SEQ_NUM_S.nextval

1628: l_message_name) = TRUE) THEN
1629: --
1630: -- End of the latest version check of Grading Schema.
1631: --
1632: SELECT IGS_AS_UNITASS_ITEM_SEQ_NUM_S.nextval
1633: INTO v_new_sequence_number
1634: FROM dual;
1635: x_rowid := NULL;
1636: l_unit_ass_item_id := NULL;

Line 2595: SELECT IGS_AS_UNITASS_ITEM_SEQ_NUM_S.NEXTVAL

2591: SELECT IGS_PS_UNIT_OFR_OPT_UOO_ID_S.NEXTVAL
2592: FROM DUAL;
2593:
2594: CURSOR c_uai_seq_num IS
2595: SELECT IGS_AS_UNITASS_ITEM_SEQ_NUM_S.NEXTVAL
2596: FROM DUAL;
2597:
2598: CURSOR c_teach_date(cp_cal_type igs_ca_inst_all.cal_type%TYPE ,cp_seq_num igs_ca_inst_all.sequence_number%TYPE) IS
2599: SELECT start_dt,end_dt