APPS.POA_SUPPLIER_CONSOLIDATION_PK dependencies on FND_PROFILE

Line 313: IF (fnd_profile.value('POA_GLOBAL_SECURITY') = 'Y') THEN

309: x_progress := '001';
310:
311: -- Select the average price
312:
313: IF (fnd_profile.value('POA_GLOBAL_SECURITY') = 'Y') THEN
314: SELECT SUM(psp.purchase_price *
315: DECODE(gl_currency_api.rate_exists(psp.currency_code,
316: p_currency_code,
317: psp.rate_date,

Line 378: IF (fnd_profile.value('POA_GLOBAL_SECURITY') = 'Y') THEN

374: x_progress := '002';
375:
376: -- Select the average percentage of defect
377:
378: IF (fnd_profile.value('POA_GLOBAL_SECURITY') = 'Y') THEN
379: SELECT SUM(psp.quantity_rejected)/SUM(psp.quantity_received)
380: INTO v_pref_pct_defect
381: FROM poa_bis_supplier_performance psp
382: WHERE psp.item_id = p_item_id

Line 420: IF (fnd_profile.value('POA_GLOBAL_SECURITY') = 'Y') THEN

416: x_progress := '003';
417:
418: -- Select the average percentage of delivery exception
419:
420: IF (fnd_profile.value('POA_GLOBAL_SECURITY') = 'Y') THEN
421: SELECT SUM(psp.quantity_received_late + psp.quantity_received_early +
422: psp.quantity_past_due)/SUM(psp.quantity_purchased)
423: INTO v_pref_pct_del_excp
424: FROM poa_bis_supplier_performance psp

Line 491: IF (fnd_profile.value('POA_GLOBAL_SECURITY') = 'Y') THEN

487: -- Get consolidated supplier(s) info and calculate savings
488: -- ------------------------------------------------------------------------
489: x_progress := '004';
490:
491: IF (fnd_profile.value('POA_GLOBAL_SECURITY') = 'Y') THEN
492: OPEN c_cons_supplier;
493: ELSE
494: OPEN c_cons_supplier_glb_sec;
495: END IF;

Line 500: IF (fnd_profile.value('POA_GLOBAL_SECURITY') = 'Y') THEN

496:
497: LOOP
498: x_progress := '005';
499:
500: IF (fnd_profile.value('POA_GLOBAL_SECURITY') = 'Y') THEN
501: FETCH c_cons_supplier INTO v_cons_shipment_id,
502: v_cons_purch_price,
503: v_cons_qty_purchased,
504: v_cons_qty_ordered,

Line 539: IF (fnd_profile.value('POA_GLOBAL_SECURITY') = 'Y') THEN

535: -- Get blankets w/ price breaks
536:
537: x_progress := '006';
538:
539: IF (fnd_profile.value('POA_GLOBAL_SECURITY') = 'Y') THEN
540: OPEN c_blanket_break;
541: FETCH c_blanket_break INTO v_pref_blanket_price;
542:
543: IF c_blanket_break%NOTFOUND THEN

Line 563: IF (fnd_profile.value('POA_GLOBAL_SECURITY') = 'Y') THEN

559: -- Get blankets w/out price breaks
560:
561: x_progress := '007';
562:
563: IF (fnd_profile.value('POA_GLOBAL_SECURITY') = 'Y') THEN
564: OPEN c_blanket_nobreak;
565: FETCH c_blanket_nobreak INTO v_pref_blanket_price2;
566:
567: IF c_blanket_nobreak%NOTFOUND THEN

Line 647: IF (fnd_profile.value('POA_GLOBAL_SECURITY') = 'Y') THEN

643: END IF;
644:
645: END LOOP;
646:
647: IF (fnd_profile.value('POA_GLOBAL_SECURITY') = 'Y') THEN
648: CLOSE c_cons_supplier;
649: ELSE
650: CLOSE c_cons_supplier_glb_sec;
651: END IF;