APPS.IGS_AD_CRED_TYPES_PKG dependencies on IGS_AD_CRED_TYPES

Line 1: PACKAGE BODY igs_ad_cred_types_pkg AS

1: PACKAGE BODY igs_ad_cred_types_pkg AS
2: /* $Header: IGSAI90B.pls 115.18 2003/10/30 13:16:55 akadam ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_cred_types%RowType;
5: new_references igs_ad_cred_types%RowType;

Line 4: old_references igs_ad_cred_types%RowType;

1: PACKAGE BODY igs_ad_cred_types_pkg AS
2: /* $Header: IGSAI90B.pls 115.18 2003/10/30 13:16:55 akadam ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_cred_types%RowType;
5: new_references igs_ad_cred_types%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ad_cred_types%RowType;

1: PACKAGE BODY igs_ad_cred_types_pkg AS
2: /* $Header: IGSAI90B.pls 115.18 2003/10/30 13:16:55 akadam ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_cred_types%RowType;
5: new_references igs_ad_cred_types%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 36: FROM IGS_AD_CRED_TYPES

32: ***************************************************************/
33:
34: CURSOR cur_old_ref_values IS
35: SELECT *
36: FROM IGS_AD_CRED_TYPES
37: WHERE rowid = x_rowid;
38:
39: BEGIN
40:

Line 167: Igs_Pe_Credentials_Pkg.Get_FK_Igs_Ad_Cred_Types (

163: ***************************************************************/
164:
165: BEGIN
166:
167: Igs_Pe_Credentials_Pkg.Get_FK_Igs_Ad_Cred_Types (
168: old_references.credential_type_id
169: );
170:
171: END Check_Child_Existance;

Line 219: FROM igs_ad_cred_types

215: ***************************************************************/
216:
217: CURSOR cur_rowid IS
218: SELECT rowid
219: FROM igs_ad_cred_types
220: WHERE credential_type_id = x_credential_type_id AND
221: closed_ind = NVL(x_closed_ind,closed_ind);
222: --FOR UPDATE NOWAIT;
223:

Line 259: FROM igs_ad_cred_types

255: ***************************************************************/
256:
257: CURSOR cur_rowid IS
258: SELECT rowid
259: FROM igs_ad_cred_types
260: WHERE UPPER(credential_type) = UPPER(x_credential_type) AND
261: ((l_rowid is null) or (rowid <> l_rowid)) AND
262: closed_ind = NVL(x_closed_ind,closed_ind);
263: lv_rowid cur_rowid%RowType;

Line 417: cursor C is select ROWID from IGS_AD_CRED_TYPES

413:
414: (reverse chronological order - newest change first)
415: ***************************************************************/
416:
417: cursor C is select ROWID from IGS_AD_CRED_TYPES
418: where CREDENTIAL_TYPE_ID= X_CREDENTIAL_TYPE_ID
419: ;
420: X_LAST_UPDATE_DATE DATE ;
421: X_LAST_UPDATED_BY NUMBER ;

Line 458: insert into IGS_AD_CRED_TYPES (

454: x_created_by=>X_LAST_UPDATED_BY,
455: x_last_update_date=>X_LAST_UPDATE_DATE,
456: x_last_updated_by=>X_LAST_UPDATED_BY,
457: x_last_update_login=>X_LAST_UPDATE_LOGIN);
458: insert into IGS_AD_CRED_TYPES (
459: CREDENTIAL_TYPE_ID
460: ,CREDENTIAL_TYPE
461: ,SYSTEM_TYPE
462: ,DESCRIPTION

Line 519: from IGS_AD_CRED_TYPES

515: , SYSTEM_TYPE
516: , DESCRIPTION
517: , CLOSED_IND
518: , STEP_CODE
519: from IGS_AD_CRED_TYPES
520: where ROWID = X_ROWID
521: for update nowait;
522: tlinfo c1%rowtype;
523: begin

Line 607: update IGS_AD_CRED_TYPES set

603: x_created_by=>X_LAST_UPDATED_BY,
604: x_last_update_date=>X_LAST_UPDATE_DATE,
605: x_last_updated_by=>X_LAST_UPDATED_BY,
606: x_last_update_login=>X_LAST_UPDATE_LOGIN);
607: update IGS_AD_CRED_TYPES set
608: CREDENTIAL_TYPE = NEW_REFERENCES.CREDENTIAL_TYPE,
609: SYSTEM_TYPE = NEW_REFERENCES.SYSTEM_TYPE,
610: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
611: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,

Line 647: cursor c1 is select ROWID from IGS_AD_CRED_TYPES

643:
644: (reverse chronological order - newest change first)
645: ***************************************************************/
646:
647: cursor c1 is select ROWID from IGS_AD_CRED_TYPES
648: where CREDENTIAL_TYPE_ID= X_CREDENTIAL_TYPE_ID
649: ;
650: begin
651: open c1;

Line 696: delete from IGS_AD_CRED_TYPES

692: Before_DML (
693: p_action => 'DELETE',
694: x_rowid => X_ROWID
695: );
696: delete from IGS_AD_CRED_TYPES
697: where ROWID = X_ROWID;
698: if (sql%notfound) then
699: raise no_data_found;
700: end if;

Line 706: END igs_ad_cred_types_pkg;

702: p_action => 'DELETE',
703: x_rowid => X_ROWID
704: );
705: end DELETE_ROW;
706: END igs_ad_cred_types_pkg;