APPS.IGS_PE_DATA_ELEMENT_PKG dependencies on IGS_PE_DATA_ELEMENT

Line 1: PACKAGE BODY igs_pe_data_element_pkg AS

1: PACKAGE BODY igs_pe_data_element_pkg AS
2: /* $Header: IGSNI44B.pls 115.6 2002/11/29 01:24:20 nsidana ship $ */
3: /*************************************************************
4: Created By : nalkumar
5: Date Created By : 2000/05/11

Line 14: old_references igs_pe_data_element%RowType;

10:
11: (reverse chronological order - newest change first)
12: ***************************************************************/
13: l_rowid VARCHAR2(25);
14: old_references igs_pe_data_element%RowType;
15: new_references igs_pe_data_element%RowType;
16:
17: PROCEDURE Set_Column_Values (
18: p_action IN VARCHAR2,

Line 15: new_references igs_pe_data_element%RowType;

11: (reverse chronological order - newest change first)
12: ***************************************************************/
13: l_rowid VARCHAR2(25);
14: old_references igs_pe_data_element%RowType;
15: new_references igs_pe_data_element%RowType;
16:
17: PROCEDURE Set_Column_Values (
18: p_action IN VARCHAR2,
19: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 43: FROM IGS_PE_DATA_ELEMENT

39: ***************************************************************/
40:
41: CURSOR cur_old_ref_values IS
42: SELECT *
43: FROM IGS_PE_DATA_ELEMENT
44: WHERE rowid = x_rowid;
45:
46: BEGIN
47:

Line 120: Igs_Pe_Stup_Data_Emt_Pkg.Get_FK_Igs_Pe_Data_Element (

116: ***************************************************************/
117:
118: BEGIN
119:
120: Igs_Pe_Stup_Data_Emt_Pkg.Get_FK_Igs_Pe_Data_Element (
121: old_references.data_element
122: );
123:
124: END Check_Child_Existance;

Line 143: FROM igs_pe_data_element

139: ***************************************************************/
140:
141: CURSOR cur_rowid IS
142: SELECT rowid
143: FROM igs_pe_data_element
144: WHERE data_element = x_data_element
145: FOR UPDATE NOWAIT;
146:
147: lv_rowid cur_rowid%RowType;

Line 285: cursor C is select ROWID from IGS_PE_DATA_ELEMENT

281:
282: (reverse chronological order - newest change first)
283: ***************************************************************/
284:
285: cursor C is select ROWID from IGS_PE_DATA_ELEMENT
286: where DATA_ELEMENT= X_DATA_ELEMENT
287: ;
288: X_LAST_UPDATE_DATE DATE ;
289: X_LAST_UPDATED_BY NUMBER ;

Line 321: insert into IGS_PE_DATA_ELEMENT (

317: x_created_by=>X_LAST_UPDATED_BY,
318: x_last_update_date=>X_LAST_UPDATE_DATE,
319: x_last_updated_by=>X_LAST_UPDATED_BY,
320: x_last_update_login=>X_LAST_UPDATE_LOGIN);
321: insert into IGS_PE_DATA_ELEMENT (
322: DATA_ELEMENT
323: ,TABLE_NAME
324: ,COLUMN_NAME
325: ,CREATION_DATE

Line 370: from IGS_PE_DATA_ELEMENT

366:
367: cursor c1 is select
368: TABLE_NAME
369: , COLUMN_NAME
370: from IGS_PE_DATA_ELEMENT
371: where ROWID = X_ROWID
372: for update nowait;
373: tlinfo c1%rowtype;
374: begin

Line 447: update IGS_PE_DATA_ELEMENT set

443: x_created_by=>X_LAST_UPDATED_BY,
444: x_last_update_date=>X_LAST_UPDATE_DATE,
445: x_last_updated_by=>X_LAST_UPDATED_BY,
446: x_last_update_login=>X_LAST_UPDATE_LOGIN);
447: update IGS_PE_DATA_ELEMENT set
448: TABLE_NAME = NEW_REFERENCES.TABLE_NAME,
449: COLUMN_NAME = NEW_REFERENCES.COLUMN_NAME,
450: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
451: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 481: cursor c1 is select ROWID from IGS_PE_DATA_ELEMENT

477:
478: (reverse chronological order - newest change first)
479: ***************************************************************/
480:
481: cursor c1 is select ROWID from IGS_PE_DATA_ELEMENT
482: where DATA_ELEMENT= X_DATA_ELEMENT
483: ;
484: begin
485: open c1;

Line 524: delete from IGS_PE_DATA_ELEMENT

520: Before_DML (
521: p_action => 'DELETE',
522: x_rowid => X_ROWID
523: );
524: delete from IGS_PE_DATA_ELEMENT
525: where ROWID = X_ROWID;
526: if (sql%notfound) then
527: raise no_data_found;
528: end if;

Line 534: END igs_pe_data_element_pkg;

530: p_action => 'DELETE',
531: x_rowid => X_ROWID
532: );
533: end DELETE_ROW;
534: END igs_pe_data_element_pkg;