227: x_return_status OUT NOCOPY VARCHAR2
228: );
229:
230: PROCEDURE add_to_serial_table(
231: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType);
232:
233:
234: PROCEDURE Update_Delivery_Details(
235: p_source_code IN VARCHAR2 DEFAULT 'OE',
488: l_new_detail_ids WSH_UTIL_CORE.Id_Tab_Type;
489: l_table_count NUMBER;
490: l_return_status VARCHAR2(30);
491:
492: l_del_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
493: -- Patchset I: Harmonization Project
494: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
495: l_api_version NUMBER := 1.0;
496: l_detail_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
490: l_return_status VARCHAR2(30);
491:
492: l_del_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
493: -- Patchset I: Harmonization Project
494: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
495: l_api_version NUMBER := 1.0;
496: l_detail_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
497: l_detail_out_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
498: l_index NUMBER;
492: l_del_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
493: -- Patchset I: Harmonization Project
494: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
495: l_api_version NUMBER := 1.0;
496: l_detail_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
497: l_detail_out_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
498: l_index NUMBER;
499: -- End Patchset I: Harmonization Project
500:
493: -- Patchset I: Harmonization Project
494: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
495: l_api_version NUMBER := 1.0;
496: l_detail_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
497: l_detail_out_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
498: l_index NUMBER;
499: -- End Patchset I: Harmonization Project
500:
501:
1208: l_prev_int_rec del_det_int_cur%ROWTYPE;
1209: l_number_of_errors NUMBER := 0;
1210: l_number_of_warnings NUMBER := 0;
1211: l_num_of_dtl NUMBER := 0;
1212: l_serial_range_tab WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType;
1213: l_index NUMBER;
1214: --Cursors
1215: CURSOR c_det_count_cur(p_detail_id NUMBER, p_dlvy_int_id NUMBER) IS
1216: SELECT COUNT(*)
3128: l_commit VARCHAR2(1) ;
3129: l_return_status VARCHAR2(30);
3130:
3131: l_loc_interface_error_rec WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type;
3132: l_DETAIL_INFO_TAB WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
3133: l_IN_REC WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
3134: l_OUT_REC WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
3135: --exceptions
3136: update_shipping_att_failed exception;
3129: l_return_status VARCHAR2(30);
3130:
3131: l_loc_interface_error_rec WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type;
3132: l_DETAIL_INFO_TAB WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
3133: l_IN_REC WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
3134: l_OUT_REC WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
3135: --exceptions
3136: update_shipping_att_failed exception;
3137: cont_upd_ship_att_failed exception;
3130:
3131: l_loc_interface_error_rec WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type;
3132: l_DETAIL_INFO_TAB WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
3133: l_IN_REC WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
3134: l_OUT_REC WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
3135: --exceptions
3136: update_shipping_att_failed exception;
3137: cont_upd_ship_att_failed exception;
3138: --
3757: x_return_status OUT NOCOPY VARCHAR2) IS
3758:
3759: -- variables
3760: --l_changed_attributes WSH_INTERFACE.ChangedAttributeRecType;
3761: l_changed_attributes WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
3762: l_packing_detail_rec WSH_INTERFACE_COMMON_ACTIONS.PackingDetailRecType;
3763: l_intf_parent_det_id NUMBER;
3764:
3765: -- cursors
4361: END split_delivery_detail;
4362:
4363:
4364: PROCEDURE add_to_serial_table(
4365: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType)
4366: IS
4367: l_index NUMBER;
4368: l_g_count NUMBER;
4369: BEGIN