DBA Data[Home] [Help]

APPS.WSH_INTERFACE_COMMON_ACTIONS dependencies on WSH_GLBL_VAR_STRCT_GRP

Line 234: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType);

230: x_return_status OUT NOCOPY VARCHAR2
231: );
232:
233: PROCEDURE add_to_serial_table(
234: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType);
235:
236:
237: PROCEDURE Update_Delivery_Details(
238: p_source_code IN VARCHAR2 DEFAULT 'OE',

Line 593: l_del_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;

589: l_new_detail_ids WSH_UTIL_CORE.Id_Tab_Type;
590: l_table_count NUMBER;
591: l_return_status VARCHAR2(30);
592:
593: l_del_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
594: -- Patchset I: Harmonization Project
595: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
596: l_api_version NUMBER := 1.0;
597: l_detail_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;

Line 595: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;

591: l_return_status VARCHAR2(30);
592:
593: l_del_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
594: -- Patchset I: Harmonization Project
595: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
596: l_api_version NUMBER := 1.0;
597: l_detail_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
598: l_detail_out_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
599: l_index NUMBER;

Line 597: l_detail_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;

593: l_del_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
594: -- Patchset I: Harmonization Project
595: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
596: l_api_version NUMBER := 1.0;
597: l_detail_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
598: l_detail_out_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
599: l_index NUMBER;
600: -- End Patchset I: Harmonization Project
601:

Line 598: l_detail_out_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;

594: -- Patchset I: Harmonization Project
595: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
596: l_api_version NUMBER := 1.0;
597: l_detail_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
598: l_detail_out_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
599: l_index NUMBER;
600: -- End Patchset I: Harmonization Project
601:
602:

Line 1623: l_serial_range_tab WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType;

1619: l_prev_int_rec del_det_int_cur%ROWTYPE;
1620: l_number_of_errors NUMBER := 0;
1621: l_number_of_warnings NUMBER := 0;
1622: l_num_of_dtl NUMBER := 0;
1623: l_serial_range_tab WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType;
1624: l_index NUMBER;
1625: -- TPW - Distributed changes
1626: l_detail_id NUMBER;
1627:

Line 4135: l_DETAIL_INFO_TAB WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;

4131: l_commit VARCHAR2(1) ;
4132: l_return_status VARCHAR2(30);
4133:
4134: l_loc_interface_error_rec WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type;
4135: l_DETAIL_INFO_TAB WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
4136: l_IN_REC WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
4137: l_OUT_REC WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
4138: -- TPW - Distribution Organization Changes - Inv. Rsv API Integration Changes - Starts
4139: l_header_id NUMBER;

Line 4136: l_IN_REC WSH_GLBL_VAR_STRCT_GRP.detailInRecType;

4132: l_return_status VARCHAR2(30);
4133:
4134: l_loc_interface_error_rec WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type;
4135: l_DETAIL_INFO_TAB WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
4136: l_IN_REC WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
4137: l_OUT_REC WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
4138: -- TPW - Distribution Organization Changes - Inv. Rsv API Integration Changes - Starts
4139: l_header_id NUMBER;
4140: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

Line 4137: l_OUT_REC WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;

4133:
4134: l_loc_interface_error_rec WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type;
4135: l_DETAIL_INFO_TAB WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
4136: l_IN_REC WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
4137: l_OUT_REC WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
4138: -- TPW - Distribution Organization Changes - Inv. Rsv API Integration Changes - Starts
4139: l_header_id NUMBER;
4140: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
4141: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

Line 4845: l_changed_attributes WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;

4841: x_return_status OUT NOCOPY VARCHAR2) IS
4842:
4843: -- variables
4844: --l_changed_attributes WSH_INTERFACE.ChangedAttributeRecType;
4845: l_changed_attributes WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
4846: l_packing_detail_rec WSH_INTERFACE_COMMON_ACTIONS.PackingDetailRecType;
4847: l_intf_parent_det_id NUMBER;
4848:
4849: -- TPW - Distributed changes

Line 5632: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType)

5628: END split_delivery_detail;
5629:
5630:
5631: PROCEDURE add_to_serial_table(
5632: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType)
5633: IS
5634: l_index NUMBER;
5635: l_g_count NUMBER;
5636: BEGIN