1 PACKAGE CSD_WIP_TRANSACTION_DTLS_PKG as
2 /* $Header: csdtwtds.pls 120.11.12020000.2 2013/02/07 00:23:39 vicli ship $ */
3 -- Start of Comments
4 -- Package name : CSD_WIP_TRANSACTION_DTLS_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 PROCEDURE Insert_Row(
11 px_WIP_TRANSACTION_DETAIL_ID IN OUT NOCOPY NUMBER
12 ,p_CREATED_BY IN NUMBER
13 ,p_CREATION_DATE IN DATE
14 ,p_LAST_UPDATED_BY IN NUMBER
15 ,p_LAST_UPDATE_DATE IN DATE
16 ,p_LAST_UPDATE_LOGIN IN NUMBER
17 ,p_INVENTORY_ITEM_ID IN NUMBER
18 ,p_WIP_ENTITY_ID IN NUMBER
19 ,p_OPERATION_SEQ_NUM IN NUMBER
20 ,p_RESOURCE_SEQ_NUM IN NUMBER
21 ,p_employee_id IN NUMBER
22 ,p_TRANSACTION_QUANTITY IN NUMBER
23 ,p_TRANSACTION_UOM IN VARCHAR2
24 ,p_SERIAL_NUMBER IN VARCHAR2
25 ,p_REVISION IN VARCHAR2 -- swai: bug 7182047 (FP of 6995498)
26 -- swai bug 6841113: added material txn reason code
27 ,p_REASON_ID IN NUMBER
28 -- swai: added code for operations
29 ,p_BACKFLUSH_FLAG IN NUMBER
30 ,p_COUNT_POINT_TYPE IN NUMBER
31 ,p_DEPARTMENT_ID IN NUMBER
32 ,p_DESCRIPTION IN VARCHAR2
33 ,p_FIRST_UNIT_COMPLETION_DATE IN DATE
34 ,p_FIRST_UNIT_START_DATE IN DATE
35 ,p_LAST_UNIT_COMPLETION_DATE IN DATE
36 ,p_LAST_UNIT_START_DATE IN DATE
37 ,p_MINIMUM_TRANSFER_QUANTITY IN NUMBER
38 ,p_STANDARD_OPERATION_ID IN NUMBER
39 -- yvchen: bug 13258460
40 -- 12.1.3+ add attributes to csd_wip_transaction_details
41 -- default these to null
42 ,p_ATTRIBUTE_CATEGORY VARCHAR2 := null
43 ,p_ATTRIBUTE1 VARCHAR2 := null
44 ,p_ATTRIBUTE2 VARCHAR2 := null
45 ,p_ATTRIBUTE3 VARCHAR2 := null
46 ,p_ATTRIBUTE4 VARCHAR2 := null
47 ,p_ATTRIBUTE5 VARCHAR2 := null
48 ,p_ATTRIBUTE6 VARCHAR2 := null
49 ,p_ATTRIBUTE7 VARCHAR2 := null
50 ,p_ATTRIBUTE8 VARCHAR2 := null
51 ,p_ATTRIBUTE9 VARCHAR2 := null
52 ,p_ATTRIBUTE10 VARCHAR2 := null
53 ,p_ATTRIBUTE11 VARCHAR2 := null
54 ,p_ATTRIBUTE12 VARCHAR2 := null
55 ,p_ATTRIBUTE13 VARCHAR2 := null
56 ,p_ATTRIBUTE14 VARCHAR2 := null
57 ,p_ATTRIBUTE15 VARCHAR2 := null
58 ,p_CREATE_RO_FLAG VARCHAR2 := FND_API.G_MISS_CHAR -- bug#13698799 auto create ro, parent ro
59 );
60
61
62 PROCEDURE Update_Row(
63 p_WIP_TRANSACTION_DETAIL_ID IN NUMBER
64 ,p_CREATED_BY IN NUMBER
65 ,p_CREATION_DATE IN DATE
66 ,p_LAST_UPDATED_BY IN NUMBER
67 ,p_LAST_UPDATE_DATE IN DATE
68 ,p_LAST_UPDATE_LOGIN IN NUMBER
69 ,p_INVENTORY_ITEM_ID IN NUMBER
70 ,p_WIP_ENTITY_ID IN NUMBER
71 ,p_OPERATION_SEQ_NUM IN NUMBER
72 ,p_RESOURCE_SEQ_NUM IN NUMBER
73 ,p_employee_id IN NUMBER
74 ,p_TRANSACTION_QUANTITY IN NUMBER
75 ,p_TRANSACTION_UOM IN VARCHAR2
76 ,p_SERIAL_NUMBER IN VARCHAR2
77 ,p_REVISION IN VARCHAR2 -- swai: bug 7182047 (FP of 6995498)
78 -- swai bug 6841113: added material txn reason code
79 ,p_REASON_ID IN NUMBER
80 -- swai: added code for operations
81 ,p_BACKFLUSH_FLAG IN NUMBER
82 ,p_COUNT_POINT_TYPE IN NUMBER
83 ,p_DEPARTMENT_ID IN NUMBER
84 ,p_DESCRIPTION IN VARCHAR2
85 ,p_FIRST_UNIT_COMPLETION_DATE IN DATE
86 ,p_FIRST_UNIT_START_DATE IN DATE
87 ,p_LAST_UNIT_COMPLETION_DATE IN DATE
88 ,p_LAST_UNIT_START_DATE IN DATE
89 ,p_MINIMUM_TRANSFER_QUANTITY IN NUMBER
90 ,p_STANDARD_OPERATION_ID IN NUMBER
91 ,p_OBJECT_VERSION_NUMBER IN NUMBER
92 -- yvchen: bug 13258460
93 -- 12.1.3+ add DFF attributes to csd_wip_transaction_details
94 -- default these to null so they will remain unchanged unless
95 -- unless otherwise specified
96 ,p_ATTRIBUTE_CATEGORY VARCHAR2 := null
97 ,p_ATTRIBUTE1 VARCHAR2 := null
98 ,p_ATTRIBUTE2 VARCHAR2 := null
99 ,p_ATTRIBUTE3 VARCHAR2 := null
100 ,p_ATTRIBUTE4 VARCHAR2 := null
101 ,p_ATTRIBUTE5 VARCHAR2 := null
102 ,p_ATTRIBUTE6 VARCHAR2 := null
103 ,p_ATTRIBUTE7 VARCHAR2 := null
104 ,p_ATTRIBUTE8 VARCHAR2 := null
105 ,p_ATTRIBUTE9 VARCHAR2 := null
106 ,p_ATTRIBUTE10 VARCHAR2 := null
107 ,p_ATTRIBUTE11 VARCHAR2 := null
108 ,p_ATTRIBUTE12 VARCHAR2 := null
109 ,p_ATTRIBUTE13 VARCHAR2 := null
110 ,p_ATTRIBUTE14 VARCHAR2 := null
111 ,p_ATTRIBUTE15 VARCHAR2 := null
112 ,p_CREATE_RO_FLAG VARCHAR2 := FND_API.G_MISS_CHAR -- bug#13698799 auto create ro, parent ro
113 );
114
115
116 PROCEDURE Delete_Row(
117 p_WIP_TRANSACTION_DETAIL_ID NUMBER);
118
119 End CSD_WIP_TRANSACTION_DTLS_PKG;