APPS.IGS_AS_TRNCMT_LGCY_PUB dependencies on IGS_AS_STU_TRN_CMTS

Line 428: IF igs_as_stu_trn_cmts_pkg.get_uk_for_validation(

424: l_return_value VARCHAR2(10) := FND_API.G_RET_STS_SUCCESS;
425:
426: BEGIN
427: -- Unique key validation
428: IF igs_as_stu_trn_cmts_pkg.get_uk_for_validation(
429: x_person_id => p_person_id,
430: x_comment_type_code => p_lgcy_trncmt_rec.comment_type_code,
431: x_course_cd => p_lgcy_trncmt_rec.program_cd,
432: x_course_type => p_lgcy_trncmt_rec.program_type,

Line 578: l_comment_id igs_as_stu_trn_cmts.comment_id%TYPE;

574: l_api_name CONSTANT VARCHAR2(30) := 'create_trncmt';
575: l_api_version CONSTANT NUMBER := 1.0;
576:
577: --Local params
578: l_comment_id igs_as_stu_trn_cmts.comment_id%TYPE;
579: l_load_cal_type igs_ca_inst.cal_type%TYPE;
580: l_load_sequence_number igs_ca_inst.sequence_number%TYPE;
581: l_person_id igs_pe_person.person_id%TYPE;
582: l_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;

Line 649: INSERT INTO IGS_AS_STU_TRN_CMTS

645: INTO l_comment_id
646: FROM dual
647: WHERE ROWNUM = 1;
648:
649: INSERT INTO IGS_AS_STU_TRN_CMTS
650: (
651: COMMENT_ID ,
652: COMMENT_TYPE_CODE ,
653: COMMENT_TXT ,