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.HZ_ORGANIZATION_PROFILES_PKG dependencies on HZ_UTILITY_V2PUB

Line 544: hz_utility_v2pub.last_update_date,

540: DECODE(x_parent_sub_ind,
541: fnd_api.g_miss_char, NULL,
542: x_parent_sub_ind),
543: DECODE(x_incorp_year, fnd_api.g_miss_num, NULL, x_incorp_year),
544: hz_utility_v2pub.last_update_date,
545: hz_utility_v2pub.last_updated_by,
546: hz_utility_v2pub.creation_date,
547: hz_utility_v2pub.created_by,
548: hz_utility_v2pub.last_update_login,

Line 545: hz_utility_v2pub.last_updated_by,

541: fnd_api.g_miss_char, NULL,
542: x_parent_sub_ind),
543: DECODE(x_incorp_year, fnd_api.g_miss_num, NULL, x_incorp_year),
544: hz_utility_v2pub.last_update_date,
545: hz_utility_v2pub.last_updated_by,
546: hz_utility_v2pub.creation_date,
547: hz_utility_v2pub.created_by,
548: hz_utility_v2pub.last_update_login,
549: hz_utility_v2pub.request_id,

Line 546: hz_utility_v2pub.creation_date,

542: x_parent_sub_ind),
543: DECODE(x_incorp_year, fnd_api.g_miss_num, NULL, x_incorp_year),
544: hz_utility_v2pub.last_update_date,
545: hz_utility_v2pub.last_updated_by,
546: hz_utility_v2pub.creation_date,
547: hz_utility_v2pub.created_by,
548: hz_utility_v2pub.last_update_login,
549: hz_utility_v2pub.request_id,
550: hz_utility_v2pub.program_application_id,

Line 547: hz_utility_v2pub.created_by,

543: DECODE(x_incorp_year, fnd_api.g_miss_num, NULL, x_incorp_year),
544: hz_utility_v2pub.last_update_date,
545: hz_utility_v2pub.last_updated_by,
546: hz_utility_v2pub.creation_date,
547: hz_utility_v2pub.created_by,
548: hz_utility_v2pub.last_update_login,
549: hz_utility_v2pub.request_id,
550: hz_utility_v2pub.program_application_id,
551: hz_utility_v2pub.program_id,

Line 548: hz_utility_v2pub.last_update_login,

544: hz_utility_v2pub.last_update_date,
545: hz_utility_v2pub.last_updated_by,
546: hz_utility_v2pub.creation_date,
547: hz_utility_v2pub.created_by,
548: hz_utility_v2pub.last_update_login,
549: hz_utility_v2pub.request_id,
550: hz_utility_v2pub.program_application_id,
551: hz_utility_v2pub.program_id,
552: hz_utility_v2pub.program_update_date,

Line 549: hz_utility_v2pub.request_id,

545: hz_utility_v2pub.last_updated_by,
546: hz_utility_v2pub.creation_date,
547: hz_utility_v2pub.created_by,
548: hz_utility_v2pub.last_update_login,
549: hz_utility_v2pub.request_id,
550: hz_utility_v2pub.program_application_id,
551: hz_utility_v2pub.program_id,
552: hz_utility_v2pub.program_update_date,
553: DECODE(x_content_source_type,

Line 550: hz_utility_v2pub.program_application_id,

546: hz_utility_v2pub.creation_date,
547: hz_utility_v2pub.created_by,
548: hz_utility_v2pub.last_update_login,
549: hz_utility_v2pub.request_id,
550: hz_utility_v2pub.program_application_id,
551: hz_utility_v2pub.program_id,
552: hz_utility_v2pub.program_update_date,
553: DECODE(x_content_source_type,
554: fnd_api.g_miss_char, g_miss_content_source_type,

Line 551: hz_utility_v2pub.program_id,

547: hz_utility_v2pub.created_by,
548: hz_utility_v2pub.last_update_login,
549: hz_utility_v2pub.request_id,
550: hz_utility_v2pub.program_application_id,
551: hz_utility_v2pub.program_id,
552: hz_utility_v2pub.program_update_date,
553: DECODE(x_content_source_type,
554: fnd_api.g_miss_char, g_miss_content_source_type,
555: NULL, g_miss_content_source_type,

Line 552: hz_utility_v2pub.program_update_date,

548: hz_utility_v2pub.last_update_login,
549: hz_utility_v2pub.request_id,
550: hz_utility_v2pub.program_application_id,
551: hz_utility_v2pub.program_id,
552: hz_utility_v2pub.program_update_date,
553: DECODE(x_content_source_type,
554: fnd_api.g_miss_char, g_miss_content_source_type,
555: NULL, g_miss_content_source_type,
556: x_content_source_type),

Line 561: fnd_api.g_miss_date, TRUNC(hz_utility_v2pub.creation_date),

557: DECODE(x_content_source_number,
558: fnd_api.g_miss_char, NULL,
559: x_content_source_number),
560: DECODE(x_effective_start_date,
561: fnd_api.g_miss_date, TRUNC(hz_utility_v2pub.creation_date),
562: NULL, TRUNC(hz_utility_v2pub.creation_date),
563: x_effective_start_date),
564: DECODE(x_effective_end_date,
565: fnd_api.g_miss_date, TO_DATE(NULL),

Line 562: NULL, TRUNC(hz_utility_v2pub.creation_date),

558: fnd_api.g_miss_char, NULL,
559: x_content_source_number),
560: DECODE(x_effective_start_date,
561: fnd_api.g_miss_date, TRUNC(hz_utility_v2pub.creation_date),
562: NULL, TRUNC(hz_utility_v2pub.creation_date),
563: x_effective_start_date),
564: DECODE(x_effective_end_date,
565: fnd_api.g_miss_date, TO_DATE(NULL),
566: x_effective_end_date),

Line 1376: hop.last_update_date = hz_utility_v2pub.last_update_date,

1372: DECODE(x_incorp_year,
1373: NULL, hop.incorp_year,
1374: fnd_api.g_miss_num, NULL,
1375: x_incorp_year),
1376: hop.last_update_date = hz_utility_v2pub.last_update_date,
1377: hop.last_updated_by = hz_utility_v2pub.last_updated_by,
1378: hop.creation_date = creation_date,
1379: hop.created_by = created_by,
1380: hop.last_update_login = hz_utility_v2pub.last_update_login,

Line 1377: hop.last_updated_by = hz_utility_v2pub.last_updated_by,

1373: NULL, hop.incorp_year,
1374: fnd_api.g_miss_num, NULL,
1375: x_incorp_year),
1376: hop.last_update_date = hz_utility_v2pub.last_update_date,
1377: hop.last_updated_by = hz_utility_v2pub.last_updated_by,
1378: hop.creation_date = creation_date,
1379: hop.created_by = created_by,
1380: hop.last_update_login = hz_utility_v2pub.last_update_login,
1381: hop.request_id = hz_utility_v2pub.request_id,

Line 1380: hop.last_update_login = hz_utility_v2pub.last_update_login,

1376: hop.last_update_date = hz_utility_v2pub.last_update_date,
1377: hop.last_updated_by = hz_utility_v2pub.last_updated_by,
1378: hop.creation_date = creation_date,
1379: hop.created_by = created_by,
1380: hop.last_update_login = hz_utility_v2pub.last_update_login,
1381: hop.request_id = hz_utility_v2pub.request_id,
1382: hop.program_application_id =
1383: hz_utility_v2pub.program_application_id,
1384: hop.program_id = hz_utility_v2pub.program_id,

Line 1381: hop.request_id = hz_utility_v2pub.request_id,

1377: hop.last_updated_by = hz_utility_v2pub.last_updated_by,
1378: hop.creation_date = creation_date,
1379: hop.created_by = created_by,
1380: hop.last_update_login = hz_utility_v2pub.last_update_login,
1381: hop.request_id = hz_utility_v2pub.request_id,
1382: hop.program_application_id =
1383: hz_utility_v2pub.program_application_id,
1384: hop.program_id = hz_utility_v2pub.program_id,
1385: hop.program_update_date = hz_utility_v2pub.program_update_date,

Line 1383: hz_utility_v2pub.program_application_id,

1379: hop.created_by = created_by,
1380: hop.last_update_login = hz_utility_v2pub.last_update_login,
1381: hop.request_id = hz_utility_v2pub.request_id,
1382: hop.program_application_id =
1383: hz_utility_v2pub.program_application_id,
1384: hop.program_id = hz_utility_v2pub.program_id,
1385: hop.program_update_date = hz_utility_v2pub.program_update_date,
1386: hop.content_source_type =
1387: DECODE(x_content_source_type,

Line 1384: hop.program_id = hz_utility_v2pub.program_id,

1380: hop.last_update_login = hz_utility_v2pub.last_update_login,
1381: hop.request_id = hz_utility_v2pub.request_id,
1382: hop.program_application_id =
1383: hz_utility_v2pub.program_application_id,
1384: hop.program_id = hz_utility_v2pub.program_id,
1385: hop.program_update_date = hz_utility_v2pub.program_update_date,
1386: hop.content_source_type =
1387: DECODE(x_content_source_type,
1388: NULL, hop.content_source_type,

Line 1385: hop.program_update_date = hz_utility_v2pub.program_update_date,

1381: hop.request_id = hz_utility_v2pub.request_id,
1382: hop.program_application_id =
1383: hz_utility_v2pub.program_application_id,
1384: hop.program_id = hz_utility_v2pub.program_id,
1385: hop.program_update_date = hz_utility_v2pub.program_update_date,
1386: hop.content_source_type =
1387: DECODE(x_content_source_type,
1388: NULL, hop.content_source_type,
1389: fnd_api.g_miss_char, NULL,