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.HZ_REGISTRY_VALIDATE_V2PUB dependencies on HZ_FINANCIAL_REPORTS

Line 15757: FROM hz_financial_reports hfr

15753: ) IS
15754:
15755: CURSOR c_dup_financial_report_id (p_financial_report_id IN NUMBER) IS
15756: SELECT 'Y'
15757: FROM hz_financial_reports hfr
15758: WHERE hfr.financial_report_id = p_financial_report_id;
15759:
15760: CURSOR c_unique_financial_report_rec ( p_party_id IN NUMBER,
15761: p_type_of_financial_report IN VARCHAR2,

Line 15769: FROM hz_financial_reports

15765: p_report_start_date IN DATE,
15766: p_report_end_date IN DATE,
15767: p_actual_content_source IN VARCHAR2) IS
15768: SELECT 'Y'
15769: FROM hz_financial_reports
15770: WHERE party_id = p_party_id
15771: AND nvl(type_of_financial_report, 'XXX') = nvl(p_type_of_financial_report, 'XXX')
15772: AND nvl(document_reference, 'XXX') = nvl(p_document_reference, 'XXX')
15773: AND actual_content_source = nvl(p_actual_content_source,'USER_ENTERED')

Line 15790: l_financial_report_id hz_financial_reports.financial_report_id%TYPE;

15786: FROM hz_parties hp
15787: WHERE hp.party_id = p_financial_report_rec.party_id;
15788:
15789: l_party_type VARCHAR2(30);
15790: l_financial_report_id hz_financial_reports.financial_report_id%TYPE;
15791: l_document_reference hz_financial_reports.document_reference%TYPE;
15792: l_date_report_issued hz_financial_reports.date_report_issued%TYPE;
15793: l_issued_period hz_financial_reports.issued_period%TYPE;
15794: l_party_id hz_financial_reports.party_id%TYPE;

Line 15791: l_document_reference hz_financial_reports.document_reference%TYPE;

15787: WHERE hp.party_id = p_financial_report_rec.party_id;
15788:
15789: l_party_type VARCHAR2(30);
15790: l_financial_report_id hz_financial_reports.financial_report_id%TYPE;
15791: l_document_reference hz_financial_reports.document_reference%TYPE;
15792: l_date_report_issued hz_financial_reports.date_report_issued%TYPE;
15793: l_issued_period hz_financial_reports.issued_period%TYPE;
15794: l_party_id hz_financial_reports.party_id%TYPE;
15795: -- l_requiring_authority hz_financial_reports.requiring_authority%TYPE;

Line 15792: l_date_report_issued hz_financial_reports.date_report_issued%TYPE;

15788:
15789: l_party_type VARCHAR2(30);
15790: l_financial_report_id hz_financial_reports.financial_report_id%TYPE;
15791: l_document_reference hz_financial_reports.document_reference%TYPE;
15792: l_date_report_issued hz_financial_reports.date_report_issued%TYPE;
15793: l_issued_period hz_financial_reports.issued_period%TYPE;
15794: l_party_id hz_financial_reports.party_id%TYPE;
15795: -- l_requiring_authority hz_financial_reports.requiring_authority%TYPE;
15796: l_type_of_financial_report hz_financial_reports.type_of_financial_report%TYPE;

Line 15793: l_issued_period hz_financial_reports.issued_period%TYPE;

15789: l_party_type VARCHAR2(30);
15790: l_financial_report_id hz_financial_reports.financial_report_id%TYPE;
15791: l_document_reference hz_financial_reports.document_reference%TYPE;
15792: l_date_report_issued hz_financial_reports.date_report_issued%TYPE;
15793: l_issued_period hz_financial_reports.issued_period%TYPE;
15794: l_party_id hz_financial_reports.party_id%TYPE;
15795: -- l_requiring_authority hz_financial_reports.requiring_authority%TYPE;
15796: l_type_of_financial_report hz_financial_reports.type_of_financial_report%TYPE;
15797: l_report_start_date hz_financial_reports.report_start_date%TYPE;

Line 15794: l_party_id hz_financial_reports.party_id%TYPE;

15790: l_financial_report_id hz_financial_reports.financial_report_id%TYPE;
15791: l_document_reference hz_financial_reports.document_reference%TYPE;
15792: l_date_report_issued hz_financial_reports.date_report_issued%TYPE;
15793: l_issued_period hz_financial_reports.issued_period%TYPE;
15794: l_party_id hz_financial_reports.party_id%TYPE;
15795: -- l_requiring_authority hz_financial_reports.requiring_authority%TYPE;
15796: l_type_of_financial_report hz_financial_reports.type_of_financial_report%TYPE;
15797: l_report_start_date hz_financial_reports.report_start_date%TYPE;
15798: l_report_end_date hz_financial_reports.report_end_date%TYPE;

Line 15795: -- l_requiring_authority hz_financial_reports.requiring_authority%TYPE;

15791: l_document_reference hz_financial_reports.document_reference%TYPE;
15792: l_date_report_issued hz_financial_reports.date_report_issued%TYPE;
15793: l_issued_period hz_financial_reports.issued_period%TYPE;
15794: l_party_id hz_financial_reports.party_id%TYPE;
15795: -- l_requiring_authority hz_financial_reports.requiring_authority%TYPE;
15796: l_type_of_financial_report hz_financial_reports.type_of_financial_report%TYPE;
15797: l_report_start_date hz_financial_reports.report_start_date%TYPE;
15798: l_report_end_date hz_financial_reports.report_end_date%TYPE;
15799: -- l_audit_ind hz_financial_reports.audit_ind%TYPE;

Line 15796: l_type_of_financial_report hz_financial_reports.type_of_financial_report%TYPE;

15792: l_date_report_issued hz_financial_reports.date_report_issued%TYPE;
15793: l_issued_period hz_financial_reports.issued_period%TYPE;
15794: l_party_id hz_financial_reports.party_id%TYPE;
15795: -- l_requiring_authority hz_financial_reports.requiring_authority%TYPE;
15796: l_type_of_financial_report hz_financial_reports.type_of_financial_report%TYPE;
15797: l_report_start_date hz_financial_reports.report_start_date%TYPE;
15798: l_report_end_date hz_financial_reports.report_end_date%TYPE;
15799: -- l_audit_ind hz_financial_reports.audit_ind%TYPE;
15800: -- l_consolidated_ind hz_financial_reports.consolidated_ind%TYPE;

Line 15797: l_report_start_date hz_financial_reports.report_start_date%TYPE;

15793: l_issued_period hz_financial_reports.issued_period%TYPE;
15794: l_party_id hz_financial_reports.party_id%TYPE;
15795: -- l_requiring_authority hz_financial_reports.requiring_authority%TYPE;
15796: l_type_of_financial_report hz_financial_reports.type_of_financial_report%TYPE;
15797: l_report_start_date hz_financial_reports.report_start_date%TYPE;
15798: l_report_end_date hz_financial_reports.report_end_date%TYPE;
15799: -- l_audit_ind hz_financial_reports.audit_ind%TYPE;
15800: -- l_consolidated_ind hz_financial_reports.consolidated_ind%TYPE;
15801: -- l_estimated_ind hz_financial_reports.estimated_ind%TYPE;

Line 15798: l_report_end_date hz_financial_reports.report_end_date%TYPE;

15794: l_party_id hz_financial_reports.party_id%TYPE;
15795: -- l_requiring_authority hz_financial_reports.requiring_authority%TYPE;
15796: l_type_of_financial_report hz_financial_reports.type_of_financial_report%TYPE;
15797: l_report_start_date hz_financial_reports.report_start_date%TYPE;
15798: l_report_end_date hz_financial_reports.report_end_date%TYPE;
15799: -- l_audit_ind hz_financial_reports.audit_ind%TYPE;
15800: -- l_consolidated_ind hz_financial_reports.consolidated_ind%TYPE;
15801: -- l_estimated_ind hz_financial_reports.estimated_ind%TYPE;
15802: -- l_fiscal_ind hz_financial_reports.fiscal_ind%TYPE;

Line 15799: -- l_audit_ind hz_financial_reports.audit_ind%TYPE;

15795: -- l_requiring_authority hz_financial_reports.requiring_authority%TYPE;
15796: l_type_of_financial_report hz_financial_reports.type_of_financial_report%TYPE;
15797: l_report_start_date hz_financial_reports.report_start_date%TYPE;
15798: l_report_end_date hz_financial_reports.report_end_date%TYPE;
15799: -- l_audit_ind hz_financial_reports.audit_ind%TYPE;
15800: -- l_consolidated_ind hz_financial_reports.consolidated_ind%TYPE;
15801: -- l_estimated_ind hz_financial_reports.estimated_ind%TYPE;
15802: -- l_fiscal_ind hz_financial_reports.fiscal_ind%TYPE;
15803: -- l_final_ind hz_financial_reports.final_ind%TYPE;

Line 15800: -- l_consolidated_ind hz_financial_reports.consolidated_ind%TYPE;

15796: l_type_of_financial_report hz_financial_reports.type_of_financial_report%TYPE;
15797: l_report_start_date hz_financial_reports.report_start_date%TYPE;
15798: l_report_end_date hz_financial_reports.report_end_date%TYPE;
15799: -- l_audit_ind hz_financial_reports.audit_ind%TYPE;
15800: -- l_consolidated_ind hz_financial_reports.consolidated_ind%TYPE;
15801: -- l_estimated_ind hz_financial_reports.estimated_ind%TYPE;
15802: -- l_fiscal_ind hz_financial_reports.fiscal_ind%TYPE;
15803: -- l_final_ind hz_financial_reports.final_ind%TYPE;
15804: -- l_forecast_ind hz_financial_reports.forecast_ind%TYPE;

Line 15801: -- l_estimated_ind hz_financial_reports.estimated_ind%TYPE;

15797: l_report_start_date hz_financial_reports.report_start_date%TYPE;
15798: l_report_end_date hz_financial_reports.report_end_date%TYPE;
15799: -- l_audit_ind hz_financial_reports.audit_ind%TYPE;
15800: -- l_consolidated_ind hz_financial_reports.consolidated_ind%TYPE;
15801: -- l_estimated_ind hz_financial_reports.estimated_ind%TYPE;
15802: -- l_fiscal_ind hz_financial_reports.fiscal_ind%TYPE;
15803: -- l_final_ind hz_financial_reports.final_ind%TYPE;
15804: -- l_forecast_ind hz_financial_reports.forecast_ind%TYPE;
15805: -- l_opening_ind hz_financial_reports.opening_ind%TYPE;

Line 15802: -- l_fiscal_ind hz_financial_reports.fiscal_ind%TYPE;

15798: l_report_end_date hz_financial_reports.report_end_date%TYPE;
15799: -- l_audit_ind hz_financial_reports.audit_ind%TYPE;
15800: -- l_consolidated_ind hz_financial_reports.consolidated_ind%TYPE;
15801: -- l_estimated_ind hz_financial_reports.estimated_ind%TYPE;
15802: -- l_fiscal_ind hz_financial_reports.fiscal_ind%TYPE;
15803: -- l_final_ind hz_financial_reports.final_ind%TYPE;
15804: -- l_forecast_ind hz_financial_reports.forecast_ind%TYPE;
15805: -- l_opening_ind hz_financial_reports.opening_ind%TYPE;
15806: -- l_proforma_ind hz_financial_reports.proforma_ind%TYPE;

Line 15803: -- l_final_ind hz_financial_reports.final_ind%TYPE;

15799: -- l_audit_ind hz_financial_reports.audit_ind%TYPE;
15800: -- l_consolidated_ind hz_financial_reports.consolidated_ind%TYPE;
15801: -- l_estimated_ind hz_financial_reports.estimated_ind%TYPE;
15802: -- l_fiscal_ind hz_financial_reports.fiscal_ind%TYPE;
15803: -- l_final_ind hz_financial_reports.final_ind%TYPE;
15804: -- l_forecast_ind hz_financial_reports.forecast_ind%TYPE;
15805: -- l_opening_ind hz_financial_reports.opening_ind%TYPE;
15806: -- l_proforma_ind hz_financial_reports.proforma_ind%TYPE;
15807: -- l_qualified_ind hz_financial_reports.qualified_ind%TYPE;

Line 15804: -- l_forecast_ind hz_financial_reports.forecast_ind%TYPE;

15800: -- l_consolidated_ind hz_financial_reports.consolidated_ind%TYPE;
15801: -- l_estimated_ind hz_financial_reports.estimated_ind%TYPE;
15802: -- l_fiscal_ind hz_financial_reports.fiscal_ind%TYPE;
15803: -- l_final_ind hz_financial_reports.final_ind%TYPE;
15804: -- l_forecast_ind hz_financial_reports.forecast_ind%TYPE;
15805: -- l_opening_ind hz_financial_reports.opening_ind%TYPE;
15806: -- l_proforma_ind hz_financial_reports.proforma_ind%TYPE;
15807: -- l_qualified_ind hz_financial_reports.qualified_ind%TYPE;
15808: -- l_restated_ind hz_financial_reports.restated_ind%TYPE;

Line 15805: -- l_opening_ind hz_financial_reports.opening_ind%TYPE;

15801: -- l_estimated_ind hz_financial_reports.estimated_ind%TYPE;
15802: -- l_fiscal_ind hz_financial_reports.fiscal_ind%TYPE;
15803: -- l_final_ind hz_financial_reports.final_ind%TYPE;
15804: -- l_forecast_ind hz_financial_reports.forecast_ind%TYPE;
15805: -- l_opening_ind hz_financial_reports.opening_ind%TYPE;
15806: -- l_proforma_ind hz_financial_reports.proforma_ind%TYPE;
15807: -- l_qualified_ind hz_financial_reports.qualified_ind%TYPE;
15808: -- l_restated_ind hz_financial_reports.restated_ind%TYPE;
15809: -- l_signed_by_principals_ind hz_financial_reports.signed_by_principals_ind%TYPE;

Line 15806: -- l_proforma_ind hz_financial_reports.proforma_ind%TYPE;

15802: -- l_fiscal_ind hz_financial_reports.fiscal_ind%TYPE;
15803: -- l_final_ind hz_financial_reports.final_ind%TYPE;
15804: -- l_forecast_ind hz_financial_reports.forecast_ind%TYPE;
15805: -- l_opening_ind hz_financial_reports.opening_ind%TYPE;
15806: -- l_proforma_ind hz_financial_reports.proforma_ind%TYPE;
15807: -- l_qualified_ind hz_financial_reports.qualified_ind%TYPE;
15808: -- l_restated_ind hz_financial_reports.restated_ind%TYPE;
15809: -- l_signed_by_principals_ind hz_financial_reports.signed_by_principals_ind%TYPE;
15810: -- l_trial_balance_ind hz_financial_reports.trial_balance_ind%TYPE;

Line 15807: -- l_qualified_ind hz_financial_reports.qualified_ind%TYPE;

15803: -- l_final_ind hz_financial_reports.final_ind%TYPE;
15804: -- l_forecast_ind hz_financial_reports.forecast_ind%TYPE;
15805: -- l_opening_ind hz_financial_reports.opening_ind%TYPE;
15806: -- l_proforma_ind hz_financial_reports.proforma_ind%TYPE;
15807: -- l_qualified_ind hz_financial_reports.qualified_ind%TYPE;
15808: -- l_restated_ind hz_financial_reports.restated_ind%TYPE;
15809: -- l_signed_by_principals_ind hz_financial_reports.signed_by_principals_ind%TYPE;
15810: -- l_trial_balance_ind hz_financial_reports.trial_balance_ind%TYPE;
15811: -- l_unbalanced_ind hz_financial_reports.unbalanced_ind%TYPE;

Line 15808: -- l_restated_ind hz_financial_reports.restated_ind%TYPE;

15804: -- l_forecast_ind hz_financial_reports.forecast_ind%TYPE;
15805: -- l_opening_ind hz_financial_reports.opening_ind%TYPE;
15806: -- l_proforma_ind hz_financial_reports.proforma_ind%TYPE;
15807: -- l_qualified_ind hz_financial_reports.qualified_ind%TYPE;
15808: -- l_restated_ind hz_financial_reports.restated_ind%TYPE;
15809: -- l_signed_by_principals_ind hz_financial_reports.signed_by_principals_ind%TYPE;
15810: -- l_trial_balance_ind hz_financial_reports.trial_balance_ind%TYPE;
15811: -- l_unbalanced_ind hz_financial_reports.unbalanced_ind%TYPE;
15812: l_content_source_type hz_financial_reports.content_source_type%TYPE;

Line 15809: -- l_signed_by_principals_ind hz_financial_reports.signed_by_principals_ind%TYPE;

15805: -- l_opening_ind hz_financial_reports.opening_ind%TYPE;
15806: -- l_proforma_ind hz_financial_reports.proforma_ind%TYPE;
15807: -- l_qualified_ind hz_financial_reports.qualified_ind%TYPE;
15808: -- l_restated_ind hz_financial_reports.restated_ind%TYPE;
15809: -- l_signed_by_principals_ind hz_financial_reports.signed_by_principals_ind%TYPE;
15810: -- l_trial_balance_ind hz_financial_reports.trial_balance_ind%TYPE;
15811: -- l_unbalanced_ind hz_financial_reports.unbalanced_ind%TYPE;
15812: l_content_source_type hz_financial_reports.content_source_type%TYPE;
15813: l_actual_content_source hz_financial_reports.actual_content_source%TYPE;

Line 15810: -- l_trial_balance_ind hz_financial_reports.trial_balance_ind%TYPE;

15806: -- l_proforma_ind hz_financial_reports.proforma_ind%TYPE;
15807: -- l_qualified_ind hz_financial_reports.qualified_ind%TYPE;
15808: -- l_restated_ind hz_financial_reports.restated_ind%TYPE;
15809: -- l_signed_by_principals_ind hz_financial_reports.signed_by_principals_ind%TYPE;
15810: -- l_trial_balance_ind hz_financial_reports.trial_balance_ind%TYPE;
15811: -- l_unbalanced_ind hz_financial_reports.unbalanced_ind%TYPE;
15812: l_content_source_type hz_financial_reports.content_source_type%TYPE;
15813: l_actual_content_source hz_financial_reports.actual_content_source%TYPE;
15814: -- l_request_id hz_financial_reports.request_id%TYPE;

Line 15811: -- l_unbalanced_ind hz_financial_reports.unbalanced_ind%TYPE;

15807: -- l_qualified_ind hz_financial_reports.qualified_ind%TYPE;
15808: -- l_restated_ind hz_financial_reports.restated_ind%TYPE;
15809: -- l_signed_by_principals_ind hz_financial_reports.signed_by_principals_ind%TYPE;
15810: -- l_trial_balance_ind hz_financial_reports.trial_balance_ind%TYPE;
15811: -- l_unbalanced_ind hz_financial_reports.unbalanced_ind%TYPE;
15812: l_content_source_type hz_financial_reports.content_source_type%TYPE;
15813: l_actual_content_source hz_financial_reports.actual_content_source%TYPE;
15814: -- l_request_id hz_financial_reports.request_id%TYPE;
15815: l_status hz_financial_reports.status%TYPE;

Line 15812: l_content_source_type hz_financial_reports.content_source_type%TYPE;

15808: -- l_restated_ind hz_financial_reports.restated_ind%TYPE;
15809: -- l_signed_by_principals_ind hz_financial_reports.signed_by_principals_ind%TYPE;
15810: -- l_trial_balance_ind hz_financial_reports.trial_balance_ind%TYPE;
15811: -- l_unbalanced_ind hz_financial_reports.unbalanced_ind%TYPE;
15812: l_content_source_type hz_financial_reports.content_source_type%TYPE;
15813: l_actual_content_source hz_financial_reports.actual_content_source%TYPE;
15814: -- l_request_id hz_financial_reports.request_id%TYPE;
15815: l_status hz_financial_reports.status%TYPE;
15816: l_created_by_module hz_financial_reports.created_by_module%TYPE;

Line 15813: l_actual_content_source hz_financial_reports.actual_content_source%TYPE;

15809: -- l_signed_by_principals_ind hz_financial_reports.signed_by_principals_ind%TYPE;
15810: -- l_trial_balance_ind hz_financial_reports.trial_balance_ind%TYPE;
15811: -- l_unbalanced_ind hz_financial_reports.unbalanced_ind%TYPE;
15812: l_content_source_type hz_financial_reports.content_source_type%TYPE;
15813: l_actual_content_source hz_financial_reports.actual_content_source%TYPE;
15814: -- l_request_id hz_financial_reports.request_id%TYPE;
15815: l_status hz_financial_reports.status%TYPE;
15816: l_created_by_module hz_financial_reports.created_by_module%TYPE;
15817:

Line 15814: -- l_request_id hz_financial_reports.request_id%TYPE;

15810: -- l_trial_balance_ind hz_financial_reports.trial_balance_ind%TYPE;
15811: -- l_unbalanced_ind hz_financial_reports.unbalanced_ind%TYPE;
15812: l_content_source_type hz_financial_reports.content_source_type%TYPE;
15813: l_actual_content_source hz_financial_reports.actual_content_source%TYPE;
15814: -- l_request_id hz_financial_reports.request_id%TYPE;
15815: l_status hz_financial_reports.status%TYPE;
15816: l_created_by_module hz_financial_reports.created_by_module%TYPE;
15817:
15818: -- l_temp_issued_period hz_financial_reports.issued_period%TYPE;

Line 15815: l_status hz_financial_reports.status%TYPE;

15811: -- l_unbalanced_ind hz_financial_reports.unbalanced_ind%TYPE;
15812: l_content_source_type hz_financial_reports.content_source_type%TYPE;
15813: l_actual_content_source hz_financial_reports.actual_content_source%TYPE;
15814: -- l_request_id hz_financial_reports.request_id%TYPE;
15815: l_status hz_financial_reports.status%TYPE;
15816: l_created_by_module hz_financial_reports.created_by_module%TYPE;
15817:
15818: -- l_temp_issued_period hz_financial_reports.issued_period%TYPE;
15819: -- l_temp_report_start_date hz_financial_reports.report_start_date%TYPE;

Line 15816: l_created_by_module hz_financial_reports.created_by_module%TYPE;

15812: l_content_source_type hz_financial_reports.content_source_type%TYPE;
15813: l_actual_content_source hz_financial_reports.actual_content_source%TYPE;
15814: -- l_request_id hz_financial_reports.request_id%TYPE;
15815: l_status hz_financial_reports.status%TYPE;
15816: l_created_by_module hz_financial_reports.created_by_module%TYPE;
15817:
15818: -- l_temp_issued_period hz_financial_reports.issued_period%TYPE;
15819: -- l_temp_report_start_date hz_financial_reports.report_start_date%TYPE;
15820: -- l_temp_report_end_date hz_financial_reports.report_end_date%TYPE;

Line 15818: -- l_temp_issued_period hz_financial_reports.issued_period%TYPE;

15814: -- l_request_id hz_financial_reports.request_id%TYPE;
15815: l_status hz_financial_reports.status%TYPE;
15816: l_created_by_module hz_financial_reports.created_by_module%TYPE;
15817:
15818: -- l_temp_issued_period hz_financial_reports.issued_period%TYPE;
15819: -- l_temp_report_start_date hz_financial_reports.report_start_date%TYPE;
15820: -- l_temp_report_end_date hz_financial_reports.report_end_date%TYPE;
15821: l_dummy VARCHAR2(1);
15822: l_debug_prefix VARCHAR2(30) := '';

Line 15819: -- l_temp_report_start_date hz_financial_reports.report_start_date%TYPE;

15815: l_status hz_financial_reports.status%TYPE;
15816: l_created_by_module hz_financial_reports.created_by_module%TYPE;
15817:
15818: -- l_temp_issued_period hz_financial_reports.issued_period%TYPE;
15819: -- l_temp_report_start_date hz_financial_reports.report_start_date%TYPE;
15820: -- l_temp_report_end_date hz_financial_reports.report_end_date%TYPE;
15821: l_dummy VARCHAR2(1);
15822: l_debug_prefix VARCHAR2(30) := '';
15823:

Line 15820: -- l_temp_report_end_date hz_financial_reports.report_end_date%TYPE;

15816: l_created_by_module hz_financial_reports.created_by_module%TYPE;
15817:
15818: -- l_temp_issued_period hz_financial_reports.issued_period%TYPE;
15819: -- l_temp_report_start_date hz_financial_reports.report_start_date%TYPE;
15820: -- l_temp_report_end_date hz_financial_reports.report_end_date%TYPE;
15821: l_dummy VARCHAR2(1);
15822: l_debug_prefix VARCHAR2(30) := '';
15823:
15824: BEGIN

Line 15900: FROM HZ_FINANCIAL_REPORTS

15896: l_actual_content_source,
15897: -- l_request_id,
15898: l_status,
15899: l_created_by_module
15900: FROM HZ_FINANCIAL_REPORTS
15901: WHERE ROWID = p_rowid;
15902: END IF;
15903:
15904: -------------------------------------

Line 16879: p_entity_name => 'HZ_FINANCIAL_REPORTS',

16875: p_content_source_type => 'USER_ENTERED',
16876: p_old_content_source_type => 'USER_ENTERED',
16877: p_actual_content_source => p_financial_report_rec.actual_content_source,
16878: p_old_actual_content_source => l_actual_content_source,
16879: p_entity_name => 'HZ_FINANCIAL_REPORTS',
16880: x_return_status => x_return_status );
16881:
16882: ----------------------------
16883: --validate created_by_module

Line 17068: --Must exist in HZ_FINANCIAL_REPORTS. Non-updateable.

17064: -- validation for financial_report_id
17065: -------------------------------------
17066: /****Logical APIs - validation not required****/
17067: IF(HZ_UTILITY_V2PUB.G_CALLING_API IS NULL) THEN
17068: --Must exist in HZ_FINANCIAL_REPORTS. Non-updateable.
17069: -- financial_report_id has foreign key HZ_FINANCIAL_REPORTS.FINANCIAL_REPORT_ID
17070: IF p_create_update_flag = 'C'
17071: AND
17072: p_financial_number_rec.financial_report_id IS NOT NULL

Line 17069: -- financial_report_id has foreign key HZ_FINANCIAL_REPORTS.FINANCIAL_REPORT_ID

17065: -------------------------------------
17066: /****Logical APIs - validation not required****/
17067: IF(HZ_UTILITY_V2PUB.G_CALLING_API IS NULL) THEN
17068: --Must exist in HZ_FINANCIAL_REPORTS. Non-updateable.
17069: -- financial_report_id has foreign key HZ_FINANCIAL_REPORTS.FINANCIAL_REPORT_ID
17070: IF p_create_update_flag = 'C'
17071: AND
17072: p_financial_number_rec.financial_report_id IS NOT NULL
17073: AND

Line 17077: --bug 3942332: selected actual_content_source from the hz_financial_reports record.

17073: AND
17074: p_financial_number_rec.financial_report_id <> fnd_api.g_miss_num
17075: THEN
17076: BEGIN
17077: --bug 3942332: selected actual_content_source from the hz_financial_reports record.
17078: --SELECT 'Y'
17079: --INTO l_dummy
17080: SELECT actual_content_source
17081: INTO x_actual_content_source

Line 17082: FROM hz_financial_reports hfr

17078: --SELECT 'Y'
17079: --INTO l_dummy
17080: SELECT actual_content_source
17081: INTO x_actual_content_source
17082: FROM hz_financial_reports hfr
17083: WHERE hfr.financial_report_id = p_financial_number_rec.financial_report_id;
17084:
17085: EXCEPTION
17086: WHEN NO_DATA_FOUND THEN

Line 17090: fnd_message.set_token('TABLE', 'hz_financial_reports');

17086: WHEN NO_DATA_FOUND THEN
17087: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
17088: fnd_message.set_token('FK', 'financial_report_id');
17089: fnd_message.set_token('COLUMN', 'financial_report_id');
17090: fnd_message.set_token('TABLE', 'hz_financial_reports');
17091: fnd_msg_pub.add;
17092: x_return_status := fnd_api.g_ret_sts_error;
17093: END;
17094:

Line 17097: 'financial_report_id has foreign key hz_financial_reports.financial_report_id. ' ||

17093: END;
17094:
17095: /*IF g_debug THEN
17096: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
17097: 'financial_report_id has foreign key hz_financial_reports.financial_report_id. ' ||
17098: 'x_return_status = ' || x_return_status, l_debug_prefix);
17099: END IF;
17100: */
17101: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 17103: p_message=>'financial_report_id has foreign key hz_financial_reports.financial_report_id. ' ||

17099: END IF;
17100: */
17101: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
17102: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
17103: p_message=>'financial_report_id has foreign key hz_financial_reports.financial_report_id. ' ||
17104: 'x_return_status = ' || x_return_status,
17105: p_msg_level=>fnd_log.level_statement);
17106: END IF;
17107: