APPS.HZ_ORG_INFO_VALIDATE dependencies on HZ_FINANCIAL_REPORTS

Line 221: l_content_source_type hz_financial_reports.content_source_type%TYPE;

217: l_count NUMBER;
218: l_party_id NUMBER;
219: l_report_start_date DATE;
220: l_report_end_date DATE;
221: l_content_source_type hz_financial_reports.content_source_type%TYPE;
222: db_actual_content_source hz_financial_reports.actual_content_source%TYPE;
223:
224: BEGIN
225:

Line 222: db_actual_content_source hz_financial_reports.actual_content_source%TYPE;

218: l_party_id NUMBER;
219: l_report_start_date DATE;
220: l_report_end_date DATE;
221: l_content_source_type hz_financial_reports.content_source_type%TYPE;
222: db_actual_content_source hz_financial_reports.actual_content_source%TYPE;
223:
224: BEGIN
225:
226: -- mandatory fields

Line 248: FROM HZ_FINANCIAL_REPORTS

244: SELECT party_id,report_start_date,
245: report_end_date, content_source_type, actual_content_source
246: INTO l_party_id, l_report_start_date,
247: l_report_end_date, l_content_source_type, db_actual_content_source
248: FROM HZ_FINANCIAL_REPORTS
249: WHERE financial_report_id= p_financial_reports_rec.financial_report_id;
250:
251: IF p_financial_reports_rec.party_id <> FND_API.G_MISS_NUM OR
252: p_financial_reports_rec.report_end_date <> FND_API.G_MISS_DATE OR

Line 387: -- Pass HZ_FINANCIAL_REPORTS for new parameter p_entity_name

383: ----------------------------------------
384: -- validate content_source_type and actual_content_source_type
385: ----------------------------------------
386: -- SSM SST Integration and Extension
387: -- Pass HZ_FINANCIAL_REPORTS for new parameter p_entity_name
388: HZ_MIXNM_UTILITY.ValidateContentSource (
389: p_api_version => 'V1',
390: p_create_update_flag => p_create_update_flag,
391: p_check_update_privilege => 'Y',

Line 396: p_entity_name => 'HZ_FINANCIAL_REPORTS',

392: p_content_source_type => p_financial_reports_rec.content_source_type,
393: p_old_content_source_type => l_content_source_type,
394: p_actual_content_source => p_financial_reports_rec.actual_content_source,
395: p_old_actual_content_source => db_actual_content_source,
396: p_entity_name => 'HZ_FINANCIAL_REPORTS',
397: x_return_status => x_return_status );
398:
399: --Status Validation
400: hz_common_pub.validate_lookup('REGISTRY_STATUS','status',p_financial_reports_rec.status,x_return_status);

Line 454: -- foreign keys: financial_report_id to HZ_FINANCIAL_REPORTS table

450: END IF;
451:
452: END IF;
453:
454: -- foreign keys: financial_report_id to HZ_FINANCIAL_REPORTS table
455:
456: IF p_financial_numbers_rec.financial_report_id is NOT NULL AND
457: p_financial_numbers_rec.financial_report_id <> FND_API.G_MISS_NUM THEN
458:

Line 462: FROM HZ_FINANCIAL_REPORTS

458:
459: BEGIN
460: SELECT content_source_type, actual_content_source
461: INTO x_rep_content_source_type, x_rep_actual_content_source
462: FROM HZ_FINANCIAL_REPORTS
463: where financial_report_id = p_financial_numbers_rec.financial_report_id;
464:
465: EXCEPTION WHEN NO_DATA_FOUND THEN
466: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

Line 469: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_financial_reports');

465: EXCEPTION WHEN NO_DATA_FOUND THEN
466: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
467: FND_MESSAGE.SET_TOKEN('FK', 'financial_report_id');
468: FND_MESSAGE.SET_TOKEN('COLUMN', 'financial_report_id');
469: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_financial_reports');
470: FND_MSG_PUB.ADD;
471: x_return_status := FND_API.G_RET_STS_ERROR;
472:
473: END;