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.IGS_FI_PRC_DISC_SUA dependencies on IGS_PE_PERSON

Line 93: p_person_id IN igs_pe_person.person_id%TYPE,

89: AND dcnt_unit_ind = g_yes_ind;
90:
91: -- Fuction for validating all the Input Paramters
92: FUNCTION validate_input_parameters(
93: p_person_id IN igs_pe_person.person_id%TYPE,
94: p_person_id_grp IN igs_pe_prsid_grp_mem_v.group_id%TYPE,
95: p_fee_period IN VARCHAR2,
96: p_fee_cal_type IN igs_fi_inv_int.fee_cal_type%TYPE,
97: p_fee_ci_sequence_number IN igs_fi_inv_int.fee_ci_sequence_number%TYPE,

Line 120: CURSOR cur_person_id(cp_person_id IN igs_pe_person.person_id%TYPE) IS

116: (reverse chronological order - newest change first)
117: ****************************************************/
118:
119: -- Cursor for validating the Person Id
120: CURSOR cur_person_id(cp_person_id IN igs_pe_person.person_id%TYPE) IS
121: SELECT party_number
122: FROM hz_parties
123: WHERE party_id = cp_person_id;
124:

Line 276: p_person_id IN igs_pe_person.person_id%type,

272:
273: PROCEDURE drop_disc_sua_non_payment(
274: ERRBUF OUT NOCOPY VARCHAR2,
275: RETCODE OUT NOCOPY NUMBER,
276: p_person_id IN igs_pe_person.person_id%type,
277: p_person_id_grp IN igs_pe_prsid_grp_mem_v.group_id%type,
278: p_FEE_PERIOD IN VARCHAR2,
279: p_balance_type IN igs_fi_balance_rules.balance_name%type,
280: p_dcnt_reason_cd IN igs_en_dcnt_reasoncd_v.discontinuation_reason_cd%type,

Line 300: sapanigr 13-Feb-2006 Bug#5018036. Modified cursor cur_person. Query now uses igs_pe_person_base_v

296:
297: sapanigr 01-Jun-2006 Bug#5251760. Review comments addressed. Minor modifications.
298: sapanigr 31-May-2006 Bug#5251760. Removed unions in cur_person_unit_outstdng_chrgs to form
299: three separate cursors. Modified related code accordingly.
300: sapanigr 13-Feb-2006 Bug#5018036. Modified cursor cur_person. Query now uses igs_pe_person_base_v
301: instead of igs_pe_person.
302: rmaddipa 22-jul-2004 Bug#3776195 Replaced the call APP_EXCEPTION.RAISE_EXCEPTION with a
303: "retcode := 2;" statement and "RETURN;" to remove the 'Unhandled Exception'
304: in the log,

Line 301: instead of igs_pe_person.

297: sapanigr 01-Jun-2006 Bug#5251760. Review comments addressed. Minor modifications.
298: sapanigr 31-May-2006 Bug#5251760. Removed unions in cur_person_unit_outstdng_chrgs to form
299: three separate cursors. Modified related code accordingly.
300: sapanigr 13-Feb-2006 Bug#5018036. Modified cursor cur_person. Query now uses igs_pe_person_base_v
301: instead of igs_pe_person.
302: rmaddipa 22-jul-2004 Bug#3776195 Replaced the call APP_EXCEPTION.RAISE_EXCEPTION with a
303: "retcode := 2;" statement and "RETURN;" to remove the 'Unhandled Exception'
304: in the log,
305: Added the code for logging the input parameters

Line 434: CURSOR cur_person(cp_person_id IN igs_pe_person_base_v.person_id%TYPE) IS

430: BETWEEN wd.start_dt and wd.end_dt))
431: ORDER BY person_id,course_cd, uoo_id,invoice_creation_date;
432:
433: --Cursor to fetch the person details
434: CURSOR cur_person(cp_person_id IN igs_pe_person_base_v.person_id%TYPE) IS
435: SELECT person_number,
436: first_name || ' ' || last_name person_name
437: FROM igs_pe_person_base_v
438: WHERE person_id = cp_person_id;

Line 437: FROM igs_pe_person_base_v

433: --Cursor to fetch the person details
434: CURSOR cur_person(cp_person_id IN igs_pe_person_base_v.person_id%TYPE) IS
435: SELECT person_number,
436: first_name || ' ' || last_name person_name
437: FROM igs_pe_person_base_v
438: WHERE person_id = cp_person_id;
439:
440: -- Enh # 2187247
441: -- Modified the cursor for fetching the unit attempt status

Line 464: CURSOR cur_course_version(p_person_id IN igs_pe_person.person_id%TYPE,

460: -- Cursor to fetch the Course details
461: -- Enh # 2187247
462: -- Modified the cursor
463: -- Removed the subquery as it was redundant
464: CURSOR cur_course_version(p_person_id IN igs_pe_person.person_id%TYPE,
465: p_course_cd IN igs_fi_inv_int.course_cd%TYPE
466: ) IS
467: SELECT ps.course_cd, ps.version_number
468: FROM igs_en_stdnt_ps_att ps

Line 484: l_person_id igs_pe_person.person_id%TYPE;

480:
481: -- Declaration of local variables
482:
483: l_uoo_id igs_fi_invln_int.uoo_id%TYPE;
484: l_person_id igs_pe_person.person_id%TYPE;
485: l_course_cd igs_fi_inv_int.course_cd%TYPE;
486: l_cnt NUMBER;
487: l_str VARCHAR2(4000);
488: l_message VARCHAR2(2000);

Line 493: l_person_number igs_pe_person.person_number%TYPE;

489: l_fee_cal_type igs_fi_inv_int.fee_cal_type%TYPE;
490: l_fee_ci_sequence_number igs_fi_inv_int.fee_ci_sequence_number%TYPE;
491: l_ld_cal_type igs_ca_inst.cal_type%TYPE;
492: l_ld_ci_sequence_number Igs_ca_inst.sequence_number%TYPE;
493: l_person_number igs_pe_person.person_number%TYPE;
494: l_enrolled_dt igs_en_su_attempt.enrolled_dt%TYPE;
495: l_person_name igs_pe_person.full_name%TYPE;
496: l_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE;
497: l_last_conversion_date igs_fi_balance_rules.last_conversion_date%TYPE;

Line 495: l_person_name igs_pe_person.full_name%TYPE;

491: l_ld_cal_type igs_ca_inst.cal_type%TYPE;
492: l_ld_ci_sequence_number Igs_ca_inst.sequence_number%TYPE;
493: l_person_number igs_pe_person.person_number%TYPE;
494: l_enrolled_dt igs_en_su_attempt.enrolled_dt%TYPE;
495: l_person_name igs_pe_person.full_name%TYPE;
496: l_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE;
497: l_last_conversion_date igs_fi_balance_rules.last_conversion_date%TYPE;
498: l_version_number igs_fi_balance_rules.version_number%TYPE;
499: