DBA Data[Home] [Help]

APPS.IGS_FI_PRC_APPL dependencies on IGS_PE_PRSID_GRP_MEM_ALL

Line 350: p_person_id_grp igs_pe_prsid_grp_mem_all.group_id%TYPE,

346: PROCEDURE mass_application ( errbuf OUT NOCOPY VARCHAR2,
347: retcode OUT NOCOPY NUMBER,
348: p_org_id NUMBER,
349: p_person_id igs_fi_inv_int_all.person_id%TYPE,
350: p_person_id_grp igs_pe_prsid_grp_mem_all.group_id%TYPE,
351: p_credit_number igs_fi_credits_all.credit_number%TYPE,
352: p_credit_type_id igs_fi_credits_all.credit_type_id%TYPE,
353: p_credit_date_low VARCHAR2,
354: p_credit_date_high VARCHAR2,

Line 446: p_person_id_grp igs_pe_prsid_grp_mem_all.group_id%TYPE,

442: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
443: END mass_application;
444:
445: PROCEDURE mass_apply(p_person_id igs_fi_inv_int_all.person_id%TYPE,
446: p_person_id_grp igs_pe_prsid_grp_mem_all.group_id%TYPE,
447: p_credit_number igs_fi_credits_all.credit_number%TYPE,
448: p_credit_type_id igs_fi_credits_all.credit_type_id%TYPE,
449: p_credit_date_low VARCHAR2,
450: p_credit_date_high VARCHAR2,

Line 501: CURSOR cur_person_group_id(cp_person_grp igs_pe_prsid_grp_mem_all.group_id%TYPE)

497: bug#2326163.(added cursors cur_subaccount_name,cur_credit_type).
498: ******************************************************************/
499:
500: -- cursor for getting the person_id when person group id is passed
501: CURSOR cur_person_group_id(cp_person_grp igs_pe_prsid_grp_mem_all.group_id%TYPE)
502: IS
503: SELECT person_id
504: FROM igs_pe_prsid_grp_mem
505: WHERE group_id = cp_person_grp