DBA Data[Home] [Help]

APPS.GME_PICKING_PVT dependencies on FND_DATE

Line 111: p_days_forward, fnd_date.canonical_to_date(p_from_req_date),

107: OPEN l_pick_cursor FOR l_sql_stmt
108: USING p_organization_id, p_from_batch, p_to_batch, p_oprn_no, p_oprn_vers,
109: p_product_no, p_organization_id, p_organization_id, p_product_no,
110: p_ingredient_no, p_organization_id, p_organization_id, p_ingredient_no,
111: p_days_forward, fnd_date.canonical_to_date(p_from_req_date),
112: fnd_date.canonical_to_date(p_to_req_date);
113: FETCH l_pick_cursor BULK COLLECT INTO l_picking_tbl;
114: CLOSE l_pick_cursor;
115: IF g_debug <= gme_debug.g_log_statement THEN

Line 112: fnd_date.canonical_to_date(p_to_req_date);

108: USING p_organization_id, p_from_batch, p_to_batch, p_oprn_no, p_oprn_vers,
109: p_product_no, p_organization_id, p_organization_id, p_product_no,
110: p_ingredient_no, p_organization_id, p_organization_id, p_ingredient_no,
111: p_days_forward, fnd_date.canonical_to_date(p_from_req_date),
112: fnd_date.canonical_to_date(p_to_req_date);
113: FETCH l_pick_cursor BULK COLLECT INTO l_picking_tbl;
114: CLOSE l_pick_cursor;
115: IF g_debug <= gme_debug.g_log_statement THEN
116: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':No. of records found = '|| l_picking_tbl.COUNT);