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

Line 144: FUNCTION validate_award_cal_inst(p_c_awd_ci_cal_type igs_ca_inst.cal_type%TYPE,

140: END IF;
141: END validate_spnsr_cd;
142:
143:
144: FUNCTION validate_award_cal_inst(p_c_awd_ci_cal_type igs_ca_inst.cal_type%TYPE,
145: p_n_awd_ci_sequence_number igs_ca_inst.sequence_number%TYPE) RETURN BOOLEAN
146: AS
147: /****************************************************************************
148: Created By: Vinay Chappidi

Line 145: p_n_awd_ci_sequence_number igs_ca_inst.sequence_number%TYPE) RETURN BOOLEAN

141: END validate_spnsr_cd;
142:
143:
144: FUNCTION validate_award_cal_inst(p_c_awd_ci_cal_type igs_ca_inst.cal_type%TYPE,
145: p_n_awd_ci_sequence_number igs_ca_inst.sequence_number%TYPE) RETURN BOOLEAN
146: AS
147: /****************************************************************************
148: Created By: Vinay Chappidi
149: Date Created By: 19-Feb-2003

Line 157: CURSOR cur_check_ci_status(cp_c_cal_type igs_ca_inst.cal_type%TYPE,

153: Change History
154: Who When What
155: ******************************************************************************/
156:
157: CURSOR cur_check_ci_status(cp_c_cal_type igs_ca_inst.cal_type%TYPE,
158: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE,
159: cp_c_cal_status igs_ca_stat.cal_status%TYPE)
160: IS
161: SELECT 'x'

Line 158: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE,

154: Who When What
155: ******************************************************************************/
156:
157: CURSOR cur_check_ci_status(cp_c_cal_type igs_ca_inst.cal_type%TYPE,
158: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE,
159: cp_c_cal_status igs_ca_stat.cal_status%TYPE)
160: IS
161: SELECT 'x'
162: FROM igs_ca_inst i,

Line 162: FROM igs_ca_inst i,

158: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE,
159: cp_c_cal_status igs_ca_stat.cal_status%TYPE)
160: IS
161: SELECT 'x'
162: FROM igs_ca_inst i,
163: igs_ca_stat s,
164: igf_ap_batch_aw_map b
165: WHERE i.cal_status = s.cal_status AND
166: i.cal_type = b.ci_cal_type AND

Line 183: FUNCTION validate_load_cal_inst(p_c_ld_ci_cal_type igs_ca_inst.cal_type%TYPE,

179: RETURN TRUE;
180: END IF;
181: END validate_award_cal_inst;
182:
183: FUNCTION validate_load_cal_inst(p_c_ld_ci_cal_type igs_ca_inst.cal_type%TYPE,
184: p_n_ld_ci_sequence_number igs_ca_inst.sequence_number%TYPE) RETURN BOOLEAN
185: AS
186: /****************************************************************************
187: Created By: Vinay Chappidi

Line 184: p_n_ld_ci_sequence_number igs_ca_inst.sequence_number%TYPE) RETURN BOOLEAN

180: END IF;
181: END validate_award_cal_inst;
182:
183: FUNCTION validate_load_cal_inst(p_c_ld_ci_cal_type igs_ca_inst.cal_type%TYPE,
184: p_n_ld_ci_sequence_number igs_ca_inst.sequence_number%TYPE) RETURN BOOLEAN
185: AS
186: /****************************************************************************
187: Created By: Vinay Chappidi
188: Date Created By: 19-Feb-2003

Line 195: CURSOR cur_check_ci_status (cp_c_cal_type igs_ca_inst.cal_type%TYPE,

191:
192: Change History
193: Who When What
194: ******************************************************************************/
195: CURSOR cur_check_ci_status (cp_c_cal_type igs_ca_inst.cal_type%TYPE,
196: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE,
197: cp_c_cal_status igs_ca_stat.cal_status%TYPE,
198: cp_c_awd_cal_cat igs_ca_type.s_cal_cat%TYPE,
199: cp_c_ld_cal_cat igs_ca_type.s_cal_cat%TYPE)

Line 196: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE,

192: Change History
193: Who When What
194: ******************************************************************************/
195: CURSOR cur_check_ci_status (cp_c_cal_type igs_ca_inst.cal_type%TYPE,
196: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE,
197: cp_c_cal_status igs_ca_stat.cal_status%TYPE,
198: cp_c_awd_cal_cat igs_ca_type.s_cal_cat%TYPE,
199: cp_c_ld_cal_cat igs_ca_type.s_cal_cat%TYPE)
200: IS

Line 202: FROM igs_ca_inst aw,

198: cp_c_awd_cal_cat igs_ca_type.s_cal_cat%TYPE,
199: cp_c_ld_cal_cat igs_ca_type.s_cal_cat%TYPE)
200: IS
201: SELECT 'x'
202: FROM igs_ca_inst aw,
203: igs_ca_inst ld,
204: igs_ca_type ld_t,
205: igs_ca_type aw_t,
206: igs_ca_inst_rel rel,

Line 203: igs_ca_inst ld,

199: cp_c_ld_cal_cat igs_ca_type.s_cal_cat%TYPE)
200: IS
201: SELECT 'x'
202: FROM igs_ca_inst aw,
203: igs_ca_inst ld,
204: igs_ca_type ld_t,
205: igs_ca_type aw_t,
206: igs_ca_inst_rel rel,
207: igs_ca_stat status

Line 206: igs_ca_inst_rel rel,

202: FROM igs_ca_inst aw,
203: igs_ca_inst ld,
204: igs_ca_type ld_t,
205: igs_ca_type aw_t,
206: igs_ca_inst_rel rel,
207: igs_ca_stat status
208: WHERE rel.sup_cal_type=aw.cal_type AND
209: rel.sup_ci_sequence_number=aw.sequence_number AND
210: rel.sub_cal_type=ld.cal_type AND

Line 234: p_c_aw_cal_type IN igs_ca_inst.cal_type%TYPE,

230: END IF;
231: END validate_load_cal_inst;
232:
233: PROCEDURE check_spnsr_awd_rel(p_c_fund_code IN igf_aw_fund_mast.fund_code%TYPE,
234: p_c_aw_cal_type IN igs_ca_inst.cal_type%TYPE,
235: p_n_aw_sequence_number IN igs_ca_inst.sequence_number%TYPE,
236: p_c_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
237: p_n_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE,
238: p_b_return_status OUT NOCOPY BOOLEAN,

Line 235: p_n_aw_sequence_number IN igs_ca_inst.sequence_number%TYPE,

231: END validate_load_cal_inst;
232:
233: PROCEDURE check_spnsr_awd_rel(p_c_fund_code IN igf_aw_fund_mast.fund_code%TYPE,
234: p_c_aw_cal_type IN igs_ca_inst.cal_type%TYPE,
235: p_n_aw_sequence_number IN igs_ca_inst.sequence_number%TYPE,
236: p_c_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
237: p_n_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE,
238: p_b_return_status OUT NOCOPY BOOLEAN,
239: p_n_fund_id OUT NOCOPY igf_aw_fund_mast.fund_id%TYPE)

Line 236: p_c_ld_cal_type IN igs_ca_inst.cal_type%TYPE,

232:
233: PROCEDURE check_spnsr_awd_rel(p_c_fund_code IN igf_aw_fund_mast.fund_code%TYPE,
234: p_c_aw_cal_type IN igs_ca_inst.cal_type%TYPE,
235: p_n_aw_sequence_number IN igs_ca_inst.sequence_number%TYPE,
236: p_c_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
237: p_n_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE,
238: p_b_return_status OUT NOCOPY BOOLEAN,
239: p_n_fund_id OUT NOCOPY igf_aw_fund_mast.fund_id%TYPE)
240: AS

Line 237: p_n_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE,

233: PROCEDURE check_spnsr_awd_rel(p_c_fund_code IN igf_aw_fund_mast.fund_code%TYPE,
234: p_c_aw_cal_type IN igs_ca_inst.cal_type%TYPE,
235: p_n_aw_sequence_number IN igs_ca_inst.sequence_number%TYPE,
236: p_c_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
237: p_n_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE,
238: p_b_return_status OUT NOCOPY BOOLEAN,
239: p_n_fund_id OUT NOCOPY igf_aw_fund_mast.fund_id%TYPE)
240: AS
241: /****************************************************************************

Line 286: p_c_awd_ci_cal_type igs_ca_inst.cal_type%TYPE,

282: CLOSE c_check_spn_awd;
283: END check_spnsr_awd_rel;
284:
285: PROCEDURE check_create_fa_rec(p_n_person_id hz_parties.party_id%TYPE,
286: p_c_awd_ci_cal_type igs_ca_inst.cal_type%TYPE,
287: p_n_awd_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
288: p_b_ret_status OUT NOCOPY BOOLEAN,
289: p_n_base_id OUT NOCOPY NUMBER)
290: AS

Line 287: p_n_awd_ci_sequence_number igs_ca_inst.sequence_number%TYPE,

283: END check_spnsr_awd_rel;
284:
285: PROCEDURE check_create_fa_rec(p_n_person_id hz_parties.party_id%TYPE,
286: p_c_awd_ci_cal_type igs_ca_inst.cal_type%TYPE,
287: p_n_awd_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
288: p_b_ret_status OUT NOCOPY BOOLEAN,
289: p_n_base_id OUT NOCOPY NUMBER)
290: AS
291: /****************************************************************************

Line 332: p_c_ld_cal_type igs_ca_inst.cal_type%TYPE,

328: END check_create_fa_rec;
329:
330: FUNCTION check_spnsr_stdnt_rel(p_c_fund_id igf_aw_fund_mast.fund_id%TYPE,
331: p_n_base_id igf_ap_fa_base_rec.base_id%TYPE,
332: p_c_ld_cal_type igs_ca_inst.cal_type%TYPE,
333: p_n_ld_ci_sequence_number igs_ca_inst.sequence_number%TYPE) RETURN BOOLEAN
334: AS
335: /****************************************************************************
336: Created By: Vinay Chappidi

Line 333: p_n_ld_ci_sequence_number igs_ca_inst.sequence_number%TYPE) RETURN BOOLEAN

329:
330: FUNCTION check_spnsr_stdnt_rel(p_c_fund_id igf_aw_fund_mast.fund_id%TYPE,
331: p_n_base_id igf_ap_fa_base_rec.base_id%TYPE,
332: p_c_ld_cal_type igs_ca_inst.cal_type%TYPE,
333: p_n_ld_ci_sequence_number igs_ca_inst.sequence_number%TYPE) RETURN BOOLEAN
334: AS
335: /****************************************************************************
336: Created By: Vinay Chappidi
337: Date Created By: 19-Feb-2003