DBA Data[Home] [Help]

APPS.CSD_PRODUCT_TRANSACTIONS_PKG dependencies on DUAL

Line 66: CURSOR C2 IS SELECT CSD_PRODUCT_TRANSACTIONS_S1.nextval FROM sys.dual;

62: P_INTERNAL_PO_HEADER_ID NUMBER -- swai: bug 6148019
63: )
64:
65: IS
66: CURSOR C2 IS SELECT CSD_PRODUCT_TRANSACTIONS_S1.nextval FROM sys.dual;
67: BEGIN
68: -- Since Product transaction id is a primary key, it is good if value is always
69: -- generated from a sequence. This is to fix bug 3215153 saupadhy
70: -- If (px_PRODUCT_TRANSACTION_ID IS NULL) OR (px_PRODUCT_TRANSACTION_ID = FND_API.G_MISS_NUM) then