DBA Data[Home] [Help]

APPS.INV_PROCESS_TEMP dependencies on PJM_UNIT_EFF

Line 1513: IF(NVL(PJM_UNIT_EFF.ENABLED,'N') = 'Y') THEN

1509: FUNCTION validateUnitNumber(txnrec IN TXNREC) RETURN NUMBER
1510: IS
1511: l_dummy NUMBER;
1512: BEGIN
1513: IF(NVL(PJM_UNIT_EFF.ENABLED,'N') = 'Y') THEN
1514: IF(PJM_UNIT_EFF.UNIT_EFFECTIVE_ITEM(txnrec.inventory_item_id,
1515: txnrec.organization_id) = 'Y') then
1516: IF(txnrec.transaction_source_type_id = 3 AND
1517: txnrec.transaction_action_id IN (3,21) AND

Line 1514: IF(PJM_UNIT_EFF.UNIT_EFFECTIVE_ITEM(txnrec.inventory_item_id,

1510: IS
1511: l_dummy NUMBER;
1512: BEGIN
1513: IF(NVL(PJM_UNIT_EFF.ENABLED,'N') = 'Y') THEN
1514: IF(PJM_UNIT_EFF.UNIT_EFFECTIVE_ITEM(txnrec.inventory_item_id,
1515: txnrec.organization_id) = 'Y') then
1516: IF(txnrec.transaction_source_type_id = 3 AND
1517: txnrec.transaction_action_id IN (3,21) AND
1518: txnrec.end_item_unit_number IS NOT NULL) THEN