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_OR_GEN_001 dependencies on IGS_OR_STATUS

Line 323: IGS_OR_STATUS

319: IS
320: SELECT IGS_OR_UNIT.org_unit_cd,
321: IGS_OR_UNIT.start_dt
322: FROM IGS_OR_UNIT,
323: IGS_OR_STATUS
324: WHERE IGS_OR_UNIT.institution_cd = p_institution_cd
325: AND IGS_OR_STATUS.org_status = IGS_OR_UNIT.org_status
326: AND IGS_OR_STATUS.s_org_status = 'ACTIVE'
327: ORDER BY IGS_OR_UNIT.institution_cd;

Line 325: AND IGS_OR_STATUS.org_status = IGS_OR_UNIT.org_status

321: IGS_OR_UNIT.start_dt
322: FROM IGS_OR_UNIT,
323: IGS_OR_STATUS
324: WHERE IGS_OR_UNIT.institution_cd = p_institution_cd
325: AND IGS_OR_STATUS.org_status = IGS_OR_UNIT.org_status
326: AND IGS_OR_STATUS.s_org_status = 'ACTIVE'
327: ORDER BY IGS_OR_UNIT.institution_cd;
328:
329: CURSOR c_ou_parent (

Line 326: AND IGS_OR_STATUS.s_org_status = 'ACTIVE'

322: FROM IGS_OR_UNIT,
323: IGS_OR_STATUS
324: WHERE IGS_OR_UNIT.institution_cd = p_institution_cd
325: AND IGS_OR_STATUS.org_status = IGS_OR_UNIT.org_status
326: AND IGS_OR_STATUS.s_org_status = 'ACTIVE'
327: ORDER BY IGS_OR_UNIT.institution_cd;
328:
329: CURSOR c_ou_parent (
330: cp_org_unit_cd IGS_OR_UNIT_REL.parent_org_unit_cd%TYPE,

Line 336: IGS_OR_STATUS

332: SELECT parent_org_unit_cd,
333: parent_start_dt
334: FROM IGS_OR_UNIT_REL,
335: IGS_OR_UNIT,
336: IGS_OR_STATUS
337: WHERE child_org_unit_cd = cp_org_unit_cd
338: AND child_start_dt = cp_start_dt
339: AND logical_delete_dt IS NULL
340: AND org_unit_cd = parent_org_unit_cd

Line 342: AND IGS_OR_STATUS.org_status = IGS_OR_UNIT.org_status

338: AND child_start_dt = cp_start_dt
339: AND logical_delete_dt IS NULL
340: AND org_unit_cd = parent_org_unit_cd
341: AND start_dt = parent_start_dt
342: AND IGS_OR_STATUS.org_status = IGS_OR_UNIT.org_status
343: AND IGS_OR_STATUS.s_org_status = 'ACTIVE';
344:
345: ou_parent c_ou_parent%ROWTYPE;
346:

Line 343: AND IGS_OR_STATUS.s_org_status = 'ACTIVE';

339: AND logical_delete_dt IS NULL
340: AND org_unit_cd = parent_org_unit_cd
341: AND start_dt = parent_start_dt
342: AND IGS_OR_STATUS.org_status = IGS_OR_UNIT.org_status
343: AND IGS_OR_STATUS.s_org_status = 'ACTIVE';
344:
345: ou_parent c_ou_parent%ROWTYPE;
346:
347: -- Local function

Line 353: p_new_org_status IN IGS_OR_STATUS.s_org_status%TYPE,

349: p_org_unit_cd IN IGS_OR_UNIT.org_unit_cd%TYPE,
350: p_start_dt IN IGS_OR_UNIT.start_dt%TYPE,
351: p_org_instn_cd IN IGS_OR_UNIT.institution_cd%TYPE,
352: p_institution_cd IN IGS_OR_UNIT.institution_cd%TYPE,
353: p_new_org_status IN IGS_OR_STATUS.s_org_status%TYPE,
354: p_complete OUT NOCOPY BOOLEAN)
355: RETURN BOOLEAN IS
356:
357: v_update_ou BOOLEAN;

Line 368: IGS_OR_STATUS

364: IGS_OR_UNIT_REL.child_start_dt,
365: IGS_OR_UNIT.institution_cd
366: FROM IGS_OR_UNIT_REL,
367: IGS_OR_UNIT,
368: IGS_OR_STATUS
369: WHERE IGS_OR_UNIT_REL.parent_org_unit_cd = p_org_unit_cd
370: AND IGS_OR_UNIT_REL.parent_start_dt = p_start_dt
371: AND IGS_OR_UNIT_REL.logical_delete_dt IS NULL
372: AND IGS_OR_UNIT.org_unit_cd = IGS_OR_UNIT_REL.child_org_unit_cd

Line 374: AND IGS_OR_STATUS.org_status = IGS_OR_UNIT.org_status

370: AND IGS_OR_UNIT_REL.parent_start_dt = p_start_dt
371: AND IGS_OR_UNIT_REL.logical_delete_dt IS NULL
372: AND IGS_OR_UNIT.org_unit_cd = IGS_OR_UNIT_REL.child_org_unit_cd
373: AND IGS_OR_UNIT.start_dt = IGS_OR_UNIT_REL.child_start_dt
374: AND IGS_OR_STATUS.org_status = IGS_OR_UNIT.org_status
375: AND IGS_OR_STATUS.s_org_status = 'ACTIVE';
376:
377: -- Fetch other active parents.
378: CURSOR c_our_ou_os_parent (

Line 375: AND IGS_OR_STATUS.s_org_status = 'ACTIVE';

371: AND IGS_OR_UNIT_REL.logical_delete_dt IS NULL
372: AND IGS_OR_UNIT.org_unit_cd = IGS_OR_UNIT_REL.child_org_unit_cd
373: AND IGS_OR_UNIT.start_dt = IGS_OR_UNIT_REL.child_start_dt
374: AND IGS_OR_STATUS.org_status = IGS_OR_UNIT.org_status
375: AND IGS_OR_STATUS.s_org_status = 'ACTIVE';
376:
377: -- Fetch other active parents.
378: CURSOR c_our_ou_os_parent (
379: cp_parent_org_unit_cd IGS_OR_UNIT_REL.parent_org_unit_cd%TYPE,

Line 387: IGS_OR_STATUS

383: SELECT parent_org_unit_cd,
384: parent_start_dt
385: FROM IGS_OR_UNIT_REL,
386: IGS_OR_UNIT,
387: IGS_OR_STATUS
388: WHERE child_org_unit_cd = cp_child_org_unit_cd
389: AND child_start_dt = cp_child_start_dt
390: AND NOT (
391: parent_org_unit_cd = cp_parent_org_unit_cd AND

Line 396: AND IGS_OR_STATUS.org_status = IGS_OR_UNIT.org_status

392: parent_start_dt = cp_parent_start_dt)
393: AND logical_delete_dt IS NULL
394: AND org_unit_cd = parent_org_unit_cd
395: AND start_dt = parent_start_dt
396: AND IGS_OR_STATUS.org_status = IGS_OR_UNIT.org_status
397: AND IGS_OR_STATUS.s_org_status = 'ACTIVE';
398:
399:
400: v_rowid VARCHAR2(25);

Line 397: AND IGS_OR_STATUS.s_org_status = 'ACTIVE';

393: AND logical_delete_dt IS NULL
394: AND org_unit_cd = parent_org_unit_cd
395: AND start_dt = parent_start_dt
396: AND IGS_OR_STATUS.org_status = IGS_OR_UNIT.org_status
397: AND IGS_OR_STATUS.s_org_status = 'ACTIVE';
398:
399:
400: v_rowid VARCHAR2(25);
401:

Line 601: IGS_OR_STATUS

597: SELECT child_org_unit_cd,
598: child_start_dt
599: FROM IGS_OR_UNIT_REL,
600: IGS_OR_UNIT,
601: IGS_OR_STATUS
602: WHERE parent_org_unit_cd = p_org_unit_cd
603: AND parent_start_dt = p_start_dt
604: AND logical_delete_dt IS NULL
605: AND org_unit_cd = child_org_unit_cd

Line 607: AND IGS_OR_STATUS.org_status = IGS_OR_UNIT.org_status

603: AND parent_start_dt = p_start_dt
604: AND logical_delete_dt IS NULL
605: AND org_unit_cd = child_org_unit_cd
606: AND start_dt = child_start_dt
607: AND IGS_OR_STATUS.org_status = IGS_OR_UNIT.org_status
608: AND IGS_OR_STATUS.s_org_status = 'ACTIVE';
609:
610: -- Fetch other active parents.
611: CURSOR c_our_ou_os_parent (

Line 608: AND IGS_OR_STATUS.s_org_status = 'ACTIVE';

604: AND logical_delete_dt IS NULL
605: AND org_unit_cd = child_org_unit_cd
606: AND start_dt = child_start_dt
607: AND IGS_OR_STATUS.org_status = IGS_OR_UNIT.org_status
608: AND IGS_OR_STATUS.s_org_status = 'ACTIVE';
609:
610: -- Fetch other active parents.
611: CURSOR c_our_ou_os_parent (
612: cp_parent_org_unit_cd IGS_OR_UNIT_REL.parent_org_unit_cd%TYPE,

Line 620: IGS_OR_STATUS

616: SELECT parent_org_unit_cd,
617: parent_start_dt
618: FROM IGS_OR_UNIT_REL,
619: IGS_OR_UNIT,
620: IGS_OR_STATUS
621: WHERE child_org_unit_cd = cp_child_org_unit_cd
622: AND child_start_dt = cp_child_start_dt
623: AND NOT (
624: parent_org_unit_cd = cp_parent_org_unit_cd AND

Line 629: AND IGS_OR_STATUS.org_status = IGS_OR_UNIT.org_status

625: parent_start_dt = cp_parent_start_dt)
626: AND logical_delete_dt IS NULL
627: AND org_unit_cd = parent_org_unit_cd
628: AND start_dt = parent_start_dt
629: AND IGS_OR_STATUS.org_status = IGS_OR_UNIT.org_status
630: AND IGS_OR_STATUS.s_org_status = 'ACTIVE';
631:
632: v_update_ou BOOLEAN;
633: v_other_active_parent BOOLEAN;

Line 630: AND IGS_OR_STATUS.s_org_status = 'ACTIVE';

626: AND logical_delete_dt IS NULL
627: AND org_unit_cd = parent_org_unit_cd
628: AND start_dt = parent_start_dt
629: AND IGS_OR_STATUS.org_status = IGS_OR_UNIT.org_status
630: AND IGS_OR_STATUS.s_org_status = 'ACTIVE';
631:
632: v_update_ou BOOLEAN;
633: v_other_active_parent BOOLEAN;
634: v_other_detail VARCHAR2(255);