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_INST_STAT_PKG dependencies on STANDARD

Line 14: x_standard_ind IN VARCHAR2,

10: x_rowid IN VARCHAR2,
11: x_stat_type IN VARCHAR2,
12: x_display_order IN NUMBER,
13: x_timeframe IN VARCHAR2,
14: x_standard_ind IN VARCHAR2,
15: x_display_ind IN VARCHAR2,
16: x_include_standard_ind IN VARCHAR2,
17: x_include_local_ind IN VARCHAR2,
18: x_include_other_ind IN VARCHAR2,

Line 16: x_include_standard_ind IN VARCHAR2,

12: x_display_order IN NUMBER,
13: x_timeframe IN VARCHAR2,
14: x_standard_ind IN VARCHAR2,
15: x_display_ind IN VARCHAR2,
16: x_include_standard_ind IN VARCHAR2,
17: x_include_local_ind IN VARCHAR2,
18: x_include_other_ind IN VARCHAR2,
19: x_creation_date IN DATE,
20: x_created_by IN NUMBER,

Line 61: new_references.standard_ind := x_standard_ind;

57: -- Populate New Values.
58: new_references.stat_type := x_stat_type;
59: new_references.display_order := x_display_order;
60: new_references.timeframe := x_timeframe;
61: new_references.standard_ind := x_standard_ind;
62: new_references.display_ind := x_display_ind;
63: new_references.include_standard_ind := x_include_standard_ind;
64: new_references.include_local_ind := x_include_local_ind;
65: new_references.include_other_ind := x_include_other_ind;

Line 63: new_references.include_standard_ind := x_include_standard_ind;

59: new_references.display_order := x_display_order;
60: new_references.timeframe := x_timeframe;
61: new_references.standard_ind := x_standard_ind;
62: new_references.display_ind := x_display_ind;
63: new_references.include_standard_ind := x_include_standard_ind;
64: new_references.include_local_ind := x_include_local_ind;
65: new_references.include_other_ind := x_include_other_ind;
66:
67: IF (p_action = 'UPDATE') THEN

Line 260: x_standard_ind IN VARCHAR2,

256: x_rowid IN VARCHAR2,
257: x_stat_type IN VARCHAR2,
258: x_display_order IN NUMBER,
259: x_timeframe IN VARCHAR2,
260: x_standard_ind IN VARCHAR2,
261: x_display_ind IN VARCHAR2,
262: x_include_standard_ind IN VARCHAR2,
263: x_include_local_ind IN VARCHAR2,
264: x_include_other_ind IN VARCHAR2,

Line 262: x_include_standard_ind IN VARCHAR2,

258: x_display_order IN NUMBER,
259: x_timeframe IN VARCHAR2,
260: x_standard_ind IN VARCHAR2,
261: x_display_ind IN VARCHAR2,
262: x_include_standard_ind IN VARCHAR2,
263: x_include_local_ind IN VARCHAR2,
264: x_include_other_ind IN VARCHAR2,
265: x_creation_date IN DATE,
266: x_created_by IN NUMBER,

Line 289: x_standard_ind,

285: x_rowid,
286: x_stat_type,
287: x_display_order,
288: x_timeframe,
289: x_standard_ind,
290: x_display_ind,
291: x_include_standard_ind,
292: x_include_local_ind,
293: x_include_other_ind,

Line 291: x_include_standard_ind,

287: x_display_order,
288: x_timeframe,
289: x_standard_ind,
290: x_display_ind,
291: x_include_standard_ind,
292: x_include_local_ind,
293: x_include_other_ind,
294: x_creation_date,
295: x_created_by,

Line 352: x_standard_ind IN VARCHAR2,

348: x_rowid IN OUT NOCOPY VARCHAR2,
349: x_stat_type IN VARCHAR2,
350: x_display_order IN NUMBER,
351: x_timeframe IN VARCHAR2,
352: x_standard_ind IN VARCHAR2,
353: x_display_ind IN VARCHAR2,
354: x_include_standard_ind IN VARCHAR2,
355: x_include_local_ind IN VARCHAR2,
356: x_include_other_ind IN VARCHAR2,

Line 354: x_include_standard_ind IN VARCHAR2,

350: x_display_order IN NUMBER,
351: x_timeframe IN VARCHAR2,
352: x_standard_ind IN VARCHAR2,
353: x_display_ind IN VARCHAR2,
354: x_include_standard_ind IN VARCHAR2,
355: x_include_local_ind IN VARCHAR2,
356: x_include_other_ind IN VARCHAR2,
357: x_mode IN VARCHAR2
358: ) AS

Line 404: x_standard_ind => x_standard_ind,

400: x_rowid => x_rowid,
401: x_stat_type => x_stat_type,
402: x_display_order => x_display_order,
403: x_timeframe => x_timeframe,
404: x_standard_ind => x_standard_ind,
405: x_display_ind => x_display_ind,
406: x_include_standard_ind => x_include_standard_ind,
407: x_include_local_ind => x_include_local_ind,
408: x_include_other_ind => x_include_other_ind,

Line 406: x_include_standard_ind => x_include_standard_ind,

402: x_display_order => x_display_order,
403: x_timeframe => x_timeframe,
404: x_standard_ind => x_standard_ind,
405: x_display_ind => x_display_ind,
406: x_include_standard_ind => x_include_standard_ind,
407: x_include_local_ind => x_include_local_ind,
408: x_include_other_ind => x_include_other_ind,
409: x_creation_date => x_last_update_date,
410: x_created_by => x_last_updated_by,

Line 420: standard_ind,

416: INSERT INTO igs_pr_inst_stat (
417: stat_type,
418: display_order,
419: timeframe,
420: standard_ind,
421: display_ind,
422: include_standard_ind,
423: include_local_ind,
424: include_other_ind,

Line 422: include_standard_ind,

418: display_order,
419: timeframe,
420: standard_ind,
421: display_ind,
422: include_standard_ind,
423: include_local_ind,
424: include_other_ind,
425: creation_date,
426: created_by,

Line 434: new_references.standard_ind,

430: ) VALUES (
431: new_references.stat_type,
432: new_references.display_order,
433: new_references.timeframe,
434: new_references.standard_ind,
435: new_references.display_ind,
436: new_references.include_standard_ind,
437: new_references.include_local_ind,
438: new_references.include_other_ind,

Line 436: new_references.include_standard_ind,

432: new_references.display_order,
433: new_references.timeframe,
434: new_references.standard_ind,
435: new_references.display_ind,
436: new_references.include_standard_ind,
437: new_references.include_local_ind,
438: new_references.include_other_ind,
439: x_last_update_date,
440: x_last_updated_by,

Line 473: inst.standard_ind

469: */
470:
471: CURSOR c1 IS
472: SELECT inst.timeframe,
473: inst.standard_ind
474: FROM igs_pr_inst_stat inst
475: WHERE inst.standard_ind = 'Y';
476:
477: CURSOR c2 IS

Line 475: WHERE inst.standard_ind = 'Y';

471: CURSOR c1 IS
472: SELECT inst.timeframe,
473: inst.standard_ind
474: FROM igs_pr_inst_stat inst
475: WHERE inst.standard_ind = 'Y';
476:
477: CURSOR c2 IS
478: SELECT inst.timeframe
479: FROM igs_pr_inst_stat inst

Line 480: WHERE inst.standard_ind = 'Y'

476:
477: CURSOR c2 IS
478: SELECT inst.timeframe
479: FROM igs_pr_inst_stat inst
480: WHERE inst.standard_ind = 'Y'
481: GROUP BY inst.timeframe
482: HAVING COUNT(inst.timeframe) > 1;
483:
484: l_c1_rec c1%ROWTYPE;

Line 492: IF l_c1_rec.standard_ind = 'Y' THEN

488:
489: BEGIN
490:
491: FOR l_c1_rec IN c1 LOOP
492: IF l_c1_rec.standard_ind = 'Y' THEN
493: IF l_std_ind = 'N' THEN
494: l_std_ind := 'Y';
495: IF l_c1_rec.timeframe = 'BOTH' THEN
496: l_both_std_flag := 'Y';

Line 502: FND_MESSAGE.SET_TOKEN('STATTYPE_IND','Standard');

498: ELSIF l_std_ind = 'Y'
499: AND (l_c1_rec.timeframe = 'BOTH'
500: OR l_both_std_flag ='Y' ) THEN
501: fnd_message.set_name ('IGS','IGS_PR_STAT_TYPE_IND');
502: FND_MESSAGE.SET_TOKEN('STATTYPE_IND','Standard');
503: igs_ge_msg_stack.add;
504: app_exception.raise_exception;
505: END IF;
506: END IF;

Line 513: FND_MESSAGE.SET_TOKEN('STATTYPE_IND','Standard');

509: OPEN c2;
510: FETCH c2 INTO dummy;
511: IF c2%FOUND THEN
512: fnd_message.set_name ('IGS','IGS_PR_STAT_TYPE_IND');
513: FND_MESSAGE.SET_TOKEN('STATTYPE_IND','Standard');
514: igs_ge_msg_stack.add;
515: app_exception.raise_exception;
516: END IF;
517: CLOSE c2;

Line 533: x_standard_ind IN VARCHAR2,

529: x_rowid IN VARCHAR2,
530: x_stat_type IN VARCHAR2,
531: x_display_order IN NUMBER,
532: x_timeframe IN VARCHAR2,
533: x_standard_ind IN VARCHAR2,
534: x_display_ind IN VARCHAR2,
535: x_include_standard_ind IN VARCHAR2,
536: x_include_local_ind IN VARCHAR2,
537: x_include_other_ind IN VARCHAR2

Line 535: x_include_standard_ind IN VARCHAR2,

531: x_display_order IN NUMBER,
532: x_timeframe IN VARCHAR2,
533: x_standard_ind IN VARCHAR2,
534: x_display_ind IN VARCHAR2,
535: x_include_standard_ind IN VARCHAR2,
536: x_include_local_ind IN VARCHAR2,
537: x_include_other_ind IN VARCHAR2
538: ) AS
539: /*

Line 554: standard_ind,

550: CURSOR c1 IS
551: SELECT
552: display_order,
553: timeframe,
554: standard_ind,
555: display_ind,
556: include_standard_ind,
557: include_local_ind,
558: include_other_ind

Line 556: include_standard_ind,

552: display_order,
553: timeframe,
554: standard_ind,
555: display_ind,
556: include_standard_ind,
557: include_local_ind,
558: include_other_ind
559: FROM igs_pr_inst_stat
560: WHERE rowid = x_rowid

Line 581: AND (tlinfo.standard_ind = x_standard_ind)

577:
578: IF (
579: (tlinfo.display_order = x_display_order)
580: AND (tlinfo.timeframe = x_timeframe)
581: AND (tlinfo.standard_ind = x_standard_ind)
582: AND (tlinfo.display_ind = x_display_ind)
583: AND (tlinfo.include_standard_ind = x_include_standard_ind)
584: AND (tlinfo.include_local_ind = x_include_local_ind)
585: AND (tlinfo.include_other_ind = x_include_other_ind)

Line 583: AND (tlinfo.include_standard_ind = x_include_standard_ind)

579: (tlinfo.display_order = x_display_order)
580: AND (tlinfo.timeframe = x_timeframe)
581: AND (tlinfo.standard_ind = x_standard_ind)
582: AND (tlinfo.display_ind = x_display_ind)
583: AND (tlinfo.include_standard_ind = x_include_standard_ind)
584: AND (tlinfo.include_local_ind = x_include_local_ind)
585: AND (tlinfo.include_other_ind = x_include_other_ind)
586: ) THEN
587: NULL;

Line 604: x_standard_ind IN VARCHAR2,

600: x_rowid IN VARCHAR2,
601: x_stat_type IN VARCHAR2,
602: x_display_order IN NUMBER,
603: x_timeframe IN VARCHAR2,
604: x_standard_ind IN VARCHAR2,
605: x_display_ind IN VARCHAR2,
606: x_include_standard_ind IN VARCHAR2,
607: x_include_local_ind IN VARCHAR2,
608: x_include_other_ind IN VARCHAR2,

Line 606: x_include_standard_ind IN VARCHAR2,

602: x_display_order IN NUMBER,
603: x_timeframe IN VARCHAR2,
604: x_standard_ind IN VARCHAR2,
605: x_display_ind IN VARCHAR2,
606: x_include_standard_ind IN VARCHAR2,
607: x_include_local_ind IN VARCHAR2,
608: x_include_other_ind IN VARCHAR2,
609: x_mode IN VARCHAR2
610: ) AS

Line 651: x_standard_ind => x_standard_ind,

647: x_rowid => x_rowid,
648: x_stat_type => x_stat_type,
649: x_display_order => x_display_order,
650: x_timeframe => x_timeframe,
651: x_standard_ind => x_standard_ind,
652: x_display_ind => x_display_ind,
653: x_include_standard_ind => x_include_standard_ind,
654: x_include_local_ind => x_include_local_ind,
655: x_include_other_ind => x_include_other_ind,

Line 653: x_include_standard_ind => x_include_standard_ind,

649: x_display_order => x_display_order,
650: x_timeframe => x_timeframe,
651: x_standard_ind => x_standard_ind,
652: x_display_ind => x_display_ind,
653: x_include_standard_ind => x_include_standard_ind,
654: x_include_local_ind => x_include_local_ind,
655: x_include_other_ind => x_include_other_ind,
656: x_creation_date => x_last_update_date,
657: x_created_by => x_last_updated_by,

Line 667: standard_ind = new_references.standard_ind,

663: UPDATE igs_pr_inst_stat
664: SET
665: display_order = new_references.display_order,
666: timeframe = new_references.timeframe,
667: standard_ind = new_references.standard_ind,
668: display_ind = new_references.display_ind,
669: include_standard_ind = new_references.include_standard_ind,
670: include_local_ind = new_references.include_local_ind,
671: include_other_ind = new_references.include_other_ind,

Line 669: include_standard_ind = new_references.include_standard_ind,

665: display_order = new_references.display_order,
666: timeframe = new_references.timeframe,
667: standard_ind = new_references.standard_ind,
668: display_ind = new_references.display_ind,
669: include_standard_ind = new_references.include_standard_ind,
670: include_local_ind = new_references.include_local_ind,
671: include_other_ind = new_references.include_other_ind,
672: last_update_date = x_last_update_date,
673: last_updated_by = x_last_updated_by,

Line 690: x_standard_ind IN VARCHAR2,

686: x_rowid IN OUT NOCOPY VARCHAR2,
687: x_stat_type IN VARCHAR2,
688: x_display_order IN NUMBER,
689: x_timeframe IN VARCHAR2,
690: x_standard_ind IN VARCHAR2,
691: x_display_ind IN VARCHAR2,
692: x_include_standard_ind IN VARCHAR2,
693: x_include_local_ind IN VARCHAR2,
694: x_include_other_ind IN VARCHAR2,

Line 692: x_include_standard_ind IN VARCHAR2,

688: x_display_order IN NUMBER,
689: x_timeframe IN VARCHAR2,
690: x_standard_ind IN VARCHAR2,
691: x_display_ind IN VARCHAR2,
692: x_include_standard_ind IN VARCHAR2,
693: x_include_local_ind IN VARCHAR2,
694: x_include_other_ind IN VARCHAR2,
695: x_mode IN VARCHAR2
696: ) AS

Line 723: x_standard_ind,

719: x_rowid,
720: x_stat_type,
721: x_display_order,
722: x_timeframe,
723: x_standard_ind,
724: x_display_ind,
725: x_include_standard_ind,
726: x_include_local_ind,
727: x_include_other_ind,

Line 725: x_include_standard_ind,

721: x_display_order,
722: x_timeframe,
723: x_standard_ind,
724: x_display_ind,
725: x_include_standard_ind,
726: x_include_local_ind,
727: x_include_other_ind,
728: x_mode
729: );

Line 739: x_standard_ind,

735: x_rowid,
736: x_stat_type,
737: x_display_order,
738: x_timeframe,
739: x_standard_ind,
740: x_display_ind,
741: x_include_standard_ind,
742: x_include_local_ind,
743: x_include_other_ind,

Line 741: x_include_standard_ind,

737: x_display_order,
738: x_timeframe,
739: x_standard_ind,
740: x_display_ind,
741: x_include_standard_ind,
742: x_include_local_ind,
743: x_include_other_ind,
744: x_mode
745: );