APPS.IGS_AD_GEN_010 dependencies on IGS_AD_APPL_LTR

Line 649: -- This module validates and inserts a record into the IGS_AD_APPL_LTR

645: p_message_name OUT NOCOPY VARCHAR2 )
646: RETURN BOOLEAN IS
647: gv_other_detail VARCHAR2(255);
648: BEGIN -- admp_ins_aal
649: -- This module validates and inserts a record into the IGS_AD_APPL_LTR
650: -- table
651: DECLARE
652: v_sequence_num IGS_AD_APPL_LTR.sequence_number%TYPE;
653: v_message_name varchar2(30);

Line 652: v_sequence_num IGS_AD_APPL_LTR.sequence_number%TYPE;

648: BEGIN -- admp_ins_aal
649: -- This module validates and inserts a record into the IGS_AD_APPL_LTR
650: -- table
651: DECLARE
652: v_sequence_num IGS_AD_APPL_LTR.sequence_number%TYPE;
653: v_message_name varchar2(30);
654: lv_rowid VARCHAR2(25);
655:
656:

Line 661: FROM IGS_AD_APPL_LTR

657:
658: -- Derive the next sequence number
659: CURSOR c_aal IS
660: SELECT NVL(MAX(sequence_number),0) + 1
661: FROM IGS_AD_APPL_LTR
662: WHERE person_id = p_person_id AND
663: admission_appl_number = p_admission_appl_number AND
664: correspondence_type = p_correspondence_type;
665: BEGIN

Line 697: IGS_AD_APPL_Ltr_Pkg.Insert_Row (

693: OPEN c_aal;
694: FETCH c_aal INTO v_sequence_num;
695: CLOSE c_aal;
696: -- Insert new record
697: IGS_AD_APPL_Ltr_Pkg.Insert_Row (
698: X_Mode => 'R',
699: X_RowId => lv_rowid,
700: X_Person_Id => p_person_id,
701: X_Admission_Appl_Number => p_admission_appl_number,