[Home] [Help]
PACKAGE: APPS.GML_MOBILE_SHIP_CONFIRM
Source
1 PACKAGE GML_MOBILE_SHIP_CONFIRM AS
2 /* $Header: GMLMOSCS.pls 120.0 2005/05/25 16:29:21 appldev noship $ */
3
4 TYPE t_genref IS REF CURSOR;
5 G_PKG_NAME VARCHAR2(30) := 'GMI_MOBILE_SHIP_CONFIRM';
6
7 PROCEDURE INV_DELIVERY_LINE_INFO(x_deliveryLineInfo OUT NOCOPY t_genref,
8 p_delivery_id IN NUMBER,
9 p_inventory_item_id IN NUMBER,
10 x_return_Status OUT NOCOPY VARCHAR2);
11
12 PROCEDURE INV_LINE_RETURN_TO_STOCK(p_delivery_id IN NUMBER,
13 p_delivery_line_id IN NUMBER,
14 p_shipped_quantity IN NUMBER,
15 p_shipped_quantity2 IN NUMBER,
16 x_return_status OUT NOCOPY VARCHAR2,
17 x_msg_data OUT NOCOPY VARCHAR2,
18 x_msg_count OUT NOCOPY NUMBER,
19 p_commit_flag IN VARCHAR2 DEFAULT FND_API.g_false,
20 p_relieve_rsv IN VARCHAR2 DEFAULT 'Y');
21
22
23 PROCEDURE INV_REPORT_MISSING_QTY(
24 p_delivery_line_id IN NUMBER,
25 p_missing_quantity IN NUMBER,
26 p_missing_quantity2 IN NUMBER,
27 x_return_status OUT NOCOPY VARCHAR2,
28 x_msg_data OUT NOCOPY VARCHAR2,
29 x_msg_count OUT NOCOPY NUMBER);
30
31 PROCEDURE SUBMIT_DELIVERY_LINE(p_delivery_line_id IN NUMBER,
32 p_quantity IN NUMBER,
33 p_quantity2 IN NUMBER,
34 p_trackingNumber IN VARCHAR2,
35 x_return_status OUT NOCOPY VARCHAR2,
36 x_msg_data OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER );
38
39 FUNCTION GET_SHIPMETHOD_MEANING(p_ship_method_code IN VARCHAR2)
40 RETURN VARCHAR2;
41
42 PROCEDURE GET_DELIVERY_INFO(x_delivery_info OUT NOCOPY t_genref,
43 p_delivery_id IN NUMBER);
44
45
46
47 PROCEDURE CONFIRM_DELIVERY (
48 p_ship_delivery IN VARCHAR2 DEFAULT NULL,
49 p_delivery_id IN NUMBER,
50 p_organization_id IN NUMBER,
51 p_delivery_name IN VARCHAR2,
52 p_carrier_id IN NUMBER,
53 p_ship_method_code IN VARCHAR2,
54 p_gross_weight IN NUMBER,
55 p_gross_weight_uom IN VARCHAR2,
56 p_bol IN VARCHAR2,
57 p_waybill IN VARCHAR2,
58 p_action_flag IN VARCHAR2,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_ret_code OUT NOCOPY NUMBER,
61 x_msg_data OUT NOCOPY VARCHAR2,
62 x_msg_count OUT NOCOPY NUMBER);
63
64
65 PROCEDURE UNASSIGN_LINES_AND_CONFIRM (
66 p_delivery_id IN NUMBER,
67 p_organization_id IN NUMBER,
68 p_delivery_name IN VARCHAR2,
69 p_carrier_id IN NUMBER,
70 p_ship_method_code IN VARCHAR2,
71 p_gross_weight IN NUMBER,
72 p_gross_weight_uom IN VARCHAR2,
73 p_bol IN VARCHAR2,
74 p_waybill IN VARCHAR2,
75 p_action_flag IN VARCHAR2,
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_msg_data OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY NUMBER);
79
80
81
82 PROCEDURE CHECK_SHIP_SET(
83 p_delivery_id IN NUMBER,
84 x_ship_set OUT NOCOPY VARCHAR2,
85 x_return_Status OUT NOCOPY VARCHAR2,
86 x_error_msg OUT NOCOPY VARCHAR2);
87
88 PROCEDURE CHECK_COMPLETE_DELVIERY(
89 p_delivery_id IN NUMBER,
90 x_return_Status OUT NOCOPY VARCHAR2,
91 x_error_msg OUT NOCOPY VARCHAR2);
92
93
94 PROCEDURE Get_Ship_Conf_Delivery_Lov(x_deliveryLOV OUT NOCOPY t_genref,
95 p_delivery_name IN VARCHAR2,
96 p_organization_id IN NUMBER);
97
98
99 PROCEDURE Get_Ship_Items_Lov(x_items OUT NOCOPY t_genref,
100 p_organization_id IN NUMBER,
101 p_delivery_id IN NUMBER,
102 p_concatenated_segments IN VARCHAR2);
103
104 PROCEDURE Get_Ship_Method_LoV(x_shipMethodLOV OUT NOCOPY t_genref,
105 p_organization_id IN NUMBER,
106 p_ship_method_name IN VARCHAR2);
107
108
109 END GML_MOBILE_SHIP_CONFIRM;