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.HRI_OPL_ORGH_CT dependencies on HRI_CS_ORGH_CT

Line 132: INSERT INTO hri_cs_orgh_ct

128:
129: -- Trap unique constraint errors
130: BEGIN
131:
132: INSERT INTO hri_cs_orgh_ct
133: (orgh_orghrchy_fk
134: ,orgh_global_flag
135: ,orgh_orghvrsn_fk
136: ,orgh_sup_organztn_fk

Line 197: INSERT INTO hri_cs_orgh_ct

193:
194: BEGIN
195: -- insert chunk of rows
196: FORALL i IN 1..g_cs_rows_to_insert
197: INSERT INTO hri_cs_orgh_ct
198: (orgh_orghrchy_fk
199: ,orgh_global_flag
200: ,orgh_orghvrsn_fk
201: ,orgh_sup_organztn_fk

Line 569: UPDATE /+ PARALLEL / hri_cs_orgh_ct orgh

565: --
566: -- Update flag orgh_sub_org_has_workers_flag. This flag is set to 'Y' when
567: -- the subordinate organization has workers. Else, it is 'N'.
568: --
569: UPDATE /*+ PARALLEL */ hri_cs_orgh_ct orgh
570: SET orgh.orgh_sub_org_has_workers_flag = 'Y'
571: WHERE orgh.rowid IN (SELECT sub_org.rowid
572: FROM hri_cs_orgh_ct sub_org,
573: hri_cs_organztn_ct org_wrkrs

Line 572: FROM hri_cs_orgh_ct sub_org,

568: --
569: UPDATE /*+ PARALLEL */ hri_cs_orgh_ct orgh
570: SET orgh.orgh_sub_org_has_workers_flag = 'Y'
571: WHERE orgh.rowid IN (SELECT sub_org.rowid
572: FROM hri_cs_orgh_ct sub_org,
573: hri_cs_organztn_ct org_wrkrs
574: WHERE sub_org.orgh_organztn_fk = org_wrkrs.org_organztn_pk
575: AND org_wrkrs.org_has_workers_flag = 'Y'
576: );

Line 588: UPDATE /+ PARALLEL(orgh) / hri_cs_orgh_ct orgh

584: -- Update flag orgh_node_has_workers_flag. This flag is set to 'Y' when
585: -- the supervisor organization has workers for any of its subordinate
586: -- organizations. Else, it is 'N'.
587: --
588: UPDATE /*+ PARALLEL(orgh) */ hri_cs_orgh_ct orgh
589: SET orgh.orgh_sub_node_has_workers_flag = 'Y'
590: WHERE orgh.rowid IN (
591: SELECT sup_org.rowid
592: FROM hri_cs_orgh_ct sup_org

Line 592: FROM hri_cs_orgh_ct sup_org

588: UPDATE /*+ PARALLEL(orgh) */ hri_cs_orgh_ct orgh
589: SET orgh.orgh_sub_node_has_workers_flag = 'Y'
590: WHERE orgh.rowid IN (
591: SELECT sup_org.rowid
592: FROM hri_cs_orgh_ct sup_org
593: WHERE EXISTS (SELECT null
594: FROM hri_cs_orgh_ct sub_org
595: WHERE sup_org.orgh_organztn_fk = sub_org.orgh_sup_organztn_fk
596: AND sub_org.orgh_sub_org_has_workers_flag = 'Y'));

Line 594: FROM hri_cs_orgh_ct sub_org

590: WHERE orgh.rowid IN (
591: SELECT sup_org.rowid
592: FROM hri_cs_orgh_ct sup_org
593: WHERE EXISTS (SELECT null
594: FROM hri_cs_orgh_ct sub_org
595: WHERE sup_org.orgh_organztn_fk = sub_org.orgh_sup_organztn_fk
596: AND sub_org.orgh_sub_org_has_workers_flag = 'Y'));
597: --
598: COMMIT;

Line 627: UPDATE hri_cs_orgh_ct orgh

623: -- Update flag orgh_sub_org_has_workers_flag. This flag is set to 'Y' when
624: -- the subordinate organization has workers. Else, it is 'N'.
625: --
626: FORALL i IN g_new_orgs_with_worker.FIRST..g_new_orgs_with_worker.LAST
627: UPDATE hri_cs_orgh_ct orgh
628: SET orgh.orgh_sub_org_has_workers_flag = 'Y'
629: WHERE orgh.rowid IN (SELECT sub_org.rowid
630: FROM hri_cs_orgh_ct sub_org
631: WHERE sub_org.orgh_organztn_fk = g_new_orgs_with_worker(i)

Line 630: FROM hri_cs_orgh_ct sub_org

626: FORALL i IN g_new_orgs_with_worker.FIRST..g_new_orgs_with_worker.LAST
627: UPDATE hri_cs_orgh_ct orgh
628: SET orgh.orgh_sub_org_has_workers_flag = 'Y'
629: WHERE orgh.rowid IN (SELECT sub_org.rowid
630: FROM hri_cs_orgh_ct sub_org
631: WHERE sub_org.orgh_organztn_fk = g_new_orgs_with_worker(i)
632: );
633: --
634: COMMIT;

Line 645: UPDATE hri_cs_orgh_ct orgh

641: -- the supervisor organization has workers for any of its subordinate
642: -- organizations. Else, it is 'N'.
643: --
644: FORALL i IN g_new_orgs_with_worker.FIRST..g_new_orgs_with_worker.LAST
645: UPDATE hri_cs_orgh_ct orgh
646: SET orgh.orgh_sub_node_has_workers_flag = 'Y'
647: WHERE orgh.rowid IN (
648: SELECT sup_org.rowid
649: FROM hri_cs_orgh_ct sup_org

Line 649: FROM hri_cs_orgh_ct sup_org

645: UPDATE hri_cs_orgh_ct orgh
646: SET orgh.orgh_sub_node_has_workers_flag = 'Y'
647: WHERE orgh.rowid IN (
648: SELECT sup_org.rowid
649: FROM hri_cs_orgh_ct sup_org
650: WHERE EXISTS (SELECT null
651: FROM hri_cs_orgh_ct sub_org
652: WHERE sup_org.orgh_organztn_fk = sub_org.orgh_sup_organztn_fk
653: AND sub_org.orgh_organztn_fk = g_new_orgs_with_worker(i)

Line 651: FROM hri_cs_orgh_ct sub_org

647: WHERE orgh.rowid IN (
648: SELECT sup_org.rowid
649: FROM hri_cs_orgh_ct sup_org
650: WHERE EXISTS (SELECT null
651: FROM hri_cs_orgh_ct sub_org
652: WHERE sup_org.orgh_organztn_fk = sub_org.orgh_sup_organztn_fk
653: AND sub_org.orgh_organztn_fk = g_new_orgs_with_worker(i)
654: AND sub_org.orgh_sub_org_has_workers_flag = 'Y')
655: AND sup_org.orgh_sub_node_has_workers_flag = 'N');

Line 703: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_CS_ORGH_CT';

699: /* Get HRI schema name - get_app_info populates l_schema */
700: IF fnd_installation.get_app_info('HRI',l_dummy1, l_dummy2, l_schema) THEN
701:
702: /* Empty out organization hierarchy tables */
703: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_CS_ORGH_CT';
704: EXECUTE IMMEDIATE(l_sql_stmt);
705:
706: /* Write timing information to log */
707: output('Truncated organization hierarchy tables: ' ||

Line 711: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_ORGH_CT_WHO DISABLE');

707: output('Truncated organization hierarchy tables: ' ||
708: to_char(sysdate,'HH24:MI:SS'));
709:
710: /* Disable WHO trigger */
711: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_ORGH_CT_WHO DISABLE');
712:
713: /* Drop all the indexes on the table */
714: hri_utl_ddl.log_and_drop_indexes
715: (p_application_short_name => 'HRI',

Line 716: p_table_name => 'HRI_CS_ORGH_CT',

712:
713: /* Drop all the indexes on the table */
714: hri_utl_ddl.log_and_drop_indexes
715: (p_application_short_name => 'HRI',
716: p_table_name => 'HRI_CS_ORGH_CT',
717: p_table_owner => l_schema);
718:
719: /* Write timing information to log */
720: output('Disabled indexes/WHO trigger: ' ||

Line 733: p_table_name => 'HRI_CS_ORGH_CT',

729:
730: /* Recreate indexes */
731: hri_utl_ddl.recreate_indexes
732: (p_application_short_name => 'HRI',
733: p_table_name => 'HRI_CS_ORGH_CT',
734: p_table_owner => l_schema);
735:
736: /* Update flags to determine if orgs/nodes have workers */
737:

Line 741: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_ORGH_CT_WHO ENABLE');

737:
738: upd_org_has_worker_flags_full;
739:
740: /* Enable WHO trigger */
741: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_ORGH_CT_WHO ENABLE');
742:
743: /* Write timing information to log */
744: output('Enabled indexes/WHO trigger: ' ||
745: to_char(sysdate,'HH24:MI:SS'));

Line 966: p_process_table_name => 'HRI_CS_ORGH_CT');

962:
963: /* Determine full or incremental refresh */
964: l_full_refresh := hri_oltp_conc_param.get_parameter_value
965: (p_parameter_name => 'FULL_REFRESH',
966: p_process_table_name => 'HRI_CS_ORGH_CT');
967:
968: IF l_full_refresh = 'Y' THEN
969:
970: /* Call main function to full refresh */

Line 988: hri_bpl_conc_log.record_process_start('HRI_CS_ORGH_CT');

984: --
985: END IF;
986:
987: /* Log process end */
988: hri_bpl_conc_log.record_process_start('HRI_CS_ORGH_CT');
989: hri_bpl_conc_log.log_process_end(
990: p_status => TRUE
991: ,p_period_from => TRUNC(SYSDATE)
992: ,p_period_to => TRUNC(SYSDATE)