[Home] [Help]
PACKAGE: APPS.CSD_PRODUCT_TRANSACTIONS_PKG
Source
1 PACKAGE CSD_PRODUCT_TRANSACTIONS_PKG AUTHID CURRENT_USER as
2 /* $Header: csdtptxs.pls 120.2.12000000.2 2007/06/27 22:47:22 swai ship $ */
3
4 PROCEDURE Insert_Row(
5 px_PRODUCT_TRANSACTION_ID IN OUT NOCOPY NUMBER,
6 p_REPAIR_LINE_ID NUMBER,
7 p_ESTIMATE_DETAIL_ID NUMBER,
8 p_ACTION_TYPE VARCHAR2,
9 p_ACTION_CODE VARCHAR2,
10 p_LOT_NUMBER VARCHAR2,
11 p_SUB_INVENTORY VARCHAR2,
12 p_INTERFACE_TO_OM_FLAG VARCHAR2,
13 p_BOOK_SALES_ORDER_FLAG VARCHAR2,
14 p_RELEASE_SALES_ORDER_FLAG VARCHAR2,
15 p_SHIP_SALES_ORDER_FLAG VARCHAR2,
16 p_PROD_TXN_STATUS VARCHAR2,
17 p_PROD_TXN_CODE VARCHAR2,
18 p_LAST_UPDATE_DATE DATE,
19 p_CREATION_DATE DATE,
20 p_LAST_UPDATED_BY NUMBER,
21 p_CREATED_BY NUMBER,
22 p_LAST_UPDATE_LOGIN NUMBER,
23 p_ATTRIBUTE1 VARCHAR2,
24 p_ATTRIBUTE2 VARCHAR2,
25 p_ATTRIBUTE3 VARCHAR2,
26 p_ATTRIBUTE4 VARCHAR2,
27 p_ATTRIBUTE5 VARCHAR2,
28 p_ATTRIBUTE6 VARCHAR2,
29 p_ATTRIBUTE7 VARCHAR2,
30 p_ATTRIBUTE8 VARCHAR2,
31 p_ATTRIBUTE9 VARCHAR2,
32 p_ATTRIBUTE10 VARCHAR2,
33 p_ATTRIBUTE11 VARCHAR2,
34 p_ATTRIBUTE12 VARCHAR2,
35 p_ATTRIBUTE13 VARCHAR2,
36 p_ATTRIBUTE14 VARCHAR2,
37 p_ATTRIBUTE15 VARCHAR2,
38 p_CONTEXT VARCHAR2,
39 p_OBJECT_VERSION_NUMBER NUMBER,
40 P_REQ_HEADER_ID NUMBER,
41 P_REQ_LINE_ID NUMBER,
42 P_ORDER_HEADER_ID NUMBER,
43 P_ORDER_LINE_ID NUMBER,
44 P_PRD_TXN_QTY_RECEIVED NUMBER,
45 P_PRD_TXN_QTY_SHIPPED NUMBER,
46 P_SOURCE_SERIAL_NUMBER VARCHAR2,
47 P_SOURCE_INSTANCE_ID NUMBER,
48 P_NON_SOURCE_SERIAL_NUMBER VARCHAR2,
49 P_NON_SOURCE_INSTANCE_ID NUMBER,
50 P_LOCATOR_ID NUMBER,
51 P_SUB_INVENTORY_RCVD VARCHAR2,
52 P_LOT_NUMBER_RCVD VARCHAR2,
53 P_picking_rule_id NUMBER, -- R12 dEvelopment changes
54 P_PROJECT_ID NUMBER, --taklam
55 P_TASK_ID NUMBER,
56 P_UNIT_NUMBER VARCHAR2,
57 -- swai: bug 6148019 internal po for 3rd party
58 P_INTERNAL_PO_HEADER_ID NUMBER := Fnd_API.G_MISS_NUM
59 );
60
61
62
63 PROCEDURE Update_Row(
64 p_PRODUCT_TRANSACTION_ID NUMBER,
65 p_REPAIR_LINE_ID NUMBER,
66 p_ESTIMATE_DETAIL_ID NUMBER,
67 p_ACTION_TYPE VARCHAR2,
68 p_ACTION_CODE VARCHAR2,
69 p_LOT_NUMBER VARCHAR2,
70 p_SUB_INVENTORY VARCHAR2,
71 p_INTERFACE_TO_OM_FLAG VARCHAR2,
72 p_BOOK_SALES_ORDER_FLAG VARCHAR2,
73 p_RELEASE_SALES_ORDER_FLAG VARCHAR2,
74 p_SHIP_SALES_ORDER_FLAG VARCHAR2,
75 p_PROD_TXN_STATUS VARCHAR2,
76 p_PROD_TXN_CODE VARCHAR2,
77 p_LAST_UPDATE_DATE DATE,
78 p_CREATION_DATE DATE,
79 p_LAST_UPDATED_BY NUMBER,
80 p_CREATED_BY NUMBER,
81 p_LAST_UPDATE_LOGIN NUMBER,
82 p_ATTRIBUTE1 VARCHAR2,
83 p_ATTRIBUTE2 VARCHAR2,
84 p_ATTRIBUTE3 VARCHAR2,
85 p_ATTRIBUTE4 VARCHAR2,
86 p_ATTRIBUTE5 VARCHAR2,
87 p_ATTRIBUTE6 VARCHAR2,
88 p_ATTRIBUTE7 VARCHAR2,
89 p_ATTRIBUTE8 VARCHAR2,
90 p_ATTRIBUTE9 VARCHAR2,
91 p_ATTRIBUTE10 VARCHAR2,
92 p_ATTRIBUTE11 VARCHAR2,
93 p_ATTRIBUTE12 VARCHAR2,
94 p_ATTRIBUTE13 VARCHAR2,
95 p_ATTRIBUTE14 VARCHAR2,
96 p_ATTRIBUTE15 VARCHAR2,
97 p_CONTEXT VARCHAR2,
98 p_OBJECT_VERSION_NUMBER NUMBER,
99 P_REQ_HEADER_ID NUMBER,
100 P_REQ_LINE_ID NUMBER,
101 P_ORDER_HEADER_ID NUMBER,
102 P_ORDER_LINE_ID NUMBER,
103 P_PRD_TXN_QTY_RECEIVED NUMBER,
104 P_PRD_TXN_QTY_SHIPPED NUMBER,
105 P_SOURCE_SERIAL_NUMBER VARCHAR2,
106 P_SOURCE_INSTANCE_ID NUMBER,
107 P_NON_SOURCE_SERIAL_NUMBER VARCHAR2,
108 P_NON_SOURCE_INSTANCE_ID NUMBER,
109 P_LOCATOR_ID NUMBER,
110 P_SUB_INVENTORY_RCVD VARCHAR2,
111 P_LOT_NUMBER_RCVD VARCHAR2,
112 P_picking_rule_id NUMBER, -- R12 dEvelopment changes
113 P_PROJECT_ID NUMBER, --taklam
114 P_TASK_ID NUMBER,
115 P_UNIT_NUMBER VARCHAR2,
116 -- swai: bug 6148019 internal po for 3rd party
117 P_INTERNAL_PO_HEADER_ID NUMBER := Fnd_API.G_MISS_NUM
118
119 );
120
121
122 PROCEDURE Lock_Row(
123 p_PRODUCT_TRANSACTION_ID NUMBER,
124 p_OBJECT_VERSION_NUMBER NUMBER);
125
126 PROCEDURE Delete_Row(
127 p_PRODUCT_TRANSACTION_ID NUMBER);
128 End CSD_PRODUCT_TRANSACTIONS_PKG;