DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_ACTIONS dependencies on WSH_DELIVERY_LEGS

Line 3466: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);

3462: /* H integration: Pricing integration csun */
3463: IF l_del_tab.count > 0 THEN
3464: --
3465: IF l_debug_on THEN
3466: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
3467: END IF;
3468: --
3469: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
3470: p_entity_type => 'DELIVERY',

Line 3469: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

3465: IF l_debug_on THEN
3466: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
3467: END IF;
3468: --
3469: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
3470: p_entity_type => 'DELIVERY',
3471: p_entity_ids => l_del_tab,
3472: x_return_status => l_return_status);
3473: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 3846: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);

3842: l_del_tab.delete;
3843: l_del_tab(1) := l_del_rec.delivery_id;
3844: --
3845: IF l_debug_on THEN
3846: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
3847: END IF;
3848: --
3849: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
3850: p_entity_type => 'DELIVERY',

Line 3849: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

3845: IF l_debug_on THEN
3846: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
3847: END IF;
3848: --
3849: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
3850: p_entity_type => 'DELIVERY',
3851: p_entity_ids => l_del_tab,
3852: x_return_status => l_return_status);
3853: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 4950: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);

4946: l_del_tab(1) := p_delivery_id;
4947:
4948: --
4949: IF l_debug_on THEN
4950: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
4951: END IF;
4952: --
4953: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
4954: p_entity_type => 'DELIVERY',

Line 4953: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

4949: IF l_debug_on THEN
4950: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
4951: END IF;
4952: --
4953: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
4954: p_entity_type => 'DELIVERY',
4955: p_entity_ids => l_del_tab,
4956: x_return_status => l_return_status);
4957: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 6430: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);

6426: when plan a delivery
6427: */
6428: --
6429: IF l_debug_on THEN
6430: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
6431: WSH_DEBUG_SV.log(l_module_name,'Count of l_del_tab',l_del_tab.count);
6432: END IF;
6433: --
6434: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

Line 6434: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

6430: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
6431: WSH_DEBUG_SV.log(l_module_name,'Count of l_del_tab',l_del_tab.count);
6432: END IF;
6433: --
6434: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
6435: p_entity_type => 'DELIVERY',
6436: p_entity_ids => l_del_tab,
6437: x_return_status => l_return_status);
6438: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 6839: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);

6835: l_del_tab(1) := l_assign.delivery_id;
6836:
6837: --
6838: IF l_debug_on THEN
6839: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
6840: END IF;
6841: --
6842: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
6843: p_entity_type => 'DELIVERY',

Line 6842: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

6838: IF l_debug_on THEN
6839: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
6840: END IF;
6841: --
6842: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
6843: p_entity_type => 'DELIVERY',
6844: p_entity_ids => l_del_tab,
6845: x_return_status => l_return_status);
6846: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

Line 8560: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);

8556: END IF;
8557: IF l_del_tab.count > 0 THEN
8558: --
8559: IF l_debug_on THEN
8560: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
8561: END IF;
8562: --
8563: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
8564: p_entity_type => 'DELIVERY',

Line 8563: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

8559: IF l_debug_on THEN
8560: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
8561: END IF;
8562: --
8563: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
8564: p_entity_type => 'DELIVERY',
8565: p_entity_ids => l_del_tab,
8566: x_return_status => l_return_status);
8567: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 8956: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);

8952: l_entity_ids(1) := old_delivery_detail_rec.delivery_detail_id;
8953: --
8954: IF l_debug_on THEN
8955: WSH_DEBUG_SV.log(l_module_name,'entity id 1-',l_entity_ids(1));
8956: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
8957: END IF;
8958: --
8959: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
8960: p_entity_type => 'DELIVERY_DETAIL',

Line 8959: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

8955: WSH_DEBUG_SV.log(l_module_name,'entity id 1-',l_entity_ids(1));
8956: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
8957: END IF;
8958: --
8959: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
8960: p_entity_type => 'DELIVERY_DETAIL',
8961: p_entity_ids => l_entity_ids,
8962: x_return_status => l_return_status);
8963: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

Line 10181: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);

10177: */
10178: l_entity_ids(1) := old_delivery_detail_rec.delivery_detail_id;
10179: --
10180: IF l_debug_on THEN
10181: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
10182: END IF;
10183: --
10184: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
10185: p_entity_type => 'DELIVERY_DETAIL',

Line 10184: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

10180: IF l_debug_on THEN
10181: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
10182: END IF;
10183: --
10184: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
10185: p_entity_type => 'DELIVERY_DETAIL',
10186: p_entity_ids => l_entity_ids,
10187: x_return_status => l_return_status);
10188: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 13279: from wsh_delivery_legs l1, wsh_delivery_legs l2, wsh_delivery_assignments a

13275: x_return_status OUT NOCOPY VARCHAR2) IS
13276:
13277: cursor c_get_consolidation_delivery (p_det_id IN NUMBER) is
13278: select l1.delivery_id, l2.delivery_id
13279: from wsh_delivery_legs l1, wsh_delivery_legs l2, wsh_delivery_assignments a
13280: where a.delivery_detail_id = p_det_id
13281: and l1.delivery_id = a.delivery_id
13282: and l1.parent_delivery_leg_id = l2.delivery_leg_id
13283: and a.parent_delivery_detail_id is NULL