APPS.IGS_EN_SPAA_LGCY_PUB dependencies on IGS_EN_SPA_AWD_AIM

Line 113: IF igs_en_spa_awd_aim_pkg.get_pk_for_validation (

109:
110: --Check for duplicate record in the Award Aims Table
111: --If record exists then return the return status as 'W' without checking
112: --for further FK checks
113: IF igs_en_spa_awd_aim_pkg.get_pk_for_validation (
114: x_award_cd => p_awd_aim_rec.award_cd,
115: x_course_cd => p_awd_aim_rec.program_cd,
116: x_person_id => p_person_id ) THEN
117: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_AWD_AIM_EXISTS');

Line 253: l_last_update_date igs_en_spa_awd_aim.creation_date%TYPE;

249: l_api_name CONSTANT VARCHAR2(30) := 'create_student_awd_aim';
250: l_api_version CONSTANT NUMBER := 1.0;
251: l_stdnt_awd_aim_status VARCHAR2(10) := 'VALID';
252: l_person_id igs_re_thesis.person_id%TYPE := NULL;
253: l_last_update_date igs_en_spa_awd_aim.creation_date%TYPE;
254: l_last_updated_by igs_en_spa_awd_aim.last_updated_by%TYPE;
255: l_last_update_login igs_en_spa_awd_aim.last_update_login%TYPE;
256:
257: BEGIN

Line 254: l_last_updated_by igs_en_spa_awd_aim.last_updated_by%TYPE;

250: l_api_version CONSTANT NUMBER := 1.0;
251: l_stdnt_awd_aim_status VARCHAR2(10) := 'VALID';
252: l_person_id igs_re_thesis.person_id%TYPE := NULL;
253: l_last_update_date igs_en_spa_awd_aim.creation_date%TYPE;
254: l_last_updated_by igs_en_spa_awd_aim.last_updated_by%TYPE;
255: l_last_update_login igs_en_spa_awd_aim.last_update_login%TYPE;
256:
257: BEGIN
258: -- Standard Start of API savepoint

Line 255: l_last_update_login igs_en_spa_awd_aim.last_update_login%TYPE;

251: l_stdnt_awd_aim_status VARCHAR2(10) := 'VALID';
252: l_person_id igs_re_thesis.person_id%TYPE := NULL;
253: l_last_update_date igs_en_spa_awd_aim.creation_date%TYPE;
254: l_last_updated_by igs_en_spa_awd_aim.last_updated_by%TYPE;
255: l_last_update_login igs_en_spa_awd_aim.last_update_login%TYPE;
256:
257: BEGIN
258: -- Standard Start of API savepoint
259: SAVEPOINT awd_aim_pub;

Line 324: INSERT INTO igs_en_spa_awd_aim (

320: l_last_update_login := -1;
321: END IF;
322:
323: --insert data into Thesis Details table
324: INSERT INTO igs_en_spa_awd_aim (
325: person_id,
326: course_cd,
327: award_cd,
328: start_dt,