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_PRSID_GRP_MEM

Line 23: Replaced all occurrences of igs_pe_persid_group_v and igs_pe_prsid_grp_mem_v

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.
22: pathipat 23-Jun-2003 Bug: 3018104 - Impact of changes in person id group views
23: Replaced all occurrences of igs_pe_persid_group_v and igs_pe_prsid_grp_mem_v
24: with igs_pe_persid_group and igs_pe_prsid_grp_mem respectively
25: pathipat 05-May-2003 Enh 2831569 - Commercial Receivables Build
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.

Line 24: with igs_pe_persid_group and igs_pe_prsid_grp_mem respectively

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.
22: pathipat 23-Jun-2003 Bug: 3018104 - Impact of changes in person id group views
23: Replaced all occurrences of igs_pe_persid_group_v and igs_pe_prsid_grp_mem_v
24: with igs_pe_persid_group and igs_pe_prsid_grp_mem respectively
25: pathipat 05-May-2003 Enh 2831569 - Commercial Receivables Build
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

Line 1046: Modified cursor c_person_group - replaced igs_pe_prsid_grp_mem_v

1042: pmarada 26-jul-2004 Bug 3792800, Added code to bypass the holds apply validation
1043: smadathi 28-Aug-2003 Enh Bug 3045007. Removed the parameter P_OFFSET_DAYS from
1044: procedure finp_apply_holds and all the references of P_OFFSET_DAYS
1045: pathipat 23-Jun-2003 Bug: 3018104 - Impact of changes in person id group views
1046: Modified cursor c_person_group - replaced igs_pe_prsid_grp_mem_v
1047: with igs_pe_prsid_grp_mem
1048: pathipat 05-May-2003 Enh 2831569 - Commercial Receivables Build
1049: Added check for manage_accounts - call to igs_fi_com_rec_interface.check_manage_acc()
1050: vvutukur 25-Mar-2003 Enh#2824994.Modified code such that log file output is not shown in horizontal tabular format, instead it

Line 1047: with igs_pe_prsid_grp_mem

1043: smadathi 28-Aug-2003 Enh Bug 3045007. Removed the parameter P_OFFSET_DAYS from
1044: procedure finp_apply_holds and all the references of P_OFFSET_DAYS
1045: pathipat 23-Jun-2003 Bug: 3018104 - Impact of changes in person id group views
1046: Modified cursor c_person_group - replaced igs_pe_prsid_grp_mem_v
1047: with igs_pe_prsid_grp_mem
1048: pathipat 05-May-2003 Enh 2831569 - Commercial Receivables Build
1049: Added check for manage_accounts - call to igs_fi_com_rec_interface.check_manage_acc()
1050: vvutukur 25-Mar-2003 Enh#2824994.Modified code such that log file output is not shown in horizontal tabular format, instead it
1051: it is shown in linear/logging format.Removed the code using l_person_ind as it is redundant since it is used

Line 1068: --Cursor to SELECT dstinct persons FROM igs_pe_prsid_grp_mem_v if person group id is passsed

1064:
1065: pathipat 04-OCT-2002 Enh Bug:2562745, added check that if the holds conversion process
1066: is running, then application of holds cannot take place.
1067: ***************************************************************/
1068: --Cursor to SELECT dstinct persons FROM igs_pe_prsid_grp_mem_v if person group id is passsed
1069: CURSOR c_person_group IS
1070: SELECT person_id
1071: FROM igs_pe_prsid_grp_mem
1072: WHERE (TRUNC(end_date) IS NULL OR TRUNC(end_date) >= TRUNC(SYSDATE))

Line 1071: FROM igs_pe_prsid_grp_mem

1067: ***************************************************************/
1068: --Cursor to SELECT dstinct persons FROM igs_pe_prsid_grp_mem_v if person group id is passsed
1069: CURSOR c_person_group IS
1070: SELECT person_id
1071: FROM igs_pe_prsid_grp_mem
1072: WHERE (TRUNC(end_date) IS NULL OR TRUNC(end_date) >= TRUNC(SYSDATE))
1073: AND group_id = p_person_id_group;
1074: --Cursor to SELECT distinct persons FROM igs_fi_inv_int if person id AND person group id are passsed as NULL
1075: CURSOR c_person_inv_int IS

Line 2236: Modified cursor c_person_group - replaced igs_pe_prsid_grp_mem_v

2232: sapanigr 10-Oct-2005 Bug 3049184 - Modified log file layout.
2233: pathipat 18-Aug-2003 Enh 3076768 - Automatic Release of Holds
2234: Modified cursor c_person_hold to remove DISTINCT clause
2235: pathipat 23-Jun-2003 Bug: 3018104 - Impact of changes in person id group views
2236: Modified cursor c_person_group - replaced igs_pe_prsid_grp_mem_v
2237: with igs_pe_prsid_grp_mem
2238: pathipat 05-May-2003 Enh 2831569 - Commercial Receivables Build
2239: Added check for manage_accounts - call to igs_fi_com_rec_interface.check_manage_acc()
2240: pathipat 26-Feb-2003 Enh 2747341 - Additional Security for Holds

Line 2237: with igs_pe_prsid_grp_mem

2233: pathipat 18-Aug-2003 Enh 3076768 - Automatic Release of Holds
2234: Modified cursor c_person_hold to remove DISTINCT clause
2235: pathipat 23-Jun-2003 Bug: 3018104 - Impact of changes in person id group views
2236: Modified cursor c_person_group - replaced igs_pe_prsid_grp_mem_v
2237: with igs_pe_prsid_grp_mem
2238: pathipat 05-May-2003 Enh 2831569 - Commercial Receivables Build
2239: Added check for manage_accounts - call to igs_fi_com_rec_interface.check_manage_acc()
2240: pathipat 26-Feb-2003 Enh 2747341 - Additional Security for Holds
2241: Added code to keep count of total number of records fetched apart from

Line 2256: FROM igs_pe_prsid_grp_mem

2252: --exception handeling has been done in wrapper procedure.
2253:
2254: CURSOR c_person_group IS
2255: SELECT person_id
2256: FROM igs_pe_prsid_grp_mem
2257: WHERE (TRUNC(end_date) IS NULL OR TRUNC(end_date) >= TRUNC(SYSDATE))
2258: AND group_id = p_person_id_group;
2259:
2260: CURSOR c_person_hold IS