APPS.CSD_WIP_TRANSACTION_DTLS_PKG dependencies on CSD_WIP_TRANSACTION_DETAILS

Line 46: -- 12.1.3+ add DFF attributes to csd_wip_transaction_details

42: ,p_LAST_UNIT_START_DATE IN DATE
43: ,p_MINIMUM_TRANSFER_QUANTITY IN NUMBER
44: ,p_STANDARD_OPERATION_ID IN NUMBER
45: -- yvchen: bug 13258460
46: -- 12.1.3+ add DFF attributes to csd_wip_transaction_details
47: ,p_ATTRIBUTE_CATEGORY VARCHAR2 := null
48: ,p_ATTRIBUTE1 VARCHAR2 := null
49: ,p_ATTRIBUTE2 VARCHAR2 := null
50: ,p_ATTRIBUTE3 VARCHAR2 := null

Line 67: CURSOR C2 IS SELECT CSD_WIP_TRANSACTION_DETAILS_S1.nextval FROM sys.dual;

63: ,p_CREATE_RO_FLAG VARCHAR2 := FND_API.G_MISS_CHAR --bug#13698799 auto create ro, parent ro
64: )
65:
66: IS
67: CURSOR C2 IS SELECT CSD_WIP_TRANSACTION_DETAILS_S1.nextval FROM sys.dual;
68: l_object_version_number NUMBER := 1;
69: BEGIN
70: If (px_WIP_TRANSACTION_DETAIL_ID IS NULL) OR (px_WIP_TRANSACTION_DETAIL_ID = FND_API.G_MISS_NUM) then
71: OPEN C2;

Line 75: INSERT INTO CSD_WIP_TRANSACTION_DETAILS(

71: OPEN C2;
72: FETCH C2 INTO px_WIP_TRANSACTION_DETAIL_ID;
73: CLOSE C2;
74: End If;
75: INSERT INTO CSD_WIP_TRANSACTION_DETAILS(
76: WIP_TRANSACTION_DETAIL_ID
77: ,CREATED_BY
78: ,CREATION_DATE
79: ,LAST_UPDATED_BY

Line 160: -- 12.1.3+ add DFF attributes to csd_wip_transaction_details

156: ,decode( p_STANDARD_OPERATION_ID, FND_API.G_MISS_NUM, NULL, p_STANDARD_OPERATION_ID)
157: -- end swai: added code for operations
158: ,l_object_version_number
159: -- yvchen: bug 13258460
160: -- 12.1.3+ add DFF attributes to csd_wip_transaction_details
161: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
162: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
163: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
164: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)

Line 213: -- 12.1.3+ add attributes to csd_wip_transaction_details

209: ,p_MINIMUM_TRANSFER_QUANTITY IN NUMBER
210: ,p_STANDARD_OPERATION_ID IN NUMBER
211: ,p_OBJECT_VERSION_NUMBER IN NUMBER
212: -- yvchen: bug 13258460
213: -- 12.1.3+ add attributes to csd_wip_transaction_details
214: -- default these to null so they will remain unchanged unless
215: -- unless otherwise specified
216: ,p_ATTRIBUTE_CATEGORY VARCHAR2 := null
217: ,p_ATTRIBUTE1 VARCHAR2 := null

Line 237: Update CSD_WIP_TRANSACTION_DETAILS

233: )
234:
235: IS
236: BEGIN
237: Update CSD_WIP_TRANSACTION_DETAILS
238: SET
239: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, p_CREATED_BY)
240: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, p_CREATION_DATE)
241: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)

Line 272: -- 12.1.3+ add DFF attributes to csd_wip_transaction_details

268: ,STANDARD_OPERATION_ID = decode( p_STANDARD_OPERATION_ID, FND_API.G_MISS_NUM, NULL, NULL, STANDARD_OPERATION_ID, p_STANDARD_OPERATION_ID)
269: -- end swai: added code for operations
270: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
271: -- yvchen: bug 13258460
272: -- 12.1.3+ add DFF attributes to csd_wip_transaction_details
273: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
274: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
275: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
276: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)

Line 303: DELETE FROM CSD_WIP_TRANSACTION_DETAILS

299: PROCEDURE Delete_Row(
300: p_WIP_TRANSACTION_DETAIL_ID NUMBER)
301: IS
302: BEGIN
303: DELETE FROM CSD_WIP_TRANSACTION_DETAILS
304: WHERE WIP_TRANSACTION_DETAIL_ID = p_WIP_TRANSACTION_DETAIL_ID;
305: If (SQL%NOTFOUND) then
306: RAISE NO_DATA_FOUND;
307: End If;