APPS.IGS_PE_STUP_DATA_EMT_PKG dependencies on IGS_PE_STUP_DATA_EMT_ALL

Line 4: old_references igs_pe_stup_data_emt_all%RowType;

1: PACKAGE BODY igs_pe_stup_data_emt_pkg AS
2: /* $Header: IGSNI45B.pls 115.8 2002/11/29 01:24:36 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_pe_stup_data_emt_all%RowType;
5: new_references igs_pe_stup_data_emt_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_pe_stup_data_emt_all%RowType;

1: PACKAGE BODY igs_pe_stup_data_emt_pkg AS
2: /* $Header: IGSNI45B.pls 115.8 2002/11/29 01:24:36 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_pe_stup_data_emt_all%RowType;
5: new_references igs_pe_stup_data_emt_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 36: FROM igs_pe_stup_data_emt_all

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

Line 169: FROM igs_pe_stup_data_emt_all

165: ***************************************************************/
166:
167: CURSOR cur_rowid IS
168: SELECT rowid
169: FROM igs_pe_stup_data_emt_all
170: WHERE setup_data_element_id = x_setup_data_element_id
171: FOR UPDATE NOWAIT;
172:
173: lv_rowid cur_rowid%RowType;

Line 205: FROM igs_pe_stup_data_emt_all

201: ***************************************************************/
202:
203: CURSOR cur_rowid IS
204: SELECT rowid
205: FROM igs_pe_stup_data_emt_all
206: WHERE person_type_code = x_person_type_code ;
207:
208: lv_rowid cur_rowid%RowType;
209:

Line 242: FROM igs_pe_stup_data_emt_all

238: ***************************************************************/
239:
240: CURSOR cur_rowid IS
241: SELECT rowid
242: FROM igs_pe_stup_data_emt_all
243: WHERE data_element = x_data_element ;
244:
245: lv_rowid cur_rowid%RowType;
246:

Line 395: cursor C is select ROWID from igs_pe_stup_data_emt_all

391:
392: (reverse chronological order - newest change first)
393: ***************************************************************/
394:
395: cursor C is select ROWID from igs_pe_stup_data_emt_all
396: where SETUP_DATA_ELEMENT_ID= X_SETUP_DATA_ELEMENT_ID
397: ;
398: X_LAST_UPDATE_DATE DATE ;
399: X_LAST_UPDATED_BY NUMBER ;

Line 439: insert into igs_pe_stup_data_emt_all (

435: x_last_updated_by=>X_LAST_UPDATED_BY,
436: x_last_update_login=>X_LAST_UPDATE_LOGIN,
437: x_org_id=>igs_ge_gen_003.get_org_id
438: );
439: insert into igs_pe_stup_data_emt_all (
440: SETUP_DATA_ELEMENT_ID
441: ,PERSON_TYPE_CODE
442: ,DATA_ELEMENT
443: ,VALUE

Line 500: from igs_pe_stup_data_emt_all

496: PERSON_TYPE_CODE
497: , DATA_ELEMENT
498: , VALUE
499: , REQUIRED_IND
500: from igs_pe_stup_data_emt_all
501: where ROWID = X_ROWID
502: for update nowait;
503: tlinfo c1%rowtype;
504: begin

Line 589: update igs_pe_stup_data_emt_all set

585: x_last_update_date=>X_LAST_UPDATE_DATE,
586: x_last_updated_by=>X_LAST_UPDATED_BY,
587: x_last_update_login=>X_LAST_UPDATE_LOGIN
588: );
589: update igs_pe_stup_data_emt_all set
590: PERSON_TYPE_CODE = NEW_REFERENCES.PERSON_TYPE_CODE,
591: DATA_ELEMENT = NEW_REFERENCES.DATA_ELEMENT,
592: VALUE = NEW_REFERENCES.VALUE,
593: REQUIRED_IND = NEW_REFERENCES.REQUIRED_IND,

Line 629: cursor c1 is select ROWID from igs_pe_stup_data_emt_all

625:
626: (reverse chronological order - newest change first)
627: ***************************************************************/
628:
629: cursor c1 is select ROWID from igs_pe_stup_data_emt_all
630: where SETUP_DATA_ELEMENT_ID= X_SETUP_DATA_ELEMENT_ID
631: ;
632: begin
633: open c1;

Line 679: delete from igs_pe_stup_data_emt_all

675: Before_DML (
676: p_action => 'DELETE',
677: x_rowid => X_ROWID
678: );
679: delete from igs_pe_stup_data_emt_all
680: where ROWID = X_ROWID;
681: if (sql%notfound) then
682: raise no_data_found;
683: end if;