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_AD_PS_APPL_INST_PKG dependencies on IGS_CA_TEACH_TO_LOAD_V

Line 4732: FROM igs_ca_teach_to_load_v ctl

4728:
4729: CURSOR c_get_load_start_date (p_sub_cal_type igs_ca_inst.cal_type%TYPE,
4730: p_sub_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS
4731: SELECT TRUNC(load_start_dt) load_start_dt, load_cal_type, load_ci_sequence_number
4732: FROM igs_ca_teach_to_load_v ctl
4733: WHERE ctl.teach_cal_type = p_sub_cal_type
4734: AND ctl.teach_ci_sequence_number = p_sub_ci_sequence_number;
4735:
4736: cv_get_load_start_date c_get_load_start_date%ROWTYPE;

Line 4756: l_load_init_start_date IGS_CA_TEACH_TO_LOAD_V.LOAD_START_DT%TYPE;

4752: -- Added in order to avoid the hit to the database every time the records are looped through
4753: l_most_recent_profile VARCHAR2(200) ;
4754: l_catalog_profile VARCHAR2(200) ;
4755:
4756: l_load_init_start_date IGS_CA_TEACH_TO_LOAD_V.LOAD_START_DT%TYPE;
4757: l_load_init_cal_type IGS_CA_TEACH_TO_LOAD_V.LOAD_CAL_TYPE%TYPE;
4758: l_load_init_ci_sequence_number IGS_CA_TEACH_TO_LOAD_V.LOAD_CI_SEQUENCE_NUMBER%TYPE;
4759: l_recent_start_date IGS_CA_TEACH_TO_LOAD_V.LOAD_START_DT%TYPE;
4760: l_recent_cal_type IGS_CA_TEACH_TO_LOAD_V.LOAD_CAL_TYPE%TYPE;

Line 4757: l_load_init_cal_type IGS_CA_TEACH_TO_LOAD_V.LOAD_CAL_TYPE%TYPE;

4753: l_most_recent_profile VARCHAR2(200) ;
4754: l_catalog_profile VARCHAR2(200) ;
4755:
4756: l_load_init_start_date IGS_CA_TEACH_TO_LOAD_V.LOAD_START_DT%TYPE;
4757: l_load_init_cal_type IGS_CA_TEACH_TO_LOAD_V.LOAD_CAL_TYPE%TYPE;
4758: l_load_init_ci_sequence_number IGS_CA_TEACH_TO_LOAD_V.LOAD_CI_SEQUENCE_NUMBER%TYPE;
4759: l_recent_start_date IGS_CA_TEACH_TO_LOAD_V.LOAD_START_DT%TYPE;
4760: l_recent_cal_type IGS_CA_TEACH_TO_LOAD_V.LOAD_CAL_TYPE%TYPE;
4761: l_recent_ci_sequence_number IGS_CA_TEACH_TO_LOAD_V.LOAD_CI_SEQUENCE_NUMBER%TYPE;

Line 4758: l_load_init_ci_sequence_number IGS_CA_TEACH_TO_LOAD_V.LOAD_CI_SEQUENCE_NUMBER%TYPE;

4754: l_catalog_profile VARCHAR2(200) ;
4755:
4756: l_load_init_start_date IGS_CA_TEACH_TO_LOAD_V.LOAD_START_DT%TYPE;
4757: l_load_init_cal_type IGS_CA_TEACH_TO_LOAD_V.LOAD_CAL_TYPE%TYPE;
4758: l_load_init_ci_sequence_number IGS_CA_TEACH_TO_LOAD_V.LOAD_CI_SEQUENCE_NUMBER%TYPE;
4759: l_recent_start_date IGS_CA_TEACH_TO_LOAD_V.LOAD_START_DT%TYPE;
4760: l_recent_cal_type IGS_CA_TEACH_TO_LOAD_V.LOAD_CAL_TYPE%TYPE;
4761: l_recent_ci_sequence_number IGS_CA_TEACH_TO_LOAD_V.LOAD_CI_SEQUENCE_NUMBER%TYPE;
4762:

Line 4759: l_recent_start_date IGS_CA_TEACH_TO_LOAD_V.LOAD_START_DT%TYPE;

4755:
4756: l_load_init_start_date IGS_CA_TEACH_TO_LOAD_V.LOAD_START_DT%TYPE;
4757: l_load_init_cal_type IGS_CA_TEACH_TO_LOAD_V.LOAD_CAL_TYPE%TYPE;
4758: l_load_init_ci_sequence_number IGS_CA_TEACH_TO_LOAD_V.LOAD_CI_SEQUENCE_NUMBER%TYPE;
4759: l_recent_start_date IGS_CA_TEACH_TO_LOAD_V.LOAD_START_DT%TYPE;
4760: l_recent_cal_type IGS_CA_TEACH_TO_LOAD_V.LOAD_CAL_TYPE%TYPE;
4761: l_recent_ci_sequence_number IGS_CA_TEACH_TO_LOAD_V.LOAD_CI_SEQUENCE_NUMBER%TYPE;
4762:
4763: v_party_last_update_date hz_person_profiles.last_update_date%TYPE;

Line 4760: l_recent_cal_type IGS_CA_TEACH_TO_LOAD_V.LOAD_CAL_TYPE%TYPE;

4756: l_load_init_start_date IGS_CA_TEACH_TO_LOAD_V.LOAD_START_DT%TYPE;
4757: l_load_init_cal_type IGS_CA_TEACH_TO_LOAD_V.LOAD_CAL_TYPE%TYPE;
4758: l_load_init_ci_sequence_number IGS_CA_TEACH_TO_LOAD_V.LOAD_CI_SEQUENCE_NUMBER%TYPE;
4759: l_recent_start_date IGS_CA_TEACH_TO_LOAD_V.LOAD_START_DT%TYPE;
4760: l_recent_cal_type IGS_CA_TEACH_TO_LOAD_V.LOAD_CAL_TYPE%TYPE;
4761: l_recent_ci_sequence_number IGS_CA_TEACH_TO_LOAD_V.LOAD_CI_SEQUENCE_NUMBER%TYPE;
4762:
4763: v_party_last_update_date hz_person_profiles.last_update_date%TYPE;
4764: lv_perosn_profile_id hz_person_profiles.person_profile_id%TYPE;

Line 4761: l_recent_ci_sequence_number IGS_CA_TEACH_TO_LOAD_V.LOAD_CI_SEQUENCE_NUMBER%TYPE;

4757: l_load_init_cal_type IGS_CA_TEACH_TO_LOAD_V.LOAD_CAL_TYPE%TYPE;
4758: l_load_init_ci_sequence_number IGS_CA_TEACH_TO_LOAD_V.LOAD_CI_SEQUENCE_NUMBER%TYPE;
4759: l_recent_start_date IGS_CA_TEACH_TO_LOAD_V.LOAD_START_DT%TYPE;
4760: l_recent_cal_type IGS_CA_TEACH_TO_LOAD_V.LOAD_CAL_TYPE%TYPE;
4761: l_recent_ci_sequence_number IGS_CA_TEACH_TO_LOAD_V.LOAD_CI_SEQUENCE_NUMBER%TYPE;
4762:
4763: v_party_last_update_date hz_person_profiles.last_update_date%TYPE;
4764: lv_perosn_profile_id hz_person_profiles.person_profile_id%TYPE;
4765: v_return_status VARCHAR2(5);