[Home] [Help]
3250: l_DET_HISTORY_IND HZ_CREDIT_RATINGS.DET_HISTORY_IND%type;
3251: l_OTHER_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OTHER_SPEC_EVNT_IND%type;
3252: l_OPRG_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OPRG_SPEC_EVNT_IND%type;
3253: l_CREDIT_SCORE_COMMENTARY HZ_CREDIT_RATINGS.CREDIT_SCORE_COMMENTARY%type;
3254: l_country hz_locations.country%type;
3255:
3256:
3257: l_cash_liqu_asset NUMBER;
3258: l_ar NUMBER;
3384: and case_folder_id = p_case_folder_id);
3385:
3386: CURSOR cGetLocation IS
3387: SELECT COUNTRY
3388: FROM hz_locations
3389: where location_id = p_location_id;
3390:
3391: BEGIN
3392: IF pg_wf_debug = 'Y'
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';
4413: l_credit_rating_id NUMBER;
4533: THEN
4534:
4535: populate_dnb_data(
4536: p_case_folder_id => p_case_folder_id,
4537: p_source_table_name => 'HZ_LOCATIONS',
4538: p_source_key => l_location_id,
4539: p_source_key_column_name => 'LOCATION_ID',
4540: p_mode => p_mode);
4541: END IF;