DBA Data[Home] [Help]

APPS.WSH_WF_INTERFACE dependencies on WSH_NEW_DELIVERIES

Line 15: l_status_code WSH_NEW_DELIVERIES.STATUS_CODE%TYPE;

11: actid IN NUMBER,
12: funcmode IN VARCHAR2,
13: resultout OUT NOCOPY VARCHAR2 ) IS
14:
15: l_status_code WSH_NEW_DELIVERIES.STATUS_CODE%TYPE;
16: l_del_lines_count NUMBER;
17: l_return_status VARCHAR2(1);
18:
19:

Line 22: FROM wsh_new_deliveries

18:
19:
20: CURSOR get_delivery_status IS
21: SELECT status_code
22: FROM wsh_new_deliveries
23: WHERE delivery_id = to_number(itemkey);
24:
25: CURSOR get_del_lines_count IS
26: SELECT count(*)

Line 163: wsh_new_deliveries wnd

159: CURSOR get_pickup_stop_id IS
160: SELECT wts.stop_id
161: FROM wsh_trip_stops wts,
162: wsh_delivery_legs wdl,
163: wsh_new_deliveries wnd
164: WHERE wnd.delivery_id = to_number(itemkey)
165: AND wdl.delivery_id = wnd.delivery_id
166: AND wts.stop_id = wdl.pick_up_stop_id
167: AND wts.stop_location_id = wnd.initial_pickup_location_id;

Line 214: UPDATE WSH_NEW_DELIVERIES

210: l_action_prms.defer_interface_flag := 'Y'; -- Performed as another atomic transaction
211: l_action_prms.report_set_id := NULL;
212: l_action_prms.override_flag := 'N'; -- WT-VOL specific
213:
214: UPDATE WSH_NEW_DELIVERIES
215: SET del_wf_intransit_attr = 'P'
216: WHERE delivery_id = l_delivery_id;
217:
218: IF l_debug_on THEN

Line 242: UPDATE WSH_NEW_DELIVERIES

238: END IF;
239:
240: IF (l_return_status <> wsh_util_core.g_ret_sts_error
241: AND l_return_status <> wsh_util_core.G_RET_STS_UNEXP_ERROR) THEN
242: UPDATE WSH_NEW_DELIVERIES
243: SET del_wf_intransit_attr = 'C'
244: WHERE delivery_id = l_delivery_id;
245: resultout := 'COMPLETE:SUCCESS';
246: fnd_message.set_name('WSH', 'WSH_WF_SCPOD_INTRANSIT');

Line 249: UPDATE WSH_NEW_DELIVERIES

245: resultout := 'COMPLETE:SUCCESS';
246: fnd_message.set_name('WSH', 'WSH_WF_SCPOD_INTRANSIT');
247: l_msg_data := FND_MESSAGE.Get;
248: ELSE
249: UPDATE WSH_NEW_DELIVERIES
250: SET del_wf_intransit_attr = 'E'
251: WHERE delivery_id = l_delivery_id;
252: resultout := 'COMPLETE:FAILURE';
253: END IF;

Line 339: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;

335: l_sc_rule_id NUMBER;
336:
337:
338: l_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
339: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
340: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
341:
342: l_delivery_out_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;
343: l_defaults_rec WSH_DELIVERIES_GRP.default_parameters_rectype;

Line 340: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;

336:
337:
338: l_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
339: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
340: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
341:
342: l_delivery_out_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;
343: l_defaults_rec WSH_DELIVERIES_GRP.default_parameters_rectype;
344: l_return_status VARCHAR2(1);

Line 387: WSH_NEW_DELIVERIES_PVT.Populate_Record (l_delivery_id,l_delivery_info,l_return_status);

383: l_report_set_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,'REPORT_SET_ID',FALSE);
384: l_sc_rule_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,'SC_RULE_ID',FALSE);
385:
386:
387: WSH_NEW_DELIVERIES_PVT.Populate_Record (l_delivery_id,l_delivery_info,l_return_status);
388: l_rec_attr_tab(l_rec_attr_tab.COUNT + 1) := l_delivery_info;
389:
390: l_action_prms.caller := 'PLSQL';
391: l_action_prms.phase := NULL;

Line 439: UPDATE WSH_NEW_DELIVERIES

435: l_action_prms.ignore_ineligible_dels:= NULL; -- XXXXX
436: l_action_prms.event := NULL; --ADJUST-PLANNED-FLAG
437: l_action_prms.form_flag := NULL; --PROCESS_CARRIER_SELECTION
438:
439: UPDATE WSH_NEW_DELIVERIES
440: SET del_wf_close_attr = 'P'
441: WHERE delivery_id = l_delivery_id;
442:
443: IF l_debug_on THEN

Line 468: UPDATE WSH_NEW_DELIVERIES

464:
465:
466: IF (l_return_status <> wsh_util_core.g_ret_sts_error
467: AND l_return_status <> wsh_util_core.G_RET_STS_UNEXP_ERROR) THEN
468: UPDATE WSH_NEW_DELIVERIES
469: SET del_wf_close_attr = 'C'
470: WHERE delivery_id = l_delivery_id;
471: resultout := 'COMPLETE:SUCCESS';
472: fnd_message.set_name('WSH', 'WSH_WF_SCPOD_CLOSED');

Line 475: UPDATE WSH_NEW_DELIVERIES

471: resultout := 'COMPLETE:SUCCESS';
472: fnd_message.set_name('WSH', 'WSH_WF_SCPOD_CLOSED');
473: l_msg_data := FND_MESSAGE.Get;
474: ELSE
475: UPDATE WSH_NEW_DELIVERIES
476: SET del_wf_close_attr = 'E'
477: WHERE delivery_id = l_delivery_id;
478: resultout := 'COMPLETE:FAILURE';
479: END IF;

Line 579: UPDATE WSH_NEW_DELIVERIES

575: -- RUN mode - normal process execution
576: IF (funcmode = 'RUN') THEN
577: l_delivery_id := itemkey;
578: l_log_level := 1;
579: UPDATE WSH_NEW_DELIVERIES
580: SET del_wf_interface_attr = 'P'
581: WHERE delivery_id = l_delivery_id;
582:
583: l_request_id := FND_REQUEST.submit_Request('WSH', 'WSHINTERFACE', '', '', FALSE,

Line 593: UPDATE WSH_NEW_DELIVERIES

589: WSH_DEBUG_SV.log(l_module_name,'Request Id L_REQUEST_ID',l_request_id);
590: END IF;
591:
592: IF (l_request_id = 0) THEN
593: UPDATE WSH_NEW_DELIVERIES
594: SET del_wf_interface_attr = 'E'
595: WHERE delivery_id = l_delivery_id;
596: resultout := 'COMPLETE:FAILURE';
597: fnd_message.set_name('WSH', 'WSH_DET_INV_INT_REQ_SUBMISSION');

Line 600: UPDATE WSH_NEW_DELIVERIES

596: resultout := 'COMPLETE:FAILURE';
597: fnd_message.set_name('WSH', 'WSH_DET_INV_INT_REQ_SUBMISSION');
598: WSH_UTIL_CORE.ADD_MESSAGE(wsh_util_core.g_ret_sts_error,l_module_name);
599: ELSE
600: UPDATE WSH_NEW_DELIVERIES
601: SET del_wf_interface_attr = 'C'
602: WHERE delivery_id = l_delivery_id;
603: resultout := 'COMPLETE:SUCCESS';
604: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_INV_INT_SUBMITTED');

Line 1420: UPDATE WSH_NEW_DELIVERIES

1416: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND l_custom_process_name is null) THEN
1417: l_custom_process_name := 'R_SCPOD_C';
1418: END IF;
1419:
1420: UPDATE WSH_NEW_DELIVERIES
1421: SET delivery_scpod_wf_process=l_custom_process_name
1422: WHERE delivery_id=to_number(itemkey);
1423: resultout := 'COMPLETE:ENABLED';
1424: ELSE

Line 1489: FROM wsh_new_deliveries wnd,

1485: resultout OUT NOCOPY VARCHAR2 ) IS
1486:
1487: CURSOR get_manifest_status(l_delivery_id NUMBER) IS
1488: SELECT count(wnd.delivery_id)
1489: FROM wsh_new_deliveries wnd,
1490: mtl_parameters mp,
1491: wsh_carriers wc
1492: WHERE wnd.organization_id = mp.organization_id
1493: AND wnd.carrier_id = wc.carrier_id