APPS.IGS_PE_PERSON_PKG dependencies on IGS_PE_PERSON

Line 1: PACKAGE BODY Igs_Pe_Person_PKG AS

1: PACKAGE BODY Igs_Pe_Person_PKG AS
2: /* $Header: IGSNI19B.pls 120.6 2006/01/20 05:42:17 skpandey ship $ */
3:
4: ------------------------------------------------------------------
5: -- Change History

Line 17: old_references igs_pe_person%ROWTYPE;

13: -- since the parameters of Before_Dml are DEFAULT NULL
14: ------------------------------------------------------------------
15:
16: l_rowid VARCHAR2(25);
17: old_references igs_pe_person%ROWTYPE;
18: new_references igs_pe_person%ROWTYPE;
19: v_person_rec hz_party_v2pub.person_rec_type;
20:
21: PROCEDURE Set_Column_Values (

Line 18: new_references igs_pe_person%ROWTYPE;

14: ------------------------------------------------------------------
15:
16: l_rowid VARCHAR2(25);
17: old_references igs_pe_person%ROWTYPE;
18: new_references igs_pe_person%ROWTYPE;
19: v_person_rec hz_party_v2pub.person_rec_type;
20:
21: PROCEDURE Set_Column_Values (
22: p_action IN VARCHAR2,

Line 95: FROM IGS_PE_PERSON

91: (reverse chronological order - newest change first)
92: ***************************************************************/
93: CURSOR cur_old_ref_values IS
94: SELECT *
95: FROM IGS_PE_PERSON
96: WHERE row_id = x_rowid;
97: BEGIN
98: l_rowid := x_rowid;
99: -- Code for setting the Old and New Reference Values.

Line 600: lv_Person_Type_Code IGS_PE_PERSON_TYPES.person_type_code%TYPE;

596: lv_rowid VARCHAR2(30);
597: lv_rowid1 VARCHAR2(30);
598: ln_type_instance_id IGS_PE_TYP_INSTANCES.TYPE_INSTANCE_ID%TYPE;
599: x_profile_id HZ_PERSON_PROFILES.PERSON_PROFILE_ID%TYPE;
600: lv_Person_Type_Code IGS_PE_PERSON_TYPES.person_type_code%TYPE;
601:
602: CURSOR c_pe_rowid (cp_person_id HZ_PARTIES.PARTY_ID%TYPE) IS
603: SELECT ROWID
604: FROM HZ_PARTIES

Line 612: FROM igs_pe_person_types pt

608:
609:
610: CURSOR ptc IS
611: SELECT pt.person_type_code
612: FROM igs_pe_person_types pt
613: WHERE pt.system_type = 'OTHER'
614: AND pt.closed_ind = 'N';
615:
616:

Line 1121: END Igs_Pe_Person_Pkg;

1117:
1118: END IF;
1119: END UPDATE_ROW;
1120:
1121: END Igs_Pe_Person_Pkg;