eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_RU_ITEM_PKG dependencies on IGS_RU_ITEM

Line 1: package body IGS_RU_ITEM_PKG as

1: package body IGS_RU_ITEM_PKG as
2: /* $Header: IGSUI07B.pls 120.2 2006/02/20 04:34:17 sarakshi noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RU_ITEM%RowType;

Line 5: old_references IGS_RU_ITEM%RowType;

1: package body IGS_RU_ITEM_PKG as
2: /* $Header: IGSUI07B.pls 120.2 2006/02/20 04:34:17 sarakshi noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RU_ITEM%RowType;
6: new_references IGS_RU_ITEM%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_RU_ITEM%RowType;

2: /* $Header: IGSUI07B.pls 120.2 2006/02/20 04:34:17 sarakshi noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RU_ITEM%RowType;
6: new_references IGS_RU_ITEM%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 28: FROM IGS_RU_ITEM

24: ) as
25:
26: CURSOR cur_old_ref_values IS
27: SELECT *
28: FROM IGS_RU_ITEM
29: WHERE rowid = x_rowid;
30:
31: BEGIN
32:

Line 41: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_ITEM : P_ACTION INSERT VALIDATE_INSERT : IGSUI07B.PLS');

37: Open cur_old_ref_values;
38: Fetch cur_old_ref_values INTO old_references;
39: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
40: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
41: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_ITEM : P_ACTION INSERT VALIDATE_INSERT : IGSUI07B.PLS');
42: IGS_GE_MSG_STACK.ADD;
43: App_Exception.Raise_Exception;
44: Close cur_old_ref_values;
45: Return;

Line 213: FROM IGS_RU_ITEM

209: ) RETURN BOOLEAN
210: as
211: CURSOR cur_rowid IS
212: SELECT rowid
213: FROM IGS_RU_ITEM
214: WHERE rul_sequence_number = x_rul_sequence_number
215: AND item = x_item
216: FOR UPDATE NOWAIT;
217:

Line 239: FROM IGS_RU_ITEM

235: )as
236:
237: CURSOR cur_rowid IS
238: SELECT rowid
239: FROM IGS_RU_ITEM
240: WHERE named_rule = x_rul_sequence_number ;
241:
242: lv_rowid cur_rowid%RowType;
243:

Line 265: FROM IGS_RU_ITEM

261: )as
262:
263: CURSOR cur_rowid IS
264: SELECT rowid
265: FROM IGS_RU_ITEM
266: WHERE rul_sequence_number = x_sequence_number
267: OR rule_number = x_sequence_number ;
268:
269: lv_rowid cur_rowid%RowType;

Line 292: FROM IGS_RU_ITEM

288: )as
289:
290: CURSOR cur_rowid IS
291: SELECT rowid
292: FROM IGS_RU_ITEM
293: WHERE set_number = x_sequence_number ;
294:
295: lv_rowid cur_rowid%RowType;
296:

Line 318: FROM IGS_RU_ITEM

314: )as
315:
316: CURSOR cur_rowid IS
317: SELECT rowid
318: FROM IGS_RU_ITEM
319: WHERE derived_rule = x_rud_sequence_number ;
320:
321: lv_rowid cur_rowid%RowType;
322:

Line 344: FROM IGS_RU_ITEM

340: )as
341:
342: CURSOR cur_rowid IS
343: SELECT rowid
344: FROM IGS_RU_ITEM
345: WHERE turin_function = x_s_turin_function ;
346:
347: lv_rowid cur_rowid%RowType;
348:

Line 454: cursor C is select ROWID from IGS_RU_ITEM

450: X_VALUE in VARCHAR2,
451: X_DERIVED_RULE in NUMBER,
452: X_MODE in VARCHAR2
453: )as
454: cursor C is select ROWID from IGS_RU_ITEM
455: where RUL_SEQUENCE_NUMBER = X_RUL_SEQUENCE_NUMBER
456: and ITEM = X_ITEM;
457: X_LAST_UPDATE_DATE DATE;
458: X_LAST_UPDATED_BY NUMBER;

Line 498: insert into IGS_RU_ITEM (

494: x_last_updated_by=>X_LAST_UPDATED_BY,
495: x_last_update_login=>X_LAST_UPDATE_LOGIN
496: );
497:
498: insert into IGS_RU_ITEM (
499: RUL_SEQUENCE_NUMBER,
500: ITEM,
501: TURIN_FUNCTION,
502: NAMED_RULE,

Line 560: from IGS_RU_ITEM

556: RULE_NUMBER,
557: SET_NUMBER,
558: VALUE,
559: DERIVED_RULE
560: from IGS_RU_ITEM
561: where ROWID = X_ROWID for update nowait;
562: tlinfo c1%rowtype;
563:
564: begin

Line 569: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_ITEM : P_ACTION LOCK_ROW : IGSUI07B.PLS');

565: open c1;
566: fetch c1 into tlinfo;
567: if (c1%notfound) then
568: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
569: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_ITEM : P_ACTION LOCK_ROW : IGSUI07B.PLS');
570: IGS_GE_MSG_STACK.ADD;
571: app_exception.raise_exception;
572: close c1;
573: return;

Line 599: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_ITEM : P_ACTION LOCK_ROW FORM_RECORD_CHANGED : IGSUI07B.PLS');

595: ) then
596: null;
597: else
598: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
599: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_ITEM : P_ACTION LOCK_ROW FORM_RECORD_CHANGED : IGSUI07B.PLS');
600: IGS_GE_MSG_STACK.ADD;
601: app_exception.raise_exception;
602: end if;
603: return;

Line 659: update IGS_RU_ITEM set

655: x_last_updated_by=>X_LAST_UPDATED_BY,
656: x_last_update_login=>X_LAST_UPDATE_LOGIN
657: );
658:
659: update IGS_RU_ITEM set
660: TURIN_FUNCTION = NEW_REFERENCES.TURIN_FUNCTION,
661: NAMED_RULE = NEW_REFERENCES.NAMED_RULE,
662: RULE_NUMBER = NEW_REFERENCES.RULE_NUMBER,
663: SET_NUMBER = NEW_REFERENCES.SET_NUMBER,

Line 693: cursor c1 is select rowid from IGS_RU_ITEM

689: X_VALUE in VARCHAR2,
690: X_DERIVED_RULE in NUMBER,
691: X_MODE in VARCHAR2
692: )as
693: cursor c1 is select rowid from IGS_RU_ITEM
694: where RUL_SEQUENCE_NUMBER = X_RUL_SEQUENCE_NUMBER
695: and ITEM = X_ITEM
696: ;
697: begin

Line 738: delete from IGS_RU_ITEM

734: Before_DML (
735: p_action => 'DELETE',
736: x_rowid => X_ROWID);
737:
738: delete from IGS_RU_ITEM
739: where ROWID = X_ROWID;
740: if (sql%notfound) then
741: raise no_data_found;
742: end if;

Line 768: CURSOR c_ru_item(cp_rul_sequence_number igs_ru_item.rul_sequence_number%TYPE,

764: f_ludate date; -- entity update date in file
765: db_luby number; -- entity owner in db
766: db_ludate date; -- entity update date in db
767:
768: CURSOR c_ru_item(cp_rul_sequence_number igs_ru_item.rul_sequence_number%TYPE,
769: cp_item igs_ru_item.item%TYPE) IS
770: SELECT last_updated_by, last_update_date
771: FROM igs_ru_item
772: WHERE rul_sequence_number = cp_rul_sequence_number

Line 769: cp_item igs_ru_item.item%TYPE) IS

765: db_luby number; -- entity owner in db
766: db_ludate date; -- entity update date in db
767:
768: CURSOR c_ru_item(cp_rul_sequence_number igs_ru_item.rul_sequence_number%TYPE,
769: cp_item igs_ru_item.item%TYPE) IS
770: SELECT last_updated_by, last_update_date
771: FROM igs_ru_item
772: WHERE rul_sequence_number = cp_rul_sequence_number
773: AND item = cp_item

Line 771: FROM igs_ru_item

767:
768: CURSOR c_ru_item(cp_rul_sequence_number igs_ru_item.rul_sequence_number%TYPE,
769: cp_item igs_ru_item.item%TYPE) IS
770: SELECT last_updated_by, last_update_date
771: FROM igs_ru_item
772: WHERE rul_sequence_number = cp_rul_sequence_number
773: AND item = cp_item
774: AND rul_sequence_number <= 500000; -- this is the addtional check put to filter out the customer defined rules, bug 2421803
775:

Line 793: DELETE FROM IGS_RU_ITEM

789: IF (TRUNC(f_ludate) > TRUNC(db_ludate)) THEN
790:
791: -- Delete all the old entries for the currenly processed RUL_SEQUENCE_NUMBER
792: -- Added as part of bug fix 2421803, nshee
793: DELETE FROM IGS_RU_ITEM
794: WHERE RUL_SEQUENCE_NUMBER = x_rul_sequence_number;
795:
796: INSERT INTO igs_ru_item
797: (

Line 796: INSERT INTO igs_ru_item

792: -- Added as part of bug fix 2421803, nshee
793: DELETE FROM IGS_RU_ITEM
794: WHERE RUL_SEQUENCE_NUMBER = x_rul_sequence_number;
795:
796: INSERT INTO igs_ru_item
797: (
798: RUL_SEQUENCE_NUMBER,
799: ITEM,
800: TURIN_FUNCTION,

Line 831: INSERT INTO igs_ru_item

827: );
828:
829: END IF;
830: ELSE
831: INSERT INTO igs_ru_item
832: (
833: RUL_SEQUENCE_NUMBER,
834: ITEM,
835: TURIN_FUNCTION,

Line 888: igs_ru_item_pkg.load_row(

884:
885: IF (x_upload_mode = 'NLS') THEN
886: NULL; --For translated record call Table_pkg.TRANSLATE_ROW
887: ELSE
888: igs_ru_item_pkg.load_row(
889: x_rul_sequence_number => x_rul_sequence_number ,
890: x_item => x_item ,
891: x_turin_function => x_turin_function ,
892: x_named_rule => x_named_rule,

Line 904: end IGS_RU_ITEM_PKG;

900: END IF;
901:
902: END LOAD_SEED_ROW;
903:
904: end IGS_RU_ITEM_PKG;