DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_PUB dependencies on WSH_GLBL_VAR_STRCT_GRP

Line 10: x_detail_info_tab OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type

6: p_message_type CONSTANT VARCHAR2(1) := 'E';
7:
8:
9: PROCEDURE Copy_Attributes(
10: x_detail_info_tab OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type
11: , x_changed_attributes IN WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType);
12:
13:
14: -- -----------------------------------------------------------------------

Line 62: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;

58: l_msg_summary varchar2(2000) := NULL;
59: l_msg_details varchar2(4000) := NULL;
60:
61: -- Harmonization Project
62: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
63: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
64: l_dummy_qty NUMBER;
65: l_dummy_qty2 NUMBER;
66: l_dummy_ids wsh_util_core.id_tab_type;

Line 63: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;

59: l_msg_details varchar2(4000) := NULL;
60:
61: -- Harmonization Project
62: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
63: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
64: l_dummy_qty NUMBER;
65: l_dummy_qty2 NUMBER;
66: l_dummy_ids wsh_util_core.id_tab_type;
67:

Line 288: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;

284: l_msg_summary varchar2(2000);
285: l_msg_details varchar2(4000);
286:
287: -- Harmonization Project
288: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
289: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
290: l_dummy_qty NUMBER;
291: l_dummy_qty2 NUMBER;
292: l_dummy_ids wsh_util_core.id_tab_type;

Line 289: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;

285: l_msg_details varchar2(4000);
286:
287: -- Harmonization Project
288: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
289: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
290: l_dummy_qty NUMBER;
291: l_dummy_qty2 NUMBER;
292: l_dummy_ids wsh_util_core.id_tab_type;
293: l_detail_ids wsh_util_core.id_tab_type;

Line 720: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;

716: m NUMBER := 0;
717:
718:
719: -- Harmonization Project
720: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
721: l_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
722: l_lpn_ids wsh_util_core.id_Tab_type;
723: l_out_Rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
724: l_msg_count NUMBER;

Line 721: l_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;

717:
718:
719: -- Harmonization Project
720: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
721: l_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
722: l_lpn_ids wsh_util_core.id_Tab_type;
723: l_out_Rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
724: l_msg_count NUMBER;
725: l_msg_data VARCHAR2(32767);

Line 723: l_out_Rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;

719: -- Harmonization Project
720: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
721: l_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
722: l_lpn_ids wsh_util_core.id_Tab_type;
723: l_out_Rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
724: l_msg_count NUMBER;
725: l_msg_data VARCHAR2(32767);
726: l_number_of_errors NUMBER := 0;
727: l_number_of_warnings NUMBER := 0;

Line 1020: , p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType

1016: -- Procedure specific parameters
1017: , p_changed_attributes IN WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType
1018: , p_source_code IN VARCHAR2
1019: , p_container_flag IN VARCHAR2
1020: , p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType
1021: )
1022: IS
1023:
1024: l_valid_index_tab WSH_UTIL_CORE.Id_Tab_Type;

Line 1036: l_serial_range_tab WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType;

1032: l_api_name VARCHAR2(30) := 'Update_Shipping_Attributes2';
1033: l_ship_to_location_id NUMBER;
1034: invalid_source_code EXCEPTION;
1035:
1036: l_serial_range_tab WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType;
1037:
1038: m NUMBER := 0;
1039:
1040:

Line 1042: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;

1038: m NUMBER := 0;
1039:
1040:
1041: -- Harmonization Project
1042: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
1043: l_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
1044: l_lpn_ids wsh_util_core.id_Tab_type;
1045: l_out_Rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
1046: l_msg_count NUMBER;

Line 1043: l_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;

1039:
1040:
1041: -- Harmonization Project
1042: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
1043: l_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
1044: l_lpn_ids wsh_util_core.id_Tab_type;
1045: l_out_Rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
1046: l_msg_count NUMBER;
1047: l_msg_data VARCHAR2(32767);

Line 1045: l_out_Rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;

1041: -- Harmonization Project
1042: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
1043: l_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
1044: l_lpn_ids wsh_util_core.id_Tab_type;
1045: l_out_Rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
1046: l_msg_count NUMBER;
1047: l_msg_data VARCHAR2(32767);
1048: l_number_of_errors NUMBER := 0;
1049: l_number_of_warnings NUMBER := 0;

Line 1431: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;

1427: l_msg_summary varchar2(2000) := NULL;
1428: l_msg_details varchar2(4000) := NULL;
1429:
1430: -- Harmonization Project
1431: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
1432: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
1433: l_dummy_qty NUMBER;
1434: l_dummy_qty2 NUMBER;
1435: l_dummy_ids wsh_util_core.id_tab_type;

Line 1432: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;

1428: l_msg_details varchar2(4000) := NULL;
1429:
1430: -- Harmonization Project
1431: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
1432: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
1433: l_dummy_qty NUMBER;
1434: l_dummy_qty2 NUMBER;
1435: l_dummy_ids wsh_util_core.id_tab_type;
1436: l_msg_count NUMBER;

Line 1722: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;

1718: l_org_rows wsh_util_core.id_tab_type; -- bug 1668578
1719: autocreate_trip_failed EXCEPTION;
1720:
1721: -- Harmonization Project
1722: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
1723: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
1724: l_dummy_qty NUMBER;
1725: l_dummy_qty2 NUMBER;
1726: l_del_rows wsh_util_core.id_tab_type;

Line 1723: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;

1719: autocreate_trip_failed EXCEPTION;
1720:
1721: -- Harmonization Project
1722: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
1723: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
1724: l_dummy_qty NUMBER;
1725: l_dummy_qty2 NUMBER;
1726: l_del_rows wsh_util_core.id_tab_type;
1727: l_msg_count NUMBER;

Line 1898: x_detail_info_tab OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type

1894: END Autocreate_del_trip;
1895:
1896:
1897: PROCEDURE Copy_Attributes(
1898: x_detail_info_tab OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type
1899: , x_changed_attributes IN WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType)
1900:
1901: IS
1902: