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_EN_TIMESLOT_PREF_PKG dependencies on IGS_EN_TIMESLOT_PREF

Line 1: PACKAGE BODY igs_en_timeslot_pref_pkg AS

1: PACKAGE BODY igs_en_timeslot_pref_pkg AS
2: /* $Header: IGSEI40B.pls 115.10 2003/02/24 11:02:51 npalanis ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_en_timeslot_pref%ROWTYPE;
5: new_references igs_en_timeslot_pref%ROWTYPE;

Line 4: old_references igs_en_timeslot_pref%ROWTYPE;

1: PACKAGE BODY igs_en_timeslot_pref_pkg AS
2: /* $Header: IGSEI40B.pls 115.10 2003/02/24 11:02:51 npalanis ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_en_timeslot_pref%ROWTYPE;
5: new_references igs_en_timeslot_pref%ROWTYPE;
6:
7: PROCEDURE set_column_values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_en_timeslot_pref%ROWTYPE;

1: PACKAGE BODY igs_en_timeslot_pref_pkg AS
2: /* $Header: IGSEI40B.pls 115.10 2003/02/24 11:02:51 npalanis ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_en_timeslot_pref%ROWTYPE;
5: new_references igs_en_timeslot_pref%ROWTYPE;
6:
7: PROCEDURE set_column_values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 10: x_igs_en_timeslot_pref_id IN NUMBER DEFAULT NULL,

6:
7: PROCEDURE set_column_values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,
10: x_igs_en_timeslot_pref_id IN NUMBER DEFAULT NULL,
11: x_igs_en_timeslot_prty_id IN NUMBER DEFAULT NULL,
12: x_preference_order IN NUMBER DEFAULT NULL,
13: x_preference_code IN VARCHAR2 DEFAULT NULL,
14: x_preference_version IN NUMBER DEFAULT NULL,

Line 36: FROM IGS_EN_TIMESLOT_PREF

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

Line 57: new_references.igs_en_timeslot_pref_id := x_igs_en_timeslot_pref_id;

53: END IF;
54: CLOSE cur_old_ref_values;
55:
56: -- Populate New Values.
57: new_references.igs_en_timeslot_pref_id := x_igs_en_timeslot_pref_id;
58: new_references.igs_en_timeslot_prty_id := x_igs_en_timeslot_prty_id;
59: new_references.preference_order := x_preference_order;
60: new_references.preference_code := x_preference_code;
61: new_references.preference_version := x_preference_version;

Line 154: x_igs_en_timeslot_pref_id IN NUMBER

150:
151: END check_parent_existance;
152:
153: FUNCTION get_pk_for_validation (
154: x_igs_en_timeslot_pref_id IN NUMBER
155: ) RETURN BOOLEAN AS
156:
157: /*************************************************************
158: Created By :

Line 170: FROM igs_en_timeslot_pref

166: ***************************************************************/
167:
168: CURSOR cur_rowid IS
169: SELECT rowid
170: FROM igs_en_timeslot_pref
171: WHERE igs_en_timeslot_pref_id = x_igs_en_timeslot_pref_id
172: FOR UPDATE NOWAIT;
173:
174: lv_rowid cur_rowid%RowType;

Line 171: WHERE igs_en_timeslot_pref_id = x_igs_en_timeslot_pref_id

167:
168: CURSOR cur_rowid IS
169: SELECT rowid
170: FROM igs_en_timeslot_pref
171: WHERE igs_en_timeslot_pref_id = x_igs_en_timeslot_pref_id
172: FOR UPDATE NOWAIT;
173:
174: lv_rowid cur_rowid%RowType;
175:

Line 208: FROM igs_en_timeslot_pref

204: ***************************************************************/
205:
206: CURSOR cur_rowid IS
207: SELECT rowid
208: FROM igs_en_timeslot_pref
209: WHERE igs_en_timeslot_prty_id = x_igs_en_timeslot_prty_id
210: AND preference_code = x_preference_code
211: AND ((preference_version IS NULL and x_preference_version IS NULL)
212: OR preference_version = x_preference_version)

Line 250: FROM igs_en_timeslot_pref

246: ***************************************************************/
247:
248: CURSOR cur_rowid IS
249: SELECT rowid
250: FROM igs_en_timeslot_pref
251: WHERE igs_en_timeslot_prty_id = x_igs_en_timeslot_prty_id ;
252:
253: lv_rowid cur_rowid%RowType;
254:

Line 291: x_igs_en_timeslot_pref_id IN NUMBER DEFAULT NULL,

287:
288: PROCEDURE before_dml (
289: p_action IN VARCHAR2,
290: x_rowid IN VARCHAR2 DEFAULT NULL,
291: x_igs_en_timeslot_pref_id IN NUMBER DEFAULT NULL,
292: x_igs_en_timeslot_prty_id IN NUMBER DEFAULT NULL,
293: x_preference_order IN NUMBER DEFAULT NULL,
294: x_preference_code IN VARCHAR2 DEFAULT NULL,
295: x_preference_version IN NUMBER DEFAULT NULL,

Line 319: x_igs_en_timeslot_pref_id,

315:
316: set_column_values (
317: p_action,
318: x_rowid,
319: x_igs_en_timeslot_pref_id,
320: x_igs_en_timeslot_prty_id,
321: x_preference_order,
322: x_preference_code,
323: x_preference_version,

Line 337: new_references.igs_en_timeslot_pref_id) THEN

333: -- Call all the procedures related to Before Insert.
334: Null;
335: BeforeInsertUpdate(TRUE,FALSE);
336: IF get_pk_for_validation(
337: new_references.igs_en_timeslot_pref_id) THEN
338: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
339: igs_ge_msg_stack.add;
340: app_exception.raise_exception;
341: END IF;

Line 359: new_references.igs_en_timeslot_pref_id) THEN

355: ELSIF (p_action = 'VALIDATE_INSERT') THEN
356: -- Call all the procedures related to Before Insert.
357: BeforeInsertUpdate(TRUE,FALSE);
358: IF get_pk_for_validation (
359: new_references.igs_en_timeslot_pref_id) THEN
360: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
361: igs_ge_msg_stack.add;
362: app_exception.raise_exception;
363: END IF;

Line 410: x_igs_en_timeslot_pref_id IN OUT NOCOPY NUMBER,

406: END after_dml;
407:
408: PROCEDURE insert_row (
409: x_rowid IN OUT NOCOPY VARCHAR2,
410: x_igs_en_timeslot_pref_id IN OUT NOCOPY NUMBER,
411: x_igs_en_timeslot_prty_id IN NUMBER,
412: x_preference_order IN NUMBER,
413: x_preference_code IN VARCHAR2,
414: x_preference_version IN NUMBER,

Line 429: CURSOR c IS SELECT ROWID FROM igs_en_timeslot_pref

425: ayedubat 16,JUL 2002 Removed the default NULL value of the in parameter,x_sequence_number for the bug fix:2464172
426: (reverse chronological order - newest change first)
427: ***************************************************************/
428:
429: CURSOR c IS SELECT ROWID FROM igs_en_timeslot_pref
430: WHERE igs_en_timeslot_pref_id= x_igs_en_timeslot_pref_id
431: ;
432: x_last_update_date DATE ;
433: x_last_updated_by NUMBER ;

Line 430: WHERE igs_en_timeslot_pref_id= x_igs_en_timeslot_pref_id

426: (reverse chronological order - newest change first)
427: ***************************************************************/
428:
429: CURSOR c IS SELECT ROWID FROM igs_en_timeslot_pref
430: WHERE igs_en_timeslot_pref_id= x_igs_en_timeslot_pref_id
431: ;
432: x_last_update_date DATE ;
433: x_last_updated_by NUMBER ;
434: x_last_update_login NUMBER ;

Line 455: select igs_en_timeslot_pref_s.nextval into x_igs_en_timeslot_pref_id from dual;

451: igs_ge_msg_stack.add;
452: app_exception.raise_exception;
453: end if;
454:
455: select igs_en_timeslot_pref_s.nextval into x_igs_en_timeslot_pref_id from dual;
456:
457: before_dml(
458: p_action=>'INSERT',
459: x_rowid=>X_ROWID,

Line 460: x_igs_en_timeslot_pref_id=>x_igs_en_timeslot_pref_id,

456:
457: before_dml(
458: p_action=>'INSERT',
459: x_rowid=>X_ROWID,
460: x_igs_en_timeslot_pref_id=>x_igs_en_timeslot_pref_id,
461: x_igs_en_timeslot_prty_id=>x_igs_en_timeslot_prty_id,
462: x_preference_order=>x_preference_order,
463: x_preference_code=>x_preference_code,
464: x_preference_version=>x_preference_version,

Line 472: INSERT INTO igs_en_timeslot_pref (

468: x_last_updated_by=> x_last_updated_by,
469: x_last_update_login=> x_last_update_login,
470: x_sequence_number=> x_sequence_number
471: );
472: INSERT INTO igs_en_timeslot_pref (
473: igs_en_timeslot_pref_id
474: ,igs_en_timeslot_prty_id
475: ,preference_order
476: ,preference_code

Line 473: igs_en_timeslot_pref_id

469: x_last_update_login=> x_last_update_login,
470: x_sequence_number=> x_sequence_number
471: );
472: INSERT INTO igs_en_timeslot_pref (
473: igs_en_timeslot_pref_id
474: ,igs_en_timeslot_prty_id
475: ,preference_order
476: ,preference_code
477: ,preference_version

Line 485: new_references.igs_en_timeslot_pref_id

481: ,last_updated_by
482: ,last_update_login
483: ,sequence_number
484: ) VALUES (
485: new_references.igs_en_timeslot_pref_id
486: ,new_references.igs_en_timeslot_prty_id
487: ,new_references.preference_order
488: ,new_references.preference_code
489: ,new_references.preference_version

Line 510: x_igs_en_timeslot_pref_id IN NUMBER,

506: x_rowid => X_ROWID );
507: END insert_row;
508: PROCEDURE lock_row (
509: x_rowid IN VARCHAR2,
510: x_igs_en_timeslot_pref_id IN NUMBER,
511: x_igs_en_timeslot_prty_id IN NUMBER,
512: x_preference_order IN NUMBER,
513: x_preference_code IN VARCHAR2,
514: x_preference_version IN NUMBER,

Line 534: FROM igs_en_timeslot_pref

530: , preference_order
531: , preference_code
532: , preference_version
533: , sequence_number
534: FROM igs_en_timeslot_pref
535: WHERE ROWID = x_rowid
536: FOR UPDATE NOWAIT;
537: tlinfo c1%ROWTYPE;
538: BEGIN

Line 569: x_IGS_EN_TIMESLOT_PREF_ID IN NUMBER,

565: RETURN;
566: END lock_row;
567: PROCEDURE update_row (
568: x_rowid IN VARCHAR2,
569: x_IGS_EN_TIMESLOT_PREF_ID IN NUMBER,
570: x_IGS_EN_TIMESLOT_PRTY_ID IN NUMBER,
571: x_PREFERENCE_ORDER IN NUMBER,
572: x_PREFERENCE_CODE IN VARCHAR2,
573: x_PREFERENCE_VERSION IN NUMBER,

Line 613: x_igs_en_timeslot_pref_id=>X_IGS_EN_TIMESLOT_PREF_ID,

609: END IF;
610: before_dml(
611: p_action=>'UPDATE',
612: x_rowid=>X_ROWID,
613: x_igs_en_timeslot_pref_id=>X_IGS_EN_TIMESLOT_PREF_ID,
614: x_igs_en_timeslot_prty_id=>X_IGS_EN_TIMESLOT_PRTY_ID,
615: x_preference_order=>X_PREFERENCE_ORDER,
616: x_preference_code=>X_PREFERENCE_CODE,
617: x_preference_version=>X_PREFERENCE_VERSION,

Line 625: UPDATE igs_en_timeslot_pref SET

621: x_last_updated_by=>x_last_updated_by,
622: x_last_update_login=>x_last_update_login,
623: x_sequence_number=>x_sequence_number
624: );
625: UPDATE igs_en_timeslot_pref SET
626: igs_en_timeslot_prty_id = NEW_REFERENCES.igs_en_timeslot_prty_id,
627: preference_order = NEW_REFERENCES.preference_order,
628: preference_code = NEW_REFERENCES.preference_code,
629: preference_version = NEW_REFERENCES.preference_version,

Line 646: x_igs_en_timeslot_pref_id IN OUT NOCOPY NUMBER,

642: );
643: END update_row;
644: PROCEDURE add_row (
645: x_rowid IN OUT NOCOPY VARCHAR2,
646: x_igs_en_timeslot_pref_id IN OUT NOCOPY NUMBER,
647: x_igs_en_timeslot_prty_id IN NUMBER,
648: x_preference_order IN NUMBER,
649: x_preference_code IN VARCHAR2,
650: x_preference_version IN NUMBER,

Line 665: CURSOR c1 IS SELECT ROWID FROM igs_en_timeslot_pref

661:
662: (reverse chronological order - newest change first)
663: ***************************************************************/
664:
665: CURSOR c1 IS SELECT ROWID FROM igs_en_timeslot_pref
666: WHERE igs_en_timeslot_pref_id= x_igs_en_timeslot_pref_id
667: ;
668: BEGIN
669: OPEN c1;

Line 666: WHERE igs_en_timeslot_pref_id= x_igs_en_timeslot_pref_id

662: (reverse chronological order - newest change first)
663: ***************************************************************/
664:
665: CURSOR c1 IS SELECT ROWID FROM igs_en_timeslot_pref
666: WHERE igs_en_timeslot_pref_id= x_igs_en_timeslot_pref_id
667: ;
668: BEGIN
669: OPEN c1;
670: FETCH c1 INTO x_rowid;

Line 675: X_igs_en_timeslot_pref_id,

671: IF (c1%NOTFOUND) THEN
672: CLOSE c1;
673: insert_row (
674: x_rowid,
675: X_igs_en_timeslot_pref_id,
676: X_igs_en_timeslot_prty_id,
677: X_preference_order,
678: X_preference_code,
679: X_preference_version,

Line 688: x_igs_en_timeslot_pref_id,

684: END IF;
685: CLOSE c1;
686: update_row (
687: x_rowid,
688: x_igs_en_timeslot_pref_id,
689: x_igs_en_timeslot_prty_id,
690: x_preference_order,
691: x_preference_code,
692: x_preference_version,

Line 716: DELETE FROM igs_en_timeslot_pref

712: before_dml (
713: p_action => 'DELETE',
714: x_rowid => X_ROWID
715: );
716: DELETE FROM igs_en_timeslot_pref
717: WHERE ROWID = x_rowid;
718: IF (SQL%NOTFOUND) THEN
719: RAISE NO_DATA_FOUND;
720: END IF;

Line 726: END igs_en_timeslot_pref_pkg;

722: p_action => 'DELETE',
723: x_rowid => X_ROWID
724: );
725: END delete_row;
726: END igs_en_timeslot_pref_pkg;