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_AWARD dependencies on IGF_AW_FUND_MAST

Line 136: CURSOR cur_include_as_plncrd(cp_fund_id igf_aw_fund_mast.fund_id%TYPE)

132: Change History :
133: Who When What
134: (reverse chronological order - newest change first)
135: ----------------------------------------------------------------------------*/
136: CURSOR cur_include_as_plncrd(cp_fund_id igf_aw_fund_mast.fund_id%TYPE)
137: IS
138: SELECT show_on_bill
139: FROM igf_aw_fund_mast
140: WHERE fund_id = cp_fund_id;

Line 139: FROM igf_aw_fund_mast

135: ----------------------------------------------------------------------------*/
136: CURSOR cur_include_as_plncrd(cp_fund_id igf_aw_fund_mast.fund_id%TYPE)
137: IS
138: SELECT show_on_bill
139: FROM igf_aw_fund_mast
140: WHERE fund_id = cp_fund_id;
141: l_v_show_on_bill igf_aw_fund_mast.show_on_bill%TYPE;
142: BEGIN
143: OPEN cur_include_as_plncrd(p_n_fund_id);

Line 141: l_v_show_on_bill igf_aw_fund_mast.show_on_bill%TYPE;

137: IS
138: SELECT show_on_bill
139: FROM igf_aw_fund_mast
140: WHERE fund_id = cp_fund_id;
141: l_v_show_on_bill igf_aw_fund_mast.show_on_bill%TYPE;
142: BEGIN
143: OPEN cur_include_as_plncrd(p_n_fund_id);
144: FETCH cur_include_as_plncrd INTO l_v_show_on_bill ;
145: CLOSE cur_include_as_plncrd;

Line 484: igf_aw_fund_mast_all fmast

480: CURSOR c_stdnt_rel (cp_spnsr_stdnt_id igf_sp_stdnt_rel.spnsr_stdnt_id%TYPE)
481: IS
482: SELECT spstd.*, fmast.fund_code
483: FROM igf_sp_stdnt_rel_all spstd,
484: igf_aw_fund_mast_all fmast
485: WHERE spstd.spnsr_stdnt_id = cp_spnsr_stdnt_id
486: AND fmast.fund_id = spstd.fund_id;
487: rec_stdnt_rel c_stdnt_rel%ROWTYPE;
488:

Line 964: p_fee_type igf_aw_fund_mast.fee_type%TYPE,

960: PROCEDURE create_aw_award (p_fund_id igf_sp_stdnt_rel.fund_id%TYPE,
961: p_base_id igf_sp_stdnt_rel.base_id%TYPE,
962: p_ld_cal_type igf_sp_stdnt_rel.ld_cal_type%TYPE,
963: p_ld_sequence_number igf_sp_stdnt_rel.ld_sequence_number%TYPE,
964: p_fee_type igf_aw_fund_mast.fee_type%TYPE,
965: p_spnsr_stdnt_id igf_sp_stdnt_rel.spnsr_stdnt_id%TYPE,
966: p_award_type igf_aw_awd_disb.trans_type%TYPE,
967: p_person_id igs_pe_person.person_id%TYPE,
968: p_chk_elig VARCHAR2)

Line 1015: l_include_as_plncrd igf_aw_fund_mast.show_on_bill%TYPE;

1011: SELECT *
1012: FROM igf_sp_std_fc
1013: WHERE spnsr_stdnt_id = cp_spnsr_stdnt_id;
1014:
1015: l_include_as_plncrd igf_aw_fund_mast.show_on_bill%TYPE;
1016:
1017: l_disb_gross_amt igf_aw_awd_disb.disb_gross_amt%TYPE;
1018: l_chk_elig VARCHAR2(1);
1019: l_award_id igf_aw_award.award_id%TYPE;

Line 1334: p_fee_type igf_aw_fund_mast.fee_type%TYPE,

1330: p_min_credit_points igf_sp_stdnt_rel.min_credit_points%TYPE,
1331: p_ld_cal_type igf_sp_stdnt_rel.ld_cal_type%TYPE,
1332: p_ld_sequence_number igf_sp_stdnt_rel.ld_sequence_number%TYPE,
1333: p_spnsr_stdnt_id igf_sp_stdnt_rel.spnsr_stdnt_id%TYPE,
1334: p_fee_type igf_aw_fund_mast.fee_type%TYPE,
1335: p_n_total_spnsr_amt igf_sp_stdnt_rel.tot_spnsr_amount%TYPE
1336: )
1337: AS
1338: ------------------------------------------------------------------------------------

Line 1420: l_include_as_plncrd igf_aw_fund_mast.show_on_bill%TYPE;

1416: WHERE spnsr_stdnt_id = cp_spnsr_stdnt_id;
1417: rec_c_igf_sp_std_fc c_igf_sp_std_fc%ROWTYPE;
1418: l_n_before_awd_amt igf_aw_award.accepted_amt%TYPE :=0;
1419:
1420: l_include_as_plncrd igf_aw_fund_mast.show_on_bill%TYPE;
1421: l_v_award_type igf_aw_awd_disb.trans_type%TYPE;
1422: l_n_disb_num igf_aw_awd_disb.disb_num%TYPE;
1423:
1424: l_v_upd_msg_text fnd_new_messages.message_text%TYPE;

Line 2010: p_fund_id IN igf_aw_fund_mast.fund_id%TYPE,

2006: PROCEDURE loop_thru_spnsr_dtl (p_person_id IN igs_pe_person.person_id%TYPE,
2007: p_cal_type IN igs_ca_inst.cal_type%TYPE,
2008: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
2009: p_award_type IN VARCHAR2,
2010: p_fund_id IN igf_aw_fund_mast.fund_id%TYPE,
2011: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
2012: p_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE)
2013: AS
2014: ------------------------------------------------------------------------------------

Line 2041: cp_fund_id igf_aw_fund_mast.fund_id%TYPE,

2037: -- cursor to get all the sponsor detail for the person id
2038: CURSOR c_sp_std_dtls (cp_person_id igs_pe_person.person_id%TYPE,
2039: cp_awd_cal_type igs_ca_inst.cal_type%TYPE,
2040: cp_awd_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
2041: cp_fund_id igf_aw_fund_mast.fund_id%TYPE,
2042: cp_v_disc_fund igf_aw_fund_mast.discontinue_fund%TYPE) IS
2043: SELECT rel.*,
2044: fund.fund_code,
2045: fund.description fund_desc,

Line 2042: cp_v_disc_fund igf_aw_fund_mast.discontinue_fund%TYPE) IS

2038: CURSOR c_sp_std_dtls (cp_person_id igs_pe_person.person_id%TYPE,
2039: cp_awd_cal_type igs_ca_inst.cal_type%TYPE,
2040: cp_awd_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
2041: cp_fund_id igf_aw_fund_mast.fund_id%TYPE,
2042: cp_v_disc_fund igf_aw_fund_mast.discontinue_fund%TYPE) IS
2043: SELECT rel.*,
2044: fund.fund_code,
2045: fund.description fund_desc,
2046: fund.fee_type

Line 2048: igf_aw_fund_mast fund

2044: fund.fund_code,
2045: fund.description fund_desc,
2046: fund.fee_type
2047: FROM igf_sp_stdnt_rel rel,
2048: igf_aw_fund_mast fund
2049: WHERE rel.fund_id = fund.fund_id
2050: AND rel.fund_id = cp_fund_id
2051: AND fund.discontinue_fund <> cp_v_disc_fund
2052: AND (

Line 2216: --smadathi 31-May-2002 Bug 2387344. Cursor c_igs_lookups , c_igs_pe_persid_group , c_igf_aw_fund_mast

2212: -- cursor c_igs_lookups modified to fetch only active look up codes
2213: --smadathi 02-jul-2002 Bug 2427996. Cursor c_person_id_grp modified to select only active person id
2214: -- belonging to the group. The logic for logging the message IGF_SP_NO_PERSON
2215: -- has been removed.
2216: --smadathi 31-May-2002 Bug 2387344. Cursor c_igs_lookups , c_igs_pe_persid_group , c_igf_aw_fund_mast
2217: -- added. Also logic of logging of all parameters added.
2218: --smadathi 17-May-2002 Bug 2369173. Modified to hadnle the cases when
2219: -- term calendar was provided as parameter to the process
2220: -------------------------------------------------------------------------------------

Line 2230: -- cursor to select fund code from igf_aw_fund_mast to get fund code for fund id parameter

2226: l_ld_sequence_number igs_ca_inst.sequence_number%TYPE;
2227:
2228: l_v_awd_yr_status_cd igf_ap_batch_aw_map.award_year_status_code%TYPE;
2229:
2230: -- cursor to select fund code from igf_aw_fund_mast to get fund code for fund id parameter
2231: -- This cursor definition is public to this package body;
2232: CURSOR c_igf_aw_fund_mast(cp_fund_id igf_aw_fund_mast.fund_id%TYPE,
2233: cp_cal_type igs_ca_inst.cal_type%TYPE,
2234: cp_sequence_number igs_ca_inst.sequence_number%TYPE,

Line 2232: CURSOR c_igf_aw_fund_mast(cp_fund_id igf_aw_fund_mast.fund_id%TYPE,

2228: l_v_awd_yr_status_cd igf_ap_batch_aw_map.award_year_status_code%TYPE;
2229:
2230: -- cursor to select fund code from igf_aw_fund_mast to get fund code for fund id parameter
2231: -- This cursor definition is public to this package body;
2232: CURSOR c_igf_aw_fund_mast(cp_fund_id igf_aw_fund_mast.fund_id%TYPE,
2233: cp_cal_type igs_ca_inst.cal_type%TYPE,
2234: cp_sequence_number igs_ca_inst.sequence_number%TYPE,
2235: cp_v_sys_fund_type igf_aw_fund_cat.sys_fund_type%TYPE,
2236: cp_v_disc_fund igf_aw_fund_mast.discontinue_fund%TYPE)

Line 2236: cp_v_disc_fund igf_aw_fund_mast.discontinue_fund%TYPE)

2232: CURSOR c_igf_aw_fund_mast(cp_fund_id igf_aw_fund_mast.fund_id%TYPE,
2233: cp_cal_type igs_ca_inst.cal_type%TYPE,
2234: cp_sequence_number igs_ca_inst.sequence_number%TYPE,
2235: cp_v_sys_fund_type igf_aw_fund_cat.sys_fund_type%TYPE,
2236: cp_v_disc_fund igf_aw_fund_mast.discontinue_fund%TYPE)
2237: IS
2238: SELECT fmast.*
2239: FROM igf_aw_fund_mast fmast ,
2240: igf_aw_fund_cat fcat

Line 2239: FROM igf_aw_fund_mast fmast ,

2235: cp_v_sys_fund_type igf_aw_fund_cat.sys_fund_type%TYPE,
2236: cp_v_disc_fund igf_aw_fund_mast.discontinue_fund%TYPE)
2237: IS
2238: SELECT fmast.*
2239: FROM igf_aw_fund_mast fmast ,
2240: igf_aw_fund_cat fcat
2241: WHERE fmast.fund_code = fcat.fund_code
2242: AND (fmast.fund_id = cp_fund_id OR cp_fund_id IS NULL)
2243: AND fmast.ci_cal_type = cp_cal_type

Line 2249: -- cursor variable for c_igf_aw_fund_mast

2245: AND fcat.sys_fund_type = cp_v_sys_fund_type
2246: AND fmast.discontinue_fund <> cp_v_disc_fund
2247: ORDER BY fund_id;
2248:
2249: -- cursor variable for c_igf_aw_fund_mast
2250: l_c_igf_aw_fund_mast c_igf_aw_fund_mast%ROWTYPE;
2251:
2252: -- Cursor for validating the Person Id Group
2253: CURSOR c_pers_id_grp(cp_n_pers_grp_id igs_pe_all_persid_group_v.group_id%TYPE)

Line 2250: l_c_igf_aw_fund_mast c_igf_aw_fund_mast%ROWTYPE;

2246: AND fmast.discontinue_fund <> cp_v_disc_fund
2247: ORDER BY fund_id;
2248:
2249: -- cursor variable for c_igf_aw_fund_mast
2250: l_c_igf_aw_fund_mast c_igf_aw_fund_mast%ROWTYPE;
2251:
2252: -- Cursor for validating the Person Id Group
2253: CURSOR c_pers_id_grp(cp_n_pers_grp_id igs_pe_all_persid_group_v.group_id%TYPE)
2254: IS

Line 2260: CURSOR c_validate_fund_id(cp_n_fund_id igf_aw_fund_mast.fund_id%TYPE)

2256: FROM igs_pe_all_persid_group_v
2257: WHERE group_id = cp_n_pers_grp_id;
2258: l_c_pers_id_grp c_pers_id_grp%ROWTYPE;
2259:
2260: CURSOR c_validate_fund_id(cp_n_fund_id igf_aw_fund_mast.fund_id%TYPE)
2261: IS
2262: SELECT fund_code, discontinue_fund
2263: FROM igf_aw_fund_mast
2264: WHERE fund_id = cp_n_fund_id;

Line 2263: FROM igf_aw_fund_mast

2259:
2260: CURSOR c_validate_fund_id(cp_n_fund_id igf_aw_fund_mast.fund_id%TYPE)
2261: IS
2262: SELECT fund_code, discontinue_fund
2263: FROM igf_aw_fund_mast
2264: WHERE fund_id = cp_n_fund_id;
2265: l_rec_c_validate_fund_id c_validate_fund_id%ROWTYPE;
2266:
2267: l_v_fund_code igf_aw_fund_mast.fund_code%TYPE;

Line 2267: l_v_fund_code igf_aw_fund_mast.fund_code%TYPE;

2263: FROM igf_aw_fund_mast
2264: WHERE fund_id = cp_n_fund_id;
2265: l_rec_c_validate_fund_id c_validate_fund_id%ROWTYPE;
2266:
2267: l_v_fund_code igf_aw_fund_mast.fund_code%TYPE;
2268:
2269:
2270: l_v_manage_acc igs_fi_control_all.manage_accounts%TYPE := NULL;
2271: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;

Line 2515: FOR l_c_igf_aw_fund_mast IN c_igf_aw_fund_mast (p_fund_id,l_cal_type,l_sequence_number,'SPONSOR','Y')

2511: RETURN;
2512: END IF;
2513: END IF;
2514:
2515: FOR l_c_igf_aw_fund_mast IN c_igf_aw_fund_mast (p_fund_id,l_cal_type,l_sequence_number,'SPONSOR','Y')
2516: LOOP
2517:
2518: IF p_person_group_id IS NOT NULL THEN
2519: -- Open the REF CURSOR for above derived SQL statement ( l_dynamic_sql )

Line 2537: loop_thru_spnsr_dtl (rec_person_grp.l_n_person_id, l_cal_type, l_sequence_number, p_award_type, l_c_igf_aw_fund_mast.fund_id,l_ld_cal_type,l_ld_sequence_number);

2533: -- package variable.
2534: -- When the person id is passed as input parameter then while logging the process parameters, this global
2535: -- variable is initialized and has a value.
2536: g_v_person_number := get_person_number(rec_person_grp.l_n_person_id);
2537: loop_thru_spnsr_dtl (rec_person_grp.l_n_person_id, l_cal_type, l_sequence_number, p_award_type, l_c_igf_aw_fund_mast.fund_id,l_ld_cal_type,l_ld_sequence_number);
2538: END LOOP;
2539: CLOSE c_ref_person_grp;
2540: ELSE
2541: -- When the user has not provided either Person Id od Person Group then the process should assign awards for

Line 2543: loop_thru_spnsr_dtl(p_person_id, l_cal_type, l_sequence_number, p_award_type,l_c_igf_aw_fund_mast.fund_id,l_ld_cal_type,l_ld_sequence_number);

2539: CLOSE c_ref_person_grp;
2540: ELSE
2541: -- When the user has not provided either Person Id od Person Group then the process should assign awards for
2542: -- all eligible persons. This is handled in the local procedure loop_thru_spnsr_dtl main cursor.
2543: loop_thru_spnsr_dtl(p_person_id, l_cal_type, l_sequence_number, p_award_type,l_c_igf_aw_fund_mast.fund_id,l_ld_cal_type,l_ld_sequence_number);
2544: END IF;
2545:
2546: -- Commit the transactions for each Sponsor and when test_run mode is 'N'
2547: -- Should Rollback the transactions to avoid redo log error