APPS.IGS_AD_GEN_011 dependencies on IGS_CO_ITM_RF_NUM_S

Line 773: SELECT igs_co_itm_rf_num_s.NEXTVAL

769: gv_other_detail VARCHAR2(255);
770: gv_first_cori BOOLEAN DEFAULT TRUE;
771: gv_reference_number NUMBER DEFAULT NULL;
772: CURSOR c_igsco_itm_rf_num_s IS
773: SELECT igs_co_itm_rf_num_s.NEXTVAL
774: FROM dual;
775: CURSOR c_igs_co_ou_co_ref_seq_num_s IS
776: SELECT igs_co_ou_co_ref_seq_num_s.NEXTVAL
777: FROM dual;

Line 805: v_igs_co_itm_rf_num_s NUMBER;

801: v_message_name VARCHAR2(30);
802: v_sl_record_found BOOLEAN DEFAULT FALSE;
803: lv_rowid VARCHAR2(25);
804: x_rowid VARCHAR2(25);
805: v_igs_co_itm_rf_num_s NUMBER;
806: v_igs_co_ou_co_ref_seq_num_s igs_co_ou_co_ref.sequence_number%TYPE;
807: CURSOR c_apcl_slet (
808: cp_admission_cat igs_ad_appl.admission_cat%TYPE,
809: cp_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE,

Line 927: FETCH c_igsco_itm_rf_num_s INTO v_igs_co_itm_rf_num_s;

923: || p_org_unit
924: || ', Sort By-'
925: || p_sortby;
926: OPEN c_igsco_itm_rf_num_s;
927: FETCH c_igsco_itm_rf_num_s INTO v_igs_co_itm_rf_num_s;
928: IF c_igsco_itm_rf_num_s%NOTFOUND THEN
929: RAISE NO_DATA_FOUND;
930: END IF;
931: CLOSE c_igsco_itm_rf_num_s;

Line 942: x_reference_number => v_igs_co_itm_rf_num_s,

938: igs_co_itm_pkg.insert_row (
939: x_rowid => lv_rowid,
940: x_org_id => fnd_profile.value ('ORG_ID'),
941: x_correspondence_type => p_correspondence_type,
942: x_reference_number => v_igs_co_itm_rf_num_s,
943: x_create_dt => v_create_dt,
944: x_originator_person_id => NULL,
945: x_request_num => NULL,
946: x_s_job_name => NULL,