APPS.HZ_ORGANIZATION_INFO_V2PUB dependencies on HZ_FINANCIAL_NUMBERS

Line 345: l_acual_content_source HZ_FINANCIAL_NUMBERS.actual_content_source%TYPE;

341: ) IS
342:
343: l_dummy VARCHAR2(1);
344: l_rowid ROWID;
345: l_acual_content_source HZ_FINANCIAL_NUMBERS.actual_content_source%TYPE;
346:
347: BEGIN
348:
349: -- validate financial number record

Line 376: HZ_FINANCIAL_NUMBERS_PKG.Insert_Row (

372: END IF;
373: END IF;
374:
375: -- call table handler to insert a row
376: HZ_FINANCIAL_NUMBERS_PKG.Insert_Row (
377: x_rowid => l_rowid,
378: x_financial_number_id => p_financial_number_rec.financial_number_id,
379: x_financial_report_id => p_financial_number_rec.financial_report_id,
380: x_financial_number => p_financial_number_rec.financial_number,

Line 437: l_acual_content_source HZ_FINANCIAL_NUMBERS.actual_content_source%TYPE;

433: ) IS
434:
435: l_rowid ROWID := NULL;
436: l_object_version_number NUMBER;
437: l_acual_content_source HZ_FINANCIAL_NUMBERS.actual_content_source%TYPE;
438: g_cre_mixnmatch_enabled VARCHAR2(1);
439: g_cre_selected_datasources VARCHAR2(255);
440: g_cre_is_datasource_selected VARCHAR2(1) := 'N';
441: g_cre_entity_attr_id NUMBER;

Line 450: FROM HZ_financial_numbers

446: BEGIN
447: -- check object_version_number
448: SELECT rowid, object_version_number
449: INTO l_rowid, l_object_version_number
450: FROM HZ_financial_numbers
451: WHERE financial_number_id = p_financial_number_rec.financial_number_id
452: FOR UPDATE NOWAIT;
453:
454: IF NOT

Line 465: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_FINANCIAL_NUMBERS');

461: )
462: )
463: THEN
464: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
465: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_FINANCIAL_NUMBERS');
466: FND_MSG_PUB.ADD;
467: RAISE FND_API.G_EXC_ERROR;
468: END IF;
469:

Line 475: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_FINANCIAL_NUMBERS');

471:
472: EXCEPTION
473: WHEN NO_DATA_FOUND THEN
474: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
475: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_FINANCIAL_NUMBERS');
476: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_financial_number_rec.financial_number_id ), 'null' ) );
477: FND_MSG_PUB.ADD;
478: RAISE FND_API.G_EXC_ERROR;
479: END;

Line 519: HZ_FINANCIAL_NUMBERS_PKG.Update_Row (

515: p_api_version => 'V2');
516: */
517:
518: -- call table handler to update a row
519: HZ_FINANCIAL_NUMBERS_PKG.Update_Row (
520: x_rowid => l_rowid,
521: x_financial_number_id => p_financial_number_rec.financial_number_id,
522: x_financial_report_id => p_financial_number_rec.financial_report_id,
523: x_financial_number => p_financial_number_rec.financial_number,

Line 1083: HZ_POPULATE_BOT_PKG.pop_hz_financial_numbers(

1079: l_financial_number_rec );
1080: END IF;
1081:
1082: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1083: HZ_POPULATE_BOT_PKG.pop_hz_financial_numbers(
1084: p_operation => 'I',
1085: p_financial_number_id => x_financial_number_id);
1086: END IF;
1087: END IF;

Line 1228: HZ_POPULATE_BOT_PKG.pop_hz_financial_numbers(

1224: l_old_financial_number_rec );
1225: END IF;
1226:
1227: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1228: HZ_POPULATE_BOT_PKG.pop_hz_financial_numbers(
1229: p_operation => 'U',
1230: p_financial_number_id => l_financial_number_rec.financial_number_id);
1231: END IF;
1232: END IF;

Line 1277: * HZ_FINANCIAL_NUMBERS_PKG.Select_Row

1273: * DESCRIPTION
1274: * Gets financial number record.
1275: *
1276: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1277: * HZ_FINANCIAL_NUMBERS_PKG.Select_Row
1278: *
1279: * ARGUMENTS
1280: * IN:
1281: * p_init_msg_list Initialize message stack if it is set to

Line 1334: HZ_FINANCIAL_NUMBERS_PKG.Select_Row (

1330:
1331: -- The p_financial_number_rec.financial_number_id must be initiated to p_financial_number_id
1332: p_financial_number_rec.financial_number_id := p_financial_number_id;
1333:
1334: HZ_FINANCIAL_NUMBERS_PKG.Select_Row (
1335: x_financial_number_id => p_financial_number_rec.financial_number_id,
1336: x_financial_report_id => p_financial_number_rec.financial_report_id,
1337: x_financial_number => p_financial_number_rec.financial_number,
1338: x_financial_number_name => p_financial_number_rec.financial_number_name,