eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_EXTRACT_PERSON_CUST_BO_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 210


		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';

Line: 374


			x_person_cust_objs(i).action_type := 'CHILD_UPDATED';

Line: 497


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;

Line: 531


        	hz_utility_v2pub.debug(p_message=>'get_person_custs_updated(+)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);

Line: 549


  	-- call event API get_person_cust_updated for each id.

	x_person_cust_objs := HZ_PERSON_CUST_BO_TBL();

Line: 556


		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);

Line: 583


        	hz_utility_v2pub.debug(p_message=>'get_person_custs_updated (-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);

Line: 606


        hz_utility_v2pub.debug(p_message=>'get_person_custs_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);

Line: 625


        hz_utility_v2pub.debug(p_message=>'get_person_custs_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);

Line: 648


        hz_utility_v2pub.debug(p_message=>'get_person_custs_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);

Line: 701


		px_cust_acct_obj.action_type := 'CHILD_UPDATED';

Line: 730


			px_cust_acct_obj.CUST_PROFILE_OBJ.action_type := 'CHILD_UPDATED';

Line: 763


			then PX_CUST_ACCT_OBJ.CUST_ACCT_CONTACT_OBJS(i).action_type := 'CHILD_UPDATED';

Line: 846


			then PX_CUST_ACCT_OBJ.CUST_ACCT_SITE_OBJS(i).CUST_ACCT_CONTACT_OBJS(j).action_type := 'CHILD_UPDATED';

Line: 851


		then PX_CUST_ACCT_OBJ.CUST_ACCT_SITE_OBJS(i).action_type := 'CHILD_UPDATED';

Line: 854


		then PX_CUST_ACCT_OBJ.action_type := 'CHILD_UPDATED';

Line: 867


	   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;

Line: 887


    	   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;

Line: 895


		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;

Line: 952


		then l_action_type := 'UPDATED';

Line: 974


	then PX_PERSON_CUST_OBJ.action_type := 'CHILD_UPDATED';

Line: 1025


 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;

Line: 1051


        	hz_utility_v2pub.debug(p_message=>'get_person_cust_updated(+)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);

Line: 1080


	-- Based on BOT, for updated branch, set action_type = 'UPDATED'/'CREATED'

	l_person_cust_obj := x_person_cust_obj;

Line: 1106


        	hz_utility_v2pub.debug(p_message=>'get_person_cust_updated (-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);

Line: 1129


        hz_utility_v2pub.debug(p_message=>'get_person_cust_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);

Line: 1148


        hz_utility_v2pub.debug(p_message=>'get_person_cust_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);

Line: 1171


        hz_utility_v2pub.debug(p_message=>'get_person_cust_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);

Line: 1520


			x_person_cust_v2_objs(i).action_type := 'CHILD_UPDATED';

Line: 1644


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;

Line: 1678


        	hz_utility_v2pub.debug(p_message=>'get_v2_person_custs_updated(+)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);

Line: 1696


  	-- call event API get_person_cust_updated for each id.

	x_person_cust_v2_objs := HZ_PERSON_CUST_V2_BO_TBL();

Line: 1703


		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);

Line: 1730


        	hz_utility_v2pub.debug(p_message=>'get_v2_person_custs_updated (-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);

Line: 1753


        hz_utility_v2pub.debug(p_message=>'get_v2_person_custs_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);

Line: 1772


        hz_utility_v2pub.debug(p_message=>'get_v2_person_custs_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);

Line: 1795


        hz_utility_v2pub.debug(p_message=>'get_v2_person_custs_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);

Line: 1850


		px_cust_acct_v2_obj.action_type := 'CHILD_UPDATED';

Line: 1879


			px_cust_acct_v2_obj.CUST_PROFILE_OBJ.action_type := 'CHILD_UPDATED';

Line: 1912


			then px_cust_acct_v2_obj.CUST_ACCT_CONTACT_OBJS(i).action_type := 'CHILD_UPDATED';

Line: 1997


			then px_cust_acct_v2_obj.CUST_ACCT_SITE_OBJS(i).CUST_ACCT_CONTACT_OBJS(j).action_type := 'CHILD_UPDATED';

Line: 2002


		then px_cust_acct_v2_obj.CUST_ACCT_SITE_OBJS(i).action_type := 'CHILD_UPDATED';

Line: 2005


		then px_cust_acct_v2_obj.action_type := 'CHILD_UPDATED';

Line: 2019


	   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;

Line: 2039


    	   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;

Line: 2047


		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;

Line: 2104


		then l_action_type := 'UPDATED';

Line: 2126


	then PX_PERSON_CUST_V2_OBJ.action_type := 'CHILD_UPDATED';

Line: 2177


 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;

Line: 2203


        	hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_updated(+)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);

Line: 2232


	-- Based on BOT, for updated branch, set action_type = 'UPDATED'/'CREATED'

	l_person_cust_obj := x_person_cust_v2_obj;

Line: 2258


        	hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_updated (-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);

Line: 2281


        hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);

Line: 2300


        hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);

Line: 2323


        hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);