[Home] [Help]
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.
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,
793: P_fee_cal_type IN igs_fi_inv_int.fee_cal_type%TYPE,
805: smadathi 28-Aug-2003 Enh Bug 3045007. Removed the parameter P_OFFSET_DAYS.
806: pathipat 12-Aug-2003 Enh 3076768 - Automatic Release of Holds
807: Removed calls to igs_pe_gen_001.get_hold_auth -- Removed validation for staff member
808: pathipat 23-Jun-2003 Bug: 3018104 - Impact of changes in person id group views
809: Modified cursor c_person_group_id - replaced igs_pe_persid_group_v
810: with igs_pe_persid_group
811: pathipat 25-Feb-2003 Enh:2747341 - Additional Security for Holds build
812: Removed parameter p_auth_person_id, added call to igs_pe_gen_001.get_hold_auth
813: pathipat 04-OCT-2002 Enh Bug:2562745
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,
1028: P_fee_period IN VARCHAR2,
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
1524: IS
1531: Who When What
1532: pathipat 12-Aug-2003 Enh 3076768 - Automatic Release of Holds
1533: Removed calls to igs_pe_gen_001.get_hold_auth
1534: pathipat 23-Jun-2003 Bug: 3018104 - Impact of changes in person id group views
1535: Modified cursor c_person_group_id - replaced igs_pe_persid_group_v
1536: with igs_pe_persid_group
1537: pathipat 25-Feb-2003 Enh:2747341 - - Additional Security for Holds build
1538: Added validation for hold authorizer
1539: ***************************************************************/
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)
2223: IS
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:
2577: IS