APPS.IGS_PE_PERSON_ID_TYP_PKG dependencies on IGS_PE_PERSON_ID_TYP

Line 1: package body IGS_PE_PERSON_ID_TYP_PKG AS

1: package body IGS_PE_PERSON_ID_TYP_PKG AS
2: /* $Header: IGSNI25B.pls 120.1 2006/01/25 09:20:33 skpandey noship $ */
3:
4: ------------------------------------------------------------------
5: -- Change History

Line 25: old_references IGS_PE_PERSON_ID_TYP%RowType;

21: (reverse chronological order - newest change first)
22: ********************************************************/
23:
24: l_rowid VARCHAR2(25);
25: old_references IGS_PE_PERSON_ID_TYP%RowType;
26: new_references IGS_PE_PERSON_ID_TYP%RowType;
27:
28: PROCEDURE Set_Column_Values (
29: p_action IN VARCHAR2,

Line 26: new_references IGS_PE_PERSON_ID_TYP%RowType;

22: ********************************************************/
23:
24: l_rowid VARCHAR2(25);
25: old_references IGS_PE_PERSON_ID_TYP%RowType;
26: new_references IGS_PE_PERSON_ID_TYP%RowType;
27:
28: PROCEDURE Set_Column_Values (
29: p_action IN VARCHAR2,
30: x_rowid IN VARCHAR2 ,

Line 60: FROM IGS_PE_PERSON_ID_TYP

56: ***************************************************************/
57:
58: CURSOR cur_old_ref_values IS
59: SELECT *
60: FROM IGS_PE_PERSON_ID_TYP
61: WHERE rowid = x_rowid;
62:
63: BEGIN
64:

Line 124: -- Validate IGS_PE_PERSON ID TYPE.

120: ********************************************************/
121:
122: v_message_name varchar2(30);
123: BEGIN
124: -- Validate IGS_PE_PERSON ID TYPE.
125: -- IGS_OR_INSTITUTION closed indicator.
126: IF new_references.institution_cd IS NOT NULL AND
127: (NVL(old_references.institution_cd, 'NULL') <> new_references.institution_cd) THEN
128: IF IGS_EN_VAL_PIT.enrp_val_pit_inst_cd (

Line 286: FROM IGS_PE_PERSON_ID_TYP

282: ********************************************************/
283: --Cursor to check the existence of parent
284: CURSOR cur_rowid IS
285: SELECT rowid
286: FROM IGS_PE_PERSON_ID_TYP
287: WHERE person_id_type = x_person_id_type;
288:
289: lv_rowid cur_rowid%ROWTYPE;
290:

Line 312: after adding closed indicator in IGS_PE_PERSON_ID_TYP

308: Created By : ssaleem
309: Date Created By : 17-SEP-2004
310: Purpose : To enforce primary key validations with closed indicator
311: Know limitations, enhancements or remarks : This function is created
312: after adding closed indicator in IGS_PE_PERSON_ID_TYP
313: Change History
314: Who When What
315: (reverse chronological order - newest change first)
316: ********************************************************/

Line 320: FROM IGS_PE_PERSON_ID_TYP

316: ********************************************************/
317: --Cursor to check the existence of parent
318: CURSOR cur_rowid IS
319: SELECT rowid
320: FROM IGS_PE_PERSON_ID_TYP
321: WHERE person_id_type = x_person_id_type AND
322: CLOSED_IND = 'N';
323:
324: lv_rowid cur_rowid%ROWTYPE;

Line 358: FROM IGS_PE_PERSON_ID_TYP

354: ********************************************************/
355:
356: CURSOR cur_rowid IS
357: SELECT rowid
358: FROM IGS_PE_PERSON_ID_TYP
359: WHERE institution_cd = x_institution_cd ;
360: lv_rowid cur_rowid%RowType;
361: BEGIN
362: Open cur_rowid;

Line 533: cursor C is select ROWID from IGS_PE_PERSON_ID_TYP

529: sraj 17-MAY-2000 Two columns have been added to this table.
530: (reverse chronological order - newest change first)
531: ***************************************************************/
532:
533: cursor C is select ROWID from IGS_PE_PERSON_ID_TYP
534: where PERSON_ID_TYPE= X_PERSON_ID_TYPE
535: ;
536: X_LAST_UPDATE_DATE DATE ;
537: X_LAST_UPDATED_BY NUMBER ;

Line 576: insert into IGS_PE_PERSON_ID_TYP (

572: x_last_update_date=>X_LAST_UPDATE_DATE,
573: x_last_updated_by=>X_LAST_UPDATED_BY,
574: x_last_update_login=>X_LAST_UPDATE_LOGIN
575: );
576: insert into IGS_PE_PERSON_ID_TYP (
577: PERSON_ID_TYPE
578: ,DESCRIPTION
579: ,S_PERSON_ID_TYPE
580: ,INSTITUTION_CD

Line 648: from IGS_PE_PERSON_ID_TYP

644: , PREFERRED_IND
645: , UNIQUE_IND
646: , FORMAT_MASK
647: , REGION_IND
648: from IGS_PE_PERSON_ID_TYP
649: where ROWID = X_ROWID
650: for update nowait;
651: tlinfo c1%rowtype;
652: begin

Line 760: update IGS_PE_PERSON_ID_TYP set

756: x_last_update_date=>X_LAST_UPDATE_DATE,
757: x_last_updated_by=>X_LAST_UPDATED_BY,
758: x_last_update_login=>X_LAST_UPDATE_LOGIN
759: );
760: update IGS_PE_PERSON_ID_TYP set
761: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
762: S_PERSON_ID_TYPE = NEW_REFERENCES.S_PERSON_ID_TYPE,
763: INSTITUTION_CD = NEW_REFERENCES.INSTITUTION_CD,
764: PREFERRED_IND = NEW_REFERENCES.PREFERRED_IND,

Line 807: cursor c1 is select ROWID from IGS_PE_PERSON_ID_TYP

803: sraj 17-MAY-2000 Two columns have been added to this table.
804: (reverse chronological order - newest change first)
805: ***************************************************************/
806:
807: cursor c1 is select ROWID from IGS_PE_PERSON_ID_TYP
808: where PERSON_ID_TYPE= X_PERSON_ID_TYPE
809: ;
810: begin
811: open c1;

Line 844: END igs_pe_person_id_typ_pkg;

840: X_MODE,
841: X_CLOSED_IND);
842: end ADD_ROW;
843:
844: END igs_pe_person_id_typ_pkg;