DBA Data[Home] [Help]

APPS.IGS_RU_TURIN_RULE_GR_PKG dependencies on IGS_RU_TURIN_RULE_GR

Line 1: PACKAGE BODY igs_ru_turin_rule_gr_pkg AS

1: PACKAGE BODY igs_ru_turin_rule_gr_pkg AS
2: /* $Header: IGSUI19B.pls 115.8 2002/11/29 04:30:05 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ru_turin_rule_gr%RowType;
5: new_references igs_ru_turin_rule_gr%RowType;

Line 4: old_references igs_ru_turin_rule_gr%RowType;

1: PACKAGE BODY igs_ru_turin_rule_gr_pkg AS
2: /* $Header: IGSUI19B.pls 115.8 2002/11/29 04:30:05 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ru_turin_rule_gr%RowType;
5: new_references igs_ru_turin_rule_gr%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ru_turin_rule_gr%RowType;

1: PACKAGE BODY igs_ru_turin_rule_gr_pkg AS
2: /* $Header: IGSUI19B.pls 115.8 2002/11/29 04:30:05 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ru_turin_rule_gr%RowType;
5: new_references igs_ru_turin_rule_gr%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 ,

Line 34: FROM IGS_RU_TURIN_RULE_GR

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

Line 48: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_TURIN_RULE_GR : P_ACTION INSERT, VALIDATE_INSERT : IGSUI19B.PLS');

44: Fetch cur_old_ref_values INTO old_references;
45: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
46: Close cur_old_ref_values;
47: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
48: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_TURIN_RULE_GR : P_ACTION INSERT, VALIDATE_INSERT : IGSUI19B.PLS');
49: IGS_GE_MSG_STACK.ADD;
50: App_Exception.Raise_Exception;
51: Return;
52: END IF;

Line 193: FROM igs_ru_turin_rule_gr

189: ***************************************************************/
190:
191: CURSOR cur_rowid IS
192: SELECT rowid
193: FROM igs_ru_turin_rule_gr
194: WHERE group_cd = x_group_cd
195: AND name_cd = x_name_cd
196: FOR UPDATE NOWAIT;
197:

Line 230: FROM igs_ru_turin_rule_gr

226: ***************************************************************/
227:
228: CURSOR cur_rowid IS
229: SELECT rowid
230: FROM igs_ru_turin_rule_gr
231: WHERE rug_sequence_number = x_rug_sequence_number and ((l_rowid is null) or (rowid <> l_rowid))
232:
233: ;
234: lv_rowid cur_rowid%RowType;

Line 266: FROM igs_ru_turin_rule_gr

262: ***************************************************************/
263:
264: CURSOR cur_rowid IS
265: SELECT rowid
266: FROM igs_ru_turin_rule_gr
267: WHERE rug_sequence_number = x_sequence_number ;
268:
269: lv_rowid cur_rowid%RowType;
270:

Line 303: FROM igs_ru_turin_rule_gr

299: ***************************************************************/
300:
301: CURSOR cur_rowid IS
302: SELECT rowid
303: FROM igs_ru_turin_rule_gr
304: WHERE group_cd = x_group_cd ;
305:
306: lv_rowid cur_rowid%RowType;
307:

Line 459: cursor C is select ROWID from IGS_RU_TURIN_RULE_GR

455:
456: (reverse chronological order - newest change first)
457: ***************************************************************/
458:
459: cursor C is select ROWID from IGS_RU_TURIN_RULE_GR
460: where GROUP_CD= X_GROUP_CD
461: and NAME_CD = X_NAME_CD
462: ;
463: X_LAST_UPDATE_DATE DATE ;

Line 497: insert into IGS_RU_TURIN_RULE_GR (

493: x_created_by=>X_LAST_UPDATED_BY,
494: x_last_update_date=>X_LAST_UPDATE_DATE,
495: x_last_updated_by=>X_LAST_UPDATED_BY,
496: x_last_update_login=>X_LAST_UPDATE_LOGIN);
497: insert into IGS_RU_TURIN_RULE_GR (
498: GROUP_CD
499: ,NAME_CD
500: ,DESCRIPTION
501: ,RUG_SEQUENCE_NUMBER

Line 550: from IGS_RU_TURIN_RULE_GR

546:
547: cursor c1 is select
548: DESCRIPTION
549: , RUG_SEQUENCE_NUMBER
550: from IGS_RU_TURIN_RULE_GR
551: where ROWID = X_ROWID
552: for update nowait;
553: tlinfo c1%rowtype;
554: begin

Line 559: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_TURIN_RULE_GR : P_ACTION LOCK_ROW : IGSUI19B.PLS');

555: open c1;
556: fetch c1 into tlinfo;
557: if (c1%notfound) then
558: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
559: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_TURIN_RULE_GR : P_ACTION LOCK_ROW : IGSUI19B.PLS');
560: IGS_GE_MSG_STACK.ADD;
561: close c1;
562: app_exception.raise_exception;
563: return;

Line 572: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_TURIN_RULE_GR : P_ACTION LOCK_ROW FORM_RECORD_CHANGED : IGSUI19B.PLS');

568: ) then
569: null;
570: else
571: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
572: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_TURIN_RULE_GR : P_ACTION LOCK_ROW FORM_RECORD_CHANGED : IGSUI19B.PLS');
573: IGS_GE_MSG_STACK.ADD;
574: app_exception.raise_exception;
575: end if;
576: return;

Line 632: update IGS_RU_TURIN_RULE_GR set

628: x_created_by=>X_LAST_UPDATED_BY,
629: x_last_update_date=>X_LAST_UPDATE_DATE,
630: x_last_updated_by=>X_LAST_UPDATED_BY,
631: x_last_update_login=>X_LAST_UPDATE_LOGIN);
632: update IGS_RU_TURIN_RULE_GR set
633: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
634: RUG_SEQUENCE_NUMBER = NEW_REFERENCES.RUG_SEQUENCE_NUMBER,
635: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
636: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 668: cursor c1 is select ROWID from IGS_RU_TURIN_RULE_GR

664:
665: (reverse chronological order - newest change first)
666: ***************************************************************/
667:
668: cursor c1 is select ROWID from IGS_RU_TURIN_RULE_GR
669: where GROUP_CD= X_GROUP_CD
670: and NAME_CD = X_NAME_CD
671: ;
672: begin

Line 715: delete from IGS_RU_TURIN_RULE_GR

711: Before_DML (
712: p_action => 'DELETE',
713: x_rowid => X_ROWID
714: );
715: delete from IGS_RU_TURIN_RULE_GR
716: where ROWID = X_ROWID;
717: if (sql%notfound) then
718: raise no_data_found;
719: end if;

Line 725: END igs_ru_turin_rule_gr_pkg;

721: p_action => 'DELETE',
722: x_rowid => X_ROWID
723: );
724: end DELETE_ROW;
725: END igs_ru_turin_rule_gr_pkg;