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.

APPS.IGS_EN_VAL_SCHO dependencies on IGS_EN_STDNTPSHECSOP

Line 18: -- This module validates deletion of IGS_EN_STDNTPSHECSOP in

14: p_start_dt IN DATE ,
15: p_message_name OUT NOCOPY VARCHAR2)
16: RETURN BOOLEAN AS
17: BEGIN -- enrp_val_scho_trgdel
18: -- This module validates deletion of IGS_EN_STDNTPSHECSOP in
19: -- the database trigger. This varies from the form validation in
20: -- that it allows deletion of when the student course attempt is
21: -- unconfirmed.
22: DECLARE

Line 94: -- IGS_EN_STDNTPSHECSOP record. This routine is typically called by

90: p_message_name OUT NOCOPY VARCHAR2)
91: RETURN boolean AS
92: BEGIN -- enrp_val_scho_all
93: -- Perform all validations associated with the addition of a
94: -- IGS_EN_STDNTPSHECSOP record. This routine is typically called by
95: -- processes which are defaulting or HECS records and need all validations
96: -- to be performed.
97: -- The routine will return a single error, being the first one encountered.
98: DECLARE

Line 435: cp_person_id IGS_EN_STDNTPSHECSOP.person_id%TYPE,

431: RETURN BOOLEAN AS
432: BEGIN
433: DECLARE
434: CURSOR gc_scho(
435: cp_person_id IGS_EN_STDNTPSHECSOP.person_id%TYPE,
436: cp_course_cd IGS_EN_STDNTPSHECSOP.course_cd%TYPE,
437: cp_start_dt IGS_EN_STDNTPSHECSOP.start_dt%TYPE) IS
438: SELECT IGS_EN_STDNTPSHECSOP.end_dt
439: FROM IGS_EN_STDNTPSHECSOP

Line 436: cp_course_cd IGS_EN_STDNTPSHECSOP.course_cd%TYPE,

432: BEGIN
433: DECLARE
434: CURSOR gc_scho(
435: cp_person_id IGS_EN_STDNTPSHECSOP.person_id%TYPE,
436: cp_course_cd IGS_EN_STDNTPSHECSOP.course_cd%TYPE,
437: cp_start_dt IGS_EN_STDNTPSHECSOP.start_dt%TYPE) IS
438: SELECT IGS_EN_STDNTPSHECSOP.end_dt
439: FROM IGS_EN_STDNTPSHECSOP
440: WHERE IGS_EN_STDNTPSHECSOP.person_id = cp_person_id AND

Line 437: cp_start_dt IGS_EN_STDNTPSHECSOP.start_dt%TYPE) IS

433: DECLARE
434: CURSOR gc_scho(
435: cp_person_id IGS_EN_STDNTPSHECSOP.person_id%TYPE,
436: cp_course_cd IGS_EN_STDNTPSHECSOP.course_cd%TYPE,
437: cp_start_dt IGS_EN_STDNTPSHECSOP.start_dt%TYPE) IS
438: SELECT IGS_EN_STDNTPSHECSOP.end_dt
439: FROM IGS_EN_STDNTPSHECSOP
440: WHERE IGS_EN_STDNTPSHECSOP.person_id = cp_person_id AND
441: IGS_EN_STDNTPSHECSOP.course_cd = cp_course_cd AND

Line 438: SELECT IGS_EN_STDNTPSHECSOP.end_dt

434: CURSOR gc_scho(
435: cp_person_id IGS_EN_STDNTPSHECSOP.person_id%TYPE,
436: cp_course_cd IGS_EN_STDNTPSHECSOP.course_cd%TYPE,
437: cp_start_dt IGS_EN_STDNTPSHECSOP.start_dt%TYPE) IS
438: SELECT IGS_EN_STDNTPSHECSOP.end_dt
439: FROM IGS_EN_STDNTPSHECSOP
440: WHERE IGS_EN_STDNTPSHECSOP.person_id = cp_person_id AND
441: IGS_EN_STDNTPSHECSOP.course_cd = cp_course_cd AND
442: IGS_EN_STDNTPSHECSOP.start_dt <> cp_start_dt;

Line 439: FROM IGS_EN_STDNTPSHECSOP

435: cp_person_id IGS_EN_STDNTPSHECSOP.person_id%TYPE,
436: cp_course_cd IGS_EN_STDNTPSHECSOP.course_cd%TYPE,
437: cp_start_dt IGS_EN_STDNTPSHECSOP.start_dt%TYPE) IS
438: SELECT IGS_EN_STDNTPSHECSOP.end_dt
439: FROM IGS_EN_STDNTPSHECSOP
440: WHERE IGS_EN_STDNTPSHECSOP.person_id = cp_person_id AND
441: IGS_EN_STDNTPSHECSOP.course_cd = cp_course_cd AND
442: IGS_EN_STDNTPSHECSOP.start_dt <> cp_start_dt;
443: BEGIN

Line 440: WHERE IGS_EN_STDNTPSHECSOP.person_id = cp_person_id AND

436: cp_course_cd IGS_EN_STDNTPSHECSOP.course_cd%TYPE,
437: cp_start_dt IGS_EN_STDNTPSHECSOP.start_dt%TYPE) IS
438: SELECT IGS_EN_STDNTPSHECSOP.end_dt
439: FROM IGS_EN_STDNTPSHECSOP
440: WHERE IGS_EN_STDNTPSHECSOP.person_id = cp_person_id AND
441: IGS_EN_STDNTPSHECSOP.course_cd = cp_course_cd AND
442: IGS_EN_STDNTPSHECSOP.start_dt <> cp_start_dt;
443: BEGIN
444: -- this module validates that there are no other "open ended" scho

Line 441: IGS_EN_STDNTPSHECSOP.course_cd = cp_course_cd AND

437: cp_start_dt IGS_EN_STDNTPSHECSOP.start_dt%TYPE) IS
438: SELECT IGS_EN_STDNTPSHECSOP.end_dt
439: FROM IGS_EN_STDNTPSHECSOP
440: WHERE IGS_EN_STDNTPSHECSOP.person_id = cp_person_id AND
441: IGS_EN_STDNTPSHECSOP.course_cd = cp_course_cd AND
442: IGS_EN_STDNTPSHECSOP.start_dt <> cp_start_dt;
443: BEGIN
444: -- this module validates that there are no other "open ended" scho
445: -- records for the nominated student course attempt

Line 442: IGS_EN_STDNTPSHECSOP.start_dt <> cp_start_dt;

438: SELECT IGS_EN_STDNTPSHECSOP.end_dt
439: FROM IGS_EN_STDNTPSHECSOP
440: WHERE IGS_EN_STDNTPSHECSOP.person_id = cp_person_id AND
441: IGS_EN_STDNTPSHECSOP.course_cd = cp_course_cd AND
442: IGS_EN_STDNTPSHECSOP.start_dt <> cp_start_dt;
443: BEGIN
444: -- this module validates that there are no other "open ended" scho
445: -- records for the nominated student course attempt
446: p_message_name := null;

Line 480: FROM IGS_EN_STDNTPSHECSOP scho

476: v_exit_loop BOOLEAN DEFAULT FALSE;
477: CURSOR c_scho IS
478: SELECT scho.start_dt,
479: scho.end_dt
480: FROM IGS_EN_STDNTPSHECSOP scho
481: WHERE scho.person_id = p_person_id AND
482: scho.course_cd = p_course_cd AND
483: scho.start_dt <> p_start_dt;
484: BEGIN

Line 485: -- this module validates that the IGS_EN_STDNTPSHECSOP record

481: WHERE scho.person_id = p_person_id AND
482: scho.course_cd = p_course_cd AND
483: scho.start_dt <> p_start_dt;
484: BEGIN
485: -- this module validates that the IGS_EN_STDNTPSHECSOP record
486: -- being created or updated does not overlap with an existing record
487: -- for the nominated person
488: p_message_name := null;
489: FOR v_scho_rec IN c_scho LOOP

Line 648: v_scho_unique_rec IGS_EN_STDNTPSHECSOP%ROWTYPE;

644: RETURN BOOLEAN AS
645: BEGIN
646: DECLARE
647: v_other_detail VARCHAR2(255);
648: v_scho_unique_rec IGS_EN_STDNTPSHECSOP%ROWTYPE;
649: v_scho_same_rec IGS_EN_STDNTPSHECSOP%ROWTYPE;
650: v_count NUMBER;
651: v_count1 NUMBER;
652: v_cnt NUMBER;

Line 649: v_scho_same_rec IGS_EN_STDNTPSHECSOP%ROWTYPE;

645: BEGIN
646: DECLARE
647: v_other_detail VARCHAR2(255);
648: v_scho_unique_rec IGS_EN_STDNTPSHECSOP%ROWTYPE;
649: v_scho_same_rec IGS_EN_STDNTPSHECSOP%ROWTYPE;
650: v_count NUMBER;
651: v_count1 NUMBER;
652: v_cnt NUMBER;
653: v_tfn_digit NUMBER;

Line 658: FROM IGS_EN_STDNTPSHECSOP

654: v_algorithm_total NUMBER;
655: cst_factor CONSTANT NUMBER := 11;
656: CURSOR c_scho_unique_rec IS
657: SELECT *
658: FROM IGS_EN_STDNTPSHECSOP
659: WHERE person_id <> p_person_id AND
660: tax_file_number = p_tax_file_number;
661: CURSOR c_scho_same_rec IS
662: SELECT *

Line 663: FROM IGS_EN_STDNTPSHECSOP

659: WHERE person_id <> p_person_id AND
660: tax_file_number = p_tax_file_number;
661: CURSOR c_scho_same_rec IS
662: SELECT *
663: FROM IGS_EN_STDNTPSHECSOP
664: WHERE person_id = p_person_id AND
665: tax_file_number is NOT NULL AND
666: tax_file_number <> p_tax_file_number;
667: TYPE t_algorithm IS TABLE OF NUMBER NOT NULL

Line 985: -- the IGS_EN_STDNTPSHECSOP.start_dt is equal or greater

981: v_diff NUMBER;
982: BEGIN
983: -- This module validates whether a IGS_EN_STDNT_PS_HECS_OPTION_V
984: -- record may be updated. It may only be updated if
985: -- the IGS_EN_STDNTPSHECSOP.start_dt is equal or greater
986: -- than the current date.
987: v_diff := MONTHS_BETWEEN(SYSDATE, p_start_dt);
988: -- start_dt is less than the current date
989: IF (v_diff > 0) THEN

Line 1018: -- the IGS_EN_STDNTPSHECSOP.start_dt is equal or greater

1014: v_diff NUMBER;
1015: BEGIN
1016: -- This module validates whether a IGS_EN_STDNT_PS_HECS_OPTION_V
1017: -- record may be deleted. It may only be deleted if
1018: -- the IGS_EN_STDNTPSHECSOP.start_dt is equal or greater
1019: -- than the current date.
1020: v_diff := MONTHS_BETWEEN(SYSDATE, p_start_dt);
1021: -- start_dt is less than the current date
1022: IF (v_diff > 0) THEN

Line 3436: cp_hpo IGS_EN_STDNTPSHECSOP.hecs_payment_option%TYPE) IS

3432: v_end_dt IGS_CA_INST.end_dt%TYPE;
3433: v_cal_type IGS_CA_INST.cal_type%TYPE;
3434: v_sequence_number IGS_CA_INST.sequence_number%TYPE;
3435: CURSOR c_hpo(
3436: cp_hpo IGS_EN_STDNTPSHECSOP.hecs_payment_option%TYPE) IS
3437: SELECT expire_aftr_acdmc_perd_ind
3438: FROM IGS_FI_HECS_PAY_OPTN
3439: WHERE hecs_payment_option= cp_hpo;
3440: CURSOR c_cal_instance (

Line 3506: -- Validate the IGS_EN_STDNTPSHECSOP.tax_file_certificate_number.

3502: p_message_name OUT NOCOPY VARCHAR2)
3503: RETURN BOOLEAN AS
3504: BEGIN
3505: BEGIN
3506: -- Validate the IGS_EN_STDNTPSHECSOP.tax_file_certificate_number.
3507: -- Set the default message number
3508: p_message_name := null;
3509: -- Validate the input parameter
3510: IF (p_tax_file_certificate_number IS NULL) THEN

Line 3540: -- This module validates the IGS_EN_STDNTPSHECSOP.tax_file_invalid_dt.

3536: p_message_name OUT NOCOPY VARCHAR2)
3537: RETURN BOOLEAN AS
3538: BEGIN
3539: BEGIN
3540: -- This module validates the IGS_EN_STDNTPSHECSOP.tax_file_invalid_dt.
3541: -- Set the default message number
3542: p_message_name := null;
3543: -- Validate the input parameter
3544: IF (p_tax_file_invalid_dt IS NULL) THEN