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 1646: l_created_by := hz_utility_v2pub.created_by;

1642: retcode := 0;
1643:
1644: -- retrieve who information
1645: --
1646: l_created_by := hz_utility_v2pub.created_by;
1647: l_last_update_login := hz_utility_v2pub.last_update_login;
1648: l_last_updated_by := hz_utility_v2pub.last_updated_by;
1649:
1650: -- find out if there is any work units need to be processed

Line 1647: l_last_update_login := hz_utility_v2pub.last_update_login;

1643:
1644: -- retrieve who information
1645: --
1646: l_created_by := hz_utility_v2pub.created_by;
1647: l_last_update_login := hz_utility_v2pub.last_update_login;
1648: l_last_updated_by := hz_utility_v2pub.last_updated_by;
1649:
1650: -- find out if there is any work units need to be processed
1651: --

Line 1648: l_last_updated_by := hz_utility_v2pub.last_updated_by;

1644: -- retrieve who information
1645: --
1646: l_created_by := hz_utility_v2pub.created_by;
1647: l_last_update_login := hz_utility_v2pub.last_update_login;
1648: l_last_updated_by := hz_utility_v2pub.last_updated_by;
1649:
1650: -- find out if there is any work units need to be processed
1651: --
1652: LOOP

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

1828:
1829: -- truncate staging table
1830: --
1831: Write_Log('Truncating staging table ...');
1832: l_owner := hz_utility_v2pub.Get_SchemaName('AR');
1833: Write_Log('l_owner = '||l_owner);
1834:
1835: l_sql := 'truncate table '||l_owner||'.';
1836: IF p_entity_name = C_ORG THEN

Line 1875: l_parent_request_id := hz_utility_v2pub.request_id;

1871: END IF;
1872:
1873: -- get parent request id
1874: --
1875: l_parent_request_id := hz_utility_v2pub.request_id;
1876: Write_Log('l_parent_request_id = '||l_parent_request_id);
1877:
1878: -- submit sub requests
1879: --