DBA Data[Home] [Help]

APPS.HZ_ORGANIZATION_INFO_V2PUB dependencies on HZ_FINANCIAL_REPORTS

Line 163: HZ_FINANCIAL_REPORTS_PKG.Insert_Row (

159:
160: --Bug 2490399: Added final_ind in financial_report_rec_type. Hence passing
161: --the final_ind value instead of fnd_api.g_miss_char.
162: -- call table handler to insert a row
163: HZ_FINANCIAL_REPORTS_PKG.Insert_Row (
164: x_ROWID => l_rowid,
165: x_FINANCIAL_REPORT_ID => p_financial_report_rec.financial_report_id,
166: x_DATE_REPORT_ISSUED => p_financial_report_rec.date_report_issued,
167: x_PARTY_ID => p_financial_report_rec.party_id,

Line 208: l_acs HZ_FINANCIAL_REPORTS.actual_content_source%TYPE;

204: l_rowid ROWID := NULL;
205: l_object_version_number NUMBER;
206: l_party_id NUMBER;
207: -- Bug 4693719 : Added for local assignment
208: l_acs HZ_FINANCIAL_REPORTS.actual_content_source%TYPE;
209: db_actual_content_source HZ_FINANCIAL_REPORTS.actual_content_source%TYPE;
210:
211: BEGIN
212:

Line 209: db_actual_content_source HZ_FINANCIAL_REPORTS.actual_content_source%TYPE;

205: l_object_version_number NUMBER;
206: l_party_id NUMBER;
207: -- Bug 4693719 : Added for local assignment
208: l_acs HZ_FINANCIAL_REPORTS.actual_content_source%TYPE;
209: db_actual_content_source HZ_FINANCIAL_REPORTS.actual_content_source%TYPE;
210:
211: BEGIN
212:
213: -- check whether record has been updated by another user

Line 219: FROM HZ_FINANCIAL_REPORTS

215: -- check object_version_number
216: -- Bug 4693719 : add ACS in select
217: SELECT rowid, object_version_number, party_id, actual_content_source
218: INTO l_rowid, l_object_version_number, l_party_id, db_actual_content_source
219: FROM HZ_FINANCIAL_REPORTS
220: WHERE financial_report_id = p_financial_report_rec.financial_report_id
221: FOR UPDATE NOWAIT;
222:
223: IF NOT

Line 234: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_FINANCIAL_REPORTS');

230: )
231: )
232: THEN
233: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
234: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_FINANCIAL_REPORTS');
235: FND_MSG_PUB.ADD;
236: RAISE FND_API.G_EXC_ERROR;
237: END IF;
238:

Line 244: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_FINANCIAL_REPORTS');

240:
241: EXCEPTION
242: WHEN NO_DATA_FOUND THEN
243: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
244: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_FINANCIAL_REPORTS');
245: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_financial_report_rec.financial_report_id ), 'null' ) );
246: FND_MSG_PUB.ADD;
247: RAISE FND_API.G_EXC_ERROR;
248: END;

Line 272: HZ_FINANCIAL_REPORTS_PKG.Update_Row (

268:
269: --Bug 2490399: Added final_ind in financial_report_rec_type. Hence passing
270: --the final_ind value instead of fnd_api.g_miss_char.
271: -- call table handler to update a row
272: HZ_FINANCIAL_REPORTS_PKG.Update_Row (
273: x_ROWID => l_rowid,
274: x_FINANCIAL_REPORT_ID => p_financial_report_rec.financial_report_id,
275: x_DATE_REPORT_ISSUED => p_financial_report_rec.date_report_issued,
276: x_PARTY_ID => p_financial_report_rec.party_id,

Line 364: p_entity_name => 'HZ_FINANCIAL_REPORTS',

360:
361: -- Bug 4225452.
362: IF l_acual_content_source = G_MISS_CONTENT_SOURCE_TYPE THEN
363: HZ_MIXNM_UTILITY.CheckUserCreationPrivilege (
364: p_entity_name => 'HZ_FINANCIAL_REPORTS',
365: p_entity_attr_id => g_fin_entity_attr_id,
366: p_mixnmatch_enabled => g_fin_mixnmatch_enabled,
367: p_actual_content_source => l_acual_content_source,
368: x_return_status => x_return_status );

Line 614: p_entity_name => 'HZ_FINANCIAL_REPORTS',

610: /* SSM SST Integration and Extension
611: For non-profile entities, the concept of select/de-select data-sources is obsoleted.
612:
613: HZ_MIXNM_UTILITY.LoadDataSources(
614: p_entity_name => 'HZ_FINANCIAL_REPORTS',
615: p_entity_attr_id => g_fin_entity_attr_id,
616: p_mixnmatch_enabled => g_fin_mixnmatch_enabled,
617: p_selected_datasources => g_fin_selected_datasources );
618: */

Line 620: p_entity_name => 'HZ_FINANCIAL_REPORTS',

616: p_mixnmatch_enabled => g_fin_mixnmatch_enabled,
617: p_selected_datasources => g_fin_selected_datasources );
618: */
619: HZ_MIXNM_UTILITY.AssignDataSourceDuringCreation (
620: p_entity_name => 'HZ_FINANCIAL_REPORTS',
621: p_entity_attr_id => g_fin_entity_attr_id,
622: p_mixnmatch_enabled => g_fin_mixnmatch_enabled,
623: p_selected_datasources => g_fin_selected_datasources,
624: p_content_source_type => g_miss_content_source_type,

Line 656: HZ_POPULATE_BOT_PKG.pop_hz_financial_reports(

652: l_financial_report_rec );
653: END IF;
654:
655: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
656: HZ_POPULATE_BOT_PKG.pop_hz_financial_reports(
657: p_operation => 'I',
658: p_financial_report_id => x_financial_report_id);
659: END IF;
660: END IF;

Line 779: p_entity_name => 'HZ_FINANCIAL_REPORTS',

775: * For non-profile entities, the concept of select/de-select data-sources is obsoleted.
776: * There is no need to check if the data-source is selected.
777:
778: HZ_MIXNM_UTILITY.LoadDataSources(
779: p_entity_name => 'HZ_FINANCIAL_REPORTS',
780: p_entity_attr_id => g_fin_entity_attr_id,
781: p_mixnmatch_enabled => g_fin_mixnmatch_enabled,
782: p_selected_datasources => g_fin_selected_datasources );
783:

Line 812: HZ_POPULATE_BOT_PKG.pop_hz_financial_reports(

808: l_old_fin_report_rec );
809: END IF;
810:
811: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
812: HZ_POPULATE_BOT_PKG.pop_hz_financial_reports(
813: p_operation => 'U',
814: p_financial_report_id => l_financial_report_rec.financial_report_id);
815: END IF;
816: END IF;

Line 865: * HZ_FINANCIAL_REPORTS_PKG.Select_Row

861: * DESCRIPTION
862: * Gets financial report record.
863: *
864: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
865: * HZ_FINANCIAL_REPORTS_PKG.Select_Row
866: *
867: * ARGUMENTS
868: * IN:
869: * p_init_msg_list Initialize message stack if it is set to

Line 924: HZ_FINANCIAL_REPORTS_PKG.Select_Row (

920: p_financial_report_rec.financial_report_id := p_financial_report_id;
921:
922: --Bug 2490399: Added final_ind in financial_report_rec_type. Hence changing the call to
923: --select_row.
924: HZ_FINANCIAL_REPORTS_PKG.Select_Row (
925: x_financial_report_id => p_financial_report_rec.financial_report_id,
926: x_date_report_issued => p_financial_report_rec.date_report_issued,
927: x_party_id => p_financial_report_rec.party_id,
928: x_document_reference => p_financial_report_rec.document_reference,

Line 1056: p_entity_name => 'HZ_FINANCIAL_REPORTS',

1052: * For non-profile entities, the concept of select/de-select data-sources is obsoleted.
1053: * There is no need to check if the data-source is selected.
1054:
1055: HZ_MIXNM_UTILITY.LoadDataSources(
1056: p_entity_name => 'HZ_FINANCIAL_REPORTS',
1057: p_entity_attr_id => g_fin_entity_attr_id,
1058: p_mixnmatch_enabled => g_fin_mixnmatch_enabled,
1059: p_selected_datasources => g_fin_selected_datasources );
1060: */

Line 1205: p_entity_name => 'HZ_FINANCIAL_REPORTS',

1201: * For non-profile entities, the concept of select/de-select data-sources is obsoleted.
1202: * There is no need to check if the data-source is selected.
1203:
1204: HZ_MIXNM_UTILITY.LoadDataSources(
1205: p_entity_name => 'HZ_FINANCIAL_REPORTS',
1206: p_entity_attr_id => g_fin_entity_attr_id,
1207: p_mixnmatch_enabled => g_fin_mixnmatch_enabled,
1208: p_selected_datasources => g_fin_selected_datasources );
1209: */