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';
| HZ_CERTIFICATIONS_PKG.INSERT_ROW(),HZ_CERTIFICATION_PKG.UPDATE_ROW(),
| HZ_FINANCIAL_REPORTS_PKG.INSERT_ROW(),HZ_FINANCIAL_REPORTS_PKG.UPDATE_ROW(),
| HZ_FINANCIAL_NUMBER_PKG.INSERT_ROW(),HZ_FINANCIAL_NUMBER_PKG.UPDATE_ROW(),
| HZ_INDUSTRIAL_REFERENCE_PKG.INSERT_ROW(),HZ_INDUSTRIAL_REFERENCE_PKG.UPDATE_ROW,
| HZ_SECURITY_ISSUED_PKG.INSERT_ROW(),HZ_SECURITY_ISSUED_PKG.UPDATE_ROW.
+===========================================================================*/
procedure do_create_stock_markets(
p_stock_markets_rec IN OUT NOCOPY stock_markets_rec_type,
x_stock_exchange_id OUT NOCOPY NUMBER,
x_return_status IN OUT NOCOPY VARCHAR2
) IS
l_stock_exchange_id NUMBER := p_stock_markets_rec.stock_exchange_id;
SELECT hz_stock_markets_s.nextval
INTO l_stock_exchange_id from dual;
SELECT count(*)
INTO l_count
FROM HZ_STOCK_MARKETS
WHERE stock_exchange_id = l_stock_exchange_id;
SELECT count(*)
INTO l_count
FROM HZ_STOCK_MARKETS
WHERE stock_exchange_id = l_stock_exchange_id;
HZ_STOCK_MARKETS_PKG.INSERT_ROW(
X_Rowid => l_rowid,
X_STOCK_EXCHANGE_ID => p_stock_markets_rec.stock_exchange_id,
X_COUNTRY_OF_RESIDENCE => p_stock_markets_rec.COUNTRY_OF_RESIDENCE,
X_STOCK_EXCHANGE_CODE => p_stock_markets_rec.STOCK_EXCHANGE_CODE,
X_STOCK_EXCHANGE_NAME => p_stock_markets_rec.STOCK_EXCHANGE_NAME,
X_CREATED_BY => hz_utility_pub.CREATED_BY,
X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
X_WH_UPDATE_DATE => p_stock_markets_rec.WH_UPDATE_DATE
);
| do_update_stock_markets
|
| DESCRIPTION
| Updates stock markets.
|
| SCOPE - PRIVATE
|
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
|
| ARGUMENTS : IN:
| OUT:
| IN/ OUT:
| p_stock_markets_rec
| p_last_update_date
| x_return_status
|
| RETURNS : NONE
|
| NOTES
|
| MODIFICATION HISTORY
| Jianying Huang 06-OCT-00 Bug 1428526: make *_rec parameters as
| 'IN OUT' in order to pass the changed record
| to caller.
|
+===========================================================================*/
procedure do_update_stock_markets(
p_stock_markets_rec IN OUT NOCOPY stock_markets_rec_type,
p_last_update_date IN OUT NOCOPY DATE,
x_return_status IN OUT NOCOPY VARCHAR2
) IS
l_count NUMBER;
l_last_update_date DATE;
IF p_last_update_date is NULL OR
p_last_update_date = FND_API.G_MISS_DATE THEN
FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
FND_MESSAGE.SET_TOKEN('COLUMN', 'last_update_date');
SELECT rowid, last_update_date
INTO l_rowid, l_last_update_date
FROM HZ_STOCK_MARKETS
WHERE stock_exchange_id = p_stock_markets_rec.stock_exchange_id
AND to_char(last_update_date, 'DD-MON-YYYY HH:MI:SS') =
to_char(p_last_update_date, 'DD-MON-YYYY HH:MI:SS')
FOR UPDATE NOWAIT;
p_last_update_date := hz_utility_pub.LAST_UPDATE_DATE;
HZ_STOCK_MARKETS_PKG.UPDATE_ROW(
X_Rowid => l_rowid,
X_STOCK_EXCHANGE_ID => p_stock_markets_rec.STOCK_EXCHANGE_ID,
X_COUNTRY_OF_RESIDENCE => p_stock_markets_rec.COUNTRY_OF_RESIDENCE,
X_STOCK_EXCHANGE_CODE => p_stock_markets_rec.STOCK_EXCHANGE_CODE,
X_STOCK_EXCHANGE_NAME => p_stock_markets_rec.STOCK_EXCHANGE_NAME,
X_CREATED_BY => FND_API.G_MISS_NUM,
X_CREATION_DATE => FND_API.G_MISS_DATE,
X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
X_LAST_UPDATE_DATE => p_last_update_date,
X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
X_WH_UPDATE_DATE => p_stock_markets_rec.WH_UPDATE_DATE
);
END do_update_stock_markets;
SELECT hz_security_issued_s.nextval
INTO l_security_issued_id from DUAL;
SELECT count(*)
INTO l_count
FROM HZ_SECURITY_ISSUED
WHERE security_issued_id = l_security_issued_id;
SELECT count(*)
INTO l_count
FROM HZ_SECURITY_ISSUED
WHERE security_issued_id = l_security_issued_id;
HZ_SECURITY_ISSUED_PKG.INSERT_ROW(
X_Rowid => l_rowid,
X_SECURITY_ISSUED_ID => p_security_issued_rec.security_issued_id,
X_ESTIMATED_TOTAL_AMOUNT => p_security_issued_rec.ESTIMATED_TOTAL_AMOUNT,
X_PARTY_ID => p_security_issued_rec.PARTY_ID,
X_STOCK_EXCHANGE_ID => p_security_issued_rec.STOCK_EXCHANGE_ID,
X_SECURITY_ISSUED_CLASS => p_security_issued_rec.SECURITY_ISSUED_CLASS,
X_SECURITY_ISSUED_NAME => p_security_issued_rec.SECURITY_ISSUED_NAME,
X_TOTAL_AMOUNT_IN_A_CURRENCY => p_security_issued_rec.TOTAL_AMOUNT_IN_A_CURRENCY,
X_STOCK_TICKER_SYMBOL => p_security_issued_rec.STOCK_TICKER_SYMBOL,
X_SECURITY_CURRENCY_CODE => p_security_issued_rec.SECURITY_CURRENCY_CODE,
X_BEGIN_DATE => p_security_issued_rec.BEGIN_DATE,
X_END_DATE => p_security_issued_rec.END_DATE,
X_CREATED_BY => hz_utility_pub.CREATED_BY,
X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
X_WH_UPDATE_DATE => p_security_issued_rec.WH_UPDATE_DATE,
X_STATUS =>p_security_issued_rec.STATUS
);
| do_update_security_issued
|
| DESCRIPTION
| Updates security issued.
|
| SCOPE - PRIVATE
|
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
|
| ARGUMENTS : IN:
| OUT:
| IN/ OUT:
| p_security_issued_rec
| p_last_update_date
| x_return_status
|
| RETURNS : NONE
|
| NOTES
|
| MODIFICATION HISTORY
| Jianying Huang 06-OCT-00 Bug 1428526: make *_rec parameters as
| 'IN OUT' in order to pass the changed record
| to caller.
|
+===========================================================================*/
procedure do_update_security_issued(
p_security_issued_rec IN OUT NOCOPY security_issued_rec_type,
p_last_update_date IN OUT NOCOPY DATE,
x_return_status IN OUT NOCOPY VARCHAR2
) IS
l_last_update_date DATE;
IF p_last_update_date IS NULL OR
p_last_update_date = FND_API.G_MISS_DATE
THEN
FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');
SELECT rowid, last_update_date
INTO l_rowid, l_last_update_date
FROM HZ_SECURITY_ISSUED
where security_issued_id
= p_security_issued_rec.security_issued_id
AND to_char(last_update_date, 'DD-MON-YYYY HH:MI:SS') =
to_char(p_last_update_date, 'DD-MON-YYYY HH:MI:SS')
FOR UPDATE NOWAIT;
p_last_update_date := hz_utility_pub.LAST_UPDATE_DATE;
HZ_SECURITY_ISSUED_PKG.UPDATE_ROW(
X_Rowid => l_rowid,
X_SECURITY_ISSUED_ID => p_security_issued_rec.SECURITY_ISSUED_ID,
X_ESTIMATED_TOTAL_AMOUNT => p_security_issued_rec.ESTIMATED_TOTAL_AMOUNT,
X_PARTY_ID => p_security_issued_rec.PARTY_ID,
X_STOCK_EXCHANGE_ID => p_security_issued_rec.STOCK_EXCHANGE_ID,
X_SECURITY_ISSUED_CLASS => p_security_issued_rec.SECURITY_ISSUED_CLASS,
X_SECURITY_ISSUED_NAME => p_security_issued_rec.SECURITY_ISSUED_NAME,
X_TOTAL_AMOUNT_IN_A_CURRENCY => p_security_issued_rec.TOTAL_AMOUNT_IN_A_CURRENCY,
X_STOCK_TICKER_SYMBOL => p_security_issued_rec.STOCK_TICKER_SYMBOL,
X_SECURITY_CURRENCY_CODE => p_security_issued_rec.SECURITY_CURRENCY_CODE,
X_BEGIN_DATE => p_security_issued_rec.BEGIN_DATE,
X_END_DATE => p_security_issued_rec.END_DATE,
X_CREATED_BY => FND_API.G_MISS_NUM,
X_CREATION_DATE => FND_API.G_MISS_DATE,
X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
X_LAST_UPDATE_DATE => p_last_update_date,
X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
X_WH_UPDATE_DATE => p_security_issued_rec.WH_UPDATE_DATE,
X_STATUS => p_security_issued_rec.STATUS
);
END do_update_security_issued;
| select/de-select data-sources is obsoleted.
+===========================================================================*/
procedure do_create_financial_reports(
p_financial_reports_rec IN OUT NOCOPY financial_reports_rec_type,
x_financial_report_id OUT NOCOPY NUMBER,
x_return_status IN OUT NOCOPY VARCHAR2
) IS
l_financial_report_id NUMBER := p_financial_reports_rec.financial_report_id;
g_fin_is_datasource_selected = 'Y'
THEN
hz_org_info_crmhk.create_financial_reports_pre(
p_financial_reports_rec,
x_return_status,
x_msg_count,
x_msg_data);
SELECT hz_financial_reports_s.nextval
INTO l_financial_report_id from dual;
SELECT count(*)
INTO l_count
FROM HZ_FINANCIAL_REPORTS
WHERE financial_report_id = l_financial_report_id;
SELECT count(*)
INTO l_count
FROM HZ_FINANCIAL_REPORTS
WHERE financial_report_id = l_financial_report_id;
HZ_FINANCIAL_REPORTS_PKG.INSERT_ROW(
x_rowid => l_rowid,
x_financial_report_id => p_financial_reports_rec.financial_report_id,
x_date_report_issued => p_financial_reports_rec.date_report_issued,
x_party_id => p_financial_reports_rec.party_id,
x_document_reference => p_financial_reports_rec.document_reference,
x_issued_period => p_financial_reports_rec.issued_period,
x_requiring_authority => p_financial_reports_rec.requiring_authority,
x_type_of_financial_report => p_financial_reports_rec.type_of_financial_report,
x_created_by => hz_utility_pub.created_by,
x_creation_date => hz_utility_pub.creation_date,
x_last_update_login => hz_utility_pub.last_update_login,
x_last_update_date => hz_utility_pub.last_update_date,
x_last_updated_by => hz_utility_pub.last_updated_by,
x_request_id => hz_utility_pub.request_id,
x_program_application_id => hz_utility_pub.program_application_id,
x_program_id => hz_utility_pub.program_id,
x_program_update_date => hz_utility_pub.program_update_date,
x_wh_udpate_id => p_financial_reports_rec.wh_udpate_id,
x_report_start_date => p_financial_reports_rec.report_start_date,
x_report_end_date => p_financial_reports_rec.report_end_date,
x_audit_ind => p_financial_reports_rec.audit_ind,
x_consolidated_ind => p_financial_reports_rec.consolidated_ind,
x_estimated_ind => p_financial_reports_rec.estimated_ind,
x_fiscal_ind => p_financial_reports_rec.fiscal_ind,
x_final_ind => p_financial_reports_rec.final_ind,
x_forecast_ind => p_financial_reports_rec.forecast_ind,
x_opening_ind => p_financial_reports_rec.opening_ind,
x_proforma_ind => p_financial_reports_rec.proforma_ind,
x_qualified_ind => p_financial_reports_rec.qualified_ind,
x_restated_ind => p_financial_reports_rec.restated_ind,
x_signed_by_principals_ind => p_financial_reports_rec.signed_by_principals_ind,
x_trial_balance_ind => p_financial_reports_rec.trial_balance_ind,
x_unbalanced_ind => p_financial_reports_rec.unbalanced_ind,
x_content_source_type => p_financial_reports_rec.content_source_type ,
x_status => p_financial_reports_rec.status,
x_actual_content_source => p_financial_reports_rec.actual_content_source
);
g_fin_is_datasource_selected = 'Y'
THEN
hz_org_info_crmhk.create_financial_reports_post(
p_financial_reports_rec,
x_return_status,
x_msg_count,
x_msg_data);
| do_update_financial_reports
|
| DESCRIPTION
| Updates financial reports.
|
| SCOPE - PRIVATE
|
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
|
| ARGUMENTS : IN:
| OUT:
| IN/ OUT:
| p_financial_reports_rec
| p_last_update_date
| x_return_status
|
| RETURNS : NONE
|
| NOTES
|
| MODIFICATION HISTORY
| Jianying Huang 06-OCT-00 Bug 1428526: make *_rec parameters as
| 'IN OUT' in order to pass the changed record
| to caller.
| 01-03-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 do_update_financial_reports(
p_financial_reports_rec IN OUT NOCOPY financial_reports_rec_type,
p_last_update_date IN OUT NOCOPY DATE,
x_return_status IN OUT NOCOPY VARCHAR2
) IS
l_rowid ROWID := NULL;
l_last_update_date DATE;
IF p_last_update_date IS NULL OR
p_last_update_date = FND_API.G_MISS_DATE
THEN
FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');
SELECT rowid, last_update_date
INTO l_rowid, l_last_update_date
FROM hz_financial_reports
where financial_report_id = p_financial_reports_rec.financial_report_id
AND to_char(last_update_date, 'DD-MON-YYYY HH:MI:SS') =
to_char(p_last_update_date, 'DD-MON-YYYY HH:MI:SS')
FOR UPDATE NOWAIT;
g_fin_is_datasource_selected = 'Y'
THEN
hz_org_info_crmhk.update_financial_reports_pre(
p_financial_reports_rec,
x_return_status,
x_msg_count,
x_msg_data);
'HZ_ORG_INFO_CRMHK.UPDATE_FINANCIAL_REPORTS_PRE');
p_last_update_date := hz_utility_pub.LAST_UPDATE_DATE;
HZ_FINANCIAL_REPORTS_PKG.UPDATE_ROW(
x_rowid => l_rowid,
x_financial_report_id => p_financial_reports_rec.financial_report_id,
x_date_report_issued => p_financial_reports_rec.date_report_issued,
x_party_id => p_financial_reports_rec.party_id,
x_document_reference => p_financial_reports_rec.document_reference,
x_issued_period => p_financial_reports_rec.issued_period,
x_requiring_authority => p_financial_reports_rec.requiring_authority,
x_type_of_financial_report => p_financial_reports_rec.type_of_financial_report,
x_created_by => fnd_api.g_miss_num,
x_creation_date => fnd_api.g_miss_date,
x_last_update_login => hz_utility_pub.last_update_login,
x_last_update_date => p_last_update_date,
x_last_updated_by => hz_utility_pub.last_updated_by,
x_request_id => hz_utility_pub.request_id,
x_program_application_id => hz_utility_pub.program_application_id,
x_program_id => hz_utility_pub.program_id,
x_program_update_date => hz_utility_pub.program_update_date,
x_wh_udpate_id => p_financial_reports_rec.wh_udpate_id,
x_report_start_date => p_financial_reports_rec.report_start_date,
x_report_end_date => p_financial_reports_rec.report_end_date,
x_audit_ind => p_financial_reports_rec.audit_ind,
x_consolidated_ind => p_financial_reports_rec.consolidated_ind,
x_estimated_ind => p_financial_reports_rec.estimated_ind,
x_fiscal_ind => p_financial_reports_rec.fiscal_ind,
x_final_ind => p_financial_reports_rec.final_ind,
x_forecast_ind => p_financial_reports_rec.forecast_ind,
x_opening_ind => p_financial_reports_rec.opening_ind,
x_proforma_ind => p_financial_reports_rec.proforma_ind,
x_qualified_ind => p_financial_reports_rec.qualified_ind,
x_restated_ind => p_financial_reports_rec.restated_ind,
x_signed_by_principals_ind => p_financial_reports_rec.signed_by_principals_ind,
x_trial_balance_ind => p_financial_reports_rec.trial_balance_ind,
x_unbalanced_ind => p_financial_reports_rec.unbalanced_ind,
-- bug 2197181 : content_source_type is obsolete and it is non-updateable.
x_content_source_type => fnd_api.g_miss_char,
x_status =>p_financial_reports_rec.status,
x_actual_content_source => p_financial_reports_rec.actual_content_source
);
g_fin_is_datasource_selected = 'Y'
THEN
hz_org_info_crmhk.update_financial_reports_post(
p_financial_reports_rec,
x_return_status,
x_msg_count,
x_msg_data);
'HZ_ORG_INFO_CRMHK.UPDATE_FINANCIAL_REPORTS_POST');
END do_update_financial_reports;
| select/de-select data-sources is obsoleted.
+===========================================================================*/
procedure do_create_financial_numbers(
p_financial_numbers_rec IN OUT NOCOPY financial_numbers_rec_type,
x_financial_number_id OUT NOCOPY NUMBER,
x_return_status IN OUT NOCOPY VARCHAR2
) IS
l_financial_number_id NUMBER := p_financial_numbers_rec.financial_number_id;
SELECT hz_financial_numbers_s.nextval
INTO l_financial_number_id from dual;
SELECT count(*)
INTO l_count
FROM HZ_FINANCIAL_NUMBERS
WHERE financial_number_id = l_financial_number_id;
SELECT count(*)
INTO l_count
FROM HZ_FINANCIAL_NUMBERS
WHERE financial_number_id = l_financial_number_id;
* 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.
g_fin_is_datasource_selected :=
HZ_MIXNM_UTILITY.isDataSourceSelected (
p_selected_datasources => g_fin_selected_datasources,
p_actual_content_source => l_rep_actual_content_source );
g_fin_is_datasource_selected = 'Y'
THEN
hz_org_info_crmhk.create_financial_numbers_pre(
p_financial_numbers_rec,
x_return_status,
x_msg_count,
x_msg_data);
HZ_FINANCIAL_NUMBERS_PKG.INSERT_ROW(
x_rowid => l_rowid,
x_financial_number_id => p_financial_numbers_rec.financial_number_id,
x_financial_report_id => p_financial_numbers_rec.financial_report_id,
x_financial_number => p_financial_numbers_rec.financial_number,
x_financial_number_name => p_financial_numbers_rec.financial_number_name,
x_financial_units_applied => p_financial_numbers_rec.financial_units_applied,
x_financial_number_currency => p_financial_numbers_rec.financial_number_currency,
x_projected_actual_flag => p_financial_numbers_rec.projected_actual_flag,
x_created_by => hz_utility_pub.created_by,
x_creation_date => hz_utility_pub.creation_date,
x_last_update_login => hz_utility_pub.last_update_login,
x_last_update_date => hz_utility_pub.last_update_date,
x_last_updated_by => hz_utility_pub.last_updated_by,
x_request_id => hz_utility_pub.request_id,
x_program_application_id => hz_utility_pub.program_application_id,
x_program_id => hz_utility_pub.program_id,
x_program_update_date => hz_utility_pub.program_update_date,
x_wh_update_date => p_financial_numbers_rec.wh_update_date,
x_content_source_type => l_rep_content_source_type,
x_status => p_financial_numbers_rec.status,
x_actual_content_source => l_rep_actual_content_source
);
g_fin_is_datasource_selected = 'Y'
THEN
hz_org_info_crmhk.create_financial_numbers_post(
p_financial_numbers_rec,
x_return_status,
x_msg_count,
x_msg_data);
| do_update_financial_numbers
|
| DESCRIPTION
| Updates financial numbers.
|
| SCOPE - PRIVATE
|
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
|
| ARGUMENTS : IN:
| OUT:
| IN/ OUT:
| p_financial_numbers_rec
| p_last_update_date
| x_return_status
|
| RETURNS : NONE
|
| NOTES
|
| MODIFICATION HISTORY
| Jianying Huang 06-OCT-00 Bug 1428526: make *_rec parameters as
| 'IN OUT' in order to pass the changed record
| to caller.
| 01-03-2005 Rajib Ranjan Borah o SSM SST Integration and Extension.
| For non-profile entities, the concept of
| select/de-select data-sources is obsoleted.
| o Updateability will be checked according to the
| rules setup for the same instead of program controlled
| profile values.
+===========================================================================*/
procedure do_update_financial_numbers(
p_financial_numbers_rec IN OUT NOCOPY financial_numbers_rec_type,
p_last_update_date IN OUT NOCOPY DATE,
x_return_status IN OUT NOCOPY VARCHAR2
) IS
l_last_update_date DATE;
IF p_last_update_date IS NULL OR
p_last_update_date = FND_API.G_MISS_DATE
THEN
FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');
SELECT rowid, last_update_date, actual_content_source
INTO l_rowid, l_last_update_date, db_actual_content_source
FROM HZ_FINANCIAL_NUMBERS
WHERE financial_number_id = p_financial_numbers_rec.financial_number_id
AND to_char(last_update_date, 'DD-MON-YYYY HH:MI:SS') =
to_char(p_last_update_date, 'DD-MON-YYYY HH:MI:SS')
FOR UPDATE NOWAIT;
HZ_MIXNM_UTILITY.CheckUserUpdatePrivilege (
p_actual_content_source => db_actual_content_source,
p_new_actual_content_source => G_MISS_CONTENT_SOURCE_TYPE,
p_entity_name => 'HZ_FINANCIAL_REPORTS',
x_return_status => x_return_status );
* 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.
g_fin_is_datasource_selected :=
HZ_MIXNM_UTILITY.isDataSourceSelected (
p_selected_datasources => g_fin_selected_datasources,
p_actual_content_source => db_actual_content_source );
g_fin_is_datasource_selected = 'Y'
THEN
hz_org_info_crmhk.update_financial_numbers_pre(
p_financial_numbers_rec,
x_return_status,
x_msg_count,
x_msg_data);
'HZ_ORG_INFO_CRMHK.UPDATE_FINANCIAL_NUMBERS_PRE');
p_last_update_date := hz_utility_pub.LAST_UPDATE_DATE;
HZ_FINANCIAL_NUMBERS_PKG.UPDATE_ROW(
x_rowid => l_rowid,
x_financial_number_id => p_financial_numbers_rec.financial_number_id,
x_financial_report_id => p_financial_numbers_rec.financial_report_id,
x_financial_number => p_financial_numbers_rec.financial_number,
x_financial_number_name => p_financial_numbers_rec.financial_number_name,
x_financial_units_applied => p_financial_numbers_rec.financial_units_applied,
x_financial_number_currency => p_financial_numbers_rec.financial_number_currency,
x_projected_actual_flag => p_financial_numbers_rec.projected_actual_flag,
x_created_by => fnd_api.g_miss_num,
x_creation_date => fnd_api.g_miss_date,
x_last_update_login => hz_utility_pub.last_update_login,
x_last_update_date => p_last_update_date,
x_last_updated_by => hz_utility_pub.last_updated_by,
x_request_id => hz_utility_pub.request_id,
x_program_application_id => hz_utility_pub.program_application_id,
x_program_id => hz_utility_pub.program_id,
x_program_update_date => hz_utility_pub.program_update_date,
x_wh_update_date => p_financial_numbers_rec.wh_update_date,
-- bug 2197181 : content_source_type is obsolete and it is non-updateable.
x_content_source_type => fnd_api.g_miss_char,
x_status => p_financial_numbers_rec.status,
-- bug 2197181 : actual_content_source is non-updateable.
x_actual_content_source => fnd_api.g_miss_char
);
g_fin_is_datasource_selected = 'Y'
THEN
hz_org_info_crmhk.update_financial_numbers_post(
p_financial_numbers_rec,
x_return_status,
x_msg_count,
x_msg_data);
'HZ_ORG_INFO_CRMHK.UPDATE_FINANCIAL_NUMBERS_POST');
END do_update_financial_numbers;
SELECT hz_certifications_s.nextval
INTO l_certification_id from dual;
SELECT count(*)
INTO l_count
FROM HZ_CERTIFICATIONS
WHERE certification_id = l_certification_id;
SELECT count(*)
INTO l_count
FROM HZ_CERTIFICATIONS
WHERE certification_id = l_certification_id;
HZ_CERTIFICATIONS_PKG.INSERT_ROW(
X_Rowid => l_rowid,
X_CERTIFICATION_ID => p_certifications_rec.certification_id,
X_CERTIFICATION_NAME => p_certifications_rec.CERTIFICATION_NAME,
X_CURRENT_STATUS => p_certifications_rec.CURRENT_STATUS,
X_PARTY_ID => p_certifications_rec.PARTY_ID,
X_EXPIRES_ON_DATE => p_certifications_rec.EXPIRES_ON_DATE,
X_GRADE => p_certifications_rec.GRADE,
X_ISSUED_BY_AUTHORITY => p_certifications_rec.ISSUED_BY_AUTHORITY,
X_ISSUED_ON_DATE => p_certifications_rec.ISSUED_ON_DATE,
X_CREATED_BY => hz_utility_pub.CREATED_BY,
X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
X_WH_UPDATE_DATE => p_certifications_rec.WH_UPDATE_DATE,
X_STATUS => p_certifications_rec.STATUS
);
| do_update_certifications
|
| DESCRIPTION
| Updates certifications.
|
| SCOPE - PRIVATE
|
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
|
| ARGUMENTS : IN:
| OUT:
| IN/ OUT:
| p_certifications_rec
| p_last_update_date
| x_return_status
|
| RETURNS : NONE
|
| NOTES
|
| MODIFICATION HISTORY
| Jianying Huang 06-OCT-00 Bug 1428526: make *_rec parameters as
| 'IN OUT' in order to pass the changed record
| to caller.
|
+===========================================================================*/
procedure do_update_certifications(
p_certifications_rec IN OUT NOCOPY certifications_rec_type,
p_last_update_date IN OUT NOCOPY DATE,
x_return_status IN OUT NOCOPY VARCHAR2
) IS
l_rowid ROWID := NULL;
l_last_update_date DATE;
IF p_last_update_date IS NULL OR
p_last_update_date = FND_API.G_MISS_DATE
THEN
FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');
SELECT rowid, last_update_date
INTO l_rowid, l_last_update_date
FROM HZ_CERTIFICATIONS
where certification_id
= p_certifications_rec.certification_id
AND to_char(last_update_date, 'DD-MON-YYYY HH:MI:SS') =
to_char(p_last_update_date, 'DD-MON-YYYY HH:MI:SS')
FOR UPDATE NOWAIT;
p_last_update_date := hz_utility_pub.LAST_UPDATE_DATE;
HZ_CERTIFICATIONS_PKG.UPDATE_ROW(
X_Rowid => l_rowid,
X_CERTIFICATION_ID => p_certifications_rec.CERTIFICATION_ID,
X_CERTIFICATION_NAME => p_certifications_rec.CERTIFICATION_NAME,
X_CURRENT_STATUS => p_certifications_rec.CURRENT_STATUS,
X_PARTY_ID => p_certifications_rec.PARTY_ID,
X_EXPIRES_ON_DATE => p_certifications_rec.EXPIRES_ON_DATE,
X_GRADE => p_certifications_rec.GRADE,
X_ISSUED_BY_AUTHORITY => p_certifications_rec.ISSUED_BY_AUTHORITY,
X_ISSUED_ON_DATE => p_certifications_rec.ISSUED_ON_DATE,
X_CREATED_BY => FND_API.G_MISS_NUM,
X_CREATION_DATE => FND_API.G_MISS_DATE,
X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
X_LAST_UPDATE_DATE => p_last_update_date,
X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
X_WH_UPDATE_DATE => p_certifications_rec.WH_UPDATE_DATE,
X_STATUS => p_certifications_rec.STATUS
);
END do_update_certifications;
SELECT hz_industrial_reference_s.nextval
INTO l_industry_reference_id from dual;
SELECT count(*)
INTO l_count
FROM HZ_INDUSTRIAL_REFERENCE
WHERE industry_reference_id = l_industry_reference_id;
SELECT count(*)
INTO l_count
FROM HZ_INDUSTRIAL_REFERENCE
WHERE industry_reference_id = l_industry_reference_id;
HZ_INDUSTRIAL_REFERENCE_PKG.INSERT_ROW(
X_Rowid => l_rowid,
X_INDUSTRY_REFERENCE_ID => p_industrial_reference_rec.industry_reference_id,
X_INDUSTRY_REFERENCE => p_industrial_reference_rec.INDUSTRY_REFERENCE,
X_ISSUED_BY_AUTHORITY => p_industrial_reference_rec.ISSUED_BY_AUTHORITY,
X_NAME_OF_REFERENCE => p_industrial_reference_rec.NAME_OF_REFERENCE,
X_RECOGNIZED_AS_OF_DATE => p_industrial_reference_rec.RECOGNIZED_AS_OF_DATE,
X_CREATED_BY => hz_utility_pub.CREATED_BY,
X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
X_WH_UPDATE_DATE => p_industrial_reference_rec.WH_UPDATE_DATE,
X_PARTY_ID => p_industrial_reference_rec.PARTY_ID,
X_STATUS =>p_industrial_reference_rec.STATUS
);
| do_update_industrial_reference
|
| DESCRIPTION
| Updates industrial reference.
|
| SCOPE - PRIVATE
|
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
|
| ARGUMENTS : IN:
| OUT:
| IN/ OUT:
| p_industrial_reference_rec
| p_last_update_date
| x_return_status
|
| RETURNS : NONE
|
| NOTES
|
| MODIFICATION HISTORY
| Jianying Huang 06-OCT-00 Bug 1428526: make *_rec parameters as
| 'IN OUT' in order to pass the changed record
| to caller.
|
+===========================================================================*/
procedure do_update_industrial_reference(
p_industrial_reference_rec IN OUT NOCOPY industrial_reference_rec_type,
p_last_update_date IN OUT NOCOPY DATE,
x_return_status IN OUT NOCOPY VARCHAR2
) IS
l_rowid ROWID := NULL;
l_last_update_date DATE;
IF p_last_update_date IS NULL OR
p_last_update_date = FND_API.G_MISS_DATE
THEN
FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');
SELECT rowid, last_update_date
INTO l_rowid, l_last_update_date
FROM HZ_INDUSTRIAL_REFERENCE
where industry_reference_id
= p_industrial_reference_rec.industry_reference_id
AND to_char(last_update_date, 'DD-MON-YYYY HH:MI:SS') =
to_char(p_last_update_date, 'DD-MON-YYYY HH:MI:SS')
FOR UPDATE NOWAIT;
p_last_update_date := hz_utility_pub.LAST_UPDATE_DATE;
HZ_INDUSTRIAL_REFERENCE_PKG.UPDATE_ROW(
X_Rowid => l_rowid,
X_INDUSTRY_REFERENCE_ID => p_industrial_reference_rec.INDUSTRY_REFERENCE_ID,
X_INDUSTRY_REFERENCE => p_industrial_reference_rec.INDUSTRY_REFERENCE,
X_ISSUED_BY_AUTHORITY => p_industrial_reference_rec.ISSUED_BY_AUTHORITY,
X_NAME_OF_REFERENCE => p_industrial_reference_rec.NAME_OF_REFERENCE,
X_RECOGNIZED_AS_OF_DATE => p_industrial_reference_rec.RECOGNIZED_AS_OF_DATE,
X_CREATED_BY => FND_API.G_MISS_NUM,
X_CREATION_DATE => FND_API.G_MISS_DATE,
X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
X_LAST_UPDATE_DATE => p_last_update_date,
X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
X_WH_UPDATE_DATE => p_industrial_reference_rec.WH_UPDATE_DATE,
X_PARTY_ID => p_industrial_reference_rec.PARTY_ID,
X_STATUS =>p_industrial_reference_rec.STATUS
);
END do_update_industrial_reference;
SELECT hz_industrial_classes_s.nextval
INTO l_industrial_class_id from dual;
SELECT count(*)
INTO l_count
FROM HZ_INDUSTRIAL_CLASSES
WHERE industrial_class_id = l_industrial_class_id;
SELECT count(*)
INTO l_count
FROM HZ_INDUSTRIAL_CLASSES
WHERE industrial_class_id = l_industrial_class_id;
HZ_INDUSTRIAL_CLASSES_PKG.INSERT_ROW(
X_Rowid => l_rowid,
X_INDUSTRIAL_CLASS_ID => p_industrial_classes_rec.industrial_class_id,
X_INDUSTRIAL_CODE_NAME => p_industrial_classes_rec.INDUSTRIAL_CODE_NAME,
X_CODE_PRIMARY_SEGMENT => p_industrial_classes_rec.CODE_PRIMARY_SEGMENT,
X_INDUSTRIAL_CLASS_SOURCE => p_industrial_classes_rec.INDUSTRIAL_CLASS_SOURCE,
X_CODE_DESCRIPTION => p_industrial_classes_rec.CODE_DESCRIPTION,
X_CREATED_BY => hz_utility_pub.CREATED_BY,
X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
X_WH_UPDATE_DATE => p_industrial_classes_rec.WH_UPDATE_DATE
);
| do_update_industrial_classes
|
| DESCRIPTION
| Updates industrial classes.
|
| SCOPE - PRIVATE
|
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
|
| ARGUMENTS : IN:
| OUT:
| IN/ OUT:
| p_industrial_classes_rec
| p_last_update_date
| x_return_status
|
| RETURNS : NONE
|
| NOTES
|
| MODIFICATION HISTORY
| Jianying Huang 06-OCT-00 Bug 1428526: make *_rec parameters as
| 'IN OUT' in order to pass the changed record
| to caller.
|
+===========================================================================*/
procedure do_update_industrial_classes(
p_industrial_classes_rec IN OUT NOCOPY industrial_classes_rec_type,
p_last_update_date IN OUT NOCOPY DATE,
x_return_status IN OUT NOCOPY VARCHAR2
) IS
l_count NUMBER;
l_last_update_date DATE;
IF p_last_update_date IS NULL OR
p_last_update_date = FND_API.G_MISS_DATE
THEN
FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');
SELECT rowid, last_update_date
INTO l_rowid, l_last_update_date
FROM HZ_INDUSTRIAL_CLASSES
where industrial_class_id
= p_industrial_classes_rec.industrial_class_id
AND to_char(last_update_date, 'DD-MON-YYYY HH:MI:SS') =
to_char(p_last_update_date, 'DD-MON-YYYY HH:MI:SS')
FOR UPDATE NOWAIT;
p_last_update_date := hz_utility_pub.LAST_UPDATE_DATE;
HZ_INDUSTRIAL_CLASSES_PKG.UPDATE_ROW(
X_Rowid => l_rowid,
X_INDUSTRIAL_CLASS_ID => p_industrial_classes_rec.INDUSTRIAL_CLASS_ID,
X_INDUSTRIAL_CODE_NAME => p_industrial_classes_rec.INDUSTRIAL_CODE_NAME,
X_CODE_PRIMARY_SEGMENT => p_industrial_classes_rec.CODE_PRIMARY_SEGMENT,
X_INDUSTRIAL_CLASS_SOURCE => p_industrial_classes_rec.INDUSTRIAL_CLASS_SOURCE,
X_CODE_DESCRIPTION => p_industrial_classes_rec.CODE_DESCRIPTION,
X_CREATED_BY => FND_API.G_MISS_NUM,
X_CREATION_DATE => FND_API.G_MISS_DATE,
X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
X_LAST_UPDATE_DATE => p_last_update_date,
X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
X_WH_UPDATE_DATE => p_industrial_classes_rec.WH_UPDATE_DATE
);
END do_update_industrial_classes;
SELECT
industrial_class_id,
industrial_code_name,
code_primary_segment,
industrial_class_source,
code_description,
wh_update_date
FROM HZ_INDUSTRIAL_CLASSES
WHERE industrial_class_id = p_industrial_class_id;
x_industrial_classes_rec.wh_update_date := lrec.wh_update_date;
SELECT stock_exchange_id,
country_of_residence,
stock_exchange_code,
stock_exchange_name,
wh_update_date
FROM hz_stock_markets
WHERE stock_exchange_id = p_stock_exchange_id;
x_stock_markets_rec.wh_update_date := lrec.wh_update_date;
SELECT security_issued_id ,
estimated_total_amount ,
stock_exchange_id ,
security_issued_class ,
security_issued_name ,
total_amount_in_a_currency,
stock_ticker_symbol ,
security_currency_code ,
begin_date ,
party_id ,
end_date ,
wh_update_date ,
status
FROM hz_security_issued
WHERE security_issued_id = p_security_issued_id;
x_security_issued_rec.wh_update_date := lrec.wh_update_date;
SELECT certification_id ,
certification_name ,
party_id ,
current_status ,
expires_on_date ,
grade ,
issued_by_authority ,
issued_on_date ,
wh_update_date ,
status
FROM hz_certifications
WHERE certification_id = p_certification_id;
x_certifications_rec.wh_update_date := lrec.wh_update_date;
SELECT hz_industrial_class_app_s.nextval
INTO l_code_applied_id from dual;
SELECT count(*)
INTO l_count
FROM HZ_INDUSTRIAL_CLASS_APP
WHERE code_applied_id = l_code_applied_id;
SELECT count(*)
INTO l_count
FROM HZ_INDUSTRIAL_CLASS_APP
WHERE code_applied_id = l_code_applied_id;
HZ_INDUSTRIAL_CLASS_APP_PKG.INSERT_ROW(
X_Rowid => l_rowid,
X_CODE_APPLIED_ID => p_industrial_class_app_rec.code_applied_id,
X_BEGIN_DATE => p_industrial_class_app_rec.BEGIN_DATE,
X_PARTY_ID => p_industrial_class_app_rec.PARTY_ID,
X_END_DATE => p_industrial_class_app_rec.END_DATE,
X_INDUSTRIAL_CLASS_ID => p_industrial_class_app_rec.INDUSTRIAL_CLASS_ID,
X_CREATED_BY => hz_utility_pub.CREATED_BY,
X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
X_WH_UPDATE_DATE => p_industrial_class_app_rec.WH_UPDATE_DATE,
X_CONTENT_SOURCE_TYPE => p_industrial_class_app_rec.CONTENT_SOURCE_TYPE,
X_IMPORTANCE_RANKING => p_industrial_class_app_rec.IMPORTANCE_RANKING
);
| do_update_industrial_class_app
|
| DESCRIPTION
| Updates industrial class app.
|
| SCOPE - PRIVATE
|
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
|
| ARGUMENTS : IN:
| OUT:
| IN/ OUT:
| p_industrial_class_app_rec
| p_last_update_date
| x_return_status
|
| RETURNS : NONE
|
| NOTES
|
| MODIFICATION HISTORY
| Jianying Huang 06-OCT-00 Bug 1428526: make *_rec parameters as
| 'IN OUT' in order to pass the changed record
| to caller.
|
+===========================================================================*/
procedure do_update_industrial_class_app(
p_industrial_class_app_rec IN OUT NOCOPY industrial_class_app_rec_type,
p_last_update_date IN OUT NOCOPY DATE,
x_return_status IN OUT NOCOPY VARCHAR2
) IS
l_count NUMBER;
l_last_update_date DATE;
IF p_last_update_date IS NULL OR
p_last_update_date = FND_API.G_MISS_DATE
THEN
FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');
SELECT rowid, last_update_date
INTO l_rowid, l_last_update_date
FROM HZ_INDUSTRIAL_CLASS_APP
where code_applied_id
= p_industrial_class_app_rec.code_applied_id
AND to_char(last_update_date, 'DD-MON-YYYY HH:MI:SS') =
to_char(p_last_update_date, 'DD-MON-YYYY HH:MI:SS')
FOR UPDATE NOWAIT;
p_last_update_date := hz_utility_pub.LAST_UPDATE_DATE;
HZ_INDUSTRIAL_CLASS_APP_PKG.UPDATE_ROW(
X_Rowid => l_rowid,
X_CODE_APPLIED_ID => p_industrial_class_app_rec.CODE_APPLIED_ID,
X_BEGIN_DATE => p_industrial_class_app_rec.BEGIN_DATE,
X_PARTY_ID => p_industrial_class_app_rec.PARTY_ID,
X_END_DATE => p_industrial_class_app_rec.END_DATE,
X_INDUSTRIAL_CLASS_ID => p_industrial_class_app_rec.INDUSTRIAL_CLASS_ID,
X_CREATED_BY => FND_API.G_MISS_NUM,
X_CREATION_DATE => FND_API.G_MISS_DATE,
X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
X_LAST_UPDATE_DATE => p_last_update_date,
X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
X_WH_UPDATE_DATE => p_industrial_class_app_rec.WH_UPDATE_DATE,
X_CONTENT_SOURCE_TYPE => p_industrial_class_app_rec.CONTENT_SOURCE_TYPE,
X_IMPORTANCE_RANKING => p_industrial_class_app_rec.IMPORTANCE_RANKING
);
END do_update_industrial_class_app;
| update_stock_markets
|
| DESCRIPTION
| Updates stock markets.
|
| SCOPE - PUBLIC
|
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
|
| ARGUMENTS : IN:
| p_api_version
| p_init_msg_list
| p_commit
| p_stock_markets_rec
| p_validation_level
| OUT:
| x_return_status
| x_msg_count
| x_msg_data
| IN/ OUT:
| p_last_update_date
|
| RETURNS : NONE
|
| NOTES
|
| MODIFICATION HISTORY
|
+===========================================================================*/
procedure update_stock_markets(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
p_commit IN VARCHAR2:= FND_API.G_FALSE,
p_stock_markets_rec IN STOCK_MARKETS_REC_TYPE,
p_last_update_date IN OUT NOCOPY DATE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
) IS
l_api_name CONSTANT VARCHAR2(30) := 'update stock markets';
SAVEPOINT update_stock_markets_pub;
hz_org_info_crmhk.update_stock_markets_pre(
l_stock_markets_rec,
x_return_status,
x_msg_count,
x_msg_data);
'HZ_ORG_INFO_CRMHK.UPDATE_STOCK_MARKETS_PRE');
do_update_stock_markets( l_stock_markets_rec,
p_last_update_date,
x_return_status);
hz_org_info_crmhk.update_stock_markets_post(
l_stock_markets_rec,
x_return_status,
x_msg_count,
x_msg_data);
'HZ_ORG_INFO_CRMHK.UPDATE_STOCK_MARKETS_POST');
hz_business_event_v2pvt.update_stock_markets_event(l_stock_markets_rec);
ROLLBACK TO update_stock_markets_pub;
ROLLBACK TO update_stock_markets_pub;
ROLLBACK TO update_stock_markets_pub;
END update_stock_markets;
| update_security_issued
|
| DESCRIPTION
| Updates security issued.
|
| SCOPE - PUBLIC
|
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
|
| ARGUMENTS : IN:
| p_api_version
| p_init_msg_list
| p_commit
| p_security_issued_rec
| p_validation_level
| OUT:
| x_return_status
| x_msg_count
| x_msg_data
| IN/ OUT:
| p_last_update_date
|
| RETURNS : NONE
|
| NOTES
|
| MODIFICATION HISTORY
|
+===========================================================================*/
procedure update_security_issued(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
p_commit IN VARCHAR2:= FND_API.G_FALSE,
p_security_issued_rec IN SECURITY_ISSUED_REC_TYPE,
p_last_update_date IN OUT NOCOPY DATE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
) IS
l_api_name CONSTANT VARCHAR2(30) := 'update security issued';
SAVEPOINT update_security_issued_pub;
hz_org_info_crmhk.update_security_issued_pre(
l_security_issued_rec,
x_return_status,
x_msg_count,
x_msg_data);
'HZ_ORG_INFO_CRMHK.UPDATE_SECURITY_ISSUED_PRE');
do_update_security_issued(l_security_issued_rec,
p_last_update_date,
x_return_status);
hz_org_info_crmhk.update_security_issued_post(
l_security_issued_rec,
x_return_status,
x_msg_count,
x_msg_data);
'HZ_ORG_INFO_CRMHK.UPDATE_SECURITY_ISSUED_POST');
hz_business_event_v2pvt.update_sec_issued_event(l_security_issued_rec);
ROLLBACK TO update_security_issued_pub;
ROLLBACK TO update_security_issued_pub;
ROLLBACK TO update_security_issued_pub;
END update_security_issued;
| select/de-select data-sources is obsoleted.
+===========================================================================
procedure create_financial_reports(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
p_commit IN VARCHAR2:= FND_API.G_FALSE,
p_financial_reports_rec IN FINANCIAL_REPORTS_REC_TYPE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
x_financial_report_id OUT NOCOPY NUMBER,
p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
) IS
l_api_name CONSTANT VARCHAR2(30) := 'create financial reports';
* 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 );
p_selected_datasources => g_fin_selected_datasources,
p_content_source_type => l_financial_reports_rec.content_source_type,
p_actual_content_source => l_financial_reports_rec.actual_content_source,
x_is_datasource_selected => g_fin_is_datasource_selected,
x_return_status => x_return_status,
p_api_version => 'V1');
g_fin_is_datasource_selected = 'Y'
THEN
HZ_BUSINESS_EVENT_V2PVT.create_fin_reports_event(l_financial_reports_rec);
| update_financial_reports
|
| DESCRIPTION
| Updates financial reports.
|
| SCOPE - PUBLIC
|
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
|
| ARGUMENTS : IN:
| p_api_version
| p_init_msg_list
| p_commit
| p_financial_reports_rec
| p_validation_level
| OUT:
| x_return_status
| x_msg_count
| x_msg_data
| IN/ OUT:
| p_last_update_date
|
| RETURNS : NONE
|
| NOTES
|
| MODIFICATION HISTORY
|
| 01-03-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_reports(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
p_commit IN VARCHAR2:= FND_API.G_FALSE,
p_financial_reports_rec IN FINANCIAL_REPORTS_REC_TYPE,
p_last_update_date IN OUT NOCOPY DATE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
) IS
l_api_name CONSTANT VARCHAR2(30) := 'update financial reports';
SAVEPOINT update_financial_reports_pub;
* 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 );
* 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.
g_fin_is_datasource_selected :=
HZ_MIXNM_UTILITY.isDataSourceSelected (
p_selected_datasources => g_fin_selected_datasources,
p_actual_content_source => l_old_financial_reports_rec.actual_content_source );
do_update_financial_reports(
l_financial_reports_rec,
p_last_update_date,
x_return_status);
HZ_ORGANIZATION_INFO_V2PVT.v2_update_financial_report (
l_financial_reports_rec,
p_last_update_date,
x_return_status
);
g_fin_is_datasource_selected = 'Y'
THEN
HZ_BUSINESS_EVENT_V2PVT.update_fin_reports_event(l_financial_reports_rec);
ROLLBACK TO update_financial_reports_pub;
ROLLBACK TO update_financial_reports_pub;
ROLLBACK TO update_financial_reports_pub;
END update_financial_reports;
| select/de-select data-sources is obsoleted.
+===========================================================================
procedure create_financial_numbers(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
p_commit IN VARCHAR2:= FND_API.G_FALSE,
p_financial_numbers_rec IN FINANCIAL_NUMBERS_REC_TYPE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
x_financial_number_id OUT NOCOPY NUMBER,
p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
) IS
l_api_name CONSTANT VARCHAR2(30) := 'create financial numbers';
* 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
HZ_BUSINESS_EVENT_V2PVT.create_fin_numbers_event(l_financial_numbers_rec);
| update_financial_numbers
|
| DESCRIPTION
| Updates financial numbers.
|
| SCOPE - PUBLIC
|
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
|
| ARGUMENTS : IN:
| p_api_version
| p_init_msg_list
| p_commit
| p_financial_numbers_rec
| p_validation_level
| OUT:
| x_return_status
| x_msg_count
| x_msg_data
| IN/ OUT:
| p_last_update_date
|
| RETURNS : NONE
|
| NOTES
|
| MODIFICATION HISTORY
|
| 01-03-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_numbers(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
p_commit IN VARCHAR2:= FND_API.G_FALSE,
p_financial_numbers_rec IN FINANCIAL_NUMBERS_REC_TYPE,
p_last_update_date IN OUT NOCOPY DATE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
) IS
l_api_name CONSTANT VARCHAR2(30) := 'update financial numbers';
SAVEPOINT update_financial_numbers_pub;
* 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_numbers(
l_financial_numbers_rec,
p_last_update_date,
x_return_status);
HZ_ORGANIZATION_INFO_V2PVT.v2_update_financial_number (
l_financial_numbers_rec,
p_last_update_date,
x_return_status
);
g_fin_is_datasource_selected = 'Y'
THEN
HZ_BUSINESS_EVENT_V2PVT.update_fin_numbers_event(l_financial_numbers_rec);
ROLLBACK TO update_financial_numbers_pub;
ROLLBACK TO update_financial_numbers_pub;
ROLLBACK TO update_financial_numbers_pub;
END update_financial_numbers;
| update_certifications
|
| DESCRIPTION
| Updates certifications.
|
| SCOPE - PUBLIC
|
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
|
| ARGUMENTS : IN:
| p_api_version
| p_init_msg_list
| p_commit
| p_certifications_rec
| p_validation_level
| OUT:
| x_return_status
| x_msg_count
| x_msg_data
| IN/ OUT:
| p_last_update_date
|
| RETURNS : NONE
|
| NOTES
|
| MODIFICATION HISTORY
|
+===========================================================================*/
procedure update_certifications(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
p_commit IN VARCHAR2:= FND_API.G_FALSE,
p_certifications_rec IN CERTIFICATIONS_REC_TYPE,
p_last_update_date IN OUT NOCOPY DATE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
) IS
l_api_name CONSTANT VARCHAR2(30) := 'update certifications';
SAVEPOINT update_certifications_pub;
hz_org_info_crmhk.update_certifications_pre(
l_certifications_rec,
x_return_status,
x_msg_count,
x_msg_data);
'HZ_ORG_INFO_CRMHK.UPDATE_CERTIFICATIONS_PRE');
do_update_certifications( l_certifications_rec,
p_last_update_date,
x_return_status);
hz_org_info_crmhk.update_certifications_post(
l_certifications_rec,
x_return_status,
x_msg_count,
x_msg_data);
'HZ_ORG_INFO_CRMHK.UPDATE_CERTIFICATIONS_POST');
hz_business_event_v2pvt.update_certifications_event(l_certifications_rec);
ROLLBACK TO update_certifications_pub;
ROLLBACK TO update_certifications_pub;
ROLLBACK TO update_certifications_pub;
END update_certifications;
| update_industrial_reference
|
| DESCRIPTION
| Updates industrial_reference.
|
| SCOPE - PUBLIC
|
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
|
| ARGUMENTS : IN:
| p_api_version
| p_init_msg_list
| p_commit
| p_industrial_reference_rec
| p_validation_level
| OUT:
| x_return_status
| x_msg_count
| x_msg_data
| IN/ OUT:
| p_last_update_date
|
| RETURNS : NONE
|
| NOTES
|
| MODIFICATION HISTORY
|
+===========================================================================*/
procedure update_industrial_reference(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
p_commit IN VARCHAR2:= FND_API.G_FALSE,
p_industrial_reference_rec IN INDUSTRIAL_REFERENCE_REC_TYPE,
p_last_update_date IN OUT NOCOPY DATE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
) IS
l_api_name CONSTANT VARCHAR2(30) := 'update industrial reference';
SAVEPOINT update_industrial_ref_pub;
hz_org_info_crmhk.update_industrial_ref_pre(
l_industrial_reference_rec,
x_return_status,
x_msg_count,
x_msg_data);
'HZ_ORG_INFO_CRMHK.UPDATE_INDUSTRIAL_REF_PRE');
do_update_industrial_reference( l_industrial_reference_rec,
p_last_update_date,
x_return_status);
hz_org_info_crmhk.update_industrial_ref_post(
l_industrial_reference_rec,
x_return_status,
x_msg_count,
x_msg_data);
'HZ_ORG_INFO_CRMHK.UPDATE_INDUSTRIAL_REF_POST');
ROLLBACK TO update_industrial_ref_pub;
ROLLBACK TO update_industrial_ref_pub;
ROLLBACK TO update_industrial_ref_pub;
END update_industrial_reference;
| update_industrial_classes
|
| DESCRIPTION
| Updates industrial classes.
|
| SCOPE - PUBLIC
|
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
|
| ARGUMENTS : IN:
| p_api_version
| p_init_msg_list
| p_commit
| p_industrial_classes_rec
| p_validation_level
| OUT:
| x_return_status
| x_msg_count
| x_msg_data
| IN/ OUT:
| p_last_update_date
|
| RETURNS : NONE
|
| NOTES
|
| MODIFICATION HISTORY
|
+===========================================================================*/
procedure update_industrial_classes(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
p_commit IN VARCHAR2:= FND_API.G_FALSE,
p_industrial_classes_rec IN INDUSTRIAL_CLASSES_REC_TYPE,
p_last_update_date IN OUT NOCOPY DATE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
) IS
l_api_name CONSTANT VARCHAR2(30) := 'update industrial classes';
SAVEPOINT update_industrial_classes_pub;
hz_org_info_crmhk.update_industrial_classes_pre(
l_industrial_classes_rec,
l_old_industrial_classes_rec,
x_return_status,
x_msg_count,
x_msg_data);
'HZ_ORG_INFO_CRMHK.UPDATE_INDUSTRIAL_CLASSES_PRE');
do_update_industrial_classes( l_industrial_classes_rec,
p_last_update_date,
x_return_status);
hz_org_info_crmhk.update_industrial_classes_post(
l_industrial_classes_rec,
x_return_status,
x_msg_count,
x_msg_data);
'HZ_ORG_INFO_CRMHK.UPDATE_INDUSTRIAL_CLASSES_POST');
ROLLBACK TO update_industrial_classes_pub;
ROLLBACK TO update_industrial_classes_pub;
ROLLBACK TO update_industrial_classes_pub;
END update_industrial_classes;
| update_industrial_class_app
|
| DESCRIPTION
| Updates industrial class app.
|
| SCOPE - PUBLIC
|
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
|
| ARGUMENTS : IN:
| p_api_version
| p_init_msg_list
| p_commit
| p_industrial_class_app_rec
| p_validation_level
| OUT:
| x_return_status
| x_msg_count
| x_msg_data
| IN/ OUT:
| p_last_update_date
|
| RETURNS : NONE
|
| NOTES
|
| MODIFICATION HISTORY
|
+===========================================================================*/
procedure update_industrial_class_app(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
p_commit IN VARCHAR2:= FND_API.G_FALSE,
p_industrial_class_app_rec IN INDUSTRIAL_CLASS_APP_REC_TYPE,
p_last_update_date IN OUT NOCOPY DATE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
) IS
l_api_name CONSTANT VARCHAR2(30) := 'update industrial class app';
SAVEPOINT update_indus_class_app_pub;
hz_org_info_crmhk.update_indus_class_app_pre(
l_industrial_class_app_rec,
x_return_status,
x_msg_count,
x_msg_data);
do_update_industrial_class_app( l_industrial_class_app_rec,
p_last_update_date,
x_return_status);
hz_org_info_crmhk.update_indus_class_app_post(
l_industrial_class_app_rec,
x_return_status,
x_msg_count,
x_msg_data);
'HZ_ORG_INFO_CRMHK.UPDATE_INDUS_CLASS_APP_POST');
ROLLBACK TO update_indus_class_app_pub;
ROLLBACK TO update_indus_class_app_pub;
ROLLBACK TO update_indus_class_app_pub;
END update_industrial_class_app;
BEGIN /* Just for select statement */
SELECT
financial_report_id,
date_report_issued,
party_id,
document_reference,
issued_period,
requiring_authority,
type_of_financial_report,
wh_udpate_id,
report_start_date,
report_end_date,
audit_ind,
consolidated_ind,
estimated_ind,
fiscal_ind,
final_ind,
forecast_ind,
opening_ind,
proforma_ind,
qualified_ind,
restated_ind,
signed_by_principals_ind,
trial_balance_ind,
unbalanced_ind,
content_source_type,
status,
actual_content_source
INTO
x_financial_reports_rec.financial_report_id,
x_financial_reports_rec.date_report_issued,
x_financial_reports_rec.party_id,
x_financial_reports_rec.document_reference,
x_financial_reports_rec.issued_period,
x_financial_reports_rec.requiring_authority,
x_financial_reports_rec.type_of_financial_report,
x_financial_reports_rec.wh_udpate_id,
x_financial_reports_rec.report_start_date,
x_financial_reports_rec.report_end_date,
x_financial_reports_rec.audit_ind,
x_financial_reports_rec.consolidated_ind,
x_financial_reports_rec.estimated_ind,
x_financial_reports_rec.fiscal_ind,
x_financial_reports_rec.final_ind,
x_financial_reports_rec.forecast_ind,
x_financial_reports_rec.opening_ind,
x_financial_reports_rec.proforma_ind,
x_financial_reports_rec.qualified_ind,
x_financial_reports_rec.restated_ind,
x_financial_reports_rec.signed_by_principals_ind,
x_financial_reports_rec.trial_balance_ind,
x_financial_reports_rec.unbalanced_ind,
x_financial_reports_rec.content_source_type,
x_financial_reports_rec.status,
x_financial_reports_rec.actual_content_source
FROM hz_financial_reports
WHERE financial_report_id = p_financial_report_id;
BEGIN /* Just for select statement */
SELECT
financial_number_id,
financial_report_id,
financial_number,
financial_number_name,
financial_units_applied,
financial_number_currency,
projected_actual_flag,
wh_update_date,
content_source_type,
status
INTO
x_financial_numbers_rec.financial_number_id,
x_financial_numbers_rec.financial_report_id,
x_financial_numbers_rec.financial_number,
x_financial_numbers_rec.financial_number_name,
x_financial_numbers_rec.financial_units_applied,
x_financial_numbers_rec.financial_number_currency,
x_financial_numbers_rec.projected_actual_flag,
x_financial_numbers_rec.wh_update_date,
x_financial_numbers_rec.content_source_type,
x_financial_numbers_rec.status
FROM hz_financial_numbers
WHERE financial_number_id = p_financial_number_id;