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_PR_CSS_CLASS_STD_PKG dependencies on IGS_PR_CSS_CLASS_STD

Line 1: PACKAGE BODY igs_pr_css_class_std_pkg AS

1: PACKAGE BODY igs_pr_css_class_std_pkg AS
2: /* $Header: IGSQI31B.pls 115.5 2002/11/29 03:22:16 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_css_class_std%ROWTYPE;

Line 5: old_references igs_pr_css_class_std%ROWTYPE;

1: PACKAGE BODY igs_pr_css_class_std_pkg AS
2: /* $Header: IGSQI31B.pls 115.5 2002/11/29 03:22:16 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_css_class_std%ROWTYPE;
6: new_references igs_pr_css_class_std%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_pr_css_class_std%ROWTYPE;

2: /* $Header: IGSQI31B.pls 115.5 2002/11/29 03:22:16 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_css_class_std%ROWTYPE;
6: new_references igs_pr_css_class_std%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 11: x_igs_pr_css_class_std_id IN NUMBER DEFAULT NULL,

7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,
11: x_igs_pr_css_class_std_id IN NUMBER DEFAULT NULL,
12: x_igs_pr_cs_schdl_id IN NUMBER DEFAULT NULL,
13: x_igs_pr_class_std_id IN NUMBER DEFAULT NULL,
14: x_min_cp IN NUMBER DEFAULT NULL,
15: x_max_cp IN NUMBER DEFAULT NULL,

Line 35: FROM IGS_PR_CSS_CLASS_STD

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

Line 56: new_references.igs_pr_css_class_std_id := x_igs_pr_css_class_std_id;

52: END IF;
53: CLOSE cur_old_ref_values;
54:
55: -- Populate New Values.
56: new_references.igs_pr_css_class_std_id := x_igs_pr_css_class_std_id;
57: new_references.igs_pr_cs_schdl_id := x_igs_pr_cs_schdl_id;
58: new_references.igs_pr_class_std_id := x_igs_pr_class_std_id;
59: new_references.min_cp := x_min_cp;
60: new_references.max_cp := x_max_cp;

Line 141: x_igs_pr_css_class_std_id IN NUMBER

137: END check_parent_existance;
138:
139:
140: FUNCTION get_pk_for_validation (
141: x_igs_pr_css_class_std_id IN NUMBER
142: ) RETURN BOOLEAN AS
143: /*
144: || Created By : avenkatr
145: || Created On : 12-JUL-2001

Line 154: FROM igs_pr_css_class_std

150: || (reverse chronological order - newest change first)
151: */
152: CURSOR cur_rowid IS
153: SELECT rowid
154: FROM igs_pr_css_class_std
155: WHERE igs_pr_css_class_std_id = x_igs_pr_css_class_std_id
156: FOR UPDATE NOWAIT;
157:
158: lv_rowid cur_rowid%RowType;

Line 155: WHERE igs_pr_css_class_std_id = x_igs_pr_css_class_std_id

151: */
152: CURSOR cur_rowid IS
153: SELECT rowid
154: FROM igs_pr_css_class_std
155: WHERE igs_pr_css_class_std_id = x_igs_pr_css_class_std_id
156: FOR UPDATE NOWAIT;
157:
158: lv_rowid cur_rowid%RowType;
159:

Line 190: FROM igs_pr_css_class_std

186: || (reverse chronological order - newest change first)
187: */
188: CURSOR cur_rowid IS
189: SELECT rowid
190: FROM igs_pr_css_class_std
191: WHERE igs_pr_class_std_id = x_igs_pr_class_std_id
192: AND igs_pr_cs_schdl_id = x_igs_pr_cs_schdl_id
193: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
194:

Line 226: FROM igs_pr_css_class_std

222: || (reverse chronological order - newest change first)
223: */
224: CURSOR cur_rowid IS
225: SELECT rowid
226: FROM igs_pr_css_class_std
227: WHERE ((igs_pr_cs_schdl_id = x_igs_pr_cs_schdl_id));
228:
229: lv_rowid cur_rowid%RowType;
230:

Line 261: FROM igs_pr_css_class_std

257: || (reverse chronological order - newest change first)
258: */
259: CURSOR cur_rowid IS
260: SELECT rowid
261: FROM igs_pr_css_class_std
262: WHERE ((igs_pr_class_std_id = x_igs_pr_class_std_id));
263:
264: lv_rowid cur_rowid%RowType;
265:

Line 285: x_igs_pr_css_class_std_id IN NUMBER DEFAULT NULL,

281:
282: PROCEDURE before_dml (
283: p_action IN VARCHAR2,
284: x_rowid IN VARCHAR2 DEFAULT NULL,
285: x_igs_pr_css_class_std_id IN NUMBER DEFAULT NULL,
286: x_igs_pr_cs_schdl_id IN NUMBER DEFAULT NULL,
287: x_igs_pr_class_std_id IN NUMBER DEFAULT NULL,
288: x_min_cp IN NUMBER DEFAULT NULL,
289: x_max_cp IN NUMBER DEFAULT NULL,

Line 312: x_igs_pr_css_class_std_id,

308:
309: set_column_values (
310: p_action,
311: x_rowid,
312: x_igs_pr_css_class_std_id,
313: x_igs_pr_cs_schdl_id,
314: x_igs_pr_class_std_id,
315: x_min_cp,
316: x_max_cp,

Line 328: new_references.igs_pr_css_class_std_id

324:
325: IF (p_action = 'INSERT') THEN
326: -- Call all the procedures related to Before Insert.
327: IF ( get_pk_for_validation(
328: new_references.igs_pr_css_class_std_id
329: )
330: ) THEN
331: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
332: igs_ge_msg_stack.add;

Line 344: new_references.igs_pr_css_class_std_id

340: check_parent_existance;
341: ELSIF (p_action = 'VALIDATE_INSERT') THEN
342: -- Call all the procedures related to Before Insert.
343: IF ( get_pk_for_validation (
344: new_references.igs_pr_css_class_std_id
345: )
346: ) THEN
347: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
348: igs_ge_msg_stack.add;

Line 361: x_igs_pr_css_class_std_id IN OUT NOCOPY NUMBER,

357:
358:
359: PROCEDURE insert_row (
360: x_rowid IN OUT NOCOPY VARCHAR2,
361: x_igs_pr_css_class_std_id IN OUT NOCOPY NUMBER,
362: x_igs_pr_cs_schdl_id IN NUMBER,
363: x_igs_pr_class_std_id IN NUMBER,
364: x_min_cp IN NUMBER,
365: x_max_cp IN NUMBER,

Line 380: FROM igs_pr_css_class_std

376: || (reverse chronological order - newest change first)
377: */
378: CURSOR c IS
379: SELECT rowid
380: FROM igs_pr_css_class_std
381: WHERE igs_pr_css_class_std_id = x_igs_pr_css_class_std_id;
382:
383: x_last_update_date DATE;
384: x_last_updated_by NUMBER;

Line 381: WHERE igs_pr_css_class_std_id = x_igs_pr_css_class_std_id;

377: */
378: CURSOR c IS
379: SELECT rowid
380: FROM igs_pr_css_class_std
381: WHERE igs_pr_css_class_std_id = x_igs_pr_css_class_std_id;
382:
383: x_last_update_date DATE;
384: x_last_updated_by NUMBER;
385: x_last_update_login NUMBER;

Line 408: SELECT igs_pr_css_class_std_s.NEXTVAL

404: igs_ge_msg_stack.add;
405: app_exception.raise_exception;
406: END IF;
407:
408: SELECT igs_pr_css_class_std_s.NEXTVAL
409: INTO x_igs_pr_css_class_std_id
410: FROM dual;
411:
412: before_dml(

Line 409: INTO x_igs_pr_css_class_std_id

405: app_exception.raise_exception;
406: END IF;
407:
408: SELECT igs_pr_css_class_std_s.NEXTVAL
409: INTO x_igs_pr_css_class_std_id
410: FROM dual;
411:
412: before_dml(
413: p_action => 'INSERT',

Line 415: x_igs_pr_css_class_std_id => x_igs_pr_css_class_std_id,

411:
412: before_dml(
413: p_action => 'INSERT',
414: x_rowid => x_rowid,
415: x_igs_pr_css_class_std_id => x_igs_pr_css_class_std_id,
416: x_igs_pr_cs_schdl_id => x_igs_pr_cs_schdl_id,
417: x_igs_pr_class_std_id => x_igs_pr_class_std_id,
418: x_min_cp => x_min_cp,
419: x_max_cp => x_max_cp,

Line 428: INSERT INTO igs_pr_css_class_std (

424: x_last_updated_by => x_last_updated_by,
425: x_last_update_login => x_last_update_login
426: );
427:
428: INSERT INTO igs_pr_css_class_std (
429: igs_pr_css_class_std_id,
430: igs_pr_cs_schdl_id,
431: igs_pr_class_std_id,
432: min_cp,

Line 429: igs_pr_css_class_std_id,

425: x_last_update_login => x_last_update_login
426: );
427:
428: INSERT INTO igs_pr_css_class_std (
429: igs_pr_css_class_std_id,
430: igs_pr_cs_schdl_id,
431: igs_pr_class_std_id,
432: min_cp,
433: max_cp,

Line 441: new_references.igs_pr_css_class_std_id,

437: last_update_date,
438: last_updated_by,
439: last_update_login
440: ) VALUES (
441: new_references.igs_pr_css_class_std_id,
442: new_references.igs_pr_cs_schdl_id,
443: new_references.igs_pr_class_std_id,
444: new_references.min_cp,
445: new_references.max_cp,

Line 467: x_igs_pr_css_class_std_id IN NUMBER,

463:
464:
465: PROCEDURE lock_row (
466: x_rowid IN VARCHAR2,
467: x_igs_pr_css_class_std_id IN NUMBER,
468: x_igs_pr_cs_schdl_id IN NUMBER,
469: x_igs_pr_class_std_id IN NUMBER,
470: x_min_cp IN NUMBER,
471: x_max_cp IN NUMBER,

Line 490: FROM igs_pr_css_class_std

486: igs_pr_class_std_id,
487: min_cp,
488: max_cp,
489: acad_year
490: FROM igs_pr_css_class_std
491: WHERE rowid = x_rowid
492: FOR UPDATE NOWAIT;
493:
494: tlinfo c1%ROWTYPE;

Line 530: x_igs_pr_css_class_std_id IN NUMBER,

526:
527:
528: PROCEDURE update_row (
529: x_rowid IN VARCHAR2,
530: x_igs_pr_css_class_std_id IN NUMBER,
531: x_igs_pr_cs_schdl_id IN NUMBER,
532: x_igs_pr_class_std_id IN NUMBER,
533: x_min_cp IN NUMBER,
534: x_max_cp IN NUMBER,

Line 575: x_igs_pr_css_class_std_id => x_igs_pr_css_class_std_id,

571:
572: before_dml(
573: p_action => 'UPDATE',
574: x_rowid => x_rowid,
575: x_igs_pr_css_class_std_id => x_igs_pr_css_class_std_id,
576: x_igs_pr_cs_schdl_id => x_igs_pr_cs_schdl_id,
577: x_igs_pr_class_std_id => x_igs_pr_class_std_id,
578: x_min_cp => x_min_cp,
579: x_max_cp => x_max_cp,

Line 588: UPDATE igs_pr_css_class_std

584: x_last_updated_by => x_last_updated_by,
585: x_last_update_login => x_last_update_login
586: );
587:
588: UPDATE igs_pr_css_class_std
589: SET
590: igs_pr_cs_schdl_id = new_references.igs_pr_cs_schdl_id,
591: igs_pr_class_std_id = new_references.igs_pr_class_std_id,
592: min_cp = new_references.min_cp,

Line 609: x_igs_pr_css_class_std_id IN OUT NOCOPY NUMBER,

605:
606:
607: PROCEDURE add_row (
608: x_rowid IN OUT NOCOPY VARCHAR2,
609: x_igs_pr_css_class_std_id IN OUT NOCOPY NUMBER,
610: x_igs_pr_cs_schdl_id IN NUMBER,
611: x_igs_pr_class_std_id IN NUMBER,
612: x_min_cp IN NUMBER,
613: x_max_cp IN NUMBER,

Line 628: FROM igs_pr_css_class_std

624: || (reverse chronological order - newest change first)
625: */
626: CURSOR c1 IS
627: SELECT rowid
628: FROM igs_pr_css_class_std
629: WHERE igs_pr_css_class_std_id = x_igs_pr_css_class_std_id;
630:
631: BEGIN
632:

Line 629: WHERE igs_pr_css_class_std_id = x_igs_pr_css_class_std_id;

625: */
626: CURSOR c1 IS
627: SELECT rowid
628: FROM igs_pr_css_class_std
629: WHERE igs_pr_css_class_std_id = x_igs_pr_css_class_std_id;
630:
631: BEGIN
632:
633: OPEN c1;

Line 640: x_igs_pr_css_class_std_id,

636: CLOSE c1;
637:
638: insert_row (
639: x_rowid,
640: x_igs_pr_css_class_std_id,
641: x_igs_pr_cs_schdl_id,
642: x_igs_pr_class_std_id,
643: x_min_cp,
644: x_max_cp,

Line 654: x_igs_pr_css_class_std_id,

650: CLOSE c1;
651:
652: update_row (
653: x_rowid,
654: x_igs_pr_css_class_std_id,
655: x_igs_pr_cs_schdl_id,
656: x_igs_pr_class_std_id,
657: x_min_cp,
658: x_max_cp,

Line 685: DELETE FROM igs_pr_css_class_std

681: p_action => 'DELETE',
682: x_rowid => x_rowid
683: );
684:
685: DELETE FROM igs_pr_css_class_std
686: WHERE rowid = x_rowid;
687:
688: IF (SQL%NOTFOUND) THEN
689: RAISE NO_DATA_FOUND;

Line 695: END igs_pr_css_class_std_pkg;

691:
692: END delete_row;
693:
694:
695: END igs_pr_css_class_std_pkg;