DBA Data[Home] [Help]

APPS.JMF_SHIKYU_ALLOCATION_PVT dependencies on DBMS_OUTPUT

Line 82: --| 26-OCT-2005 vchu Replaced dbms_output calls with FND_LOG calls. |

78: --| change of signature. Also added the where |
79: --| clause condition "pha.approved_flag = 'Y'" to |
80: --| the query of the c_avail_replen_po_cur cursor |
81: --| in the Get_Available_Replenishment_Po procedure |
82: --| 26-OCT-2005 vchu Replaced dbms_output calls with FND_LOG calls. |
83: --| Also modified the value to populate into the |
84: --| TP_SUPPLIER_ID and TP_SUPPLIER_SITE_ID columns |
85: --| of the JMF_SHIKYU_REPLENISHMENTS table for |
86: --| fixing the wrong value issue of the |

Line 3069: dbms_output.put_line('In Loop : IF x_deleted_allocations_tbl IS NOT NULL AND x_deleted_allocations_tbl.COUNT > 0');

3065: IF l_tbl_index IS NOT NULL
3066: THEN
3067: LOOP
3068:
3069: dbms_output.put_line('In Loop : IF x_deleted_allocations_tbl IS NOT NULL AND x_deleted_allocations_tbl.COUNT > 0');
3070:
3071: -- Get UOM of the Replenishment SO Line
3072: SELECT jsr.uom
3073: INTO l_replen_uom