Exist method call without boolean argument
Check for the Exist calls to validity set LUs in non-base layers and verify if the last argument is 'TRUE' or 'FALSE'.
Violating this rule will affect the functionality of the code.The severity is minor which means that the code probably works, but should be corrected at first opportunity.
Note:
This rule is subject to a white-list that is maintained by the product managers collectively.Code that violates this rule must either be fixed or put on the appropriate white-list.See appendixes for currently white-listed objects.
In the following example assume, the Currency_Code_API is a Validity set LU. But the Exist call does not contain a boolean variable as the last argument.
and this could be a potential problem in runtime if the data is blocked.
...
PROCEDURE Drive_Me (
iata_code_ IN VARCHAR2 )
IS
BEGIN
Currency_Code_API.Exist( iata_code_);
END Drive_Me;
...
Appendix 1: List of PL/SQL function names that can give these types of errors.
Appendix 2: Validty enabled files in ACCRUL.
Appendix 3: Validty enabled files in APPSRV.
-
QUA_DISPOSITION_CODE_API
-
QUA_NON_CONFORMANCE_API
Appendix 4: Validty enabled files in CAREER.
-
CAREER_PERIOD_API
-
CAREER_POTENTIAL_API
Appendix 5: Validty enabled files in CFGRUL.
Appendix 6: Validty enabled files in CHMGMT.
Appendix 7: Validty enabled files in CONMGT.
-
CON_ADDRESS_TYPE_API
-
CON_DEDUCTION_TYPE_API
-
CONTRACT_CATEGORY1_API
-
CONTRACT_CATEGORY2_API
-
CONTRACT_COMPETITOR_API
-
CONTRACT_ITEM_TYPE_API
-
CONTRACT_REASON_API
-
CONTRACT_SUB_STATUS_API
-
CONTRACT_TYPE_API
-
SALES_CONTRACT_TASK_TYPE_API
Appendix 8: Validty enabled files in COST.
-
COST_ESTIMATOR_API
-
KAIZEN_COST_REDUCTION_TYPE_API
-
PART_COST_GROUP_API
Appendix 9: Validty enabled files in crm.
-
BUSINESS_CAMPAIGN_INTEREST_API
-
BUSINESS_LEAD_STAGE_API
-
BUSINESS_OPP_PROBABILITY_API
-
BUSINESS_OPPORTUN_SOURCE_API
-
BUSINESS_OPPORTUNITY_STAGE_API
-
BUSINESS_OPPORTUNITY_TYPE_API
-
CRM_RESPONSE_CATEGORY_API
-
CUSTOMER_EMPLOYEE_COUNT_API
-
CUSTOMER_LOYALTY_API
-
CUSTOMER_POTENTIAL_API
-
CUSTOMER_SOURCE_API
-
MARKETING_CAMPAIGN_TYPE_API
-
PERSONAL_INTEREST_API
Appendix 10: Validty enabled files in CROMFG.
-
CRO_EXCHANGE_CODE_API
-
CRO_LINE_HOLD_REASON_API
-
CRO_PACKAGE_CONDITION_API
Appendix 11: Validty enabled files in CUSSCH.
-
SCHEDULE_APPROVER_API
-
SCHEDULE_RECONCILER_API
Appendix 12: Validty enabled files in DISCOM.
Appendix 13: Validty enabled files in ESTMAN.
-
ESTIMATE_CLASSIFICATION_API
-
ESTIMATE_ITEM_TYPE_API
-
ESTIMATE_TYPE_API
Appendix 14: Validty enabled files in EXPCTR.
-
ACCESS_GROUP_API
-
CLASSIFICATION_SCHEME_API
-
END_USAGE_API
-
EXPLIC_AUTHORIZATION_API
-
EXPORT_CONTROL_CODE_API
-
EXPORT_LICENSE_TYPE_API
-
PRIMARY_CLASSIFICATION_API
Appendix 15: Validty enabled files in FMEA.
Appendix 16: Validty enabled files in GENLED.
-
REV_RECOG_FORECAST_TYPE_API
Appendix 17: Validty enabled files in GENRES.
Appendix 18: Validty enabled files in INVENT.
-
ACCOUNTING_GROUP_API
-
ADDITIONAL_SHIPPING_DESC_API
-
ASSET_CLASS_API
-
CLASSIFICATION_STANDARD_API
-
COMMODITY_GROUP_API
-
CUSTOMS_STATISTICS_NUMBER_API
-
HANDLING_UNIT_CATEGORY_API
-
INSPECTION_RULE_API
-
INTERNAL_CUSTOMER_API
-
INTERNAL_DESTINATION_API
-
INVENT_VALUE_COMPARAT_TYPE_API
-
INVENTORY_PART_PLANNER_API
-
INVENTORY_PRODUCT_CODE_API
-
INVENTORY_PRODUCT_FAMILY_API
-
PACKAGING_GROUP_API
-
PACKAGING_MATERIAL_API
-
PART_AVAILABILITY_CONTROL_API
-
PART_MOVE_ACKNOWLDG_REASON_API
-
PROPER_SHIPPING_NAME_API
-
SAFETY_INSTRUCTION_API
-
STORAGE_CAPABILITY_API
-
SUPPLY_CHAIN_PART_GROUP_API
-
TECHNICAL_COORDINATOR_API
-
TRANSPORT_HAZARD_CLASS_API
-
TRANSPORT_HAZARD_COMMENT_API
-
TRANSPORT_LIMITED_QUANTITY_API
-
TUNNEL_CODE_API
-
WAREHOUSE_TASK_PARK_REASON_API
Appendix 19: Validty enabled files in MFGSTD.
-
COMP_REPLACE_REASON_TYPE_API
-
COMPONENT_REPLACE_REASON_API
-
INDIRECT_JOB_API
-
MANUF_ENGINEER_API
-
SHOP_ORDER_PROCESS_TYPE_API
-
SPLIT_REASON_CODE_API
-
VALUE_ANALYSIS_FUNC_API
-
WORK_CENTER_DEPARTMENT_API
Appendix 20: Validty enabled files in MPCCOM.
-
MPCCOM_SHIP_VIA_API
-
ORDER_CANCEL_REASON_API
-
ORDER_COORDINATOR_API
-
ORDER_DELIVERY_TERM_API
-
SCRAPPING_CAUSE_API
Appendix 21: Validty enabled files in MROMFG.
-
DISCREPANCY_CODE_API
-
MRO_MODIFICATION_TYPE_API
-
REPAIR_CODE_API
Appendix 22: Validty enabled files in ORDER.
-
COMMISSION_RECEIVER_API
-
COMMISSION_RECEIVER_GROUP_API
-
COMPETITIVENESS_API
-
COMPETITOR_API
-
CUST_MILESTONE_TEMPL_API
-
CUSTOMER_GROUP_API
-
LOSE_WIN_REASON_API
-
REBATE_TYPE_API
-
RETURN_MATERIAL_REASON_API
-
SALES_CHARGE_GROUP_API
-
SALES_DISCOUNT_TYPE_API
-
SALES_DISTRICT_API
-
SALES_GROUP_API
-
SALES_MARKET_API
-
SALES_PART_REBATE_GROUP_API
-
SALES_PART_SALESMAN_API
-
SALES_PRICE_GROUP_API
-
SALES_REGION_API
-
SALES_REVISION_REASON_API
-
SELF_BILLING_DEV_REASON_API
Appendix 23: Validty enabled files in OSHA.
-
DAMAGE_TYPE_API
-
DANGEROUS_GOODS_TYPE_API
-
EXAMINATION_TEST_API
-
HAZARD_API
-
ILLNESS_TYPE_API
-
INCIDENT_AGENT_API
-
INCIDENT_CAUSE_ITEM_API
-
INCIDENT_CLASS_API
-
INCIDENT_TYPE_API
-
INJURED_PART_API
-
INJURY_TYPE_API
-
INVESTIGATION_ROLE_API
-
MEDICAL_CENTRE_API
-
ROUTE_ENTRY_API
-
SAFETY_INSPECTION_QUES_API
-
SEVERITY_LEVEL_API
Appendix 24: Validty enabled files in PARTCA.
-
ENG_PART_MAIN_GROUP_API
-
MAINT_LEVEL_API
Appendix 25: Validty enabled files in PAYLED.
-
BAD_DEBT_LEVELS_API
-
BANK_IDENTIFIER_CODE_API
-
CLEARING_SYSTEM_CODE_API
Appendix 26: Validty enabled files in PDMCON.
Appendix 27: Validty enabled files in PERSON.
-
COMPANY_EMP_CATEGORY_API
-
EMPLOYMENT_TYPE_API
-
FORMER_EMPLOYEE_GROUP_API
-
GRADE_API
-
ORGANIZATION_TERM_API
-
PERS_ASSIGNMENT_TYPE_API
Appendix 28: Validty enabled files in PROJ.
-
PROJ_PROGRESS_TEMPLATE_API
-
PROJECT_CATEGORY1_API
-
PROJECT_CATEGORY1_GLOBAL_API
-
PROJECT_CATEGORY2_API
-
PROJECT_CATEGORY2_GLOBAL_API
-
PROJECT_PROGRAM_API
-
PROJECT_PROGRAM_GLOBAL_API
Appendix 29: Validty enabled files in PROJBF.
-
PROJECT_FORECAST_TYPE_API
-
PROJECT_RESOURCE_FCST_TYPE_API
Appendix 30: Validty enabled files in PURCH.
-
DELIVERY_CONTROL_CODE_API
-
EXTERNAL_SERVICE_TYPE_API
-
ORDER_PROC_TYPE_API
-
PUR_AUTH_REJECT_REASON_API
-
PURCH_ADDITIONAL_COST_TYPE_API
-
PURCH_MILESTONE_TEMPL_API
-
PURCHASE_AUTHORIZER_API
-
PURCHASE_BUYER_API
-
PURCHASE_CHARGE_GROUP_API
-
PURCHASE_CODE_API
-
PURCHASE_PART_GROUP_API
-
PURCHASE_REQUISITIONER_API
-
SUPPLIER_ASSORTMENT_API
-
SUPPLIER_BLANKET_TYPE_API
-
SUPPLIER_GROUP_API
Appendix 31: Validty enabled files in QUAAUD.
-
AUD_AUDIT_AUTHORITY_API
-
AUD_AUDIT_AUTHORITY_TYPE_API
-
AUD_AUDIT_GROUP_API
-
AUD_AUDIT_TYPE_API
-
AUD_BUSINESS_AREA_API
Appendix 32: Validty enabled files in QUAMAN.
-
NORM_TYPE_API
-
QMAN_CANCELLATION_REASON_API
-
QMAN_CATEGORY_DATA_TYPE_API
-
QMAN_CATEGORY_VALUE_API
Appendix 33: Validty enabled files in QUANCR.
-
NCR_LOCATION_API
-
NCR_REFERENCE_STANDARD_API
-
NCR_ROOT_CAUSE_API
-
NCR_SEVERITY_API
-
NCR_SOURCE_API
Appendix 34: Validty enabled files in RCEIPT.
Appendix 35: Validty enabled files in RCRUIT.
-
EMP_AGENCY_API
-
STANDARD_ACTION_LIST_API
-
STANDARD_RCRUIT_ERRAND_API
-
STANDARD_SELECTION_PROCESS_API
Appendix 36: Validty enabled files in RENTAL.
-
RENTAL_TRANS_SCHEDULE_API
Appendix 37: Validty enabled files in RMCOM.
-
BUSINESS_ACTIVITY_PRIORITY_API
-
BUSINESS_ACTIVITY_TYPE_API
-
BUSINESS_REPRESENTATIVE_API
-
CONTACT_DEPARTMENT_API
-
DECISION_POWER_TYPE_API
-
OPPORTUNITY_ROLE_API
Appendix 38: Validty enabled files in SCENTR.
-
SUPPORT_BUSINESS_OBJECT_API
-
SUPPORT_ISSUE_CLASS_API
-
SUPPORT_ISSUE_PRIORITY_API
-
SUPPORT_ISSUE_STATUS_API
-
SUPPORT_ISSUE_TYPE_API
-
SUPPORT_SOLUTION_TYPE_API
Appendix 39: Validty enabled files in SHPORD.
-
DISPATCH_LIST_FILTER_API
-
OP_INTERRUPTION_CAUSE_API
-
ORDER_PARK_REASON_API
-
SHOP_FLOOR_TEAM_API
-
SHOP_ORDER_PRIORITY_API
Appendix 40: Validty enabled files in SRM.
-
SUPP_GEOGRAPHY_CODE_API
-
SUPPLIER_INFO1_API
-
SUPPLIER_RATING_API
-
SUPPLIER_SEGMENT_API
Appendix 41: Validty enabled files in SRVINV.
Appendix 42: Validty enabled files in STRACO.
-
COMPETENCY_API
-
COMPETENCY_COMPANY_API
-
COMPETENCY_GROUP_API
-
CONFIDENTIAL_LEVEL_API
-
EDUCATION_FIELD_API
-
EDUCATION_LEVEL_API
-
FUNCTIONAL_AREA_API
-
INDUSTRY_AREA_API
-
JOB_AUTHORITY_GROUP_API
-
JOB_FAMILY_API
-
JOB_GROUP_API
-
JOB_GROUP_CATEGORY_API
-
LICENSE_API
-
LICENSE_COMPANY_API
-
PHYSICAL_CHAR_API
-
PSYCHOLOGICAL_CHAR_API
-
QUALITATIVE_MEASUREMENT_API
-
URGENCY_LEVEL_API
-
WORK_CONDITION_FACTOR_API
Appendix 43: Validty enabled files in SUBCON.
-
SUB_CON_ADDRESS_TYPE_API
-
SUB_CON_CATEGORY1_API
-
SUB_CON_CATEGORY2_API
-
SUB_CON_DEDUCTION_TYPE_API
-
SUB_CON_ITEM_TYPE_API
-
SUB_CON_REASON_CODE_API
-
SUB_CON_SUB_STATUS_API
-
SUB_CON_TASK_TYPE_API
-
SUB_CON_TYPE_API
-
SUB_CON_WORK_INST_TYPE_API
Appendix 44: Validty enabled files in SUPSCH.
Appendix 45: Validty enabled files in TIMREP.
-
PLAN_REJECTION_REASON_API
-
REQUEST_REJECTION_REASON_API
Appendix 46: Validty enabled files in TRNADM.
-
COURSE_API
-
EVALUATION_QUESTION_API
-
EVALUATION_RATING_SCALE_API
-
EVALUATION_TEMPLATE_API
-
EXTERNAL_PARTICIPANT_API
-
TRAINER_API
-
TRAINING_INSTITUTION_API
Appendix 47: Validty enabled files in WRKSCH.
-
ABSENCE_CATEGORY_API
-
ILLNESS_API
-
SHIFT_INFO_API
-
WAGE_CLASS_API
-
WEEK_TYPE_API
This page is generated from IFS Developer Studio at 2025-03-23 11:16.