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 58: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,

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

Line 59: p_detail_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,

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

Line 61: x_detail_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType,

57: PROCEDURE Create_Delivery_Detail(
58: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
59: p_detail_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
60: p_valid_index_tab IN wsh_util_core.id_tab_type,
61: x_detail_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType,
62: x_return_status OUT NOCOPY VARCHAR2,
63: x_msg_count OUT NOCOPY NUMBER,
64: x_msg_data OUT NOCOPY VARCHAR2
65: );

Line 68: x_detail_info_tab IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,

64: x_msg_data OUT NOCOPY VARCHAR2
65: );
66:
67: PROCEDURE Validate_Delivery_Detail(
68: x_detail_info_tab IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
69: p_in_detail_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
70: p_action IN VARCHAR2,
71: p_validation_tab IN wsh_util_core.Id_Tab_Type,
72: p_caller IN varchar2,

Line 69: p_in_detail_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,

65: );
66:
67: PROCEDURE Validate_Delivery_Detail(
68: x_detail_info_tab IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
69: p_in_detail_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
70: p_action IN VARCHAR2,
71: p_validation_tab IN wsh_util_core.Id_Tab_Type,
72: p_caller IN varchar2,
73: x_valid_index_tab OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,

Line 79: p_in_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,

75: x_detail_tender_tab OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
76: x_return_status OUT NOCOPY VARCHAR2,
77: x_msg_count OUT NOCOPY NUMBER,
78: x_msg_data OUT NOCOPY VARCHAR2,
79: p_in_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
80: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType
81: );
82:
83: PROCEDURE Update_Delivery_Detail(

Line 80: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType

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

Line 84: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,

80: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType
81: );
82:
83: PROCEDURE Update_Delivery_Detail(
84: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,
85: p_valid_index_tab IN wsh_util_core.id_tab_type,
86: x_return_status OUT NOCOPY varchar2,
87: x_msg_count OUT NOCOPY NUMBER,
88: x_msg_data OUT NOCOPY VARCHAR2,

Line 102: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,

98: -- Created: Harmonization Project. Patchset I
99: -- -----------------------------------------------------------------------
100:
101: PROCEDURE Cancel_Delivery_Detail(
102: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,
105: x_msg_data OUT NOCOPY VARCHAR2,
106: p_caller IN VARCHAR2 DEFAULT NULL

Line 112: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,

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

Line 113: p_in_detail_rec IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,

109:
110:
111: PROCEDURE Validate_Detail_Line(
112: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
113: p_in_detail_rec IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
114: p_original_rec IN c_original_detail_cur%ROWTYPE,
115: p_validation_tab IN WSH_UTIL_CORE.id_tab_type,
116: x_mark_reprice_flag OUT NOCOPY VARCHAR2,
117: x_return_status OUT NOCOPY VARCHAR2,

Line 120: p_in_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,

116: x_mark_reprice_flag OUT NOCOPY VARCHAR2,
117: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
119: x_msg_data OUT NOCOPY VARCHAR2,
120: p_in_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
121: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType
122: );
123:
124: PROCEDURE Validate_Detail_Container(

Line 121: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType

117: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
119: x_msg_data OUT NOCOPY VARCHAR2,
120: p_in_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
121: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType
122: );
123:
124: PROCEDURE Validate_Detail_Container(
125: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,

Line 125: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,

121: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType
122: );
123:
124: PROCEDURE Validate_Detail_Container(
125: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
126: p_original_rec IN c_original_detail_cur%ROWTYPE,
127: p_validation_tab IN WSH_UTIL_CORE.id_tab_type,
128: x_mark_reprice_flag OUT NOCOPY VARCHAR2,
129: x_return_status OUT NOCOPY VARCHAR2,

Line 135: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,

131: x_msg_data OUT NOCOPY VARCHAR2
132: );
133:
134: PROCEDURE Validate_Detail_Common(
135: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
136: p_original_rec IN c_original_detail_cur%ROWTYPE,
137: p_validation_tab IN wsh_util_core.id_tab_type,
138: x_mark_reprice_flag OUT NOCOPY VARCHAR2,
139: x_return_status OUT NOCOPY VARCHAR2,

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

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

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

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

Line 1127: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;

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

Line 1128: l_detail_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;

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

Line 1129: l_detail_out_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;

1125: l_msg_count NUMBER;
1126: l_msg_data VARCHAR2(32767);
1127: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
1128: l_detail_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
1129: l_detail_out_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
1130: l_dummy_ids wsh_util_core.id_Tab_type;
1131: invalid_source_code exception;
1132: mark_reprice_error exception;
1133: update_failed exception;

Line 2235: p_rec_attr_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,

2231: x_msg_count OUT NOCOPY NUMBER,
2232: x_msg_data OUT NOCOPY VARCHAR2,
2233:
2234: -- Procedure specific Parameters
2235: p_rec_attr_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
2236: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
2237: x_defaults OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type, -- defaults
2238: x_action_out_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type
2239: ) IS

Line 2236: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,

2232: x_msg_data OUT NOCOPY VARCHAR2,
2233:
2234: -- Procedure specific Parameters
2235: p_rec_attr_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
2236: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
2237: x_defaults OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type, -- defaults
2238: x_action_out_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type
2239: ) IS
2240:

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

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

Line 2238: x_action_out_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type

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

Line 2419: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;

2415: l_trip_id NUMBER;
2416:
2417: --dummy tables for calling validate_constraint_mainper
2418: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2419: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
2420: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2421: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2422: l_cc_in_ids wsh_util_core.id_tab_type;
2423: l_cc_fail_ids wsh_util_core.id_tab_type;

Line 2443: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;

2439: l_delivery_already_included boolean;
2440: --
2441: --
2442: l_cnt NUMBER;
2443: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
2444: --
2445:
2446: l_dummy_line_ids WSH_UTIL_CORE.Id_Tab_Type;
2447:

Line 2456: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;

2452: l_api_session_name CONSTANT VARCHAR2(150) := G_PKG_NAME ||'.' || l_module_name;
2453: l_reset_flags BOOLEAN;
2454:
2455: -- K LPN CONV. rv
2456: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
2457: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
2458: -- K LPN CONV. rv
2459: --
2460:

Line 2457: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;

2453: l_reset_flags BOOLEAN;
2454:
2455: -- K LPN CONV. rv
2456: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
2457: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
2458: -- K LPN CONV. rv
2459: --
2460:
2461: -- OTM R12 : due to record changes in WSHDEVLS

Line 4698: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,

4694: x_msg_count OUT NOCOPY NUMBER,
4695: x_msg_data OUT NOCOPY VARCHAR2,
4696:
4697: -- Procedure Specific Parameters
4698: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
4699: p_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
4700: x_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType
4701: ) IS
4702:

Line 4699: p_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,

4695: x_msg_data OUT NOCOPY VARCHAR2,
4696:
4697: -- Procedure Specific Parameters
4698: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
4699: p_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
4700: x_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType
4701: ) IS
4702:
4703: l_api_name CONSTANT VARCHAR2(30) := 'Create_Update_Delivery_Detail';

Line 4700: x_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType

4696:
4697: -- Procedure Specific Parameters
4698: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
4699: p_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
4700: x_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType
4701: ) IS
4702:
4703: l_api_name CONSTANT VARCHAR2(30) := 'Create_Update_Delivery_Detail';
4704: l_api_version CONSTANT NUMBER := 1.0;

Line 4721: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;

4717: --
4718: l_counter NUMBER := 0;
4719: l_index NUMBER;
4720:
4721: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
4722: l_valid_index_tab wsh_util_core.id_tab_type;
4723: l_delivery_id NUMBER;
4724: l_delivery_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
4725: l_validation_tab wsh_util_core.id_tab_type;

Line 4724: l_delivery_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;

4720:
4721: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
4722: l_valid_index_tab wsh_util_core.id_tab_type;
4723: l_delivery_id NUMBER;
4724: l_delivery_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
4725: l_validation_tab wsh_util_core.id_tab_type;
4726: --
4727: l_details_marked WSH_UTIL_CORE.Id_Tab_Type;
4728: l_dummy_ser_range_tab WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType;

Line 4728: l_dummy_ser_range_tab WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType;

4724: l_delivery_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
4725: l_validation_tab wsh_util_core.id_tab_type;
4726: --
4727: l_details_marked WSH_UTIL_CORE.Id_Tab_Type;
4728: l_dummy_ser_range_tab WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType;
4729: mark_reprice_error EXCEPTION;
4730:
4731: --
4732: CURSOR det_to_del_cur(p_detail_id NUMBER) IS

Line 4922: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,

4918: PROCEDURE Create_containers
4919: ----------------------------------------------------*/
4920: -- lpn conv
4921: PROCEDURE Create_containers(
4922: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,
4923: p_detail_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
4924: x_container_ids OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
4925: x_return_status OUT NOCOPY varchar2
4926: )

Line 4923: p_detail_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,

4919: ----------------------------------------------------*/
4920: -- lpn conv
4921: PROCEDURE Create_containers(
4922: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,
4923: p_detail_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
4924: x_container_ids OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
4925: x_return_status OUT NOCOPY varchar2
4926: )
4927: IS

Line 4953: l_container_names WSH_GLBL_VAR_STRCT_GRP.v50_Tbl_Type;

4949: l_name_prefix VARCHAR2(30);
4950: l_name_suffix VARCHAR2(30);
4951: l_base_number NUMBER;
4952: l_base_number_dummy NUMBER;
4953: l_container_names WSH_GLBL_VAR_STRCT_GRP.v50_Tbl_Type;
4954: l_lpn_ids wsh_util_core.id_tab_type;
4955: i NUMBER;
4956: j NUMBER;
4957: l_orig_value varchar2(2);

Line 4961: l_container_info_rec WSH_GLBL_VAR_STRCT_GRP.ContInfoRectype;

4957: l_orig_value varchar2(2);
4958: l_update_container_orig VARCHAR2(2) := WSH_WMS_LPN_GRP.g_update_to_container;
4959: -- bmso
4960: l_lpn_table WMS_Data_Type_Definitions_pub.LPNTableType;
4961: l_container_info_rec WSH_GLBL_VAR_STRCT_GRP.ContInfoRectype;
4962: l_container_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
4963: l_cont_dummy_tab WSH_UTIL_CORE.id_tab_type;
4964: l_del_assg_rec WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
4965: l_assignment_dummy_tab WSH_UTIL_CORE.id_tab_type;

Line 4962: l_container_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;

4958: l_update_container_orig VARCHAR2(2) := WSH_WMS_LPN_GRP.g_update_to_container;
4959: -- bmso
4960: l_lpn_table WMS_Data_Type_Definitions_pub.LPNTableType;
4961: l_container_info_rec WSH_GLBL_VAR_STRCT_GRP.ContInfoRectype;
4962: l_container_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
4963: l_cont_dummy_tab WSH_UTIL_CORE.id_tab_type;
4964: l_del_assg_rec WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
4965: l_assignment_dummy_tab WSH_UTIL_CORE.id_tab_type;
4966: l_wms_enabled BOOLEAN;

Line 4971: l_additional_cont_attr wsh_glbl_var_strct_grp.LPNRecordType;

4967: l_return_status VARCHAR2(2);
4968: l_number_of_warnings NUMBER := 0;
4969: l_number_of_errors NUMBER := 0;
4970: l_suffix_length NUMBER;
4971: l_additional_cont_attr wsh_glbl_var_strct_grp.LPNRecordType;
4972:
4973: l_new_session BOOLEAN := TRUE;
4974:
4975: CURSOR c_get_default_parameters (v_organization_id NUMBER) IS

Line 5723: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,

5719: -- Created: Harmonization Project. Patchset I
5720: -- -----------------------------------------------------------------------
5721:
5722: PROCEDURE Create_Delivery_Detail(
5723: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,
5724: p_detail_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
5725: p_valid_index_tab IN wsh_util_core.id_tab_type,
5726: x_detail_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType,
5727: x_return_status OUT NOCOPY varchar2,

Line 5724: p_detail_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,

5720: -- -----------------------------------------------------------------------
5721:
5722: PROCEDURE Create_Delivery_Detail(
5723: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,
5724: p_detail_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
5725: p_valid_index_tab IN wsh_util_core.id_tab_type,
5726: x_detail_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType,
5727: x_return_status OUT NOCOPY varchar2,
5728: x_msg_count OUT NOCOPY NUMBER,

Line 5726: x_detail_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType,

5722: PROCEDURE Create_Delivery_Detail(
5723: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,
5724: p_detail_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
5725: p_valid_index_tab IN wsh_util_core.id_tab_type,
5726: x_detail_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType,
5727: x_return_status OUT NOCOPY varchar2,
5728: x_msg_count OUT NOCOPY NUMBER,
5729: x_msg_data OUT NOCOPY VARCHAR2)
5730: IS

Line 6133: x_detail_info_tab IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,

6129: -- transaction_temp_id will be stamped on wdd table.
6130: -- -----------------------------------------------------------------------
6131:
6132: PROCEDURE Validate_Delivery_Detail(
6133: x_detail_info_tab IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
6134: p_in_detail_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
6135: p_action IN VARCHAR2,
6136: p_validation_tab IN wsh_util_core.id_tab_type,
6137: p_caller IN VARCHAR2,

Line 6134: p_in_detail_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,

6130: -- -----------------------------------------------------------------------
6131:
6132: PROCEDURE Validate_Delivery_Detail(
6133: x_detail_info_tab IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
6134: p_in_detail_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
6135: p_action IN VARCHAR2,
6136: p_validation_tab IN wsh_util_core.id_tab_type,
6137: p_caller IN VARCHAR2,
6138: x_valid_index_tab OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,

Line 6144: p_in_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,

6140: x_detail_tender_tab OUT NOCOPY wsh_util_core.id_tab_type,
6141: x_return_status OUT NOCOPY VARCHAR2,
6142: x_msg_count OUT NOCOPY NUMBER,
6143: x_msg_data OUT NOCOPY VARCHAR2,
6144: p_in_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
6145: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType
6146: ) IS
6147:
6148:

Line 6145: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType

6141: x_return_status OUT NOCOPY VARCHAR2,
6142: x_msg_count OUT NOCOPY NUMBER,
6143: x_msg_data OUT NOCOPY VARCHAR2,
6144: p_in_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
6145: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType
6146: ) IS
6147:
6148:
6149: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Delivery_Detail';

Line 6963: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,

6959: -- Created: Harmonization Project. Patchset I
6960: -- -----------------------------------------------------------------------
6961:
6962: PROCEDURE Update_Delivery_Detail(
6963: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,
6964: p_valid_index_tab IN wsh_util_core.id_tab_type,
6965: x_return_status OUT NOCOPY VARCHAR2,
6966: x_msg_count OUT NOCOPY NUMBER,
6967: x_msg_data OUT NOCOPY VARCHAR2,

Line 6993: l_in_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;

6989: --
6990: l_index NUMBER;
6991: l_delivery_detail NUMBER;
6992: --lpn conv
6993: l_in_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
6994: l_out_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
6995:
6996: --
6997: l_debug_on BOOLEAN;

Line 6994: l_out_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;

6990: l_index NUMBER;
6991: l_delivery_detail NUMBER;
6992: --lpn conv
6993: l_in_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
6994: l_out_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
6995:
6996: --
6997: l_debug_on BOOLEAN;
6998: --

Line 7288: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,

7284: -- Created: Harmonization Project. Patchset I
7285: -- -----------------------------------------------------------------------
7286:
7287: PROCEDURE Cancel_Delivery_Detail(
7288: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,
7289: x_return_status OUT NOCOPY VARCHAR2,
7290: x_msg_count OUT NOCOPY NUMBER,
7291: x_msg_data OUT NOCOPY VARCHAR2,
7292: p_caller IN VARCHAR2 DEFAULT NULL)

Line 7507: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,

7503: If you are adding any validation, which may be applicable for inbound line as well, please
7504: evaluate against that.
7505: */
7506: PROCEDURE validate_detail_line(
7507: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
7508: p_in_detail_rec IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
7509: p_original_rec IN c_original_detail_cur%ROWTYPE,
7510: p_validation_tab IN wsh_util_core.id_tab_type,
7511: x_mark_reprice_flag OUT NOCOPY VARCHAR2,

Line 7508: p_in_detail_rec IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,

7504: evaluate against that.
7505: */
7506: PROCEDURE validate_detail_line(
7507: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
7508: p_in_detail_rec IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
7509: p_original_rec IN c_original_detail_cur%ROWTYPE,
7510: p_validation_tab IN wsh_util_core.id_tab_type,
7511: x_mark_reprice_flag OUT NOCOPY VARCHAR2,
7512: x_return_status OUT NOCOPY VARCHAR2,

Line 7515: p_in_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,

7511: x_mark_reprice_flag OUT NOCOPY VARCHAR2,
7512: x_return_status OUT NOCOPY VARCHAR2,
7513: x_msg_count OUT NOCOPY NUMBER,
7514: x_msg_data OUT NOCOPY VARCHAR2,
7515: p_in_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
7516: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType
7517: ) IS
7518: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Detail_Line';
7519: l_api_version CONSTANT NUMBER := 1.0;

Line 7516: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType

7512: x_return_status OUT NOCOPY VARCHAR2,
7513: x_msg_count OUT NOCOPY NUMBER,
7514: x_msg_data OUT NOCOPY VARCHAR2,
7515: p_in_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
7516: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType
7517: ) IS
7518: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Detail_Line';
7519: l_api_version CONSTANT NUMBER := 1.0;
7520: --

Line 7592: l_det_ser_range_tab WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType;

7588: l_index NUMBER;
7589: l_det_index NUMBER;
7590: l_detail_ser_count NUMBER;
7591: l_detail_ser_qty NUMBER;
7592: l_det_ser_range_tab WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType;
7593: l_update_attributes BOOLEAN;
7594: l_stamp_ser_wdd BOOLEAN; -- frontport bug 5055682
7595:
7596: -- bug 4766908

Line 9369: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,

9365: -- Description: This local procedure is the new API for wrapping the logic of VALIDATE of Containers
9366: -- Created: Harmonization Project. Patchset I
9367: -- -----------------------------------------------------------------------
9368: PROCEDURE Validate_Detail_Container(
9369: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
9370: p_original_rec IN c_original_detail_cur%ROWTYPE,
9371: p_validation_tab IN wsh_util_core.id_tab_type,
9372: x_mark_reprice_flag OUT NOCOPY VARCHAR2,
9373: x_return_status OUT NOCOPY VARCHAR2,

Line 9575: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,

9571: -- Created: Harmonization Project. Patchset I
9572: -- -----------------------------------------------------------------------
9573:
9574: PROCEDURE Validate_Detail_Common(
9575: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
9576: p_original_rec IN c_original_detail_cur%ROWTYPE,
9577: p_validation_tab IN wsh_util_core.id_tab_type,
9578: x_mark_reprice_flag OUT NOCOPY VARCHAR2,
9579: x_return_status OUT NOCOPY VARCHAR2,

Line 10031: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,

10027: x_msg_count OUT NOCOPY NUMBER,
10028: x_msg_data OUT NOCOPY VARCHAR2,
10029:
10030: -- Procedure Specific Parameters
10031: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
10032: p_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
10033: x_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType,
10034: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType
10035: ) IS

Line 10032: p_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,

10028: x_msg_data OUT NOCOPY VARCHAR2,
10029:
10030: -- Procedure Specific Parameters
10031: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
10032: p_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
10033: x_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType,
10034: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType
10035: ) IS
10036:

Line 10033: x_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType,

10029:
10030: -- Procedure Specific Parameters
10031: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
10032: p_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
10033: x_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType,
10034: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType
10035: ) IS
10036:
10037: l_api_name CONSTANT VARCHAR2(30) := 'Create_Update_Delivery_Detail2';

Line 10034: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType

10030: -- Procedure Specific Parameters
10031: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
10032: p_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
10033: x_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType,
10034: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType
10035: ) IS
10036:
10037: l_api_name CONSTANT VARCHAR2(30) := 'Create_Update_Delivery_Detail2';
10038: l_api_version CONSTANT NUMBER := 1.0;

Line 10057: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;

10053: --
10054: l_counter NUMBER := 0;
10055: l_index NUMBER;
10056:
10057: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
10058: l_valid_index_tab wsh_util_core.id_tab_type;
10059: l_delivery_id NUMBER;
10060: l_delivery_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
10061: l_validation_tab wsh_util_core.id_tab_type;

Line 10060: l_delivery_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;

10056:
10057: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
10058: l_valid_index_tab wsh_util_core.id_tab_type;
10059: l_delivery_id NUMBER;
10060: l_delivery_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
10061: l_validation_tab wsh_util_core.id_tab_type;
10062: --
10063: l_details_marked WSH_UTIL_CORE.Id_Tab_Type;
10064: mark_reprice_error EXCEPTION;