[Home] [Help]
PACKAGE BODY: APPS.SO_PICKING_LINE_DETAILS_PKG1
Source
1 PACKAGE BODY SO_PICKING_LINE_DETAILS_PKG1 as
2 /* $Header: WSHPLDXB.pls 115.0 99/07/16 08:19:41 porting ship $ */
3
4 PROCEDURE Update_Row(X_Rowid VARCHAR2,
5 X_Picking_Line_Detail_Id NUMBER,
6 X_Last_Update_Date DATE,
7 X_Last_Updated_By NUMBER,
8 X_Last_Update_Login NUMBER,
9 X_Picking_Line_Id NUMBER,
10 X_Warehouse_Id NUMBER,
11 X_Requested_Quantity NUMBER,
12 X_Shipped_Quantity NUMBER,
13 X_Serial_Number VARCHAR2,
14 X_Lot_Number VARCHAR2,
15 X_Customer_Requested_Lot_Flag VARCHAR2,
16 X_Revision VARCHAR2,
17 X_Subinventory VARCHAR2,
18 X_Inventory_Location_Id NUMBER,
19 X_Inventory_Location_Segments VARCHAR2,
20 X_Detail_Type_Code VARCHAR2,
21 X_Context VARCHAR2,
22 X_Attribute1 VARCHAR2,
23 X_Attribute2 VARCHAR2,
24 X_Attribute3 VARCHAR2,
25 X_Attribute4 VARCHAR2,
26 X_Attribute5 VARCHAR2,
27 X_Attribute6 VARCHAR2,
28 X_Attribute7 VARCHAR2,
29 X_Attribute8 VARCHAR2,
30 X_Attribute9 VARCHAR2,
31 X_Attribute10 VARCHAR2,
32 X_Attribute11 VARCHAR2,
33 X_Attribute12 VARCHAR2,
34 X_Attribute13 VARCHAR2,
35 X_Attribute14 VARCHAR2,
36 X_Attribute15 VARCHAR2,
37 X_Released_Flag VARCHAR2,
38 X_Schedule_Date DATE,
39 X_Schedule_Level NUMBER,
40 X_Schedule_Status_Code VARCHAR2,
41 X_Demand_Id NUMBER,
42 X_Autoscheduled_Flag VARCHAR2,
43 X_Delivery NUMBER,
44 X_Wip_Reserved_Quantity NUMBER,
45 X_Wip_Completed_Quantity NUMBER,
46 X_Supply_Source_Type NUMBER,
47 X_Supply_Source_Header_Id NUMBER,
48 X_Update_Flag VARCHAR2,
49 X_Demand_Class_Code VARCHAR2,
50 X_Reservable_Flag VARCHAR2,
51 X_Transactable_Flag VARCHAR2,
52 X_Latest_Acceptable_Date DATE,
53 X_Delivery_Id NUMBER,
54 X_Departure_Id NUMBER,
55 X_Master_Container_Item_Id NUMBER,
56 X_Detail_Container_Item_Id NUMBER,
57 X_Dpw_Assigned_Flag VARCHAR2,
58 X_Load_Seq_Number NUMBER,
59 X_Transaction_Temp_Id NUMBER,
60 X_Container_Id NUMBER,
61 X_movement_id NUMBER
62
63 ) IS
64 BEGIN
65 UPDATE so_picking_line_details
66 SET
67 picking_line_detail_id = X_Picking_Line_Detail_Id,
68 last_update_date = X_Last_Update_Date,
69 last_updated_by = X_Last_Updated_By,
70 last_update_login = X_Last_Update_Login,
71 picking_line_id = X_Picking_Line_Id,
72 warehouse_id = X_Warehouse_Id,
73 requested_quantity = X_Requested_Quantity,
74 shipped_quantity = X_Shipped_Quantity,
75 serial_number = X_Serial_Number,
76 lot_number = X_Lot_Number,
77 customer_requested_lot_flag = X_Customer_Requested_Lot_Flag,
78 revision = X_Revision,
79 subinventory = X_Subinventory,
80 inventory_location_id = X_Inventory_Location_Id,
81 inventory_location_segments = X_Inventory_Location_Segments,
82 detail_type_code = X_Detail_Type_Code,
83 context = X_Context,
84 attribute1 = X_Attribute1,
85 attribute2 = X_Attribute2,
86 attribute3 = X_Attribute3,
87 attribute4 = X_Attribute4,
88 attribute5 = X_Attribute5,
89 attribute6 = X_Attribute6,
90 attribute7 = X_Attribute7,
91 attribute8 = X_Attribute8,
92 attribute9 = X_Attribute9,
93 attribute10 = X_Attribute10,
94 attribute11 = X_Attribute11,
95 attribute12 = X_Attribute12,
96 attribute13 = X_Attribute13,
97 attribute14 = X_Attribute14,
98 attribute15 = X_Attribute15,
99 released_flag = X_Released_Flag,
100 schedule_date = X_Schedule_Date,
101 schedule_level = X_Schedule_Level,
102 schedule_status_code = X_Schedule_Status_Code,
103 demand_id = X_Demand_Id,
104 autoscheduled_flag = X_Autoscheduled_Flag,
105 delivery = X_Delivery,
106 wip_reserved_quantity = X_Wip_Reserved_Quantity,
107 wip_completed_quantity = X_Wip_Completed_Quantity,
108 supply_source_type = X_Supply_Source_Type,
109 supply_source_header_id = X_Supply_Source_Header_Id,
110 update_flag = X_Update_Flag,
111 demand_class_code = X_Demand_Class_Code,
112 reservable_flag = X_Reservable_Flag,
113 transactable_flag = X_Transactable_Flag,
114 latest_acceptable_date = X_Latest_Acceptable_Date,
115 delivery_id = X_Delivery_Id,
116 departure_id = X_Departure_Id,
117 master_container_item_id = X_Master_Container_Item_Id,
118 detail_container_item_id = X_Detail_Container_Item_Id,
119 dpw_assigned_flag = X_Dpw_Assigned_Flag,
120 load_seq_number = X_Load_Seq_Number,
121 transaction_temp_id = X_Transaction_Temp_Id,
122 container_id = X_Container_id,
123 movement_id = X_Movement_id
124 WHERE rowid = X_Rowid;
125
126 if (SQL%NOTFOUND) then
127 Raise NO_DATA_FOUND;
128 end if;
129 END Update_Row;
130 PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
131 BEGIN
132 DELETE FROM so_picking_line_details
133 WHERE rowid = X_Rowid;
134
135 if (SQL%NOTFOUND) then
136 Raise NO_DATA_FOUND;
137 end if;
138 END Delete_Row;
139
140 END SO_PICKING_LINE_DETAILS_PKG1;