1 PACKAGE PO_ITEMS_SV2 AUTHID CURRENT_USER as
2 /* $Header: POXCOI2S.pls 120.0 2005/06/01 19:45:33 appldev noship $ */
3 /*===========================================================================
4 PACKAGE NAME: PO_ITEMS_SV2
5
6 DESCRIPTION: This package contains the server side Item related
7 Application Program Interfaces (APIs). This api
8 obtains information based on the item and organization.
9
10 CLIENT/SERVER: Server
11
12 OWNER: Melissa Snyder
13
14 PROCEDURE NAMES: get_item_details()
15 get_item_status()
16 get_item_cost ()
17
18 ===========================================================================*/
19
20 procedure get_item_details( X_item_id IN NUMBER,
21 X_inventory_organization_id IN NUMBER,
22 X_planned_item_flag IN OUT NOCOPY VARCHAR2,
23 X_outside_operation_flag IN OUT NOCOPY VARCHAR2,
24 X_outside_op_uom_type IN OUT NOCOPY VARCHAR2,
25 X_invoice_close_tolerance IN OUT NOCOPY NUMBER,
26 X_receive_close_tolerance IN OUT NOCOPY NUMBER,
27 X_receipt_required_flag IN OUT NOCOPY VARCHAR2,
28 X_stock_enabled_flag IN OUT NOCOPY VARCHAR2,
29 X_internal_orderable IN OUT NOCOPY VARCHAR2,
30 X_purchasing_enabled IN OUT NOCOPY VARCHAR2,
31 X_inventory_asset_flag IN OUT NOCOPY VARCHAR2,
32 /* INVCONV BEGIN PBAMB */
33 X_secondary_default_ind IN OUT NOCOPY VARCHAR2,
34 X_grade_control_flag IN OUT NOCOPY VARCHAR2,
35 X_secondary_unit_of_measure IN OUT NOCOPY VARCHAR2 );
36 /* INVCONV END PBAMB */
37
38 /*===========================================================================
39 PROCEDURE NAME: get_item_status
40
41 DESCRIPTION: Get the item status for autocreating shipments/distributions.
42 This has been created to cause the least amount of
43 ripple effect to all other people who might have already
44 used either get_item_details or get_item_info procedures.
45 This can ceratinly be merged into both those procedures.
46
47 PARAMETERS:
48
49 DESIGN REFERENCES:
50
51 ALGORITHM:
52
53 NOTES:
54
55 OPEN ISSUES:
56
57 CLOSED ISSUES:
58
59 CHANGE HISTORY: Created 31-JUL-95 SIYER
60 ==============================================================================*/
61
62 procedure get_item_status( X_item_id IN NUMBER,
63 X_ship_org_id IN NUMBER,
64 X_item_status IN OUT NOCOPY VARCHAR2);
65
66
67 /*===========================================================================
68 PROCEDURE NAME: get_latest_item_rev
69
70 DESCRIPTION: get the latest implemented item rev to be used as
71 a default for the Enter Receipts form
72
73 PARAMETERS: X_item_id IN NUMBER,
74 X_organization_id IN NUMBER
75 X_item_revision IN OUT VARCHAR2,
76 X_rev_exists OUT BOOLEAN
77
78 DESIGN REFERENCES: ../RCVRCERC.dd
79
80 ALGORITHM:
81
82 NOTES:
83
84 OPEN ISSUES:
85
86 CLOSED ISSUES:
87
88 CHANGE HISTORY: Created 27-JUN-95 GKELLNER
89 ===========================================================================*/
90
91 PROCEDURE get_latest_item_rev (
92 X_item_id IN NUMBER,
93 X_organization_id IN NUMBER,
94 X_item_revision IN OUT NOCOPY VARCHAR2,
95 X_rev_exists OUT NOCOPY BOOLEAN);
96
97 /*===========================================================================
98 PROCEDURE NAME: val_item_rev_controls
99
100 DESCRIPTION: get the item revision control flag and if needed, try
101 to get the most up-to-date revision.
102 You only need to check for item rev if you're doing an
103 receipt/delivery for an inventory final destination
104
105 PARAMETERS: X_transaction_type IN VARCHAR2
106 X_auto_transact_code IN VARCHAR2
107 X_po_line_location_id IN NUMBER
108 X_shipment_line_id IN NUMBER
109 X_to_organization_id IN NUMBER
110 X_destination_type_code IN VARCHAR2
111 X_item_id IN NUMBER
112 X_item_revision IN VARCHAR2
113
114 RETURN BOOLEAN - Is the item rev valid based on the
115 destination type
116
117 DESIGN REFERENCES: ../RCVRCERC.dd
118
119 ALGORITHM:
120
121 NOTES:
122
123 OPEN ISSUES:
124
125 CLOSED ISSUES:
126
127 CHANGE HISTORY: Created 10-JUL-95 GKELLNER
128 ===========================================================================*/
129
130 FUNCTION val_item_rev_controls (
131 X_transaction_type IN VARCHAR2,
132 X_auto_transact_code IN VARCHAR2,
133 X_po_line_location_id IN NUMBER,
134 X_shipment_line_id IN NUMBER,
135 X_to_organization_id IN NUMBER,
136 X_destination_type_code IN VARCHAR2,
137 X_item_id IN NUMBER,
138 X_item_revision IN VARCHAR2)
139 RETURN BOOLEAN;
140
141
142 /*===========================================================================
143 PROCEDURE NAME: get_item_cost
144
145 DESCRIPTION: Obtain the item cost. If the
146 cost is not available then this
147 procedure returns zero.
148
149 PARAMETERS: x_item_id IN NUMBER
150 x_organization_id IN NUMBER
151 x_inv_cost OUT NUMBER
152
153 DESIGN REFERENCES: POXRQERQ.doc
154
155 ALGORITHM:
156
157 NOTES:
158
159 OPEN ISSUES:
160
161 CLOSED ISSUES:
162
163 CHANGE HISTORY: RMULPURY 04/16 Created
164 ===========================================================================*/
165
166 PROCEDURE get_item_cost (x_item_id IN NUMBER,
167 x_organization_id IN NUMBER,
168 x_inv_cost OUT NOCOPY NUMBER);
169
170 END PO_ITEMS_SV2;