APPS.POR_VIEW_REQS_PKG dependencies on FND_GLOBAL

Line 193: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL1.LOOKUP_TYPE, FCL1.VIEW_APPLICATION_ID)) AND

189: HLC.REGION_1 = FCL1.LOOKUP_CODE (+) AND
190: HLC.COUNTRY || '_PROVINCE' = FCL1.LOOKUP_TYPE (+) AND
191: DECODE(FCL1.LOOKUP_CODE, NULL, '1', FCL1.SECURITY_GROUP_ID) =
192: DECODE(FCL1.LOOKUP_CODE, NULL, '1',
193: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL1.LOOKUP_TYPE, FCL1.VIEW_APPLICATION_ID)) AND
194: DECODE(FCL1.LOOKUP_CODE, NULL, '1', FCL1.VIEW_APPLICATION_ID) =
195: DECODE(FCL1.LOOKUP_CODE, NULL, '1', 3) AND
196: DECODE(FCL1.LOOKUP_CODE, NULL, '1', FCL1.LANGUAGE) =
197: DECODE(FCL1.LOOKUP_CODE, NULL, '1', USERENV('LANG')) AND

Line 202: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL2.LOOKUP_TYPE, FCL2.VIEW_APPLICATION_ID)) AND

198: HLC.REGION_2 = FCL2.LOOKUP_CODE (+) AND
199: HLC.COUNTRY || '_STATE' = FCL2.LOOKUP_TYPE (+) AND
200: DECODE(FCL2.LOOKUP_CODE, NULL, '1', FCL2.SECURITY_GROUP_ID) =
201: DECODE(FCL2.LOOKUP_CODE, NULL, '1',
202: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL2.LOOKUP_TYPE, FCL2.VIEW_APPLICATION_ID)) AND
203: DECODE(FCL2.LOOKUP_CODE, NULL, '1', FCL2.VIEW_APPLICATION_ID) =
204: DECODE(FCL2.LOOKUP_CODE, NULL, '1', 3) AND
205: DECODE(FCL2.LOOKUP_CODE, NULL, '1', FCL2.LANGUAGE) =
206: DECODE(FCL2.LOOKUP_CODE, NULL, '1', USERENV('LANG')) AND

Line 211: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL3.LOOKUP_TYPE, FCL3.VIEW_APPLICATION_ID)) AND

207: HLC.REGION_1 = FCL3.LOOKUP_CODE (+) AND
208: HLC.COUNTRY || '_COUNTY' = FCL3.LOOKUP_TYPE (+) AND
209: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.SECURITY_GROUP_ID) =
210: DECODE(FCL3.LOOKUP_CODE, NULL, '1',
211: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL3.LOOKUP_TYPE, FCL3.VIEW_APPLICATION_ID)) AND
212: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.VIEW_APPLICATION_ID) =
213: DECODE(FCL3.LOOKUP_CODE, NULL, '1', 3) AND
214: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.LANGUAGE) =
215: DECODE(FCL3.LOOKUP_CODE, NULL, '1', USERENV('LANG')) ;

Line 535: fnd_global.Lookup_Security_Group(lv.lookup_type,

531: AND lookup_code = p_status_code
532: AND LANGUAGE = userenv('LANG')
533: AND VIEW_APPLICATION_ID = 660
534: AND SECURITY_GROUP_ID =
535: fnd_global.Lookup_Security_Group(lv.lookup_type,
536: lv.view_application_id);
537:
538: /* status is AWAITING_SHIPPING or PRODUCTION_COMPLETE etc.
539: get value from shipping table */

Line 557: fnd_global.Lookup_Security_Group(lv.lookup_type,

553: AND lookup_code = 'PICKED'
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:
560: ELSIF l_released_count < l_total_count and l_released_count <> 0 THEN
561: SELECT meaning

Line 569: fnd_global.Lookup_Security_Group(lv.lookup_type,

565: AND lookup_code = 'PICKED_PARTIAL'
566: AND LANGUAGE = userenv('LANG')
567: AND VIEW_APPLICATION_ID = 660
568: AND SECURITY_GROUP_ID =
569: fnd_global.Lookup_Security_Group(lv.lookup_type,
570: lv.view_application_id);
571: ELSE
572: SELECT meaning
573: INTO l_flow_meaning

Line 580: fnd_global.Lookup_Security_Group(lv.lookup_type,

576: AND lookup_code = p_status_code
577: AND LANGUAGE = userenv('LANG')
578: AND VIEW_APPLICATION_ID = 660
579: AND SECURITY_GROUP_ID =
580: fnd_global.Lookup_Security_Group(lv.lookup_type,
581: lv.view_application_id);
582: END IF;
583: END IF;
584:

Line 635: fnd_global.Lookup_Security_Group(lv.lookup_type,

631: AND lookup_code = l_status_code
632: AND LANGUAGE = userenv('LANG')
633: AND VIEW_APPLICATION_ID = 660
634: AND SECURITY_GROUP_ID =
635: fnd_global.Lookup_Security_Group(lv.lookup_type,
636: lv.view_application_id);
637: END IF;
638: return l_flow_meaning;
639: