eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_DELIVERY_DETAILS_GRP dependencies on WSH_GLBL_VAR_STRCT_GRP

Line 54: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,

50:
51:
52: -- Forward Declarations for local procedures
53: PROCEDURE Create_Delivery_Detail(
54: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
55: p_detail_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
56: p_valid_index_tab IN wsh_util_core.id_tab_type,
57: x_detail_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType,
58: x_return_status OUT NOCOPY VARCHAR2,

Line 55: p_detail_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,

51:
52: -- Forward Declarations for local procedures
53: PROCEDURE Create_Delivery_Detail(
54: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
55: p_detail_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
56: p_valid_index_tab IN wsh_util_core.id_tab_type,
57: x_detail_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType,
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_msg_count OUT NOCOPY NUMBER,

Line 57: x_detail_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType,

53: PROCEDURE Create_Delivery_Detail(
54: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
55: p_detail_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
56: p_valid_index_tab IN wsh_util_core.id_tab_type,
57: x_detail_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType,
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_msg_count OUT NOCOPY NUMBER,
60: x_msg_data OUT NOCOPY VARCHAR2
61: );

Line 64: x_detail_info_tab IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,

60: x_msg_data OUT NOCOPY VARCHAR2
61: );
62:
63: PROCEDURE Validate_Delivery_Detail(
64: x_detail_info_tab IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
65: p_in_detail_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
66: p_action IN VARCHAR2,
67: p_validation_tab IN wsh_util_core.Id_Tab_Type,
68: p_caller IN varchar2,

Line 65: p_in_detail_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,

61: );
62:
63: PROCEDURE Validate_Delivery_Detail(
64: x_detail_info_tab IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
65: p_in_detail_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
66: p_action IN VARCHAR2,
67: p_validation_tab IN wsh_util_core.Id_Tab_Type,
68: p_caller IN varchar2,
69: x_valid_index_tab OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,

Line 75: p_in_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,

71: x_detail_tender_tab OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
72: x_return_status OUT NOCOPY VARCHAR2,
73: x_msg_count OUT NOCOPY NUMBER,
74: x_msg_data OUT NOCOPY VARCHAR2,
75: p_in_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
76: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType
77: );
78:
79: PROCEDURE Update_Delivery_Detail(

Line 76: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType

72: x_return_status OUT NOCOPY VARCHAR2,
73: x_msg_count OUT NOCOPY NUMBER,
74: x_msg_data OUT NOCOPY VARCHAR2,
75: p_in_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
76: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType
77: );
78:
79: PROCEDURE Update_Delivery_Detail(
80: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,

Line 80: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,

76: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType
77: );
78:
79: PROCEDURE Update_Delivery_Detail(
80: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,
81: p_valid_index_tab IN wsh_util_core.id_tab_type,
82: x_return_status OUT NOCOPY varchar2,
83: x_msg_count OUT NOCOPY NUMBER,
84: x_msg_data OUT NOCOPY VARCHAR2,

Line 98: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,

94: -- Created: Harmonization Project. Patchset I
95: -- -----------------------------------------------------------------------
96:
97: PROCEDURE Cancel_Delivery_Detail(
98: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,
101: x_msg_data OUT NOCOPY VARCHAR2,
102: p_caller IN VARCHAR2 DEFAULT NULL

Line 108: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,

104:
105:
106:
107: PROCEDURE Validate_Detail_Line(
108: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
109: p_in_detail_rec IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
110: p_original_rec IN c_original_detail_cur%ROWTYPE,
111: p_validation_tab IN WSH_UTIL_CORE.id_tab_type,
112: x_mark_reprice_flag OUT NOCOPY VARCHAR2,

Line 109: p_in_detail_rec IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,

105:
106:
107: PROCEDURE Validate_Detail_Line(
108: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
109: p_in_detail_rec IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
110: p_original_rec IN c_original_detail_cur%ROWTYPE,
111: p_validation_tab IN WSH_UTIL_CORE.id_tab_type,
112: x_mark_reprice_flag OUT NOCOPY VARCHAR2,
113: x_return_status OUT NOCOPY VARCHAR2,

Line 116: p_in_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,

112: x_mark_reprice_flag OUT NOCOPY VARCHAR2,
113: x_return_status OUT NOCOPY VARCHAR2,
114: x_msg_count OUT NOCOPY NUMBER,
115: x_msg_data OUT NOCOPY VARCHAR2,
116: p_in_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
117: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType
118: );
119:
120: PROCEDURE Validate_Detail_Container(

Line 117: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType

113: x_return_status OUT NOCOPY VARCHAR2,
114: x_msg_count OUT NOCOPY NUMBER,
115: x_msg_data OUT NOCOPY VARCHAR2,
116: p_in_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
117: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType
118: );
119:
120: PROCEDURE Validate_Detail_Container(
121: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,

Line 121: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,

117: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType
118: );
119:
120: PROCEDURE Validate_Detail_Container(
121: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
122: p_original_rec IN c_original_detail_cur%ROWTYPE,
123: p_validation_tab IN WSH_UTIL_CORE.id_tab_type,
124: x_mark_reprice_flag OUT NOCOPY VARCHAR2,
125: x_return_status OUT NOCOPY VARCHAR2,

Line 131: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,

127: x_msg_data OUT NOCOPY VARCHAR2
128: );
129:
130: PROCEDURE Validate_Detail_Common(
131: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
132: p_original_rec IN c_original_detail_cur%ROWTYPE,
133: p_validation_tab IN wsh_util_core.id_tab_type,
134: x_mark_reprice_flag OUT NOCOPY VARCHAR2,
135: x_return_status OUT NOCOPY VARCHAR2,

Line 180: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type -- J-IB-NPARIKH

176: p_tabofdeldets IN WSH_UTIL_CORE.id_tab_type,
177: p_action IN VARCHAR2,
178: p_delivery_id IN NUMBER,
179: p_delivery_name IN VARCHAR2,
180: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type -- J-IB-NPARIKH
181: ) IS
182: -- Standard call to check for call compatibility
183: l_api_version CONSTANT NUMBER := 1.0;
184: l_api_name CONSTANT VARCHAR2(30) := 'delivery_detail_to_delivery';

Line 643: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type; -- J-IB-NPARIKH

639: l_debug_on BOOLEAN;
640: --
641: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || g_pkg_name || '.' || 'DETAIL_TO_DELIVERY';
642: --
643: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type; -- J-IB-NPARIKH
644: BEGIN
645: --
646: l_debug_on := wsh_debug_interface.g_debug;
647:

Line 1123: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;

1119: l_api_name VARCHAR2(30) := 'Update_Shipping_Attributes';
1120:
1121: l_msg_count NUMBER;
1122: l_msg_data VARCHAR2(32767);
1123: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
1124: l_detail_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
1125: l_detail_out_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
1126: l_dummy_ids wsh_util_core.id_Tab_type;
1127: invalid_source_code exception;

Line 1124: l_detail_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;

1120:
1121: l_msg_count NUMBER;
1122: l_msg_data VARCHAR2(32767);
1123: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
1124: l_detail_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
1125: l_detail_out_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
1126: l_dummy_ids wsh_util_core.id_Tab_type;
1127: invalid_source_code exception;
1128: mark_reprice_error exception;

Line 1125: l_detail_out_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;

1121: l_msg_count NUMBER;
1122: l_msg_data VARCHAR2(32767);
1123: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
1124: l_detail_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
1125: l_detail_out_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
1126: l_dummy_ids wsh_util_core.id_Tab_type;
1127: invalid_source_code exception;
1128: mark_reprice_error exception;
1129: update_failed exception;

Line 2231: p_rec_attr_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,

2227: x_msg_count OUT NOCOPY NUMBER,
2228: x_msg_data OUT NOCOPY VARCHAR2,
2229:
2230: -- Procedure specific Parameters
2231: p_rec_attr_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
2232: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
2233: x_defaults OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type, -- defaults
2234: x_action_out_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type
2235: ) IS

Line 2232: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,

2228: x_msg_data OUT NOCOPY VARCHAR2,
2229:
2230: -- Procedure specific Parameters
2231: p_rec_attr_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
2232: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
2233: x_defaults OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type, -- defaults
2234: x_action_out_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type
2235: ) IS
2236:

Line 2233: x_defaults OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type, -- defaults

2229:
2230: -- Procedure specific Parameters
2231: p_rec_attr_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
2232: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
2233: x_defaults OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type, -- defaults
2234: x_action_out_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type
2235: ) IS
2236:
2237: l_api_name CONSTANT VARCHAR2(30) := 'delivery_detail_action';

Line 2234: x_action_out_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type

2230: -- Procedure specific Parameters
2231: p_rec_attr_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
2232: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
2233: x_defaults OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type, -- defaults
2234: x_action_out_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type
2235: ) IS
2236:
2237: l_api_name CONSTANT VARCHAR2(30) := 'delivery_detail_action';
2238: l_api_version CONSTANT NUMBER := 1.0;

Line 2413: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;

2409: l_trip_id NUMBER;
2410:
2411: --dummy tables for calling validate_constraint_mainper
2412: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2413: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
2414: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2415: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2416: l_cc_in_ids wsh_util_core.id_tab_type;
2417: l_cc_fail_ids wsh_util_core.id_tab_type;

Line 2437: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;

2433: l_delivery_already_included boolean;
2434: --
2435: --
2436: l_cnt NUMBER;
2437: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
2438: --
2439:
2440: l_dummy_line_ids WSH_UTIL_CORE.Id_Tab_Type;
2441:

Line 2450: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;

2446: l_api_session_name CONSTANT VARCHAR2(150) := G_PKG_NAME ||'.' || l_module_name;
2447: l_reset_flags BOOLEAN;
2448:
2449: -- K LPN CONV. rv
2450: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
2451: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
2452: -- K LPN CONV. rv
2453: --
2454:

Line 2451: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;

2447: l_reset_flags BOOLEAN;
2448:
2449: -- K LPN CONV. rv
2450: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
2451: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
2452: -- K LPN CONV. rv
2453: --
2454:
2455: -- OTM R12 : due to record changes in WSHDEVLS

Line 4688: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,

4684: x_msg_count OUT NOCOPY NUMBER,
4685: x_msg_data OUT NOCOPY VARCHAR2,
4686:
4687: -- Procedure Specific Parameters
4688: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
4689: p_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
4690: x_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType
4691: ) IS
4692:

Line 4689: p_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,

4685: x_msg_data OUT NOCOPY VARCHAR2,
4686:
4687: -- Procedure Specific Parameters
4688: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
4689: p_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
4690: x_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType
4691: ) IS
4692:
4693: l_api_name CONSTANT VARCHAR2(30) := 'Create_Update_Delivery_Detail';

Line 4690: x_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType

4686:
4687: -- Procedure Specific Parameters
4688: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
4689: p_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
4690: x_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType
4691: ) IS
4692:
4693: l_api_name CONSTANT VARCHAR2(30) := 'Create_Update_Delivery_Detail';
4694: l_api_version CONSTANT NUMBER := 1.0;

Line 4711: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;

4707: --
4708: l_counter NUMBER := 0;
4709: l_index NUMBER;
4710:
4711: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
4712: l_valid_index_tab wsh_util_core.id_tab_type;
4713: l_delivery_id NUMBER;
4714: l_delivery_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
4715: l_validation_tab wsh_util_core.id_tab_type;

Line 4714: l_delivery_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;

4710:
4711: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
4712: l_valid_index_tab wsh_util_core.id_tab_type;
4713: l_delivery_id NUMBER;
4714: l_delivery_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
4715: l_validation_tab wsh_util_core.id_tab_type;
4716: --
4717: l_details_marked WSH_UTIL_CORE.Id_Tab_Type;
4718: l_dummy_ser_range_tab WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType;

Line 4718: l_dummy_ser_range_tab WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType;

4714: l_delivery_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
4715: l_validation_tab wsh_util_core.id_tab_type;
4716: --
4717: l_details_marked WSH_UTIL_CORE.Id_Tab_Type;
4718: l_dummy_ser_range_tab WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType;
4719: mark_reprice_error EXCEPTION;
4720:
4721: --
4722: CURSOR det_to_del_cur(p_detail_id NUMBER) IS

Line 4912: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,

4908: PROCEDURE Create_containers
4909: ----------------------------------------------------*/
4910: -- lpn conv
4911: PROCEDURE Create_containers(
4912: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,
4913: p_detail_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
4914: x_container_ids OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
4915: x_return_status OUT NOCOPY varchar2
4916: )

Line 4913: p_detail_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,

4909: ----------------------------------------------------*/
4910: -- lpn conv
4911: PROCEDURE Create_containers(
4912: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,
4913: p_detail_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
4914: x_container_ids OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
4915: x_return_status OUT NOCOPY varchar2
4916: )
4917: IS

Line 4943: l_container_names WSH_GLBL_VAR_STRCT_GRP.v50_Tbl_Type;

4939: l_name_prefix VARCHAR2(30);
4940: l_name_suffix VARCHAR2(30);
4941: l_base_number NUMBER;
4942: l_base_number_dummy NUMBER;
4943: l_container_names WSH_GLBL_VAR_STRCT_GRP.v50_Tbl_Type;
4944: l_lpn_ids wsh_util_core.id_tab_type;
4945: i NUMBER;
4946: j NUMBER;
4947: l_orig_value varchar2(2);

Line 4951: l_container_info_rec WSH_GLBL_VAR_STRCT_GRP.ContInfoRectype;

4947: l_orig_value varchar2(2);
4948: l_update_container_orig VARCHAR2(2) := WSH_WMS_LPN_GRP.g_update_to_container;
4949: -- bmso
4950: l_lpn_table WMS_Data_Type_Definitions_pub.LPNTableType;
4951: l_container_info_rec WSH_GLBL_VAR_STRCT_GRP.ContInfoRectype;
4952: l_container_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
4953: l_cont_dummy_tab WSH_UTIL_CORE.id_tab_type;
4954: l_del_assg_rec WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
4955: l_assignment_dummy_tab WSH_UTIL_CORE.id_tab_type;

Line 4952: l_container_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;

4948: l_update_container_orig VARCHAR2(2) := WSH_WMS_LPN_GRP.g_update_to_container;
4949: -- bmso
4950: l_lpn_table WMS_Data_Type_Definitions_pub.LPNTableType;
4951: l_container_info_rec WSH_GLBL_VAR_STRCT_GRP.ContInfoRectype;
4952: l_container_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
4953: l_cont_dummy_tab WSH_UTIL_CORE.id_tab_type;
4954: l_del_assg_rec WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
4955: l_assignment_dummy_tab WSH_UTIL_CORE.id_tab_type;
4956: l_wms_enabled BOOLEAN;

Line 4961: l_additional_cont_attr wsh_glbl_var_strct_grp.LPNRecordType;

4957: l_return_status VARCHAR2(2);
4958: l_number_of_warnings NUMBER := 0;
4959: l_number_of_errors NUMBER := 0;
4960: l_suffix_length NUMBER;
4961: l_additional_cont_attr wsh_glbl_var_strct_grp.LPNRecordType;
4962:
4963: l_new_session BOOLEAN := TRUE;
4964:
4965: CURSOR c_get_default_parameters (v_organization_id NUMBER) IS

Line 5713: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,

5709: -- Created: Harmonization Project. Patchset I
5710: -- -----------------------------------------------------------------------
5711:
5712: PROCEDURE Create_Delivery_Detail(
5713: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,
5714: p_detail_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
5715: p_valid_index_tab IN wsh_util_core.id_tab_type,
5716: x_detail_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType,
5717: x_return_status OUT NOCOPY varchar2,

Line 5714: p_detail_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,

5710: -- -----------------------------------------------------------------------
5711:
5712: PROCEDURE Create_Delivery_Detail(
5713: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,
5714: p_detail_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
5715: p_valid_index_tab IN wsh_util_core.id_tab_type,
5716: x_detail_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType,
5717: x_return_status OUT NOCOPY varchar2,
5718: x_msg_count OUT NOCOPY NUMBER,

Line 5716: x_detail_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType,

5712: PROCEDURE Create_Delivery_Detail(
5713: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,
5714: p_detail_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
5715: p_valid_index_tab IN wsh_util_core.id_tab_type,
5716: x_detail_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType,
5717: x_return_status OUT NOCOPY varchar2,
5718: x_msg_count OUT NOCOPY NUMBER,
5719: x_msg_data OUT NOCOPY VARCHAR2)
5720: IS

Line 6123: x_detail_info_tab IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,

6119: -- transaction_temp_id will be stamped on wdd table.
6120: -- -----------------------------------------------------------------------
6121:
6122: PROCEDURE Validate_Delivery_Detail(
6123: x_detail_info_tab IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
6124: p_in_detail_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
6125: p_action IN VARCHAR2,
6126: p_validation_tab IN wsh_util_core.id_tab_type,
6127: p_caller IN VARCHAR2,

Line 6124: p_in_detail_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,

6120: -- -----------------------------------------------------------------------
6121:
6122: PROCEDURE Validate_Delivery_Detail(
6123: x_detail_info_tab IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
6124: p_in_detail_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
6125: p_action IN VARCHAR2,
6126: p_validation_tab IN wsh_util_core.id_tab_type,
6127: p_caller IN VARCHAR2,
6128: x_valid_index_tab OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,

Line 6134: p_in_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,

6130: x_detail_tender_tab OUT NOCOPY wsh_util_core.id_tab_type,
6131: x_return_status OUT NOCOPY VARCHAR2,
6132: x_msg_count OUT NOCOPY NUMBER,
6133: x_msg_data OUT NOCOPY VARCHAR2,
6134: p_in_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
6135: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType
6136: ) IS
6137:
6138:

Line 6135: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType

6131: x_return_status OUT NOCOPY VARCHAR2,
6132: x_msg_count OUT NOCOPY NUMBER,
6133: x_msg_data OUT NOCOPY VARCHAR2,
6134: p_in_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
6135: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType
6136: ) IS
6137:
6138:
6139: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Delivery_Detail';

Line 6876: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,

6872: -- Created: Harmonization Project. Patchset I
6873: -- -----------------------------------------------------------------------
6874:
6875: PROCEDURE Update_Delivery_Detail(
6876: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,
6877: p_valid_index_tab IN wsh_util_core.id_tab_type,
6878: x_return_status OUT NOCOPY VARCHAR2,
6879: x_msg_count OUT NOCOPY NUMBER,
6880: x_msg_data OUT NOCOPY VARCHAR2,

Line 6906: l_in_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;

6902: --
6903: l_index NUMBER;
6904: l_delivery_detail NUMBER;
6905: --lpn conv
6906: l_in_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
6907: l_out_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
6908:
6909: --
6910: l_debug_on BOOLEAN;

Line 6907: l_out_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;

6903: l_index NUMBER;
6904: l_delivery_detail NUMBER;
6905: --lpn conv
6906: l_in_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
6907: l_out_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
6908:
6909: --
6910: l_debug_on BOOLEAN;
6911: --

Line 7201: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,

7197: -- Created: Harmonization Project. Patchset I
7198: -- -----------------------------------------------------------------------
7199:
7200: PROCEDURE Cancel_Delivery_Detail(
7201: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,
7202: x_return_status OUT NOCOPY VARCHAR2,
7203: x_msg_count OUT NOCOPY NUMBER,
7204: x_msg_data OUT NOCOPY VARCHAR2,
7205: p_caller IN VARCHAR2 DEFAULT NULL)

Line 7420: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,

7416: If you are adding any validation, which may be applicable for inbound line as well, please
7417: evaluate against that.
7418: */
7419: PROCEDURE validate_detail_line(
7420: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
7421: p_in_detail_rec IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
7422: p_original_rec IN c_original_detail_cur%ROWTYPE,
7423: p_validation_tab IN wsh_util_core.id_tab_type,
7424: x_mark_reprice_flag OUT NOCOPY VARCHAR2,

Line 7421: p_in_detail_rec IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,

7417: evaluate against that.
7418: */
7419: PROCEDURE validate_detail_line(
7420: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
7421: p_in_detail_rec IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
7422: p_original_rec IN c_original_detail_cur%ROWTYPE,
7423: p_validation_tab IN wsh_util_core.id_tab_type,
7424: x_mark_reprice_flag OUT NOCOPY VARCHAR2,
7425: x_return_status OUT NOCOPY VARCHAR2,

Line 7428: p_in_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,

7424: x_mark_reprice_flag OUT NOCOPY VARCHAR2,
7425: x_return_status OUT NOCOPY VARCHAR2,
7426: x_msg_count OUT NOCOPY NUMBER,
7427: x_msg_data OUT NOCOPY VARCHAR2,
7428: p_in_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
7429: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType
7430: ) IS
7431: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Detail_Line';
7432: l_api_version CONSTANT NUMBER := 1.0;

Line 7429: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType

7425: x_return_status OUT NOCOPY VARCHAR2,
7426: x_msg_count OUT NOCOPY NUMBER,
7427: x_msg_data OUT NOCOPY VARCHAR2,
7428: p_in_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
7429: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType
7430: ) IS
7431: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Detail_Line';
7432: l_api_version CONSTANT NUMBER := 1.0;
7433: --

Line 7500: l_det_ser_range_tab WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType;

7496: l_index NUMBER;
7497: l_det_index NUMBER;
7498: l_detail_ser_count NUMBER;
7499: l_detail_ser_qty NUMBER;
7500: l_det_ser_range_tab WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType;
7501: l_update_attributes BOOLEAN;
7502: l_stamp_ser_wdd BOOLEAN; -- frontport bug 5055682
7503:
7504: -- bug 4766908

Line 9249: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,

9245: -- Description: This local procedure is the new API for wrapping the logic of VALIDATE of Containers
9246: -- Created: Harmonization Project. Patchset I
9247: -- -----------------------------------------------------------------------
9248: PROCEDURE Validate_Detail_Container(
9249: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
9250: p_original_rec IN c_original_detail_cur%ROWTYPE,
9251: p_validation_tab IN wsh_util_core.id_tab_type,
9252: x_mark_reprice_flag OUT NOCOPY VARCHAR2,
9253: x_return_status OUT NOCOPY VARCHAR2,

Line 9455: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,

9451: -- Created: Harmonization Project. Patchset I
9452: -- -----------------------------------------------------------------------
9453:
9454: PROCEDURE Validate_Detail_Common(
9455: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
9456: p_original_rec IN c_original_detail_cur%ROWTYPE,
9457: p_validation_tab IN wsh_util_core.id_tab_type,
9458: x_mark_reprice_flag OUT NOCOPY VARCHAR2,
9459: x_return_status OUT NOCOPY VARCHAR2,

Line 9911: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,

9907: x_msg_count OUT NOCOPY NUMBER,
9908: x_msg_data OUT NOCOPY VARCHAR2,
9909:
9910: -- Procedure Specific Parameters
9911: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
9912: p_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
9913: x_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType,
9914: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType
9915: ) IS

Line 9912: p_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,

9908: x_msg_data OUT NOCOPY VARCHAR2,
9909:
9910: -- Procedure Specific Parameters
9911: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
9912: p_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
9913: x_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType,
9914: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType
9915: ) IS
9916:

Line 9913: x_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType,

9909:
9910: -- Procedure Specific Parameters
9911: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
9912: p_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
9913: x_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType,
9914: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType
9915: ) IS
9916:
9917: l_api_name CONSTANT VARCHAR2(30) := 'Create_Update_Delivery_Detail2';

Line 9914: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType

9910: -- Procedure Specific Parameters
9911: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
9912: p_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
9913: x_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType,
9914: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType
9915: ) IS
9916:
9917: l_api_name CONSTANT VARCHAR2(30) := 'Create_Update_Delivery_Detail2';
9918: l_api_version CONSTANT NUMBER := 1.0;

Line 9937: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;

9933: --
9934: l_counter NUMBER := 0;
9935: l_index NUMBER;
9936:
9937: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
9938: l_valid_index_tab wsh_util_core.id_tab_type;
9939: l_delivery_id NUMBER;
9940: l_delivery_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
9941: l_validation_tab wsh_util_core.id_tab_type;

Line 9940: l_delivery_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;

9936:
9937: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
9938: l_valid_index_tab wsh_util_core.id_tab_type;
9939: l_delivery_id NUMBER;
9940: l_delivery_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
9941: l_validation_tab wsh_util_core.id_tab_type;
9942: --
9943: l_details_marked WSH_UTIL_CORE.Id_Tab_Type;
9944: mark_reprice_error EXCEPTION;