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 15737: FROM hz_financial_reports hfr

15733: ) IS
15734:
15735: CURSOR c_dup_financial_report_id (p_financial_report_id IN NUMBER) IS
15736: SELECT 'Y'
15737: FROM hz_financial_reports hfr
15738: WHERE hfr.financial_report_id = p_financial_report_id;
15739:
15740: CURSOR c_unique_financial_report_rec ( p_party_id IN NUMBER,
15741: p_type_of_financial_report IN VARCHAR2,

Line 15749: FROM hz_financial_reports

15745: p_report_start_date IN DATE,
15746: p_report_end_date IN DATE,
15747: p_actual_content_source IN VARCHAR2) IS
15748: SELECT 'Y'
15749: FROM hz_financial_reports
15750: WHERE party_id = p_party_id
15751: AND nvl(type_of_financial_report, 'XXX') = nvl(p_type_of_financial_report, 'XXX')
15752: AND nvl(document_reference, 'XXX') = nvl(p_document_reference, 'XXX')
15753: AND actual_content_source = nvl(p_actual_content_source,'USER_ENTERED')

Line 15770: l_financial_report_id hz_financial_reports.financial_report_id%TYPE;

15766: FROM hz_parties hp
15767: WHERE hp.party_id = p_financial_report_rec.party_id;
15768:
15769: l_party_type VARCHAR2(30);
15770: l_financial_report_id hz_financial_reports.financial_report_id%TYPE;
15771: l_document_reference hz_financial_reports.document_reference%TYPE;
15772: l_date_report_issued hz_financial_reports.date_report_issued%TYPE;
15773: l_issued_period hz_financial_reports.issued_period%TYPE;
15774: l_party_id hz_financial_reports.party_id%TYPE;

Line 15771: l_document_reference hz_financial_reports.document_reference%TYPE;

15767: WHERE hp.party_id = p_financial_report_rec.party_id;
15768:
15769: l_party_type VARCHAR2(30);
15770: l_financial_report_id hz_financial_reports.financial_report_id%TYPE;
15771: l_document_reference hz_financial_reports.document_reference%TYPE;
15772: l_date_report_issued hz_financial_reports.date_report_issued%TYPE;
15773: l_issued_period hz_financial_reports.issued_period%TYPE;
15774: l_party_id hz_financial_reports.party_id%TYPE;
15775: -- l_requiring_authority hz_financial_reports.requiring_authority%TYPE;

Line 15772: l_date_report_issued hz_financial_reports.date_report_issued%TYPE;

15768:
15769: l_party_type VARCHAR2(30);
15770: l_financial_report_id hz_financial_reports.financial_report_id%TYPE;
15771: l_document_reference hz_financial_reports.document_reference%TYPE;
15772: l_date_report_issued hz_financial_reports.date_report_issued%TYPE;
15773: l_issued_period hz_financial_reports.issued_period%TYPE;
15774: l_party_id hz_financial_reports.party_id%TYPE;
15775: -- l_requiring_authority hz_financial_reports.requiring_authority%TYPE;
15776: l_type_of_financial_report hz_financial_reports.type_of_financial_report%TYPE;

Line 15773: l_issued_period hz_financial_reports.issued_period%TYPE;

15769: l_party_type VARCHAR2(30);
15770: l_financial_report_id hz_financial_reports.financial_report_id%TYPE;
15771: l_document_reference hz_financial_reports.document_reference%TYPE;
15772: l_date_report_issued hz_financial_reports.date_report_issued%TYPE;
15773: l_issued_period hz_financial_reports.issued_period%TYPE;
15774: l_party_id hz_financial_reports.party_id%TYPE;
15775: -- l_requiring_authority hz_financial_reports.requiring_authority%TYPE;
15776: l_type_of_financial_report hz_financial_reports.type_of_financial_report%TYPE;
15777: l_report_start_date hz_financial_reports.report_start_date%TYPE;

Line 15774: l_party_id hz_financial_reports.party_id%TYPE;

15770: l_financial_report_id hz_financial_reports.financial_report_id%TYPE;
15771: l_document_reference hz_financial_reports.document_reference%TYPE;
15772: l_date_report_issued hz_financial_reports.date_report_issued%TYPE;
15773: l_issued_period hz_financial_reports.issued_period%TYPE;
15774: l_party_id hz_financial_reports.party_id%TYPE;
15775: -- l_requiring_authority hz_financial_reports.requiring_authority%TYPE;
15776: l_type_of_financial_report hz_financial_reports.type_of_financial_report%TYPE;
15777: l_report_start_date hz_financial_reports.report_start_date%TYPE;
15778: l_report_end_date hz_financial_reports.report_end_date%TYPE;

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

15771: l_document_reference hz_financial_reports.document_reference%TYPE;
15772: l_date_report_issued hz_financial_reports.date_report_issued%TYPE;
15773: l_issued_period hz_financial_reports.issued_period%TYPE;
15774: l_party_id hz_financial_reports.party_id%TYPE;
15775: -- l_requiring_authority hz_financial_reports.requiring_authority%TYPE;
15776: l_type_of_financial_report hz_financial_reports.type_of_financial_report%TYPE;
15777: l_report_start_date hz_financial_reports.report_start_date%TYPE;
15778: l_report_end_date hz_financial_reports.report_end_date%TYPE;
15779: -- l_audit_ind hz_financial_reports.audit_ind%TYPE;

Line 15776: l_type_of_financial_report hz_financial_reports.type_of_financial_report%TYPE;

15772: l_date_report_issued hz_financial_reports.date_report_issued%TYPE;
15773: l_issued_period hz_financial_reports.issued_period%TYPE;
15774: l_party_id hz_financial_reports.party_id%TYPE;
15775: -- l_requiring_authority hz_financial_reports.requiring_authority%TYPE;
15776: l_type_of_financial_report hz_financial_reports.type_of_financial_report%TYPE;
15777: l_report_start_date hz_financial_reports.report_start_date%TYPE;
15778: l_report_end_date hz_financial_reports.report_end_date%TYPE;
15779: -- l_audit_ind hz_financial_reports.audit_ind%TYPE;
15780: -- l_consolidated_ind hz_financial_reports.consolidated_ind%TYPE;

Line 15777: l_report_start_date hz_financial_reports.report_start_date%TYPE;

15773: l_issued_period hz_financial_reports.issued_period%TYPE;
15774: l_party_id hz_financial_reports.party_id%TYPE;
15775: -- l_requiring_authority hz_financial_reports.requiring_authority%TYPE;
15776: l_type_of_financial_report hz_financial_reports.type_of_financial_report%TYPE;
15777: l_report_start_date hz_financial_reports.report_start_date%TYPE;
15778: l_report_end_date hz_financial_reports.report_end_date%TYPE;
15779: -- l_audit_ind hz_financial_reports.audit_ind%TYPE;
15780: -- l_consolidated_ind hz_financial_reports.consolidated_ind%TYPE;
15781: -- l_estimated_ind hz_financial_reports.estimated_ind%TYPE;

Line 15778: l_report_end_date hz_financial_reports.report_end_date%TYPE;

15774: l_party_id hz_financial_reports.party_id%TYPE;
15775: -- l_requiring_authority hz_financial_reports.requiring_authority%TYPE;
15776: l_type_of_financial_report hz_financial_reports.type_of_financial_report%TYPE;
15777: l_report_start_date hz_financial_reports.report_start_date%TYPE;
15778: l_report_end_date hz_financial_reports.report_end_date%TYPE;
15779: -- l_audit_ind hz_financial_reports.audit_ind%TYPE;
15780: -- l_consolidated_ind hz_financial_reports.consolidated_ind%TYPE;
15781: -- l_estimated_ind hz_financial_reports.estimated_ind%TYPE;
15782: -- l_fiscal_ind hz_financial_reports.fiscal_ind%TYPE;

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

15775: -- l_requiring_authority hz_financial_reports.requiring_authority%TYPE;
15776: l_type_of_financial_report hz_financial_reports.type_of_financial_report%TYPE;
15777: l_report_start_date hz_financial_reports.report_start_date%TYPE;
15778: l_report_end_date hz_financial_reports.report_end_date%TYPE;
15779: -- l_audit_ind hz_financial_reports.audit_ind%TYPE;
15780: -- l_consolidated_ind hz_financial_reports.consolidated_ind%TYPE;
15781: -- l_estimated_ind hz_financial_reports.estimated_ind%TYPE;
15782: -- l_fiscal_ind hz_financial_reports.fiscal_ind%TYPE;
15783: -- l_final_ind hz_financial_reports.final_ind%TYPE;

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

15776: l_type_of_financial_report hz_financial_reports.type_of_financial_report%TYPE;
15777: l_report_start_date hz_financial_reports.report_start_date%TYPE;
15778: l_report_end_date hz_financial_reports.report_end_date%TYPE;
15779: -- l_audit_ind hz_financial_reports.audit_ind%TYPE;
15780: -- l_consolidated_ind hz_financial_reports.consolidated_ind%TYPE;
15781: -- l_estimated_ind hz_financial_reports.estimated_ind%TYPE;
15782: -- l_fiscal_ind hz_financial_reports.fiscal_ind%TYPE;
15783: -- l_final_ind hz_financial_reports.final_ind%TYPE;
15784: -- l_forecast_ind hz_financial_reports.forecast_ind%TYPE;

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

15777: l_report_start_date hz_financial_reports.report_start_date%TYPE;
15778: l_report_end_date hz_financial_reports.report_end_date%TYPE;
15779: -- l_audit_ind hz_financial_reports.audit_ind%TYPE;
15780: -- l_consolidated_ind hz_financial_reports.consolidated_ind%TYPE;
15781: -- l_estimated_ind hz_financial_reports.estimated_ind%TYPE;
15782: -- l_fiscal_ind hz_financial_reports.fiscal_ind%TYPE;
15783: -- l_final_ind hz_financial_reports.final_ind%TYPE;
15784: -- l_forecast_ind hz_financial_reports.forecast_ind%TYPE;
15785: -- l_opening_ind hz_financial_reports.opening_ind%TYPE;

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

15778: l_report_end_date hz_financial_reports.report_end_date%TYPE;
15779: -- l_audit_ind hz_financial_reports.audit_ind%TYPE;
15780: -- l_consolidated_ind hz_financial_reports.consolidated_ind%TYPE;
15781: -- l_estimated_ind hz_financial_reports.estimated_ind%TYPE;
15782: -- l_fiscal_ind hz_financial_reports.fiscal_ind%TYPE;
15783: -- l_final_ind hz_financial_reports.final_ind%TYPE;
15784: -- l_forecast_ind hz_financial_reports.forecast_ind%TYPE;
15785: -- l_opening_ind hz_financial_reports.opening_ind%TYPE;
15786: -- l_proforma_ind hz_financial_reports.proforma_ind%TYPE;

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

15779: -- l_audit_ind hz_financial_reports.audit_ind%TYPE;
15780: -- l_consolidated_ind hz_financial_reports.consolidated_ind%TYPE;
15781: -- l_estimated_ind hz_financial_reports.estimated_ind%TYPE;
15782: -- l_fiscal_ind hz_financial_reports.fiscal_ind%TYPE;
15783: -- l_final_ind hz_financial_reports.final_ind%TYPE;
15784: -- l_forecast_ind hz_financial_reports.forecast_ind%TYPE;
15785: -- l_opening_ind hz_financial_reports.opening_ind%TYPE;
15786: -- l_proforma_ind hz_financial_reports.proforma_ind%TYPE;
15787: -- l_qualified_ind hz_financial_reports.qualified_ind%TYPE;

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

15780: -- l_consolidated_ind hz_financial_reports.consolidated_ind%TYPE;
15781: -- l_estimated_ind hz_financial_reports.estimated_ind%TYPE;
15782: -- l_fiscal_ind hz_financial_reports.fiscal_ind%TYPE;
15783: -- l_final_ind hz_financial_reports.final_ind%TYPE;
15784: -- l_forecast_ind hz_financial_reports.forecast_ind%TYPE;
15785: -- l_opening_ind hz_financial_reports.opening_ind%TYPE;
15786: -- l_proforma_ind hz_financial_reports.proforma_ind%TYPE;
15787: -- l_qualified_ind hz_financial_reports.qualified_ind%TYPE;
15788: -- l_restated_ind hz_financial_reports.restated_ind%TYPE;

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

15781: -- l_estimated_ind hz_financial_reports.estimated_ind%TYPE;
15782: -- l_fiscal_ind hz_financial_reports.fiscal_ind%TYPE;
15783: -- l_final_ind hz_financial_reports.final_ind%TYPE;
15784: -- l_forecast_ind hz_financial_reports.forecast_ind%TYPE;
15785: -- l_opening_ind hz_financial_reports.opening_ind%TYPE;
15786: -- l_proforma_ind hz_financial_reports.proforma_ind%TYPE;
15787: -- l_qualified_ind hz_financial_reports.qualified_ind%TYPE;
15788: -- l_restated_ind hz_financial_reports.restated_ind%TYPE;
15789: -- l_signed_by_principals_ind hz_financial_reports.signed_by_principals_ind%TYPE;

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

15782: -- l_fiscal_ind hz_financial_reports.fiscal_ind%TYPE;
15783: -- l_final_ind hz_financial_reports.final_ind%TYPE;
15784: -- l_forecast_ind hz_financial_reports.forecast_ind%TYPE;
15785: -- l_opening_ind hz_financial_reports.opening_ind%TYPE;
15786: -- l_proforma_ind hz_financial_reports.proforma_ind%TYPE;
15787: -- l_qualified_ind hz_financial_reports.qualified_ind%TYPE;
15788: -- l_restated_ind hz_financial_reports.restated_ind%TYPE;
15789: -- l_signed_by_principals_ind hz_financial_reports.signed_by_principals_ind%TYPE;
15790: -- l_trial_balance_ind hz_financial_reports.trial_balance_ind%TYPE;

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

15783: -- l_final_ind hz_financial_reports.final_ind%TYPE;
15784: -- l_forecast_ind hz_financial_reports.forecast_ind%TYPE;
15785: -- l_opening_ind hz_financial_reports.opening_ind%TYPE;
15786: -- l_proforma_ind hz_financial_reports.proforma_ind%TYPE;
15787: -- l_qualified_ind hz_financial_reports.qualified_ind%TYPE;
15788: -- l_restated_ind hz_financial_reports.restated_ind%TYPE;
15789: -- l_signed_by_principals_ind hz_financial_reports.signed_by_principals_ind%TYPE;
15790: -- l_trial_balance_ind hz_financial_reports.trial_balance_ind%TYPE;
15791: -- l_unbalanced_ind hz_financial_reports.unbalanced_ind%TYPE;

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

15784: -- l_forecast_ind hz_financial_reports.forecast_ind%TYPE;
15785: -- l_opening_ind hz_financial_reports.opening_ind%TYPE;
15786: -- l_proforma_ind hz_financial_reports.proforma_ind%TYPE;
15787: -- l_qualified_ind hz_financial_reports.qualified_ind%TYPE;
15788: -- l_restated_ind hz_financial_reports.restated_ind%TYPE;
15789: -- l_signed_by_principals_ind hz_financial_reports.signed_by_principals_ind%TYPE;
15790: -- l_trial_balance_ind hz_financial_reports.trial_balance_ind%TYPE;
15791: -- l_unbalanced_ind hz_financial_reports.unbalanced_ind%TYPE;
15792: l_content_source_type hz_financial_reports.content_source_type%TYPE;

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

15785: -- l_opening_ind hz_financial_reports.opening_ind%TYPE;
15786: -- l_proforma_ind hz_financial_reports.proforma_ind%TYPE;
15787: -- l_qualified_ind hz_financial_reports.qualified_ind%TYPE;
15788: -- l_restated_ind hz_financial_reports.restated_ind%TYPE;
15789: -- l_signed_by_principals_ind hz_financial_reports.signed_by_principals_ind%TYPE;
15790: -- l_trial_balance_ind hz_financial_reports.trial_balance_ind%TYPE;
15791: -- l_unbalanced_ind hz_financial_reports.unbalanced_ind%TYPE;
15792: l_content_source_type hz_financial_reports.content_source_type%TYPE;
15793: l_actual_content_source hz_financial_reports.actual_content_source%TYPE;

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

15786: -- l_proforma_ind hz_financial_reports.proforma_ind%TYPE;
15787: -- l_qualified_ind hz_financial_reports.qualified_ind%TYPE;
15788: -- l_restated_ind hz_financial_reports.restated_ind%TYPE;
15789: -- l_signed_by_principals_ind hz_financial_reports.signed_by_principals_ind%TYPE;
15790: -- l_trial_balance_ind hz_financial_reports.trial_balance_ind%TYPE;
15791: -- l_unbalanced_ind hz_financial_reports.unbalanced_ind%TYPE;
15792: l_content_source_type hz_financial_reports.content_source_type%TYPE;
15793: l_actual_content_source hz_financial_reports.actual_content_source%TYPE;
15794: -- l_request_id hz_financial_reports.request_id%TYPE;

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

15787: -- l_qualified_ind hz_financial_reports.qualified_ind%TYPE;
15788: -- l_restated_ind hz_financial_reports.restated_ind%TYPE;
15789: -- l_signed_by_principals_ind hz_financial_reports.signed_by_principals_ind%TYPE;
15790: -- l_trial_balance_ind hz_financial_reports.trial_balance_ind%TYPE;
15791: -- l_unbalanced_ind hz_financial_reports.unbalanced_ind%TYPE;
15792: l_content_source_type hz_financial_reports.content_source_type%TYPE;
15793: l_actual_content_source hz_financial_reports.actual_content_source%TYPE;
15794: -- l_request_id hz_financial_reports.request_id%TYPE;
15795: l_status hz_financial_reports.status%TYPE;

Line 15792: l_content_source_type hz_financial_reports.content_source_type%TYPE;

15788: -- l_restated_ind hz_financial_reports.restated_ind%TYPE;
15789: -- l_signed_by_principals_ind hz_financial_reports.signed_by_principals_ind%TYPE;
15790: -- l_trial_balance_ind hz_financial_reports.trial_balance_ind%TYPE;
15791: -- l_unbalanced_ind hz_financial_reports.unbalanced_ind%TYPE;
15792: l_content_source_type hz_financial_reports.content_source_type%TYPE;
15793: l_actual_content_source hz_financial_reports.actual_content_source%TYPE;
15794: -- l_request_id hz_financial_reports.request_id%TYPE;
15795: l_status hz_financial_reports.status%TYPE;
15796: l_created_by_module hz_financial_reports.created_by_module%TYPE;

Line 15793: l_actual_content_source hz_financial_reports.actual_content_source%TYPE;

15789: -- l_signed_by_principals_ind hz_financial_reports.signed_by_principals_ind%TYPE;
15790: -- l_trial_balance_ind hz_financial_reports.trial_balance_ind%TYPE;
15791: -- l_unbalanced_ind hz_financial_reports.unbalanced_ind%TYPE;
15792: l_content_source_type hz_financial_reports.content_source_type%TYPE;
15793: l_actual_content_source hz_financial_reports.actual_content_source%TYPE;
15794: -- l_request_id hz_financial_reports.request_id%TYPE;
15795: l_status hz_financial_reports.status%TYPE;
15796: l_created_by_module hz_financial_reports.created_by_module%TYPE;
15797:

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

15790: -- l_trial_balance_ind hz_financial_reports.trial_balance_ind%TYPE;
15791: -- l_unbalanced_ind hz_financial_reports.unbalanced_ind%TYPE;
15792: l_content_source_type hz_financial_reports.content_source_type%TYPE;
15793: l_actual_content_source hz_financial_reports.actual_content_source%TYPE;
15794: -- l_request_id hz_financial_reports.request_id%TYPE;
15795: l_status hz_financial_reports.status%TYPE;
15796: l_created_by_module hz_financial_reports.created_by_module%TYPE;
15797:
15798: -- l_temp_issued_period hz_financial_reports.issued_period%TYPE;

Line 15795: l_status hz_financial_reports.status%TYPE;

15791: -- l_unbalanced_ind hz_financial_reports.unbalanced_ind%TYPE;
15792: l_content_source_type hz_financial_reports.content_source_type%TYPE;
15793: l_actual_content_source hz_financial_reports.actual_content_source%TYPE;
15794: -- l_request_id hz_financial_reports.request_id%TYPE;
15795: l_status hz_financial_reports.status%TYPE;
15796: l_created_by_module hz_financial_reports.created_by_module%TYPE;
15797:
15798: -- l_temp_issued_period hz_financial_reports.issued_period%TYPE;
15799: -- l_temp_report_start_date hz_financial_reports.report_start_date%TYPE;

Line 15796: l_created_by_module hz_financial_reports.created_by_module%TYPE;

15792: l_content_source_type hz_financial_reports.content_source_type%TYPE;
15793: l_actual_content_source hz_financial_reports.actual_content_source%TYPE;
15794: -- l_request_id hz_financial_reports.request_id%TYPE;
15795: l_status hz_financial_reports.status%TYPE;
15796: l_created_by_module hz_financial_reports.created_by_module%TYPE;
15797:
15798: -- l_temp_issued_period hz_financial_reports.issued_period%TYPE;
15799: -- l_temp_report_start_date hz_financial_reports.report_start_date%TYPE;
15800: -- l_temp_report_end_date hz_financial_reports.report_end_date%TYPE;

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

15794: -- l_request_id hz_financial_reports.request_id%TYPE;
15795: l_status hz_financial_reports.status%TYPE;
15796: l_created_by_module hz_financial_reports.created_by_module%TYPE;
15797:
15798: -- l_temp_issued_period hz_financial_reports.issued_period%TYPE;
15799: -- l_temp_report_start_date hz_financial_reports.report_start_date%TYPE;
15800: -- l_temp_report_end_date hz_financial_reports.report_end_date%TYPE;
15801: l_dummy VARCHAR2(1);
15802: l_debug_prefix VARCHAR2(30) := '';

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

15795: l_status hz_financial_reports.status%TYPE;
15796: l_created_by_module hz_financial_reports.created_by_module%TYPE;
15797:
15798: -- l_temp_issued_period hz_financial_reports.issued_period%TYPE;
15799: -- l_temp_report_start_date hz_financial_reports.report_start_date%TYPE;
15800: -- l_temp_report_end_date hz_financial_reports.report_end_date%TYPE;
15801: l_dummy VARCHAR2(1);
15802: l_debug_prefix VARCHAR2(30) := '';
15803:

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

15796: l_created_by_module hz_financial_reports.created_by_module%TYPE;
15797:
15798: -- l_temp_issued_period hz_financial_reports.issued_period%TYPE;
15799: -- l_temp_report_start_date hz_financial_reports.report_start_date%TYPE;
15800: -- l_temp_report_end_date hz_financial_reports.report_end_date%TYPE;
15801: l_dummy VARCHAR2(1);
15802: l_debug_prefix VARCHAR2(30) := '';
15803:
15804: BEGIN

Line 15880: FROM HZ_FINANCIAL_REPORTS

15876: l_actual_content_source,
15877: -- l_request_id,
15878: l_status,
15879: l_created_by_module
15880: FROM HZ_FINANCIAL_REPORTS
15881: WHERE ROWID = p_rowid;
15882: END IF;
15883:
15884: -------------------------------------

Line 16859: p_entity_name => 'HZ_FINANCIAL_REPORTS',

16855: p_content_source_type => 'USER_ENTERED',
16856: p_old_content_source_type => 'USER_ENTERED',
16857: p_actual_content_source => p_financial_report_rec.actual_content_source,
16858: p_old_actual_content_source => l_actual_content_source,
16859: p_entity_name => 'HZ_FINANCIAL_REPORTS',
16860: x_return_status => x_return_status );
16861:
16862: ----------------------------
16863: --validate created_by_module

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

17044: -- validation for financial_report_id
17045: -------------------------------------
17046: /****Logical APIs - validation not required****/
17047: IF(HZ_UTILITY_V2PUB.G_CALLING_API IS NULL) THEN
17048: --Must exist in HZ_FINANCIAL_REPORTS. Non-updateable.
17049: -- financial_report_id has foreign key HZ_FINANCIAL_REPORTS.FINANCIAL_REPORT_ID
17050: IF p_create_update_flag = 'C'
17051: AND
17052: p_financial_number_rec.financial_report_id IS NOT NULL

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

17045: -------------------------------------
17046: /****Logical APIs - validation not required****/
17047: IF(HZ_UTILITY_V2PUB.G_CALLING_API IS NULL) THEN
17048: --Must exist in HZ_FINANCIAL_REPORTS. Non-updateable.
17049: -- financial_report_id has foreign key HZ_FINANCIAL_REPORTS.FINANCIAL_REPORT_ID
17050: IF p_create_update_flag = 'C'
17051: AND
17052: p_financial_number_rec.financial_report_id IS NOT NULL
17053: AND

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

17053: AND
17054: p_financial_number_rec.financial_report_id <> fnd_api.g_miss_num
17055: THEN
17056: BEGIN
17057: --bug 3942332: selected actual_content_source from the hz_financial_reports record.
17058: --SELECT 'Y'
17059: --INTO l_dummy
17060: SELECT actual_content_source
17061: INTO x_actual_content_source

Line 17062: FROM hz_financial_reports hfr

17058: --SELECT 'Y'
17059: --INTO l_dummy
17060: SELECT actual_content_source
17061: INTO x_actual_content_source
17062: FROM hz_financial_reports hfr
17063: WHERE hfr.financial_report_id = p_financial_number_rec.financial_report_id;
17064:
17065: EXCEPTION
17066: WHEN NO_DATA_FOUND THEN

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

17066: WHEN NO_DATA_FOUND THEN
17067: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
17068: fnd_message.set_token('FK', 'financial_report_id');
17069: fnd_message.set_token('COLUMN', 'financial_report_id');
17070: fnd_message.set_token('TABLE', 'hz_financial_reports');
17071: fnd_msg_pub.add;
17072: x_return_status := fnd_api.g_ret_sts_error;
17073: END;
17074:

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

17073: END;
17074:
17075: /*IF g_debug THEN
17076: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
17077: 'financial_report_id has foreign key hz_financial_reports.financial_report_id. ' ||
17078: 'x_return_status = ' || x_return_status, l_debug_prefix);
17079: END IF;
17080: */
17081: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

17079: END IF;
17080: */
17081: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
17082: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
17083: p_message=>'financial_report_id has foreign key hz_financial_reports.financial_report_id. ' ||
17084: 'x_return_status = ' || x_return_status,
17085: p_msg_level=>fnd_log.level_statement);
17086: END IF;
17087: