APPS.IGS_AD_INTERFACE_CTL_PKG dependencies on IGS_AD_INTERFACE_CTL

Line 1: PACKAGE BODY igs_ad_interface_ctl_pkg AS

1: PACKAGE BODY igs_ad_interface_ctl_pkg AS
2: /* $Header: IGSAIA8B.pls 115.15 2003/12/09 12:45:08 pbondugu ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_INTERFACE_CTL%RowType;
5: new_references IGS_AD_INTERFACE_CTL%RowType;

Line 4: old_references IGS_AD_INTERFACE_CTL%RowType;

1: PACKAGE BODY igs_ad_interface_ctl_pkg AS
2: /* $Header: IGSAIA8B.pls 115.15 2003/12/09 12:45:08 pbondugu ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_INTERFACE_CTL%RowType;
5: new_references IGS_AD_INTERFACE_CTL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_AD_INTERFACE_CTL%RowType;

1: PACKAGE BODY igs_ad_interface_ctl_pkg AS
2: /* $Header: IGSAIA8B.pls 115.15 2003/12/09 12:45:08 pbondugu ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_INTERFACE_CTL%RowType;
5: new_references IGS_AD_INTERFACE_CTL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 ,

Line 35: FROM IGS_AD_INTERFACE_CTL

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

Line 173: FROM IGS_AD_INTERFACE_CTL

169: ***************************************************************/
170:
171: CURSOR cur_rowid IS
172: SELECT rowid
173: FROM IGS_AD_INTERFACE_CTL
174: WHERE interface_run_id = x_interface_run_id
175: FOR UPDATE NOWAIT;
176:
177: lv_rowid cur_rowid%RowType;

Line 211: FROM IGS_AD_INTERFACE_CTL

207: ***************************************************************/
208:
209: CURSOR cur_rowid IS
210: SELECT rowid
211: FROM IGS_AD_INTERFACE_CTL
212: WHERE source_type_id = x_source_type_id ;
213:
214: lv_rowid cur_rowid%RowType;
215:

Line 248: FROM IGS_AD_INTERFACE_CTL

244: ***************************************************************/
245:
246: CURSOR cur_rowid IS
247: SELECT rowid
248: FROM IGS_AD_INTERFACE_CTL
249: WHERE match_set_id = x_match_set_id ;
250:
251: lv_rowid cur_rowid%RowType;
252:

Line 398: cursor C is select ROWID from IGS_AD_INTERFACE_CTL

394: rrengara 4-OCT-2002 Passed null to admission category, calendar instance, person type and funnel status for the Build 2604395
395: (reverse chronological order - newest change first)
396: ***************************************************************/
397:
398: cursor C is select ROWID from IGS_AD_INTERFACE_CTL
399: where INTERFACE_RUN_ID= X_INTERFACE_RUN_ID;
400:
401: X_LAST_UPDATE_DATE DATE ;
402: X_LAST_UPDATED_BY NUMBER ;

Line 455: INSERT INTO IGS_AD_INTERFACE_CTL (

451: x_last_updated_by=>X_LAST_UPDATED_BY,
452: x_last_update_login=>X_LAST_UPDATE_LOGIN
453: );
454:
455: INSERT INTO IGS_AD_INTERFACE_CTL (
456: INTERFACE_RUN_ID
457: ,SOURCE_TYPE_ID
458: ,BATCH_ID
459: ,MATCH_SET_ID

Line 471: IGS_AD_INTERFACE_CTL_S.NEXTVAL

467: ,PROGRAM_ID
468: ,PROGRAM_APPLICATION_ID
469: ,PROGRAM_UPDATE_DATE
470: ) values (
471: IGS_AD_INTERFACE_CTL_S.NEXTVAL
472: ,NEW_REFERENCES.SOURCE_TYPE_ID
473: ,NEW_REFERENCES.BATCH_ID
474: ,NEW_REFERENCES.MATCH_SET_ID
475: ,NEW_REFERENCES.STATUS

Line 524: FROM IGS_AD_INTERFACE_CTL

520: SOURCE_TYPE_ID,
521: BATCH_ID,
522: MATCH_SET_ID,
523: STATUS
524: FROM IGS_AD_INTERFACE_CTL
525: WHERE ROWID = X_ROWID
526: for update nowait;
527:
528: tlinfo c1%rowtype;

Line 635: update IGS_AD_INTERFACE_CTL set

631: X_PROGRAM_UPDATE_DATE := SYSDATE;
632: end if;
633: end if;
634:
635: update IGS_AD_INTERFACE_CTL set
636: SOURCE_TYPE_ID = NEW_REFERENCES.SOURCE_TYPE_ID,
637: BATCH_ID = NEW_REFERENCES.BATCH_ID,
638: MATCH_SET_ID = NEW_REFERENCES.MATCH_SET_ID,
639: STATUS = NEW_REFERENCES.STATUS,

Line 679: cursor c1 is select ROWID from IGS_AD_INTERFACE_CTL

675:
676: (reverse chronological order - newest change first)
677: ***************************************************************/
678:
679: cursor c1 is select ROWID from IGS_AD_INTERFACE_CTL
680: where INTERFACE_RUN_ID= X_INTERFACE_RUN_ID;
681:
682: begin
683: open c1;

Line 729: delete from IGS_AD_INTERFACE_CTL

725: Before_DML (
726: p_action => 'DELETE',
727: x_rowid => X_ROWID
728: );
729: delete from IGS_AD_INTERFACE_CTL
730: where ROWID = X_ROWID;
731: if (sql%notfound) then
732: raise no_data_found;
733: end if;

Line 742: END igs_ad_interface_ctl_pkg;

738: );
739:
740: end DELETE_ROW;
741:
742: END igs_ad_interface_ctl_pkg;