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

Line 16: p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,

12:
13: FUNCTION chk_awd_exp_date (
14: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
15: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
16: p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
17: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
18: p_run_mode IN igf_lookups_view.lookup_code%TYPE
19: )
20: RETURN BOOLEAN

Line 17: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

13: FUNCTION chk_awd_exp_date (
14: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
15: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
16: p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
17: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
18: p_run_mode IN igf_lookups_view.lookup_code%TYPE
19: )
20: RETURN BOOLEAN
21: IS

Line 117: p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,

113: END chk_awd_exp_date;
114:
115: PROCEDURE get_base_id_per_num (
116: p_person_id IN hz_parties.party_id%TYPE,
117: p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
118: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
119: p_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE,
120: p_per_num OUT NOCOPY igs_pe_person_base_v.person_number%TYPE
121: )

Line 118: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

114:
115: PROCEDURE get_base_id_per_num (
116: p_person_id IN hz_parties.party_id%TYPE,
117: p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
118: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
119: p_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE,
120: p_per_num OUT NOCOPY igs_pe_person_base_v.person_number%TYPE
121: )
122: IS

Line 140: CURSOR cur_get_base (cp_cal_type igs_ca_inst_all.cal_type%TYPE,

136: SELECT person_number
137: FROM igs_pe_person_base_v
138: WHERE person_id = cp_person_id;
139:
140: CURSOR cur_get_base (cp_cal_type igs_ca_inst_all.cal_type%TYPE,
141: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE,
142: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE)
143: IS
144: SELECT base_id

Line 141: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE,

137: FROM igs_pe_person_base_v
138: WHERE person_id = cp_person_id;
139:
140: CURSOR cur_get_base (cp_cal_type igs_ca_inst_all.cal_type%TYPE,
141: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE,
142: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE)
143: IS
144: SELECT base_id
145: FROM igf_ap_fa_base_rec_all

Line 163: p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,

159: CLOSE cur_get_base;
160: END get_base_id_per_num;
161:
162: PROCEDURE cancel_award_fabase (
163: p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
164: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
165: p_fund_id IN igf_aw_award_all.fund_id%TYPE,
166: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
167: p_run_mode IN igf_lookups_view.lookup_code%TYPE

Line 164: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

160: END get_base_id_per_num;
161:
162: PROCEDURE cancel_award_fabase (
163: p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
164: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
165: p_fund_id IN igf_aw_award_all.fund_id%TYPE,
166: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
167: p_run_mode IN igf_lookups_view.lookup_code%TYPE
168: )

Line 181: CURSOR c_award (cp_ci_cal_type igs_ca_inst_all.cal_type%TYPE,

177: ||
178: || (reverse chronological order - newest change first)
179: */
180:
181: CURSOR c_award (cp_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
182: cp_ci_seq_num igs_ca_inst_all.sequence_number%TYPE,
183: cp_fund_id igf_aw_fund_mast.fund_id%TYPE,
184: cp_base_id igf_ap_fa_con_v.base_id%TYPE)
185: IS

Line 182: cp_ci_seq_num igs_ca_inst_all.sequence_number%TYPE,

178: || (reverse chronological order - newest change first)
179: */
180:
181: CURSOR c_award (cp_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
182: cp_ci_seq_num igs_ca_inst_all.sequence_number%TYPE,
183: cp_fund_id igf_aw_fund_mast.fund_id%TYPE,
184: cp_base_id igf_ap_fa_con_v.base_id%TYPE)
185: IS
186: SELECT

Line 467: CURSOR cur_alt_code(p_cal_type igs_ca_inst.cal_type%TYPE,p_sequence_number igs_ca_inst.sequence_number%TYPE)

463: WHERE lookup_type='IGF_GE_PARAMETERS'
464: AND lookup_code IN ('AWARD_ID', 'FUND_CODE', 'PARAMETER_PASS', 'PERSON_NUMBER', 'RUN_MODE', 'PERSON_ID_GROUP');
465:
466: --Cursor to fetch the alternate code for award year instance
467: CURSOR cur_alt_code(p_cal_type igs_ca_inst.cal_type%TYPE,p_sequence_number igs_ca_inst.sequence_number%TYPE)
468: IS
469: SELECT alternate_code FROM igs_ca_inst
470: WHERE cal_type =p_cal_type
471: AND sequence_number = p_sequence_number;

Line 469: SELECT alternate_code FROM igs_ca_inst

465:
466: --Cursor to fetch the alternate code for award year instance
467: CURSOR cur_alt_code(p_cal_type igs_ca_inst.cal_type%TYPE,p_sequence_number igs_ca_inst.sequence_number%TYPE)
468: IS
469: SELECT alternate_code FROM igs_ca_inst
470: WHERE cal_type =p_cal_type
471: AND sequence_number = p_sequence_number;
472:
473: --Cursor to get the person number for the base id

Line 489: l_alt_code igs_ca_inst.alternate_code%TYPE;

485:
486: --For display of heading and parameters passed
487: TYPE l_parameters IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
488: l_para_rec l_parameters;
489: l_alt_code igs_ca_inst.alternate_code%TYPE;
490: l_i NUMBER(2);
491: l_fund_code igf_aw_fund_mast.fund_code%TYPE;
492: l_person_no igf_aw_award_v.person_number%TYPE;
493: -----------------------------------------------------------------------------------------------------------