APPS.IGS_PE_TYP_INSTANCES_PKG dependencies on HZ_PARTIES

Line 153: p_person_id IN HZ_PARTIES.party_id%TYPE,

149:
150: END After_Insert_update;
151:
152: PROCEDURE checkprospectevaluator(
153: p_person_id IN HZ_PARTIES.party_id%TYPE,
154: p_person_type_code IN igs_pe_typ_instances_all.person_type_code%TYPE
155: ) AS
156: /*************************************************************
157: Created By : Nilotpal Shee

Line 674: p_person_id IN HZ_PARTIES.party_id%TYPE

670:
671: PROCEDURE Check_Mand_Person_Type
672: (
673: p_person_type_code IN IGS_PE_PERSON_TYPES.person_type_code%TYPE,
674: p_person_id IN HZ_PARTIES.party_id%TYPE
675: )
676: IS
677: /*************************************************************
678: Created By :

Line 1027: CURSOR get_active_inst_cur(cp_person_id hz_parties.party_id%type,

1023: l_person_id_w_other number; -- to hold the person_id value during insert of a person type for the first time.
1024:
1025: ---- Check if the person has more than ONE ACTIVE assignment for the same System Person Type,
1026: ---- as the user PERSON TYPE passed. UPDATE CASE
1027: CURSOR get_active_inst_cur(cp_person_id hz_parties.party_id%type,
1028: cp_system_type igs_pe_person_types.system_type%type ,
1029: cp_rowid varchar2) IS
1030: SELECT MAX(NVL(end_date,TO_DATE('4712/12/31','YYYY/MM/DD'))) FROM igs_pe_typ_instances_all pti
1031: WHERE pti.person_id = cp_person_id