APPS.IGS_PE_PERSON_TYPES_PKG dependencies on IGS_PE_PERSON_TYPES

Line 1: PACKAGE BODY igs_pe_person_types_pkg AS

1: PACKAGE BODY igs_pe_person_types_pkg AS
2: /* $Header: IGSNI43B.pls 115.17 2003/06/11 06:05:56 rnirwani ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_pe_person_types%RowType;
5: new_references igs_pe_person_types%RowType;

Line 4: old_references igs_pe_person_types%RowType;

1: PACKAGE BODY igs_pe_person_types_pkg AS
2: /* $Header: IGSNI43B.pls 115.17 2003/06/11 06:05:56 rnirwani ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_pe_person_types%RowType;
5: new_references igs_pe_person_types%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_pe_person_types%RowType;

1: PACKAGE BODY igs_pe_person_types_pkg AS
2: /* $Header: IGSNI43B.pls 115.17 2003/06/11 06:05:56 rnirwani ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_pe_person_types%RowType;
5: new_references igs_pe_person_types%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 34: FROM IGS_PE_PERSON_TYPES

30: ***************************************************************/
31:
32: CURSOR cur_old_ref_values IS
33: SELECT *
34: FROM IGS_PE_PERSON_TYPES
35: WHERE rowid = x_rowid;
36:
37: BEGIN
38:

Line 90: IGS_PE_PERSON_TYPES A,

86: CURSOR dup_system_type IS
87: SELECT
88: COUNT(1)
89: FROM
90: IGS_PE_PERSON_TYPES A,
91: IGS_PE_PERSON_TYPES B
92: WHERE
93: A.System_Type NOT IN ('USER_DEFINED', 'SS_ENROLL_STAFF')
94: AND A.System_Type = B.System_Type

Line 91: IGS_PE_PERSON_TYPES B

87: SELECT
88: COUNT(1)
89: FROM
90: IGS_PE_PERSON_TYPES A,
91: IGS_PE_PERSON_TYPES B
92: WHERE
93: A.System_Type NOT IN ('USER_DEFINED', 'SS_ENROLL_STAFF')
94: AND A.System_Type = B.System_Type
95: AND A.ROWID <> B.ROWID

Line 188: FROM IGS_PE_PERSON_TYPES

184: ***************************************************************/
185:
186: CURSOR C2 IS
187: SELECT 'X'
188: FROM IGS_PE_PERSON_TYPES
189: WHERE System_Type = new_references.system_type
190: AND CLOSED_IND = 'N';
191: tlinfo c2%ROWTYPE;
192: BEGIN

Line 222: FROM IGS_PE_PERSON_TYPES

218: ***************************************************************/
219:
220: CURSOR C3 IS
221: SELECT 'X'
222: FROM IGS_PE_PERSON_TYPES
223: WHERE System_Type = new_references.system_type
224: AND rowid <> l_rowid
225: -- AND Person_Type_Code <> new_references.Person_Type_Code
226: AND CLOSED_IND = 'N'

Line 295: Igs_Pe_Typ_Instances_Pkg.Get_FK_Igs_Pe_Person_Types (

291: ***************************************************************/
292:
293: BEGIN
294:
295: Igs_Pe_Typ_Instances_Pkg.Get_FK_Igs_Pe_Person_Types (
296: old_references.person_type_code
297: );
298:
299: Igs_Pe_Usr_Arg_pkg.Get_FK_Igs_Pe_Person_Types (

Line 299: Igs_Pe_Usr_Arg_pkg.Get_FK_Igs_Pe_Person_Types (

295: Igs_Pe_Typ_Instances_Pkg.Get_FK_Igs_Pe_Person_Types (
296: old_references.person_type_code
297: );
298:
299: Igs_Pe_Usr_Arg_pkg.Get_FK_Igs_Pe_Person_Types (
300: old_references.person_type_code
301: );
302:
303: Igs_Pe_Usr_Aval_pkg.Get_FK_Igs_Pe_Person_Types (

Line 303: Igs_Pe_Usr_Aval_pkg.Get_FK_Igs_Pe_Person_Types (

299: Igs_Pe_Usr_Arg_pkg.Get_FK_Igs_Pe_Person_Types (
300: old_references.person_type_code
301: );
302:
303: Igs_Pe_Usr_Aval_pkg.Get_FK_Igs_Pe_Person_Types (
304: old_references.person_type_code
305: );
306:
307: END Check_Child_Existance;

Line 327: FROM igs_pe_person_types

323: ***************************************************************/
324:
325: CURSOR cur_rowid IS
326: SELECT rowid
327: FROM igs_pe_person_types
328: WHERE UPPER(person_type_code) = UPPER(x_person_type_code);
329:
330: lv_rowid cur_rowid%RowType;
331:

Line 481: cursor C is select ROWID from IGS_PE_PERSON_TYPES

477:
478: (reverse chronological order - newest change first)
479: ***************************************************************/
480:
481: cursor C is select ROWID from IGS_PE_PERSON_TYPES
482: where PERSON_TYPE_CODE= X_PERSON_TYPE_CODE
483: ;
484: X_LAST_UPDATE_DATE DATE ;
485: X_LAST_UPDATED_BY NUMBER ;

Line 519: insert into IGS_PE_PERSON_TYPES (

515: x_created_by=>X_LAST_UPDATED_BY,
516: x_last_update_date=>X_LAST_UPDATE_DATE,
517: x_last_updated_by=>X_LAST_UPDATED_BY,
518: x_last_update_login=>X_LAST_UPDATE_LOGIN);
519: insert into IGS_PE_PERSON_TYPES (
520: PERSON_TYPE_CODE
521: ,DESCRIPTION
522: ,SYSTEM_TYPE
523: ,CLOSED_IND

Line 575: from IGS_PE_PERSON_TYPES

571: cursor c1 is select
572: DESCRIPTION
573: , SYSTEM_TYPE
574: , CLOSED_IND
575: from IGS_PE_PERSON_TYPES
576: where ROWID = X_ROWID
577: for update nowait;
578: tlinfo c1%rowtype;
579: begin

Line 658: update IGS_PE_PERSON_TYPES set

654: x_created_by=>X_LAST_UPDATED_BY,
655: x_last_update_date=>X_LAST_UPDATE_DATE,
656: x_last_updated_by=>X_LAST_UPDATED_BY,
657: x_last_update_login=>X_LAST_UPDATE_LOGIN);
658: update IGS_PE_PERSON_TYPES set
659: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
660: SYSTEM_TYPE = NEW_REFERENCES.SYSTEM_TYPE,
661: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
662: RANK = NEW_REFERENCES.RANK,

Line 696: cursor c1 is select ROWID from IGS_PE_PERSON_TYPES

692:
693: (reverse chronological order - newest change first)
694: ***************************************************************/
695:
696: cursor c1 is select ROWID from IGS_PE_PERSON_TYPES
697: where PERSON_TYPE_CODE= X_PERSON_TYPE_CODE
698: ;
699: begin
700: open c1;

Line 744: delete from IGS_PE_PERSON_TYPES

740: Before_DML (
741: p_action => 'DELETE',
742: x_rowid => X_ROWID
743: );
744: delete from IGS_PE_PERSON_TYPES
745: where ROWID = X_ROWID;
746: if (sql%notfound) then
747: raise no_data_found;
748: end if;

Line 754: END igs_pe_person_types_pkg;

750: p_action => 'DELETE',
751: x_rowid => X_ROWID
752: );
753: end DELETE_ROW;
754: END igs_pe_person_types_pkg;