APPS.IGS_PE_MTCH_SET_DATA_PKG dependencies on IGS_PE_MTCH_SET_DATA_ALL

Line 4: old_references igs_pe_mtch_set_data_all%RowType;

1: PACKAGE BODY igs_pe_mtch_set_data_pkg AS
2: /* $Header: IGSNI67B.pls 115.7 2002/11/29 01:29:01 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_pe_mtch_set_data_all%RowType;
5: new_references igs_pe_mtch_set_data_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_pe_mtch_set_data_all%RowType;

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

Line 38: FROM igs_pe_mtch_set_data_all

34: ***************************************************************/
35:
36: CURSOR cur_old_ref_values IS
37: SELECT *
38: FROM igs_pe_mtch_set_data_all
39: WHERE rowid = x_rowid;
40:
41: BEGIN
42:

Line 158: FROM igs_pe_mtch_set_data_all

154: ***************************************************************/
155:
156: CURSOR cur_rowid IS
157: SELECT rowid
158: FROM igs_pe_mtch_set_data_all
159: WHERE match_set_data_id = x_match_set_data_id
160: FOR UPDATE NOWAIT;
161:
162: lv_rowid cur_rowid%RowType;

Line 314: cursor C is select ROWID from igs_pe_mtch_set_data_all

310: sraj 17-MAY-2000 Two Columns have added to this table.
311: (reverse chronological order - newest change first)
312: ***************************************************************/
313:
314: cursor C is select ROWID from igs_pe_mtch_set_data_all
315: where MATCH_SET_DATA_ID= X_MATCH_SET_DATA_ID;
316:
317: X_LAST_UPDATE_DATE DATE ;
318: X_LAST_UPDATED_BY NUMBER ;

Line 361: insert into igs_pe_mtch_set_data_all (

357: x_last_updated_by=>X_LAST_UPDATED_BY,
358: x_last_update_login=>X_LAST_UPDATE_LOGIN,
359: x_org_id=>igs_ge_gen_003.get_org_id
360: );
361: insert into igs_pe_mtch_set_data_all (
362: MATCH_SET_DATA_ID
363: ,MATCH_SET_ID
364: ,DATA_ELEMENT
365: ,VALUE

Line 429: from igs_pe_mtch_set_data_all

425: , VALUE
426: , EXACT_INCLUDE
427: , PARTIAL_INCLUDE
428: , DROP_IF_NULL
429: from igs_pe_mtch_set_data_all
430: where ROWID = X_ROWID
431: for update nowait;
432: tlinfo c1%rowtype;
433: begin

Line 523: update igs_pe_mtch_set_data_all set

519: x_last_update_date=>X_LAST_UPDATE_DATE,
520: x_last_updated_by=>X_LAST_UPDATED_BY,
521: x_last_update_login=>X_LAST_UPDATE_LOGIN
522: );
523: update igs_pe_mtch_set_data_all set
524: MATCH_SET_ID = NEW_REFERENCES.MATCH_SET_ID,
525: DATA_ELEMENT = NEW_REFERENCES.DATA_ELEMENT,
526: VALUE = NEW_REFERENCES.VALUE,
527: EXACT_INCLUDE = NEW_REFERENCES.EXACT_INCLUDE,

Line 566: cursor c1 is select ROWID from igs_pe_mtch_set_data_all

562: sraj 17-MAY-2000 Two Columns have added to this table.
563: (reverse chronological order - newest change first)
564: ***************************************************************/
565:
566: cursor c1 is select ROWID from igs_pe_mtch_set_data_all
567: where MATCH_SET_DATA_ID= X_MATCH_SET_DATA_ID
568: ;
569: begin
570: open c1;

Line 620: delete from igs_pe_mtch_set_data_all

616: Before_DML (
617: p_action => 'DELETE',
618: x_rowid => X_ROWID
619: );
620: delete from igs_pe_mtch_set_data_all
621: where ROWID = X_ROWID;
622: if (sql%notfound) then
623: raise no_data_found;
624: end if;