APPS.IGS_PE_PERSON_PKG dependencies on IGS_PE_ALT_PERS_ID

Line 9: -- CDCRUZ Sep 24,2002 Modified calls to IGS_PE_ALT_PERS_ID_PKG

5: -- Change History
6: --
7: -- Bug ID : 2000408
8: -- who when what
9: -- CDCRUZ Sep 24,2002 Modified calls to IGS_PE_ALT_PERS_ID_PKG
10: -- vrathi 2003/07/11 Bug No:3045079 The sysdate should be truncated before inserting into
11: -- IGS_PE_ALT_PERS_ID to eliminate the time component
12: -- asbala 13-APR-2004 Removed DEFAULT NULL from the parameters of Set_Column_Values procedure
13: -- since the parameters of Before_Dml are DEFAULT NULL

Line 11: -- IGS_PE_ALT_PERS_ID to eliminate the time component

7: -- Bug ID : 2000408
8: -- who when what
9: -- CDCRUZ Sep 24,2002 Modified calls to IGS_PE_ALT_PERS_ID_PKG
10: -- vrathi 2003/07/11 Bug No:3045079 The sysdate should be truncated before inserting into
11: -- IGS_PE_ALT_PERS_ID to eliminate the time component
12: -- asbala 13-APR-2004 Removed DEFAULT NULL from the parameters of Set_Column_Values procedure
13: -- since the parameters of Before_Dml are DEFAULT NULL
14: ------------------------------------------------------------------
15:

Line 769: IGS_PE_ALT_PERS_ID_PKG.INSERT_ROW (

765: );
766:
767:
768: IF x_api_person_id IS NOT NULL AND x_person_id_type IS NOT NULL THEN
769: IGS_PE_ALT_PERS_ID_PKG.INSERT_ROW (
770: X_ROWID => lv_rowid,
771: X_PE_PERSON_ID => X_PERSON_ID,
772: X_API_PERSON_ID => x_api_person_id,
773: X_PERSON_ID_TYPE => x_person_id_type,

Line 914: IGS_PE_ALT_PERS_ID to eliminate the time component

910: Change History
911: Who When What
912: sraj 2000/05/05 the table structure has been changed
913: vrathi 2003/07/11 Bug No:3045079 The sysdate should be truncated before inserting into
914: IGS_PE_ALT_PERS_ID to eliminate the time component
915: (reverse chronological order - newest change first)
916: ***************************************************************/
917: x_profile_id HZ_PERSON_PROFILES.PERSON_PROFILE_ID%TYPE;
918:

Line 923: FROM IGS_PE_ALT_PERS_ID P_ID

919: lv_rowid VARCHAR2(25);
920:
921: CURSOR c1 IS
922: SELECT P_ID.ROWID,P_ID.*
923: FROM IGS_PE_ALT_PERS_ID P_ID
924: WHERE pe_person_id = x_person_id AND
925: person_id_type = x_person_id_type AND
926: sysdate between start_dt AND NVL(end_dt, sysdate);
927:

Line 1084: IGS_PE_ALT_PERS_ID_PKG.INSERT_ROW (

1080: IF x_api_person_id IS NOT NULL AND x_person_id_type IS NOT NULL THEN
1081: OPEN c1; FETCH c1 INTO tlinfo;
1082: IF c1%NOTFOUND THEN
1083: CLOSE c1;
1084: IGS_PE_ALT_PERS_ID_PKG.INSERT_ROW (
1085: X_ROWID => lv_rowid,
1086: X_PE_PERSON_ID => new_references.person_id ,
1087: X_API_PERSON_ID => x_api_person_id,
1088: X_PERSON_ID_TYPE => x_person_id_type,