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.IGF_AP_LI_ISIR_IMP_PROC dependencies on IGS_CA_INST

Line 1680: p_alternate_code IN igs_ca_inst.alternate_code%TYPE,

1676: END p_l_to_i_col;
1677:
1678:
1679: PROCEDURE log_input_params( p_batch_num IN igf_aw_li_coa_ints.batch_num%TYPE,
1680: p_alternate_code IN igs_ca_inst.alternate_code%TYPE,
1681: p_delete_flag IN VARCHAR2,
1682: p_import_type IN VARCHAR2) IS
1683: /*
1684: || Created By : masehgal

Line 5879: CURSOR c_award_det(p_ci_cal_type igs_ca_inst.cal_type%TYPE,

5875: bkkumar 05-Aug-2003 Bug# 3025723 Added code to prefix the transaction_num_txt
5876: with '0' if it is of length one.
5877:
5878: ***************************************************************/
5879: CURSOR c_award_det(p_ci_cal_type igs_ca_inst.cal_type%TYPE,
5880: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE
5881: ) IS
5882: SELECT
5883: BATCH_YEAR batch_year,

Line 5880: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE

5876: with '0' if it is of length one.
5877:
5878: ***************************************************************/
5879: CURSOR c_award_det(p_ci_cal_type igs_ca_inst.cal_type%TYPE,
5880: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE
5881: ) IS
5882: SELECT
5883: BATCH_YEAR batch_year,
5884: AWARD_YEAR_STATUS_CODE,

Line 5952: CURSOR c_alternate_code( cp_ci_cal_type igs_ca_inst.cal_type%TYPE,

5948: AND base_id=p_base_id
5949: AND system_record_type='ORIGINAL';
5950:
5951: -- cursor to get alternate code for award year
5952: CURSOR c_alternate_code( cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
5953: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE ) IS
5954: SELECT alternate_code
5955: FROM igs_ca_inst
5956: WHERE cal_type = cp_ci_cal_type

Line 5953: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE ) IS

5949: AND system_record_type='ORIGINAL';
5950:
5951: -- cursor to get alternate code for award year
5952: CURSOR c_alternate_code( cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
5953: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE ) IS
5954: SELECT alternate_code
5955: FROM igs_ca_inst
5956: WHERE cal_type = cp_ci_cal_type
5957: AND sequence_number = cp_ci_sequence_number ;

Line 5955: FROM igs_ca_inst

5951: -- cursor to get alternate code for award year
5952: CURSOR c_alternate_code( cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
5953: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE ) IS
5954: SELECT alternate_code
5955: FROM igs_ca_inst
5956: WHERE cal_type = cp_ci_cal_type
5957: AND sequence_number = cp_ci_sequence_number ;
5958:
5959: l_alternate_code igs_ca_inst.alternate_code%TYPE ;

Line 5959: l_alternate_code igs_ca_inst.alternate_code%TYPE ;

5955: FROM igs_ca_inst
5956: WHERE cal_type = cp_ci_cal_type
5957: AND sequence_number = cp_ci_sequence_number ;
5958:
5959: l_alternate_code igs_ca_inst.alternate_code%TYPE ;
5960:
5961:
5962: -- cursor to get sys award year and award year status
5963: CURSOR c_get_stat( p_ci_cal_type VARCHAR2,p_ci_sequence_number NUMBER)IS