PACKAGE: APPS.WSH_DELIVERY_LEGS_GRP

Source

1 PACKAGE WSH_DELIVERY_LEGS_GRP as
2 /* $Header: WSHDGGPS.pls 120.0.12000000.1 2007/01/16 05:44:45 appldev ship $ */
3 
4 c_sdebug    CONSTANT NUMBER := wsh_debug_sv.c_level1;
5 c_debug     CONSTANT NUMBER := wsh_debug_sv.c_level2;
6 
7 TYPE action_parameters_rectype  IS RECORD(
8 caller              		VARCHAR2(32000),
9 action_code			VARCHAR2(32000),
10 phase				NUMBER,
11 p_Pick_Up_Location_Id		NUMBER,
12 p_Ship_Method			VARCHAR2(30),
13 p_Drop_Off_Location_Id		NUMBER,
14 p_Carrier_Id			NUMBER,
15 p_print_bol_from_dleg           Varchar2(1) default null
16 );
17 
18 --Pack J: kvenkate: Added result_id_tab to action out rec type
19 
20 TYPE action_out_rec_type IS RECORD(
21 valid_id_tab          		WSH_UTIL_CORE.id_tab_type,
22 selection_issue_flag  		VARCHAR2(1),
23 x_trip_id			NUMBER,
24 x_trip_name			VARCHAR2(30),
25 x_delivery_id			NUMBER,
26 x_bol_number			VARCHAR2(32000),
27 result_id_tab                   wsh_util_core.id_tab_type);
28 
29 TYPE dlvy_leg_tab_type IS TABLE of WSH_DELIVERY_LEGS_PVT.Delivery_Leg_Rec_Type INDEX by BINARY_INTEGER;
30 
31 PROCEDURE Delivery_Leg_Action(
32 	p_api_version_number	 	IN 	NUMBER,
33 	p_init_msg_list			IN	VARCHAR2,
34 	p_commit                 	IN 	VARCHAR2,
35 	p_rec_attr_tab			IN	dlvy_leg_tab_type,
36 	p_action_prms			IN	action_parameters_rectype,
37 	x_action_out_rec		IN OUT  NOCOPY action_out_rec_type,
38 	x_return_status  		OUT 	NOCOPY VARCHAR2,
39 	x_msg_count     		OUT 	NOCOPY NUMBER,
40 	x_msg_data       		OUT 	NOCOPY VARCHAR2
41 );
42 
43 
44 PROCEDURE Update_Delivery_Leg(
45 p_api_version_number     IN     NUMBER,
46 p_init_msg_list          IN     VARCHAR2,
47 p_commit                 IN     VARCHAR2,
48 p_delivery_leg_tab       IN     WSH_DELIVERY_LEGS_GRP.dlvy_leg_tab_type,
49 p_in_rec                 IN     WSH_DELIVERY_LEGS_GRP.action_parameters_rectype,
50 x_out_rec                OUT    NOCOPY WSH_DELIVERY_LEGS_GRP.action_out_rec_type,
51 x_return_status          OUT    NOCOPY VARCHAR2,
52 x_msg_count              OUT    NOCOPY NUMBER,
53 x_msg_data               OUT    NOCOPY VARCHAR2);
54 
55 
56 END WSH_DELIVERY_LEGS_GRP;