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 3032: l_control_yr hz_organization_profiles.control_yr%type;

3028: p_annual_sales_volume_id IN NUMBER,
3029: p_resultout OUT nocopy VARCHAR2,
3030: p_error_msg OUT nocopy VARCHAR2) IS
3031:
3032: l_control_yr hz_organization_profiles.control_yr%type;
3033: l_incorp_year hz_organization_profiles.incorp_year%type;
3034: l_year_established hz_organization_profiles.year_established%type;
3035: l_employees_total hz_organization_profiles.employees_total%type;
3036: l_total_payments hz_organization_profiles.total_payments%type;

Line 3033: l_incorp_year hz_organization_profiles.incorp_year%type;

3029: p_resultout OUT nocopy VARCHAR2,
3030: p_error_msg OUT nocopy VARCHAR2) IS
3031:
3032: l_control_yr hz_organization_profiles.control_yr%type;
3033: l_incorp_year hz_organization_profiles.incorp_year%type;
3034: l_year_established hz_organization_profiles.year_established%type;
3035: l_employees_total hz_organization_profiles.employees_total%type;
3036: l_total_payments hz_organization_profiles.total_payments%type;
3037: l_maximum_credit_reco hz_organization_profiles.maximum_credit_recommendation%type;

Line 3034: l_year_established hz_organization_profiles.year_established%type;

3030: p_error_msg OUT nocopy VARCHAR2) IS
3031:
3032: l_control_yr hz_organization_profiles.control_yr%type;
3033: l_incorp_year hz_organization_profiles.incorp_year%type;
3034: l_year_established hz_organization_profiles.year_established%type;
3035: l_employees_total hz_organization_profiles.employees_total%type;
3036: l_total_payments hz_organization_profiles.total_payments%type;
3037: l_maximum_credit_reco hz_organization_profiles.maximum_credit_recommendation%type;
3038: l_oob_ind hz_organization_profiles.oob_ind%type;

Line 3035: l_employees_total hz_organization_profiles.employees_total%type;

3031:
3032: l_control_yr hz_organization_profiles.control_yr%type;
3033: l_incorp_year hz_organization_profiles.incorp_year%type;
3034: l_year_established hz_organization_profiles.year_established%type;
3035: l_employees_total hz_organization_profiles.employees_total%type;
3036: l_total_payments hz_organization_profiles.total_payments%type;
3037: l_maximum_credit_reco hz_organization_profiles.maximum_credit_recommendation%type;
3038: l_oob_ind hz_organization_profiles.oob_ind%type;
3039: l_TOTAL_EMPLOYEES_IND hz_organization_profiles.TOTAL_EMPLOYEES_IND%type;

Line 3036: l_total_payments hz_organization_profiles.total_payments%type;

3032: l_control_yr hz_organization_profiles.control_yr%type;
3033: l_incorp_year hz_organization_profiles.incorp_year%type;
3034: l_year_established hz_organization_profiles.year_established%type;
3035: l_employees_total hz_organization_profiles.employees_total%type;
3036: l_total_payments hz_organization_profiles.total_payments%type;
3037: l_maximum_credit_reco hz_organization_profiles.maximum_credit_recommendation%type;
3038: l_oob_ind hz_organization_profiles.oob_ind%type;
3039: l_TOTAL_EMPLOYEES_IND hz_organization_profiles.TOTAL_EMPLOYEES_IND%type;
3040: l_SIC_CODE hz_organization_profiles.SIC_CODE%type;

Line 3037: l_maximum_credit_reco hz_organization_profiles.maximum_credit_recommendation%type;

3033: l_incorp_year hz_organization_profiles.incorp_year%type;
3034: l_year_established hz_organization_profiles.year_established%type;
3035: l_employees_total hz_organization_profiles.employees_total%type;
3036: l_total_payments hz_organization_profiles.total_payments%type;
3037: l_maximum_credit_reco hz_organization_profiles.maximum_credit_recommendation%type;
3038: l_oob_ind hz_organization_profiles.oob_ind%type;
3039: l_TOTAL_EMPLOYEES_IND hz_organization_profiles.TOTAL_EMPLOYEES_IND%type;
3040: l_SIC_CODE hz_organization_profiles.SIC_CODE%type;
3041: l_RENT_OWN_IND hz_organization_profiles.RENT_OWN_IND%type;

Line 3038: l_oob_ind hz_organization_profiles.oob_ind%type;

3034: l_year_established hz_organization_profiles.year_established%type;
3035: l_employees_total hz_organization_profiles.employees_total%type;
3036: l_total_payments hz_organization_profiles.total_payments%type;
3037: l_maximum_credit_reco hz_organization_profiles.maximum_credit_recommendation%type;
3038: l_oob_ind hz_organization_profiles.oob_ind%type;
3039: l_TOTAL_EMPLOYEES_IND hz_organization_profiles.TOTAL_EMPLOYEES_IND%type;
3040: l_SIC_CODE hz_organization_profiles.SIC_CODE%type;
3041: l_RENT_OWN_IND hz_organization_profiles.RENT_OWN_IND%type;
3042: l_REGISTRATION_TYPE hz_organization_profiles.REGISTRATION_TYPE%type;

Line 3039: l_TOTAL_EMPLOYEES_IND hz_organization_profiles.TOTAL_EMPLOYEES_IND%type;

3035: l_employees_total hz_organization_profiles.employees_total%type;
3036: l_total_payments hz_organization_profiles.total_payments%type;
3037: l_maximum_credit_reco hz_organization_profiles.maximum_credit_recommendation%type;
3038: l_oob_ind hz_organization_profiles.oob_ind%type;
3039: l_TOTAL_EMPLOYEES_IND hz_organization_profiles.TOTAL_EMPLOYEES_IND%type;
3040: l_SIC_CODE hz_organization_profiles.SIC_CODE%type;
3041: l_RENT_OWN_IND hz_organization_profiles.RENT_OWN_IND%type;
3042: l_REGISTRATION_TYPE hz_organization_profiles.REGISTRATION_TYPE%type;
3043: l_LEGAL_STATUS hz_organization_profiles.LEGAL_STATUS%type;

Line 3040: l_SIC_CODE hz_organization_profiles.SIC_CODE%type;

3036: l_total_payments hz_organization_profiles.total_payments%type;
3037: l_maximum_credit_reco hz_organization_profiles.maximum_credit_recommendation%type;
3038: l_oob_ind hz_organization_profiles.oob_ind%type;
3039: l_TOTAL_EMPLOYEES_IND hz_organization_profiles.TOTAL_EMPLOYEES_IND%type;
3040: l_SIC_CODE hz_organization_profiles.SIC_CODE%type;
3041: l_RENT_OWN_IND hz_organization_profiles.RENT_OWN_IND%type;
3042: l_REGISTRATION_TYPE hz_organization_profiles.REGISTRATION_TYPE%type;
3043: l_LEGAL_STATUS hz_organization_profiles.LEGAL_STATUS%type;
3044: l_HQ_BRANCH_IND hz_organization_profiles.HQ_BRANCH_IND%type;

Line 3041: l_RENT_OWN_IND hz_organization_profiles.RENT_OWN_IND%type;

3037: l_maximum_credit_reco hz_organization_profiles.maximum_credit_recommendation%type;
3038: l_oob_ind hz_organization_profiles.oob_ind%type;
3039: l_TOTAL_EMPLOYEES_IND hz_organization_profiles.TOTAL_EMPLOYEES_IND%type;
3040: l_SIC_CODE hz_organization_profiles.SIC_CODE%type;
3041: l_RENT_OWN_IND hz_organization_profiles.RENT_OWN_IND%type;
3042: l_REGISTRATION_TYPE hz_organization_profiles.REGISTRATION_TYPE%type;
3043: l_LEGAL_STATUS hz_organization_profiles.LEGAL_STATUS%type;
3044: l_HQ_BRANCH_IND hz_organization_profiles.HQ_BRANCH_IND%type;
3045: l_BRANCH_FLAG hz_organization_profiles.BRANCH_FLAG%type;

Line 3042: l_REGISTRATION_TYPE hz_organization_profiles.REGISTRATION_TYPE%type;

3038: l_oob_ind hz_organization_profiles.oob_ind%type;
3039: l_TOTAL_EMPLOYEES_IND hz_organization_profiles.TOTAL_EMPLOYEES_IND%type;
3040: l_SIC_CODE hz_organization_profiles.SIC_CODE%type;
3041: l_RENT_OWN_IND hz_organization_profiles.RENT_OWN_IND%type;
3042: l_REGISTRATION_TYPE hz_organization_profiles.REGISTRATION_TYPE%type;
3043: l_LEGAL_STATUS hz_organization_profiles.LEGAL_STATUS%type;
3044: l_HQ_BRANCH_IND hz_organization_profiles.HQ_BRANCH_IND%type;
3045: l_BRANCH_FLAG hz_organization_profiles.BRANCH_FLAG%type;
3046: l_LOCAL_ACTIVITY_CODE_TYPE hz_organization_profiles.LOCAL_ACTIVITY_CODE_TYPE%type;

Line 3043: l_LEGAL_STATUS hz_organization_profiles.LEGAL_STATUS%type;

3039: l_TOTAL_EMPLOYEES_IND hz_organization_profiles.TOTAL_EMPLOYEES_IND%type;
3040: l_SIC_CODE hz_organization_profiles.SIC_CODE%type;
3041: l_RENT_OWN_IND hz_organization_profiles.RENT_OWN_IND%type;
3042: l_REGISTRATION_TYPE hz_organization_profiles.REGISTRATION_TYPE%type;
3043: l_LEGAL_STATUS hz_organization_profiles.LEGAL_STATUS%type;
3044: l_HQ_BRANCH_IND hz_organization_profiles.HQ_BRANCH_IND%type;
3045: l_BRANCH_FLAG hz_organization_profiles.BRANCH_FLAG%type;
3046: l_LOCAL_ACTIVITY_CODE_TYPE hz_organization_profiles.LOCAL_ACTIVITY_CODE_TYPE%type;
3047: l_LOCAL_ACTIVITY_CODE hz_organization_profiles.LOCAL_ACTIVITY_CODE%type;

Line 3044: l_HQ_BRANCH_IND hz_organization_profiles.HQ_BRANCH_IND%type;

3040: l_SIC_CODE hz_organization_profiles.SIC_CODE%type;
3041: l_RENT_OWN_IND hz_organization_profiles.RENT_OWN_IND%type;
3042: l_REGISTRATION_TYPE hz_organization_profiles.REGISTRATION_TYPE%type;
3043: l_LEGAL_STATUS hz_organization_profiles.LEGAL_STATUS%type;
3044: l_HQ_BRANCH_IND hz_organization_profiles.HQ_BRANCH_IND%type;
3045: l_BRANCH_FLAG hz_organization_profiles.BRANCH_FLAG%type;
3046: l_LOCAL_ACTIVITY_CODE_TYPE hz_organization_profiles.LOCAL_ACTIVITY_CODE_TYPE%type;
3047: l_LOCAL_ACTIVITY_CODE hz_organization_profiles.LOCAL_ACTIVITY_CODE%type;
3048: l_SIC_CODE_TYPE hz_organization_profiles.SIC_CODE_TYPE%type;

Line 3045: l_BRANCH_FLAG hz_organization_profiles.BRANCH_FLAG%type;

3041: l_RENT_OWN_IND hz_organization_profiles.RENT_OWN_IND%type;
3042: l_REGISTRATION_TYPE hz_organization_profiles.REGISTRATION_TYPE%type;
3043: l_LEGAL_STATUS hz_organization_profiles.LEGAL_STATUS%type;
3044: l_HQ_BRANCH_IND hz_organization_profiles.HQ_BRANCH_IND%type;
3045: l_BRANCH_FLAG hz_organization_profiles.BRANCH_FLAG%type;
3046: l_LOCAL_ACTIVITY_CODE_TYPE hz_organization_profiles.LOCAL_ACTIVITY_CODE_TYPE%type;
3047: l_LOCAL_ACTIVITY_CODE hz_organization_profiles.LOCAL_ACTIVITY_CODE%type;
3048: l_SIC_CODE_TYPE hz_organization_profiles.SIC_CODE_TYPE%type;
3049: l_GLOBAL_FAILURE_SCORE hz_organization_profiles.GLOBAL_FAILURE_SCORE%type;

Line 3046: l_LOCAL_ACTIVITY_CODE_TYPE hz_organization_profiles.LOCAL_ACTIVITY_CODE_TYPE%type;

3042: l_REGISTRATION_TYPE hz_organization_profiles.REGISTRATION_TYPE%type;
3043: l_LEGAL_STATUS hz_organization_profiles.LEGAL_STATUS%type;
3044: l_HQ_BRANCH_IND hz_organization_profiles.HQ_BRANCH_IND%type;
3045: l_BRANCH_FLAG hz_organization_profiles.BRANCH_FLAG%type;
3046: l_LOCAL_ACTIVITY_CODE_TYPE hz_organization_profiles.LOCAL_ACTIVITY_CODE_TYPE%type;
3047: l_LOCAL_ACTIVITY_CODE hz_organization_profiles.LOCAL_ACTIVITY_CODE%type;
3048: l_SIC_CODE_TYPE hz_organization_profiles.SIC_CODE_TYPE%type;
3049: l_GLOBAL_FAILURE_SCORE hz_organization_profiles.GLOBAL_FAILURE_SCORE%type;
3050: l_IMPORT_IND hz_organization_profiles.IMPORT_IND%type;

Line 3047: l_LOCAL_ACTIVITY_CODE hz_organization_profiles.LOCAL_ACTIVITY_CODE%type;

3043: l_LEGAL_STATUS hz_organization_profiles.LEGAL_STATUS%type;
3044: l_HQ_BRANCH_IND hz_organization_profiles.HQ_BRANCH_IND%type;
3045: l_BRANCH_FLAG hz_organization_profiles.BRANCH_FLAG%type;
3046: l_LOCAL_ACTIVITY_CODE_TYPE hz_organization_profiles.LOCAL_ACTIVITY_CODE_TYPE%type;
3047: l_LOCAL_ACTIVITY_CODE hz_organization_profiles.LOCAL_ACTIVITY_CODE%type;
3048: l_SIC_CODE_TYPE hz_organization_profiles.SIC_CODE_TYPE%type;
3049: l_GLOBAL_FAILURE_SCORE hz_organization_profiles.GLOBAL_FAILURE_SCORE%type;
3050: l_IMPORT_IND hz_organization_profiles.IMPORT_IND%type;
3051: l_DUNS_NUMBER_C hz_organization_profiles.DUNS_NUMBER_C%type;

Line 3048: l_SIC_CODE_TYPE hz_organization_profiles.SIC_CODE_TYPE%type;

3044: l_HQ_BRANCH_IND hz_organization_profiles.HQ_BRANCH_IND%type;
3045: l_BRANCH_FLAG hz_organization_profiles.BRANCH_FLAG%type;
3046: l_LOCAL_ACTIVITY_CODE_TYPE hz_organization_profiles.LOCAL_ACTIVITY_CODE_TYPE%type;
3047: l_LOCAL_ACTIVITY_CODE hz_organization_profiles.LOCAL_ACTIVITY_CODE%type;
3048: l_SIC_CODE_TYPE hz_organization_profiles.SIC_CODE_TYPE%type;
3049: l_GLOBAL_FAILURE_SCORE hz_organization_profiles.GLOBAL_FAILURE_SCORE%type;
3050: l_IMPORT_IND hz_organization_profiles.IMPORT_IND%type;
3051: l_DUNS_NUMBER_C hz_organization_profiles.DUNS_NUMBER_C%type;
3052: l_PARENT_SUB_IND hz_organization_profiles.PARENT_SUB_IND%type;

Line 3049: l_GLOBAL_FAILURE_SCORE hz_organization_profiles.GLOBAL_FAILURE_SCORE%type;

3045: l_BRANCH_FLAG hz_organization_profiles.BRANCH_FLAG%type;
3046: l_LOCAL_ACTIVITY_CODE_TYPE hz_organization_profiles.LOCAL_ACTIVITY_CODE_TYPE%type;
3047: l_LOCAL_ACTIVITY_CODE hz_organization_profiles.LOCAL_ACTIVITY_CODE%type;
3048: l_SIC_CODE_TYPE hz_organization_profiles.SIC_CODE_TYPE%type;
3049: l_GLOBAL_FAILURE_SCORE hz_organization_profiles.GLOBAL_FAILURE_SCORE%type;
3050: l_IMPORT_IND hz_organization_profiles.IMPORT_IND%type;
3051: l_DUNS_NUMBER_C hz_organization_profiles.DUNS_NUMBER_C%type;
3052: l_PARENT_SUB_IND hz_organization_profiles.PARENT_SUB_IND%type;
3053: l_FAILURE_SCORE hz_organization_profiles.FAILURE_SCORE%type;

Line 3050: l_IMPORT_IND hz_organization_profiles.IMPORT_IND%type;

3046: l_LOCAL_ACTIVITY_CODE_TYPE hz_organization_profiles.LOCAL_ACTIVITY_CODE_TYPE%type;
3047: l_LOCAL_ACTIVITY_CODE hz_organization_profiles.LOCAL_ACTIVITY_CODE%type;
3048: l_SIC_CODE_TYPE hz_organization_profiles.SIC_CODE_TYPE%type;
3049: l_GLOBAL_FAILURE_SCORE hz_organization_profiles.GLOBAL_FAILURE_SCORE%type;
3050: l_IMPORT_IND hz_organization_profiles.IMPORT_IND%type;
3051: l_DUNS_NUMBER_C hz_organization_profiles.DUNS_NUMBER_C%type;
3052: l_PARENT_SUB_IND hz_organization_profiles.PARENT_SUB_IND%type;
3053: l_FAILURE_SCORE hz_organization_profiles.FAILURE_SCORE%type;
3054: l_FAILURE_SCORE_COMMENTARY hz_organization_profiles.FAILURE_SCORE_COMMENTARY%type;

Line 3051: l_DUNS_NUMBER_C hz_organization_profiles.DUNS_NUMBER_C%type;

3047: l_LOCAL_ACTIVITY_CODE hz_organization_profiles.LOCAL_ACTIVITY_CODE%type;
3048: l_SIC_CODE_TYPE hz_organization_profiles.SIC_CODE_TYPE%type;
3049: l_GLOBAL_FAILURE_SCORE hz_organization_profiles.GLOBAL_FAILURE_SCORE%type;
3050: l_IMPORT_IND hz_organization_profiles.IMPORT_IND%type;
3051: l_DUNS_NUMBER_C hz_organization_profiles.DUNS_NUMBER_C%type;
3052: l_PARENT_SUB_IND hz_organization_profiles.PARENT_SUB_IND%type;
3053: l_FAILURE_SCORE hz_organization_profiles.FAILURE_SCORE%type;
3054: l_FAILURE_SCORE_COMMENTARY hz_organization_profiles.FAILURE_SCORE_COMMENTARY%type;
3055: l_TOTAL_EMP_EST_IND hz_organization_profiles.TOTAL_EMP_EST_IND%type;

Line 3052: l_PARENT_SUB_IND hz_organization_profiles.PARENT_SUB_IND%type;

3048: l_SIC_CODE_TYPE hz_organization_profiles.SIC_CODE_TYPE%type;
3049: l_GLOBAL_FAILURE_SCORE hz_organization_profiles.GLOBAL_FAILURE_SCORE%type;
3050: l_IMPORT_IND hz_organization_profiles.IMPORT_IND%type;
3051: l_DUNS_NUMBER_C hz_organization_profiles.DUNS_NUMBER_C%type;
3052: l_PARENT_SUB_IND hz_organization_profiles.PARENT_SUB_IND%type;
3053: l_FAILURE_SCORE hz_organization_profiles.FAILURE_SCORE%type;
3054: l_FAILURE_SCORE_COMMENTARY hz_organization_profiles.FAILURE_SCORE_COMMENTARY%type;
3055: l_TOTAL_EMP_EST_IND hz_organization_profiles.TOTAL_EMP_EST_IND%type;
3056:

Line 3053: l_FAILURE_SCORE hz_organization_profiles.FAILURE_SCORE%type;

3049: l_GLOBAL_FAILURE_SCORE hz_organization_profiles.GLOBAL_FAILURE_SCORE%type;
3050: l_IMPORT_IND hz_organization_profiles.IMPORT_IND%type;
3051: l_DUNS_NUMBER_C hz_organization_profiles.DUNS_NUMBER_C%type;
3052: l_PARENT_SUB_IND hz_organization_profiles.PARENT_SUB_IND%type;
3053: l_FAILURE_SCORE hz_organization_profiles.FAILURE_SCORE%type;
3054: l_FAILURE_SCORE_COMMENTARY hz_organization_profiles.FAILURE_SCORE_COMMENTARY%type;
3055: l_TOTAL_EMP_EST_IND hz_organization_profiles.TOTAL_EMP_EST_IND%type;
3056:
3057: l_PAYDEX_SCORE Number;

Line 3054: l_FAILURE_SCORE_COMMENTARY hz_organization_profiles.FAILURE_SCORE_COMMENTARY%type;

3050: l_IMPORT_IND hz_organization_profiles.IMPORT_IND%type;
3051: l_DUNS_NUMBER_C hz_organization_profiles.DUNS_NUMBER_C%type;
3052: l_PARENT_SUB_IND hz_organization_profiles.PARENT_SUB_IND%type;
3053: l_FAILURE_SCORE hz_organization_profiles.FAILURE_SCORE%type;
3054: l_FAILURE_SCORE_COMMENTARY hz_organization_profiles.FAILURE_SCORE_COMMENTARY%type;
3055: l_TOTAL_EMP_EST_IND hz_organization_profiles.TOTAL_EMP_EST_IND%type;
3056:
3057: l_PAYDEX_SCORE Number;
3058: l_PAYDEX_THREE_MONTHS_AGO Number;

Line 3055: l_TOTAL_EMP_EST_IND hz_organization_profiles.TOTAL_EMP_EST_IND%type;

3051: l_DUNS_NUMBER_C hz_organization_profiles.DUNS_NUMBER_C%type;
3052: l_PARENT_SUB_IND hz_organization_profiles.PARENT_SUB_IND%type;
3053: l_FAILURE_SCORE hz_organization_profiles.FAILURE_SCORE%type;
3054: l_FAILURE_SCORE_COMMENTARY hz_organization_profiles.FAILURE_SCORE_COMMENTARY%type;
3055: l_TOTAL_EMP_EST_IND hz_organization_profiles.TOTAL_EMP_EST_IND%type;
3056:
3057: l_PAYDEX_SCORE Number;
3058: l_PAYDEX_THREE_MONTHS_AGO Number;
3059: l_AVG_HIGH_CREDIT HZ_CREDIT_RATINGS.AVG_HIGH_CREDIT%type;

Line 3174: FROM hz_organization_profiles

3170: PARENT_SUB_IND,
3171: FAILURE_SCORE,
3172: FAILURE_SCORE_COMMENTARY
3173:
3174: FROM hz_organization_profiles
3175: WHERE organization_profile_id = p_org_profile_id;
3176:
3177: CURSOR cCrRatings IS
3178: SELECT decode(PAYDEX_SCORE,'UN', null, paydex_score ) paydex_score,

Line 4259: l_organization_profile_id hz_organization_profiles.organization_profile_id%TYPE;

4255: p_mode IN VARCHAR2 default 'CREATE',
4256: p_resultout OUT nocopy VARCHAR2,
4257: p_error_msg OUT nocopy VARCHAR2) IS
4258:
4259: l_organization_profile_id hz_organization_profiles.organization_profile_id%TYPE;
4260: l_location_id hz_locations.location_id%TYPE;
4261: l_contact_point_id hz_contact_points.contact_point_id%TYPE;
4262: l_relationship_id hz_relationships.relationship_id%TYPE;
4263: l_report_type hz_financial_reports.type_of_financial_report%TYPE := 'BALANCE_SHEET';

Line 4361: FROM HZ_ORGANIZATION_PROFILES

4357:
4358: BEGIN
4359: SELECT ORGANIZATION_PROFILE_ID
4360: INTO l_organization_profile_id
4361: FROM HZ_ORGANIZATION_PROFILES
4362: WHERE party_id = p_party_id
4363: AND effective_end_date IS NULL
4364: AND ACTUAL_CONTENT_SOURCE = 'DNB';
4365:

Line 4368: p_source_table_name => 'HZ_ORGANIZATION_PROFILES',

4364: AND ACTUAL_CONTENT_SOURCE = 'DNB';
4365:
4366: populate_dnb_data(
4367: p_case_folder_id => p_case_folder_id,
4368: p_source_table_name => 'HZ_ORGANIZATION_PROFILES',
4369: p_source_key => l_organization_profile_id,
4370: p_source_key_column_name => 'ORGANIZATION_PROFILE_ID',
4371: p_mode => p_mode);
4372: EXCEPTION

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

4373: WHEN NO_DATA_FOUND THEN
4374: NULL;
4375: WHEN OTHERS THEN
4376: p_resultout := 1;
4377: p_error_msg := 'SqlError While retrieving Data from HZ_ORGANIZATION_PROFILES '||sqlerrm;
4378: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);
4379: return;
4380: END;
4381: -- Get location id