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_CO_PROCESS dependencies on IGS_AD_MISSING_ITEMS_LETTER_V

Line 1790: p_view_name := ' igs_ad_missing_items_letter_v';

1786: BEGIN
1787: IF p_sys_ltr_code IN ('ADADHOC','FAADHOC','GENERIC','ENADHOC','SFADHOC') THEN
1788: p_view_name := ' hz_parties';
1789: ELSIF p_sys_ltr_code = 'ADMISTM' THEN
1790: p_view_name := ' igs_ad_missing_items_letter_v';
1791: p_where_clause := ' s_adm_outcome_status <> ''CANCELLED''';
1792: ELSIF p_sys_ltr_code = 'ADACKMT' THEN
1793: p_view_name := ' igs_ad_ack_letter_v';
1794: p_where_clause := ' s_adm_outcome_status <> ''CANCELLED''';

Line 1883: l_pers_group_id igs_ad_missing_items_letter_v.pers_group_id%TYPE;

1879: Modified for Bind Variable
1880: (reverse chronological order - newest change first)
1881: ***************************************************************/
1882:
1883: l_pers_group_id igs_ad_missing_items_letter_v.pers_group_id%TYPE;
1884: l_acad_cal_type VARCHAR(15); --igs_ad_missing_items_letter_v.acad_cal_type%TYPE;
1885: l_acad_ci_sequence_number igs_ad_missing_items_letter_v.acad_ci_sequence_number%TYPE;
1886: l_adm_cal_type VARCHAR(15); --igs_ad_ps_appl_inst.adm_cal_type%TYPE;
1887: l_adm_ci_sequence_number igs_ad_ps_appl_inst.adm_ci_sequence_number%TYPE;

Line 1884: l_acad_cal_type VARCHAR(15); --igs_ad_missing_items_letter_v.acad_cal_type%TYPE;

1880: (reverse chronological order - newest change first)
1881: ***************************************************************/
1882:
1883: l_pers_group_id igs_ad_missing_items_letter_v.pers_group_id%TYPE;
1884: l_acad_cal_type VARCHAR(15); --igs_ad_missing_items_letter_v.acad_cal_type%TYPE;
1885: l_acad_ci_sequence_number igs_ad_missing_items_letter_v.acad_ci_sequence_number%TYPE;
1886: l_adm_cal_type VARCHAR(15); --igs_ad_ps_appl_inst.adm_cal_type%TYPE;
1887: l_adm_ci_sequence_number igs_ad_ps_appl_inst.adm_ci_sequence_number%TYPE;
1888: l_parameter_7 hz_parties.party_id%TYPE;

Line 1885: l_acad_ci_sequence_number igs_ad_missing_items_letter_v.acad_ci_sequence_number%TYPE;

1881: ***************************************************************/
1882:
1883: l_pers_group_id igs_ad_missing_items_letter_v.pers_group_id%TYPE;
1884: l_acad_cal_type VARCHAR(15); --igs_ad_missing_items_letter_v.acad_cal_type%TYPE;
1885: l_acad_ci_sequence_number igs_ad_missing_items_letter_v.acad_ci_sequence_number%TYPE;
1886: l_adm_cal_type VARCHAR(15); --igs_ad_ps_appl_inst.adm_cal_type%TYPE;
1887: l_adm_ci_sequence_number igs_ad_ps_appl_inst.adm_ci_sequence_number%TYPE;
1888: l_parameter_7 hz_parties.party_id%TYPE;
1889: l_parameter_8 igs_co_interac_hist.adm_application_number%TYPE;