APPS.WSH_INTERFACE_COMMON_ACTIONS dependencies on WSH_DELIVERY_DETAILS

Line 536: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda

532: ORDER BY wddi.container_flag desc;
533:
534: CURSOR cont_inst_exists(l_del_det_id NUMBER) IS
535: SELECT count(*)
536: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda
537: WHERE wdd.source_line_id = l_del_det_id
538: AND wdd.source_code = 'WSH'
539: AND wdd.container_flag = 'Y'
540: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 1033: UPDATE wsh_delivery_details

1029:
1030:
1031:
1032: -- need to update the source_line_id of the newly created container instance
1033: UPDATE wsh_delivery_details
1034: SET source_line_id = del_det_int_rec.delivery_detail_id
1035: WHERE delivery_detail_id = l_cont_instance_id;
1036:
1037: IF(SQL%NOTFOUND) THEN

Line 1111: WSH_DELIVERY_DETAILS_GRP.Detail_To_Delivery(

1107: wsh_debug_sv.log (l_module_name, 'Assign table count', l_new_detail_ids.count);
1108: END IF;
1109:
1110: IF(l_new_detail_ids.count > 0) THEN
1111: WSH_DELIVERY_DETAILS_GRP.Detail_To_Delivery(
1112: p_api_version =>1.0,
1113: p_init_msg_list => l_init_msg_list,
1114: p_validation_level => l_validation_level,
1115: p_commit => l_commit,

Line 3169: wsh_delivery_Details_grp.create_update_delivery_detail(

3165: --jckwok: set UPDATE or CANCEL action codes
3166: l_in_rec.action_code := p_action_code;
3167: l_in_rec.phase := 1;
3168:
3169: wsh_delivery_Details_grp.create_update_delivery_detail(
3170: P_API_VERSION_NUMBER => 1.0,
3171: P_INIT_MSG_LIST => FND_API.G_FALSE,
3172: P_COMMIT => FND_API.G_FALSE,
3173: x_RETURN_STATUS => l_RETURN_STATUS,

Line 3201: p_api_name =>'WSH_DELIVERY_DETAILS_GRP.Create_Update_Delivery_Detail',

3197:
3198: Log_Errors(
3199: p_loc_interface_errors_rec => l_loc_interface_error_rec,
3200: p_msg_data => l_msg_data,
3201: p_api_name =>'WSH_DELIVERY_DETAILS_GRP.Create_Update_Delivery_Detail',
3202: x_return_status => l_return_status);
3203:
3204: IF l_debug_on THEN
3205: wsh_debug_sv.log (l_module_name,'Log_Errors l_return_status',l_return_status);

Line 3768: FROM wsh_delivery_details wdd

3764:
3765: -- cursors
3766: CURSOR base_detail_cur(l_cont_inst_id NUMBER) IS
3767: SELECT wdd.delivery_detail_id
3768: FROM wsh_delivery_details wdd
3769: WHERE source_line_id = l_cont_inst_id
3770: AND wdd.source_code = 'WSH'
3771: AND wdd.container_flag = 'Y'
3772: AND wdd.organization_id = p_del_det_int_rec.organization_id;

Line 4003: FROM wsh_delivery_details wdd,

3999: wdd.source_line_id,
4000: wdd.source_code,
4001: wdd.container_flag,
4002: wdd.requested_quantity_uom
4003: FROM wsh_delivery_details wdd,
4004: wsh_delivery_assignments_v wda
4005: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
4006: AND wda.delivery_id = p_delivery_id;
4007:

Line 4093: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda

4089: l_dummy_id NUMBER;
4090:
4091: CURSOR lock_delivery_details IS
4092: SELECT wdd.delivery_detail_id
4093: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda
4094: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
4095: AND wda.delivery_id = p_delivery_id
4096: FOR UPDATE NOWAIT;
4097:

Line 4239: FROM wsh_delivery_details

4235: l_number_of_warnings NUMBER := 0;
4236: --
4237: CURSOR base_detail_qty(l_del_detail_id NUMBER) IS
4238: SELECT requested_quantity
4239: FROM wsh_delivery_details
4240: WHERE delivery_detail_id =l_del_detail_id;
4241: --
4242: l_debug_on BOOLEAN;
4243: --

Line 4289: wsh_delivery_details_actions.split_delivery_details(

4285: RAISE FND_API.G_EXC_ERROR;
4286: END IF;
4287:
4288: l_qty_to_split := p_qty_to_split;
4289: wsh_delivery_details_actions.split_delivery_details(
4290: p_from_detail_id => p_delivery_detail_id,
4291: p_req_quantity => l_qty_to_split,
4292: x_new_detail_id => x_new_detail_id,
4293: x_return_status => l_return_status);