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.

[Home] [Help]

APPS.IGF_SP_ASSIGN_PUB dependencies on IGF_SP_STDNT_REL

Line 13: in the igf_sp_stdnt_rel_pkg.insert_row call in create_stdnt_spnsr_rel procedure.

9:
10: Change History
11: Who When What
12: svuppala 12-May-2006 Bug 5217319 Added call to format amount by rounding off to currency precision
13: in the igf_sp_stdnt_rel_pkg.insert_row call in create_stdnt_spnsr_rel procedure.
14: vvutukur 20-Jul-2003 Enh#3038511.FICR106 Build. Modified procedure create_stdnt_spnsr_rel.
15: pathipat 24-Apr-2003 Enh 2831569 - Commercial Receivables build
16: Modified create_stdnt_spnsr_rel() - added call to chk_manage_account()
17: ******************************************************************************/

Line 344: CURSOR c_check_stdnt_spnsr_rel(cp_n_fund_id igf_sp_stdnt_rel.fund_id%TYPE,

340:
341: Change History
342: Who When What
343: ******************************************************************************/
344: CURSOR c_check_stdnt_spnsr_rel(cp_n_fund_id igf_sp_stdnt_rel.fund_id%TYPE,
345: cp_n_base_id igf_sp_stdnt_rel.base_id%TYPE,
346: cp_c_ld_cal_type igf_sp_stdnt_rel.ld_cal_type%TYPE,
347: cp_n_ld_seq_number igf_sp_stdnt_rel.ld_sequence_number%TYPE)
348: IS

Line 345: cp_n_base_id igf_sp_stdnt_rel.base_id%TYPE,

341: Change History
342: Who When What
343: ******************************************************************************/
344: CURSOR c_check_stdnt_spnsr_rel(cp_n_fund_id igf_sp_stdnt_rel.fund_id%TYPE,
345: cp_n_base_id igf_sp_stdnt_rel.base_id%TYPE,
346: cp_c_ld_cal_type igf_sp_stdnt_rel.ld_cal_type%TYPE,
347: cp_n_ld_seq_number igf_sp_stdnt_rel.ld_sequence_number%TYPE)
348: IS
349: SELECT 'x'

Line 346: cp_c_ld_cal_type igf_sp_stdnt_rel.ld_cal_type%TYPE,

342: Who When What
343: ******************************************************************************/
344: CURSOR c_check_stdnt_spnsr_rel(cp_n_fund_id igf_sp_stdnt_rel.fund_id%TYPE,
345: cp_n_base_id igf_sp_stdnt_rel.base_id%TYPE,
346: cp_c_ld_cal_type igf_sp_stdnt_rel.ld_cal_type%TYPE,
347: cp_n_ld_seq_number igf_sp_stdnt_rel.ld_sequence_number%TYPE)
348: IS
349: SELECT 'x'
350: FROM igf_sp_stdnt_rel

Line 347: cp_n_ld_seq_number igf_sp_stdnt_rel.ld_sequence_number%TYPE)

343: ******************************************************************************/
344: CURSOR c_check_stdnt_spnsr_rel(cp_n_fund_id igf_sp_stdnt_rel.fund_id%TYPE,
345: cp_n_base_id igf_sp_stdnt_rel.base_id%TYPE,
346: cp_c_ld_cal_type igf_sp_stdnt_rel.ld_cal_type%TYPE,
347: cp_n_ld_seq_number igf_sp_stdnt_rel.ld_sequence_number%TYPE)
348: IS
349: SELECT 'x'
350: FROM igf_sp_stdnt_rel
351: WHERE fund_id = cp_n_fund_id AND

Line 350: FROM igf_sp_stdnt_rel

346: cp_c_ld_cal_type igf_sp_stdnt_rel.ld_cal_type%TYPE,
347: cp_n_ld_seq_number igf_sp_stdnt_rel.ld_sequence_number%TYPE)
348: IS
349: SELECT 'x'
350: FROM igf_sp_stdnt_rel
351: WHERE fund_id = cp_n_fund_id AND
352: base_id = cp_n_base_id AND
353: ld_cal_type = cp_c_ld_cal_type AND
354: ld_sequence_number = cp_n_ld_seq_number;

Line 396: in the igf_sp_stdnt_rel_pkg.insert_row call

392: Change History
393:
394: Who When What
395: svuppala 12-May-2006 Bug 5217319 Added call to format amount by rounding off to currency precision
396: in the igf_sp_stdnt_rel_pkg.insert_row call
397: vvutukur 20-Jul-2003 Enh#3038511.FICR106 Build. Added call to generic procedure
398: igs_fi_crdapi_util.get_award_year_status to validate Award Year Status.
399: pathipat 24-Apr-2003 Enh 2831569 - Commercial Receivables build
400: Added check for manage_accounts - call to chk_manage_account()

Line 414: l_n_spr_stdnt_id igf_sp_stdnt_rel.spnsr_stdnt_id%TYPE;

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:
416: l_c_manage_acc igs_fi_control_all.manage_accounts%TYPE := NULL;
417: l_c_message_name fnd_new_messages.message_name%TYPE := NULL;
418:

Line 673: igf_sp_stdnt_rel_pkg.insert_row (x_rowid => l_rowid,

669: END IF;
670: ELSE
671: -- If there is no relation then a new Sponsor-Student relation should be created.
672: -- Bug 5217319 Added call to format amount by rounding off to currency precision
673: igf_sp_stdnt_rel_pkg.insert_row (x_rowid => l_rowid,
674: x_spnsr_stdnt_id=> l_n_spr_stdnt_id,
675: x_fund_id => l_n_fund_id ,
676: x_base_id=> l_n_base_id,
677: x_person_id=> NVL(p_person_id, l_n_person_id),