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 IGS_PE_PERSON

Line 260: FUNCTION get_person_number (p_person_id igs_pe_person.person_id%TYPE)

256: fnd_file.put_line(fnd_file.log, p_v_parm_type || ' : ' || p_v_parm_code );
257: END log_parameters;
258:
259:
260: FUNCTION get_person_number (p_person_id igs_pe_person.person_id%TYPE)
261: RETURN VARCHAR2
262: AS
263: ------------------------------------------------------------------------------------
264: --Created by : smanglm ( Oracle IDC)

Line 278: -- to fetch the records from view igs_pe_person_base_v

274: --
275: --Change History:
276: --Who When What
277: --smadathi 30-Jan-2002 Bug 2620302. Cursor c_person_number select modified
278: -- to fetch the records from view igs_pe_person_base_v
279: -- instead of igs_pe_person. This fix is done to remove
280: -- Non-mergablity due to igs_pe_person view
281: -------------------------------------------------------------------------------------
282: -- cursor to get person number

Line 279: -- instead of igs_pe_person. This fix is done to remove

275: --Change History:
276: --Who When What
277: --smadathi 30-Jan-2002 Bug 2620302. Cursor c_person_number select modified
278: -- to fetch the records from view igs_pe_person_base_v
279: -- instead of igs_pe_person. This fix is done to remove
280: -- Non-mergablity due to igs_pe_person view
281: -------------------------------------------------------------------------------------
282: -- cursor to get person number
283: CURSOR c_person_number (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

Line 280: -- Non-mergablity due to igs_pe_person view

276: --Who When What
277: --smadathi 30-Jan-2002 Bug 2620302. Cursor c_person_number select modified
278: -- to fetch the records from view igs_pe_person_base_v
279: -- instead of igs_pe_person. This fix is done to remove
280: -- Non-mergablity due to igs_pe_person view
281: -------------------------------------------------------------------------------------
282: -- cursor to get person number
283: CURSOR c_person_number (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
284: SELECT person_number

Line 283: CURSOR c_person_number (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

279: -- instead of igs_pe_person. This fix is done to remove
280: -- Non-mergablity due to igs_pe_person view
281: -------------------------------------------------------------------------------------
282: -- cursor to get person number
283: CURSOR c_person_number (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
284: SELECT person_number
285: FROM igs_pe_person_base_v
286: WHERE person_id = cp_person_id;
287:

Line 285: FROM igs_pe_person_base_v

281: -------------------------------------------------------------------------------------
282: -- cursor to get person number
283: CURSOR c_person_number (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
284: SELECT person_number
285: FROM igs_pe_person_base_v
286: WHERE person_id = cp_person_id;
287:
288: l_person_number igs_pe_person.person_number%TYPE;
289: BEGIN

Line 288: l_person_number igs_pe_person.person_number%TYPE;

284: SELECT person_number
285: FROM igs_pe_person_base_v
286: WHERE person_id = cp_person_id;
287:
288: l_person_number igs_pe_person.person_number%TYPE;
289: BEGIN
290: -- get the person number
291: OPEN c_person_number (p_person_id);
292: FETCH c_person_number INTO l_person_number;

Line 967: p_person_id igs_pe_person.person_id%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)
969: AS
970: ------------------------------------------------------------------------------------
971: --Created by : smanglm ( Oracle IDC)

Line 1325: PROCEDURE loop_thru_spnsr_dtl_pvt (p_person_id igs_pe_person.person_id%TYPE,

1321: END IF;
1322: END IF;
1323: END create_aw_award;
1324:
1325: PROCEDURE loop_thru_spnsr_dtl_pvt (p_person_id igs_pe_person.person_id%TYPE,
1326: p_award_type VARCHAR2,
1327: p_base_id igf_sp_stdnt_rel.base_id%TYPE,
1328: p_fund_id igf_sp_stdnt_rel.base_id%TYPE,
1329: p_min_attendance_type igf_sp_stdnt_rel.min_attendance_type%TYPE,

Line 2006: PROCEDURE loop_thru_spnsr_dtl (p_person_id IN igs_pe_person.person_id%TYPE,

2002: END IF;
2003: RAISE;
2004: END loop_thru_spnsr_dtl_pvt;
2005:
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,

Line 2038: CURSOR c_sp_std_dtls (cp_person_id igs_pe_person.person_id%TYPE,

2034: --smadathi 17-May-2002 Bug 2369173. Added ld_cal_type and ld_sequence_number as
2035: -- parameters to the procedure.
2036: -------------------------------------------------------------------------------------
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

Line 2155: p_person_id IN igs_pe_person.person_id%TYPE,

2151: (errbuf OUT NOCOPY VARCHAR2,
2152: retcode OUT NOCOPY NUMBER,
2153: p_award_year IN VARCHAR2,
2154: p_term_calendar IN VARCHAR2,
2155: p_person_id IN igs_pe_person.person_id%TYPE,
2156: p_person_group_id IN igs_pe_prsid_grp_mem.group_id%TYPE,
2157: p_fund_id IN igf_sp_stdnt_rel.fund_id%TYPE,
2158: p_award_type IN igf_aw_awd_disb.trans_type%TYPE,
2159: p_test_mode IN VARCHAR2,