DBA Data[Home] [Help]

APPS.HZ_EXTRACT_ORGANIZATION_BO_PVT SQL Statements

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

Line: 56

	SELECT  HZ_FINANCIAL_BO(
		P_ACTION_TYPE,
                NULL, -- COMMON_OBJ_ID
		FINANCIAL_REPORT_ID,
		PARTY_ID,
		TYPE_OF_FINANCIAL_REPORT,
		DOCUMENT_REFERENCE,
		DATE_REPORT_ISSUED,
		ISSUED_PERIOD,
		REPORT_START_DATE,
		REPORT_END_DATE,
		ACTUAL_CONTENT_SOURCE,
		REQUIRING_AUTHORITY,
		AUDIT_IND,
		CONSOLIDATED_IND,
		ESTIMATED_IND,
		FISCAL_IND,
		FINAL_IND,
		FORECAST_IND,
		OPENING_IND,
		PROFORMA_IND,
		QUALIFIED_IND,
		RESTATED_IND,
		SIGNED_BY_PRINCIPALS_IND,
		TRIAL_BALANCE_IND,
		UNBALANCED_IND,
		STATUS,
		PROGRAM_UPDATE_DATE,
		CREATED_BY_MODULE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
		CREATION_DATE,
		LAST_UPDATE_DATE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
	CAST(MULTISET (
		SELECT HZ_FINANCIAL_NUMBER_OBJ(
		P_ACTION_TYPE,
                NULL, -- COMMON_OBJ_ID
		FINANCIAL_NUMBER_ID,
		FINANCIAL_REPORT_ID,
		FINANCIAL_NUMBER,
		FINANCIAL_NUMBER_NAME,
		FINANCIAL_UNITS_APPLIED,
		FINANCIAL_NUMBER_CURRENCY,
		PROJECTED_ACTUAL_FLAG,
		STATUS,
		PROGRAM_UPDATE_DATE,
		CREATED_BY_MODULE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
		CREATION_DATE,
		LAST_UPDATE_DATE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
		ACTUAL_CONTENT_SOURCE)
	FROM HZ_FINANCIAL_NUMBERS
	WHERE FINANCIAL_REPORT_ID = FR.FINANCIAL_REPORT_ID) AS  HZ_FINANCIAL_NUMBER_OBJ_TBL))
     FROM  HZ_FINANCIAL_REPORTS FR
     WHERE PARTY_ID = P_ORGANIZATION_ID;
Line: 273

	SELECT HZ_ORGANIZATION_BO(
		P_ACTION_TYPE,
                NULL, -- COMMON_OBJ_ID
		P.PARTY_ID,
		NULL, --ORIG_SYSTEM,
		NULL, --ORIG_SYSTEM_REFERENCE,
		P.PARTY_NUMBER,
		P.VALIDATED_FLAG,
		P.STATUS,
		P.CATEGORY_CODE,
		P.SALUTATION,
		P.ATTRIBUTE_CATEGORY,
		P.ATTRIBUTE1,
		P.ATTRIBUTE2,
		P.ATTRIBUTE3,
		P.ATTRIBUTE4,
		P.ATTRIBUTE5,
		P.ATTRIBUTE6,
		P.ATTRIBUTE7,
		P.ATTRIBUTE8,
		P.ATTRIBUTE9,
		P.ATTRIBUTE10,
		P.ATTRIBUTE11,
		P.ATTRIBUTE12,
		P.ATTRIBUTE13,
		P.ATTRIBUTE14,
		P.ATTRIBUTE15,
		P.ATTRIBUTE16,
		P.ATTRIBUTE17,
		P.ATTRIBUTE18,
		P.ATTRIBUTE19,
		P.ATTRIBUTE20,
		P.ATTRIBUTE21,
		P.ATTRIBUTE22,
		P.ATTRIBUTE23,
		P.ATTRIBUTE24,
		PRO.ORGANIZATION_NAME,
		PRO.DUNS_NUMBER_C,
		PRO.ENQUIRY_DUNS,
		PRO.CEO_NAME,
		PRO.CEO_TITLE,
		PRO.PRINCIPAL_NAME,
		PRO.PRINCIPAL_TITLE,
		PRO.LEGAL_STATUS,
		PRO.CONTROL_YR,
		PRO.EMPLOYEES_TOTAL,
		PRO.HQ_BRANCH_IND,
		PRO.BRANCH_FLAG,
		PRO.OOB_IND,
		PRO.LINE_OF_BUSINESS,
		PRO.CONG_DIST_CODE,
		PRO.SIC_CODE,
		PRO.IMPORT_IND,
		PRO.EXPORT_IND,
		PRO.LABOR_SURPLUS_IND,
		PRO.DEBARMENT_IND,
		PRO.MINORITY_OWNED_IND,
		PRO.MINORITY_OWNED_TYPE,
		PRO.WOMAN_OWNED_IND,
		PRO.DISADV_8A_IND,
		PRO.SMALL_BUS_IND,
		PRO.RENT_OWN_IND,
		PRO.DEBARMENTS_COUNT,
		PRO.DEBARMENTS_DATE,
		PRO.FAILURE_SCORE,
		PRO.FAILURE_SCORE_NATNL_PERCENTILE,
		PRO.FAILURE_SCORE_OVERRIDE_CODE,
		PRO.FAILURE_SCORE_COMMENTARY,
		PRO.GLOBAL_FAILURE_SCORE,
		PRO.DB_RATING,
		PRO.CREDIT_SCORE,
		PRO.CREDIT_SCORE_COMMENTARY,
		PRO.PAYDEX_SCORE,
		PRO.PAYDEX_THREE_MONTHS_AGO,
		PRO.PAYDEX_NORM,
		PRO.BEST_TIME_CONTACT_BEGIN,
		PRO.BEST_TIME_CONTACT_END,
		PRO.ORGANIZATION_NAME_PHONETIC,
		PRO.TAX_REFERENCE,
		PRO.GSA_INDICATOR_FLAG,
		PRO.JGZZ_FISCAL_CODE,
		PRO.ANALYSIS_FY,
		PRO.FISCAL_YEAREND_MONTH,
		PRO.CURR_FY_POTENTIAL_REVENUE,
		PRO.NEXT_FY_POTENTIAL_REVENUE,
		PRO.YEAR_ESTABLISHED,
		PRO.MISSION_STATEMENT,
		PRO.ORGANIZATION_TYPE,
		PRO.BUSINESS_SCOPE,
		PRO.CORPORATION_CLASS,
		PRO.KNOWN_AS,
		PRO.KNOWN_AS2,
		PRO.KNOWN_AS3,
		PRO.KNOWN_AS4,
		PRO.KNOWN_AS5,
		PRO.LOCAL_BUS_IDEN_TYPE,
		PRO.LOCAL_BUS_IDENTIFIER,
		PRO.PREF_FUNCTIONAL_CURRENCY,
		PRO.REGISTRATION_TYPE,
		PRO.TOTAL_EMPLOYEES_TEXT,
		PRO.TOTAL_EMPLOYEES_IND,
		PRO.TOTAL_EMP_EST_IND,
		PRO.TOTAL_EMP_MIN_IND,
		PRO.PARENT_SUB_IND,
		PRO.INCORP_YEAR,
		PRO.SIC_CODE_TYPE,
		PRO.PUBLIC_PRIVATE_OWNERSHIP_FLAG,
		PRO.INTERNAL_FLAG,
		PRO.LOCAL_ACTIVITY_CODE_TYPE,
		PRO.LOCAL_ACTIVITY_CODE,
		PRO.EMP_AT_PRIMARY_ADR,
		PRO.EMP_AT_PRIMARY_ADR_TEXT,
		PRO.EMP_AT_PRIMARY_ADR_EST_IND,
		PRO.EMP_AT_PRIMARY_ADR_MIN_IND,
		PRO.HIGH_CREDIT,
		PRO.AVG_HIGH_CREDIT,
		PRO.TOTAL_PAYMENTS,
		PRO.CREDIT_SCORE_CLASS,
		PRO.CREDIT_SCORE_NATL_PERCENTILE,
		PRO.CREDIT_SCORE_INCD_DEFAULT,
		PRO.CREDIT_SCORE_AGE,
		PRO.CREDIT_SCORE_DATE,
		PRO.CREDIT_SCORE_COMMENTARY2,
		PRO.CREDIT_SCORE_COMMENTARY3,
		PRO.CREDIT_SCORE_COMMENTARY4,
		PRO.CREDIT_SCORE_COMMENTARY5,
		PRO.CREDIT_SCORE_COMMENTARY6,
		PRO.CREDIT_SCORE_COMMENTARY7,
		PRO.CREDIT_SCORE_COMMENTARY8,
		PRO.CREDIT_SCORE_COMMENTARY9,
		PRO.CREDIT_SCORE_COMMENTARY10,
		PRO.FAILURE_SCORE_CLASS,
		PRO.FAILURE_SCORE_INCD_DEFAULT,
		PRO.FAILURE_SCORE_AGE,
		PRO.FAILURE_SCORE_DATE,
		PRO.FAILURE_SCORE_COMMENTARY2,
		PRO.FAILURE_SCORE_COMMENTARY3,
		PRO.FAILURE_SCORE_COMMENTARY4,
		PRO.FAILURE_SCORE_COMMENTARY5,
		PRO.FAILURE_SCORE_COMMENTARY6,
		PRO.FAILURE_SCORE_COMMENTARY7,
		PRO.FAILURE_SCORE_COMMENTARY8,
		PRO.FAILURE_SCORE_COMMENTARY9,
		PRO.FAILURE_SCORE_COMMENTARY10,
		PRO.MAXIMUM_CREDIT_RECOMMENDATION,
		PRO.MAXIMUM_CREDIT_CURRENCY_CODE,
		PRO.DISPLAYED_DUNS_PARTY_ID,
		PRO.PROGRAM_UPDATE_DATE,
		PRO.CREATED_BY_MODULE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(PRO.CREATED_BY),
		PRO.CREATION_DATE,
		PRO.LAST_UPDATE_DATE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(PRO.LAST_UPDATED_BY),
		PRO.DO_NOT_CONFUSE_WITH,
		PRO.ACTUAL_CONTENT_SOURCE,
		HZ_ORIG_SYS_REF_OBJ_TBL(),
		HZ_EXT_ATTRIBUTE_OBJ_TBL(),
		HZ_ORG_CONTACT_BO_TBL(),
		HZ_PARTY_SITE_BO_TBL(),
	CAST(MULTISET (
		SELECT HZ_PARTY_PREF_OBJ(
		P_ACTION_TYPE,
                NULL, -- COMMON_OBJ_ID
		PARTY_PREFERENCE_ID,
		HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',PARTY_ID),
		PARTY_ID,
		CATEGORY,
		PREFERENCE_CODE,
		VALUE_VARCHAR2,
		VALUE_NUMBER,
		VALUE_DATE,
		VALUE_NAME,
		MODULE,
		ADDITIONAL_VALUE1,
		ADDITIONAL_VALUE2,
		ADDITIONAL_VALUE3,
		ADDITIONAL_VALUE4,
		ADDITIONAL_VALUE5,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
		CREATION_DATE,
		LAST_UPDATE_DATE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
		FROM HZ_PARTY_PREFERENCES
		WHERE PARTY_ID = P_ORGANIZATION_ID) AS HZ_PARTY_PREF_OBJ_TBL),
		HZ_PHONE_CP_BO_TBL(),
		HZ_TELEX_CP_BO_TBL(),
		HZ_EMAIL_CP_BO_TBL(),
		HZ_WEB_CP_BO_TBL(),
		HZ_EDI_CP_BO_TBL(),
		HZ_EFT_CP_BO_TBL(),
		HZ_RELATIONSHIP_OBJ_TBL(),
	CAST(MULTISET (
		SELECT HZ_CODE_ASSIGNMENT_OBJ(
		P_ACTION_TYPE,
                NULL, -- COMMON_OBJ_ID
		CODE_ASSIGNMENT_ID,
		HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',OWNER_TABLE_ID),
		OWNER_TABLE_ID,
		CLASS_CATEGORY,
		CLASS_CODE,
		PRIMARY_FLAG,
		ACTUAL_CONTENT_SOURCE,
		START_DATE_ACTIVE,
		END_DATE_ACTIVE,
		STATUS,
		PROGRAM_UPDATE_DATE,
		CREATED_BY_MODULE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
		CREATION_DATE,
		LAST_UPDATE_DATE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
		RANK)
	FROM HZ_CODE_ASSIGNMENTS
	WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
	AND OWNER_TABLE_ID = P_ORGANIZATION_ID) AS HZ_CODE_ASSIGNMENT_OBJ_TBL),
		HZ_FINANCIAL_BO_TBL(),
			CAST(MULTISET (
	SELECT HZ_CREDIT_RATING_OBJ(
		P_ACTION_TYPE,
                NULL, -- COMMON_OBJ_ID
		CREDIT_RATING_ID,
		DESCRIPTION,
		PARTY_ID,
		RATING,
		RATED_AS_OF_DATE,
		RATING_ORGANIZATION,
		COMMENTS,
		DET_HISTORY_IND,
		FINCL_EMBT_IND,
		CRIMINAL_PROCEEDING_IND,
		CLAIMS_IND,
		SECURED_FLNG_IND,
		FINCL_LGL_EVENT_IND,
		DISASTER_IND,
		OPRG_SPEC_EVNT_IND,
		OTHER_SPEC_EVNT_IND,
		STATUS,
		AVG_HIGH_CREDIT,
		CREDIT_SCORE,
		CREDIT_SCORE_AGE,
		CREDIT_SCORE_CLASS,
		CREDIT_SCORE_COMMENTARY,
		CREDIT_SCORE_COMMENTARY2,
		CREDIT_SCORE_COMMENTARY3,
		CREDIT_SCORE_COMMENTARY4,
		CREDIT_SCORE_COMMENTARY5,
		CREDIT_SCORE_COMMENTARY6,
		CREDIT_SCORE_COMMENTARY7,
		CREDIT_SCORE_COMMENTARY8,
		CREDIT_SCORE_COMMENTARY9,
		CREDIT_SCORE_COMMENTARY10,
		CREDIT_SCORE_DATE,
		CREDIT_SCORE_INCD_DEFAULT,
		CREDIT_SCORE_NATL_PERCENTILE,
		FAILURE_SCORE,
		FAILURE_SCORE_AGE,
		FAILURE_SCORE_CLASS,
		FAILURE_SCORE_COMMENTARY,
		FAILURE_SCORE_COMMENTARY2,
		FAILURE_SCORE_COMMENTARY3,
		FAILURE_SCORE_COMMENTARY4,
		FAILURE_SCORE_COMMENTARY5,
		FAILURE_SCORE_COMMENTARY6,
		FAILURE_SCORE_COMMENTARY7,
		FAILURE_SCORE_COMMENTARY8,
		FAILURE_SCORE_COMMENTARY9,
		FAILURE_SCORE_COMMENTARY10,
		FAILURE_SCORE_DATE,
		FAILURE_SCORE_INCD_DEFAULT,
		FAILURE_SCORE_NATNL_PERCENTILE,
		FAILURE_SCORE_OVERRIDE_CODE,
		GLOBAL_FAILURE_SCORE,
		DEBARMENT_IND,
		DEBARMENTS_COUNT,
		DEBARMENTS_DATE,
		HIGH_CREDIT,
		MAXIMUM_CREDIT_CURRENCY_CODE,
		MAXIMUM_CREDIT_RECOMMENDATION,
		PAYDEX_NORM,
		PAYDEX_SCORE,
		PAYDEX_THREE_MONTHS_AGO,
		CREDIT_SCORE_OVERRIDE_CODE,
		CR_SCR_CLAS_EXPL,
		LOW_RNG_DELQ_SCR,
		HIGH_RNG_DELQ_SCR,
		DELQ_PMT_RNG_PRCNT,
		DELQ_PMT_PCTG_FOR_ALL_FIRMS,
		NUM_TRADE_EXPERIENCES,
		PAYDEX_FIRM_DAYS,
		PAYDEX_FIRM_COMMENT,
		PAYDEX_INDUSTRY_DAYS,
		PAYDEX_INDUSTRY_COMMENT,
		PAYDEX_COMMENT,
		SUIT_IND,
		LIEN_IND,
		JUDGEMENT_IND,
		BANKRUPTCY_IND,
		NO_TRADE_IND,
		PRNT_HQ_BKCY_IND,
		NUM_PRNT_BKCY_FILING,
		PRNT_BKCY_FILG_TYPE,
		PRNT_BKCY_FILG_CHAPTER,
		PRNT_BKCY_FILG_DATE,
		NUM_PRNT_BKCY_CONVS,
		PRNT_BKCY_CONV_DATE,
		PRNT_BKCY_CHAPTER_CONV,
		SLOW_TRADE_EXPL,
		NEGV_PMT_EXPL,
		PUB_REC_EXPL,
		BUSINESS_DISCONTINUED,
		SPCL_EVENT_COMMENT,
		NUM_SPCL_EVENT,
		SPCL_EVENT_UPDATE_DATE,
		SPCL_EVNT_TXT,
		ACTUAL_CONTENT_SOURCE,
		PROGRAM_UPDATE_DATE,
		CREATED_BY_MODULE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
		CREATION_DATE,
		LAST_UPDATE_DATE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
	FROM HZ_CREDIT_RATINGS
	WHERE PARTY_ID = P_ORGANIZATION_ID) AS HZ_CREDIT_RATING_OBJ_TBL),
		CAST(MULTISET (
	SELECT HZ_CERTIFICATION_OBJ(
		P_ACTION_TYPE,
                NULL, -- COMMON_OBJ_ID
		CERTIFICATION_ID,
		CERTIFICATION_NAME,
		HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',PARTY_ID),
		PARTY_ID,
		CURRENT_STATUS,
		EXPIRES_ON_DATE,
		GRADE,
		ISSUED_BY_AUTHORITY,
		ISSUED_ON_DATE,
		--WH_UPDATE_DATE,
		STATUS,
		PROGRAM_UPDATE_DATE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
		CREATION_DATE,
		LAST_UPDATE_DATE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
		FROM HZ_CERTIFICATIONS
		WHERE PARTY_ID = P_ORGANIZATION_ID) AS HZ_CERTIFICATION_OBJ_TBL),
	CAST(MULTISET (
		SELECT HZ_FINANCIAL_PROF_OBJ(
		P_ACTION_TYPE,
                NULL, -- COMMON_OBJ_ID
		FINANCIAL_PROFILE_ID,
		ACCESS_AUTHORITY_DATE,
		ACCESS_AUTHORITY_GRANTED,
		BALANCE_AMOUNT,
		BALANCE_VERIFIED_ON_DATE,
		FINANCIAL_ACCOUNT_NUMBER,
		FINANCIAL_ACCOUNT_TYPE,
		FINANCIAL_ORG_TYPE,
		FINANCIAL_ORGANIZATION_NAME,
		HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',PARTY_ID),
		PARTY_ID,
		--WH_UPDATE_DATE,
		STATUS,
		PROGRAM_UPDATE_DATE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
		CREATION_DATE,
		LAST_UPDATE_DATE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
		FROM HZ_FINANCIAL_PROFILE
		WHERE PARTY_ID = P_ORGANIZATION_ID) AS HZ_FINANCIAL_PROF_OBJ_TBL),
		HZ_CONTACT_PREF_OBJ_TBL(),
		HZ_PARTY_USAGE_OBJ_TBL())
      	FROM HZ_ORGANIZATION_PROFILES PRO, HZ_PARTIES P
	WHERE PRO.PARTY_ID = P.PARTY_ID
	AND PRO.PARTY_ID = P_ORGANIZATION_ID
	AND SYSDATE BETWEEN EFFECTIVE_START_DATE AND NVL(EFFECTIVE_END_DATE,SYSDATE);
Line: 650

	select organization_profile_id
	from HZ_ORGANIZATION_PROFILES
	where party_id = p_organization_id
	AND sysdate between effective_start_date and nvl(effective_end_date,sysdate);
Line: 1205

The Get Organizations Updated procedure is a service to retrieve all of the Organization business objects whose updates
have been captured by the logical business event. Each Organizations Updated business event signifies that one or more
Organization business objects have been updated.
The caller provides an identifier for the Organizations Update business event and the procedure returns database objects
of the type HZ_ORGANIZATION_BO for all of the Organization 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_organizations_updated(
    p_init_msg_list       IN            VARCHAR2 := fnd_api.g_false,
    p_event_id            IN           	NUMBER,
    x_organization_objs         OUT NOCOPY    HZ_ORGANIZATION_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: 1239

        	hz_utility_v2pub.debug(p_message=>'get_organizations_updated(+)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 1257

	-- call event API get_organization_updated for each id.

	x_organization_objs := HZ_ORGANIZATION_BO_TBL();
Line: 1263

		get_organization_updated(
    		p_init_msg_list => fnd_api.g_false,
		p_event_id => p_event_id,
    		p_organization_id  => l_obj_root_ids(i),
    		x_organization_obj  => x_organization_objs(i),
		x_return_status => x_return_status,
		x_msg_count => x_msg_count,
		x_msg_data => x_msg_data);
Line: 1289

        	hz_utility_v2pub.debug(p_message=>'get_organizations_updated (-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 1312

        hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 1331

        hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 1354

        hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 1391

			if px_party_site_obj.location_obj.location_id = p_child_id and p_action_type = 'UPDATED'
			then px_party_site_obj.location_obj.action_type := p_action_type;
Line: 1449

			px_party_site_obj.action_type := 'CHILD_UPDATED';
Line: 1462

	   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 CHILD_BO_CODE = 'ORG' --(or ORG, PERSON_CUST, ORG_CUST).
		and event_id = p_event_id
	   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: 1483

    	   select CHILD_ENTITY_NAME
	    FROM HZ_BUS_OBJ_TRACKING
	    where event_id = p_event_id
	    and populated_flag = 'N'
	    and CHILD_ENTITY_NAME = 'HZ_ORGANIZATION_PROFILES';
Line: 1511

		px_org_obj.action_type := 'UPDATED';
Line: 1512

	else px_org_obj.action_type := 'CHILD_UPDATED';
Line: 1522

			px_org_obj.action_type := 'UPDATED';
Line: 1529

		then l_action_type := 'UPDATED';
Line: 1791

					if px_org_obj.party_site_objs(i).location_obj.location_id = l_child_id and l_action_type = 'UPDATED'
					then px_org_obj.party_site_objs(i).location_obj.action_type := l_action_type;					   	l_child_upd_flag := 'Y';
Line: 1857

				    px_org_obj.party_site_objs(i).action_type := 'CHILD_UPDATED';
Line: 1893

				   PX_ORG_OBJ.FINANCIAL_REPORT_OBJS(i).action_type :=  'CHILD_UPDATED';
Line: 1995

			then PX_ORG_OBJ.CONTACT_OBJS(i).action_type := 'CHILD_UPDATED';
Line: 2052

PROCEDURE get_organization_updated(
    p_init_msg_list       IN            VARCHAR2 := fnd_api.g_false,
    p_event_id            IN           	NUMBER,
    p_organization_id     IN           NUMBER,
    x_organization_obj    OUT NOCOPY   HZ_ORGANIZATION_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: 2079

        	hz_utility_v2pub.debug(p_message=>'get_organizations_updated(+)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 2108

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


	l_organization_obj := x_organization_obj;
Line: 2135

        	hz_utility_v2pub.debug(p_message=>'get_organizations_updated (-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 2158

        hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 2177

        hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 2200

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