1 PACKAGE WSH_DELIVERY_DETAILS_UTILITIES AUTHID CURRENT_USER as
2 /* $Header: WSHDDUTS.pls 120.0.12010000.2 2010/02/26 06:59:52 sankarun ship $ */
3
4 TYPE porcessed_flag_tbl IS TABLE OF VARCHAR2(1)
5 INDEX BY BINARY_INTEGER;
6
7
8
9 TYPE delivery_assignment_rec_type IS RECORD (
10 delivery_detail_id wsh_delivery_details.delivery_detail_id%type,
11 delivery_id wsh_new_deliveries.delivery_id%type);
12
13 TYPE delivery_assignment_rec_tbl IS TABLE OF delivery_assignment_rec_type
14 INDEX BY BINARY_INTEGER;
15
16 PROCEDURE Append_to_Deliveries(
17 p_delivery_detail_tbl IN WSH_UTIL_CORE.Id_Tab_Type,
18 p_append_flag IN VARCHAR2 DEFAULT NULL,
19 p_group_by_header IN VARCHAR2 DEFAULT NULL,
20 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
21 p_lock_rows IN VARCHAR2 DEFAULT FND_API.G_FALSE,
22 p_check_fte_compatibility IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23 x_appended_det_tbl OUT NOCOPY WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl,
24 x_unappended_det_tbl OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
25 x_appended_del_tbl OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
26 x_return_status OUT NOCOPY VARCHAR2);
27
28 -- TPW - Distributed Organization Changes - Start
29 --
30 --=============================================================================
31 -- PUBLIC PROCEDURE :
32 -- Check_Updates_Allowed
33 --
34 -- PARAMETERS:
35 -- p_changed_attributes => Delivery Details changed attributes
36 -- p_source_code => Source Code
37 -- x_update_allowed => Update Allowed Flag
38 -- x_return_status => Return Status of API (S,E,U)
39 --
40 -- COMMENT:
41 -- API will not allow updates other than Ordered Quantity and Order
42 -- Quantity UOM, if
43 -- 1) Organization is Distributed Enabled Org (TW2)
44 -- 2) Delivery line corresponding to order line is associated with
45 -- Shipment batch.
46 -- Increase in quantity is always allowed
47 -- For decrease in quantity, there should be delivery line(s) which are
48 -- not yet assigned to Shipment Batch atleast for quantity being cancelled.
49 --=============================================================================
50 --
51 PROCEDURE Check_Updates_Allowed(
52 p_changed_attributes IN WSH_INTERFACE.ChangedAttributeTabType,
53 p_source_code IN VARCHAR2,
54 x_update_allowed OUT NOCOPY VARCHAR2,
55 x_return_status OUT NOCOPY VARCHAR2);
56 -- TPW - Distributed Organization Changes - End
57
58
59 END WSH_DELIVERY_DETAILS_UTILITIES;
[Home] [Help]