The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE do_update_org_cust_bo(
p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
p_org_cust_obj IN OUT NOCOPY HZ_ORG_CUST_BO,
p_created_by_module IN VARCHAR2,
p_obj_source IN VARCHAR2 := null,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
x_organization_id OUT NOCOPY NUMBER
);
SELECT HZ_BUS_OBJ_TRACKING_S.nextval
INTO l_org_event_id
FROM DUAL;
SELECT HZ_BUS_OBJ_TRACKING_S.nextval
INTO l_oc_event_id
FROM DUAL;
p_create_update_flag => 'C',
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_parent_id => x_organization_id,
p_parent_os => l_organization_os,
p_parent_osr => l_organization_osr,
p_parent_obj_type => 'ORG'
);
p_create_or_update => 'C',
p_obj_source => p_obj_source,
p_event_id => l_org_event_id
);
p_create_or_update => 'C',
p_obj_source => p_obj_source,
p_event_id => l_oc_event_id
);
PROCEDURE do_update_org_cust_bo(
p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
p_org_cust_obj IN OUT NOCOPY HZ_ORG_CUST_BO,
p_created_by_module IN VARCHAR2,
p_obj_source IN VARCHAR2 := null,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
x_organization_id OUT NOCOPY NUMBER
) IS
l_organization_os VARCHAR2(30);
SAVEPOINT do_update_org_cust_bo_pub;
hz_utility_v2pub.debug(p_message=>'do_update_org_cust_bo(+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
p_create_or_update => 'U',
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
l_org_raise_event := HZ_PARTY_BO_PVT.is_raising_update_event(
p_party_id => x_organization_id,
p_bo_code => 'ORG'
);
l_oc_raise_event := HZ_PARTY_BO_PVT.is_raising_update_event(
p_party_id => x_organization_id,
p_bo_code => 'ORG_CUST'
);
SELECT HZ_BUS_OBJ_TRACKING_S.nextval
INTO l_org_event_id
FROM DUAL;
SELECT HZ_BUS_OBJ_TRACKING_S.nextval
INTO l_oc_event_id
FROM DUAL;
HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := 'Y';
HZ_ORGANIZATION_BO_PUB.do_update_organization_bo(
p_init_msg_list => fnd_api.g_false,
p_organization_obj => p_org_cust_obj.organization_obj,
p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
p_obj_source => p_obj_source,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
x_organization_id => x_organization_id,
x_organization_os => l_organization_os,
x_organization_osr => l_organization_osr
);
p_create_update_flag => 'U',
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_parent_id => x_organization_id,
p_parent_os => l_organization_os,
p_parent_osr => l_organization_osr,
p_parent_obj_type => 'ORG'
);
p_create_or_update => 'U',
p_obj_source => p_obj_source,
p_event_id => l_org_event_id
);
p_create_or_update => 'U',
p_obj_source => p_obj_source,
p_event_id => l_oc_event_id
);
HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
hz_utility_v2pub.debug(p_message=>'do_update_org_cust_bo(+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
ROLLBACK TO do_update_org_cust_bo_pub;
HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
hz_utility_v2pub.debug(p_message=>'do_update_org_cust_bo(+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
ROLLBACK TO do_update_org_cust_bo_pub;
HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
hz_utility_v2pub.debug(p_message=>'do_update_org_cust_bo(+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
ROLLBACK TO do_update_org_cust_bo_pub;
HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
hz_utility_v2pub.debug(p_message=>'do_update_org_cust_bo(+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
END do_update_org_cust_bo;
PROCEDURE update_org_cust_bo(
p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
p_org_cust_obj IN HZ_ORG_CUST_BO,
p_created_by_module IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
x_organization_id OUT NOCOPY NUMBER
) IS
l_oc_obj HZ_ORG_CUST_BO;
do_update_org_cust_bo(
p_init_msg_list => p_init_msg_list,
p_org_cust_obj => l_oc_obj,
p_created_by_module => p_created_by_module,
p_obj_source => null,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
x_organization_id => x_organization_id
);
END update_org_cust_bo;
PROCEDURE update_org_cust_bo(
p_org_cust_obj IN HZ_ORG_CUST_BO,
p_created_by_module IN VARCHAR2,
p_obj_source IN VARCHAR2 := null,
p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
x_return_status OUT NOCOPY VARCHAR2,
x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
x_return_obj OUT NOCOPY HZ_ORG_CUST_BO,
x_organization_id OUT NOCOPY NUMBER
) IS
l_msg_count NUMBER;
do_update_org_cust_bo(
p_init_msg_list => fnd_api.g_true,
p_org_cust_obj => l_oc_obj,
p_created_by_module => p_created_by_module,
p_obj_source => p_obj_source,
x_return_status => x_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
x_organization_id => x_organization_id
);
END update_org_cust_bo;
l_create_update_flag VARCHAR2(1);
l_create_update_flag := HZ_REGISTRY_VALIDATE_BO_PVT.check_bo_op(
p_entity_id => l_organization_id,
p_entity_os => l_organization_os,
p_entity_osr => l_organization_osr,
p_entity_type => 'HZ_PARTIES',
p_parent_id => NULL,
p_parent_obj_type=> NULL );
IF(l_create_update_flag = 'E') THEN
FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
IF(l_create_update_flag = 'C') THEN
do_create_org_cust_bo(
p_init_msg_list => fnd_api.g_false,
p_validate_bo_flag => p_validate_bo_flag,
p_org_cust_obj => p_org_cust_obj,
p_created_by_module => p_created_by_module,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
x_organization_id => x_organization_id
);
ELSIF(l_create_update_flag = 'U') THEN
do_update_org_cust_bo(
p_init_msg_list => fnd_api.g_false,
p_org_cust_obj => p_org_cust_obj,
p_created_by_module => p_created_by_module,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
x_organization_id => x_organization_id
);
-- extraction validation logic is same as update
l_organization_id := p_organization_id;
The Get Organization Customers Updated procedure is a service to retrieve all of the Organization Customer business objects whose
updates have been captured by the logical business event. Each Organization Customers Updated business event signifies that one or
more Organization Customer business objects have been updated.
The caller provides an identifier for the Organization Customers Update business event and the procedure returns database objects
of the type HZ_ORG_CUST_BO for all of the Organization Customer business objects from the business event.
Gathering all of the returned database objects from those API calls, the procedure packages them in a table structure and returns
them to the caller.
*/
PROCEDURE get_org_custs_updated(
p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
p_event_id IN NUMBER,
x_org_cust_objs OUT NOCOPY HZ_ORG_CUST_BO_TBL,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) is
l_debug_prefix VARCHAR2(30) := '';
hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
HZ_EXTRACT_ORG_CUST_BO_PVT.get_org_custs_updated(
p_init_msg_list => fnd_api.g_false,
p_event_id => p_event_id,
x_org_cust_objs => x_org_cust_objs,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
PROCEDURE get_org_custs_updated(
p_event_id IN NUMBER,
x_org_cust_objs OUT NOCOPY HZ_ORG_CUST_BO_TBL,
x_return_status OUT NOCOPY VARCHAR2,
x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
) IS
l_msg_data VARCHAR2(2000);
get_org_custs_updated(
p_init_msg_list => fnd_api.g_true,
p_event_id => p_event_id,
x_org_cust_objs => x_org_cust_objs,
x_return_status => x_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
);
END get_org_custs_updated;
PROCEDURE get_org_cust_updated(
p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
p_event_id IN NUMBER,
p_org_cust_id IN NUMBER,
x_org_cust_obj OUT NOCOPY HZ_ORG_CUST_BO,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) is
l_debug_prefix VARCHAR2(30) := '';
hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
HZ_EXTRACT_ORG_CUST_BO_PVT.get_org_cust_updated(
p_init_msg_list => fnd_api.g_false,
p_event_id => p_event_id,
p_org_cust_id => p_org_cust_id,
x_org_cust_obj => x_org_cust_obj,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
PROCEDURE get_org_cust_updated(
p_event_id IN NUMBER,
p_org_cust_id IN NUMBER,
x_org_cust_obj OUT NOCOPY HZ_ORG_CUST_BO,
x_return_status OUT NOCOPY VARCHAR2,
x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
) IS
l_msg_data VARCHAR2(2000);
get_org_cust_updated(
p_init_msg_list => fnd_api.g_false,
p_event_id => p_event_id,
p_org_cust_id => p_org_cust_id,
x_org_cust_obj => x_org_cust_obj,
x_return_status => x_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
);
END get_org_cust_updated;
PROCEDURE get_ids_org_custs_updated (
p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
p_event_id IN NUMBER,
x_org_cust_ids OUT NOCOPY HZ_EXTRACT_BO_UTIL_PVT.BO_ID_TBL,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) is
l_debug_prefix VARCHAR2(30) := '';
hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_updated(+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_updated (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
SELECT HZ_BUS_OBJ_TRACKING_S.nextval
INTO l_org_event_id
FROM DUAL;
SELECT HZ_BUS_OBJ_TRACKING_S.nextval
INTO l_oc_event_id
FROM DUAL;
p_create_update_flag => 'C',
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_parent_id => x_organization_id,
p_parent_os => l_organization_os,
p_parent_osr => l_organization_osr,
p_parent_obj_type => 'ORG'
);
p_create_or_update => 'C',
p_obj_source => p_obj_source,
p_event_id => l_org_event_id
);
p_create_or_update => 'C',
p_obj_source => p_obj_source,
p_event_id => l_oc_event_id
);
PROCEDURE do_update_org_cust_v2_bo(
p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
p_org_cust_v2_obj IN OUT NOCOPY HZ_org_cust_v2_bo,
p_created_by_module IN VARCHAR2,
p_obj_source IN VARCHAR2 := null,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
x_organization_id OUT NOCOPY NUMBER
) IS
l_organization_os VARCHAR2(30);
SAVEPOINT do_update_org_cust_v2_bo_pub;
hz_utility_v2pub.debug(p_message=>'do_update_org_cust_v2_bo(+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
p_create_or_update => 'U',
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
l_org_raise_event := HZ_PARTY_BO_PVT.is_raising_update_event(
p_party_id => x_organization_id,
p_bo_code => 'ORG'
);
l_oc_raise_event := HZ_PARTY_BO_PVT.is_raising_update_event(
p_party_id => x_organization_id,
p_bo_code => 'ORG_CUST'
);
SELECT HZ_BUS_OBJ_TRACKING_S.nextval
INTO l_org_event_id
FROM DUAL;
SELECT HZ_BUS_OBJ_TRACKING_S.nextval
INTO l_oc_event_id
FROM DUAL;
HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := 'Y';
HZ_ORGANIZATION_BO_PUB.do_update_organization_bo(
p_init_msg_list => fnd_api.g_false,
p_organization_obj => p_org_cust_v2_obj.organization_obj,
p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
p_obj_source => p_obj_source,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
x_organization_id => x_organization_id,
x_organization_os => l_organization_os,
x_organization_osr => l_organization_osr
);
p_create_update_flag => 'U',
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_parent_id => x_organization_id,
p_parent_os => l_organization_os,
p_parent_osr => l_organization_osr,
p_parent_obj_type => 'ORG'
);
p_create_or_update => 'U',
p_obj_source => p_obj_source,
p_event_id => l_org_event_id
);
p_create_or_update => 'U',
p_obj_source => p_obj_source,
p_event_id => l_oc_event_id
);
HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
hz_utility_v2pub.debug(p_message=>'do_update_org_cust_v2_bo(+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
ROLLBACK TO do_update_org_cust_v2_bo_pub;
HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
hz_utility_v2pub.debug(p_message=>'do_update_org_cust_v2_bo(+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
ROLLBACK TO do_update_org_cust_v2_bo_pub;
HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
hz_utility_v2pub.debug(p_message=>'do_update_org_cust_v2_bo(+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
ROLLBACK TO do_update_org_cust_v2_bo_pub;
HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
hz_utility_v2pub.debug(p_message=>'do_update_org_cust_v2_bo(+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
END do_update_org_cust_v2_bo;
PROCEDURE update_org_cust_v2_bo(
p_org_cust_v2_obj IN HZ_org_cust_v2_bo,
p_created_by_module IN VARCHAR2,
p_obj_source IN VARCHAR2 := null,
p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
x_return_status OUT NOCOPY VARCHAR2,
x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
x_return_obj OUT NOCOPY HZ_org_cust_v2_bo,
x_organization_id OUT NOCOPY NUMBER
) IS
l_msg_count NUMBER;
do_update_org_cust_v2_bo(
p_init_msg_list => fnd_api.g_true,
p_org_cust_v2_obj => l_oc_obj,
p_created_by_module => p_created_by_module,
p_obj_source => p_obj_source,
x_return_status => x_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
x_organization_id => x_organization_id
);
END update_org_cust_v2_bo;
l_create_update_flag VARCHAR2(1);
l_create_update_flag := HZ_REGISTRY_VALIDATE_BO_PVT.check_bo_op(
p_entity_id => l_organization_id,
p_entity_os => l_organization_os,
p_entity_osr => l_organization_osr,
p_entity_type => 'HZ_PARTIES',
p_parent_id => NULL,
p_parent_obj_type=> NULL );
IF(l_create_update_flag = 'E') THEN
FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
IF(l_create_update_flag = 'C') THEN
do_create_org_cust_v2_bo(
p_init_msg_list => fnd_api.g_false,
p_validate_bo_flag => p_validate_bo_flag,
p_org_cust_v2_obj => p_org_cust_v2_obj,
p_created_by_module => p_created_by_module,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
x_organization_id => x_organization_id
);
ELSIF(l_create_update_flag = 'U') THEN
do_update_org_cust_v2_bo(
p_init_msg_list => fnd_api.g_false,
p_org_cust_v2_obj => p_org_cust_v2_obj,
p_created_by_module => p_created_by_module,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
x_organization_id => x_organization_id
);
-- extraction validation logic is same as update
l_organization_id := p_organization_id;
The Get Organization Customers Updated procedure is a service to retrieve all of the Organization Customer business objects whose
updates have been captured by the logical business event. Each Organization Customers Updated business event signifies that one or
more Organization Customer business objects have been updated.
The caller provides an identifier for the Organization Customers Update business event and the procedure returns database objects
of the type HZ_ORG_CUST_V2_BO for all of the Organization Customer business objects from the business event.
Gathering all of the returned database objects from those API calls, the procedure packages them in a table structure and returns
them to the caller.
*/
PROCEDURE get_v2_org_custs_updated(
p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
p_event_id IN NUMBER,
x_org_cust_v2_objs OUT NOCOPY HZ_ORG_CUST_V2_BO_TBL,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) is
l_debug_prefix VARCHAR2(30) := '';
hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated(+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
HZ_EXTRACT_ORG_CUST_BO_PVT.get_v2_org_custs_updated(
p_init_msg_list => fnd_api.g_false,
p_event_id => p_event_id,
x_org_cust_v2_objs => x_org_cust_v2_objs,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
PROCEDURE get_v2_org_custs_updated(
p_event_id IN NUMBER,
x_org_cust_v2_objs OUT NOCOPY HZ_ORG_CUST_V2_BO_TBL,
x_return_status OUT NOCOPY VARCHAR2,
x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
) IS
l_msg_data VARCHAR2(2000);
get_v2_org_custs_updated(
p_init_msg_list => fnd_api.g_true,
p_event_id => p_event_id,
x_org_cust_v2_objs => x_org_cust_v2_objs,
x_return_status => x_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
);
END get_v2_org_custs_updated;
PROCEDURE get_v2_org_cust_updated(
p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
p_event_id IN NUMBER,
p_org_cust_id IN NUMBER,
x_org_cust_v2_obj OUT NOCOPY HZ_ORG_CUST_V2_BO,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) is
l_debug_prefix VARCHAR2(30) := '';
hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
HZ_EXTRACT_ORG_CUST_BO_PVT.get_v2_org_cust_updated(
p_init_msg_list => fnd_api.g_false,
p_event_id => p_event_id,
p_org_cust_id => p_org_cust_id,
x_org_cust_v2_obj => x_org_cust_v2_obj,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
PROCEDURE get_v2_org_cust_updated(
p_event_id IN NUMBER,
p_org_cust_id IN NUMBER,
x_org_cust_v2_obj OUT NOCOPY HZ_ORG_CUST_V2_BO,
x_return_status OUT NOCOPY VARCHAR2,
x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
) IS
l_msg_data VARCHAR2(2000);
get_v2_org_cust_updated(
p_init_msg_list => fnd_api.g_false,
p_event_id => p_event_id,
p_org_cust_id => p_org_cust_id,
x_org_cust_v2_obj => x_org_cust_v2_obj,
x_return_status => x_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
);
END get_v2_org_cust_updated;