APPS.IGS_AD_RS_VALUES_PKG dependencies on IGS_AD_RS_VALUES

Line 1: PACKAGE BODY igs_ad_rs_values_pkg AS

1: PACKAGE BODY igs_ad_rs_values_pkg AS
2: /* $Header: IGSAI74B.pls 115.10 2003/10/30 13:16:40 akadam ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_rs_values%RowType;
5: new_references igs_ad_rs_values%RowType;

Line 4: old_references igs_ad_rs_values%RowType;

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

Line 5: new_references igs_ad_rs_values%RowType;

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

Line 35: FROM IGS_AD_RS_VALUES

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

Line 175: Igs_Ad_Appl_Eval_Pkg.Get_FK_Igs_Ad_Rs_Values (

171: ***************************************************************/
172:
173: BEGIN
174:
175: Igs_Ad_Appl_Eval_Pkg.Get_FK_Igs_Ad_Rs_Values (
176: old_references.rating_values_id
177: );
178:
179: END Check_Child_Existance;

Line 199: FROM igs_ad_rs_values

195: ***************************************************************/
196:
197: CURSOR cur_rowid IS
198: SELECT rowid
199: FROM igs_ad_rs_values
200: WHERE rating_values_id = x_rating_values_id AND
201: closed_ind = NVL(x_closed_ind,closed_ind)
202: FOR UPDATE NOWAIT;
203:

Line 238: FROM igs_ad_rs_values

234: ***************************************************************/
235:
236: CURSOR cur_rowid IS
237: SELECT rowid
238: FROM igs_ad_rs_values
239: WHERE rating_scale_id = x_rating_scale_id AND
240: rating_value = x_rating_value AND
241: ((l_rowid is null) or (rowid <> l_rowid)) AND
242: closed_ind = NVL(x_closed_ind,closed_ind)

Line 276: FROM igs_ad_rs_values

272: ***************************************************************/
273:
274: CURSOR cur_rowid IS
275: SELECT rowid
276: FROM igs_ad_rs_values
277: WHERE rating_scale_id = x_rating_scale_id ;
278:
279: lv_rowid cur_rowid%RowType;
280:

Line 432: cursor C is select ROWID from IGS_AD_RS_VALUES

428:
429: (reverse chronological order - newest change first)
430: ***************************************************************/
431:
432: cursor C is select ROWID from IGS_AD_RS_VALUES
433: where RATING_VALUES_ID= X_RATING_VALUES_ID;
434: X_LAST_UPDATE_DATE DATE ;
435: X_LAST_UPDATED_BY NUMBER ;
436: X_LAST_UPDATE_LOGIN NUMBER ;

Line 472: insert into IGS_AD_RS_VALUES (

468: x_created_by=>X_LAST_UPDATED_BY,
469: x_last_update_date=>X_LAST_UPDATE_DATE,
470: x_last_updated_by=>X_LAST_UPDATED_BY,
471: x_last_update_login=>X_LAST_UPDATE_LOGIN);
472: insert into IGS_AD_RS_VALUES (
473: RATING_VALUES_ID
474: ,RATING_SCALE_ID
475: ,RATING_VALUE
476: ,DESCRIPTION

Line 484: IGS_AD_RS_VALUES_S.NEXTVAL

480: ,LAST_UPDATE_DATE
481: ,LAST_UPDATED_BY
482: ,LAST_UPDATE_LOGIN
483: ) values (
484: IGS_AD_RS_VALUES_S.NEXTVAL
485: ,NEW_REFERENCES.RATING_SCALE_ID
486: ,NEW_REFERENCES.RATING_VALUE
487: ,NEW_REFERENCES.DESCRIPTION
488: ,NEW_REFERENCES.CLOSED_IND

Line 529: from IGS_AD_RS_VALUES

525: RATING_SCALE_ID
526: , RATING_VALUE
527: , DESCRIPTION
528: , CLOSED_IND
529: from IGS_AD_RS_VALUES
530: where ROWID = X_ROWID
531: for update nowait;
532: tlinfo c1%rowtype;
533: begin

Line 612: update IGS_AD_RS_VALUES set

608: x_created_by=>X_LAST_UPDATED_BY,
609: x_last_update_date=>X_LAST_UPDATE_DATE,
610: x_last_updated_by=>X_LAST_UPDATED_BY,
611: x_last_update_login=>X_LAST_UPDATE_LOGIN);
612: update IGS_AD_RS_VALUES set
613: RATING_SCALE_ID = NEW_REFERENCES.RATING_SCALE_ID,
614: RATING_VALUE = NEW_REFERENCES.RATING_VALUE,
615: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
616: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,

Line 650: cursor c1 is select ROWID from IGS_AD_RS_VALUES

646:
647: (reverse chronological order - newest change first)
648: ***************************************************************/
649:
650: cursor c1 is select ROWID from IGS_AD_RS_VALUES
651: where RATING_VALUES_ID= X_RATING_VALUES_ID
652: ;
653: begin
654: open c1;

Line 697: delete from IGS_AD_RS_VALUES

693: Before_DML (
694: p_action => 'DELETE',
695: x_rowid => X_ROWID
696: );
697: delete from IGS_AD_RS_VALUES
698: where ROWID = X_ROWID;
699: if (sql%notfound) then
700: raise no_data_found;
701: end if;

Line 707: END igs_ad_rs_values_pkg;

703: p_action => 'DELETE',
704: x_rowid => X_ROWID
705: );
706: end DELETE_ROW;
707: END igs_ad_rs_values_pkg;