[Home] [Help]
26: Modified finp_apply_holds() and finp_release_holds_main() - Added check for manage_accounts
27: vvutukur 05-Mar-2003 Bug#2824994.Modified procedure finp_apply_holds,function validate_holds(used in releasing holds),holds_balance.
28: pathipat 25-Feb-2003 Enh:2747341 - Additional Security for Holds build
29: Modifications according to FI206_TD_SWS_Additional_Security_for_Holds_s1a.doc
30: Modified cursor c_person - selected from igs_pe_person_base_v instead of igs_pe_person
31: Changed declaration of local variable person_name appropriately.
32: ssawhney 17-feb-2003 Bug : 2758856 : Added the parameter x_external_reference in the call to IGS_PE_PERS_ENCUMB_PKG.UPDATE_ROW
33:
34: SYKRISHn 03-JAN-2002 Bug 2684895 --Procedure finp_apply_holds and finp_release_holds_main
75: --cursor to SELECT person information for the passed person id in order to display in the log
76: CURSOR c_person(l_person_id igs_pe_person.person_id%TYPE) IS
77: SELECT person_number,
78: full_name
79: FROM igs_pe_person_base_v
80: WHERE person_id = l_person_id;
81:
82: --cursor variable
83: l_person_rec c_person%ROWTYPE;
1081: l_person_inv_int_rec c_person_inv_int%ROWTYPE;
1082: l_fee_cal_type igs_fi_inv_int.fee_cal_type%TYPE;
1083: l_fee_ci_sequence_number igs_fi_inv_int.fee_ci_sequence_number%TYPE;
1084: l_person_number igs_pe_person.person_number%TYPE :=NULL;
1085: l_person_name igs_pe_person_base_v.full_name%TYPE :=NULL;
1086: l_message_name fnd_new_messages.message_name%TYPE :=NULL;
1087: l_message_name_1 fnd_new_messages.message_name%TYPE :=NULL;
1088: l_hold_type igs_fi_hold_plan.hold_type%TYPE;
1089: l_hold_plan_level igs_fi_hold_plan.hold_plan_level%TYPE;
2258: AND group_id = p_person_id_group;
2259:
2260: CURSOR c_person_hold IS
2261: SELECT person_id, person_number
2262: FROM igs_pe_person_base_v per
2263: WHERE EXISTS ( SELECT '1'
2264: FROM igs_fi_person_holds hold
2265: WHERE hold.person_id = per.person_id);
2266: