The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
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);
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);
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;
hz_utility_v2pub.debug(p_message=>'get_organizations_updated(+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
-- call event API get_organization_updated for each id.
x_organization_objs := HZ_ORGANIZATION_BO_TBL();
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);
hz_utility_v2pub.debug(p_message=>'get_organizations_updated (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
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;
px_party_site_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 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;
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';
px_org_obj.action_type := 'UPDATED';
else px_org_obj.action_type := 'CHILD_UPDATED';
px_org_obj.action_type := 'UPDATED';
then l_action_type := 'UPDATED';
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';
px_org_obj.party_site_objs(i).action_type := 'CHILD_UPDATED';
PX_ORG_OBJ.FINANCIAL_REPORT_OBJS(i).action_type := 'CHILD_UPDATED';
then PX_ORG_OBJ.CONTACT_OBJS(i).action_type := 'CHILD_UPDATED';
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;
hz_utility_v2pub.debug(p_message=>'get_organizations_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_organization_obj := x_organization_obj;
hz_utility_v2pub.debug(p_message=>'get_organizations_updated (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);