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_ORGANZTN_CT

Line 573: hri_cs_organztn_ct org_wrkrs

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: );
577: --

Line 752: /* Load HRI_CS_ORGANZTN_CT table in full */

748:
749: END load;
750:
751: /******************************************************************************/
752: /* Load HRI_CS_ORGANZTN_CT table in full */
753: /******************************************************************************/
754:
755: PROCEDURE load_org_with_workers_full IS
756:

Line 771: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_CS_ORGANZTN_CT';

767: /* Get HRI schema name - get_app_info populates l_schema */
768: IF fnd_installation.get_app_info('HRI',l_dummy1, l_dummy2, l_schema) THEN
769:
770: /* Empty out organization with workers table */
771: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_CS_ORGANZTN_CT';
772: EXECUTE IMMEDIATE(l_sql_stmt);
773:
774: /* Write timing information to log */
775: output('Truncated org with worker table: ' ||

Line 779: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_ORGANZTN_CT_WHO DISABLE');

775: output('Truncated org with worker table: ' ||
776: to_char(sysdate,'HH24:MI:SS'));
777:
778: /* Disable WHO trigger */
779: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_ORGANZTN_CT_WHO DISABLE');
780:
781: /* Drop all the indexes on the table */
782: hri_utl_ddl.log_and_drop_indexes
783: (p_application_short_name => 'HRI',

Line 784: p_table_name => 'HRI_CS_ORGANZTN_CT',

780:
781: /* Drop all the indexes on the table */
782: hri_utl_ddl.log_and_drop_indexes
783: (p_application_short_name => 'HRI',
784: p_table_name => 'HRI_CS_ORGANZTN_CT',
785: p_table_owner => l_schema);
786:
787: /* Write timing information to log */
788: output('Disabled indexes/WHO trigger: ' ||

Line 795: INSERT /+ APPEND / INTO HRI_CS_ORGANZTN_CT

791: /* Enable parallel DML */
792: run_sql_stmt_noerr('ALTER SESSION ENABLE PARALLEL DML');
793:
794: /* Insert new org with worker records */
795: INSERT /*+ APPEND */ INTO HRI_CS_ORGANZTN_CT
796: (org_organztn_pk,
797: org_has_workers_flag,
798: last_update_date,
799: last_updated_by,

Line 822: p_table_name => 'HRI_CS_ORGANZTN_CT',

818:
819: /* Recreate indexes */
820: hri_utl_ddl.recreate_indexes
821: (p_application_short_name => 'HRI',
822: p_table_name => 'HRI_CS_ORGANZTN_CT',
823: p_table_owner => l_schema);
824:
825: /* Enable WHO trigger */
826: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_ORGANZTN_CT_WHO ENABLE');

Line 826: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_ORGANZTN_CT_WHO ENABLE');

822: p_table_name => 'HRI_CS_ORGANZTN_CT',
823: p_table_owner => l_schema);
824:
825: /* Enable WHO trigger */
826: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_ORGANZTN_CT_WHO ENABLE');
827:
828: /* Write timing information to log */
829: output('Enabled indexes/WHO trigger: ' ||
830: to_char(sysdate,'HH24:MI:SS'));

Line 837: /* Load HRI_CS_ORGANZTN_CT table incrementally */

833:
834: END load_org_with_workers_full;
835: --
836: /******************************************************************************/
837: /* Load HRI_CS_ORGANZTN_CT table incrementally */
838: /******************************************************************************/
839:
840: PROCEDURE load_org_with_workers_incr
841: IS

Line 848: FROM hri_cs_organztn_ct org

844: --
845: SELECT DISTINCT asg.organization_id
846: FROM per_all_assignments_f asg
847: WHERE not exists (SELECT null
848: FROM hri_cs_organztn_ct org
849: WHERE org.org_organztn_pk = asg.organization_id);
850: --
851: BEGIN
852: --

Line 865: INSERT INTO HRI_CS_ORGANZTN_CT

861: --
862: IF g_new_orgs_with_worker.COUNT > 0 THEN
863: --
864: FORALL i IN g_new_orgs_with_worker.FIRST..g_new_orgs_with_worker.LAST
865: INSERT INTO HRI_CS_ORGANZTN_CT
866: (org_organztn_pk
867: ,org_has_workers_flag
868: ,last_update_date
869: ,last_updated_by

Line 915: p_process_table_name => 'HRI_CS_ORGANZTN_CT');

911: /* Determine full or incremental refresh */
912:
913: l_full_refresh := hri_oltp_conc_param.get_parameter_value
914: (p_parameter_name => 'FULL_REFRESH',
915: p_process_table_name => 'HRI_CS_ORGANZTN_CT');
916:
917: IF l_full_refresh = 'Y' THEN
918:
919: /* Call main function to full refresh */

Line 931: hri_bpl_conc_log.record_process_start('HRI_CS_ORGANZTN_CT');

927:
928: END IF;
929:
930: /* Log process end */
931: hri_bpl_conc_log.record_process_start('HRI_CS_ORGANZTN_CT');
932: hri_bpl_conc_log.log_process_end(
933: p_status => TRUE
934: ,p_period_from => TRUNC(SYSDATE)
935: ,p_period_to => TRUNC(SYSDATE)

Line 977: /* assigned a organization not existing in table HRI_CS_ORGANZTN_CT */

973:
974: ELSE
975:
976: /* Incremental support for update of worker flags when a worker is */
977: /* assigned a organization not existing in table HRI_CS_ORGANZTN_CT */
978:
979: upd_org_has_worker_flags_incr;
980:
981: /* Incremental support still to be added if it can be done */