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

Line 15: x_standard_ind IN VARCHAR2,

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

Line 17: x_include_standard_ind IN VARCHAR2,

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

Line 63: new_references.standard_ind := x_standard_ind;

59: new_references.stat_type := x_stat_type;
60: new_references.org_unit_cd := x_org_unit_cd;
61: new_references.display_order := x_display_order;
62: new_references.timeframe := x_timeframe;
63: new_references.standard_ind := x_standard_ind;
64: new_references.display_ind := x_display_ind;
65: new_references.include_standard_ind := x_include_standard_ind;
66: new_references.include_local_ind := x_include_local_ind;
67: new_references.include_other_ind := x_include_other_ind;

Line 65: new_references.include_standard_ind := x_include_standard_ind;

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

Line 277: x_standard_ind IN VARCHAR2,

273: x_stat_type IN VARCHAR2,
274: x_org_unit_cd IN VARCHAR2,
275: x_display_order IN NUMBER,
276: x_timeframe IN VARCHAR2,
277: x_standard_ind IN VARCHAR2,
278: x_display_ind IN VARCHAR2,
279: x_include_standard_ind IN VARCHAR2,
280: x_include_local_ind IN VARCHAR2,
281: x_include_other_ind IN VARCHAR2,

Line 279: x_include_standard_ind IN VARCHAR2,

275: x_display_order IN NUMBER,
276: x_timeframe IN VARCHAR2,
277: x_standard_ind IN VARCHAR2,
278: x_display_ind IN VARCHAR2,
279: x_include_standard_ind IN VARCHAR2,
280: x_include_local_ind IN VARCHAR2,
281: x_include_other_ind IN VARCHAR2,
282: x_creation_date IN DATE,
283: x_created_by IN NUMBER,

Line 307: x_standard_ind,

303: x_stat_type,
304: x_org_unit_cd,
305: x_display_order,
306: x_timeframe,
307: x_standard_ind,
308: x_display_ind,
309: x_include_standard_ind,
310: x_include_local_ind,
311: x_include_other_ind,

Line 309: x_include_standard_ind,

305: x_display_order,
306: x_timeframe,
307: x_standard_ind,
308: x_display_ind,
309: x_include_standard_ind,
310: x_include_local_ind,
311: x_include_other_ind,
312: x_creation_date,
313: x_created_by,

Line 366: x_standard_ind IN VARCHAR2,

362: x_stat_type IN VARCHAR2,
363: x_org_unit_cd IN VARCHAR2,
364: x_display_order IN NUMBER,
365: x_timeframe IN VARCHAR2,
366: x_standard_ind IN VARCHAR2,
367: x_display_ind IN VARCHAR2,
368: x_include_standard_ind IN VARCHAR2,
369: x_include_local_ind IN VARCHAR2,
370: x_include_other_ind IN VARCHAR2,

Line 368: x_include_standard_ind IN VARCHAR2,

364: x_display_order IN NUMBER,
365: x_timeframe IN VARCHAR2,
366: x_standard_ind IN VARCHAR2,
367: x_display_ind IN VARCHAR2,
368: x_include_standard_ind IN VARCHAR2,
369: x_include_local_ind IN VARCHAR2,
370: x_include_other_ind IN VARCHAR2,
371: x_mode IN VARCHAR2
372: ) AS

Line 420: x_standard_ind => x_standard_ind,

416: x_stat_type => x_stat_type,
417: x_org_unit_cd => x_org_unit_cd,
418: x_display_order => x_display_order,
419: x_timeframe => x_timeframe,
420: x_standard_ind => x_standard_ind,
421: x_display_ind => x_display_ind,
422: x_include_standard_ind => x_include_standard_ind,
423: x_include_local_ind => x_include_local_ind,
424: x_include_other_ind => x_include_other_ind,

Line 422: x_include_standard_ind => x_include_standard_ind,

418: x_display_order => x_display_order,
419: x_timeframe => x_timeframe,
420: x_standard_ind => x_standard_ind,
421: x_display_ind => x_display_ind,
422: x_include_standard_ind => x_include_standard_ind,
423: x_include_local_ind => x_include_local_ind,
424: x_include_other_ind => x_include_other_ind,
425: x_creation_date => x_last_update_date,
426: x_created_by => x_last_updated_by,

Line 437: standard_ind,

433: stat_type,
434: org_unit_cd,
435: display_order,
436: timeframe,
437: standard_ind,
438: display_ind,
439: include_standard_ind,
440: include_local_ind,
441: include_other_ind,

Line 439: include_standard_ind,

435: display_order,
436: timeframe,
437: standard_ind,
438: display_ind,
439: include_standard_ind,
440: include_local_ind,
441: include_other_ind,
442: creation_date,
443: created_by,

Line 452: new_references.standard_ind,

448: new_references.stat_type,
449: new_references.org_unit_cd,
450: new_references.display_order,
451: new_references.timeframe,
452: new_references.standard_ind,
453: new_references.display_ind,
454: new_references.include_standard_ind,
455: new_references.include_local_ind,
456: new_references.include_other_ind,

Line 454: new_references.include_standard_ind,

450: new_references.display_order,
451: new_references.timeframe,
452: new_references.standard_ind,
453: new_references.display_ind,
454: new_references.include_standard_ind,
455: new_references.include_local_ind,
456: new_references.include_other_ind,
457: x_last_update_date,
458: x_last_updated_by,

Line 493: orst.standard_ind

489: */
490:
491: CURSOR c1(l_org_unit_cd igs_pr_org_stat.org_unit_cd%TYPE) IS
492: SELECT orst.timeframe,
493: orst.standard_ind
494: FROM igs_pr_org_stat orst
495: WHERE orst.org_unit_cd = l_org_unit_cd
496: AND ( orst.standard_ind = 'Y');
497:

Line 496: AND ( orst.standard_ind = 'Y');

492: SELECT orst.timeframe,
493: orst.standard_ind
494: FROM igs_pr_org_stat orst
495: WHERE orst.org_unit_cd = l_org_unit_cd
496: AND ( orst.standard_ind = 'Y');
497:
498: CURSOR c2 IS
499: SELECT orst.timeframe
500: FROM igs_pr_org_stat orst

Line 501: WHERE orst.standard_ind = 'Y'

497:
498: CURSOR c2 IS
499: SELECT orst.timeframe
500: FROM igs_pr_org_stat orst
501: WHERE orst.standard_ind = 'Y'
502: AND orst.org_unit_cd = x_org_unit_cd
503: GROUP BY orst.timeframe
504: HAVING COUNT(orst.timeframe) > 1;
505:

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

508: l_both_std_flag VARCHAR2(1) :='N';
509: dummy VARCHAR2(50);
510: BEGIN
511: FOR l_c1_rec IN c1(x_org_unit_cd) LOOP
512: IF l_c1_rec.standard_ind = 'Y' THEN
513: IF l_std_ind = 'N' THEN
514: l_std_ind := 'Y';
515: IF l_c1_rec.timeframe = 'BOTH' THEN
516: l_both_std_flag := 'Y';

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

518: ELSIF l_std_ind = 'Y'
519: AND (l_c1_rec.timeframe = 'BOTH'
520: OR l_both_std_flag ='Y' ) THEN
521: fnd_message.set_name ('IGS','IGS_PR_STAT_TYPE_IND');
522: FND_MESSAGE.SET_TOKEN('STATTYPE_IND','Standard');
523: igs_ge_msg_stack.add;
524: app_exception.raise_exception;
525: END IF;
526: END IF;

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

528: OPEN c2;
529: FETCH c2 INTO dummy;
530: IF c2%FOUND THEN
531: fnd_message.set_name ('IGS','IGS_PR_STAT_TYPE_IND');
532: FND_MESSAGE.SET_TOKEN('STATTYPE_IND','Standard');
533: igs_ge_msg_stack.add;
534: app_exception.raise_exception;
535: END IF;
536: CLOSE c2;

Line 546: x_standard_ind IN VARCHAR2,

542: x_stat_type IN VARCHAR2,
543: x_org_unit_cd IN VARCHAR2,
544: x_display_order IN NUMBER,
545: x_timeframe IN VARCHAR2,
546: x_standard_ind IN VARCHAR2,
547: x_display_ind IN VARCHAR2,
548: x_include_standard_ind IN VARCHAR2,
549: x_include_local_ind IN VARCHAR2,
550: x_include_other_ind IN VARCHAR2

Line 548: x_include_standard_ind IN VARCHAR2,

544: x_display_order IN NUMBER,
545: x_timeframe IN VARCHAR2,
546: x_standard_ind IN VARCHAR2,
547: x_display_ind IN VARCHAR2,
548: x_include_standard_ind IN VARCHAR2,
549: x_include_local_ind IN VARCHAR2,
550: x_include_other_ind IN VARCHAR2
551: ) AS
552: /*

Line 567: standard_ind,

563: CURSOR c1 IS
564: SELECT
565: display_order,
566: timeframe,
567: standard_ind,
568: display_ind,
569: include_standard_ind,
570: include_local_ind,
571: include_other_ind

Line 569: include_standard_ind,

565: display_order,
566: timeframe,
567: standard_ind,
568: display_ind,
569: include_standard_ind,
570: include_local_ind,
571: include_other_ind
572: FROM igs_pr_org_stat
573: WHERE rowid = x_rowid

Line 594: AND (tlinfo.standard_ind = x_standard_ind)

590:
591: IF (
592: (tlinfo.display_order = x_display_order)
593: AND (tlinfo.timeframe = x_timeframe)
594: AND (tlinfo.standard_ind = x_standard_ind)
595: AND (tlinfo.display_ind = x_display_ind)
596: AND (tlinfo.include_standard_ind = x_include_standard_ind)
597: AND (tlinfo.include_local_ind = x_include_local_ind)
598: AND (tlinfo.include_other_ind = x_include_other_ind)

Line 596: AND (tlinfo.include_standard_ind = x_include_standard_ind)

592: (tlinfo.display_order = x_display_order)
593: AND (tlinfo.timeframe = x_timeframe)
594: AND (tlinfo.standard_ind = x_standard_ind)
595: AND (tlinfo.display_ind = x_display_ind)
596: AND (tlinfo.include_standard_ind = x_include_standard_ind)
597: AND (tlinfo.include_local_ind = x_include_local_ind)
598: AND (tlinfo.include_other_ind = x_include_other_ind)
599: ) THEN
600: NULL;

Line 618: x_standard_ind IN VARCHAR2,

614: x_stat_type IN VARCHAR2,
615: x_org_unit_cd IN VARCHAR2,
616: x_display_order IN NUMBER,
617: x_timeframe IN VARCHAR2,
618: x_standard_ind IN VARCHAR2,
619: x_display_ind IN VARCHAR2,
620: x_include_standard_ind IN VARCHAR2,
621: x_include_local_ind IN VARCHAR2,
622: x_include_other_ind IN VARCHAR2,

Line 620: x_include_standard_ind IN VARCHAR2,

616: x_display_order IN NUMBER,
617: x_timeframe IN VARCHAR2,
618: x_standard_ind IN VARCHAR2,
619: x_display_ind IN VARCHAR2,
620: x_include_standard_ind IN VARCHAR2,
621: x_include_local_ind IN VARCHAR2,
622: x_include_other_ind IN VARCHAR2,
623: x_mode IN VARCHAR2
624: ) AS

Line 666: x_standard_ind => x_standard_ind,

662: x_stat_type => x_stat_type,
663: x_org_unit_cd => x_org_unit_cd,
664: x_display_order => x_display_order,
665: x_timeframe => x_timeframe,
666: x_standard_ind => x_standard_ind,
667: x_display_ind => x_display_ind,
668: x_include_standard_ind => x_include_standard_ind,
669: x_include_local_ind => x_include_local_ind,
670: x_include_other_ind => x_include_other_ind,

Line 668: x_include_standard_ind => x_include_standard_ind,

664: x_display_order => x_display_order,
665: x_timeframe => x_timeframe,
666: x_standard_ind => x_standard_ind,
667: x_display_ind => x_display_ind,
668: x_include_standard_ind => x_include_standard_ind,
669: x_include_local_ind => x_include_local_ind,
670: x_include_other_ind => x_include_other_ind,
671: x_creation_date => x_last_update_date,
672: x_created_by => x_last_updated_by,

Line 682: standard_ind = new_references.standard_ind,

678: UPDATE igs_pr_org_stat
679: SET
680: display_order = new_references.display_order,
681: timeframe = new_references.timeframe,
682: standard_ind = new_references.standard_ind,
683: display_ind = new_references.display_ind,
684: include_standard_ind = new_references.include_standard_ind,
685: include_local_ind = new_references.include_local_ind,
686: include_other_ind = new_references.include_other_ind,

Line 684: include_standard_ind = new_references.include_standard_ind,

680: display_order = new_references.display_order,
681: timeframe = new_references.timeframe,
682: standard_ind = new_references.standard_ind,
683: display_ind = new_references.display_ind,
684: include_standard_ind = new_references.include_standard_ind,
685: include_local_ind = new_references.include_local_ind,
686: include_other_ind = new_references.include_other_ind,
687: last_update_date = x_last_update_date,
688: last_updated_by = x_last_updated_by,

Line 705: x_standard_ind IN VARCHAR2,

701: x_stat_type IN VARCHAR2,
702: x_org_unit_cd IN VARCHAR2,
703: x_display_order IN NUMBER,
704: x_timeframe IN VARCHAR2,
705: x_standard_ind IN VARCHAR2,
706: x_display_ind IN VARCHAR2,
707: x_include_standard_ind IN VARCHAR2,
708: x_include_local_ind IN VARCHAR2,
709: x_include_other_ind IN VARCHAR2,

Line 707: x_include_standard_ind IN VARCHAR2,

703: x_display_order IN NUMBER,
704: x_timeframe IN VARCHAR2,
705: x_standard_ind IN VARCHAR2,
706: x_display_ind IN VARCHAR2,
707: x_include_standard_ind IN VARCHAR2,
708: x_include_local_ind IN VARCHAR2,
709: x_include_other_ind IN VARCHAR2,
710: x_mode IN VARCHAR2
711: ) AS

Line 740: x_standard_ind,

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

Line 742: x_include_standard_ind,

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

Line 757: x_standard_ind,

753: x_stat_type,
754: x_org_unit_cd,
755: x_display_order,
756: x_timeframe,
757: x_standard_ind,
758: x_display_ind,
759: x_include_standard_ind,
760: x_include_local_ind,
761: x_include_other_ind,

Line 759: x_include_standard_ind,

755: x_display_order,
756: x_timeframe,
757: x_standard_ind,
758: x_display_ind,
759: x_include_standard_ind,
760: x_include_local_ind,
761: x_include_other_ind,
762: x_mode
763: );