1 PACKAGE GMO_DISPENSE_PVT AS
2 /* $Header: GMOVDSPS.pls 120.4.12000000.3 2007/04/17 07:16:20 achawla ship $ */
3
4 /* Returns the primary product's item number for the given batch */
5 FUNCTION GET_PRODUCT_NUMBER(P_BATCH_ID NUMBER) RETURN VARCHAR2;
6 /* Returns the primary product's item description for the given batch */
7 FUNCTION GET_PRODUCT_DESCRIPTION(P_BATCH_ID NUMBER) RETURN VARCHAR2;
8 /* Returns the complete dispense data, used in MaterialListVO view object*/
9 -- Kiosk : Start
10 PROCEDURE GET_DISPENSE_DATA (P_RESERVATION_ID NUMBER,
11 P_INVENTORY_ITEM_ID NUMBER,
12 P_ORGANIZATION_ID NUMBER,
13 P_RECIPE_ID NUMBER ,
14 P_MATERIAL_DETAILS_ID NUMBER,
15 P_RESERVATION_UOM VARCHAR2,
16 P_RESERVED_QUANTITY NUMBER,
17 P_PLAN_QUANTITY NUMBER,
18 P_PLAN_UOM VARCHAR2,
19 P_LOT_NUMBER VARCHAR2,
20 P_SHOW_IN_TOLERANCE_DATA VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.YES,
21 X_DISPENSE_UOM OUT NOCOPY VARCHAR2,
22 X_DISPENSE_CONFIG_ID OUT NOCOPY NUMBER,
23 X_RESERVED_QUANTITY OUT NOCOPY NUMBER,
24 X_PENDING_DISPENSE_QUANTITY OUT NOCOPY NUMBER,
25 X_MAX_ALLOWED_QUANTITY OUT NOCOPY NUMBER,
26 X_MIN_ALLOWED_QUANTITY OUT NOCOPY NUMBER,
27 X_INSTRUCTION_ENTITY_DEF_KEY OUT NOCOPY VARCHAR2,
28 X_PLAN_UOM_CONVERTIBLE OUT NOCOPY VARCHAR2,
29 X_RESERVATION_UOM_CONVERTIBLE OUT NOCOPY VARCHAR2,
30 X_SECURITY_FLAG OUT NOCOPY VARCHAR2
31 );
32 -- Kiosk : End
33 /* Returns T if dispense is required else F*/
34 FUNCTION IS_DISPENSE_REQUIRED(P_RESERVATION_ID NUMBER,
35 P_INVENTORY_ITEM_ID NUMBER,
36 P_ORGANIZATION_ID NUMBER,
37 P_RECIPE_ID NUMBER ,
38 P_MATERIAL_DETAILS_ID NUMBER,
39 P_RESERVED_QUANTITY NUMBER,
40 P_RESERVATION_UOM VARCHAR2,
41 P_PLAN_QUANTITY NUMBER,
42 P_PLAN_UOM VARCHAR2,
43 P_LOT_NUMBER VARCHAR2,
44 P_SHOW_IN_TOLERANCE_DATA VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.YES
45 ) RETURN VARCHAR2;
46 /* Returns Net dispensed quantity for the given Reservation*/
47 FUNCTION GET_NET_RES_DISPENSED_QTY(P_RESERVATION_ID NUMBER,
48 P_UOM VARCHAR2) RETURN NUMBER;
49 /* Returns Net dispensed quantity for the given material line */
50 FUNCTION GET_NET_MTL_DISPENSED_QTY(P_MATERIAL_DETAIL_ID NUMBER,
51 P_UOM VARCHAR2) RETURN NUMBER;
52 /* Returns Net dispensed quantity for the given dispense id */
53 FUNCTION GET_NET_DISP_DISPENSED_QTY(P_DISPENSE_ID NUMBER) RETURN NUMBER;
54 /* Returns complete reverse dispense data. Used in DispenseActivityResultVO */
55 -- Kiosk : Start
56 PROCEDURE GET_REVERSE_DISPENSE_DATA(P_DISPENSE_ID IN NUMBER,
57 X_MIN_ALLOWED_QTY OUT NOCOPY NUMBER,
58 X_MAX_ALLOWED_QTY OUT NOCOPY NUMBER,
59 X_CONFIG_ID OUT NOCOPY NUMBER,
60 X_INSTRUCTION_ENTITY_DEF_KEY OUT NOCOPY VARCHAR2,
61 X_SECURITY_FLAG OUT NOCOPY VARCHAR2);
62 -- Kiosk : End
63 /* Returns the material dispense data for group APIs. See group API
64 * comments for more details */
65 PROCEDURE GET_MATERIAL_DISPENSE_DATA(p_material_detail_id IN NUMBER,
66 x_dispense_data OUT NOCOPY GME_COMMON_PVT.reservations_tab);
67 /* Returns the last dispense ID for the given reservation */
68 FUNCTION GET_LATEST_DISPENSE_ID (p_batch_id IN NUMBER) RETURN NUMBER;
69 /* Return the last reverse dispense ID for the given dispense */
70 FUNCTION GET_LATEST_REVERSE_DISPENSE_ID (p_dispense_id IN NUMBER) RETURN NUMBER;
71 /* Calles label print API to create label context and retrn label print request
72 * ID */
73 FUNCTION GET_LABEL_REQUEST_ID (p_entity_id NUMBER,
74 p_context_param_names FND_TABLE_OF_VARCHAR2_255,
75 p_context_param_values FND_TABLE_OF_VARCHAR2_255,
76 p_label_string VARCHAR2,
77 p_entity_type VARCHAR2) RETURN NUMBER;
78 /* Return T if auto lable print is enabled */
79 FUNCTION IS_AUTO_PRINT_ENABLED RETURN VARCHAR2;
80 /* Returns the pending dispense quantity for the reservation*/
81 FUNCTION GET_PENDING_DISPENSE_QTY(P_RESERVATION_ID NUMBER,
82 P_INVENTORY_ITEM_ID NUMBER,
83 P_ORGANIZATION_ID NUMBER,
84 P_RECIPE_ID NUMBER ,
85 P_MATERIAL_DETAILS_ID NUMBER,
86 P_RESERVATION_UOM VARCHAR2,
87 P_RESERVED_QUANTITY NUMBER,
88 P_PLAN_QUANTITY NUMBER,
89 P_PLAN_UOM VARCHAR2,
90 P_LOT_NUMBER VARCHAR2) RETURN NUMBER;
91 -- Start of comments
92 -- API name : GET_TRANSACTION_XML
93 -- Type : Private Procedure
94 -- Function : This procedure performs the follwing operations:
95 -- 1. It obtains the process instruction details identified by the instruction process ID
96 -- in XML FORMAT.
97 -- 2. If P_CURRENT_XML (which is the current transaction XML) is not null then it is merged with the XML data
98 -- fetched in the previous step.
99 -- 3. The merged XML is encapsulated in the root node <ERecord> with UTF-8 encoding.
100 -- Pre-reqs : None
101 --
102 -- IN : P_INSTRUCTION_PROCESS_ID - The instruction process ID that identifies the process instruction details.
103 -- P_CURRENT_XML - The current transaction XML.
104 -- X_OUTPUT_XML - The final merged XML containing all the transaction data.
105 --
106 -- RETURN : The display name of the item identified by the item ID.
107 --End of comments
108 PROCEDURE GET_TRANSACTION_XML(P_INSTRUCTION_PROCESS_ID IN NUMBER,
109 P_CURRENT_XML IN CLOB,
110 X_OUTPUT_XML OUT NOCOPY CLOB);
111 -- Returns Total Reverse Dispensed Quantity for a given Dispense ID.
112 FUNCTION GET_NET_REVERSE_DISPENSED_QTY(P_DISPENSE_ID IN NUMBER) RETURN NUMBER;
113 -- Returns Total Material Loss Quantity for a given Dispense ID.
114 FUNCTION GET_NET_MATERIAL_LOSS(P_DISPENSE_ID IN NUMBER) RETURN NUMBER;
115 Function isDispenseOccuredAtDispBooth(disp_booth_id number) return varchar2;
116 Function isDispenseOccuredAtDispArea(disp_area_id number) return varchar2;
117
118
119 END GMO_DISPENSE_PVT;