[Home] [Help]
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
616:
617: ***************************************************************/
726: IF p_hold_plan_level ='S' THEN
727: l_rowid := NULL;
728: --To insert the required data elements as shown below to the intermediate table IGS_FI_PERSON_HOLDS
729: --Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
730: igs_fi_person_holds_pkg.insert_row(
731: x_Mode => 'R',
732: x_RowId => l_rowid,
733: x_person_id => p_person_id,
734: x_hold_plan_name => p_hold_plan_name ,
749:
750: ELSIF p_hold_plan_level ='F' THEN
751: l_rowid := NULL;
752: -- Call to igs_fi_gen_gl.get_formatted_amount formats amounts by rounding off to currency precision
753: igs_fi_person_holds_pkg.insert_row(
754: x_Mode => 'R',
755: x_Rowid => l_rowid,
756: x_person_id => p_person_id,
757: x_hold_plan_name => p_hold_plan_name ,
2121:
2122: -- Update the value of Release Credit Id in the Holds table if releasing of hold was successful
2123: -- Added as part of Automatic Release of Holds build
2124: -- The Credit Id which caused the hold to be released will be the release_credit_id
2125: igs_fi_person_holds_pkg.update_row ( x_rowid => l_hold_type_rec.row_id,
2126: x_person_id => l_hold_type_rec.person_id,
2127: x_hold_plan_name => l_hold_type_rec.hold_plan_name,
2128: x_hold_type => l_hold_type_rec.hold_type,
2129: x_hold_start_dt => l_hold_type_rec.hold_start_dt,