1 PACKAGE WSH_TP_RELEASE AUTHID CURRENT_USER as
2 /* $Header: WSHTPRLS.pls 120.1.12000000.1 2007/01/16 05:51:25 appldev ship $ */
3
4 --Package for TP specific code
5
6 /*
7 Delivery's Ignore status changes :
8
9 All delivery details of the delivery must change to the same Ignore status
10 as the delivery. If the trip (that the delivery is associated with) is of
11 a different Ignore status, the user should be asked to manually unassign
12 the delivery and then perform the action, unless the trip is Load Firm,
13 in which case the trip has to be unfirmed, delivery has to be unassigned
14 and then change the status
15
16 If the trip's ignore_for_planning is changed, All deliveries of the trip
17 must change to the same Ignore status as the trip. If there are other trips
18 associated with the deliveries with a different ignore for planning, error.
19 TPW, Carrier Manifest lines, dels have to be always marked as ignore_for_plan
20 */
21
22
23
24 procedure change_ignoreplan_status
25 (p_entity IN VARCHAR2, --'DLVY', 'DLVB', 'TRIP' dep on place from which it is called
26 p_in_ids IN wsh_util_core.id_tab_type, -- table of ids of above entity
27 p_action_code IN VARCHAR2, -- either 'IGNORE_PLAN', 'INCLUDE_PLAN'
28 x_return_status OUT NOCOPY VARCHAR2);
29
30
31 PROCEDURE firm_entity( p_entity IN VARCHAR2,
32 p_entity_id IN NUMBER,
33 x_return_status OUT NOCOPY VARCHAR2);
34
35 --unfirming trip will unfirm CM as well (if CM is firm)
36 procedure unfirm_entity(
37 p_entity IN VARCHAR2,
38 p_entity_id IN NUMBER,
39 p_action IN VARCHAR2, --either 'PLAN' or 'UNPLAN'
40 x_return_status OUT NOCOPY VARCHAR2);
41
42 PROCEDURE calculate_tp_dates(
43 p_request_date_type IN VARCHAR2,
44 p_latest_acceptable_date IN DATE,
45 p_promise_date IN DATE,
46 p_schedule_arrival_date IN DATE,
47 p_schedule_ship_date IN DATE,
48 p_earliest_acceptable_date IN DATE,
49 p_demand_satisfaction_date IN DATE,
50 p_source_line_id IN NUMBER DEFAULT NULL,
51 p_source_code IN VARCHAR2 DEFAULT NULL,
52 p_organization_id IN NUMBER DEFAULT NULL,
53 p_inventory_item_id IN NUMBER DEFAULT NULL,
54 x_return_status OUT NOCOPY VARCHAR2,
55 x_earliest_pickup_date OUT NOCOPY DATE,
56 x_latest_pickup_date OUT NOCOPY DATE,
57 x_earliest_dropoff_date OUT NOCOPY DATE,
58 x_latest_dropoff_date OUT NOCOPY DATE);
59 PROCEDURE calculate_cont_del_tpdates(
60 p_entity IN VARCHAR2,
61 p_entity_ids IN wsh_util_core.id_tab_type,
62 x_return_status OUT NOCOPY VARCHAR2);
63 PROCEDURE log_tpdate_exception(p_entity VARCHAR2,
64 p_entity_id NUMBER,
65 p_pick_up BOOLEAN,
66 early_date DATE,
67 latest_date DATE
68 );
69
70 /**
71 * Check_Shipset_Ignoreflag Checks if the p_delivery_detail_id ignore_for_planning
72 * is different from other lines ignore_for_palnning which are in same ship set.
73 * If so exception is logged if p_logexcep is True otherwise warinig message is thrown.
74 */
75 PROCEDURE Check_Shipset_Ignoreflag(p_delivery_detail_ids wsh_util_core.id_tab_type,
76 p_ignore_for_planning VARCHAR2,
77 p_logexcep boolean,
78 x_return_status OUT NOCOPY VARCHAR2);
79
80 PROCEDURE Check_Shipset_Ignoreflag(p_delivery_detail_id NUMBER,
81 p_ignore_for_planning VARCHAR2,
82 p_logexcep boolean,
83 x_return_status OUT NOCOPY VARCHAR2);
84
85 END WSH_TP_RELEASE;
86
87
[Home] [Help]