APPS.IGS_PE_GEN_004 dependencies on IGS_PE_CREDENTIALS

Line 825: attachment tables for the Entity IGS_PE_CREDENTIALS

821: ) IS
822: /*
823: Purpose: This procedure inserts record in the Credential and Fnd_Lobs table.
824: After the successful insertion of these records it calls the FND_WEBATTCH API to create the link in the
825: attachment tables for the Entity IGS_PE_CREDENTIALS
826:
827: Change History:
828: Who When What
829:

Line 877: igs_pe_credentials_pkg.insert_row (

873: );
874:
875: P_FILE_ID := l_fileid;
876:
877: igs_pe_credentials_pkg.insert_row (
878: x_mode => 'R',
879: x_rowid => lv_rowid,
880: x_credential_id => l_credential_id,
881: x_person_id => P_PERSON_ID,

Line 905: entity_name => 'IGS_PE_CREDENTIALS',

901: text => NULL,
902: file_name => P_FILE_NAME,
903: url => NULL,
904: function_name => NULL,
905: entity_name => 'IGS_PE_CREDENTIALS',
906: pk1_value => l_credential_id,
907: pk2_value => NULL,
908: pk3_value => NULL,
909: pk4_value => NULL,

Line 927: from the IGS_PE_CREDENTIALS table

923: P_MSG_DATA OUT NOCOPY VARCHAR2
924: ) IS
925: /*
926: Purpose: This procedure first removes the link for the attachment created and then deletes the record
927: from the IGS_PE_CREDENTIALS table
928:
929: Change History:
930: Who When What
931:

Line 943: FROM igs_pe_credentials

939: delete_ref_Flag => 'Y'
940: );
941:
942: SELECT ROWID INTO l_rowid
943: FROM igs_pe_credentials
944: WHERE credential_id = P_CREDENTIAL_ID;
945:
946: igs_pe_credentials_pkg.delete_row(
947: x_rowid => l_rowid

Line 946: igs_pe_credentials_pkg.delete_row(

942: SELECT ROWID INTO l_rowid
943: FROM igs_pe_credentials
944: WHERE credential_id = P_CREDENTIAL_ID;
945:
946: igs_pe_credentials_pkg.delete_row(
947: x_rowid => l_rowid
948: );
949:
950: EXCEPTION