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_HOLDS dependencies on IGS_PE_PERSON

Line 30: Modified cursor c_person - selected from igs_pe_person_base_v instead of igs_pe_person

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

Line 66: vvutukur 28-02-2002 Modified the cursor c_person by selecting from igs_pe_person

62: SYkrishn 30/APR/2002 in function validate_param
63: Changes in curor c_fee_type to compare ci ststu with system fee structure ststua
64: Bug 2348883
65: SYkrishn 03-APR-2002 Changes according to Build 2293676 - Planned Credits Functionality introduced.
66: vvutukur 28-02-2002 Modified the cursor c_person by selecting from igs_pe_person
67: instead of igs_fi_parties_v.for bug:2238362(reverting back the earlier fix).
68: vvutukur 27-02-2002 Modified cursor c_person by selecting from igs_fi_parties_v
69: instead of igs_pe_person for bug:2238362.
70: ***************************************************************/

Line 69: instead of igs_pe_person for bug:2238362.

65: SYkrishn 03-APR-2002 Changes according to Build 2293676 - Planned Credits Functionality introduced.
66: vvutukur 28-02-2002 Modified the cursor c_person by selecting from igs_pe_person
67: instead of igs_fi_parties_v.for bug:2238362(reverting back the earlier fix).
68: vvutukur 27-02-2002 Modified cursor c_person by selecting from igs_fi_parties_v
69: instead of igs_pe_person for bug:2238362.
70: ***************************************************************/
71:
72: --Skip exception used to skip a record FROM the cursor based on the condition
73: skip EXCEPTION;

Line 76: CURSOR c_person(l_person_id igs_pe_person.person_id%TYPE) IS

72: --Skip exception used to skip a record FROM the cursor based on the condition
73: skip EXCEPTION;
74:
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;

Line 79: FROM igs_pe_person_base_v

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;

Line 141: FUNCTION holds_balance( p_person_id IN igs_pe_person_v.person_id%TYPE ,

137: -- Changes due to SFCR018
138:
139: --FUNCTION to calculate holds balance amount
140:
141: FUNCTION holds_balance( p_person_id IN igs_pe_person_v.person_id%TYPE ,
142: p_person_number IN igs_pe_person_v.person_number%TYPE ,
143: p_hold_plan_name IN igs_fi_hold_plan.hold_plan_name%Type,
144: P_fee_cal_type IN igs_fi_inv_int.fee_cal_type%TYPE,
145: P_fee_ci_sequence_number IN igs_fi_inv_int.fee_ci_sequence_number%TYPE,

Line 142: p_person_number IN igs_pe_person_v.person_number%TYPE ,

138:
139: --FUNCTION to calculate holds balance amount
140:
141: FUNCTION holds_balance( p_person_id IN igs_pe_person_v.person_id%TYPE ,
142: p_person_number IN igs_pe_person_v.person_number%TYPE ,
143: p_hold_plan_name IN igs_fi_hold_plan.hold_plan_name%Type,
144: P_fee_cal_type IN igs_fi_inv_int.fee_cal_type%TYPE,
145: P_fee_ci_sequence_number IN igs_fi_inv_int.fee_ci_sequence_number%TYPE,
146: p_process_end_date IN igs_fi_person_holds.process_end_dT%TYPE ,

Line 573: FUNCTION validate_holds(p_person_id IN igs_pe_person_v.person_id%TYPE ,

569:
570:
571: --To validate holds to be applied
572:
573: FUNCTION validate_holds(p_person_id IN igs_pe_person_v.person_id%TYPE ,
574: p_person_number IN igs_pe_person_v.person_number%TYPE ,
575: p_hold_start_date IN igs_fi_person_holds.hold_start_dt%type,
576: p_hold_type IN igs_fi_hold_plan.hold_type%TYPE,
577: p_hold_plan_name IN igs_fi_hold_plan.hold_plan_name%TYPE,

Line 574: p_person_number IN igs_pe_person_v.person_number%TYPE ,

570:
571: --To validate holds to be applied
572:
573: FUNCTION validate_holds(p_person_id IN igs_pe_person_v.person_id%TYPE ,
574: p_person_number IN igs_pe_person_v.person_number%TYPE ,
575: p_hold_start_date IN igs_fi_person_holds.hold_start_dt%type,
576: p_hold_type IN igs_fi_hold_plan.hold_type%TYPE,
577: p_hold_plan_name IN igs_fi_hold_plan.hold_plan_name%TYPE,
578: p_hold_plan_level IN igs_fi_hold_plan.hold_plan_level%TYPE,

Line 788: FUNCTION validate_param(p_person_id IN igs_pe_person_v.person_id%TYPE ,

784:
785: --Function to validate passed parameter values
786:
787:
788: FUNCTION validate_param(p_person_id IN igs_pe_person_v.person_id%TYPE ,
789: p_person_id_group IN igs_pe_persid_group_v.group_id%TYPE ,
790: P_process_start_date IN igs_fi_person_holds.process_start_dT%TYPE ,
791: P_process_end_date IN igs_fi_person_holds.process_end_dT%TYPE ,
792: P_hold_plan_name IN igs_fi_hold_plan.hold_plan_name%Type,

Line 1023: p_person_id IN igs_pe_person_v.person_id%TYPE ,

1019:
1020:
1021: PROCEDURE finp_apply_holds(errbuf OUT NOCOPY VARCHAR2,
1022: retcode OUT NOCOPY NUMBER,
1023: p_person_id IN igs_pe_person_v.person_id%TYPE ,
1024: p_person_id_group IN igs_pe_persid_group_v.group_id%TYPE ,
1025: P_process_start_date IN VARCHAR2 ,
1026: P_process_end_date IN VARCHAR2 ,
1027: P_hold_plan_name IN igs_fi_hold_plan.hold_plan_name%Type,

Line 1084: l_person_number igs_pe_person.person_number%TYPE :=NULL;

1080: l_person_group_rec c_person_group%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;

Line 1085: l_person_name igs_pe_person_base_v.full_name%TYPE :=NULL;

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;

Line 1519: FUNCTION validate_param(p_person_id IN igs_pe_person_v.person_id%TYPE,

1515: igs_ge_msg_stack.conc_exception_hndl;
1516: END finp_apply_holds;
1517:
1518:
1519: FUNCTION validate_param(p_person_id IN igs_pe_person_v.person_id%TYPE,
1520: p_person_id_group IN igs_pe_persid_group_v.group_id%TYPE,
1521: P_hold_plan_name IN igs_fi_hold_plan.hold_plan_name%Type,
1522: P_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE)
1523: RETURN BOOLEAN

Line 1627: FUNCTION validate_holds( p_person_id IN igs_pe_person.person_id%TYPE,

1623: END validate_param;
1624:
1625:
1626:
1627: FUNCTION validate_holds( p_person_id IN igs_pe_person.person_id%TYPE,
1628: P_hold_plan_name IN igs_fi_hold_plan.hold_plan_name%TYPE,
1629: P_test_run IN VARCHAR2 ,
1630: P_release OUT NOCOPY PLS_INTEGER,
1631: P_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE,

Line 2218: PROCEDURE finp_release_holds_main(p_person_id IN igs_pe_person.person_id%TYPE ,

2214: RAISE;
2215: END validate_holds;
2216:
2217:
2218: PROCEDURE finp_release_holds_main(p_person_id IN igs_pe_person.person_id%TYPE ,
2219: p_person_id_group IN igs_pe_persid_group_v.group_id%TYPE ,
2220: P_hold_plan_name IN Igs_fi_hold_plan.hold_plan_name%TYPE ,
2221: P_test_run IN VARCHAR2 ,
2222: P_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE)

Line 2262: FROM igs_pe_person_base_v per

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:

Line 2269: l_person_number igs_pe_person.person_number%TYPE :=NULL;

2265: WHERE hold.person_id = per.person_id);
2266:
2267: l_person_group_rec c_person_group%ROWTYPE;
2268: l_person_hold_rec c_person_hold%ROWTYPE;
2269: l_person_number igs_pe_person.person_number%TYPE :=NULL;
2270: l_start_date igs_pe_pers_encumb.start_dt%TYPE;
2271: l_passed_hold_type igs_fi_person_holds.hold_type%TYPE ;
2272: l_hold_plan_name igs_fi_hold_plan.hold_plan_name%TYPE :=NULL;
2273: l_message_name fnd_new_messages.message_name%TYPE :=NULL;

Line 2572: p_person_id IN igs_pe_person.person_id%TYPE ,

2568:
2569:
2570: PROCEDURE finp_release_holds( errbuf OUT NOCOPY VARCHAR2,
2571: retcode OUT NOCOPY NUMBER,
2572: p_person_id IN igs_pe_person.person_id%TYPE ,
2573: p_person_id_group IN igs_pe_persid_group_v.group_id%TYPE ,
2574: p_hold_plan_name IN Igs_fi_hold_plan.hold_plan_name%Type,
2575: p_test_run IN VARCHAR2)
2576: