APPS.JAI_OM_WSH_PROCESSING_PKG dependencies on WSH_DELIVERY_TRIPS_V

Line 69: v_trip_id wsh_delivery_trips_v.trip_id%type;

65: v_register_code JAI_OM_OE_BOND_REG_HDRS.register_code%type;
66: v_debug_flag varchar2(1); --'N'; --Ramananda for File.Sql.35
67: v_utl_location VARCHAR2(512); --For Log file.
68: v_myfilehandle UTL_FILE.FILE_TYPE; -- This is for File handling
69: v_trip_id wsh_delivery_trips_v.trip_id%type;
70: lv_process_flag VARCHAR2(2);
71: lv_process_message VARCHAR2(1996);
72: lv_register_type VARCHAR2(5);
73: lv_rg23a_cess_avlbl VARCHAR2(10);

Line 493: FROM WSH_DELIVERY_TRIPS_V

489: IF v_reg_type='ERROR' THEN
490: BEGIN
491: SELECT TRIP_ID
492: into v_trip_id
493: FROM WSH_DELIVERY_TRIPS_V
494: WHERE DELIVERY_ID=p_delivery_id;
495: EXCEPTION
496: WHEN OTHERS THEN
497: NULL;