DBA Data[Home] [Help]

APPS.IGS_AD_SS_GEN_001 dependencies on IGS_PE_TYP_INSTANCES_PKG

Line 656: a.IGS_PE_TYP_INSTANCES_PKG.insert_row

652: Date Created : 11-DEC-2001
653: Purpose:
654: 1. Updates Person Type to Applicant on Successful Import/Transfer of the Application/Prog/Prog Inst
655: 2. Flow:
656: a.IGS_PE_TYP_INSTANCES_PKG.insert_row
657:
658: Known limitations,enhancements,remarks:
659: Change History
660: Who When What

Line 661: npalanis 10-JUN-2003 Bug:2923413 igs_pe_typ_instances_pkg.update_row call

657:
658: Known limitations,enhancements,remarks:
659: Change History
660: Who When What
661: npalanis 10-JUN-2003 Bug:2923413 igs_pe_typ_instances_pkg.update_row call
662: modified for the new employment category column added in the table
663: *****************************************************************************************/
664:
665: l_rowid VARCHAR2(25);

Line 684: logDetail('Before call to IGS_PE_TYP_INSTANCES_PKG.insert_row', 'S');

680: OPEN c_person_type_code('APPLICANT');
681: FETCH c_person_type_code
682: INTO l_person_type_code;
683: CLOSE c_person_type_code;
684: logDetail('Before call to IGS_PE_TYP_INSTANCES_PKG.insert_row', 'S');
685:
686: -- Setting Person Mandatory Validations to False
687: IGS_PE_GEN_004.SKIP_MAND_DATA_VAL;
688:

Line 695: IGS_PE_TYP_INSTANCES_PKG.insert_row(x_rowid => l_rowid,

691: THEN
692: lv_mode := 'S';
693: END IF;
694:
695: IGS_PE_TYP_INSTANCES_PKG.insert_row(x_rowid => l_rowid,
696: x_org_id => l_org_id,
697: x_person_id => p_person_id,
698: x_course_cd => NULL,
699: x_type_instance_id => l_type_instance_id,

Line 718: 'Exception from IGS_PE_TYP_INSTANCES_PKG.insert_row ' ||

714: logDetail('Person_type Changed to APPLICANT for the person', 'S');
715: EXCEPTION
716: WHEN OTHERS THEN
717: logDetail('inside update_person_type' ||
718: 'Exception from IGS_PE_TYP_INSTANCES_PKG.insert_row ' ||
719: SQLERRM || 'person_id : ' ||
720: IGS_GE_NUMBER.TO_CANN(p_person_id),
721: 'S');
722: IF FND_MSG_PUB.Count_Msg < 1 THEN