The following lines contain the word 'select', 'insert', 'update' or 'delete':
select child_operation_flag
from hz_bus_obj_tracking
where event_id = p_event_id
and child_bo_code = 'PERSON'
and parent_bo_code = 'PERSON_CUST';
x_person_cust_objs(i).action_type := 'CHILD_UPDATED';
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_obj_root_ids HZ_EXTRACT_BO_UTIL_PVT.BO_ID_TBL;
hz_utility_v2pub.debug(p_message=>'get_person_custs_updated(+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
-- call event API get_person_cust_updated for each id.
x_person_cust_objs := HZ_PERSON_CUST_BO_TBL();
get_person_cust_updated(
p_init_msg_list => fnd_api.g_false,
p_event_id => p_event_id,
p_person_cust_id => l_obj_root_ids(i),
x_person_cust_obj => x_person_cust_objs(i),
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
hz_utility_v2pub.debug(p_message=>'get_person_custs_updated (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'get_person_custs_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'get_person_custs_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'get_person_custs_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
px_cust_acct_obj.action_type := 'CHILD_UPDATED';
px_cust_acct_obj.CUST_PROFILE_OBJ.action_type := 'CHILD_UPDATED';
then PX_CUST_ACCT_OBJ.CUST_ACCT_CONTACT_OBJS(i).action_type := 'CHILD_UPDATED';
then PX_CUST_ACCT_OBJ.CUST_ACCT_SITE_OBJS(i).CUST_ACCT_CONTACT_OBJS(j).action_type := 'CHILD_UPDATED';
then PX_CUST_ACCT_OBJ.CUST_ACCT_SITE_OBJS(i).action_type := 'CHILD_UPDATED';
then PX_CUST_ACCT_OBJ.action_type := 'CHILD_UPDATED';
SELECT
sys_connect_by_path(CHILD_BO_CODE, '/') node_path,
CHILD_OPERATION_FLAG,
CHILD_BO_CODE,
CHILD_ENTITY_NAME,
CHILD_ID,
populated_flag
FROM HZ_BUS_OBJ_TRACKING
where event_id = p_event_id
START WITH child_id = p_root_id
AND child_entity_name = 'HZ_PARTIES'
AND PARENT_BO_CODE IS NULL
AND event_id = p_event_id
AND CHILD_BO_CODE = 'PERSON_CUST' --(or ORG, PERSON_CUST, ORG_CUST).
CONNECT BY PARENT_ENTITY_NAME = PRIOR CHILD_ENTITY_NAME
AND PARENT_ID = PRIOR CHILD_ID
AND parent_bo_code = PRIOR child_bo_code
and event_id = PRIOR event_id;
select child_event_id,creation_date
FROM HZ_BUS_OBJ_TRACKING
where event_id = p_event_id
and parent_bo_code is null
and rownum = 1;
SELECT event_id
FROM HZ_BUS_OBJ_TRACKING
WHERE creation_date = cp_creation_date
AND child_id = p_root_id
AND child_event_id IS NULL
and event_id <> p_event_id
and rownum = 1;
then l_action_type := 'UPDATED';
then PX_PERSON_CUST_OBJ.action_type := 'CHILD_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_obj_root_ids HZ_EXTRACT_BO_UTIL_PVT.BO_ID_TBL;
hz_utility_v2pub.debug(p_message=>'get_person_cust_updated(+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
-- Based on BOT, for updated branch, set action_type = 'UPDATED'/'CREATED'
l_person_cust_obj := x_person_cust_obj;
hz_utility_v2pub.debug(p_message=>'get_person_cust_updated (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'get_person_cust_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'get_person_cust_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'get_person_cust_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
x_person_cust_v2_objs(i).action_type := 'CHILD_UPDATED';
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_obj_root_ids HZ_EXTRACT_BO_UTIL_PVT.BO_ID_TBL;
hz_utility_v2pub.debug(p_message=>'get_v2_person_custs_updated(+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
-- call event API get_person_cust_updated for each id.
x_person_cust_v2_objs := HZ_PERSON_CUST_V2_BO_TBL();
get_v2_person_cust_updated(
p_init_msg_list => fnd_api.g_false,
p_event_id => p_event_id,
p_person_cust_id => l_obj_root_ids(i),
x_person_cust_v2_obj => x_person_cust_v2_objs(i),
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
hz_utility_v2pub.debug(p_message=>'get_v2_person_custs_updated (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'get_v2_person_custs_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'get_v2_person_custs_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'get_v2_person_custs_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
px_cust_acct_v2_obj.action_type := 'CHILD_UPDATED';
px_cust_acct_v2_obj.CUST_PROFILE_OBJ.action_type := 'CHILD_UPDATED';
then px_cust_acct_v2_obj.CUST_ACCT_CONTACT_OBJS(i).action_type := 'CHILD_UPDATED';
then px_cust_acct_v2_obj.CUST_ACCT_SITE_OBJS(i).CUST_ACCT_CONTACT_OBJS(j).action_type := 'CHILD_UPDATED';
then px_cust_acct_v2_obj.CUST_ACCT_SITE_OBJS(i).action_type := 'CHILD_UPDATED';
then px_cust_acct_v2_obj.action_type := 'CHILD_UPDATED';
SELECT
sys_connect_by_path(CHILD_BO_CODE, '/') node_path,
CHILD_OPERATION_FLAG,
CHILD_BO_CODE,
CHILD_ENTITY_NAME,
CHILD_ID,
populated_flag
FROM HZ_BUS_OBJ_TRACKING
where event_id = p_event_id
START WITH child_id = p_root_id
AND child_entity_name = 'HZ_PARTIES'
AND PARENT_BO_CODE IS NULL
AND event_id = p_event_id
AND CHILD_BO_CODE = 'PERSON_CUST' --(or ORG, PERSON_CUST, ORG_CUST).
CONNECT BY PARENT_ENTITY_NAME = PRIOR CHILD_ENTITY_NAME
AND PARENT_ID = PRIOR CHILD_ID
AND parent_bo_code = PRIOR child_bo_code
and event_id = PRIOR event_id;
select child_event_id,creation_date
FROM HZ_BUS_OBJ_TRACKING
where event_id = p_event_id
and parent_bo_code is null
and rownum = 1;
SELECT event_id
FROM HZ_BUS_OBJ_TRACKING
WHERE creation_date = cp_creation_date
AND child_id = p_root_id
AND child_event_id IS NULL
and event_id <> p_event_id
and rownum = 1;
then l_action_type := 'UPDATED';
then PX_PERSON_CUST_V2_OBJ.action_type := 'CHILD_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_obj_root_ids HZ_EXTRACT_BO_UTIL_PVT.BO_ID_TBL;
hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_updated(+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
-- Based on BOT, for updated branch, set action_type = 'UPDATED'/'CREATED'
l_person_cust_obj := x_person_cust_v2_obj;
hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_updated (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);