APPS.IGS_AD_GEN_011 dependencies on IGS_CO_OU_CO_REF

Line 775: CURSOR c_igs_co_ou_co_ref_seq_num_s IS

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;
778: FUNCTION Admpl_Process_Person (
779: p_person_id IN igs_ad_appl_ltr.person_id%TYPE,

Line 776: SELECT igs_co_ou_co_ref_seq_num_s.NEXTVAL

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;
778: FUNCTION Admpl_Process_Person (
779: p_person_id IN igs_ad_appl_ltr.person_id%TYPE,
780: p_admission_appl_number IN igs_ad_appl.admission_appl_number%TYPE,

Line 806: v_igs_co_ou_co_ref_seq_num_s igs_co_ou_co_ref.sequence_number%TYPE;

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,
810: cp_correspondence_type igs_ad_appl_ltr.correspondence_type%TYPE

Line 1014: OPEN c_igs_co_ou_co_ref_seq_num_s;

1010: x_spl_sequence_number => v_spl_sequence_number,
1011: x_mode => 'R'
1012: );
1013: END;
1014: OPEN c_igs_co_ou_co_ref_seq_num_s;
1015: FETCH c_igs_co_ou_co_ref_seq_num_s INTO v_igs_co_ou_co_ref_seq_num_s;
1016: IF (c_igs_co_ou_co_ref_seq_num_s%NOTFOUND) THEN
1017: RAISE NO_DATA_FOUND;
1018: END IF;

Line 1015: FETCH c_igs_co_ou_co_ref_seq_num_s INTO v_igs_co_ou_co_ref_seq_num_s;

1011: x_mode => 'R'
1012: );
1013: END;
1014: OPEN c_igs_co_ou_co_ref_seq_num_s;
1015: FETCH c_igs_co_ou_co_ref_seq_num_s INTO v_igs_co_ou_co_ref_seq_num_s;
1016: IF (c_igs_co_ou_co_ref_seq_num_s%NOTFOUND) THEN
1017: RAISE NO_DATA_FOUND;
1018: END IF;
1019: CLOSE c_igs_co_ou_co_ref_seq_num_s;

Line 1016: IF (c_igs_co_ou_co_ref_seq_num_s%NOTFOUND) THEN

1012: );
1013: END;
1014: OPEN c_igs_co_ou_co_ref_seq_num_s;
1015: FETCH c_igs_co_ou_co_ref_seq_num_s INTO v_igs_co_ou_co_ref_seq_num_s;
1016: IF (c_igs_co_ou_co_ref_seq_num_s%NOTFOUND) THEN
1017: RAISE NO_DATA_FOUND;
1018: END IF;
1019: CLOSE c_igs_co_ou_co_ref_seq_num_s;
1020: --

Line 1019: CLOSE c_igs_co_ou_co_ref_seq_num_s;

1015: FETCH c_igs_co_ou_co_ref_seq_num_s INTO v_igs_co_ou_co_ref_seq_num_s;
1016: IF (c_igs_co_ou_co_ref_seq_num_s%NOTFOUND) THEN
1017: RAISE NO_DATA_FOUND;
1018: END IF;
1019: CLOSE c_igs_co_ou_co_ref_seq_num_s;
1020: --
1021: -- Insert a record in Outgoing Correspondence Reference table.
1022: --
1023: DECLARE

Line 1026: igs_co_ou_co_ref_pkg.insert_row (

1022: --
1023: DECLARE
1024: lv_rowid VARCHAR2(25);
1025: BEGIN
1026: igs_co_ou_co_ref_pkg.insert_row (
1027: x_rowid => lv_rowid,
1028: x_person_id => p_person_id,
1029: x_org_id => l_org_id,
1030: x_correspondence_type => p_correspondence_type,

Line 1033: x_sequence_number => v_igs_co_ou_co_ref_seq_num_s,

1029: x_org_id => l_org_id,
1030: x_correspondence_type => p_correspondence_type,
1031: x_reference_number => gv_reference_number,
1032: x_issue_dt => v_issue_dt,
1033: x_sequence_number => v_igs_co_ou_co_ref_seq_num_s,
1034: x_cal_type => NULL,
1035: x_ci_sequence_number => NULL,
1036: x_course_cd => NULL,
1037: x_cv_version_number => NULL,

Line 1065: CLOSE c_igs_co_ou_co_ref_seq_num_s;

1061: END;
1062: EXCEPTION
1063: WHEN NO_DATA_FOUND THEN
1064: CLOSE c_igsco_itm_rf_num_s;
1065: CLOSE c_igs_co_ou_co_ref_seq_num_s;
1066: WHEN E_RESOURCE_BUSY THEN
1067: p_message_name := 'IGS_AD_LETTER_NOTUPD_LOCKING';
1068: RETURN FALSE;
1069: WHEN OTHERS THEN