1 PACKAGE CSD_WIP_TRANSACTION_DTLS_PKG as
2 /* $Header: csdtwtds.pls 120.7.12010000.2 2008/10/15 20:27:24 swai 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 );
40
41
42 PROCEDURE Update_Row(
43 p_WIP_TRANSACTION_DETAIL_ID IN NUMBER
44 ,p_CREATED_BY IN NUMBER
45 ,p_CREATION_DATE IN DATE
46 ,p_LAST_UPDATED_BY IN NUMBER
47 ,p_LAST_UPDATE_DATE IN DATE
48 ,p_LAST_UPDATE_LOGIN IN NUMBER
49 ,p_INVENTORY_ITEM_ID IN NUMBER
50 ,p_WIP_ENTITY_ID IN NUMBER
51 ,p_OPERATION_SEQ_NUM IN NUMBER
52 ,p_RESOURCE_SEQ_NUM IN NUMBER
53 ,p_employee_id IN NUMBER
54 ,p_TRANSACTION_QUANTITY IN NUMBER
55 ,p_TRANSACTION_UOM IN VARCHAR2
56 ,p_SERIAL_NUMBER IN VARCHAR2
57 ,p_REVISION IN VARCHAR2 -- swai: bug 7182047 (FP of 6995498)
58 -- swai bug 6841113: added material txn reason code
59 ,p_REASON_ID IN NUMBER
60 -- swai: added code for operations
61 ,p_BACKFLUSH_FLAG IN NUMBER
62 ,p_COUNT_POINT_TYPE IN NUMBER
63 ,p_DEPARTMENT_ID IN NUMBER
64 ,p_DESCRIPTION IN VARCHAR2
65 ,p_FIRST_UNIT_COMPLETION_DATE IN DATE
66 ,p_FIRST_UNIT_START_DATE IN DATE
67 ,p_LAST_UNIT_COMPLETION_DATE IN DATE
68 ,p_LAST_UNIT_START_DATE IN DATE
69 ,p_MINIMUM_TRANSFER_QUANTITY IN NUMBER
70 ,p_STANDARD_OPERATION_ID IN NUMBER
71 ,p_OBJECT_VERSION_NUMBER IN NUMBER
72 );
73
74
75 PROCEDURE Delete_Row(
76 p_WIP_TRANSACTION_DETAIL_ID NUMBER);
77
78 End CSD_WIP_TRANSACTION_DTLS_PKG;