[Home] [Help]
3101: l_DET_HISTORY_IND HZ_CREDIT_RATINGS.DET_HISTORY_IND%type;
3102: l_OTHER_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OTHER_SPEC_EVNT_IND%type;
3103: l_OPRG_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OPRG_SPEC_EVNT_IND%type;
3104: l_CREDIT_SCORE_COMMENTARY HZ_CREDIT_RATINGS.CREDIT_SCORE_COMMENTARY%type;
3105: l_country hz_locations.country%type;
3106:
3107:
3108: l_cash_liqu_asset NUMBER;
3109: l_ar NUMBER;
3235: and case_folder_id = p_case_folder_id);
3236:
3237: CURSOR cGetLocation IS
3238: SELECT COUNTRY
3239: FROM hz_locations
3240: where location_id = p_location_id;
3241:
3242: BEGIN
3243: IF pg_wf_debug = 'Y'
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';
4264: l_credit_rating_id NUMBER;
4384: THEN
4385:
4386: populate_dnb_data(
4387: p_case_folder_id => p_case_folder_id,
4388: p_source_table_name => 'HZ_LOCATIONS',
4389: p_source_key => l_location_id,
4390: p_source_key_column_name => 'LOCATION_ID',
4391: p_mode => p_mode);
4392: END IF;