DBA Data[Home] [Help]

APPS.CSD_WIP_TRANSACTION_DTLS_PKG dependencies on STANDARD

Line 44: ,p_STANDARD_OPERATION_ID IN NUMBER

40: ,p_FIRST_UNIT_START_DATE IN DATE
41: ,p_LAST_UNIT_COMPLETION_DATE IN DATE
42: ,p_LAST_UNIT_START_DATE IN DATE
43: ,p_MINIMUM_TRANSFER_QUANTITY IN NUMBER
44: ,p_STANDARD_OPERATION_ID IN NUMBER
45: )
46:
47: IS
48: CURSOR C2 IS SELECT CSD_WIP_TRANSACTION_DETAILS_S1.nextval FROM sys.dual;

Line 83: ,STANDARD_OPERATION_ID

79: ,FIRST_UNIT_START_DATE
80: ,LAST_UNIT_COMPLETION_DATE
81: ,LAST_UNIT_START_DATE
82: ,MINIMUM_TRANSFER_QUANTITY
83: ,STANDARD_OPERATION_ID
84: -- end swai: added code for operations
85: ,OBJECT_VERSION_NUMBER
86: ) VALUES (
87: px_WIP_TRANSACTION_DETAIL_ID

Line 117: ,decode( p_STANDARD_OPERATION_ID, FND_API.G_MISS_NUM, NULL, p_STANDARD_OPERATION_ID)

113: ,decode( p_FIRST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, p_FIRST_UNIT_START_DATE)
114: ,decode( p_LAST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UNIT_COMPLETION_DATE)
115: ,decode( p_LAST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UNIT_START_DATE)
116: ,decode( p_MINIMUM_TRANSFER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MINIMUM_TRANSFER_QUANTITY)
117: ,decode( p_STANDARD_OPERATION_ID, FND_API.G_MISS_NUM, NULL, p_STANDARD_OPERATION_ID)
118: -- end swai: added code for operations
119: ,l_object_version_number
120: );
121: End Insert_Row;

Line 151: ,p_STANDARD_OPERATION_ID IN NUMBER

147: ,p_FIRST_UNIT_START_DATE IN DATE
148: ,p_LAST_UNIT_COMPLETION_DATE IN DATE
149: ,p_LAST_UNIT_START_DATE IN DATE
150: ,p_MINIMUM_TRANSFER_QUANTITY IN NUMBER
151: ,p_STANDARD_OPERATION_ID IN NUMBER
152: ,p_OBJECT_VERSION_NUMBER IN NUMBER
153: )
154:
155: IS

Line 188: ,STANDARD_OPERATION_ID = decode( p_STANDARD_OPERATION_ID, FND_API.G_MISS_NUM, NULL, NULL, STANDARD_OPERATION_ID, p_STANDARD_OPERATION_ID)

184: ,FIRST_UNIT_START_DATE = decode( p_FIRST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, NULL, FIRST_UNIT_START_DATE, p_FIRST_UNIT_START_DATE)
185: ,LAST_UNIT_COMPLETION_DATE = decode( p_LAST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UNIT_COMPLETION_DATE, p_LAST_UNIT_COMPLETION_DATE)
186: ,LAST_UNIT_START_DATE = decode( p_LAST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UNIT_START_DATE, p_LAST_UNIT_START_DATE)
187: ,MINIMUM_TRANSFER_QUANTITY = decode( p_MINIMUM_TRANSFER_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, MINIMUM_TRANSFER_QUANTITY, p_MINIMUM_TRANSFER_QUANTITY)
188: ,STANDARD_OPERATION_ID = decode( p_STANDARD_OPERATION_ID, FND_API.G_MISS_NUM, NULL, NULL, STANDARD_OPERATION_ID, p_STANDARD_OPERATION_ID)
189: -- end swai: added code for operations
190: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
191: where WIP_TRANSACTION_DETAIL_ID = p_WIP_TRANSACTION_DETAIL_ID;
192: