DBA Data[Home] [Help]

APPS.WSH_PACKING_SLIPS_PVT dependencies on WSH_NEW_DELIVERIES

Line 69: wsh_new_deliveries wnd

65: -- LE Uptake
66: SELECT hoi.org_information1
67: INTO l_ledger_id
68: FROM hr_organization_information hoi,
69: wsh_new_deliveries wnd
70: WHERE wnd.delivery_id = p_entity_id
71: AND hoi.organization_id = wnd.organization_id
72: AND hoi.org_information_context = 'Accounting Information';
73:

Line 77: FROM wsh_new_deliveries

73:
74: -- Bug 2276586
75: SELECT delivery_id
76: INTO l_delivery_id
77: FROM wsh_new_deliveries
78: WHERE delivery_id = p_entity_id
79: FOR UPDATE NOWAIT;
80:
81: /* Changes for Shipping Data Model Bug#1918342*/

Line 83: Update WSH_NEW_DELIVERIES

79: FOR UPDATE NOWAIT;
80:
81: /* Changes for Shipping Data Model Bug#1918342*/
82:
83: Update WSH_NEW_DELIVERIES
84: SET
85: reason_of_transport = p_reason_of_transport,
86: description = p_description,
87: last_updated_by = fnd_global.user_id,

Line 270: wsh_new_deliveries wnd

266:
267: SELECT hoi.org_information1
268: INTO l_ledger_id
269: FROM hr_organization_information hoi,
270: wsh_new_deliveries wnd
271: WHERE wnd.delivery_id = p_entity_id
272: AND hoi.organization_id = wnd.organization_id
273: AND hoi.org_information_context = 'Accounting Information';
274:

Line 278: FROM wsh_new_deliveries

274:
275: -- Bug 2276586
276: SELECT delivery_id
277: INTO l_delivery_id
278: FROM wsh_new_deliveries
279: WHERE delivery_id = p_entity_id
280: FOR UPDATE NOWAIT;
281:
282: /* Changes for Shipping DataModel Bug#1918342 */

Line 284: Update WSH_NEW_DELIVERIES

280: FOR UPDATE NOWAIT;
281:
282: /* Changes for Shipping DataModel Bug#1918342 */
283:
284: Update WSH_NEW_DELIVERIES
285: SET
286: reason_of_transport = p_reason_of_transport,
287: description = p_description,
288: last_updated_by = fnd_global.user_id,

Line 532: FROM wsh_new_deliveries

528: IS
529: CURSOR get_delivery_status
530: IS
531: SELECT status_code
532: FROM wsh_new_deliveries
533: WHERE delivery_id = p_delivery_id;
534:
535: i NUMBER :=0;
536: wsh_dp_no_entity EXCEPTION;