DBA Data[Home] [Help]

APPS.MTL_SERIAL_CHECK dependencies on MTL_PARAMETERS

Line 570: | MTL_PARAMETERS, ser_number is the serial number in question, message

566: | violating the organization uniqueness criteria.
567: |
568: | PARAMETERS:
569: | org_id is the organization_id, serial_number_type is the value from
570: | MTL_PARAMETERS, ser_number is the serial number in question, message
571: | is expected to point to a text[241].
572: |
573: | RETURN:
574: | Returns TRUE on success, FALSE on error.

Line 694: MTL_PARAMETERS P

690: BEGIN
691: SELECT 'x'
692: INTO L_nothing
693: FROM MTL_SERIAL_NUMBERS S,
694: MTL_PARAMETERS P
695: WHERE S.CURRENT_ORGANIZATION_ID = P.ORGANIZATION_ID
696: AND S.SERIAL_NUMBER = P_serial_number
697: AND P.SERIAL_NUMBER_TYPE = 3;
698: