The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE do_update_person_cust_bo(
p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
p_person_cust_obj IN OUT NOCOPY HZ_PERSON_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_person_id OUT NOCOPY NUMBER
);
SELECT HZ_BUS_OBJ_TRACKING_S.nextval
INTO l_per_event_id
FROM DUAL;
SELECT HZ_BUS_OBJ_TRACKING_S.nextval
INTO l_pc_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_person_id,
p_parent_os => l_person_os,
p_parent_osr => l_person_osr,
p_parent_obj_type => 'PERSON'
);
p_create_or_update => 'C',
p_obj_source => p_obj_source,
p_event_id => l_per_event_id
);
p_create_or_update => 'C',
p_obj_source => p_obj_source,
p_event_id => l_pc_event_id
);
PROCEDURE do_update_person_cust_bo(
p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
p_person_cust_obj IN OUT NOCOPY HZ_PERSON_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_person_id OUT NOCOPY NUMBER
) IS
l_person_os VARCHAR2(30);
SAVEPOINT do_update_person_cust_pub;
hz_utility_v2pub.debug(p_message=>'do_update_person_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_per_raise_event := HZ_PARTY_BO_PVT.is_raising_update_event(
p_party_id => x_person_id,
p_bo_code => 'PERSON'
);
l_pc_raise_event := HZ_PARTY_BO_PVT.is_raising_update_event(
p_party_id => x_person_id,
p_bo_code => 'PERSON_CUST'
);
SELECT HZ_BUS_OBJ_TRACKING_S.nextval
INTO l_per_event_id
FROM DUAL;
SELECT HZ_BUS_OBJ_TRACKING_S.nextval
INTO l_pc_event_id
FROM DUAL;
HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := 'Y';
HZ_PERSON_BO_PUB.do_update_person_bo(
p_init_msg_list => fnd_api.g_false,
p_person_obj => p_person_cust_obj.person_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_person_id => x_person_id,
x_person_os => l_person_os,
x_person_osr => l_person_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_person_id,
p_parent_os => l_person_os,
p_parent_osr => l_person_osr,
p_parent_obj_type => 'PERSON'
);
p_create_or_update => 'U',
p_obj_source => p_obj_source,
p_event_id => l_per_event_id
);
p_create_or_update => 'U',
p_obj_source => p_obj_source,
p_event_id => l_pc_event_id
);
HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
hz_utility_v2pub.debug(p_message=>'do_update_person_cust_bo(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
ROLLBACK TO do_update_person_cust_pub;
HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
hz_utility_v2pub.debug(p_message=>'do_update_person_cust_bo(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
ROLLBACK TO do_update_person_cust_pub;
HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
hz_utility_v2pub.debug(p_message=>'do_update_person_cust_bo(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
ROLLBACK TO do_update_person_cust_pub;
HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
hz_utility_v2pub.debug(p_message=>'do_update_person_cust_bo(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
END do_update_person_cust_bo;
PROCEDURE update_person_cust_bo(
p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
p_person_cust_obj IN HZ_PERSON_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_person_id OUT NOCOPY NUMBER
) IS
l_pc_obj HZ_PERSON_CUST_BO;
do_update_person_cust_bo(
p_init_msg_list => p_init_msg_list,
p_person_cust_obj => l_pc_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_person_id => x_person_id
);
END update_person_cust_bo;
PROCEDURE update_person_cust_bo(
p_person_cust_obj IN HZ_PERSON_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_PERSON_CUST_BO,
x_person_id OUT NOCOPY NUMBER
) IS
l_msg_data VARCHAR2(2000);
do_update_person_cust_bo(
p_init_msg_list => fnd_api.g_true,
p_person_cust_obj => l_pc_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_person_id => x_person_id
);
END update_person_cust_bo;
l_create_update_flag VARCHAR2(1);
l_create_update_flag := HZ_REGISTRY_VALIDATE_BO_PVT.check_bo_op(
p_entity_id => l_person_id,
p_entity_os => l_person_os,
p_entity_osr => l_person_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_person_cust_bo(
p_init_msg_list => fnd_api.g_false,
p_validate_bo_flag => p_validate_bo_flag,
p_person_cust_obj => p_person_cust_obj,
p_created_by_module => p_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_person_id => x_person_id
);
ELSIF(l_create_update_flag = 'U') THEN
do_update_person_cust_bo(
p_init_msg_list => fnd_api.g_false,
p_person_cust_obj => p_person_cust_obj,
p_created_by_module => p_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_person_id => x_person_id
);
-- extraction validation logic is same as update
l_person_id := p_person_id;
The Get Person Customers Updated procedure is a service to retrieve all of the Person Customer business objects whose updates
have been captured by the logical business event. Each Person Customers Updated business event signifies that one or more Person
Customer business objects have been updated.
The caller provides an identifier for the Person Customers Update business event and the procedure returns database objects of
the type HZ_PERSON_CUST_BO for all of the Person 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_person_custs_updated(
p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
p_event_id IN NUMBER,
x_person_cust_objs OUT NOCOPY HZ_PERSON_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_person_cust_bo_pub.get_person_custs_updated(+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
HZ_EXTRACT_PERSON_CUST_BO_PVT.get_person_custs_updated(
p_init_msg_list => fnd_api.g_false,
p_event_id => p_event_id,
x_person_cust_objs => x_person_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_person_cust_bo_pub.get_person_custs_updated (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
PROCEDURE get_person_custs_updated(
p_event_id IN NUMBER,
x_person_cust_objs OUT NOCOPY HZ_PERSON_CUST_BO_TBL,
x_return_status OUT NOCOPY VARCHAR2,
x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
)IS
l_msg_data VARCHAR2(2000);
get_person_custs_updated(
p_init_msg_list => fnd_api.g_true,
p_event_id => p_event_id,
x_person_cust_objs => x_person_cust_objs,
x_return_status => x_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
);
END get_person_custs_updated;
PROCEDURE get_person_cust_updated(
p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
p_event_id IN NUMBER,
p_person_cust_id IN NUMBER,
x_person_cust_obj OUT NOCOPY HZ_PERSON_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_person_cust_bo_pub.get_person_cust_updated(+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
HZ_EXTRACT_PERSON_CUST_BO_PVT.get_person_cust_updated(
p_init_msg_list => fnd_api.g_false,
p_event_id => p_event_id,
p_person_cust_id => p_person_cust_id,
x_person_cust_obj => x_person_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_person_cust_bo_pub.get_person_cust_updated (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
PROCEDURE get_person_cust_updated(
p_event_id IN NUMBER,
p_person_cust_id IN NUMBER,
x_person_cust_obj OUT NOCOPY HZ_PERSON_CUST_BO,
x_return_status OUT NOCOPY VARCHAR2,
x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
) IS
l_msg_data VARCHAR2(2000);
get_person_cust_updated(
p_init_msg_list => fnd_api.g_true,
p_event_id => p_event_id,
p_person_cust_id => p_person_cust_id,
x_person_cust_obj => x_person_cust_obj,
x_return_status => x_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
);
END get_person_cust_updated;
PROCEDURE get_ids_person_custs_updated (
p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
p_event_id IN NUMBER,
x_person_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_person_custs_updated(+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'get_ids_person_custs_updated (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'get_ids_person_custs_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'get_ids_person_custs_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'get_ids_person_custs_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
SELECT HZ_BUS_OBJ_TRACKING_S.nextval
INTO l_per_event_id
FROM DUAL;
SELECT HZ_BUS_OBJ_TRACKING_S.nextval
INTO l_pc_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_person_id,
p_parent_os => l_person_os,
p_parent_osr => l_person_osr,
p_parent_obj_type => 'PERSON'
);
p_create_or_update => 'C',
p_obj_source => p_obj_source,
p_event_id => l_per_event_id
);
p_create_or_update => 'C',
p_obj_source => p_obj_source,
p_event_id => l_pc_event_id
);
PROCEDURE do_update_person_cust_v2_bo(
p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
p_person_cust_v2_obj IN OUT NOCOPY HZ_PERSON_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_person_id OUT NOCOPY NUMBER
) IS
l_person_os VARCHAR2(30);
SAVEPOINT do_update_person_cust_v2_pub;
hz_utility_v2pub.debug(p_message=>'do_update_person_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_per_raise_event := HZ_PARTY_BO_PVT.is_raising_update_event(
p_party_id => x_person_id,
p_bo_code => 'PERSON'
);
l_pc_raise_event := HZ_PARTY_BO_PVT.is_raising_update_event(
p_party_id => x_person_id,
p_bo_code => 'PERSON_CUST'
);
SELECT HZ_BUS_OBJ_TRACKING_S.nextval
INTO l_per_event_id
FROM DUAL;
SELECT HZ_BUS_OBJ_TRACKING_S.nextval
INTO l_pc_event_id
FROM DUAL;
HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := 'Y';
HZ_PERSON_BO_PUB.do_update_person_bo(
p_init_msg_list => fnd_api.g_false,
p_person_obj => p_person_cust_v2_obj.person_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_person_id => x_person_id,
x_person_os => l_person_os,
x_person_osr => l_person_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_person_id,
p_parent_os => l_person_os,
p_parent_osr => l_person_osr,
p_parent_obj_type => 'PERSON'
);
p_create_or_update => 'U',
p_obj_source => p_obj_source,
p_event_id => l_per_event_id
);
p_create_or_update => 'U',
p_obj_source => p_obj_source,
p_event_id => l_pc_event_id
);
HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
hz_utility_v2pub.debug(p_message=>'do_update_person_cust_v2_bo(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
ROLLBACK TO do_update_person_cust_v2_pub;
HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
hz_utility_v2pub.debug(p_message=>'do_update_person_cust_v2_bo(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
ROLLBACK TO do_update_person_cust_v2_pub;
HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
hz_utility_v2pub.debug(p_message=>'do_update_person_cust_v2_bo(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
ROLLBACK TO do_update_person_cust_v2_pub;
HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
hz_utility_v2pub.debug(p_message=>'do_update_person_cust_v2_bo(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
END do_update_person_cust_v2_bo;
PROCEDURE update_person_cust_v2_bo(
p_person_cust_v2_obj IN HZ_PERSON_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_PERSON_CUST_V2_BO,
x_person_id OUT NOCOPY NUMBER
) IS
l_msg_data VARCHAR2(2000);
do_update_person_cust_v2_bo(
p_init_msg_list => fnd_api.g_true,
p_person_cust_v2_obj => l_pc_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_person_id => x_person_id
);
END update_person_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_person_id,
p_entity_os => l_person_os,
p_entity_osr => l_person_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_person_cust_v2_bo(
p_init_msg_list => fnd_api.g_false,
p_validate_bo_flag => p_validate_bo_flag,
p_person_cust_v2_obj => p_person_cust_v2_obj,
p_created_by_module => p_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_person_id => x_person_id
);
ELSIF(l_create_update_flag = 'U') THEN
do_update_person_cust_v2_bo(
p_init_msg_list => fnd_api.g_false,
p_person_cust_v2_obj => p_person_cust_v2_obj,
p_created_by_module => p_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_person_id => x_person_id
);
-- extraction validation logic is same as update
l_person_id := p_person_id;
The Get Person Customers Updated procedure is a service to retrieve all of the Person Customer business objects whose updates
have been captured by the logical business event. Each Person Customers Updated business event signifies that one or more Person
Customer business objects have been updated.
The caller provides an identifier for the Person Customers Update business event and the procedure returns database objects of
the type HZ_PERSON_CUST_V2_BO for all of the Person 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_person_custs_updated(
p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
p_event_id IN NUMBER,
x_person_cust_v2_objs OUT NOCOPY HZ_PERSON_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_person_cust_bo_pub.get_v2_person_custs_updated(+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
HZ_EXTRACT_PERSON_CUST_BO_PVT.get_v2_person_custs_updated(
p_init_msg_list => fnd_api.g_false,
p_event_id => p_event_id,
x_person_cust_v2_objs => x_person_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_person_cust_bo_pub.get_v2_person_custs_updated (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
PROCEDURE get_v2_person_custs_updated(
p_event_id IN NUMBER,
x_person_cust_v2_objs OUT NOCOPY HZ_PERSON_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_person_custs_updated(
p_init_msg_list => fnd_api.g_true,
p_event_id => p_event_id,
x_person_cust_v2_objs => x_person_cust_v2_objs,
x_return_status => x_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
);
END get_v2_person_custs_updated;
PROCEDURE get_v2_person_cust_updated(
p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
p_event_id IN NUMBER,
p_person_cust_id IN NUMBER,
x_person_cust_v2_obj OUT NOCOPY HZ_PERSON_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_person_cust_bo_pub.get_v2_person_cust_updated(+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
HZ_EXTRACT_PERSON_CUST_BO_PVT.get_v2_person_cust_updated(
p_init_msg_list => fnd_api.g_false,
p_event_id => p_event_id,
p_person_cust_id => p_person_cust_id,
x_person_cust_v2_obj => x_person_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_person_cust_bo_pub.get_v2_person_cust_updated (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_cust_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_cust_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_cust_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
PROCEDURE get_v2_person_cust_updated(
p_event_id IN NUMBER,
p_person_cust_id IN NUMBER,
x_person_cust_v2_obj OUT NOCOPY HZ_PERSON_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_person_cust_updated(
p_init_msg_list => fnd_api.g_true,
p_event_id => p_event_id,
p_person_cust_id => p_person_cust_id,
x_person_cust_v2_obj => x_person_cust_v2_obj,
x_return_status => x_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
);
END get_v2_person_cust_updated;