APPS.WSH_NEW_DELIVERIES_PVT dependencies on WSH_DELIVERY_LEGS

Line 1269: FROM wsh_delivery_legs

1265: WHERE rowid = v_rowid;
1266:
1267: CURSOR get_delivery_legs (v_delivery_id NUMBER) IS
1268: SELECT delivery_leg_id, parent_delivery_leg_id
1269: FROM wsh_delivery_legs
1270: WHERE delivery_id = v_delivery_id;
1271:
1272: CURSOR detail_info(v_delivery_id NUMBER) IS
1273: SELECT delivery_detail_id

Line 1408: WSH_DELIVERY_LEGS_PVT.Delete_Delivery_Leg(

1404: END IF;
1405:
1406: END IF;
1407:
1408: WSH_DELIVERY_LEGS_PVT.Delete_Delivery_Leg(
1409: p_delivery_leg_id => dl.delivery_leg_id,
1410: x_return_status => l_return_status);
1411: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1412: ) THEN

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

2430: p_delivery_id => p_rec_attr_tab(l_index).delivery_id);
2431:
2432: if p_action = 'CONFIRM' then
2433: IF l_debug_on THEN
2434: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_PVT.LOCK_DLVY_LEG',WSH_DEBUG_SV.C_PROC_LEVEL);
2435: END IF;
2436: wsh_delivery_legs_pvt.lock_dlvy_leg_no_compare(
2437: p_delivery_id => p_rec_attr_tab(l_index).delivery_id);
2438: end if;

Line 2436: wsh_delivery_legs_pvt.lock_dlvy_leg_no_compare(

2432: if p_action = 'CONFIRM' then
2433: IF l_debug_on THEN
2434: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_PVT.LOCK_DLVY_LEG',WSH_DEBUG_SV.C_PROC_LEVEL);
2435: END IF;
2436: wsh_delivery_legs_pvt.lock_dlvy_leg_no_compare(
2437: p_delivery_id => p_rec_attr_tab(l_index).delivery_id);
2438: end if;
2439:
2440: end if;

Line 2672: FROM wsh_delivery_legs

2668: --
2669: CURSOR leg_csr(p_delivery_id NUMBER)
2670: IS
2671: SELECT delivery_leg_id
2672: FROM wsh_delivery_legs
2673: WHERE delivery_id = p_delivery_id;
2674: --
2675: --
2676: CURSOR count_delivery_rows (p_delivery_name VARCHAR2) IS

Line 3097: INSERT INTO wsh_delivery_legs

3093: --
3094: IF p_copy_legs = 'Y'
3095: THEN
3096: --{
3097: INSERT INTO wsh_delivery_legs
3098: (
3099: DELIVERY_LEG_ID,
3100: DELIVERY_ID,
3101: SEQUENCE_NUMBER,

Line 3168: wsh_delivery_legs_s.NEXTVAL,

3164: ORIGIN_STOP_ID,
3165: DESTINATION_STOP_ID
3166: )
3167: SELECT
3168: wsh_delivery_legs_s.NEXTVAL,
3169: l_delivery_id,
3170: SEQUENCE_NUMBER,
3171: LOADING_ORDER_FLAG,
3172: PICK_UP_STOP_ID,

Line 3235: FROM WSH_DELIVERY_LEGS

3231: LOADED_QUANTITY,
3232: RECEIVED_QUANTITY,
3233: ORIGIN_STOP_ID,
3234: DESTINATION_STOP_ID
3235: FROM WSH_DELIVERY_LEGS
3236: WHERE DELIVERY_ID = p_delivery_id;
3237: --
3238: IF l_debug_on THEN
3239: WSH_DEBUG_SV.logmsg(l_module_name, 'Inserted ' || SQL%ROWCOUNT || ' Legs' );