APPS.IGS_FI_PRC_HOLDS dependencies on IGS_PE_PERSON_V

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 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