DBA Data[Home] [Help]

APPS.WMS_PLAN_TASKS_PVT dependencies on WMS_DEPLOY

Line 3129: l_from_client_code := wms_deploy.get_po_client_code(wms_plan_tasks_pvt.g_from_po_header_id);

3125: END IF;
3126:
3127: --Hardik LSP bug 9274233
3128:
3129: l_from_client_code := wms_deploy.get_po_client_code(wms_plan_tasks_pvt.g_from_po_header_id);
3130: l_delimiter := wms_deploy.get_item_flex_delimiter;
3131: l_is_po_number := wms_deploy.get_po_number(wms_plan_tasks_pvt.g_from_purchase_order);
3132:
3133: IF l_is_po_number <> '-1' THEN

Line 3130: l_delimiter := wms_deploy.get_item_flex_delimiter;

3126:
3127: --Hardik LSP bug 9274233
3128:
3129: l_from_client_code := wms_deploy.get_po_client_code(wms_plan_tasks_pvt.g_from_po_header_id);
3130: l_delimiter := wms_deploy.get_item_flex_delimiter;
3131: l_is_po_number := wms_deploy.get_po_number(wms_plan_tasks_pvt.g_from_purchase_order);
3132:
3133: IF l_is_po_number <> '-1' THEN
3134: IF l_from_client_code IS NOT NULL THEN

Line 3131: l_is_po_number := wms_deploy.get_po_number(wms_plan_tasks_pvt.g_from_purchase_order);

3127: --Hardik LSP bug 9274233
3128:
3129: l_from_client_code := wms_deploy.get_po_client_code(wms_plan_tasks_pvt.g_from_po_header_id);
3130: l_delimiter := wms_deploy.get_item_flex_delimiter;
3131: l_is_po_number := wms_deploy.get_po_number(wms_plan_tasks_pvt.g_from_purchase_order);
3132:
3133: IF l_is_po_number <> '-1' THEN
3134: IF l_from_client_code IS NOT NULL THEN
3135: l_inbound_where := l_inbound_where

Line 3139: || 'AND to_char(wms_deploy.get_po_number(ph.segment1)) = ph.segment1';

3135: l_inbound_where := l_inbound_where
3136: || 'AND ph.segment1 LIKE ' || '''' || '%' || l_delimiter || l_from_client_code || '''';
3137: ELSE
3138: l_inbound_where := l_inbound_where
3139: || 'AND to_char(wms_deploy.get_po_number(ph.segment1)) = ph.segment1';
3140: END IF;
3141: END IF;
3142: --Hardik LSP End bug 9274233
3143: