1 PACKAGE AHL_OSP_ORDER_LINES_PKG AUTHID CURRENT_USER as
2 /* $Header: AHLLOSLS.pls 120.2 2008/01/30 22:21:46 jaramana ship $ */
3 PROCEDURE INSERT_ROW (
4 P_X_OSP_ORDER_LINE_ID IN OUT NOCOPY NUMBER,
5 P_OBJECT_VERSION_NUMBER IN NUMBER,
6 P_LAST_UPDATE_DATE IN DATE,
7 P_LAST_UPDATED_BY IN NUMBER,
8 P_CREATION_DATE IN DATE,
9 P_CREATED_BY IN NUMBER,
10 P_LAST_UPDATE_LOGIN IN NUMBER,
11 P_OSP_ORDER_ID IN NUMBER,
12 P_OSP_LINE_NUMBER IN NUMBER,
13 P_STATUS_CODE IN VARCHAR2,
14 P_PO_LINE_TYPE_ID IN NUMBER,
15 P_SERVICE_ITEM_ID IN NUMBER,
16 P_SERVICE_ITEM_DESCRIPTION IN VARCHAR2,
17 P_SERVICE_ITEM_UOM_CODE IN VARCHAR2,
18 P_NEED_BY_DATE IN DATE,
19 P_SHIP_BY_DATE IN DATE,
20 P_PO_LINE_ID IN NUMBER,
21 P_OE_SHIP_LINE_ID IN NUMBER,
22 P_OE_RETURN_LINE_ID IN NUMBER,
23 P_WORKORDER_ID IN NUMBER,
24 P_OPERATION_ID IN NUMBER,
25 P_QUANTITY IN NUMBER,
26 P_EXCHANGE_INSTANCE_ID IN NUMBER,
27 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
28 P_ATTRIBUTE1 IN VARCHAR2,
29 P_ATTRIBUTE2 IN VARCHAR2,
30 P_ATTRIBUTE3 IN VARCHAR2,
31 P_ATTRIBUTE4 IN VARCHAR2,
32 P_ATTRIBUTE5 IN VARCHAR2,
33 P_ATTRIBUTE6 IN VARCHAR2,
34 P_ATTRIBUTE7 IN VARCHAR2,
35 P_ATTRIBUTE8 IN VARCHAR2,
36 P_ATTRIBUTE9 IN VARCHAR2,
37 P_ATTRIBUTE10 IN VARCHAR2,
38 P_ATTRIBUTE11 IN VARCHAR2,
39 P_ATTRIBUTE12 IN VARCHAR2,
40 P_ATTRIBUTE13 IN VARCHAR2,
41 P_ATTRIBUTE14 IN VARCHAR2,
42 P_ATTRIBUTE15 IN VARCHAR2,
43 P_INVENTORY_ITEM_ID IN NUMBER,
44 P_INVENTORY_ORG_ID IN NUMBER,
45 P_SUB_INVENTORY IN VARCHAR2,
46 P_LOT_NUMBER IN VARCHAR2,
47 P_SERIAL_NUMBER IN VARCHAR2,
48 P_INVENTORY_ITEM_UOM IN VARCHAR2,
49 P_INVENTORY_ITEM_QUANTITY IN NUMBER,
50 P_PO_REQ_LINE_ID IN NUMBER -- Added by jaramana on January 14, 2008 for the Requisition ER 6034236
51 );
52
53 PROCEDURE UPDATE_ROW (
54 P_OSP_ORDER_LINE_ID IN NUMBER,
55 P_OBJECT_VERSION_NUMBER IN NUMBER,
56 P_LAST_UPDATE_DATE IN DATE,
57 P_LAST_UPDATED_BY IN NUMBER,
58 P_LAST_UPDATE_LOGIN IN NUMBER,
59 P_OSP_ORDER_ID IN NUMBER,
60 P_OSP_LINE_NUMBER IN NUMBER,
61 P_STATUS_CODE IN VARCHAR2,
62 P_PO_LINE_TYPE_ID IN NUMBER,
63 P_SERVICE_ITEM_ID IN NUMBER,
64 P_SERVICE_ITEM_DESCRIPTION IN VARCHAR2,
65 P_SERVICE_ITEM_UOM_CODE IN VARCHAR2,
66 P_NEED_BY_DATE IN DATE,
67 P_SHIP_BY_DATE IN DATE,
68 P_PO_LINE_ID IN NUMBER,
69 P_OE_SHIP_LINE_ID IN NUMBER,
70 P_OE_RETURN_LINE_ID IN NUMBER,
71 P_WORKORDER_ID IN NUMBER,
72 P_OPERATION_ID IN NUMBER,
73 P_QUANTITY IN NUMBER,
74 P_EXCHANGE_INSTANCE_ID IN NUMBER,
75 P_INVENTORY_ITEM_ID IN NUMBER,
76 P_INVENTORY_ORG_ID IN NUMBER,
77 P_INVENTORY_ITEM_UOM IN VARCHAR2,
78 P_INVENTORY_ITEM_QUANTITY IN NUMBER,
79 P_SUB_INVENTORY IN VARCHAR2,
80 P_LOT_NUMBER IN VARCHAR2,
81 P_SERIAL_NUMBER IN VARCHAR2,
82 P_PO_REQ_LINE_ID IN NUMBER, -- Added by jaramana on January 14, 2008 for the Requisition ER 6034236
83 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
84 P_ATTRIBUTE1 IN VARCHAR2,
85 P_ATTRIBUTE2 IN VARCHAR2,
86 P_ATTRIBUTE3 IN VARCHAR2,
87 P_ATTRIBUTE4 IN VARCHAR2,
88 P_ATTRIBUTE5 IN VARCHAR2,
89 P_ATTRIBUTE6 IN VARCHAR2,
90 P_ATTRIBUTE7 IN VARCHAR2,
91 P_ATTRIBUTE8 IN VARCHAR2,
92 P_ATTRIBUTE9 IN VARCHAR2,
93 P_ATTRIBUTE10 IN VARCHAR2,
94 P_ATTRIBUTE11 IN VARCHAR2,
95 P_ATTRIBUTE12 IN VARCHAR2,
96 P_ATTRIBUTE13 IN VARCHAR2,
97 P_ATTRIBUTE14 IN VARCHAR2,
98 P_ATTRIBUTE15 IN VARCHAR2
99 );
100
101
102 PROCEDURE DELETE_ROW (
103 P_OSP_ORDER_LINE_ID IN NUMBER
104 );
105
106 END AHL_OSP_ORDER_LINES_PKG; -- Package spec
107 ----------------------------------------------
108