APPS.IGS_AD_RATING_SCALES_PKG dependencies on IGS_AD_RATING_SCALES

Line 1: PACKAGE BODY igs_ad_rating_scales_pkg AS

1: PACKAGE BODY igs_ad_rating_scales_pkg AS
2: /* $Header: IGSAI73B.pls 115.14 2003/10/30 13:16:37 akadam ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_rating_scales%RowType;
5: new_references igs_ad_rating_scales%RowType;

Line 4: old_references igs_ad_rating_scales%RowType;

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

Line 5: new_references igs_ad_rating_scales%RowType;

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

Line 37: FROM IGS_AD_RATING_SCALES

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

Line 163: Igs_Ad_Rs_Values_Pkg.Get_FK_Igs_Ad_Rating_Scales (

159: ***************************************************************/
160:
161: BEGIN
162:
163: Igs_Ad_Rs_Values_Pkg.Get_FK_Igs_Ad_Rating_Scales (
164: old_references.rating_scale_id
165: );
166:
167: END Check_Child_Existance;

Line 187: FROM igs_ad_rating_scales

183: ***************************************************************/
184:
185: CURSOR cur_rowid IS
186: SELECT rowid
187: FROM igs_ad_rating_scales
188: WHERE rating_scale_id = x_rating_scale_id AND
189: closed_ind = NVL(x_closed_ind,closed_ind)
190: FOR UPDATE NOWAIT;
191:

Line 225: FROM igs_ad_rating_scales

221: ***************************************************************/
222:
223: CURSOR cur_rowid IS
224: SELECT rowid
225: FROM igs_ad_rating_scales
226: WHERE rating_scale_name = x_rating_scale_name AND
227: ((l_rowid is null) or (rowid <> l_rowid)) AND
228: closed_ind = NVL(x_closed_ind,closed_ind)
229:

Line 386: cursor C is select ROWID from IGS_AD_RATING_SCALES

382:
383: (reverse chronological order - newest change first)
384: ***************************************************************/
385:
386: cursor C is select ROWID from IGS_AD_RATING_SCALES
387: where RATING_SCALE_ID= X_RATING_SCALE_ID
388: ;
389: X_LAST_UPDATE_DATE DATE ;
390: X_LAST_UPDATED_BY NUMBER ;

Line 428: insert into IGS_AD_RATING_SCALES (

424: x_last_updated_by=>X_LAST_UPDATED_BY,
425: x_last_update_login=>X_LAST_UPDATE_LOGIN,
426: x_start_date => X_START_DATE,
427: x_end_date => X_END_DATE);
428: insert into IGS_AD_RATING_SCALES (
429: RATING_SCALE_ID
430: ,RATING_SCALE_NAME
431: ,DESCRIPTION
432: ,CLOSED_IND

Line 443: IGS_AD_RATING_SCALES_S.NEXTVAL

439: ,START_DATE
440: ,END_DATE
441:
442: ) values (
443: IGS_AD_RATING_SCALES_S.NEXTVAL
444: ,NEW_REFERENCES.RATING_SCALE_NAME
445: ,NEW_REFERENCES.DESCRIPTION
446: ,NEW_REFERENCES.CLOSED_IND
447: ,NEW_REFERENCES.DFLT

Line 492: from IGS_AD_RATING_SCALES

488: RATING_SCALE_NAME
489: , DESCRIPTION
490: , CLOSED_IND
491: , DFLT
492: from IGS_AD_RATING_SCALES
493: where ROWID = X_ROWID
494: for update nowait;
495: tlinfo c1%rowtype;
496: begin

Line 579: update IGS_AD_RATING_SCALES set

575: x_last_updated_by=>X_LAST_UPDATED_BY,
576: x_last_update_login=>X_LAST_UPDATE_LOGIN,
577: x_start_date =>X_START_DATE,
578: x_end_date=> X_END_DATE);
579: update IGS_AD_RATING_SCALES set
580: RATING_SCALE_NAME = NEW_REFERENCES.RATING_SCALE_NAME,
581: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
582: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
583: DFLT = NEW_REFERENCES.DFLT,

Line 621: cursor c1 is select ROWID from IGS_AD_RATING_SCALES

617:
618: (reverse chronological order - newest change first)
619: ***************************************************************/
620:
621: cursor c1 is select ROWID from IGS_AD_RATING_SCALES
622: where RATING_SCALE_ID= X_RATING_SCALE_ID
623: ;
624: begin
625: open c1;

Line 672: delete from IGS_AD_RATING_SCALES

668: Before_DML (
669: p_action => 'DELETE',
670: x_rowid => X_ROWID
671: );
672: delete from IGS_AD_RATING_SCALES
673: where ROWID = X_ROWID;
674: if (sql%notfound) then
675: raise no_data_found;
676: end if;

Line 682: END igs_ad_rating_scales_pkg;

678: p_action => 'DELETE',
679: x_rowid => X_ROWID
680: );
681: end DELETE_ROW;
682: END igs_ad_rating_scales_pkg;