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_PERS_ENCUMB

Line 17: while calling insert_row of IGS_PE_PERS_ENCUMB_PKG

13: sapanigr 10-Oct-2005 Bug 3049184 - Modified proc finp_release_holds_main and function validate_holds to change log file
14: for Process Release of Finance Holds
15: svuppala 17-AUG-2005 Bug 4557933 - Unable to remove holds that were put on with concurrent manager
16: Validate_holds : Passing values to AUTHORISING_PERSON_ID and AUTH_RESP_ID from SWS Holds API
17: while calling insert_row of IGS_PE_PERS_ENCUMB_PKG
18: pmarada 26-jul-2004 Bug 3792800, Added code to bypass the holds apply validation in finp_apply_holds procedure
19: pathipat 12-Aug-2003 Enh 3076768 - Automatic Release of Holds
20: Added procedure finp_auto_release_holds(), modified validate_holds() and all its call-outs
21: Modified validate_param - removed calls to igs_pe_gen_001.get_hold_auth.

Line 32: ssawhney 17-feb-2003 Bug : 2758856 : Added the parameter x_external_reference in the call to IGS_PE_PERS_ENCUMB_PKG.UPDATE_ROW

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
35: Logging Person Group Cd instead of person group id.
36: SYKRISHN 31DEC2002 Bug 2676524 - Procedure finp_apply_holds

Line 58: Added the parameter auth_resp_id in the call to the procedures of TBH igs_pe_pers_encumb_pkg

54: 5. Added parameter balance_rule_id in calls to check_exclusion_rules()
55: 6. Removed igs_ge_date.igsdate(p_process_start_date) and replaced with just
56: p_process_Start_date. similarly for process_end_date also.
57: pkpatel 30-SEP-2002 Bug No: 2600842
58: Added the parameter auth_resp_id in the call to the procedures of TBH igs_pe_pers_encumb_pkg
59: vchappid 07-Jun-2002 Bug 2392486#, Calculation of the holds balance incase the Holds plan is at subaccount
60: is corrected , Holds Balance should be added only when the balance record is found in
61: the balances table
62: SYkrishn 30/APR/2002 in function validate_param

Line 603: while calling insert_row of IGS_PE_PERS_ENCUMB_PKG

599: sapanigr 04-May-2006 Enh#3924836 Precision Issue. Amount values being inserted into igs_fi_person_holds
600: are now rounded off to currency precision
601: svuppala 17-AUG-2005 Bug 4557933 - Unable to remove holds that were put on with concurrent manager
602: Passing global values to AUTHORISING_PERSON_ID and AUTH_RESP_ID from SWS Holds API
603: while calling insert_row of IGS_PE_PERS_ENCUMB_PKG
604: smadathi 28-Aug-2003 Enh Bug 3045007. Added 2 new IN parameter - p_n_student_plan_id and
605: p_d_last_inst_due_date
606: pathipat 12-Aug-2003 Enh 3076768 - Automatic Release of Holds
607: Added param x_release_credit_id to TBH calls of igs_fi_person_holds

Line 610: in the call to igs_pe_pers_encumb_pkg.insert_row

606: pathipat 12-Aug-2003 Enh 3076768 - Automatic Release of Holds
607: Added param x_release_credit_id to TBH calls of igs_fi_person_holds
608: pathipat 25-Feb-2003 Enh:2747341 - Additional Security for Holds build
609: Removed parameter p_auth_person_id. Passed Null to authorising_person_id
610: in the call to igs_pe_pers_encumb_pkg.insert_row
611: ssawhney 17-feb-2003 Bug : 2758856 : Added the parameter x_external_reference in the call to IGS_PE_PERS_ENCUMB_PKG.UPDATE_ROW
612: pathipat 04-OCT-2002 Enh Bug: 2562745 -- obsoleted column balance_amount from igs_fi_person_holds
613: Removed column balance_amount from call to igs_fi_person_holds_pkg.insert_row()
614: pkpatel 04-OCT-2002 Bug No: 2600842

Line 611: ssawhney 17-feb-2003 Bug : 2758856 : Added the parameter x_external_reference in the call to IGS_PE_PERS_ENCUMB_PKG.UPDATE_ROW

607: Added param x_release_credit_id to TBH calls of igs_fi_person_holds
608: pathipat 25-Feb-2003 Enh:2747341 - Additional Security for Holds build
609: Removed parameter p_auth_person_id. Passed Null to authorising_person_id
610: in the call to igs_pe_pers_encumb_pkg.insert_row
611: ssawhney 17-feb-2003 Bug : 2758856 : Added the parameter x_external_reference in the call to IGS_PE_PERS_ENCUMB_PKG.UPDATE_ROW
612: pathipat 04-OCT-2002 Enh Bug: 2562745 -- obsoleted column balance_amount from igs_fi_person_holds
613: Removed column balance_amount from call to igs_fi_person_holds_pkg.insert_row()
614: pkpatel 04-OCT-2002 Bug No: 2600842
615: Added the parameter auth_resp_id in the call to TBH igs_pe_pers_encumb_pkg

Line 615: Added the parameter auth_resp_id in the call to TBH igs_pe_pers_encumb_pkg

611: ssawhney 17-feb-2003 Bug : 2758856 : Added the parameter x_external_reference in the call to IGS_PE_PERS_ENCUMB_PKG.UPDATE_ROW
612: pathipat 04-OCT-2002 Enh Bug: 2562745 -- obsoleted column balance_amount from igs_fi_person_holds
613: Removed column balance_amount from call to igs_fi_person_holds_pkg.insert_row()
614: pkpatel 04-OCT-2002 Bug No: 2600842
615: Added the parameter auth_resp_id in the call to TBH igs_pe_pers_encumb_pkg
616:
617: ***************************************************************/
618:
619: --to check if reocrd exist in IGS_PE_PERS_ENCUMB for the passed start date

Line 619: --to check if reocrd exist in IGS_PE_PERS_ENCUMB for the passed start date

615: Added the parameter auth_resp_id in the call to TBH igs_pe_pers_encumb_pkg
616:
617: ***************************************************************/
618:
619: --to check if reocrd exist in IGS_PE_PERS_ENCUMB for the passed start date
620: CURSOR c_hold_exist
621: IS
622: SELECT *
623: FROM igs_pe_pers_encumb

Line 623: FROM igs_pe_pers_encumb

619: --to check if reocrd exist in IGS_PE_PERS_ENCUMB for the passed start date
620: CURSOR c_hold_exist
621: IS
622: SELECT *
623: FROM igs_pe_pers_encumb
624: WHERE person_id = p_person_id
625: AND encumbrance_type = p_hold_type
626: AND TRUNC(start_dt) = TRUNC(p_hold_start_date);
627:

Line 668: igs_pe_pers_encumb_pkg.insert_row (

664: l_rowid := NULL;
665:
666: -- If test_tun value is 'N'
667: -- Insert into the person holds table for the person AND the hold type along with the hold start date.
668: igs_pe_pers_encumb_pkg.insert_row (
669: X_Mode => 'R',
670: X_RowId => l_rowid,
671: X_Person_Id => p_person_id,
672: X_Encumbrance_Type => p_hold_type,

Line 1653: Replaced call to igs_pe_pers_encumb_pkg.update_row with call to igs_pe_gen_001.release_hold

1649: vvutukur 05-Mar-2003 Enh#2824994.Modified code such that log file output is not shown in horizontal tabular format, instead it
1650: it is shown in linear/logging format.Also used global variables to log the details instead of calling generic function
1651: everytime to get the lookup meaning.
1652: pathipat 26-Feb-2003 Enh:2747341 - Additional Security for Holds
1653: Replaced call to igs_pe_pers_encumb_pkg.update_row with call to igs_pe_gen_001.release_hold
1654: ssawhney 17-feb-2003 Bug : 2758856 : Added the parameter x_external_reference in the call to IGS_PE_PERS_ENCUMB_PKG.UPDATE_ROW
1655:
1656: smadathi 20-dec-2002 Enh. Bug 2566615. Removed the references of obsoleted table IGS_FI_HOLD_PLN_LNS and
1657: incorporated changes suggested as per FICR102 TD

Line 1654: ssawhney 17-feb-2003 Bug : 2758856 : Added the parameter x_external_reference in the call to IGS_PE_PERS_ENCUMB_PKG.UPDATE_ROW

1650: it is shown in linear/logging format.Also used global variables to log the details instead of calling generic function
1651: everytime to get the lookup meaning.
1652: pathipat 26-Feb-2003 Enh:2747341 - Additional Security for Holds
1653: Replaced call to igs_pe_pers_encumb_pkg.update_row with call to igs_pe_gen_001.release_hold
1654: ssawhney 17-feb-2003 Bug : 2758856 : Added the parameter x_external_reference in the call to IGS_PE_PERS_ENCUMB_PKG.UPDATE_ROW
1655:
1656: smadathi 20-dec-2002 Enh. Bug 2566615. Removed the references of obsoleted table IGS_FI_HOLD_PLN_LNS and
1657: incorporated changes suggested as per FICR102 TD
1658: agairola 03-Dec-2002 Bug No: 2584741 As part of the Deposits Build, modified the cursor c_credit_amount to exclude

Line 1664: Added the parameter auth_resp_id in the call to TBH igs_pe_pers_encumb_pkg

1660: pathipat 04-OCT-2002 Enh Bug: 2562745 -- Removed selection of balance_amount from cursor c_hold_type
1661: Added cursor c_bal_amount to obtain holds balance amount from igs_fi_balances
1662: Changed type of p_release and l_release_ind to PLS_INTEGER instead of NUMBER
1663: pkpatel 04-OCT-2002 Bug No: 2600842
1664: Added the parameter auth_resp_id in the call to TBH igs_pe_pers_encumb_pkg
1665: sarakshi 23-sep-2002 Enh#2564643,removed the reference of subaccount from this function as mentioned in the TD
1666: sykrishn 07-APR-2002 Introduced planned credits functionality as per SFCR018 DLD
1667: 2293676 - Planned Credits are also considered for release of holds along with
1668: the actual credits . (suba account level holds plan)

Line 1702: FROM igs_pe_pers_encumb a,

1698: hplan.payment_plan_threshold_amt payment_plan_threshold_amt ,
1699: hplan.payment_plan_threshold_pcent payment_plan_threshold_pcent,
1700: c.student_plan_id student_plan_id,
1701: c.last_instlmnt_due_date last_instlmnt_due_date
1702: FROM igs_pe_pers_encumb a,
1703: igs_fi_person_holds c,
1704: igs_fi_hold_plan hplan
1705: WHERE (a.person_id = p_person_id OR p_person_id IS NULL)
1706: AND a.start_dt <= TRUNC(SYSDATE)

Line 1764: CURSOR c_bal_amount (cp_person_id igs_pe_pers_encumb.person_id%TYPE,

1760: );
1761:
1762: -- Get the balance amount from igs_fi_balances instead of from igs_fi_person_holds
1763: -- where the column balance_amount is getting obsoleted.
1764: CURSOR c_bal_amount (cp_person_id igs_pe_pers_encumb.person_id%TYPE,
1765: cp_process_start_dt igs_fi_person_holds.process_start_dt%TYPE) IS
1766: SELECT holds_balance
1767: FROM igs_fi_balances
1768: WHERE party_id = cp_person_id

Line 2270: l_start_date igs_pe_pers_encumb.start_dt%TYPE;

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;
2274: l_message_name_1 fnd_new_messages.message_name%TYPE :=NULL;

Line 2663: FROM igs_pe_pers_encumb pe_encmb,

2659: -- or Fee Type level.
2660: CURSOR cur_active_holds(cp_person_id igs_fi_person_holds.person_id%TYPE,
2661: cp_hold_plan_level igs_fi_hold_plan.hold_plan_level%TYPE) IS
2662: SELECT 'X'
2663: FROM igs_pe_pers_encumb pe_encmb,
2664: igs_fi_person_holds fi_holds,
2665: igs_fi_hold_plan hplan
2666: WHERE pe_encmb.person_id = p_person_id
2667: AND pe_encmb.start_dt <= TRUNC(SYSDATE)