DBA Data[Home] [Help]

APPS.PO_CREATE_REQUISITION_SV dependencies on PO_LOOKUP_CODES

Line 718: FROM po_lookup_codes plc

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

Line 725: FROM po_lookup_codes plc

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

Line 732: FROM po_lookup_codes plc

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

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

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

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

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