APPS.WSH_NEW_DELIVERIES_PVT dependencies on WSH_DELIVERY_LEGS

Line 1264: FROM wsh_delivery_legs

1260: WHERE rowid = v_rowid;
1261:
1262: CURSOR get_delivery_legs (v_delivery_id NUMBER) IS
1263: SELECT delivery_leg_id, parent_delivery_leg_id
1264: FROM wsh_delivery_legs
1265: WHERE delivery_id = v_delivery_id;
1266:
1267: CURSOR detail_info(v_delivery_id NUMBER) IS
1268: SELECT delivery_detail_id

Line 1403: WSH_DELIVERY_LEGS_PVT.Delete_Delivery_Leg(

1399: END IF;
1400:
1401: END IF;
1402:
1403: WSH_DELIVERY_LEGS_PVT.Delete_Delivery_Leg(
1404: p_delivery_leg_id => dl.delivery_leg_id,
1405: x_return_status => l_return_status);
1406: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1407: ) THEN

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

2410: p_delivery_id => p_rec_attr_tab(l_index).delivery_id);
2411:
2412: if p_action = 'CONFIRM' then
2413: IF l_debug_on THEN
2414: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_PVT.LOCK_DLVY_LEG',WSH_DEBUG_SV.C_PROC_LEVEL);
2415: END IF;
2416: wsh_delivery_legs_pvt.lock_dlvy_leg_no_compare(
2417: p_delivery_id => p_rec_attr_tab(l_index).delivery_id);
2418: end if;

Line 2416: wsh_delivery_legs_pvt.lock_dlvy_leg_no_compare(

2412: if p_action = 'CONFIRM' then
2413: IF l_debug_on THEN
2414: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_PVT.LOCK_DLVY_LEG',WSH_DEBUG_SV.C_PROC_LEVEL);
2415: END IF;
2416: wsh_delivery_legs_pvt.lock_dlvy_leg_no_compare(
2417: p_delivery_id => p_rec_attr_tab(l_index).delivery_id);
2418: end if;
2419:
2420: end if;

Line 2652: FROM wsh_delivery_legs

2648: --
2649: CURSOR leg_csr(p_delivery_id NUMBER)
2650: IS
2651: SELECT delivery_leg_id
2652: FROM wsh_delivery_legs
2653: WHERE delivery_id = p_delivery_id;
2654: --
2655: --
2656: CURSOR count_delivery_rows (p_delivery_name VARCHAR2) IS

Line 3077: INSERT INTO wsh_delivery_legs

3073: --
3074: IF p_copy_legs = 'Y'
3075: THEN
3076: --{
3077: INSERT INTO wsh_delivery_legs
3078: (
3079: DELIVERY_LEG_ID,
3080: DELIVERY_ID,
3081: SEQUENCE_NUMBER,

Line 3148: wsh_delivery_legs_s.NEXTVAL,

3144: ORIGIN_STOP_ID,
3145: DESTINATION_STOP_ID
3146: )
3147: SELECT
3148: wsh_delivery_legs_s.NEXTVAL,
3149: l_delivery_id,
3150: SEQUENCE_NUMBER,
3151: LOADING_ORDER_FLAG,
3152: PICK_UP_STOP_ID,

Line 3215: FROM WSH_DELIVERY_LEGS

3211: LOADED_QUANTITY,
3212: RECEIVED_QUANTITY,
3213: ORIGIN_STOP_ID,
3214: DESTINATION_STOP_ID
3215: FROM WSH_DELIVERY_LEGS
3216: WHERE DELIVERY_ID = p_delivery_id;
3217: --
3218: IF l_debug_on THEN
3219: WSH_DEBUG_SV.logmsg(l_module_name, 'Inserted ' || SQL%ROWCOUNT || ' Legs' );