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

Line 726: l_load_cal_type IGS_CA_INST_ALL.CAL_TYPE%TYPE;

722: Change History:
723: Who When What
724:
725: */
726: l_load_cal_type IGS_CA_INST_ALL.CAL_TYPE%TYPE;
727: l_load_seq_number IGS_CA_INST_ALL.SEQUENCE_NUMBER%TYPE;
728: l_load_alt_code IGS_CA_INST_ALL.ALTERNATE_CODE%TYPE;
729: l_load_start_dt IGS_CA_INST_ALL.START_DT%TYPE;
730: l_load_end_dt IGS_CA_INST_ALL.END_DT%TYPE;

Line 727: l_load_seq_number IGS_CA_INST_ALL.SEQUENCE_NUMBER%TYPE;

723: Who When What
724:
725: */
726: l_load_cal_type IGS_CA_INST_ALL.CAL_TYPE%TYPE;
727: l_load_seq_number IGS_CA_INST_ALL.SEQUENCE_NUMBER%TYPE;
728: l_load_alt_code IGS_CA_INST_ALL.ALTERNATE_CODE%TYPE;
729: l_load_start_dt IGS_CA_INST_ALL.START_DT%TYPE;
730: l_load_end_dt IGS_CA_INST_ALL.END_DT%TYPE;
731: l_message_name VARCHAR2(30);

Line 728: l_load_alt_code IGS_CA_INST_ALL.ALTERNATE_CODE%TYPE;

724:
725: */
726: l_load_cal_type IGS_CA_INST_ALL.CAL_TYPE%TYPE;
727: l_load_seq_number IGS_CA_INST_ALL.SEQUENCE_NUMBER%TYPE;
728: l_load_alt_code IGS_CA_INST_ALL.ALTERNATE_CODE%TYPE;
729: l_load_start_dt IGS_CA_INST_ALL.START_DT%TYPE;
730: l_load_end_dt IGS_CA_INST_ALL.END_DT%TYPE;
731: l_message_name VARCHAR2(30);
732: l_load_cal_desc IGS_CA_INST_ALL.DESCRIPTION%TYPE;

Line 729: l_load_start_dt IGS_CA_INST_ALL.START_DT%TYPE;

725: */
726: l_load_cal_type IGS_CA_INST_ALL.CAL_TYPE%TYPE;
727: l_load_seq_number IGS_CA_INST_ALL.SEQUENCE_NUMBER%TYPE;
728: l_load_alt_code IGS_CA_INST_ALL.ALTERNATE_CODE%TYPE;
729: l_load_start_dt IGS_CA_INST_ALL.START_DT%TYPE;
730: l_load_end_dt IGS_CA_INST_ALL.END_DT%TYPE;
731: l_message_name VARCHAR2(30);
732: l_load_cal_desc IGS_CA_INST_ALL.DESCRIPTION%TYPE;
733:

Line 730: l_load_end_dt IGS_CA_INST_ALL.END_DT%TYPE;

726: l_load_cal_type IGS_CA_INST_ALL.CAL_TYPE%TYPE;
727: l_load_seq_number IGS_CA_INST_ALL.SEQUENCE_NUMBER%TYPE;
728: l_load_alt_code IGS_CA_INST_ALL.ALTERNATE_CODE%TYPE;
729: l_load_start_dt IGS_CA_INST_ALL.START_DT%TYPE;
730: l_load_end_dt IGS_CA_INST_ALL.END_DT%TYPE;
731: l_message_name VARCHAR2(30);
732: l_load_cal_desc IGS_CA_INST_ALL.DESCRIPTION%TYPE;
733:
734: CURSOR cur_cal_desc(cp_load_cal_typ igs_ca_inst.cal_type%TYPE,

Line 732: l_load_cal_desc IGS_CA_INST_ALL.DESCRIPTION%TYPE;

728: l_load_alt_code IGS_CA_INST_ALL.ALTERNATE_CODE%TYPE;
729: l_load_start_dt IGS_CA_INST_ALL.START_DT%TYPE;
730: l_load_end_dt IGS_CA_INST_ALL.END_DT%TYPE;
731: l_message_name VARCHAR2(30);
732: l_load_cal_desc IGS_CA_INST_ALL.DESCRIPTION%TYPE;
733:
734: CURSOR cur_cal_desc(cp_load_cal_typ igs_ca_inst.cal_type%TYPE,
735: cp_cal_seq_no igs_ca_inst.sequence_number%TYPE) IS
736: SELECT description

Line 734: CURSOR cur_cal_desc(cp_load_cal_typ igs_ca_inst.cal_type%TYPE,

730: l_load_end_dt IGS_CA_INST_ALL.END_DT%TYPE;
731: l_message_name VARCHAR2(30);
732: l_load_cal_desc IGS_CA_INST_ALL.DESCRIPTION%TYPE;
733:
734: CURSOR cur_cal_desc(cp_load_cal_typ igs_ca_inst.cal_type%TYPE,
735: cp_cal_seq_no igs_ca_inst.sequence_number%TYPE) IS
736: SELECT description
737: FROM igs_ca_inst_all
738: WHERE cal_type = cp_load_cal_typ

Line 735: cp_cal_seq_no igs_ca_inst.sequence_number%TYPE) IS

731: l_message_name VARCHAR2(30);
732: l_load_cal_desc IGS_CA_INST_ALL.DESCRIPTION%TYPE;
733:
734: CURSOR cur_cal_desc(cp_load_cal_typ igs_ca_inst.cal_type%TYPE,
735: cp_cal_seq_no igs_ca_inst.sequence_number%TYPE) IS
736: SELECT description
737: FROM igs_ca_inst_all
738: WHERE cal_type = cp_load_cal_typ
739: AND sequence_number = cp_cal_seq_no;

Line 737: FROM igs_ca_inst_all

733:
734: CURSOR cur_cal_desc(cp_load_cal_typ igs_ca_inst.cal_type%TYPE,
735: cp_cal_seq_no igs_ca_inst.sequence_number%TYPE) IS
736: SELECT description
737: FROM igs_ca_inst_all
738: WHERE cal_type = cp_load_cal_typ
739: AND sequence_number = cp_cal_seq_no;
740:
741: BEGIN