APPS.IGS_AD_LOCATION_PKG dependencies on IGS_PE_PERSON

Line 16: x_coord_person_id IN igs_pe_person.person_id%type DEFAULT NULL,

12: x_location_cd IN VARCHAR2 DEFAULT NULL,
13: x_description IN VARCHAR2 DEFAULT NULL,
14: x_location_type IN VARCHAR2 DEFAULT NULL,
15: x_closed_ind IN VARCHAR2 DEFAULT NULL,
16: x_coord_person_id IN igs_pe_person.person_id%type DEFAULT NULL,
17: x_mail_dlvry_wrk_days IN NUMBER DEFAULT NULL,
18: x_attribute_category IN VARCHAR2 DEFAULT NULL,
19: x_attribute1 IN VARCHAR2 DEFAULT NULL,
20: x_attribute2 IN VARCHAR2 DEFAULT NULL,

Line 281: IF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (

277: IF (((old_references.coord_person_id = new_references.coord_person_id)) OR
278: ((new_references.coord_person_id IS NULL))) THEN
279: NULL;
280: ELSE
281: IF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (
282: new_references.coord_person_id
283: ) THEN
284: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
285: IGS_GE_MSG_STACK.ADD;

Line 500: PROCEDURE GET_FK_IGS_PE_PERSON (

496: Close cur_rowid;
497:
498: END GET_FK_IGS_AD_LOCATION_TYPE;
499:
500: PROCEDURE GET_FK_IGS_PE_PERSON (
501: x_person_id IN igs_pe_person.person_id%type
502: ) AS
503: /*************************************************************
504: Created By :

Line 501: x_person_id IN igs_pe_person.person_id%type

497:
498: END GET_FK_IGS_AD_LOCATION_TYPE;
499:
500: PROCEDURE GET_FK_IGS_PE_PERSON (
501: x_person_id IN igs_pe_person.person_id%type
502: ) AS
503: /*************************************************************
504: Created By :
505: Date Created By :

Line 532: END GET_FK_IGS_PE_PERSON;

528: Return;
529: END IF;
530: Close cur_rowid;
531:
532: END GET_FK_IGS_PE_PERSON;
533:
534: PROCEDURE Before_DML (
535: p_action IN VARCHAR2,
536: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 542: x_coord_person_id IN igs_pe_person.person_id%type DEFAULT NULL,

538: x_location_cd IN VARCHAR2 DEFAULT NULL,
539: x_description IN VARCHAR2 DEFAULT NULL,
540: x_location_type IN VARCHAR2 DEFAULT NULL,
541: x_closed_ind IN VARCHAR2 DEFAULT NULL,
542: x_coord_person_id IN igs_pe_person.person_id%type DEFAULT NULL,
543: x_mail_dlvry_wrk_days IN NUMBER DEFAULT NULL,
544: x_attribute_category IN VARCHAR2 DEFAULT NULL,
545: x_attribute1 IN VARCHAR2 DEFAULT NULL,
546: x_attribute2 IN VARCHAR2 DEFAULT NULL,

Line 686: X_COORD_PERSON_ID igs_pe_person.person_id%type,

682: X_LOCATION_CD in VARCHAR2,
683: X_DESCRIPTION in VARCHAR2,
684: X_LOCATION_TYPE in VARCHAR2,
685: X_MAIL_DLVRY_WRK_DAYS in NUMBER,
686: X_COORD_PERSON_ID igs_pe_person.person_id%type,
687: x_attribute_category IN VARCHAR2 DEFAULT NULL,
688: x_attribute1 IN VARCHAR2 DEFAULT NULL,
689: x_attribute2 IN VARCHAR2 DEFAULT NULL,
690: x_attribute3 IN VARCHAR2 DEFAULT NULL,

Line 878: X_COORD_PERSON_ID in igs_pe_person.person_id%type,

874: X_LOCATION_CD in VARCHAR2,
875: X_DESCRIPTION in VARCHAR2,
876: X_LOCATION_TYPE in VARCHAR2,
877: X_MAIL_DLVRY_WRK_DAYS in NUMBER,
878: X_COORD_PERSON_ID in igs_pe_person.person_id%type,
879: x_attribute_category IN VARCHAR2 DEFAULT NULL,
880: x_attribute1 IN VARCHAR2 DEFAULT NULL,
881: x_attribute2 IN VARCHAR2 DEFAULT NULL,
882: x_attribute3 IN VARCHAR2 DEFAULT NULL,

Line 1048: X_COORD_PERSON_ID in igs_pe_person.person_id%type,

1044: X_LOCATION_CD in VARCHAR2,
1045: X_DESCRIPTION in VARCHAR2,
1046: X_LOCATION_TYPE in VARCHAR2,
1047: X_MAIL_DLVRY_WRK_DAYS in NUMBER,
1048: X_COORD_PERSON_ID in igs_pe_person.person_id%type,
1049: X_CLOSED_IND in VARCHAR2,
1050: x_attribute_category IN VARCHAR2 DEFAULT NULL,
1051: x_attribute1 IN VARCHAR2 DEFAULT NULL,
1052: x_attribute2 IN VARCHAR2 DEFAULT NULL,

Line 1192: X_COORD_PERSON_ID in igs_pe_person.person_id%type,

1188: X_LOCATION_CD in VARCHAR2,
1189: X_DESCRIPTION in VARCHAR2,
1190: X_LOCATION_TYPE in VARCHAR2,
1191: X_MAIL_DLVRY_WRK_DAYS in NUMBER,
1192: X_COORD_PERSON_ID in igs_pe_person.person_id%type,
1193: X_CLOSED_IND in VARCHAR2,
1194: x_attribute_category IN VARCHAR2 DEFAULT NULL,
1195: x_attribute1 IN VARCHAR2 DEFAULT NULL,
1196: x_attribute2 IN VARCHAR2 DEFAULT NULL,