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 IGF_AW_FUND_MAST

Line 125: igf_aw_fund_mast m

121: cp_c_status igf_aw_fund_cat.active%TYPE)
122: IS
123: SELECT 'x'
124: FROM igf_aw_fund_cat c,
125: igf_aw_fund_mast m
126: WHERE c.fund_code = m.fund_code AND
127: c.fund_code = cp_c_fund_code AND
128: c.sys_fund_type = cp_c_sys_fund_type AND
129: c.active = cp_c_status;

Line 233: PROCEDURE check_spnsr_awd_rel(p_c_fund_code IN igf_aw_fund_mast.fund_code%TYPE,

229: RETURN TRUE;
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,

Line 239: p_n_fund_id OUT NOCOPY igf_aw_fund_mast.fund_id%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: /****************************************************************************
242: Created By: Vinay Chappidi
243: Date Created By: 19-Feb-2003

Line 251: CURSOR c_check_spn_awd(cp_c_fund_code igf_aw_fund_mast.fund_code%TYPE,

247:
248: Change History
249: Who When What
250: ******************************************************************************/
251: CURSOR c_check_spn_awd(cp_c_fund_code igf_aw_fund_mast.fund_code%TYPE,
252: cp_c_fund_status igf_aw_fund_mast.discontinue_fund%TYPE,
253: cp_c_aw_cal_type igf_aw_fund_mast.ci_cal_type%TYPE,
254: cp_n_aw_sequence_number igf_aw_fund_mast.ci_sequence_number%TYPE,
255: cp_c_ld_cal_type igf_aw_fund_tp.tp_cal_type%TYPE,

Line 252: cp_c_fund_status igf_aw_fund_mast.discontinue_fund%TYPE,

248: Change History
249: Who When What
250: ******************************************************************************/
251: CURSOR c_check_spn_awd(cp_c_fund_code igf_aw_fund_mast.fund_code%TYPE,
252: cp_c_fund_status igf_aw_fund_mast.discontinue_fund%TYPE,
253: cp_c_aw_cal_type igf_aw_fund_mast.ci_cal_type%TYPE,
254: cp_n_aw_sequence_number igf_aw_fund_mast.ci_sequence_number%TYPE,
255: cp_c_ld_cal_type igf_aw_fund_tp.tp_cal_type%TYPE,
256: cp_n_ld_sequence_number igf_aw_fund_tp.tp_sequence_number%TYPE)

Line 253: cp_c_aw_cal_type igf_aw_fund_mast.ci_cal_type%TYPE,

249: Who When What
250: ******************************************************************************/
251: CURSOR c_check_spn_awd(cp_c_fund_code igf_aw_fund_mast.fund_code%TYPE,
252: cp_c_fund_status igf_aw_fund_mast.discontinue_fund%TYPE,
253: cp_c_aw_cal_type igf_aw_fund_mast.ci_cal_type%TYPE,
254: cp_n_aw_sequence_number igf_aw_fund_mast.ci_sequence_number%TYPE,
255: cp_c_ld_cal_type igf_aw_fund_tp.tp_cal_type%TYPE,
256: cp_n_ld_sequence_number igf_aw_fund_tp.tp_sequence_number%TYPE)
257: IS

Line 254: cp_n_aw_sequence_number igf_aw_fund_mast.ci_sequence_number%TYPE,

250: ******************************************************************************/
251: CURSOR c_check_spn_awd(cp_c_fund_code igf_aw_fund_mast.fund_code%TYPE,
252: cp_c_fund_status igf_aw_fund_mast.discontinue_fund%TYPE,
253: cp_c_aw_cal_type igf_aw_fund_mast.ci_cal_type%TYPE,
254: cp_n_aw_sequence_number igf_aw_fund_mast.ci_sequence_number%TYPE,
255: cp_c_ld_cal_type igf_aw_fund_tp.tp_cal_type%TYPE,
256: cp_n_ld_sequence_number igf_aw_fund_tp.tp_sequence_number%TYPE)
257: IS
258: SELECT m.fund_id

Line 259: FROM igf_aw_fund_mast m,

255: cp_c_ld_cal_type igf_aw_fund_tp.tp_cal_type%TYPE,
256: cp_n_ld_sequence_number igf_aw_fund_tp.tp_sequence_number%TYPE)
257: IS
258: SELECT m.fund_id
259: FROM igf_aw_fund_mast m,
260: igf_aw_fund_tp t
261: WHERE m.fund_id = t.fund_id AND
262: m.fund_code = cp_c_fund_code AND
263: m.ci_cal_type = cp_c_aw_cal_type AND

Line 269: l_n_fund_id igf_aw_fund_mast.fund_id%TYPE;

265: m.discontinue_fund = cp_c_fund_status AND
266: t.tp_cal_type = cp_c_ld_cal_type AND
267: t.tp_sequence_number = cp_n_ld_sequence_number;
268:
269: l_n_fund_id igf_aw_fund_mast.fund_id%TYPE;
270: BEGIN
271: -- Check if the Award Calendar Insatnce, Load Calendar Instance and the Sponsor Details are setup in the system
272: -- Return False when there is no relation and TRUE when there exists a relation
273: OPEN c_check_spn_awd(p_c_fund_code,'N',p_c_aw_cal_type,p_n_aw_sequence_number,p_c_ld_cal_type,p_n_ld_sequence_number);

Line 330: FUNCTION check_spnsr_stdnt_rel(p_c_fund_id igf_aw_fund_mast.fund_id%TYPE,

326: p_b_ret_status := FALSE;
327: END IF;
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

Line 411: l_n_fund_id igf_aw_fund_mast.fund_id%TYPE;

407: l_api_name CONSTANT VARCHAR2(30) := 'Create_Stdnt_Spnsr_Rel';
408: l_api_version CONSTANT NUMBER := 1.0;
409:
410: l_n_person_id hz_parties.party_id%TYPE;
411: l_n_fund_id igf_aw_fund_mast.fund_id%TYPE;
412: l_c_sys_alt_prs_id_typ igs_pe_person_id_typ.s_person_id_type%TYPE;
413: l_n_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
414: l_n_spr_stdnt_id igf_sp_stdnt_rel.spnsr_stdnt_id%TYPE;
415: