1 PACKAGE GML_MOBILE_RECEIPT AUTHID CURRENT_USER AS
2 /* $Header: GMLMRCVS.pls 120.0 2005/05/25 16:28:27 appldev noship $ */
3
4 TYPE t_genref IS REF CURSOR;
5
6
7 --yannamal 4189249 Added NOCOPY for x_return_status and x_error_msg
8 PROCEDURE Check_Lot_Status(p_lot_id IN NUMBER,
9 p_lot_num IN VARCHAR2,
10 p_sublot_num IN VARCHAR2,
11 p_item_id IN NUMBER,
12 p_org_id IN NUMBER,
13 p_locator_id IN NUMBER,
14 p_reason_code IN VARCHAR2,
15 x_return_status OUT NOCOPY VARCHAR2,
16 x_error_msg OUT NOCOPY VARCHAR2);
17
18 PROCEDURE Get_Lot_LoV( x_lot_lov OUT NOCOPY t_genref,
19 p_item_id IN NUMBER,
20 p_lot_no IN VARCHAR2);
21
22
23 PROCEDURE Get_SubLot_LoV( x_sublot_lov OUT NOCOPY t_genref,
24 p_item_id IN NUMBER,
25 p_lot_no IN VARCHAR2,
26 p_sublot_no IN VARCHAR2);
27
28 PROCEDURE Get_Reason_Code_LoV( x_reason_code_lov OUT NOCOPY t_genref,
29 p_reason_code IN VARCHAR2);
30
31 PROCEDURE Get_Location_Lov( x_location_lov OUT NOCOPY t_genref,
32 p_location IN VARCHAR2,
33 p_item_id IN NUMBER,
34 p_whse_code IN VARCHAR2,
35 p_lot_id IN NUMBER);
36
37 PROCEDURE insert_lot(
38 p_transaction_interface_id IN OUT NOCOPY NUMBER
39 , p_product_transaction_id IN OUT NOCOPY NUMBER
40 , p_created_by IN NUMBER
41 , p_transaction_qty IN NUMBER
42 , p_secondary_qty IN NUMBER
43 , p_primary_qty IN NUMBER
44 , p_lot_number IN VARCHAR2
45 , p_sublot_number IN VARCHAR2
46 , p_expiration_date IN DATE
47 , p_secondary_unit_of_measure IN VARCHAR2
48 , p_reason_code IN VARCHAR2
49 , x_return_status OUT NOCOPY VARCHAR2
50 , x_msg_data OUT NOCOPY VARCHAR2
51 );
52
53 PROCEDURE GET_PO_LINE_ITEM_NUM_LOV(x_po_line_num_lov OUT NOCOPY t_genref,
54 p_organization_id IN NUMBER,
55 p_po_header_id IN NUMBER,
56 p_mobile_form IN VARCHAR2,
57 p_po_line_num IN VARCHAR2,
58 p_inventory_item_id IN VARCHAR2);
59
60 PROCEDURE Get_UoM_LoV_RcV(x_uoms OUT NOCOPY t_genref,
61 p_organization_id IN NUMBER,
62 p_item_id IN NUMBER,
63 p_uom_type IN NUMBER,
64 p_uom_code IN VARCHAR2);
65
66 PROCEDURE rcv_clear_global;
67
68 PROCEDURE get_uom_code(
69 x_return_status OUT NOCOPY VARCHAR2
70 , x_uom_code OUT NOCOPY VARCHAR2
71 , p_po_header_id IN NUMBER
72 , p_item_id IN NUMBER
73 , p_organization_id IN NUMBER
74 );
75
76 PROCEDURE Create_Lot(p_item_id IN NUMBER,
77 p_item_no IN VARCHAR2,
78 p_lot_no IN VARCHAR2,
79 p_sublot_no IN VARCHAR2,
80 p_vendor_id IN NUMBER,
81 x_lot_id OUT NOCOPY NUMBER,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_error_msg OUT NOCOPY VARCHAR2);
84
85 --yannamal 4189249 Added NOCOPY for x_message
86 PROCEDURE get_stacked_messages(x_message OUT NOCOPY VARCHAR2);
87
88 PROCEDURE GET_DOC_LOV(x_doc_num_lov OUT NOCOPY t_genref,
89 p_organization_id IN NUMBER,
90 p_doc_number IN VARCHAR2,
91 p_mobile_form IN VARCHAR2,
92 p_manual_po_num_type IN VARCHAR2,
93 p_shipment_header_id IN VARCHAR2,
94 p_inventory_item_id IN VARCHAR2,
95 p_item_description IN VARCHAR2,
96 p_doc_type IN VARCHAR2,
97 p_vendor_prod_num IN VARCHAR2);
98
99
100 PROCEDURE GET_ITEM_LOV_RECEIVING (
101 x_Items OUT NOCOPY t_genref,
102 p_Organization_Id IN NUMBER,
103 p_Concatenated_Segments IN VARCHAR2,
104 p_poHeaderID IN VARCHAR2,
105 p_poReleaseID IN VARCHAR2,
106 p_poLineID IN VARCHAR2,
107 p_shipmentHeaderID IN VARCHAR2,
108 p_oeOrderHeaderID IN VARCHAR2,
109 p_reqHeaderID IN VARCHAR2,
110 p_projectId IN VARCHAR2,
111 p_taskId IN VARCHAR2,
112 p_pjmorg IN VARCHAR2,
113 p_crossreftype IN VARCHAR2
114 );
115
116
117 PROCEDURE GET_COUNTRY_LOV
118 (x_country_lov OUT NOCOPY t_genref,
119 p_country IN VARCHAR2 );
120
121 PROCEDURE Get_Sub_Lov_RcV(x_sub OUT NOCOPY t_genref,
122 p_organization_id IN NUMBER,
123 p_item_id IN NUMBER,
124 p_sub IN VARCHAR2,
125 p_restrict_subinventories_code IN NUMBER,
126 p_transaction_type_id IN NUMBER,
127 p_wms_installed IN VARCHAR2);
128
129 PROCEDURE clear_lot_rec;
130
131 PROCEDURE Calculate_Secondary_Qty(
132 p_item_no IN VARCHAR2
133 , p_unit_of_measure IN VARCHAR2
134 , p_quantity IN NUMBER
135 , p_lot_no IN VARCHAR2
136 , p_sublot_no IN VARCHAR2
137 , p_secondary_unit_of_measure IN VARCHAR2
138 , x_secondary_quantity OUT NOCOPY NUMBER
139 );
140
141 PROCEDURE get_dynamic_locator(x_location_id OUT NOCOPY NUMBER,
142 x_description OUT NOCOPY VARCHAR2,
143 x_result OUT NOCOPY VARCHAR2,
144 x_exist_or_create OUT NOCOPY VARCHAR2,
145 p_org_id IN NUMBER,
146 p_sub_code IN VARCHAR2,
147 p_concat_segs IN VARCHAR2);
148
149 PROCEDURE get_prj_loc_lov(
150 x_locators OUT NOCOPY t_genref
151 , p_organization_id IN NUMBER
152 , p_subinventory_code IN VARCHAR2
153 , p_restrict_locators_code IN NUMBER
154 , p_inventory_item_id IN NUMBER
155 , p_concatenated_segments IN VARCHAR2
156 , p_transaction_type_id IN NUMBER
157 , p_wms_installed IN VARCHAR2
158 , p_project_id IN NUMBER
159 , p_task_id IN NUMBER
160 );
161
162 END GML_MOBILE_RECEIPT;