1 PACKAGE rcv_sub_locator_sv AUTHID CURRENT_USER AS
2 /* $Header: RCVTXLOS.pls 115.2 2002/11/25 21:42:19 sbull ship $*/
3
4
5 /*===========================================================================
6 PROCEDURE NAME: put_away_api
7
8 DESCRIPTION:
9
10 This function is meant to be an user extensible feature that allows the
11 user to add derivation rules to set the default deliver subinventory
12 and locator_id. The Receipts, Transactions, and Returns forms in
13 Oracle Purchasing use this function to determine what the default value
14 for the sub and locator should be. If you wish to create you're own
15 rules for this function, then feel free to add any logic that you wish.
16
17 PARAMETERS:
18
19 x_line_location_id IN NUMBER - The primary key (line_location_id)
20 from the po_line_locations table
21 Only for Receipt_Source_Code = VENDOR
22
23 x_po_distribution_id IN NUMBER - The primary key (po_distribution_id)
24 from the po_distributions table
25 Only for Receipt_Source_Code = VENDOR
26
27 x_shipment_line_id IN NUMBER - The primary key (shipment_line_id)
28 from the rcv_shipment_lines table
29
30 x_receipt_source_code IN VARCHAR2- Describes the type of document the
31 shipment is based upon. Possible
32 values are 'INTERNAL ORDER' (for
33 internal requisition transaction),
34 'INVENTORY' (for in-transit
35 transaction),VENDOR (for purchase order
36 transaction). Source of this value is
37 SHIPMENT SOURCE TYPE lookup value from
38 po_lookup_codes.
39
40 x_ship_from_org_id IN NUMBER - Organization that the shipment came
41 from
42 Only for Receipt_Source_Code =
43 INTERNAL ORDER or INVENTORY
44
45
46 x_ship_to_org_id IN NUMBER - Destination Organization for the
47 shipment
48
49 x_item_id IN NUMBER - The item primary key from
50 mtl_system_items
51
52 x_item_revision IN VARCHAR2- The revision of the item that you are
53 transacting
54
55 x_vendor_id IN NUMBER - The vendor primary key from
56 po_vendors
57
58 x_ship_to_location_id IN NUMBER - The ship to location id primary key
59 from hr_locations
60
61 x_deliver_to_location_id IN NUMBER - The deliver to location id primary key
62 from hr_locations
63
64 x_deliver_to_person_id IN NUMBER - The deliver to person id primary key
65 from hr_employees
66
67 x_available_qty IN NUMBER - The quantity available to transact in
68 the parent unit of measure. The parent
69 being for a receipt the purchase order
70 line unit or for a inspection it's
71 the receipt unit.
72
73 x_uom IN VARCHAR2- Parent unit of measure. The parent
74 being for a receipt the purchase order
75 line unit or for a inspection it's
76 the receipt unit.
77
78 x_primary_qty IN NUMBER - The quantity available to transact in
79 the primary unit of measure
80
81 x_primary_uom IN VARCHAR2- Primary unit of measure.
82
83 x_tolerable_qty IN NUMBER - The maximum quantity that can be
84 transacted based on quantity
85 precentage tolerances. This is only
86 applicable to receipts since the max
87 for other transactions is what's
88 available for the parent transaction.
89
90 x_routing_id IN NUMBER - The routing definition for the shipment
91 1=Standard receipt, 2=Inspection
92 3=Direct Receipt
93 x_default_subinventory IN VARCHAR2- The default subinventory derived
94 using our standard rules and
95 functionality
96 x_default_locator_id IN NUMBER - The default locator_id derived
97 using our standard rules and
98 functionality
99 x_subinventory IN OUT VARCHAR2 - The outbound subinventory that
100 you've derived
101 x_locator_id IN OUT NUMBER - The outbound locator_id that
102 you've derived
103
104 RETURN VALUE BOOLEAN - Not currently used
105
106 DESIGN REFERENCES:
107
108 ALGORITHM:
109
110 NOTES:
111
112 OPEN ISSUES:
113
114 CLOSED ISSUES:
115
116 CHANGE HISTORY:
117
118 ===========================================================================*/
119 FUNCTION put_away_api ( x_line_location_id IN NUMBER,
120 x_po_distribution_id IN NUMBER,
121 x_shipment_line_id IN NUMBER,
122 x_receipt_source_code IN VARCHAR2,
123 x_ship_from_org_id IN NUMBER,
124 x_ship_to_org_id IN NUMBER,
125 x_item_id IN NUMBER,
126 x_item_revision IN VARCHAR2,
127 x_vendor_id IN NUMBER,
128 x_ship_to_location_id IN NUMBER,
129 x_deliver_to_location_id IN NUMBER,
130 x_deliver_to_person_id IN NUMBER,
131 x_available_qty IN NUMBER,
132 x_primary_qty IN NUMBER,
133 x_primary_uom IN VARCHAR2,
134 x_tolerable_qty IN NUMBER,
135 x_uom IN VARCHAR2,
136 x_routing_id IN NUMBER,
137 x_default_subinventory IN VARCHAR2,
138 x_default_locator_id IN NUMBER,
139 x_subinventory IN OUT NOCOPY VARCHAR2,
140 x_locator_id IN OUT NOCOPY NUMBER )
141
142 RETURN BOOLEAN;
143
144
145 END rcv_sub_locator_sv;