[Home] [Help]
2426: BEGIN
2427:
2428: SELECT meaning
2429: INTO G_STATUS_MEANING
2430: FROM FND_LOOKUP_VALUES LV
2431: WHERE lookup_type = 'SHIPMENT LINE STATUS'
2432: AND lookup_code = l_status
2433: AND LANGUAGE = USERENV('LANG')
2434: AND VIEW_APPLICATION_ID = 201
2439: WHEN NO_DATA_FOUND THEN
2440: l_status := p_flow_status_code;
2441: SELECT meaning
2442: INTO G_STATUS_MEANING
2443: FROM fnd_lookup_values lv
2444: WHERE lookup_type = 'LINE_FLOW_STATUS'
2445: AND lookup_code = p_flow_status_code
2446: AND LANGUAGE = userenv('LANG')
2447: AND VIEW_APPLICATION_ID = 660
2454: ELSIF (p_flow_status_code <> 'AWAITING_SHIPPING' AND
2455: p_flow_status_code <> 'PRODUCTION_COMPLETE') THEN
2456: SELECT meaning
2457: INTO G_STATUS_MEANING
2458: FROM fnd_lookup_values lv
2459: WHERE lookup_type = 'LINE_FLOW_STATUS'
2460: AND lookup_code = p_flow_status_code
2461: AND LANGUAGE = userenv('LANG')
2462: AND VIEW_APPLICATION_ID = 660
2475: IF l_released_count = l_total_count THEN
2476: l_status := 'PICKED';
2477: SELECT meaning
2478: INTO G_STATUS_MEANING
2479: FROM fnd_lookup_values lv
2480: WHERE lookup_type = 'LINE_FLOW_STATUS'
2481: AND lookup_code = 'PICKED'
2482: AND LANGUAGE = userenv('LANG')
2483: AND VIEW_APPLICATION_ID = 660
2486: ELSIF l_released_count < l_total_count and l_released_count <> 0 THEN
2487: l_status := 'PICKED_PARTIAL';
2488: SELECT meaning
2489: INTO G_STATUS_MEANING
2490: FROM fnd_lookup_values lv
2491: WHERE lookup_type = 'LINE_FLOW_STATUS'
2492: AND lookup_code = 'PICKED_PARTIAL'
2493: AND LANGUAGE = userenv('LANG')
2494: AND VIEW_APPLICATION_ID = 660
2496: lv.view_application_id);
2497: ELSE
2498: SELECT meaning
2499: INTO G_STATUS_MEANING
2500: FROM fnd_lookup_values lv
2501: WHERE lookup_type = 'LINE_FLOW_STATUS'
2502: AND lookup_code = l_status
2503: AND LANGUAGE = userenv('LANG')
2504: AND VIEW_APPLICATION_ID = 660