APPS.GME_PICKING_PVT dependencies on FND_DATE

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

126: OPEN l_pick_cursor FOR l_sql_stmt
127: USING p_organization_id, p_from_batch, p_to_batch, p_oprn_no, p_oprn_vers,
128: p_product_no, p_organization_id, p_organization_id, p_product_no,
129: p_ingredient_no, p_organization_id, p_organization_id, p_ingredient_no,
130: p_days_forward, fnd_date.canonical_to_date(p_from_req_date),
131: fnd_date.canonical_to_date(p_to_req_date);
132: FETCH l_pick_cursor BULK COLLECT INTO l_picking_tbl;
133: CLOSE l_pick_cursor;
134: IF g_debug <= gme_debug.g_log_statement THEN

Line 131: fnd_date.canonical_to_date(p_to_req_date);

127: USING p_organization_id, p_from_batch, p_to_batch, p_oprn_no, p_oprn_vers,
128: p_product_no, p_organization_id, p_organization_id, p_product_no,
129: p_ingredient_no, p_organization_id, p_organization_id, p_ingredient_no,
130: p_days_forward, fnd_date.canonical_to_date(p_from_req_date),
131: fnd_date.canonical_to_date(p_to_req_date);
132: FETCH l_pick_cursor BULK COLLECT INTO l_picking_tbl;
133: CLOSE l_pick_cursor;
134: IF g_debug <= gme_debug.g_log_statement THEN
135: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':No. of records found = '|| l_picking_tbl.COUNT);