APPS.PO_CREATE_REQUISITION_SV dependencies on PO_LOOKUP_CODES

Line 720: FROM po_lookup_codes plc

716:
717: -- For Source Type Code validation, if passed to the procedure
718: CURSOR source_type_cur (p_source_type_code VARCHAR2) IS
719: SELECT 'X'
720: FROM po_lookup_codes plc
721: WHERE plc.lookup_type = 'REQUISITION SOURCE TYPE'
722: AND plc.lookup_code = p_source_type_code;
723:
724: -- For Destination Type Code validation, if passed to the procedure

Line 727: FROM po_lookup_codes plc

723:
724: -- For Destination Type Code validation, if passed to the procedure
725: CURSOR destination_type_cur (p_destination_type_code VARCHAR2) IS
726: SELECT 'X'
727: FROM po_lookup_codes plc
728: WHERE plc.lookup_type = 'DESTINATION TYPE'
729: AND plc.lookup_code = p_destination_type_code;
730:
731: -- For Authorization Status validation, if passed to the procedure

Line 734: FROM po_lookup_codes plc

730:
731: -- For Authorization Status validation, if passed to the procedure
732: CURSOR authorization_status_cur (p_authorization_status VARCHAR2) IS
733: SELECT 'X'
734: FROM po_lookup_codes plc
735: WHERE plc.lookup_type = 'AUTHORIZATION STATUS'
736: AND plc.lookup_code = p_authorization_status;
737:
738: -- Get Set of Books ID for a given Org_ID - Mandatory in PO_REQ_DISTRIBUTIONS

Line 1074: -- If passed, validate Source Type Code from PO_LOOKUP_CODES

1070: Raise INVALID_QUANTITY;
1071: END IF;
1072:
1073: -- Default INVENTORY as Source_Type_Code for Internal Requisitions if not passed
1074: -- If passed, validate Source Type Code from PO_LOOKUP_CODES
1075: -- If Invalid, Raise Error
1076: IF (l_line_tbl(i).source_type_code IS NULL ) THEN
1077: l_line_tbl(i).source_type_code := 'INVENTORY';
1078: ELSE

Line 1101: -- If passed, validate Destination Type Code from PO_LOOKUP_CODES

1097: l_line_tbl(i).cancel_flag := 'N';
1098: END IF;
1099:
1100: -- Default INVENTORY as Destination_Type_Code for Internal Requisitions if not passed
1101: -- If passed, validate Destination Type Code from PO_LOOKUP_CODES
1102: -- If Invalid, Raise Error
1103: IF (l_line_tbl(i).destination_type_code IS NULL ) THEN
1104: l_line_tbl(i).destination_type_code := 'INVENTORY';
1105: ELSE