APPS.POR_VIEW_REQS_PKG dependencies on FND_GLOBAL

Line 458: fnd_global.Lookup_Security_Group(lv.lookup_type,

454: AND lookup_code = p_status_code
455: AND LANGUAGE = userenv('LANG')
456: AND VIEW_APPLICATION_ID = 660
457: AND SECURITY_GROUP_ID =
458: fnd_global.Lookup_Security_Group(lv.lookup_type,
459: lv.view_application_id);
460:
461: /* status is AWAITING_SHIPPING or PRODUCTION_COMPLETE etc.
462: get value from shipping table */

Line 480: fnd_global.Lookup_Security_Group(lv.lookup_type,

476: AND lookup_code = 'PICKED'
477: AND LANGUAGE = userenv('LANG')
478: AND VIEW_APPLICATION_ID = 660
479: AND SECURITY_GROUP_ID =
480: fnd_global.Lookup_Security_Group(lv.lookup_type,
481: lv.view_application_id);
482:
483: ELSIF l_released_count < l_total_count and l_released_count <> 0 THEN
484: SELECT meaning

Line 492: fnd_global.Lookup_Security_Group(lv.lookup_type,

488: AND lookup_code = 'PICKED_PARTIAL'
489: AND LANGUAGE = userenv('LANG')
490: AND VIEW_APPLICATION_ID = 660
491: AND SECURITY_GROUP_ID =
492: fnd_global.Lookup_Security_Group(lv.lookup_type,
493: lv.view_application_id);
494: ELSE
495: SELECT meaning
496: INTO l_flow_meaning

Line 503: fnd_global.Lookup_Security_Group(lv.lookup_type,

499: AND lookup_code = p_status_code
500: AND LANGUAGE = userenv('LANG')
501: AND VIEW_APPLICATION_ID = 660
502: AND SECURITY_GROUP_ID =
503: fnd_global.Lookup_Security_Group(lv.lookup_type,
504: lv.view_application_id);
505: END IF;
506: END IF;
507:

Line 557: fnd_global.Lookup_Security_Group(lv.lookup_type,

553: AND lookup_code = l_status_code
554: AND LANGUAGE = userenv('LANG')
555: AND VIEW_APPLICATION_ID = 660
556: AND SECURITY_GROUP_ID =
557: fnd_global.Lookup_Security_Group(lv.lookup_type,
558: lv.view_application_id);
559: END IF;
560: return l_flow_meaning;
561: