The following lines contain the word 'select', 'insert', 'update' or 'delete':
g_fin_selected_datasources VARCHAR2(255);
g_fin_is_datasource_selected VARCHAR2(1) := 'N';
PROCEDURE do_update_financial_report(
p_financial_report_rec IN OUT NOCOPY FINANCIAL_REPORT_REC_TYPE,
p_object_version_number IN OUT NOCOPY NUMBER,
x_return_status IN OUT NOCOPY VARCHAR2
);
PROCEDURE do_update_financial_number(
p_financial_number_rec IN OUT NOCOPY FINANCIAL_NUMBER_REC_TYPE,
p_object_version_number IN OUT NOCOPY NUMBER,
x_return_status IN OUT NOCOPY VARCHAR2
);
HZ_FINANCIAL_REPORTS_PKG.Insert_Row (
x_ROWID => l_rowid,
x_FINANCIAL_REPORT_ID => p_financial_report_rec.financial_report_id,
x_DATE_REPORT_ISSUED => p_financial_report_rec.date_report_issued,
x_PARTY_ID => p_financial_report_rec.party_id,
x_DOCUMENT_REFERENCE => p_financial_report_rec.document_reference,
x_ISSUED_PERIOD => p_financial_report_rec.issued_period,
x_REQUIRING_AUTHORITY => p_financial_report_rec.requiring_authority,
x_TYPE_OF_FINANCIAL_REPORT => p_financial_report_rec.type_of_financial_report,
x_REPORT_START_DATE => p_financial_report_rec.report_start_date,
x_REPORT_END_DATE => p_financial_report_rec.report_end_date,
x_AUDIT_IND => p_financial_report_rec.audit_ind,
x_CONSOLIDATED_IND => p_financial_report_rec.consolidated_ind,
x_ESTIMATED_IND => p_financial_report_rec.estimated_ind,
x_FISCAL_IND => p_financial_report_rec.fiscal_ind,
x_FINAL_IND => p_financial_report_rec.final_ind,
x_FORECAST_IND => p_financial_report_rec.forecast_ind,
x_OPENING_IND => p_financial_report_rec.opening_ind,
x_PROFORMA_IND => p_financial_report_rec.proforma_ind,
x_QUALIFIED_IND => p_financial_report_rec.qualified_ind,
x_RESTATED_IND => p_financial_report_rec.restated_ind,
x_SIGNED_BY_PRINCIPALS_IND => p_financial_report_rec.signed_by_principals_ind,
x_TRIAL_BALANCE_IND => p_financial_report_rec.trial_balance_ind,
x_UNBALANCED_IND => p_financial_report_rec.unbalanced_ind,
x_CONTENT_SOURCE_TYPE => G_MISS_CONTENT_SOURCE_TYPE,
x_STATUS => p_financial_report_rec.status,
x_OBJECT_VERSION_NUMBER => 1,
x_CREATED_BY_MODULE => p_financial_report_rec.created_by_module,
x_ACTUAL_CONTENT_SOURCE => p_financial_report_rec.actual_content_source
);
PROCEDURE do_update_financial_report(
p_financial_report_rec IN OUT NOCOPY FINANCIAL_REPORT_REC_TYPE,
p_object_version_number IN OUT NOCOPY NUMBER,
x_return_status IN OUT NOCOPY VARCHAR2
) IS
l_rowid ROWID := NULL;
SELECT rowid, object_version_number, party_id, actual_content_source
INTO l_rowid, l_object_version_number, l_party_id, db_actual_content_source
FROM HZ_FINANCIAL_REPORTS
WHERE financial_report_id = p_financial_report_rec.financial_report_id
FOR UPDATE NOWAIT;
IF HZ_UTILITY_V2PUB.G_UPDATE_ACS = 'Y' THEN
l_acs := nvl(p_financial_report_rec.actual_content_source, 'USER_ENTERED');
HZ_FINANCIAL_REPORTS_PKG.Update_Row (
x_ROWID => l_rowid,
x_FINANCIAL_REPORT_ID => p_financial_report_rec.financial_report_id,
x_DATE_REPORT_ISSUED => p_financial_report_rec.date_report_issued,
x_PARTY_ID => p_financial_report_rec.party_id,
x_DOCUMENT_REFERENCE => p_financial_report_rec.document_reference,
x_ISSUED_PERIOD => p_financial_report_rec.issued_period,
x_REQUIRING_AUTHORITY => p_financial_report_rec.requiring_authority,
x_TYPE_OF_FINANCIAL_REPORT => p_financial_report_rec.type_of_financial_report,
x_REPORT_START_DATE => p_financial_report_rec.report_start_date,
x_REPORT_END_DATE => p_financial_report_rec.report_end_date,
x_AUDIT_IND => p_financial_report_rec.audit_ind,
x_CONSOLIDATED_IND => p_financial_report_rec.consolidated_ind,
x_ESTIMATED_IND => p_financial_report_rec.estimated_ind,
x_FISCAL_IND => p_financial_report_rec.fiscal_ind,
x_FINAL_IND => p_financial_report_rec.final_ind,
x_FORECAST_IND => p_financial_report_rec.forecast_ind,
x_OPENING_IND => p_financial_report_rec.opening_ind,
x_PROFORMA_IND => p_financial_report_rec.proforma_ind,
x_QUALIFIED_IND => p_financial_report_rec.qualified_ind,
x_RESTATED_IND => p_financial_report_rec.restated_ind,
x_SIGNED_BY_PRINCIPALS_IND => p_financial_report_rec.signed_by_principals_ind,
x_TRIAL_BALANCE_IND => p_financial_report_rec.trial_balance_ind,
x_UNBALANCED_IND => p_financial_report_rec.unbalanced_ind,
x_CONTENT_SOURCE_TYPE => G_MISS_CONTENT_SOURCE_TYPE,
x_STATUS => p_financial_report_rec.status,
x_OBJECT_VERSION_NUMBER => p_object_version_number,
x_CREATED_BY_MODULE => p_financial_report_rec.created_by_module,
-- Bug 4693719 : Pass correct value for ACS
x_ACTUAL_CONTENT_SOURCE => l_acs
);
END do_update_financial_report;
HZ_FINANCIAL_NUMBERS_PKG.Insert_Row (
x_rowid => l_rowid,
x_financial_number_id => p_financial_number_rec.financial_number_id,
x_financial_report_id => p_financial_number_rec.financial_report_id,
x_financial_number => p_financial_number_rec.financial_number,
x_financial_number_name => p_financial_number_rec.financial_number_name,
x_financial_units_applied => p_financial_number_rec.financial_units_applied,
x_financial_number_currency => p_financial_number_rec.financial_number_currency,
x_projected_actual_flag => p_financial_number_rec.projected_actual_flag,
x_content_source_type => p_financial_number_rec.content_source_type,
x_status => p_financial_number_rec.status,
x_object_version_number => 1,
x_created_by_module => p_financial_number_rec.created_by_module,
x_actual_content_source => l_acual_content_source
);
* PROCEDURE do_update_financial_number
*
* DESCRIPTION
* Creates financial_number.
*
* SCOPE - PRIVATE
*
* EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
*
* ARGUMENTS
* IN:
* p_financial_number_rec Financial Number record.
*
* IN/OUT:
* OUT:
* p_object_version_number Used for locking the being updated record.
* x_return_status Return status after the call. The status can
* be FND_API.G_RET_STS_SUCCESS (success),
* FND_API.G_RET_STS_ERROR (error),
* FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
*
* NOTES
*
* MODIFICATION HISTORY
*
* 23-JAN-2003 Sreedhar Mohan o Created.
* 04-JAN-2005 Rajib Ranjan Borah o SSM SST Integration and Extension.
* For non-profile entities, the concept of
* select/de-select data-sources is obsoleted.
* 22-MAR-2005 Rajib Ranjan Borah o Bug 4225452. The user creation rules for
* credit ratings were wrongly checked.
*/
PROCEDURE do_update_financial_number(
p_financial_number_rec IN OUT NOCOPY FINANCIAL_NUMBER_REC_TYPE,
p_object_version_number IN OUT NOCOPY NUMBER,
x_return_status IN OUT NOCOPY VARCHAR2
) IS
l_rowid ROWID := NULL;
g_cre_selected_datasources VARCHAR2(255);
g_cre_is_datasource_selected VARCHAR2(1) := 'N';
SELECT rowid, object_version_number
INTO l_rowid, l_object_version_number
FROM HZ_financial_numbers
WHERE financial_number_id = p_financial_number_rec.financial_number_id
FOR UPDATE NOWAIT;
* For non-profile entities, the concept of select/de-select data-sources is obsoleted.
HZ_MIXNM_UTILITY.LoadDataSources(
p_entity_name => 'HZ_CREDIT_RATINGS',
p_entity_attr_id => g_cre_entity_attr_id,
p_mixnmatch_enabled => g_cre_mixnmatch_enabled,
p_selected_datasources => g_cre_selected_datasources );
p_selected_datasources => g_cre_selected_datasources,
p_content_source_type => p_financial_number_rec.content_source_type,
p_actual_content_source => l_acual_content_source,
x_is_datasource_selected => g_cre_is_datasource_selected,
x_return_status => x_return_status,
p_api_version => 'V2');
HZ_FINANCIAL_NUMBERS_PKG.Update_Row (
x_rowid => l_rowid,
x_financial_number_id => p_financial_number_rec.financial_number_id,
x_financial_report_id => p_financial_number_rec.financial_report_id,
x_financial_number => p_financial_number_rec.financial_number,
x_financial_number_name => p_financial_number_rec.financial_number_name,
x_financial_units_applied => p_financial_number_rec.financial_units_applied,
x_financial_number_currency => p_financial_number_rec.financial_number_currency,
x_projected_actual_flag => p_financial_number_rec.projected_actual_flag,
x_content_source_type => p_financial_number_rec.content_source_type,
x_status => p_financial_number_rec.status,
x_object_version_number => p_object_version_number,
x_created_by_module => p_financial_number_rec.created_by_module,
--bug 3942332: actual_content_source is a non-updateable column
--x_actual_content_source => l_acual_content_source
x_actual_content_source => null
);
END do_update_financial_number;
* select/de-select data-sources is obsoleted.
*
*/
PROCEDURE create_financial_report(
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_financial_report_rec IN FINANCIAL_REPORT_REC_TYPE,
x_financial_report_id OUT NOCOPY NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) IS
l_api_name CONSTANT VARCHAR2(30) := 'create_financial_report';
For non-profile entities, the concept of select/de-select data-sources is obsoleted.
HZ_MIXNM_UTILITY.LoadDataSources(
p_entity_name => 'HZ_FINANCIAL_REPORTS',
p_entity_attr_id => g_fin_entity_attr_id,
p_mixnmatch_enabled => g_fin_mixnmatch_enabled,
p_selected_datasources => g_fin_selected_datasources );
p_selected_datasources => g_fin_selected_datasources,
p_content_source_type => g_miss_content_source_type,
p_actual_content_source => l_financial_report_rec.actual_content_source,
x_is_datasource_selected => g_fin_is_datasource_selected,
x_return_status => x_return_status,
p_api_version => 'V2');
g_fin_is_datasource_selected = 'Y' */
THEN
IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
-- Invoke business event system.
HZ_BUSINESS_EVENT_V2PVT.create_fin_reports_event (
l_financial_report_rec );
* PROCEDURE update_financial_report
*
* DESCRIPTION
* Updates Financial Report.
*
* EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
* HZ_BUSINESS_EVENT_V2PVT.update_fin_reports_event
*
* ARGUMENTS
* IN:
* p_init_msg_list Initialize message stack if it is set to
* FND_API.G_TRUE. Default is FND_API.G_FALSE.
* p_financial_report_rec Financial report record.
* IN/OUT:
* p_object_version_number Used for locking the being updated record.
* OUT:
* x_return_status Return status after the call. The status can
* be FND_API.G_RET_STS_SUCCESS (success),
* FND_API.G_RET_STS_ERROR (error),
* FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
* x_msg_count Number of messages in message stack.
* x_msg_data Message text if x_msg_count is 1.
*
* NOTES
*
* MODIFICATION HISTORY
*
* 23-JAN-2003 Sreedhar Mohan o Created.
* 04-JAN-2005 Rajib Ranjan Borah o SSM SST Integration and Extension.
* For non-profile entities, the concept of
* select/de-select data-sources is obsoleted.
*
*/
PROCEDURE update_financial_report(
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_financial_report_rec IN FINANCIAL_REPORT_REC_TYPE,
p_object_version_number IN OUT NOCOPY NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) IS
l_api_name CONSTANT VARCHAR2(30) := 'update_financial_report';
SAVEPOINT update_financial_report;
* For non-profile entities, the concept of select/de-select data-sources is obsoleted.
* There is no need to check if the data-source is selected.
HZ_MIXNM_UTILITY.LoadDataSources(
p_entity_name => 'HZ_FINANCIAL_REPORTS',
p_entity_attr_id => g_fin_entity_attr_id,
p_mixnmatch_enabled => g_fin_mixnmatch_enabled,
p_selected_datasources => g_fin_selected_datasources );
g_fin_is_datasource_selected :=
HZ_MIXNM_UTILITY.isDataSourceSelected (
p_selected_datasources => g_fin_selected_datasources,
p_actual_content_source => l_old_fin_report_rec.actual_content_source );
do_update_financial_report(
l_financial_report_rec,
p_object_version_number,
x_return_status);
g_fin_is_datasource_selected = 'Y'*/
THEN
--Bug 2979651: Since 2907261 made to HZ.K, keeping back the changes of 115.8 version.
IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
-- Invoke business event system.
HZ_BUSINESS_EVENT_V2PVT.update_fin_reports_event (
l_financial_report_rec,
l_old_fin_report_rec );
HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
ROLLBACK TO update_financial_report;
HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
ROLLBACK TO update_financial_report;
HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
ROLLBACK TO update_financial_report;
HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
END update_financial_report;
* HZ_FINANCIAL_REPORTS_PKG.Select_Row
*
* ARGUMENTS
* IN:
* p_init_msg_list Initialize message stack if it is set to
* FND_API.G_TRUE. Default is FND_API.G_FALSE.
* p_financial_report_id Financial report ID.
* IN/OUT:
* OUT:
* x_financial_report_rec Returned financial report record.
* x_return_status Return status after the call. The status can
* be FND_API.G_RET_STS_SUCCESS (success),
* FND_API.G_RET_STS_ERROR (error),
* FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
* x_msg_count Number of messages in message stack.
* x_msg_data Message text if x_msg_count is 1.
*
* NOTES
*
* MODIFICATION HISTORY
*
* 23-JAN-2003 Sreedhar Mohan o Created.
*/
PROCEDURE get_financial_report_rec (
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_financial_report_id IN NUMBER,
p_financial_report_rec OUT NOCOPY FINANCIAL_REPORT_REC_TYPE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) IS
l_api_name CONSTANT VARCHAR2(30) := 'get_financial_report_rec';
HZ_FINANCIAL_REPORTS_PKG.Select_Row (
x_financial_report_id => p_financial_report_rec.financial_report_id,
x_date_report_issued => p_financial_report_rec.date_report_issued,
x_party_id => p_financial_report_rec.party_id,
x_document_reference => p_financial_report_rec.document_reference,
x_issued_period => p_financial_report_rec.issued_period,
x_requiring_authority => p_financial_report_rec.requiring_authority,
x_type_of_financial_report => p_financial_report_rec.type_of_financial_report,
x_report_start_date => p_financial_report_rec.report_start_date,
x_report_end_date => p_financial_report_rec.report_end_date,
x_audit_ind => p_financial_report_rec.audit_ind,
x_consolidated_ind => p_financial_report_rec.consolidated_ind,
x_estimated_ind => p_financial_report_rec.estimated_ind,
x_fiscal_ind => p_financial_report_rec.fiscal_ind,
x_final_ind => p_financial_report_rec.final_ind,
x_forecast_ind => p_financial_report_rec.forecast_ind,
x_opening_ind => p_financial_report_rec.opening_ind,
x_proforma_ind => p_financial_report_rec.proforma_ind,
x_qualified_ind => p_financial_report_rec.qualified_ind,
x_restated_ind => p_financial_report_rec.restated_ind,
x_signed_by_principals_ind => p_financial_report_rec.signed_by_principals_ind,
x_trial_balance_ind => p_financial_report_rec.trial_balance_ind,
x_unbalanced_ind => p_financial_report_rec.unbalanced_ind,
x_content_source_type => G_MISS_CONTENT_SOURCE_TYPE,
x_status => p_financial_report_rec.status,
x_actual_content_source => p_financial_report_rec.actual_content_source,
x_created_by_module => p_financial_report_rec.created_by_module
);
* select/de-select data-sources is obsoleted.
*
*/
PROCEDURE create_financial_number(
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_financial_number_rec IN FINANCIAL_NUMBER_REC_TYPE,
x_financial_number_id OUT NOCOPY NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) IS
l_api_name CONSTANT VARCHAR2(30) := 'create_financial_number';
* For non-profile entities, the concept of select/de-select data-sources is obsoleted.
* There is no need to check if the data-source is selected.
HZ_MIXNM_UTILITY.LoadDataSources(
p_entity_name => 'HZ_FINANCIAL_REPORTS',
p_entity_attr_id => g_fin_entity_attr_id,
p_mixnmatch_enabled => g_fin_mixnmatch_enabled,
p_selected_datasources => g_fin_selected_datasources );
g_fin_is_datasource_selected = 'Y' */
THEN
IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
-- Invoke business event system.
HZ_BUSINESS_EVENT_V2PVT.create_fin_numbers_event (
l_financial_number_rec );
* PROCEDURE update_financial_number
*
* DESCRIPTION
* Updates Financial Number.
*
* EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
* HZ_BUSINESS_EVENT_V2PVT.update_fin_number_event
*
* ARGUMENTS
* IN:
* p_init_msg_list Initialize message stack if it is set to
* FND_API.G_TRUE. Default is FND_API.G_FALSE.
* p_financial_number_rec Financial Number record.
* IN/OUT:
* p_object_version_number Used for locking the being updated record.
* OUT:
* x_return_status Return status after the call. The status can
* be FND_API.G_RET_STS_SUCCESS (success),
* FND_API.G_RET_STS_ERROR (error),
* FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
* x_msg_count Number of messages in message stack.
* x_msg_data Message text if x_msg_count is 1.
*
* NOTES
*
* MODIFICATION HISTORY
*
* 23-JAN-2003 Sreedhar Mohan o Created.
* 04-JAN-2005 Rajib Ranjan Borah o SSM SST Integration and Extension.
* For non-profile entities, the concept of
* select/de-select data-sources is obsoleted.
*
*/
PROCEDURE update_financial_number(
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_financial_number_rec IN FINANCIAL_NUMBER_REC_TYPE,
p_object_version_number IN OUT NOCOPY NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) IS
l_api_name CONSTANT VARCHAR2(30) := 'update_financial_number';
SAVEPOINT update_financial_number;
* For non-profile entities, the concept of select/de-select data-sources is obsoleted.
* There is no need to check if the data-source is selected.
HZ_MIXNM_UTILITY.LoadDataSources(
p_entity_name => 'HZ_FINANCIAL_REPORTS',
p_entity_attr_id => g_fin_entity_attr_id,
p_mixnmatch_enabled => g_fin_mixnmatch_enabled,
p_selected_datasources => g_fin_selected_datasources );
do_update_financial_number(
l_financial_number_rec,
p_object_version_number,
x_return_status);
g_fin_is_datasource_selected = 'Y'*/
THEN
--Bug 2979651: Since 2907261 made to HZ.K, keeping back the changes of 115.8 version.
IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
HZ_BUSINESS_EVENT_V2PVT.update_fin_numbers_event (
l_financial_number_rec,
l_old_financial_number_rec );
ROLLBACK TO update_financial_number;
ROLLBACK TO update_financial_number;
ROLLBACK TO update_financial_number;
END update_financial_number;
* HZ_FINANCIAL_NUMBERS_PKG.Select_Row
*
* ARGUMENTS
* IN:
* p_init_msg_list Initialize message stack if it is set to
* FND_API.G_TRUE. Default is FND_API.G_FALSE.
* p_financial_number_id Financial Number ID.
* IN/OUT:
* OUT:
* x_financial_number_rec Returned financial number record.
* x_return_status Return status after the call. The status can
* be FND_API.G_RET_STS_SUCCESS (success),
* FND_API.G_RET_STS_ERROR (error),
* FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
* x_msg_count Number of messages in message stack.
* x_msg_data Message text if x_msg_count is 1.
*
* NOTES
*
* MODIFICATION HISTORY
*
* 23-JAN-2003 Sreedhar Mohan o Created.
*/
PROCEDURE get_financial_number_rec (
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_financial_number_id IN NUMBER,
p_financial_number_rec OUT NOCOPY FINANCIAL_NUMBER_REC_TYPE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) IS
l_api_name CONSTANT VARCHAR2(30) := 'get_financial_number_rec';
HZ_FINANCIAL_NUMBERS_PKG.Select_Row (
x_financial_number_id => p_financial_number_rec.financial_number_id,
x_financial_report_id => p_financial_number_rec.financial_report_id,
x_financial_number => p_financial_number_rec.financial_number,
x_financial_number_name => p_financial_number_rec.financial_number_name,
x_financial_units_applied => p_financial_number_rec.financial_units_applied,
x_financial_number_currency => p_financial_number_rec.financial_number_currency,
x_projected_actual_flag => p_financial_number_rec.projected_actual_flag,
x_content_source_type => G_MISS_CONTENT_SOURCE_TYPE,
x_status => p_financial_number_rec.status,
x_actual_content_source => G_MISS_CONTENT_SOURCE_TYPE
);