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_FINANCIAL_REPORTS

Line 2814: FROM hz_financial_reports

2810: QUALIFIED_IND,
2811: OPENING_IND,
2812: PROFORMA_IND,
2813: TRIAL_BALANCE_IND
2814: FROM hz_financial_reports
2815: WHERE financial_report_id = p_financial_report_id;
2816:
2817: l_ESTIMATED_IND hz_financial_reports.ESTIMATED_IND%type;
2818: l_CONSOLIDATED_IND hz_financial_reports.CONSOLIDATED_IND%type;

Line 2817: l_ESTIMATED_IND hz_financial_reports.ESTIMATED_IND%type;

2813: TRIAL_BALANCE_IND
2814: FROM hz_financial_reports
2815: WHERE financial_report_id = p_financial_report_id;
2816:
2817: l_ESTIMATED_IND hz_financial_reports.ESTIMATED_IND%type;
2818: l_CONSOLIDATED_IND hz_financial_reports.CONSOLIDATED_IND%type;
2819: l_REPORT_START_DATE hz_financial_reports.REPORT_START_DATE%type;
2820: l_REPORT_END_DATE hz_financial_reports.REPORT_END_DATE%type;
2821: l_DATE_REPORT_ISSUED hz_financial_reports.DATE_REPORT_ISSUED%type;

Line 2818: l_CONSOLIDATED_IND hz_financial_reports.CONSOLIDATED_IND%type;

2814: FROM hz_financial_reports
2815: WHERE financial_report_id = p_financial_report_id;
2816:
2817: l_ESTIMATED_IND hz_financial_reports.ESTIMATED_IND%type;
2818: l_CONSOLIDATED_IND hz_financial_reports.CONSOLIDATED_IND%type;
2819: l_REPORT_START_DATE hz_financial_reports.REPORT_START_DATE%type;
2820: l_REPORT_END_DATE hz_financial_reports.REPORT_END_DATE%type;
2821: l_DATE_REPORT_ISSUED hz_financial_reports.DATE_REPORT_ISSUED%type;
2822: l_AUDIT_IND hz_financial_reports.AUDIT_IND%type;

Line 2819: l_REPORT_START_DATE hz_financial_reports.REPORT_START_DATE%type;

2815: WHERE financial_report_id = p_financial_report_id;
2816:
2817: l_ESTIMATED_IND hz_financial_reports.ESTIMATED_IND%type;
2818: l_CONSOLIDATED_IND hz_financial_reports.CONSOLIDATED_IND%type;
2819: l_REPORT_START_DATE hz_financial_reports.REPORT_START_DATE%type;
2820: l_REPORT_END_DATE hz_financial_reports.REPORT_END_DATE%type;
2821: l_DATE_REPORT_ISSUED hz_financial_reports.DATE_REPORT_ISSUED%type;
2822: l_AUDIT_IND hz_financial_reports.AUDIT_IND%type;
2823: l_FORECAST_IND hz_financial_reports.FORECAST_IND%type;

Line 2820: l_REPORT_END_DATE hz_financial_reports.REPORT_END_DATE%type;

2816:
2817: l_ESTIMATED_IND hz_financial_reports.ESTIMATED_IND%type;
2818: l_CONSOLIDATED_IND hz_financial_reports.CONSOLIDATED_IND%type;
2819: l_REPORT_START_DATE hz_financial_reports.REPORT_START_DATE%type;
2820: l_REPORT_END_DATE hz_financial_reports.REPORT_END_DATE%type;
2821: l_DATE_REPORT_ISSUED hz_financial_reports.DATE_REPORT_ISSUED%type;
2822: l_AUDIT_IND hz_financial_reports.AUDIT_IND%type;
2823: l_FORECAST_IND hz_financial_reports.FORECAST_IND%type;
2824: l_FISCAL_IND hz_financial_reports.FISCAL_IND%type;

Line 2821: l_DATE_REPORT_ISSUED hz_financial_reports.DATE_REPORT_ISSUED%type;

2817: l_ESTIMATED_IND hz_financial_reports.ESTIMATED_IND%type;
2818: l_CONSOLIDATED_IND hz_financial_reports.CONSOLIDATED_IND%type;
2819: l_REPORT_START_DATE hz_financial_reports.REPORT_START_DATE%type;
2820: l_REPORT_END_DATE hz_financial_reports.REPORT_END_DATE%type;
2821: l_DATE_REPORT_ISSUED hz_financial_reports.DATE_REPORT_ISSUED%type;
2822: l_AUDIT_IND hz_financial_reports.AUDIT_IND%type;
2823: l_FORECAST_IND hz_financial_reports.FORECAST_IND%type;
2824: l_FISCAL_IND hz_financial_reports.FISCAL_IND%type;
2825: l_FINAL_IND hz_financial_reports.FINAL_IND%type;

Line 2822: l_AUDIT_IND hz_financial_reports.AUDIT_IND%type;

2818: l_CONSOLIDATED_IND hz_financial_reports.CONSOLIDATED_IND%type;
2819: l_REPORT_START_DATE hz_financial_reports.REPORT_START_DATE%type;
2820: l_REPORT_END_DATE hz_financial_reports.REPORT_END_DATE%type;
2821: l_DATE_REPORT_ISSUED hz_financial_reports.DATE_REPORT_ISSUED%type;
2822: l_AUDIT_IND hz_financial_reports.AUDIT_IND%type;
2823: l_FORECAST_IND hz_financial_reports.FORECAST_IND%type;
2824: l_FISCAL_IND hz_financial_reports.FISCAL_IND%type;
2825: l_FINAL_IND hz_financial_reports.FINAL_IND%type;
2826: l_SIGNED_BY_PRINCIPALS_IND hz_financial_reports.SIGNED_BY_PRINCIPALS_IND%type;

Line 2823: l_FORECAST_IND hz_financial_reports.FORECAST_IND%type;

2819: l_REPORT_START_DATE hz_financial_reports.REPORT_START_DATE%type;
2820: l_REPORT_END_DATE hz_financial_reports.REPORT_END_DATE%type;
2821: l_DATE_REPORT_ISSUED hz_financial_reports.DATE_REPORT_ISSUED%type;
2822: l_AUDIT_IND hz_financial_reports.AUDIT_IND%type;
2823: l_FORECAST_IND hz_financial_reports.FORECAST_IND%type;
2824: l_FISCAL_IND hz_financial_reports.FISCAL_IND%type;
2825: l_FINAL_IND hz_financial_reports.FINAL_IND%type;
2826: l_SIGNED_BY_PRINCIPALS_IND hz_financial_reports.SIGNED_BY_PRINCIPALS_IND%type;
2827: l_RESTATED_IND hz_financial_reports.RESTATED_IND%type;

Line 2824: l_FISCAL_IND hz_financial_reports.FISCAL_IND%type;

2820: l_REPORT_END_DATE hz_financial_reports.REPORT_END_DATE%type;
2821: l_DATE_REPORT_ISSUED hz_financial_reports.DATE_REPORT_ISSUED%type;
2822: l_AUDIT_IND hz_financial_reports.AUDIT_IND%type;
2823: l_FORECAST_IND hz_financial_reports.FORECAST_IND%type;
2824: l_FISCAL_IND hz_financial_reports.FISCAL_IND%type;
2825: l_FINAL_IND hz_financial_reports.FINAL_IND%type;
2826: l_SIGNED_BY_PRINCIPALS_IND hz_financial_reports.SIGNED_BY_PRINCIPALS_IND%type;
2827: l_RESTATED_IND hz_financial_reports.RESTATED_IND%type;
2828: l_UNBALANCED_IND hz_financial_reports.UNBALANCED_IND%type;

Line 2825: l_FINAL_IND hz_financial_reports.FINAL_IND%type;

2821: l_DATE_REPORT_ISSUED hz_financial_reports.DATE_REPORT_ISSUED%type;
2822: l_AUDIT_IND hz_financial_reports.AUDIT_IND%type;
2823: l_FORECAST_IND hz_financial_reports.FORECAST_IND%type;
2824: l_FISCAL_IND hz_financial_reports.FISCAL_IND%type;
2825: l_FINAL_IND hz_financial_reports.FINAL_IND%type;
2826: l_SIGNED_BY_PRINCIPALS_IND hz_financial_reports.SIGNED_BY_PRINCIPALS_IND%type;
2827: l_RESTATED_IND hz_financial_reports.RESTATED_IND%type;
2828: l_UNBALANCED_IND hz_financial_reports.UNBALANCED_IND%type;
2829: l_QUALIFIED_IND hz_financial_reports.QUALIFIED_IND%type;

Line 2826: l_SIGNED_BY_PRINCIPALS_IND hz_financial_reports.SIGNED_BY_PRINCIPALS_IND%type;

2822: l_AUDIT_IND hz_financial_reports.AUDIT_IND%type;
2823: l_FORECAST_IND hz_financial_reports.FORECAST_IND%type;
2824: l_FISCAL_IND hz_financial_reports.FISCAL_IND%type;
2825: l_FINAL_IND hz_financial_reports.FINAL_IND%type;
2826: l_SIGNED_BY_PRINCIPALS_IND hz_financial_reports.SIGNED_BY_PRINCIPALS_IND%type;
2827: l_RESTATED_IND hz_financial_reports.RESTATED_IND%type;
2828: l_UNBALANCED_IND hz_financial_reports.UNBALANCED_IND%type;
2829: l_QUALIFIED_IND hz_financial_reports.QUALIFIED_IND%type;
2830: l_OPENING_IND hz_financial_reports.OPENING_IND%type;

Line 2827: l_RESTATED_IND hz_financial_reports.RESTATED_IND%type;

2823: l_FORECAST_IND hz_financial_reports.FORECAST_IND%type;
2824: l_FISCAL_IND hz_financial_reports.FISCAL_IND%type;
2825: l_FINAL_IND hz_financial_reports.FINAL_IND%type;
2826: l_SIGNED_BY_PRINCIPALS_IND hz_financial_reports.SIGNED_BY_PRINCIPALS_IND%type;
2827: l_RESTATED_IND hz_financial_reports.RESTATED_IND%type;
2828: l_UNBALANCED_IND hz_financial_reports.UNBALANCED_IND%type;
2829: l_QUALIFIED_IND hz_financial_reports.QUALIFIED_IND%type;
2830: l_OPENING_IND hz_financial_reports.OPENING_IND%type;
2831: l_PROFORMA_IND hz_financial_reports.PROFORMA_IND%type;

Line 2828: l_UNBALANCED_IND hz_financial_reports.UNBALANCED_IND%type;

2824: l_FISCAL_IND hz_financial_reports.FISCAL_IND%type;
2825: l_FINAL_IND hz_financial_reports.FINAL_IND%type;
2826: l_SIGNED_BY_PRINCIPALS_IND hz_financial_reports.SIGNED_BY_PRINCIPALS_IND%type;
2827: l_RESTATED_IND hz_financial_reports.RESTATED_IND%type;
2828: l_UNBALANCED_IND hz_financial_reports.UNBALANCED_IND%type;
2829: l_QUALIFIED_IND hz_financial_reports.QUALIFIED_IND%type;
2830: l_OPENING_IND hz_financial_reports.OPENING_IND%type;
2831: l_PROFORMA_IND hz_financial_reports.PROFORMA_IND%type;
2832: l_TRIAL_BALANCE_IND hz_financial_reports.TRIAL_BALANCE_IND%type;

Line 2829: l_QUALIFIED_IND hz_financial_reports.QUALIFIED_IND%type;

2825: l_FINAL_IND hz_financial_reports.FINAL_IND%type;
2826: l_SIGNED_BY_PRINCIPALS_IND hz_financial_reports.SIGNED_BY_PRINCIPALS_IND%type;
2827: l_RESTATED_IND hz_financial_reports.RESTATED_IND%type;
2828: l_UNBALANCED_IND hz_financial_reports.UNBALANCED_IND%type;
2829: l_QUALIFIED_IND hz_financial_reports.QUALIFIED_IND%type;
2830: l_OPENING_IND hz_financial_reports.OPENING_IND%type;
2831: l_PROFORMA_IND hz_financial_reports.PROFORMA_IND%type;
2832: l_TRIAL_BALANCE_IND hz_financial_reports.TRIAL_BALANCE_IND%type;
2833:

Line 2830: l_OPENING_IND hz_financial_reports.OPENING_IND%type;

2826: l_SIGNED_BY_PRINCIPALS_IND hz_financial_reports.SIGNED_BY_PRINCIPALS_IND%type;
2827: l_RESTATED_IND hz_financial_reports.RESTATED_IND%type;
2828: l_UNBALANCED_IND hz_financial_reports.UNBALANCED_IND%type;
2829: l_QUALIFIED_IND hz_financial_reports.QUALIFIED_IND%type;
2830: l_OPENING_IND hz_financial_reports.OPENING_IND%type;
2831: l_PROFORMA_IND hz_financial_reports.PROFORMA_IND%type;
2832: l_TRIAL_BALANCE_IND hz_financial_reports.TRIAL_BALANCE_IND%type;
2833:
2834: BEGIN

Line 2831: l_PROFORMA_IND hz_financial_reports.PROFORMA_IND%type;

2827: l_RESTATED_IND hz_financial_reports.RESTATED_IND%type;
2828: l_UNBALANCED_IND hz_financial_reports.UNBALANCED_IND%type;
2829: l_QUALIFIED_IND hz_financial_reports.QUALIFIED_IND%type;
2830: l_OPENING_IND hz_financial_reports.OPENING_IND%type;
2831: l_PROFORMA_IND hz_financial_reports.PROFORMA_IND%type;
2832: l_TRIAL_BALANCE_IND hz_financial_reports.TRIAL_BALANCE_IND%type;
2833:
2834: BEGIN
2835: IF pg_wf_debug = 'Y'

Line 2832: l_TRIAL_BALANCE_IND hz_financial_reports.TRIAL_BALANCE_IND%type;

2828: l_UNBALANCED_IND hz_financial_reports.UNBALANCED_IND%type;
2829: l_QUALIFIED_IND hz_financial_reports.QUALIFIED_IND%type;
2830: l_OPENING_IND hz_financial_reports.OPENING_IND%type;
2831: l_PROFORMA_IND hz_financial_reports.PROFORMA_IND%type;
2832: l_TRIAL_BALANCE_IND hz_financial_reports.TRIAL_BALANCE_IND%type;
2833:
2834: BEGIN
2835: IF pg_wf_debug = 'Y'
2836: THEN

Line 3234: WHERE source_table_name = 'HZ_FINANCIAL_REPORTS'

3230: SELECT FINANCIAL_number, financial_number_name
3231: FROM hz_financial_numbers
3232: WHERE financial_report_id in ( SELECT source_key
3233: from ar_cmgt_cf_dnb_dtls
3234: WHERE source_table_name = 'HZ_FINANCIAL_REPORTS'
3235: and case_folder_id = p_case_folder_id);
3236:
3237: CURSOR cGetLocation IS
3238: SELECT COUNTRY

Line 4263: l_report_type hz_financial_reports.type_of_financial_report%TYPE := 'BALANCE_SHEET';

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;
4265: l_financial_report_id NUMBER;
4266: l_hq_branch_ind hz_parties.hq_branch_ind%type;
4267: l_balance_sheet_id NUMBER;

Line 4430: p_source_table_name => 'HZ_FINANCIAL_REPORTS',

4426: IF l_financial_report_id IS NOT NULL
4427: THEN
4428: populate_dnb_data(
4429: p_case_folder_id => p_case_folder_id,
4430: p_source_table_name => 'HZ_FINANCIAL_REPORTS',
4431: p_source_key => l_financial_report_id,
4432: p_source_key_column_name => 'FINANCIAL_REPORT_ID',
4433: p_mode => p_mode,
4434: p_source_key_type => 'BALANCE_SHEET',

Line 4446: p_source_table_name => 'HZ_FINANCIAL_REPORTS',

4442: IF l_financial_report_id IS NOT NULL
4443: THEN
4444: populate_dnb_data(
4445: p_case_folder_id => p_case_folder_id,
4446: p_source_table_name => 'HZ_FINANCIAL_REPORTS',
4447: p_source_key => l_financial_report_id,
4448: p_source_key_column_name => 'FINANCIAL_REPORT_ID',
4449: p_mode => p_mode,
4450: p_source_key_type => 'INCOME_STATEMENT',

Line 4463: p_source_table_name => 'HZ_FINANCIAL_REPORTS',

4459: IF l_financial_report_id IS NOT NULL
4460: THEN
4461: populate_dnb_data(
4462: p_case_folder_id => p_case_folder_id,
4463: p_source_table_name => 'HZ_FINANCIAL_REPORTS',
4464: p_source_key => l_financial_report_id,
4465: p_source_key_column_name => 'FINANCIAL_REPORT_ID',
4466: p_mode => p_mode,
4467: p_source_key_type => 'TANGIBLE_NET_WORTH',

Line 4482: p_source_table_name => 'HZ_FINANCIAL_REPORTS',

4478: IF l_financial_report_id IS NOT NULL
4479: THEN
4480: populate_dnb_data(
4481: p_case_folder_id => p_case_folder_id,
4482: p_source_table_name => 'HZ_FINANCIAL_REPORTS',
4483: p_source_key => l_financial_report_id,
4484: p_source_key_column_name => 'FINANCIAL_REPORT_ID',
4485: p_mode => p_mode,
4486: p_source_key_type => 'ANNUAL_SALES_VOLUME',