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.AR_CMGT_DATA_POINTS_PKG dependencies on HZ_ORGANIZATION_PROFILES

Line 3181: l_control_yr hz_organization_profiles.control_yr%type;

3177: p_annual_sales_volume_id IN NUMBER,
3178: p_resultout OUT nocopy VARCHAR2,
3179: p_error_msg OUT nocopy VARCHAR2) IS
3180:
3181: l_control_yr hz_organization_profiles.control_yr%type;
3182: l_incorp_year hz_organization_profiles.incorp_year%type;
3183: l_year_established hz_organization_profiles.year_established%type;
3184: l_employees_total hz_organization_profiles.employees_total%type;
3185: l_total_payments hz_organization_profiles.total_payments%type;

Line 3182: l_incorp_year hz_organization_profiles.incorp_year%type;

3178: p_resultout OUT nocopy VARCHAR2,
3179: p_error_msg OUT nocopy VARCHAR2) IS
3180:
3181: l_control_yr hz_organization_profiles.control_yr%type;
3182: l_incorp_year hz_organization_profiles.incorp_year%type;
3183: l_year_established hz_organization_profiles.year_established%type;
3184: l_employees_total hz_organization_profiles.employees_total%type;
3185: l_total_payments hz_organization_profiles.total_payments%type;
3186: l_maximum_credit_reco hz_organization_profiles.maximum_credit_recommendation%type;

Line 3183: l_year_established hz_organization_profiles.year_established%type;

3179: p_error_msg OUT nocopy VARCHAR2) IS
3180:
3181: l_control_yr hz_organization_profiles.control_yr%type;
3182: l_incorp_year hz_organization_profiles.incorp_year%type;
3183: l_year_established hz_organization_profiles.year_established%type;
3184: l_employees_total hz_organization_profiles.employees_total%type;
3185: l_total_payments hz_organization_profiles.total_payments%type;
3186: l_maximum_credit_reco hz_organization_profiles.maximum_credit_recommendation%type;
3187: l_oob_ind hz_organization_profiles.oob_ind%type;

Line 3184: l_employees_total hz_organization_profiles.employees_total%type;

3180:
3181: l_control_yr hz_organization_profiles.control_yr%type;
3182: l_incorp_year hz_organization_profiles.incorp_year%type;
3183: l_year_established hz_organization_profiles.year_established%type;
3184: l_employees_total hz_organization_profiles.employees_total%type;
3185: l_total_payments hz_organization_profiles.total_payments%type;
3186: l_maximum_credit_reco hz_organization_profiles.maximum_credit_recommendation%type;
3187: l_oob_ind hz_organization_profiles.oob_ind%type;
3188: l_TOTAL_EMPLOYEES_IND hz_organization_profiles.TOTAL_EMPLOYEES_IND%type;

Line 3185: l_total_payments hz_organization_profiles.total_payments%type;

3181: l_control_yr hz_organization_profiles.control_yr%type;
3182: l_incorp_year hz_organization_profiles.incorp_year%type;
3183: l_year_established hz_organization_profiles.year_established%type;
3184: l_employees_total hz_organization_profiles.employees_total%type;
3185: l_total_payments hz_organization_profiles.total_payments%type;
3186: l_maximum_credit_reco hz_organization_profiles.maximum_credit_recommendation%type;
3187: l_oob_ind hz_organization_profiles.oob_ind%type;
3188: l_TOTAL_EMPLOYEES_IND hz_organization_profiles.TOTAL_EMPLOYEES_IND%type;
3189: l_SIC_CODE hz_organization_profiles.SIC_CODE%type;

Line 3186: l_maximum_credit_reco hz_organization_profiles.maximum_credit_recommendation%type;

3182: l_incorp_year hz_organization_profiles.incorp_year%type;
3183: l_year_established hz_organization_profiles.year_established%type;
3184: l_employees_total hz_organization_profiles.employees_total%type;
3185: l_total_payments hz_organization_profiles.total_payments%type;
3186: l_maximum_credit_reco hz_organization_profiles.maximum_credit_recommendation%type;
3187: l_oob_ind hz_organization_profiles.oob_ind%type;
3188: l_TOTAL_EMPLOYEES_IND hz_organization_profiles.TOTAL_EMPLOYEES_IND%type;
3189: l_SIC_CODE hz_organization_profiles.SIC_CODE%type;
3190: l_RENT_OWN_IND hz_organization_profiles.RENT_OWN_IND%type;

Line 3187: l_oob_ind hz_organization_profiles.oob_ind%type;

3183: l_year_established hz_organization_profiles.year_established%type;
3184: l_employees_total hz_organization_profiles.employees_total%type;
3185: l_total_payments hz_organization_profiles.total_payments%type;
3186: l_maximum_credit_reco hz_organization_profiles.maximum_credit_recommendation%type;
3187: l_oob_ind hz_organization_profiles.oob_ind%type;
3188: l_TOTAL_EMPLOYEES_IND hz_organization_profiles.TOTAL_EMPLOYEES_IND%type;
3189: l_SIC_CODE hz_organization_profiles.SIC_CODE%type;
3190: l_RENT_OWN_IND hz_organization_profiles.RENT_OWN_IND%type;
3191: l_REGISTRATION_TYPE hz_organization_profiles.REGISTRATION_TYPE%type;

Line 3188: l_TOTAL_EMPLOYEES_IND hz_organization_profiles.TOTAL_EMPLOYEES_IND%type;

3184: l_employees_total hz_organization_profiles.employees_total%type;
3185: l_total_payments hz_organization_profiles.total_payments%type;
3186: l_maximum_credit_reco hz_organization_profiles.maximum_credit_recommendation%type;
3187: l_oob_ind hz_organization_profiles.oob_ind%type;
3188: l_TOTAL_EMPLOYEES_IND hz_organization_profiles.TOTAL_EMPLOYEES_IND%type;
3189: l_SIC_CODE hz_organization_profiles.SIC_CODE%type;
3190: l_RENT_OWN_IND hz_organization_profiles.RENT_OWN_IND%type;
3191: l_REGISTRATION_TYPE hz_organization_profiles.REGISTRATION_TYPE%type;
3192: l_LEGAL_STATUS hz_organization_profiles.LEGAL_STATUS%type;

Line 3189: l_SIC_CODE hz_organization_profiles.SIC_CODE%type;

3185: l_total_payments hz_organization_profiles.total_payments%type;
3186: l_maximum_credit_reco hz_organization_profiles.maximum_credit_recommendation%type;
3187: l_oob_ind hz_organization_profiles.oob_ind%type;
3188: l_TOTAL_EMPLOYEES_IND hz_organization_profiles.TOTAL_EMPLOYEES_IND%type;
3189: l_SIC_CODE hz_organization_profiles.SIC_CODE%type;
3190: l_RENT_OWN_IND hz_organization_profiles.RENT_OWN_IND%type;
3191: l_REGISTRATION_TYPE hz_organization_profiles.REGISTRATION_TYPE%type;
3192: l_LEGAL_STATUS hz_organization_profiles.LEGAL_STATUS%type;
3193: l_HQ_BRANCH_IND hz_organization_profiles.HQ_BRANCH_IND%type;

Line 3190: l_RENT_OWN_IND hz_organization_profiles.RENT_OWN_IND%type;

3186: l_maximum_credit_reco hz_organization_profiles.maximum_credit_recommendation%type;
3187: l_oob_ind hz_organization_profiles.oob_ind%type;
3188: l_TOTAL_EMPLOYEES_IND hz_organization_profiles.TOTAL_EMPLOYEES_IND%type;
3189: l_SIC_CODE hz_organization_profiles.SIC_CODE%type;
3190: l_RENT_OWN_IND hz_organization_profiles.RENT_OWN_IND%type;
3191: l_REGISTRATION_TYPE hz_organization_profiles.REGISTRATION_TYPE%type;
3192: l_LEGAL_STATUS hz_organization_profiles.LEGAL_STATUS%type;
3193: l_HQ_BRANCH_IND hz_organization_profiles.HQ_BRANCH_IND%type;
3194: l_BRANCH_FLAG hz_organization_profiles.BRANCH_FLAG%type;

Line 3191: l_REGISTRATION_TYPE hz_organization_profiles.REGISTRATION_TYPE%type;

3187: l_oob_ind hz_organization_profiles.oob_ind%type;
3188: l_TOTAL_EMPLOYEES_IND hz_organization_profiles.TOTAL_EMPLOYEES_IND%type;
3189: l_SIC_CODE hz_organization_profiles.SIC_CODE%type;
3190: l_RENT_OWN_IND hz_organization_profiles.RENT_OWN_IND%type;
3191: l_REGISTRATION_TYPE hz_organization_profiles.REGISTRATION_TYPE%type;
3192: l_LEGAL_STATUS hz_organization_profiles.LEGAL_STATUS%type;
3193: l_HQ_BRANCH_IND hz_organization_profiles.HQ_BRANCH_IND%type;
3194: l_BRANCH_FLAG hz_organization_profiles.BRANCH_FLAG%type;
3195: l_LOCAL_ACTIVITY_CODE_TYPE hz_organization_profiles.LOCAL_ACTIVITY_CODE_TYPE%type;

Line 3192: l_LEGAL_STATUS hz_organization_profiles.LEGAL_STATUS%type;

3188: l_TOTAL_EMPLOYEES_IND hz_organization_profiles.TOTAL_EMPLOYEES_IND%type;
3189: l_SIC_CODE hz_organization_profiles.SIC_CODE%type;
3190: l_RENT_OWN_IND hz_organization_profiles.RENT_OWN_IND%type;
3191: l_REGISTRATION_TYPE hz_organization_profiles.REGISTRATION_TYPE%type;
3192: l_LEGAL_STATUS hz_organization_profiles.LEGAL_STATUS%type;
3193: l_HQ_BRANCH_IND hz_organization_profiles.HQ_BRANCH_IND%type;
3194: l_BRANCH_FLAG hz_organization_profiles.BRANCH_FLAG%type;
3195: l_LOCAL_ACTIVITY_CODE_TYPE hz_organization_profiles.LOCAL_ACTIVITY_CODE_TYPE%type;
3196: l_LOCAL_ACTIVITY_CODE hz_organization_profiles.LOCAL_ACTIVITY_CODE%type;

Line 3193: l_HQ_BRANCH_IND hz_organization_profiles.HQ_BRANCH_IND%type;

3189: l_SIC_CODE hz_organization_profiles.SIC_CODE%type;
3190: l_RENT_OWN_IND hz_organization_profiles.RENT_OWN_IND%type;
3191: l_REGISTRATION_TYPE hz_organization_profiles.REGISTRATION_TYPE%type;
3192: l_LEGAL_STATUS hz_organization_profiles.LEGAL_STATUS%type;
3193: l_HQ_BRANCH_IND hz_organization_profiles.HQ_BRANCH_IND%type;
3194: l_BRANCH_FLAG hz_organization_profiles.BRANCH_FLAG%type;
3195: l_LOCAL_ACTIVITY_CODE_TYPE hz_organization_profiles.LOCAL_ACTIVITY_CODE_TYPE%type;
3196: l_LOCAL_ACTIVITY_CODE hz_organization_profiles.LOCAL_ACTIVITY_CODE%type;
3197: l_SIC_CODE_TYPE hz_organization_profiles.SIC_CODE_TYPE%type;

Line 3194: l_BRANCH_FLAG hz_organization_profiles.BRANCH_FLAG%type;

3190: l_RENT_OWN_IND hz_organization_profiles.RENT_OWN_IND%type;
3191: l_REGISTRATION_TYPE hz_organization_profiles.REGISTRATION_TYPE%type;
3192: l_LEGAL_STATUS hz_organization_profiles.LEGAL_STATUS%type;
3193: l_HQ_BRANCH_IND hz_organization_profiles.HQ_BRANCH_IND%type;
3194: l_BRANCH_FLAG hz_organization_profiles.BRANCH_FLAG%type;
3195: l_LOCAL_ACTIVITY_CODE_TYPE hz_organization_profiles.LOCAL_ACTIVITY_CODE_TYPE%type;
3196: l_LOCAL_ACTIVITY_CODE hz_organization_profiles.LOCAL_ACTIVITY_CODE%type;
3197: l_SIC_CODE_TYPE hz_organization_profiles.SIC_CODE_TYPE%type;
3198: l_GLOBAL_FAILURE_SCORE hz_organization_profiles.GLOBAL_FAILURE_SCORE%type;

Line 3195: l_LOCAL_ACTIVITY_CODE_TYPE hz_organization_profiles.LOCAL_ACTIVITY_CODE_TYPE%type;

3191: l_REGISTRATION_TYPE hz_organization_profiles.REGISTRATION_TYPE%type;
3192: l_LEGAL_STATUS hz_organization_profiles.LEGAL_STATUS%type;
3193: l_HQ_BRANCH_IND hz_organization_profiles.HQ_BRANCH_IND%type;
3194: l_BRANCH_FLAG hz_organization_profiles.BRANCH_FLAG%type;
3195: l_LOCAL_ACTIVITY_CODE_TYPE hz_organization_profiles.LOCAL_ACTIVITY_CODE_TYPE%type;
3196: l_LOCAL_ACTIVITY_CODE hz_organization_profiles.LOCAL_ACTIVITY_CODE%type;
3197: l_SIC_CODE_TYPE hz_organization_profiles.SIC_CODE_TYPE%type;
3198: l_GLOBAL_FAILURE_SCORE hz_organization_profiles.GLOBAL_FAILURE_SCORE%type;
3199: l_IMPORT_IND hz_organization_profiles.IMPORT_IND%type;

Line 3196: l_LOCAL_ACTIVITY_CODE hz_organization_profiles.LOCAL_ACTIVITY_CODE%type;

3192: l_LEGAL_STATUS hz_organization_profiles.LEGAL_STATUS%type;
3193: l_HQ_BRANCH_IND hz_organization_profiles.HQ_BRANCH_IND%type;
3194: l_BRANCH_FLAG hz_organization_profiles.BRANCH_FLAG%type;
3195: l_LOCAL_ACTIVITY_CODE_TYPE hz_organization_profiles.LOCAL_ACTIVITY_CODE_TYPE%type;
3196: l_LOCAL_ACTIVITY_CODE hz_organization_profiles.LOCAL_ACTIVITY_CODE%type;
3197: l_SIC_CODE_TYPE hz_organization_profiles.SIC_CODE_TYPE%type;
3198: l_GLOBAL_FAILURE_SCORE hz_organization_profiles.GLOBAL_FAILURE_SCORE%type;
3199: l_IMPORT_IND hz_organization_profiles.IMPORT_IND%type;
3200: l_DUNS_NUMBER_C hz_organization_profiles.DUNS_NUMBER_C%type;

Line 3197: l_SIC_CODE_TYPE hz_organization_profiles.SIC_CODE_TYPE%type;

3193: l_HQ_BRANCH_IND hz_organization_profiles.HQ_BRANCH_IND%type;
3194: l_BRANCH_FLAG hz_organization_profiles.BRANCH_FLAG%type;
3195: l_LOCAL_ACTIVITY_CODE_TYPE hz_organization_profiles.LOCAL_ACTIVITY_CODE_TYPE%type;
3196: l_LOCAL_ACTIVITY_CODE hz_organization_profiles.LOCAL_ACTIVITY_CODE%type;
3197: l_SIC_CODE_TYPE hz_organization_profiles.SIC_CODE_TYPE%type;
3198: l_GLOBAL_FAILURE_SCORE hz_organization_profiles.GLOBAL_FAILURE_SCORE%type;
3199: l_IMPORT_IND hz_organization_profiles.IMPORT_IND%type;
3200: l_DUNS_NUMBER_C hz_organization_profiles.DUNS_NUMBER_C%type;
3201: l_PARENT_SUB_IND hz_organization_profiles.PARENT_SUB_IND%type;

Line 3198: l_GLOBAL_FAILURE_SCORE hz_organization_profiles.GLOBAL_FAILURE_SCORE%type;

3194: l_BRANCH_FLAG hz_organization_profiles.BRANCH_FLAG%type;
3195: l_LOCAL_ACTIVITY_CODE_TYPE hz_organization_profiles.LOCAL_ACTIVITY_CODE_TYPE%type;
3196: l_LOCAL_ACTIVITY_CODE hz_organization_profiles.LOCAL_ACTIVITY_CODE%type;
3197: l_SIC_CODE_TYPE hz_organization_profiles.SIC_CODE_TYPE%type;
3198: l_GLOBAL_FAILURE_SCORE hz_organization_profiles.GLOBAL_FAILURE_SCORE%type;
3199: l_IMPORT_IND hz_organization_profiles.IMPORT_IND%type;
3200: l_DUNS_NUMBER_C hz_organization_profiles.DUNS_NUMBER_C%type;
3201: l_PARENT_SUB_IND hz_organization_profiles.PARENT_SUB_IND%type;
3202: l_FAILURE_SCORE hz_organization_profiles.FAILURE_SCORE%type;

Line 3199: l_IMPORT_IND hz_organization_profiles.IMPORT_IND%type;

3195: l_LOCAL_ACTIVITY_CODE_TYPE hz_organization_profiles.LOCAL_ACTIVITY_CODE_TYPE%type;
3196: l_LOCAL_ACTIVITY_CODE hz_organization_profiles.LOCAL_ACTIVITY_CODE%type;
3197: l_SIC_CODE_TYPE hz_organization_profiles.SIC_CODE_TYPE%type;
3198: l_GLOBAL_FAILURE_SCORE hz_organization_profiles.GLOBAL_FAILURE_SCORE%type;
3199: l_IMPORT_IND hz_organization_profiles.IMPORT_IND%type;
3200: l_DUNS_NUMBER_C hz_organization_profiles.DUNS_NUMBER_C%type;
3201: l_PARENT_SUB_IND hz_organization_profiles.PARENT_SUB_IND%type;
3202: l_FAILURE_SCORE hz_organization_profiles.FAILURE_SCORE%type;
3203: l_FAILURE_SCORE_COMMENTARY hz_organization_profiles.FAILURE_SCORE_COMMENTARY%type;

Line 3200: l_DUNS_NUMBER_C hz_organization_profiles.DUNS_NUMBER_C%type;

3196: l_LOCAL_ACTIVITY_CODE hz_organization_profiles.LOCAL_ACTIVITY_CODE%type;
3197: l_SIC_CODE_TYPE hz_organization_profiles.SIC_CODE_TYPE%type;
3198: l_GLOBAL_FAILURE_SCORE hz_organization_profiles.GLOBAL_FAILURE_SCORE%type;
3199: l_IMPORT_IND hz_organization_profiles.IMPORT_IND%type;
3200: l_DUNS_NUMBER_C hz_organization_profiles.DUNS_NUMBER_C%type;
3201: l_PARENT_SUB_IND hz_organization_profiles.PARENT_SUB_IND%type;
3202: l_FAILURE_SCORE hz_organization_profiles.FAILURE_SCORE%type;
3203: l_FAILURE_SCORE_COMMENTARY hz_organization_profiles.FAILURE_SCORE_COMMENTARY%type;
3204: l_TOTAL_EMP_EST_IND hz_organization_profiles.TOTAL_EMP_EST_IND%type;

Line 3201: l_PARENT_SUB_IND hz_organization_profiles.PARENT_SUB_IND%type;

3197: l_SIC_CODE_TYPE hz_organization_profiles.SIC_CODE_TYPE%type;
3198: l_GLOBAL_FAILURE_SCORE hz_organization_profiles.GLOBAL_FAILURE_SCORE%type;
3199: l_IMPORT_IND hz_organization_profiles.IMPORT_IND%type;
3200: l_DUNS_NUMBER_C hz_organization_profiles.DUNS_NUMBER_C%type;
3201: l_PARENT_SUB_IND hz_organization_profiles.PARENT_SUB_IND%type;
3202: l_FAILURE_SCORE hz_organization_profiles.FAILURE_SCORE%type;
3203: l_FAILURE_SCORE_COMMENTARY hz_organization_profiles.FAILURE_SCORE_COMMENTARY%type;
3204: l_TOTAL_EMP_EST_IND hz_organization_profiles.TOTAL_EMP_EST_IND%type;
3205:

Line 3202: l_FAILURE_SCORE hz_organization_profiles.FAILURE_SCORE%type;

3198: l_GLOBAL_FAILURE_SCORE hz_organization_profiles.GLOBAL_FAILURE_SCORE%type;
3199: l_IMPORT_IND hz_organization_profiles.IMPORT_IND%type;
3200: l_DUNS_NUMBER_C hz_organization_profiles.DUNS_NUMBER_C%type;
3201: l_PARENT_SUB_IND hz_organization_profiles.PARENT_SUB_IND%type;
3202: l_FAILURE_SCORE hz_organization_profiles.FAILURE_SCORE%type;
3203: l_FAILURE_SCORE_COMMENTARY hz_organization_profiles.FAILURE_SCORE_COMMENTARY%type;
3204: l_TOTAL_EMP_EST_IND hz_organization_profiles.TOTAL_EMP_EST_IND%type;
3205:
3206: l_PAYDEX_SCORE Number;

Line 3203: l_FAILURE_SCORE_COMMENTARY hz_organization_profiles.FAILURE_SCORE_COMMENTARY%type;

3199: l_IMPORT_IND hz_organization_profiles.IMPORT_IND%type;
3200: l_DUNS_NUMBER_C hz_organization_profiles.DUNS_NUMBER_C%type;
3201: l_PARENT_SUB_IND hz_organization_profiles.PARENT_SUB_IND%type;
3202: l_FAILURE_SCORE hz_organization_profiles.FAILURE_SCORE%type;
3203: l_FAILURE_SCORE_COMMENTARY hz_organization_profiles.FAILURE_SCORE_COMMENTARY%type;
3204: l_TOTAL_EMP_EST_IND hz_organization_profiles.TOTAL_EMP_EST_IND%type;
3205:
3206: l_PAYDEX_SCORE Number;
3207: l_PAYDEX_THREE_MONTHS_AGO Number;

Line 3204: l_TOTAL_EMP_EST_IND hz_organization_profiles.TOTAL_EMP_EST_IND%type;

3200: l_DUNS_NUMBER_C hz_organization_profiles.DUNS_NUMBER_C%type;
3201: l_PARENT_SUB_IND hz_organization_profiles.PARENT_SUB_IND%type;
3202: l_FAILURE_SCORE hz_organization_profiles.FAILURE_SCORE%type;
3203: l_FAILURE_SCORE_COMMENTARY hz_organization_profiles.FAILURE_SCORE_COMMENTARY%type;
3204: l_TOTAL_EMP_EST_IND hz_organization_profiles.TOTAL_EMP_EST_IND%type;
3205:
3206: l_PAYDEX_SCORE Number;
3207: l_PAYDEX_THREE_MONTHS_AGO Number;
3208: l_AVG_HIGH_CREDIT HZ_CREDIT_RATINGS.AVG_HIGH_CREDIT%type;

Line 3323: FROM hz_organization_profiles

3319: PARENT_SUB_IND,
3320: FAILURE_SCORE,
3321: FAILURE_SCORE_COMMENTARY
3322:
3323: FROM hz_organization_profiles
3324: WHERE organization_profile_id = p_org_profile_id;
3325:
3326: CURSOR cCrRatings IS
3327: SELECT decode(PAYDEX_SCORE,'UN', null, paydex_score ) paydex_score,

Line 4408: l_organization_profile_id hz_organization_profiles.organization_profile_id%TYPE;

4404: p_mode IN VARCHAR2 default 'CREATE',
4405: p_resultout OUT nocopy VARCHAR2,
4406: p_error_msg OUT nocopy VARCHAR2) IS
4407:
4408: l_organization_profile_id hz_organization_profiles.organization_profile_id%TYPE;
4409: l_location_id hz_locations.location_id%TYPE;
4410: l_contact_point_id hz_contact_points.contact_point_id%TYPE;
4411: l_relationship_id hz_relationships.relationship_id%TYPE;
4412: l_report_type hz_financial_reports.type_of_financial_report%TYPE := 'BALANCE_SHEET';

Line 4510: FROM HZ_ORGANIZATION_PROFILES

4506:
4507: BEGIN
4508: SELECT ORGANIZATION_PROFILE_ID
4509: INTO l_organization_profile_id
4510: FROM HZ_ORGANIZATION_PROFILES
4511: WHERE party_id = p_party_id
4512: AND effective_end_date IS NULL
4513: AND ACTUAL_CONTENT_SOURCE = 'DNB';
4514:

Line 4517: p_source_table_name => 'HZ_ORGANIZATION_PROFILES',

4513: AND ACTUAL_CONTENT_SOURCE = 'DNB';
4514:
4515: populate_dnb_data(
4516: p_case_folder_id => p_case_folder_id,
4517: p_source_table_name => 'HZ_ORGANIZATION_PROFILES',
4518: p_source_key => l_organization_profile_id,
4519: p_source_key_column_name => 'ORGANIZATION_PROFILE_ID',
4520: p_mode => p_mode);
4521: EXCEPTION

Line 4526: p_error_msg := 'SqlError While retrieving Data from HZ_ORGANIZATION_PROFILES '||sqlerrm;

4522: WHEN NO_DATA_FOUND THEN
4523: NULL;
4524: WHEN OTHERS THEN
4525: p_resultout := 1;
4526: p_error_msg := 'SqlError While retrieving Data from HZ_ORGANIZATION_PROFILES '||sqlerrm;
4527: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);
4528: return;
4529: END;
4530: -- Get location id