DBA Data[Home] [Help]

APPS.WSH_INTERFACE_COMMON_ACTIONS dependencies on WSH_GLBL_VAR_STRCT_GRP

Line 231: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType);

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',

Line 492: l_del_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;

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;

Line 494: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;

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;

Line 496: l_detail_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;

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:

Line 497: l_detail_out_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;

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:

Line 1212: l_serial_range_tab WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType;

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(*)

Line 3132: l_DETAIL_INFO_TAB WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;

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;

Line 3133: l_IN_REC WSH_GLBL_VAR_STRCT_GRP.detailInRecType;

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;

Line 3134: l_OUT_REC WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;

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: --

Line 3761: l_changed_attributes WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;

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

Line 4365: p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType)

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