APPS.WSH_BOLS_PVT dependencies on WSH_DELIVERY_LEGS

Line 66: l_leg_info_new wsh_delivery_legs_pvt.delivery_leg_rec_type;

62: )
63: IS
64: x_rowid varchar2(30);
65: l_trip_info wsh_trips_pvt.trip_rec_type;
66: l_leg_info_new wsh_delivery_legs_pvt.delivery_leg_rec_type;
67: l_leg_info_old wsh_delivery_legs_pvt.delivery_leg_rec_type;
68: l_old_leg_id NUMBER;
69: l_new_leg_id NUMBER;
70: l_ledger_id NUMBER; -- LE Uptake

Line 67: l_leg_info_old wsh_delivery_legs_pvt.delivery_leg_rec_type;

63: IS
64: x_rowid varchar2(30);
65: l_trip_info wsh_trips_pvt.trip_rec_type;
66: l_leg_info_new wsh_delivery_legs_pvt.delivery_leg_rec_type;
67: l_leg_info_old wsh_delivery_legs_pvt.delivery_leg_rec_type;
68: l_old_leg_id NUMBER;
69: l_new_leg_id NUMBER;
70: l_ledger_id NUMBER; -- LE Uptake
71: l_del_rows wsh_util_core.id_tab_type;

Line 557: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_PVT.DELETE_DELIVERY_LEG',WSH_DEBUG_SV.C_PROC_LEVEL);

553: END IF;
554: END IF;
555:
556: IF l_debug_on THEN
557: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_PVT.DELETE_DELIVERY_LEG',WSH_DEBUG_SV.C_PROC_LEVEL);
558: END IF;
559: --
560: wsh_delivery_legs_pvt.delete_delivery_leg
561: (l_rowid,

Line 560: wsh_delivery_legs_pvt.delete_delivery_leg

556: IF l_debug_on THEN
557: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_PVT.DELETE_DELIVERY_LEG',WSH_DEBUG_SV.C_PROC_LEVEL);
558: END IF;
559: --
560: wsh_delivery_legs_pvt.delete_delivery_leg
561: (l_rowid,
562: p_entity_id,
563: x_return_status
564: );

Line 627: from wsh_delivery_legs wdl,

623: wts1.stop_location_id,
624: wdi.document_instance_id,
625: wdl.delivery_id , --bugfix 3990683
626: wt.name
627: from wsh_delivery_legs wdl,
628: wsh_trip_stops wts1,
629: wsh_trips wt,
630: wsh_document_instances wdi,
631: wsh_doc_sequence_categories wdsc

Line 635: AND wdi.entity_name = 'WSH_DELIVERY_LEGS'

631: wsh_doc_sequence_categories wdsc
632: where wdsc.doc_sequence_category_id = wdi.doc_sequence_category_id
633: AND NVL(wdsc.document_code, '-99') <> '-99'
634: AND wdi.entity_id = wdl.delivery_leg_id
635: AND wdi.entity_name = 'WSH_DELIVERY_LEGS'
636: AND wdi.document_type = 'BOL'
637: AND wdi.status <> 'CANCELLED'
638: AND wts1.trip_id = wt.trip_id
639: and wts1.stop_id =wdl.PICK_UP_STOP_ID

Line 649: from wsh_delivery_legs wdl,

645: wts1.stop_location_id,
646: wdi.document_instance_id,
647: wdl.delivery_id , --bugfix 3990683
648: wt.name
649: from wsh_delivery_legs wdl,
650: wsh_trip_stops wts1,
651: wsh_trip_stops wts2,
652: wsh_trips wt,
653: wsh_document_instances wdi

Line 655: AND wdi.entity_name = 'WSH_DELIVERY_LEGS'

651: wsh_trip_stops wts2,
652: wsh_trips wt,
653: wsh_document_instances wdi
654: where wdi.entity_id = wdl.delivery_leg_id
655: AND wdi.entity_name = 'WSH_DELIVERY_LEGS'
656: AND wdi.document_type = 'BOL'
657: AND wdi.status <> 'CANCELLED'
658: AND wts1.trip_id = wt.trip_id
659: and wts2.trip_id = wt.trip_id