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 2963: FROM hz_financial_reports

2959: QUALIFIED_IND,
2960: OPENING_IND,
2961: PROFORMA_IND,
2962: TRIAL_BALANCE_IND
2963: FROM hz_financial_reports
2964: WHERE financial_report_id = p_financial_report_id;
2965:
2966: l_ESTIMATED_IND hz_financial_reports.ESTIMATED_IND%type;
2967: l_CONSOLIDATED_IND hz_financial_reports.CONSOLIDATED_IND%type;

Line 2966: l_ESTIMATED_IND hz_financial_reports.ESTIMATED_IND%type;

2962: TRIAL_BALANCE_IND
2963: FROM hz_financial_reports
2964: WHERE financial_report_id = p_financial_report_id;
2965:
2966: l_ESTIMATED_IND hz_financial_reports.ESTIMATED_IND%type;
2967: l_CONSOLIDATED_IND hz_financial_reports.CONSOLIDATED_IND%type;
2968: l_REPORT_START_DATE hz_financial_reports.REPORT_START_DATE%type;
2969: l_REPORT_END_DATE hz_financial_reports.REPORT_END_DATE%type;
2970: l_DATE_REPORT_ISSUED hz_financial_reports.DATE_REPORT_ISSUED%type;

Line 2967: l_CONSOLIDATED_IND hz_financial_reports.CONSOLIDATED_IND%type;

2963: FROM hz_financial_reports
2964: WHERE financial_report_id = p_financial_report_id;
2965:
2966: l_ESTIMATED_IND hz_financial_reports.ESTIMATED_IND%type;
2967: l_CONSOLIDATED_IND hz_financial_reports.CONSOLIDATED_IND%type;
2968: l_REPORT_START_DATE hz_financial_reports.REPORT_START_DATE%type;
2969: l_REPORT_END_DATE hz_financial_reports.REPORT_END_DATE%type;
2970: l_DATE_REPORT_ISSUED hz_financial_reports.DATE_REPORT_ISSUED%type;
2971: l_AUDIT_IND hz_financial_reports.AUDIT_IND%type;

Line 2968: l_REPORT_START_DATE hz_financial_reports.REPORT_START_DATE%type;

2964: WHERE financial_report_id = p_financial_report_id;
2965:
2966: l_ESTIMATED_IND hz_financial_reports.ESTIMATED_IND%type;
2967: l_CONSOLIDATED_IND hz_financial_reports.CONSOLIDATED_IND%type;
2968: l_REPORT_START_DATE hz_financial_reports.REPORT_START_DATE%type;
2969: l_REPORT_END_DATE hz_financial_reports.REPORT_END_DATE%type;
2970: l_DATE_REPORT_ISSUED hz_financial_reports.DATE_REPORT_ISSUED%type;
2971: l_AUDIT_IND hz_financial_reports.AUDIT_IND%type;
2972: l_FORECAST_IND hz_financial_reports.FORECAST_IND%type;

Line 2969: l_REPORT_END_DATE hz_financial_reports.REPORT_END_DATE%type;

2965:
2966: l_ESTIMATED_IND hz_financial_reports.ESTIMATED_IND%type;
2967: l_CONSOLIDATED_IND hz_financial_reports.CONSOLIDATED_IND%type;
2968: l_REPORT_START_DATE hz_financial_reports.REPORT_START_DATE%type;
2969: l_REPORT_END_DATE hz_financial_reports.REPORT_END_DATE%type;
2970: l_DATE_REPORT_ISSUED hz_financial_reports.DATE_REPORT_ISSUED%type;
2971: l_AUDIT_IND hz_financial_reports.AUDIT_IND%type;
2972: l_FORECAST_IND hz_financial_reports.FORECAST_IND%type;
2973: l_FISCAL_IND hz_financial_reports.FISCAL_IND%type;

Line 2970: l_DATE_REPORT_ISSUED hz_financial_reports.DATE_REPORT_ISSUED%type;

2966: l_ESTIMATED_IND hz_financial_reports.ESTIMATED_IND%type;
2967: l_CONSOLIDATED_IND hz_financial_reports.CONSOLIDATED_IND%type;
2968: l_REPORT_START_DATE hz_financial_reports.REPORT_START_DATE%type;
2969: l_REPORT_END_DATE hz_financial_reports.REPORT_END_DATE%type;
2970: l_DATE_REPORT_ISSUED hz_financial_reports.DATE_REPORT_ISSUED%type;
2971: l_AUDIT_IND hz_financial_reports.AUDIT_IND%type;
2972: l_FORECAST_IND hz_financial_reports.FORECAST_IND%type;
2973: l_FISCAL_IND hz_financial_reports.FISCAL_IND%type;
2974: l_FINAL_IND hz_financial_reports.FINAL_IND%type;

Line 2971: l_AUDIT_IND hz_financial_reports.AUDIT_IND%type;

2967: l_CONSOLIDATED_IND hz_financial_reports.CONSOLIDATED_IND%type;
2968: l_REPORT_START_DATE hz_financial_reports.REPORT_START_DATE%type;
2969: l_REPORT_END_DATE hz_financial_reports.REPORT_END_DATE%type;
2970: l_DATE_REPORT_ISSUED hz_financial_reports.DATE_REPORT_ISSUED%type;
2971: l_AUDIT_IND hz_financial_reports.AUDIT_IND%type;
2972: l_FORECAST_IND hz_financial_reports.FORECAST_IND%type;
2973: l_FISCAL_IND hz_financial_reports.FISCAL_IND%type;
2974: l_FINAL_IND hz_financial_reports.FINAL_IND%type;
2975: l_SIGNED_BY_PRINCIPALS_IND hz_financial_reports.SIGNED_BY_PRINCIPALS_IND%type;

Line 2972: l_FORECAST_IND hz_financial_reports.FORECAST_IND%type;

2968: l_REPORT_START_DATE hz_financial_reports.REPORT_START_DATE%type;
2969: l_REPORT_END_DATE hz_financial_reports.REPORT_END_DATE%type;
2970: l_DATE_REPORT_ISSUED hz_financial_reports.DATE_REPORT_ISSUED%type;
2971: l_AUDIT_IND hz_financial_reports.AUDIT_IND%type;
2972: l_FORECAST_IND hz_financial_reports.FORECAST_IND%type;
2973: l_FISCAL_IND hz_financial_reports.FISCAL_IND%type;
2974: l_FINAL_IND hz_financial_reports.FINAL_IND%type;
2975: l_SIGNED_BY_PRINCIPALS_IND hz_financial_reports.SIGNED_BY_PRINCIPALS_IND%type;
2976: l_RESTATED_IND hz_financial_reports.RESTATED_IND%type;

Line 2973: l_FISCAL_IND hz_financial_reports.FISCAL_IND%type;

2969: l_REPORT_END_DATE hz_financial_reports.REPORT_END_DATE%type;
2970: l_DATE_REPORT_ISSUED hz_financial_reports.DATE_REPORT_ISSUED%type;
2971: l_AUDIT_IND hz_financial_reports.AUDIT_IND%type;
2972: l_FORECAST_IND hz_financial_reports.FORECAST_IND%type;
2973: l_FISCAL_IND hz_financial_reports.FISCAL_IND%type;
2974: l_FINAL_IND hz_financial_reports.FINAL_IND%type;
2975: l_SIGNED_BY_PRINCIPALS_IND hz_financial_reports.SIGNED_BY_PRINCIPALS_IND%type;
2976: l_RESTATED_IND hz_financial_reports.RESTATED_IND%type;
2977: l_UNBALANCED_IND hz_financial_reports.UNBALANCED_IND%type;

Line 2974: l_FINAL_IND hz_financial_reports.FINAL_IND%type;

2970: l_DATE_REPORT_ISSUED hz_financial_reports.DATE_REPORT_ISSUED%type;
2971: l_AUDIT_IND hz_financial_reports.AUDIT_IND%type;
2972: l_FORECAST_IND hz_financial_reports.FORECAST_IND%type;
2973: l_FISCAL_IND hz_financial_reports.FISCAL_IND%type;
2974: l_FINAL_IND hz_financial_reports.FINAL_IND%type;
2975: l_SIGNED_BY_PRINCIPALS_IND hz_financial_reports.SIGNED_BY_PRINCIPALS_IND%type;
2976: l_RESTATED_IND hz_financial_reports.RESTATED_IND%type;
2977: l_UNBALANCED_IND hz_financial_reports.UNBALANCED_IND%type;
2978: l_QUALIFIED_IND hz_financial_reports.QUALIFIED_IND%type;

Line 2975: l_SIGNED_BY_PRINCIPALS_IND hz_financial_reports.SIGNED_BY_PRINCIPALS_IND%type;

2971: l_AUDIT_IND hz_financial_reports.AUDIT_IND%type;
2972: l_FORECAST_IND hz_financial_reports.FORECAST_IND%type;
2973: l_FISCAL_IND hz_financial_reports.FISCAL_IND%type;
2974: l_FINAL_IND hz_financial_reports.FINAL_IND%type;
2975: l_SIGNED_BY_PRINCIPALS_IND hz_financial_reports.SIGNED_BY_PRINCIPALS_IND%type;
2976: l_RESTATED_IND hz_financial_reports.RESTATED_IND%type;
2977: l_UNBALANCED_IND hz_financial_reports.UNBALANCED_IND%type;
2978: l_QUALIFIED_IND hz_financial_reports.QUALIFIED_IND%type;
2979: l_OPENING_IND hz_financial_reports.OPENING_IND%type;

Line 2976: l_RESTATED_IND hz_financial_reports.RESTATED_IND%type;

2972: l_FORECAST_IND hz_financial_reports.FORECAST_IND%type;
2973: l_FISCAL_IND hz_financial_reports.FISCAL_IND%type;
2974: l_FINAL_IND hz_financial_reports.FINAL_IND%type;
2975: l_SIGNED_BY_PRINCIPALS_IND hz_financial_reports.SIGNED_BY_PRINCIPALS_IND%type;
2976: l_RESTATED_IND hz_financial_reports.RESTATED_IND%type;
2977: l_UNBALANCED_IND hz_financial_reports.UNBALANCED_IND%type;
2978: l_QUALIFIED_IND hz_financial_reports.QUALIFIED_IND%type;
2979: l_OPENING_IND hz_financial_reports.OPENING_IND%type;
2980: l_PROFORMA_IND hz_financial_reports.PROFORMA_IND%type;

Line 2977: l_UNBALANCED_IND hz_financial_reports.UNBALANCED_IND%type;

2973: l_FISCAL_IND hz_financial_reports.FISCAL_IND%type;
2974: l_FINAL_IND hz_financial_reports.FINAL_IND%type;
2975: l_SIGNED_BY_PRINCIPALS_IND hz_financial_reports.SIGNED_BY_PRINCIPALS_IND%type;
2976: l_RESTATED_IND hz_financial_reports.RESTATED_IND%type;
2977: l_UNBALANCED_IND hz_financial_reports.UNBALANCED_IND%type;
2978: l_QUALIFIED_IND hz_financial_reports.QUALIFIED_IND%type;
2979: l_OPENING_IND hz_financial_reports.OPENING_IND%type;
2980: l_PROFORMA_IND hz_financial_reports.PROFORMA_IND%type;
2981: l_TRIAL_BALANCE_IND hz_financial_reports.TRIAL_BALANCE_IND%type;

Line 2978: l_QUALIFIED_IND hz_financial_reports.QUALIFIED_IND%type;

2974: l_FINAL_IND hz_financial_reports.FINAL_IND%type;
2975: l_SIGNED_BY_PRINCIPALS_IND hz_financial_reports.SIGNED_BY_PRINCIPALS_IND%type;
2976: l_RESTATED_IND hz_financial_reports.RESTATED_IND%type;
2977: l_UNBALANCED_IND hz_financial_reports.UNBALANCED_IND%type;
2978: l_QUALIFIED_IND hz_financial_reports.QUALIFIED_IND%type;
2979: l_OPENING_IND hz_financial_reports.OPENING_IND%type;
2980: l_PROFORMA_IND hz_financial_reports.PROFORMA_IND%type;
2981: l_TRIAL_BALANCE_IND hz_financial_reports.TRIAL_BALANCE_IND%type;
2982:

Line 2979: l_OPENING_IND hz_financial_reports.OPENING_IND%type;

2975: l_SIGNED_BY_PRINCIPALS_IND hz_financial_reports.SIGNED_BY_PRINCIPALS_IND%type;
2976: l_RESTATED_IND hz_financial_reports.RESTATED_IND%type;
2977: l_UNBALANCED_IND hz_financial_reports.UNBALANCED_IND%type;
2978: l_QUALIFIED_IND hz_financial_reports.QUALIFIED_IND%type;
2979: l_OPENING_IND hz_financial_reports.OPENING_IND%type;
2980: l_PROFORMA_IND hz_financial_reports.PROFORMA_IND%type;
2981: l_TRIAL_BALANCE_IND hz_financial_reports.TRIAL_BALANCE_IND%type;
2982:
2983: BEGIN

Line 2980: l_PROFORMA_IND hz_financial_reports.PROFORMA_IND%type;

2976: l_RESTATED_IND hz_financial_reports.RESTATED_IND%type;
2977: l_UNBALANCED_IND hz_financial_reports.UNBALANCED_IND%type;
2978: l_QUALIFIED_IND hz_financial_reports.QUALIFIED_IND%type;
2979: l_OPENING_IND hz_financial_reports.OPENING_IND%type;
2980: l_PROFORMA_IND hz_financial_reports.PROFORMA_IND%type;
2981: l_TRIAL_BALANCE_IND hz_financial_reports.TRIAL_BALANCE_IND%type;
2982:
2983: BEGIN
2984: IF pg_wf_debug = 'Y'

Line 2981: l_TRIAL_BALANCE_IND hz_financial_reports.TRIAL_BALANCE_IND%type;

2977: l_UNBALANCED_IND hz_financial_reports.UNBALANCED_IND%type;
2978: l_QUALIFIED_IND hz_financial_reports.QUALIFIED_IND%type;
2979: l_OPENING_IND hz_financial_reports.OPENING_IND%type;
2980: l_PROFORMA_IND hz_financial_reports.PROFORMA_IND%type;
2981: l_TRIAL_BALANCE_IND hz_financial_reports.TRIAL_BALANCE_IND%type;
2982:
2983: BEGIN
2984: IF pg_wf_debug = 'Y'
2985: THEN

Line 3383: WHERE source_table_name = 'HZ_FINANCIAL_REPORTS'

3379: SELECT FINANCIAL_number, financial_number_name
3380: FROM hz_financial_numbers
3381: WHERE financial_report_id in ( SELECT source_key
3382: from ar_cmgt_cf_dnb_dtls
3383: WHERE source_table_name = 'HZ_FINANCIAL_REPORTS'
3384: and case_folder_id = p_case_folder_id);
3385:
3386: CURSOR cGetLocation IS
3387: SELECT COUNTRY

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

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;
4414: l_financial_report_id NUMBER;
4415: l_hq_branch_ind hz_parties.hq_branch_ind%type;
4416: l_balance_sheet_id NUMBER;

Line 4579: p_source_table_name => 'HZ_FINANCIAL_REPORTS',

4575: IF l_financial_report_id IS NOT NULL
4576: THEN
4577: populate_dnb_data(
4578: p_case_folder_id => p_case_folder_id,
4579: p_source_table_name => 'HZ_FINANCIAL_REPORTS',
4580: p_source_key => l_financial_report_id,
4581: p_source_key_column_name => 'FINANCIAL_REPORT_ID',
4582: p_mode => p_mode,
4583: p_source_key_type => 'BALANCE_SHEET',

Line 4595: p_source_table_name => 'HZ_FINANCIAL_REPORTS',

4591: IF l_financial_report_id IS NOT NULL
4592: THEN
4593: populate_dnb_data(
4594: p_case_folder_id => p_case_folder_id,
4595: p_source_table_name => 'HZ_FINANCIAL_REPORTS',
4596: p_source_key => l_financial_report_id,
4597: p_source_key_column_name => 'FINANCIAL_REPORT_ID',
4598: p_mode => p_mode,
4599: p_source_key_type => 'INCOME_STATEMENT',

Line 4612: p_source_table_name => 'HZ_FINANCIAL_REPORTS',

4608: IF l_financial_report_id IS NOT NULL
4609: THEN
4610: populate_dnb_data(
4611: p_case_folder_id => p_case_folder_id,
4612: p_source_table_name => 'HZ_FINANCIAL_REPORTS',
4613: p_source_key => l_financial_report_id,
4614: p_source_key_column_name => 'FINANCIAL_REPORT_ID',
4615: p_mode => p_mode,
4616: p_source_key_type => 'TANGIBLE_NET_WORTH',

Line 4631: p_source_table_name => 'HZ_FINANCIAL_REPORTS',

4627: IF l_financial_report_id IS NOT NULL
4628: THEN
4629: populate_dnb_data(
4630: p_case_folder_id => p_case_folder_id,
4631: p_source_table_name => 'HZ_FINANCIAL_REPORTS',
4632: p_source_key => l_financial_report_id,
4633: p_source_key_column_name => 'FINANCIAL_REPORT_ID',
4634: p_mode => p_mode,
4635: p_source_key_type => 'ANNUAL_SALES_VOLUME',