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_GE_VAL_PARAM dependencies on IGS_CA_INST

Line 584: p_ass_cal_type IN IGS_CA_INST_ALL.CAL_TYPE%TYPE,

580: -- Person Date Comments
581: -- --------- -------- ------------------------------------------
582: -- MSONTER 28/08/98 Initial creation of function
583: FUNCTION repp_val_unit_cal( p_unit_cd IN IGS_PS_UNIT_VER_ALL.unit_cd%TYPE,
584: p_ass_cal_type IN IGS_CA_INST_ALL.CAL_TYPE%TYPE,
585: p_ass_seq_num IN IGS_CA_INST_ALL.sequence_number%TYPE,
586: p_teach_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE,
587: p_teach_seq_num IN IGS_CA_INST_ALL.sequence_number%TYPE,
588: p_msg_name OUT NOCOPY VARCHAR2)

Line 585: p_ass_seq_num IN IGS_CA_INST_ALL.sequence_number%TYPE,

581: -- --------- -------- ------------------------------------------
582: -- MSONTER 28/08/98 Initial creation of function
583: FUNCTION repp_val_unit_cal( p_unit_cd IN IGS_PS_UNIT_VER_ALL.unit_cd%TYPE,
584: p_ass_cal_type IN IGS_CA_INST_ALL.CAL_TYPE%TYPE,
585: p_ass_seq_num IN IGS_CA_INST_ALL.sequence_number%TYPE,
586: p_teach_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE,
587: p_teach_seq_num IN IGS_CA_INST_ALL.sequence_number%TYPE,
588: p_msg_name OUT NOCOPY VARCHAR2)
589: RETURN BOOLEAN

Line 586: p_teach_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE,

582: -- MSONTER 28/08/98 Initial creation of function
583: FUNCTION repp_val_unit_cal( p_unit_cd IN IGS_PS_UNIT_VER_ALL.unit_cd%TYPE,
584: p_ass_cal_type IN IGS_CA_INST_ALL.CAL_TYPE%TYPE,
585: p_ass_seq_num IN IGS_CA_INST_ALL.sequence_number%TYPE,
586: p_teach_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE,
587: p_teach_seq_num IN IGS_CA_INST_ALL.sequence_number%TYPE,
588: p_msg_name OUT NOCOPY VARCHAR2)
589: RETURN BOOLEAN
590: AS

Line 587: p_teach_seq_num IN IGS_CA_INST_ALL.sequence_number%TYPE,

583: FUNCTION repp_val_unit_cal( p_unit_cd IN IGS_PS_UNIT_VER_ALL.unit_cd%TYPE,
584: p_ass_cal_type IN IGS_CA_INST_ALL.CAL_TYPE%TYPE,
585: p_ass_seq_num IN IGS_CA_INST_ALL.sequence_number%TYPE,
586: p_teach_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE,
587: p_teach_seq_num IN IGS_CA_INST_ALL.sequence_number%TYPE,
588: p_msg_name OUT NOCOPY VARCHAR2)
589: RETURN BOOLEAN
590: AS
591: --

Line 807: IGS_CA_INST ci,

803: IGS_GE_DATE.igschar(ci.end_dt) || ' ' || ct.abbreviation, 100) ||
804: RPAD(ci.cal_type, 10) ||
805: TO_CHAR(ci.sequence_number, '999990') cal_desc
806: FROM IGS_CA_TYPE ct,
807: IGS_CA_INST ci,
808: IGS_CA_STAT cs
809: WHERE ct.s_cal_cat = cp_s_cal_cat AND
810: ci.cal_type = ct.cal_type AND
811: cs.cal_status = ci.cal_status AND

Line 851: p_seq_num IN IGS_CA_INST_ALL.sequence_number%TYPE,

847: -- Person Date Comments
848: -- --------- -------- ------------------------------------------
849: -- MSONTER 27/08/98 Initial creation of function
850: FUNCTION repp_get_nomin_cal( p_cal_type IN IGS_CA_TYPE.cal_type%TYPE,
851: p_seq_num IN IGS_CA_INST_ALL.sequence_number%TYPE,
852: p_cal OUT NOCOPY VARCHAR2)
853: RETURN BOOLEAN
854: AS
855: --

Line 858: cp_seq_num IN IGS_CA_INST.sequence_number%TYPE)

854: AS
855: --
856: -- Local Cursors
857: CURSOR c_cal(cp_cal_type IN IGS_CA_TYPE.cal_type%TYPE,
858: cp_seq_num IN IGS_CA_INST.sequence_number%TYPE)
859: IS
860: SELECT RPAD(RPAD(NVL(ci.alternate_code, ci.cal_type), 10) || ' ' ||
861: IGS_GE_DATE.igschar(ci.start_dt) || ' - ' ||
862: IGS_GE_DATE.igschar(ci.end_dt) || ' ' || ct.abbreviation, 100) ||

Line 866: IGS_CA_INST ci

862: IGS_GE_DATE.igschar(ci.end_dt) || ' ' || ct.abbreviation, 100) ||
863: RPAD(ci.cal_type, 10) ||
864: TO_CHAR(ci.sequence_number, '999990') cal_desc
865: FROM IGS_CA_TYPE ct,
866: IGS_CA_INST ci
867: WHERE ct.cal_type = cp_cal_type AND
868: ci.cal_type = ct.cal_type AND
869: ci.sequence_number = cp_seq_num;
870: --

Line 894: p_seq_num IN IGS_CA_INST_ALL.sequence_number%TYPE)

890: -- Person Date Comments
891: -- --------- -------- ------------------------------------------
892: -- MSONTER 27/08/98 Initial creation of function
893: FUNCTION repp_get_cal_str( p_cal_type IN IGS_CA_TYPE.cal_type%TYPE,
894: p_seq_num IN IGS_CA_INST_ALL.sequence_number%TYPE)
895: RETURN VARCHAR2
896: AS
897: --
898: -- Local Cursors

Line 900: cp_seq_num IN IGS_CA_INST.sequence_number%TYPE)

896: AS
897: --
898: -- Local Cursors
899: CURSOR c_cal(cp_cal_type IN IGS_CA_TYPE.cal_type%TYPE,
900: cp_seq_num IN IGS_CA_INST.sequence_number%TYPE)
901: IS
902: SELECT RPAD(RPAD(NVL(ci.alternate_code, ci.cal_type), 10) || ' ' ||
903: IGS_GE_DATE.igschar(ci.start_dt) || ' - ' ||
904: IGS_GE_DATE.igschar(ci.end_dt) || ' ' || ct.abbreviation, 100) ||

Line 908: IGS_CA_INST ci

904: IGS_GE_DATE.igschar(ci.end_dt) || ' ' || ct.abbreviation, 100) ||
905: RPAD(ci.cal_type, 10) ||
906: TO_CHAR(ci.sequence_number, '999990') cal_desc
907: FROM IGS_CA_TYPE ct,
908: IGS_CA_INST ci
909: WHERE ct.cal_type = cp_cal_type AND
910: ci.cal_type = ct.cal_type AND
911: ci.sequence_number = cp_seq_num;
912: --