DBA Data[Home] [Help]

APPS.HZ_EXTENSIBILITY_PVT dependencies on HZ_UTILITY_V2PUB

Line 156: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN

152: ,x_msg_data => x_msg_data
153: );
154:
155: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
156: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
157: IF(l_extension_id IS NOT NULL) THEN
158: IF(l_mode = 'CREATE') THEN
159: l_operation := 'I';
160: ELSE

Line 426: hz_utility_v2pub.debug(

422:
423: BEGIN
424:
425: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
426: hz_utility_v2pub.debug(
427: p_prefix => l_debug_prefix,
428: p_message => 'copy_person_extent_data (+)',
429: p_msg_level => fnd_log.level_procedure);
430: END IF;

Line 432: l_created_by := hz_utility_v2pub.created_by;

428: p_message => 'copy_person_extent_data (+)',
429: p_msg_level => fnd_log.level_procedure);
430: END IF;
431:
432: l_created_by := hz_utility_v2pub.created_by;
433: l_last_update_login := hz_utility_v2pub.last_update_login;
434: l_last_updated_by := hz_utility_v2pub.last_updated_by;
435:
436: -- This code will copy the existing profile extension records over

Line 433: l_last_update_login := hz_utility_v2pub.last_update_login;

429: p_msg_level => fnd_log.level_procedure);
430: END IF;
431:
432: l_created_by := hz_utility_v2pub.created_by;
433: l_last_update_login := hz_utility_v2pub.last_update_login;
434: l_last_updated_by := hz_utility_v2pub.last_updated_by;
435:
436: -- This code will copy the existing profile extension records over
437: -- to the new profile _id everytime the SST record id is changed.

Line 434: l_last_updated_by := hz_utility_v2pub.last_updated_by;

430: END IF;
431:
432: l_created_by := hz_utility_v2pub.created_by;
433: l_last_update_login := hz_utility_v2pub.last_update_login;
434: l_last_updated_by := hz_utility_v2pub.last_updated_by;
435:
436: -- This code will copy the existing profile extension records over
437: -- to the new profile _id everytime the SST record id is changed.
438: -- When the record is copied the original extension_id is stored

Line 637: hz_utility_v2pub.debug(

633: END IF;
634:
635:
636: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
637: hz_utility_v2pub.debug(
638: p_prefix => l_debug_prefix,
639: p_message => 'copy_person_extent_data (-)',
640: p_msg_level => fnd_log.level_procedure);
641: END IF;

Line 688: hz_utility_v2pub.debug(

684:
685: BEGIN
686:
687: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
688: hz_utility_v2pub.debug(
689: p_prefix => l_debug_prefix,
690: p_message => 'copy_org_extent_data (+)',
691: p_msg_level => fnd_log.level_procedure);
692: END IF;

Line 694: l_created_by := hz_utility_v2pub.created_by;

690: p_message => 'copy_org_extent_data (+)',
691: p_msg_level => fnd_log.level_procedure);
692: END IF;
693:
694: l_created_by := hz_utility_v2pub.created_by;
695: l_last_update_login := hz_utility_v2pub.last_update_login;
696: l_last_updated_by := hz_utility_v2pub.last_updated_by;
697:
698: -- This code will copy the existing profile extension records over

Line 695: l_last_update_login := hz_utility_v2pub.last_update_login;

691: p_msg_level => fnd_log.level_procedure);
692: END IF;
693:
694: l_created_by := hz_utility_v2pub.created_by;
695: l_last_update_login := hz_utility_v2pub.last_update_login;
696: l_last_updated_by := hz_utility_v2pub.last_updated_by;
697:
698: -- This code will copy the existing profile extension records over
699: -- to the new profile _id everytime the SST record id is changed.

Line 696: l_last_updated_by := hz_utility_v2pub.last_updated_by;

692: END IF;
693:
694: l_created_by := hz_utility_v2pub.created_by;
695: l_last_update_login := hz_utility_v2pub.last_update_login;
696: l_last_updated_by := hz_utility_v2pub.last_updated_by;
697:
698: -- This code will copy the existing profile extension records over
699: -- to the new profile _id everytime the SST record id is changed.
700: -- When the record is copied the original extension_id is stored

Line 898: hz_utility_v2pub.debug(

894: AND tl.extension_id = b.old_extension_id;
895: END IF;
896:
897: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
898: hz_utility_v2pub.debug(
899: p_prefix => l_debug_prefix,
900: p_message => 'copy_org_extent_data (-)',
901: p_msg_level => fnd_log.level_procedure);
902: END IF;

Line 1638: l_created_by := hz_utility_v2pub.created_by;

1634: retcode := 0;
1635:
1636: -- retrieve who information
1637: --
1638: l_created_by := hz_utility_v2pub.created_by;
1639: l_last_update_login := hz_utility_v2pub.last_update_login;
1640: l_last_updated_by := hz_utility_v2pub.last_updated_by;
1641:
1642: -- find out if there is any work units need to be processed

Line 1639: l_last_update_login := hz_utility_v2pub.last_update_login;

1635:
1636: -- retrieve who information
1637: --
1638: l_created_by := hz_utility_v2pub.created_by;
1639: l_last_update_login := hz_utility_v2pub.last_update_login;
1640: l_last_updated_by := hz_utility_v2pub.last_updated_by;
1641:
1642: -- find out if there is any work units need to be processed
1643: --

Line 1640: l_last_updated_by := hz_utility_v2pub.last_updated_by;

1636: -- retrieve who information
1637: --
1638: l_created_by := hz_utility_v2pub.created_by;
1639: l_last_update_login := hz_utility_v2pub.last_update_login;
1640: l_last_updated_by := hz_utility_v2pub.last_updated_by;
1641:
1642: -- find out if there is any work units need to be processed
1643: --
1644: LOOP

Line 1824: l_owner := hz_utility_v2pub.Get_SchemaName('AR');

1820:
1821: -- truncate staging table
1822: --
1823: Write_Log('Truncating staging table ...');
1824: l_owner := hz_utility_v2pub.Get_SchemaName('AR');
1825: Write_Log('l_owner = '||l_owner);
1826:
1827: l_sql := 'truncate table '||l_owner||'.';
1828: IF p_entity_name = C_ORG THEN

Line 1867: l_parent_request_id := hz_utility_v2pub.request_id;

1863: END IF;
1864:
1865: -- get parent request id
1866: --
1867: l_parent_request_id := hz_utility_v2pub.request_id;
1868: Write_Log('l_parent_request_id = '||l_parent_request_id);
1869:
1870: -- submit sub requests
1871: --