APPS.HZ_DSS_SETUP_PUB dependencies on HZ_DSS_SCHEME_FUNCTIONS

Line 434: from HZ_DSS_SCHEME_FUNCTIONS

430: --Bug 2645639 check if there already is a function defined
431: --for combination of security_scheme_code and data operation
432:
433: select count(*) into l_duplicate_count
434: from HZ_DSS_SCHEME_FUNCTIONS
435: where security_scheme_code = p_dss_scheme_function.security_scheme_code
436: and data_operation_code = p_dss_scheme_function.data_operation_code;
437:
438: IF l_duplicate_count >= 1 then

Line 509: HZ_DSS_SCHEME_FUNCTIONS_PKG.Insert_Row (

505:
506:
507: -- Call the low level table handler
508: --default status to A
509: HZ_DSS_SCHEME_FUNCTIONS_PKG.Insert_Row (
510: x_rowid => row_id,
511: x_security_scheme_code => p_dss_scheme_function.security_scheme_code,
512: x_data_operation_code => p_dss_scheme_function.data_operation_code,
513: x_function_id => p_dss_scheme_function.function_id,

Line 605: FROM HZ_DSS_SCHEME_FUNCTIONS

601:
602: BEGIN
603: SELECT object_version_number, rowid
604: INTO l_object_version_number, l_rowid
605: FROM HZ_DSS_SCHEME_FUNCTIONS
606: WHERE security_scheme_code = p_dss_scheme_function.security_scheme_code and
607: data_operation_code = p_dss_scheme_function.data_operation_code and
608: function_id = p_dss_scheme_function.function_id
609: FOR UPDATE NOWAIT;

Line 621: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DSS_SCHEME_FUNCTIONS');

617: IF NOT ((x_object_version_number is null and l_object_version_number is null)
618: OR (x_object_version_number = l_object_version_number))
619: THEN
620: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
621: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DSS_SCHEME_FUNCTIONS');
622: FND_MSG_PUB.ADD;
623: RAISE FND_API.G_EXC_ERROR;
624: END IF;
625:

Line 642: HZ_DSS_SCHEME_FUNCTIONS_PKG.Update_Row (

638: END IF;
639:
640:
641: -- Call the low level table handler
642: HZ_DSS_SCHEME_FUNCTIONS_PKG.Update_Row (
643: x_rowid => l_rowid,
644: x_status => p_dss_scheme_function.status,
645: x_object_version_number => x_object_version_number
646: ) ;