eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_AS_TRNCMT_LGCY_PUB dependencies on IGS_CA_INST

Line 245: p_load_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,

241: -------------------------------------------------------------------------------
242: FUNCTION derive_trncmt_data(
243: p_lgcy_trncmt_rec IN OUT NOCOPY lgcy_trncmt_rec_type,
244: p_person_id OUT NOCOPY igs_pe_person.person_id%TYPE,
245: p_load_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
246: p_load_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
247: p_uoo_id OUT NOCOPY igs_ps_unit_ofr_opt_all.uoo_id%TYPE
248: )RETURN BOOLEAN
249: /****************************************************************************

Line 246: p_load_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,

242: FUNCTION derive_trncmt_data(
243: p_lgcy_trncmt_rec IN OUT NOCOPY lgcy_trncmt_rec_type,
244: p_person_id OUT NOCOPY igs_pe_person.person_id%TYPE,
245: p_load_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
246: p_load_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
247: p_uoo_id OUT NOCOPY igs_ps_unit_ofr_opt_all.uoo_id%TYPE
248: )RETURN BOOLEAN
249: /****************************************************************************
250: || Created By : anilk

Line 267: l_teach_cal_type igs_ca_inst.cal_type%TYPE;

263: l_return_value BOOLEAN := FND_API.TO_BOOLEAN(FND_API.G_TRUE);
264: l_message VARCHAR2(2000);
265: l_start_dt DATE ;
266: l_end_dt DATE ;
267: l_teach_cal_type igs_ca_inst.cal_type%TYPE;
268: l_teach_sequence_number igs_ca_inst.sequence_number%TYPE;
269:
270: CURSOR cur_uoo_id(
271: p_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE,

Line 268: l_teach_sequence_number igs_ca_inst.sequence_number%TYPE;

264: l_message VARCHAR2(2000);
265: l_start_dt DATE ;
266: l_end_dt DATE ;
267: l_teach_cal_type igs_ca_inst.cal_type%TYPE;
268: l_teach_sequence_number igs_ca_inst.sequence_number%TYPE;
269:
270: CURSOR cur_uoo_id(
271: p_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
272: p_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE,

Line 359: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,

355:
356: -------------------------------------------------------------------------------
357: FUNCTION validate_trncmt_db_cons(
358: p_person_id IN igs_pe_person.person_id%TYPE,
359: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
360: p_load_sequence_number IN igs_ca_inst.sequence_number%TYPE,
361: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
362: p_lgcy_trncmt_rec IN lgcy_trncmt_rec_type
363: ) RETURN VARCHAR2

Line 360: p_load_sequence_number IN igs_ca_inst.sequence_number%TYPE,

356: -------------------------------------------------------------------------------
357: FUNCTION validate_trncmt_db_cons(
358: p_person_id IN igs_pe_person.person_id%TYPE,
359: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
360: p_load_sequence_number IN igs_ca_inst.sequence_number%TYPE,
361: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
362: p_lgcy_trncmt_rec IN lgcy_trncmt_rec_type
363: ) RETURN VARCHAR2
364: /****************************************************************************

Line 391: cp_load_cal_type igs_ca_inst.cal_type%TYPE,

387:
388: CURSOR cur_check_career_term(
389: cp_person_id igs_pe_person.person_id%TYPE,
390: cp_course_type igs_ps_ver_all.course_type%TYPE,
391: cp_load_cal_type igs_ca_inst.cal_type%TYPE,
392: cp_load_ci_sequence_number igs_ca_inst.sequence_number%TYPE
393: ) IS
394: SELECT 'X'
395: FROM igs_pr_acad_load_v

Line 392: cp_load_ci_sequence_number igs_ca_inst.sequence_number%TYPE

388: CURSOR cur_check_career_term(
389: cp_person_id igs_pe_person.person_id%TYPE,
390: cp_course_type igs_ps_ver_all.course_type%TYPE,
391: cp_load_cal_type igs_ca_inst.cal_type%TYPE,
392: cp_load_ci_sequence_number igs_ca_inst.sequence_number%TYPE
393: ) IS
394: SELECT 'X'
395: FROM igs_pr_acad_load_v
396: WHERE person_id = cp_person_id

Line 579: l_load_cal_type igs_ca_inst.cal_type%TYPE;

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;
583:

Line 580: l_load_sequence_number igs_ca_inst.sequence_number%TYPE;

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;
583:
584: l_return_value VARCHAR2(1);