440:
441: IF p_matching_basis = 'QUANTITY' THEN
442: SELECT DISPLAYED_FIELD
443: INTO x_contract_type
444: FROM PO_LOOKUP_CODES
445: WHERE LOOKUP_CODE = p_contract_type AND
446: LOOKUP_TYPE = 'PO_FEDERAL_CONTRACT_TYPES_QTY';
447: ELSIF p_matching_basis = 'AMOUNT' THEN
448: SELECT DISPLAYED_FIELD
446: LOOKUP_TYPE = 'PO_FEDERAL_CONTRACT_TYPES_QTY';
447: ELSIF p_matching_basis = 'AMOUNT' THEN
448: SELECT DISPLAYED_FIELD
449: INTO x_contract_type
450: FROM PO_LOOKUP_CODES
451: WHERE LOOKUP_CODE = p_contract_type AND
452: LOOKUP_TYPE = 'PO_FEDERAL_CONTRACT_TYPES_AMT';
453: END IF;
454:
526:
527: IF p_matching_basis = 'QUANTITY' THEN
528: SELECT DISPLAYED_FIELD
529: INTO x_contract_type
530: FROM PO_LOOKUP_CODES
531: WHERE LOOKUP_CODE = p_contract_type AND
532: LOOKUP_TYPE = 'PO_FEDERAL_CONTRACT_TYPES_QTY';
533: ELSIF p_matching_basis = 'AMOUNT' THEN
534: SELECT DISPLAYED_FIELD
532: LOOKUP_TYPE = 'PO_FEDERAL_CONTRACT_TYPES_QTY';
533: ELSIF p_matching_basis = 'AMOUNT' THEN
534: SELECT DISPLAYED_FIELD
535: INTO x_contract_type
536: FROM PO_LOOKUP_CODES
537: WHERE LOOKUP_CODE = p_contract_type AND
538: LOOKUP_TYPE = 'PO_FEDERAL_CONTRACT_TYPES_AMT';
539: END IF;
540:
582:
583: IF p_matching_basis = 'QUANTITY' THEN
584: SELECT DISPLAYED_FIELD
585: INTO x_idc_type
586: FROM PO_LOOKUP_CODES
587: WHERE LOOKUP_CODE = p_idc_type AND
588: LOOKUP_TYPE = 'PO_FEDERAL_IDC_TYPES';
589: ELSIF p_matching_basis = 'AMOUNT' THEN
590: SELECT DISPLAYED_FIELD
588: LOOKUP_TYPE = 'PO_FEDERAL_IDC_TYPES';
589: ELSIF p_matching_basis = 'AMOUNT' THEN
590: SELECT DISPLAYED_FIELD
591: INTO x_idc_type
592: FROM PO_LOOKUP_CODES
593: WHERE LOOKUP_CODE = p_idc_type AND
594: LOOKUP_TYPE = 'PO_FEDERAL_IDC_TYPES';
595: END IF;
596:
833: BEGIN
834:
835: SELECT displayed_field
836: INTO x_freight_meaning
837: FROM po_lookup_codes
838: WHERE lookup_type = 'FREIGHT TERMS'
839: AND lookup_code = p_freight_lookup_code;
840:
841: EXCEPTION WHEN OTHERS THEN
847: BEGIN
848:
849: SELECT displayed_field
850: INTO x_ship_cntrl_meaning
851: FROM po_lookup_codes
852: WHERE lookup_type = 'SHIPPING CONTROL'
853: AND lookup_code = p_ship_cntrl_lookup_code;
854:
855: EXCEPTION WHEN OTHERS THEN
861: BEGIN
862:
863: SELECT displayed_field
864: INTO x_fob_meaning
865: FROM po_lookup_codes
866: WHERE lookup_type = 'FOB'
867: AND lookup_code = p_fob_lookup_code;
868:
869: EXCEPTION WHEN OTHERS THEN