By using batch mode and COA setups with separator defined in system custom Web ADI been developed in EBS application and integrated with custom template using PO interface.
Pre- Requisites
Excel 2007 and above with macros enabled
EBS 12.1.3 and above
Migration Steps
***********************
WEBADI MIGRATION STEPS
***********************
————————————————————————————————-
Steps to follow:
————————————————————————————————-
1. Creation of staging table as per staging.sql in database
2. Creation of package spec and body and compile in database
3. Use FND_LOAD scripts to upload .ldt files as per attachment
3.1. Refer the below link for FND_LOAD upload commands
4. Use word document and follow the screen shots in EBS.
Staging.sql
CREATE TABLE APPS.XXDS_WEBADI_PO_STG
(
ORG_NAME VARCHAR2(240 BYTE),
PO_NUMBER VARCHAR2(20 BYTE),
PO_CREATION_DATE DATE,
DOCUMENT_TYPE VARCHAR2(100 BYTE),
VENDOR_NAME VARCHAR2(240 BYTE),
VENDOR_SITE_CODE VARCHAR2(20 BYTE),
SHIP_TO VARCHAR2(60 BYTE),
BILL_TO VARCHAR2(60 BYTE),
VENDOR_CONTACT_NAME VARCHAR2(240 BYTE),
AGENT_NAME VARCHAR2(240 BYTE),
APPROVAL_STATUS VARCHAR2(25 BYTE),
TOTAL NUMBER,
CURRENCY VARCHAR2(20 BYTE),
CONVERSION_TYPE VARCHAR2(30 BYTE),
CONVERSION_RATE NUMBER,
CONVERSION_DATE DATE,
TERMS VARCHAR2(50 BYTE),
FRIEGHT_TERMS VARCHAR2(25 BYTE),
CARRIER VARCHAR2(50 BYTE),
DESCRIPTION VARCHAR2(240 BYTE),
LINE_NUM NUMBER,
LINE_TYPE VARCHAR2(50 BYTE),
ITEM_CODE VARCHAR2(40 BYTE),
ITEM_CATEGORY VARCHAR2(240 BYTE),
ITEM_DESCRIPTION VARCHAR2(240 BYTE),
UOM_CODE VARCHAR2(50 BYTE),
UOM VARCHAR2(240 BYTE),
QUANTITY NUMBER,
PRICE NUMBER,
PROMISE_DATE DATE,
NEED_BY_DATE DATE,
SHIP_TO_ORG VARCHAR2(100 BYTE),
SEGMENT1 VARCHAR2(25 BYTE),
SEGMENT2 VARCHAR2(25 BYTE),
SEGMENT3 VARCHAR2(25 BYTE),
SEGMENT4 VARCHAR2(25 BYTE),
SEGMENT5 VARCHAR2(25 BYTE),
SEGMENT6 VARCHAR2(25 BYTE),
SEGMENT7 VARCHAR2(25 BYTE),
SEGMENT8 VARCHAR2(25 BYTE),
SEGMENT9 VARCHAR2(25 BYTE),
SEGMENT10 VARCHAR2(25 BYTE),
HDR_ATTRIBUTE1 VARCHAR2(150 BYTE),
HDR_ATTRIBUTE2 VARCHAR2(150 BYTE),
HDR_ATTRIBUTE3 VARCHAR2(150 BYTE),
HDR_ATTRIBUTE4 VARCHAR2(150 BYTE),
HDR_ATTRIBUTE5 VARCHAR2(150 BYTE),
HDR_ATTRIBUTE6 VARCHAR2(150 BYTE),
HDR_ATTRIBUTE7 VARCHAR2(150 BYTE),
HDR_ATTRIBUTE8 VARCHAR2(150 BYTE),
HDR_ATTRIBUTE9 VARCHAR2(150 BYTE),
HDR_ATTRIBUTE10 VARCHAR2(150 BYTE),
HDR_ATTRIBUTE11 VARCHAR2(150 BYTE),
HDR_ATTRIBUTE12 VARCHAR2(150 BYTE),
HDR_ATTRIBUTE13 VARCHAR2(150 BYTE),
HDR_ATTRIBUTE14 VARCHAR2(150 BYTE),
HDR_ATTRIBUTE15 VARCHAR2(150 BYTE),
LN_ATTRIBUTE1 VARCHAR2(150 BYTE),
LN_ATTRIBUTE2 VARCHAR2(150 BYTE),
LN_ATTRIBUTE3 VARCHAR2(150 BYTE),
LN_ATTRIBUTE4 VARCHAR2(150 BYTE),
LN_ATTRIBUTE5 VARCHAR2(150 BYTE),
LN_ATTRIBUTE6 VARCHAR2(150 BYTE),
LN_ATTRIBUTE7 VARCHAR2(150 BYTE),
LN_ATTRIBUTE8 VARCHAR2(150 BYTE),
LN_ATTRIBUTE9 VARCHAR2(150 BYTE),
LN_ATTRIBUTE10 VARCHAR2(150 BYTE),
LN_ATTRIBUTE11 VARCHAR2(150 BYTE),
LN_ATTRIBUTE12 VARCHAR2(150 BYTE),
LN_ATTRIBUTE13 VARCHAR2(150 BYTE),
LN_ATTRIBUTE14 VARCHAR2(150 BYTE),
LN_ATTRIBUTE15 VARCHAR2(150 BYTE),
DIST_ATTRIBUTE1 VARCHAR2(150 BYTE),
DIST_ATTRIBUTE2 VARCHAR2(150 BYTE),
DIST_ATTRIBUTE3 VARCHAR2(150 BYTE),
DIST_ATTRIBUTE4 VARCHAR2(150 BYTE),
DIST_ATTRIBUTE5 VARCHAR2(150 BYTE),
DIST_ATTRIBUTE6 VARCHAR2(150 BYTE),
DIST_ATTRIBUTE7 VARCHAR2(150 BYTE),
DIST_ATTRIBUTE8 VARCHAR2(150 BYTE),
DIST_ATTRIBUTE9 VARCHAR2(150 BYTE),
DIST_ATTRIBUTE10 VARCHAR2(150 BYTE),
DIST_ATTRIBUTE11 VARCHAR2(150 BYTE),
DIST_ATTRIBUTE12 VARCHAR2(150 BYTE),
DIST_ATTRIBUTE13 VARCHAR2(150 BYTE),
DIST_ATTRIBUTE14 VARCHAR2(150 BYTE),
DIST_ATTRIBUTE15 VARCHAR2(150 BYTE),
USER_ID NUMBER,
RESP_ID NUMBER,
APPL_ID NUMBER,
BATCH_ID NUMBER,
INST_STATUS VARCHAR2(50 BYTE),
ORG_ID NUMBER,
DOCUMENT_TYPE_CODE VARCHAR2(240 BYTE),
VENDOR_ID NUMBER,
VENDOR_SITE_ID NUMBER,
SHIPTO_ID NUMBER,
BILLTO_ID NUMBER,
BUYER_ID NUMBER,
TERMS_ID NUMBER,
LINE_TYPE_ID NUMBER,
CREATED_BY NUMBER,
CREATION_DATE DATE DEFAULT SYSDATE,
LAST_UPDATED_BY NUMBER,
LAST_UPDATE_DATE DATE DEFAULT SYSDATE,
LAST_UPDATE_LOGIN NUMBER,
SHIPMENT_NUM NUMBER DEFAULT 1,
DISTRIBUTION_NUM NUMBER DEFAULT 1,
TRX_MODE VARCHAR2(240 BYTE),
INT_REQUEST_ID NUMBER,
IMP_REQUEST_ID NUMBER,
BATCH_MODE VARCHAR2(50 BYTE),
REC_ID NUMBER,
STATUS VARCHAR2(240 BYTE) DEFAULT ‘N’,
ERROR_MSG VARCHAR2(4000 BYTE)
)
LDT Files
Content LDT
# $Header$
# dbdrv: exec fnd bin FNDLOAD bin &phase=daa+52 checkfile:~PROD:~PATH:~FILE &ui_apps 0 Y UPLOAD @BNE:patch/115/import/bnecont.lct @~PROD:~PATH/~FILE
LANGUAGE = “US”
LDRCONFIG = “bnecont.lct 120.0”
#Source Database EBSNEW
#RELEASE_NAME 12.1.3
# — Begin Entity Definitions —
DEFINE BNE_CONTENTS
KEY CONTENT_ASN VARCHAR2(120)
KEY CONTENT_CODE VARCHAR2(30)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
CTX OWNER VARCHAR2(120)
BASE INTEGRATOR_ASN VARCHAR2(120)
BASE INTEGRATOR_CODE VARCHAR2(30)
BASE PARAM_LIST_ASN VARCHAR2(120)
BASE PARAM_LIST_CODE VARCHAR2(30)
BASE CONTENT_CLASS VARCHAR2(240)
TRANS USER_NAME VARCHAR2(240)
BASE LAST_UPDATE_DATE VARCHAR2(10)
BASE ONCE_ONLY_DOWNLOAD_FLAG VARCHAR2(1)
DEFINE BNE_STORED_SQL
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE QUERY VARCHAR2(2000)
CTX OWNER VARCHAR2(120)
BASE LAST_UPDATE_DATE VARCHAR2(10)
END BNE_STORED_SQL
DEFINE BNE_CONTENT_COLS
KEY SEQUENCE_NUM VARCHAR2(50)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
CTX OWNER VARCHAR2(120)
BASE COL_NAME VARCHAR2(240)
TRANS USER_NAME VARCHAR2(240)
BASE LAST_UPDATE_DATE VARCHAR2(10)
END BNE_CONTENT_COLS
END BNE_CONTENTS
# — End Entity Definitions —
BEGIN BNE_CONTENTS “PO” “XXDS_PO_IFACE_WEDAI_CNT1”
OBJECT_VERSION_NUMBER = “1”
OWNER = “OPERATIONS”
INTEGRATOR_ASN = “PO”
INTEGRATOR_CODE = “XXDS_PO_IFACE_WEDAI_XINTG”
USER_NAME = “NONE”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_CONTENTS
Integrator LDT
# $Header$
# dbdrv: exec fnd bin FNDLOAD bin &phase=dat+52 checkfile:~PROD:~PATH:~FILE &ui_apps 0 Y UPLOAD @BNE:patch/115/import/bneintegrator.lct @~PROD:~PATH/~FILE
LANGUAGE = “US”
LDRCONFIG = “bneintegrator.lct 120.9.12010000.1”
#Source Database EBSNEW
#RELEASE_NAME 12.1.3
# — Begin Entity Definitions —
DEFINE BNE_INTEGRATORS
KEY INTEGRATOR_ASN VARCHAR2(120)
KEY INTEGRATOR_CODE VARCHAR2(30)
CTX OWNER VARCHAR2(120)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE ENABLED_FLAG VARCHAR2(1)
BASE UPL REFERENCES BNE_PARAM_LISTS
BASE UPL_SERV REFERENCES BNE_PARAM_LISTS
BASE IMPORT REFERENCES BNE_PARAM_LISTS
BASE DATE_FORMAT VARCHAR2(100)
BASE IMPORT_TYPE VARCHAR2(50)
BASE UPLOADER_CLASS VARCHAR2(240)
TRANS USER_NAME VARCHAR2(240)
TRANS UPLOAD_HEADER VARCHAR2(240)
TRANS UPLOAD_TITLE_BAR VARCHAR2(240)
BASE LAST_UPDATE_DATE VARCHAR2(10)
BASE CREATE_DOC REFERENCES BNE_PARAM_LISTS
BASE NEW_SESSION_FLAG VARCHAR2(1)
BASE LAYOUT_RESOLVER_CLASS VARCHAR2(240)
BASE LAYOUT_VERIFIER_CLASS VARCHAR2(240)
BASE SESSION_CONFIG_CLASS VARCHAR2(240)
BASE SESSION REFERENCES BNE_PARAM_LISTS
BASE SECURITY REFERENCES BNE_SECURED_OBJECTS
BASE DISPLAY_FLAG VARCHAR2(1)
DEFINE BNE_MENUS
KEY MENU_ASN VARCHAR2(120)
KEY MENU_CODE VARCHAR2(30)
CTX OWNER VARCHAR2(120)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE PARENT_MENU_ASN VARCHAR2(120)
BASE PARENT_MENU_CODE VARCHAR2(30)
BASE SEQUENCE_NUM VARCHAR2(50)
BASE RESOLVER_CLASS VARCHAR2(240)
BASE ACCESS_POINT VARCHAR2(240)
BASE PARAMS REFERENCES BNE_PARAM_LISTS
TRANS USER_NAME VARCHAR2(240)
BASE LAST_UPDATE_DATE VARCHAR2(10)
END BNE_MENUS
DEFINE BNE_MAPPINGS
KEY MAPPING_ASN VARCHAR2(120)
KEY MAPPING_CODE VARCHAR2(50)
BASE REPORTING_FLAG VARCHAR2(1)
BASE REPORTING_INTERFACE_ASN VARCHAR2(120)
BASE REPORTING_INTERFACE_CODE VARCHAR2(30)
TRANS USER_NAME VARCHAR2(240)
CTX OWNER VARCHAR2(120)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE LAST_UPDATE_DATE VARCHAR2(10)
DEFINE BNE_MAPPING_LINES
KEY SEQUENCE_NUM VARCHAR2(50)
BASE INTERFACE_ASN VARCHAR2(120)
BASE INTERFACE_CODE VARCHAR2(30)
BASE INTERFACE_SEQ_NUM VARCHAR2(50)
CTX OWNER VARCHAR2(120)
BASE DECODE_FLAG VARCHAR2(1)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE CONTENT_ASN VARCHAR2(120)
BASE CONTENT_CODE VARCHAR2(30)
BASE CONTENT_SEQ_NUM VARCHAR2(50)
BASE LAST_UPDATE_DATE VARCHAR2(10)
END BNE_MAPPING_LINES
END BNE_MAPPINGS
DEFINE BNE_CONTENTS
KEY CONTENT_ASN VARCHAR2(120)
KEY CONTENT_CODE VARCHAR2(30)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
CTX OWNER VARCHAR2(120)
BASE CONTENT REFERENCES BNE_PARAM_LISTS
BASE CONTENT_CLASS VARCHAR2(240)
TRANS USER_NAME VARCHAR2(240)
BASE LAST_UPDATE_DATE VARCHAR2(10)
BASE ONCE_ONLY_DOWNLOAD_FLAG VARCHAR2(1)
DEFINE BNE_STORED_SQL
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE QUERY VARCHAR2(2000)
BASE BNE_QUERY REFERENCES BNE_QUERIES
CTX OWNER VARCHAR2(120)
BASE LAST_UPDATE_DATE VARCHAR2(10)
END BNE_STORED_SQL
DEFINE BNE_CONTENT_COLS
KEY SEQUENCE_NUM VARCHAR2(50)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
CTX OWNER VARCHAR2(120)
BASE COL_NAME VARCHAR2(240)
TRANS USER_NAME VARCHAR2(240)
BASE LAST_UPDATE_DATE VARCHAR2(10)
BASE READ_ONLY_FLAG VARCHAR2(1)
END BNE_CONTENT_COLS
END BNE_CONTENTS
DEFINE BNE_LAYOUTS
KEY LAYOUT_ASN VARCHAR2(120)
KEY LAYOUT_CODE VARCHAR2(30)
CTX OWNER VARCHAR2(120)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE STYLESHEET_ASN VARCHAR2(120)
BASE STYLESHEET_CODE VARCHAR2(30)
BASE STYLE VARCHAR2(2000)
BASE STYLE_CLASS VARCHAR2(50)
BASE REPORTING_FLAG VARCHAR2(1)
BASE REPORTING_INTERFACE_ASN VARCHAR2(120)
BASE REPORT_INTERFACE_CODE VARCHAR2(30)
TRANS USER_NAME VARCHAR2(240)
BASE LAST_UPDATE_DATE VARCHAR2(10)
BASE CREATE_DOC REFERENCES BNE_PARAM_LISTS
DEFINE BNE_LAYOUT_BLOCKS
KEY BLOCK_ID VARCHAR2(50)
CTX OWNER VARCHAR2(120)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE PARENT_ID VARCHAR2(50)
BASE LAYOUT_ELEMENT VARCHAR2(240)
BASE STYLE_CLASS VARCHAR2(50)
BASE STYLE VARCHAR2(2000)
BASE ROW_STYLE_CLASS VARCHAR2(50)
BASE ROW_STYLE VARCHAR2(2000)
BASE COL_STYLE_CLASS VARCHAR2(50)
BASE COL_STYLE VARCHAR2(2000)
BASE PROMPT_DISPLAYED_FLAG VARCHAR2(1)
BASE PROMPT_STYLE_CLASS VARCHAR2(50)
BASE PROMPT_STYLE VARCHAR2(2000)
BASE HINT_DISPLAYED_FLAG VARCHAR2(1)
BASE HINT_STYLE_CLASS VARCHAR2(50)
BASE HINT_STYLE VARCHAR2(2000)
BASE ORIENTATION VARCHAR2(20)
BASE LAYOUT_CONTROL VARCHAR2(20)
BASE DISPLAY_FLAG VARCHAR2(1)
BASE BLOCKSIZE VARCHAR2(50)
BASE MINSIZE VARCHAR2(50)
BASE MAXSIZE VARCHAR2(50)
BASE SEQUENCE_NUM VARCHAR2(50)
BASE PROMPT_COLSPAN VARCHAR2(50)
BASE HINT_COLSPAN VARCHAR2(50)
BASE ROW_COLSPAN VARCHAR2(50)
BASE SUMMARY_STYLE_CLASS VARCHAR2(50)
BASE SUMMARY_STYLE VARCHAR2(2000)
TRANS USER_NAME VARCHAR2(240)
BASE LAST_UPDATE_DATE VARCHAR2(10)
BASE TITLE_STYLE_CLASS VARCHAR2(50)
BASE TITLE_STYLE VARCHAR2(2000)
BASE PROMPT_ABOVE VARCHAR2(240)
DEFINE BNE_LAYOUT_COLS
KEY SEQUENCE_NUM VARCHAR2(50)
CTX OWNER VARCHAR2(120)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE INTERFACE_ASN VARCHAR2(120)
BASE INTERFACE_CODE VARCHAR2(30)
BASE INTERFACE_SEQ_NUM VARCHAR2(50)
BASE STYLE_CLASS VARCHAR2(50)
BASE STYLE VARCHAR2(2000)
BASE PROMPT_STYLE_CLASS VARCHAR2(50)
BASE PROMPT_STYLE VARCHAR2(2000)
BASE HINT_STYLE_CLASS VARCHAR2(50)
BASE HINT_STYLE VARCHAR2(2000)
BASE DEFAULT_VALUE VARCHAR2(2000)
BASE DEFAULT_TYPE VARCHAR2(30)
BASE DISPLAY_WIDTH VARCHAR2(50)
BASE LAST_UPDATE_DATE VARCHAR2(10)
BASE READ_ONLY_FLAG VARCHAR2(1)
END BNE_LAYOUT_COLS
END BNE_LAYOUT_BLOCKS
END BNE_LAYOUTS
DEFINE BNE_DUPLICATE_PROFILES
KEY DUP_PROFILE_ASN VARCHAR2(120)
KEY DUP_PROFILE_CODE VARCHAR2(30)
CTX OWNER VARCHAR2(120)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
TRANS USER_NAME VARCHAR2(240)
BASE LAST_UPDATE_DATE VARCHAR2(10)
DEFINE BNE_DUP_INTERFACE_PROFILES
KEY INTERFACE_ASN VARCHAR2(120)
KEY INTERFACE_CODE VARCHAR2(30)
CTX OWNER VARCHAR2(120)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE DUP_HANDLING_CODE VARCHAR2(30)
BASE DEFAULT_RESOLVER_CLASSNAME VARCHAR2(240)
BASE LAST_UPDATE_DATE VARCHAR2(10)
DEFINE BNE_DUP_INTERFACE_COLS
KEY INTERFACE_SEQ_NUM VARCHAR2(50)
CTX OWNER VARCHAR2(120)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE RESOLVER_CLASSNAME VARCHAR2(240)
BASE LAST_UPDATE_DATE VARCHAR2(10)
END BNE_DUP_INTERFACE_COLS
END BNE_DUP_INTERFACE_PROFILES
END BNE_DUPLICATE_PROFILES
DEFINE BNE_IMPORT_PROGRAMS
KEY SEQUENCE_NUM VARCHAR2(50)
CTX OWNER VARCHAR2(120)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE PARENT_SEQ_NUM VARCHAR2(50)
BASE IMPORT_TYPE VARCHAR2(50)
BASE IMPORT REFERENCES BNE_PARAM_LISTS
BASE LAST_UPDATE_DATE VARCHAR2(10)
DEFINE BNE_IMPORT_PROGRAMS_LISTS
KEY IMPORT_PARAM_LIST_ASN VARCHAR2(120)
KEY IMPORT_PARAM_LIST_CODE VARCHAR2(30)
END BNE_IMPORT_PROGRAMS_LISTS
END BNE_IMPORT_PROGRAMS
DEFINE BNE_INTERFACES
KEY INTERFACE_ASN VARCHAR2(120)
KEY INTERFACE_CODE VARCHAR2(30)
CTX OWNER VARCHAR2(120)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE INTERFACE_NAME VARCHAR2(50)
BASE UPLOAD_TYPE VARCHAR2(50)
BASE UPLOAD_OBJ_NAME VARCHAR2(240)
BASE UPLOAD_PARAMS REFERENCES BNE_PARAM_LISTS
BASE UPLOAD_ORDER VARCHAR2(50)
TRANS USER_NAME VARCHAR2(240)
BASE LAST_UPDATE_DATE VARCHAR2(10)
DEFINE BNE_INTERFACE_COLS
KEY SEQUENCE_NUM VARCHAR2(50)
CTX OWNER VARCHAR2(120)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE INTERFACE_COL_TYPE VARCHAR2(50)
BASE INTERFACE_COL_NAME VARCHAR2(50)
BASE ENABLED_FLAG VARCHAR2(1)
BASE REQUIRED_FLAG VARCHAR2(1)
BASE DISPLAY_FLAG VARCHAR2(1)
BASE READ_ONLY_FLAG VARCHAR2(1)
BASE NOT_NULL_FLAG VARCHAR2(1)
BASE SUMMARY_FLAG VARCHAR2(1)
BASE MAPPING_ENABLED_FLAG VARCHAR2(1)
BASE DATA_TYPE VARCHAR2(50)
BASE FIELD_SIZE VARCHAR2(50)
BASE DEFAULT_TYPE VARCHAR2(30)
BASE DEFAULT_VALUE VARCHAR2(200)
BASE SEGMENT_NUMBER VARCHAR2(50)
BASE GROUP_NAME VARCHAR2(30)
BASE OA_FLEX_CODE VARCHAR2(30)
BASE OA_CONCAT_FLEX VARCHAR2(30)
BASE VAL_TYPE VARCHAR2(20)
BASE VAL_ID_COL VARCHAR2(240)
BASE VAL_MEAN_COL VARCHAR2(240)
BASE VAL_DESC_COL VARCHAR2(240)
BASE VAL_OBJ_NAME VARCHAR2(240)
BASE VAL_ADDL_W_C VARCHAR2(2000)
BASE VAL_COMPONENT REFERENCES BNE_COMPONENTS
BASE OA_FLEX_NUM VARCHAR2(50)
BASE OA_FLEX_APPLICATION_ID VARCHAR2(50)
BASE DISPLAY_ORDER VARCHAR2(50)
BASE UPLOAD_PARAM_LIST_ITEM_NUM VARCHAR2(50)
BASE EXPANDED_SQL_QUERY VARCHAR2(2000)
TRANS USER_HINT VARCHAR2(2000)
TRANS PROMPT_LEFT VARCHAR2(240)
TRANS PROMPT_ABOVE VARCHAR2(240)
TRANS USER_HELP_TEXT VARCHAR2(2000)
BASE LAST_UPDATE_DATE VARCHAR2(10)
BASE LOV_TYPE VARCHAR2(30)
BASE OFFLINE_LOV_ENABLED_FLAG VARCHAR2(1)
BASE VARIABLE_DATA_TYPE_CLASS VARCHAR2(240)
BASE VIEWER_GROUP VARCHAR2(30)
BASE EDIT_TYPE VARCHAR2(30)
BASE DISPLAY_WIDTH VARCHAR2(50)
BASE VAL_QUERY REFERENCES BNE_QUERIES
BASE EXPANDED_SQL REFERENCES BNE_QUERIES
END BNE_INTERFACE_COLS
DEFINE BNE_INTERFACE_KEYS
KEY KEY_ASN VARCHAR2(120)
KEY KEY_CODE VARCHAR2(30)
CTX OWNER VARCHAR2(120)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE KEY_TYPE VARCHAR2(30)
BASE KEY_CLASS VARCHAR2(240)
BASE LAST_UPDATE_DATE VARCHAR2(10)
DEFINE BNE_INTERFACE_KEY_COLS
KEY SEQUENCE_NUM VARCHAR2(50)
CTX OWNER VARCHAR2(120)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE INTERFACE_ASN VARCHAR2(120)
BASE INTERFACE_CODE VARCHAR2(30)
BASE INTERFACE_SEQ_NUM VARCHAR2(50)
BASE LAST_UPDATE_DATE VARCHAR2(10)
END BNE_INTERFACE_KEY_COLS
END BNE_INTERFACE_KEYS
END BNE_INTERFACES
DEFINE BNE_INTEGRATOR_VIEWERS
KEY VIEWER_ASN VARCHAR2(120)
KEY VIEWER_CODE VARCHAR2(30)
CTX OWNER VARCHAR2(120)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE LAST_UPDATE_DATE VARCHAR2(10)
END BNE_INTEGRATOR_VIEWERS
DEFINE BNE_GRAPHS
KEY GRAPH_SEQ_NUM VARCHAR2(50)
CTX OWNER VARCHAR2(120)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE LAYOUT_ASN VARCHAR2(120)
BASE LAYOUT_CODE VARCHAR2(30)
BASE GRAPH_DIMENSION_CODE VARCHAR2(30)
BASE GRAPH_TYPE_CODE VARCHAR2(30)
BASE AUTO_GRAPH_FLAG VARCHAR2(1)
TRANS CHART_TITLE VARCHAR2(240)
TRANS X_AXIS_LABEL VARCHAR2(240)
TRANS Y_AXIS_LABEL VARCHAR2(240)
TRANS Z_AXIS_LABEL VARCHAR2(2000)
BASE LAST_UPDATE_DATE VARCHAR2(10)
DEFINE BNE_GRAPH_COLUMNS
KEY GRAPH_COL_SEQ_NUM VARCHAR2(50)
CTX OWNER VARCHAR2(120)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE INTERFACE_ASN VARCHAR2(120)
BASE INTERFACE_CODE VARCHAR2(30)
BASE INTERFACE_SEQ_NUM VARCHAR2(50)
BASE LOCATION_CODE VARCHAR2(30)
BASE LAST_UPDATE_DATE VARCHAR2(10)
END BNE_GRAPH_COLUMNS
END BNE_GRAPHS
DEFINE BNE_INTEGRATOR_MENU_LISTS
KEY MENU_PARAM_LIST_ASN VARCHAR2(120)
KEY MENU_PARAM_LIST_CODE VARCHAR2(30)
END BNE_INTEGRATOR_MENU_LISTS
DEFINE BNE_INTEGRATOR_IMPORT_LISTS
KEY IMPORT_PARAM_LIST_ASN VARCHAR2(120)
KEY IMPORT_PARAM_LIST_CODE VARCHAR2(30)
END BNE_INTEGRATOR_IMPORT_LISTS
END BNE_INTEGRATORS
DEFINE BNE_SECURED_OBJECTS
KEY SECURED_OBJECT_ASN VARCHAR2(120)
KEY SECURED_OBJECT_CODE VARCHAR2(30)
KEY SECURED_OBJECT_TYPE VARCHAR2(30)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE RULE REFERENCES BNE_SECURITY_RULES
CTX OWNER VARCHAR2(120)
BASE LAST_UPDATE_DATE VARCHAR2(10)
END BNE_SECURED_OBJECTS
DEFINE BNE_QUERIES
KEY QUERY_ASN VARCHAR2(120)
KEY QUERY_CODE VARCHAR2(30)
CTX OWNER VARCHAR2(120)
BASE LAST_UPDATE_DATE VARCHAR2(10)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE QUERY_CLASS VARCHAR2(240)
TRANS USER_NAME VARCHAR2(240)
BASE CACHE REFERENCES BNE_CACHE_DIRECTIVES
DEFINE BNE_RAW_QUERY
KEY SEQUENCE_NUM VARCHAR2(50)
CTX OWNER VARCHAR2(120)
BASE LAST_UPDATE_DATE VARCHAR2(10)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE QUERY VARCHAR2(2000)
END BNE_RAW_QUERY
DEFINE BNE_SIMPLE_QUERY
CTX OWNER VARCHAR2(120)
BASE LAST_UPDATE_DATE VARCHAR2(10)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE ID_COL VARCHAR2(2000)
BASE ID_COL_ALIAS VARCHAR2(2000)
BASE MEANING_COL VARCHAR2(2000)
BASE MEANING_COL_ALIAS VARCHAR2(2000)
BASE DESCRIPTION_COL VARCHAR2(2000)
BASE DESCRIPTION_COL_ALIAS VARCHAR2(2000)
BASE ADDITIONAL_COLS VARCHAR2(2000)
BASE OBJECT_NAME VARCHAR2(2000)
BASE ADDITIONAL_WHERE_CLAUSE VARCHAR2(2000)
BASE ORDER_BY_CLAUSE VARCHAR2(2000)
END BNE_SIMPLE_QUERY
END BNE_QUERIES
DEFINE BNE_PARAM_LISTS
KEY PARAM_LIST_ASN VARCHAR2(120)
KEY PARAM_LIST_CODE VARCHAR2(30)
CTX OWNER VARCHAR2(120)
BASE LAST_UPDATE_DATE VARCHAR2(10)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE PERSISTENT_FLAG VARCHAR2(1)
BASE COMMENTS VARCHAR2(240)
BASE LIST REFERENCES BNE_ATTRIBUTES
BASE LIST_RESOLVER VARCHAR2(240)
TRANS USER_TIP VARCHAR2(2000)
TRANS PROMPT_LEFT VARCHAR2(240)
TRANS PROMPT_ABOVE VARCHAR2(240)
TRANS USER_NAME VARCHAR2(240)
DEFINE BNE_PARAM_GROUPS
KEY GROUP_SEQ_NUM VARCHAR2(50)
CTX OWNER VARCHAR2(120)
BASE LAST_UPDATE_DATE VARCHAR2(10)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE GROUP_ITEM REFERENCES BNE_ATTRIBUTES
BASE GROUP_RESOLVER VARCHAR2(240)
TRANS USER_NAME VARCHAR2(240)
DEFINE BNE_PARAM_GROUP_ITEMS
KEY SEQUENCE_NUM VARCHAR2(50)
CTX OWNER VARCHAR2(120)
BASE LAST_UPDATE_DATE VARCHAR2(10)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE PARAM_SEQ_NUM VARCHAR2(50)
END BNE_PARAM_GROUP_ITEMS
END BNE_PARAM_GROUPS
DEFINE BNE_PARAM_LIST_ITEMS
KEY SEQUENCE_NUM VARCHAR2(50)
CTX OWNER VARCHAR2(120)
BASE LAST_UPDATE_DATE VARCHAR2(10)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE DEFN REFERENCES BNE_PARAM_DEFNS
BASE PARAM_NAME VARCHAR2(240)
BASE LIST_ITEM REFERENCES BNE_ATTRIBUTES
BASE STRING_VALUE VARCHAR2(2000)
BASE DATE_VALUE VARCHAR2(19)
BASE NUMBER_VALUE VARCHAR2(50)
BASE BOOLEAN_VALUE_FLAG VARCHAR2(1)
BASE FORMULA_VALUE VARCHAR2(240)
BASE DESC_VALUE VARCHAR2(240)
END BNE_PARAM_LIST_ITEMS
END BNE_PARAM_LISTS
DEFINE BNE_COMPONENTS
KEY COMPONENT_ASN VARCHAR2(120)
KEY COMPONENT_CODE VARCHAR2(30)
CTX OWNER VARCHAR2(120)
BASE LAST_UPDATE_DATE VARCHAR2(10)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE COMPONENT_JAVA_CLASS VARCHAR2(240)
BASE PARAM REFERENCES BNE_PARAM_LISTS
TRANS USER_NAME VARCHAR2(240)
END BNE_COMPONENTS
DEFINE BNE_SECURITY_RULES
KEY SECURITY_RULE_ASN VARCHAR2(120)
KEY SECURITY_RULE_CODE VARCHAR2(30)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE SECURITY_TYPE VARCHAR2(30)
BASE SECURITY_VALUE VARCHAR2(2000)
CTX OWNER VARCHAR2(120)
BASE LAST_UPDATE_DATE VARCHAR2(10)
END BNE_SECURITY_RULES
DEFINE BNE_CACHE_DIRECTIVES
KEY DIRECTIVE_ASN VARCHAR2(120)
KEY DIRECTIVE_CODE VARCHAR2(30)
CTX OWNER VARCHAR2(120)
BASE LAST_UPDATE_DATE VARCHAR2(10)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE MAX_SIZE VARCHAR2(50)
BASE MAX_HITS VARCHAR2(50)
BASE MAX_AGE VARCHAR2(240)
BASE DISCRIMINATOR_TYPE VARCHAR2(30)
BASE DISCRIMINATOR_VALUE VARCHAR2(2000)
TRANS USER_NAME VARCHAR2(240)
END BNE_CACHE_DIRECTIVES
DEFINE BNE_ATTRIBUTES
KEY ATTRIBUTE_ASN VARCHAR2(120)
KEY ATTRIBUTE_CODE VARCHAR2(30)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE ATTRIBUTE1 VARCHAR2(2000)
BASE ATTRIBUTE2 VARCHAR2(2000)
BASE ATTRIBUTE3 VARCHAR2(2000)
BASE ATTRIBUTE4 VARCHAR2(2000)
BASE ATTRIBUTE5 VARCHAR2(2000)
BASE ATTRIBUTE6 VARCHAR2(2000)
BASE ATTRIBUTE7 VARCHAR2(2000)
BASE ATTRIBUTE8 VARCHAR2(2000)
BASE ATTRIBUTE9 VARCHAR2(2000)
BASE ATTRIBUTE10 VARCHAR2(2000)
BASE ATTRIBUTE11 VARCHAR2(2000)
BASE ATTRIBUTE12 VARCHAR2(2000)
BASE ATTRIBUTE13 VARCHAR2(2000)
BASE ATTRIBUTE14 VARCHAR2(2000)
BASE ATTRIBUTE15 VARCHAR2(2000)
BASE ATTRIBUTE16 VARCHAR2(2000)
BASE ATTRIBUTE17 VARCHAR2(2000)
BASE ATTRIBUTE18 VARCHAR2(2000)
BASE ATTRIBUTE19 VARCHAR2(2000)
BASE ATTRIBUTE20 VARCHAR2(2000)
BASE ATTRIBUTE21 VARCHAR2(2000)
BASE ATTRIBUTE22 VARCHAR2(2000)
BASE ATTRIBUTE23 VARCHAR2(2000)
BASE ATTRIBUTE24 VARCHAR2(2000)
BASE ATTRIBUTE25 VARCHAR2(2000)
BASE ATTRIBUTE26 VARCHAR2(2000)
BASE ATTRIBUTE27 VARCHAR2(2000)
BASE ATTRIBUTE28 VARCHAR2(2000)
BASE ATTRIBUTE29 VARCHAR2(2000)
BASE ATTRIBUTE30 VARCHAR2(2000)
CTX OWNER VARCHAR2(120)
BASE LAST_UPDATE_DATE VARCHAR2(10)
BASE ATTRIBUTE_NAME1 VARCHAR2(30)
BASE ATTRIBUTE_NAME2 VARCHAR2(30)
BASE ATTRIBUTE_NAME3 VARCHAR2(30)
BASE ATTRIBUTE_NAME4 VARCHAR2(30)
BASE ATTRIBUTE_NAME5 VARCHAR2(30)
BASE ATTRIBUTE_NAME6 VARCHAR2(30)
BASE ATTRIBUTE_NAME7 VARCHAR2(30)
BASE ATTRIBUTE_NAME8 VARCHAR2(30)
BASE ATTRIBUTE_NAME9 VARCHAR2(30)
BASE ATTRIBUTE_NAME10 VARCHAR2(30)
BASE ATTRIBUTE_NAME11 VARCHAR2(30)
BASE ATTRIBUTE_NAME12 VARCHAR2(30)
BASE ATTRIBUTE_NAME13 VARCHAR2(30)
BASE ATTRIBUTE_NAME14 VARCHAR2(30)
BASE ATTRIBUTE_NAME15 VARCHAR2(30)
BASE ATTRIBUTE_NAME16 VARCHAR2(30)
BASE ATTRIBUTE_NAME17 VARCHAR2(30)
BASE ATTRIBUTE_NAME18 VARCHAR2(30)
BASE ATTRIBUTE_NAME19 VARCHAR2(30)
BASE ATTRIBUTE_NAME20 VARCHAR2(30)
BASE ATTRIBUTE_NAME21 VARCHAR2(30)
BASE ATTRIBUTE_NAME22 VARCHAR2(30)
BASE ATTRIBUTE_NAME23 VARCHAR2(30)
BASE ATTRIBUTE_NAME24 VARCHAR2(30)
BASE ATTRIBUTE_NAME25 VARCHAR2(30)
BASE ATTRIBUTE_NAME26 VARCHAR2(30)
BASE ATTRIBUTE_NAME27 VARCHAR2(30)
BASE ATTRIBUTE_NAME28 VARCHAR2(30)
BASE ATTRIBUTE_NAME29 VARCHAR2(30)
BASE ATTRIBUTE_NAME30 VARCHAR2(30)
END BNE_ATTRIBUTES
DEFINE BNE_PARAM_DEFNS
KEY PARAM_DEFN_ASN VARCHAR2(120)
KEY PARAM_DEFN_CODE VARCHAR2(30)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE PARAM_NAME VARCHAR2(240)
BASE PARAM_SOURCE VARCHAR2(240)
BASE PARAM_CATEGORY VARCHAR2(50)
BASE DATATYPE VARCHAR2(50)
BASE DEFN REFERENCES BNE_ATTRIBUTES
BASE PARAM_RESOLVER VARCHAR2(240)
BASE DEFAULT_REQUIRED_FLAG VARCHAR2(1)
BASE DEFAULT_VISIBLE_FLAG VARCHAR2(1)
BASE DEFAULT_USER_MODIFYABLE_FLAG VARCHAR2(1)
BASE DEFAULT_STRING VARCHAR2(2000)
TRANS DEFAULT_STRING_TRANS VARCHAR2(2000)
BASE DEFAULT_STRING_TRANS_FLAG VARCHAR2(1)
BASE DEFAULT_DATE VARCHAR2(19)
BASE DEFAULT_NUMBER VARCHAR2(50)
BASE DEFAULT_BOOLEAN_FLAG VARCHAR2(1)
BASE DEFAULT_FORMULA VARCHAR2(240)
BASE VAL_TYPE VARCHAR2(30)
BASE VAL_VALUE VARCHAR2(30)
BASE VAL_BNE_QUERY REFERENCES BNE_QUERIES
BASE MAX_SIZE VARCHAR2(50)
BASE DISPLAY_TYPE VARCHAR2(50)
BASE DISPLAY_STYLE VARCHAR2(50)
BASE DISPLAY_SIZE VARCHAR2(50)
BASE HELP_URL VARCHAR2(240)
BASE FORMAT_MASK VARCHAR2(240)
TRANS USER_NAME VARCHAR2(240)
TRANS DEFAULT_DESC VARCHAR2(240)
TRANS PROMPT_LEFT VARCHAR2(240)
TRANS PROMPT_ABOVE VARCHAR2(240)
TRANS USER_TIP VARCHAR2(2000)
TRANS ACCESS_KEY VARCHAR2(30)
CTX OWNER VARCHAR2(120)
BASE LAST_UPDATE_DATE VARCHAR2(10)
BASE OA_FLEX_ASN VARCHAR2(120)
BASE OA_FLEX_CODE VARCHAR2(30)
BASE OA_FLEX_NUM VARCHAR2(2000)
DEFINE BNE_PARAM_DEFN_OVERRIDES
KEY LVL VARCHAR2(50)
KEY OVERRIDE_ID VARCHAR2(50)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE REQUIRED_FLAG VARCHAR2(1)
BASE VISIBLE_FLAG VARCHAR2(1)
BASE USER_MODIFYABLE_FLAG VARCHAR2(1)
BASE DEFAULT_STRING VARCHAR2(2000)
BASE DEFAULT_DATE VARCHAR2(19)
BASE DEFAULT_NUMBER VARCHAR2(50)
BASE DEFAULT_BOOLEAN_FLAG VARCHAR2(1)
BASE DEFAULT_FORMULA VARCHAR2(240)
BASE DESC_VALUE VARCHAR2(240)
CTX OWNER VARCHAR2(120)
BASE LAST_UPDATE_DATE VARCHAR2(10)
END BNE_PARAM_DEFN_OVERRIDES
END BNE_PARAM_DEFNS
# — End Entity Definitions —
BEGIN BNE_PARAM_DEFNS “BNE” “UPL_PARAM_500203”
OBJECT_VERSION_NUMBER = “1”
PARAM_NAME = “bne:rows”
PARAM_SOURCE = “DIF:Upload”
PARAM_CATEGORY = “1”
DATATYPE = “1”
DEFN = “” “”
DEFAULT_REQUIRED_FLAG = “N”
DEFAULT_VISIBLE_FLAG = “Y”
DEFAULT_USER_MODIFYABLE_FLAG = “Y”
DEFAULT_STRING_TRANS = “Y”
DEFAULT_STRING_TRANS_FLAG = “Y”
VAL_TYPE = “3”
VAL_VALUE = “BNE_ROWS”
VAL_BNE_QUERY = “” “”
MAX_SIZE = “100”
DISPLAY_TYPE = “2”
DISPLAY_STYLE = “2”
DISPLAY_SIZE = “100”
USER_NAME = “bne:rows”
DEFAULT_DESC = “Flegged Rows”
PROMPT_LEFT = “Rows to Upload”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_PARAM_DEFNS
BEGIN BNE_PARAM_DEFNS “BNE” “UPL_PARAM_500204”
OBJECT_VERSION_NUMBER = “1”
PARAM_NAME = “bne:validation”
PARAM_SOURCE = “DIF:Upload”
PARAM_CATEGORY = “1”
DATATYPE = “4”
DEFN = “” “”
DEFAULT_REQUIRED_FLAG = “N”
DEFAULT_VISIBLE_FLAG = “Y”
DEFAULT_USER_MODIFYABLE_FLAG = “Y”
DEFAULT_STRING_TRANS_FLAG = “N”
DEFAULT_BOOLEAN_FLAG = “Y”
VAL_TYPE = “1”
VAL_BNE_QUERY = “” “”
MAX_SIZE = “100”
DISPLAY_TYPE = “1”
DISPLAY_STYLE = “1”
DISPLAY_SIZE = “100”
USER_NAME = “bne:validation”
DEFAULT_DESC =
“Choose the type of validation to be used during the upload process”
PROMPT_LEFT = “Validate Before Upload”
PROMPT_ABOVE = “Validate Before Upload”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_PARAM_DEFNS
BEGIN BNE_PARAM_DEFNS “BNE” “UPL_PARAM_500205”
OBJECT_VERSION_NUMBER = “1”
PARAM_NAME = “bne:import”
PARAM_SOURCE = “DIF:Upload”
PARAM_CATEGORY = “1”
DATATYPE = “4”
DEFN = “” “”
DEFAULT_REQUIRED_FLAG = “N”
DEFAULT_VISIBLE_FLAG = “Y”
DEFAULT_USER_MODIFYABLE_FLAG = “Y”
DEFAULT_STRING_TRANS_FLAG = “N”
VAL_TYPE = “1”
VAL_BNE_QUERY = “” “”
MAX_SIZE = “100”
DISPLAY_TYPE = “1”
DISPLAY_STYLE = “1”
DISPLAY_SIZE = “100”
USER_NAME = “bne:import”
PROMPT_LEFT = “Automatically Submit Import”
USER_TIP =
“Import will be automatically submitted on successful completion of the upload”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_PARAM_DEFNS
BEGIN BNE_PARAM_DEFNS “PO” “UPL_PARAM_500238”
OBJECT_VERSION_NUMBER = “3”
PARAM_NAME = “bne:commitrows”
PARAM_SOURCE = “DIF:Upload”
PARAM_CATEGORY = “6”
DATATYPE = “1”
DEFN = “” “”
DEFAULT_REQUIRED_FLAG = “N”
DEFAULT_VISIBLE_FLAG = “Y”
DEFAULT_USER_MODIFYABLE_FLAG = “Y”
DEFAULT_STRING_TRANS_FLAG = “N”
VAL_TYPE = “3”
VAL_VALUE = “BNE_COMMITROWS”
VAL_BNE_QUERY = “” “”
MAX_SIZE = “100”
DISPLAY_TYPE = “2”
DISPLAY_STYLE = “2”
DISPLAY_SIZE = “100”
USER_NAME = “bne:commitrows”
PROMPT_LEFT = “bne:commitrows”
PROMPT_ABOVE = “bne:commitrows”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/01”
END BNE_PARAM_DEFNS
BEGIN BNE_PARAM_DEFNS “PO” “UPL_PARAM_500223”
OBJECT_VERSION_NUMBER = “3”
PARAM_NAME = “P_BUYER_ID”
PARAM_SOURCE = “DIF:Upload”
PARAM_CATEGORY = “6”
DATATYPE = “1”
DEFN = “” “”
DEFAULT_REQUIRED_FLAG = “N”
DEFAULT_VISIBLE_FLAG = “N”
DEFAULT_USER_MODIFYABLE_FLAG = “Y”
DEFAULT_STRING_TRANS_FLAG = “N”
VAL_TYPE = “2”
VAL_VALUE = “PO_PDOI_VALID_AGENTS”
VAL_BNE_QUERY = “” “”
MAX_SIZE = “240”
DISPLAY_TYPE = “3”
DISPLAY_STYLE = “1”
DISPLAY_SIZE = “15”
USER_NAME = “Default Buyer”
PROMPT_LEFT = “Default Buyer”
PROMPT_ABOVE = “Default Buyer”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
END BNE_PARAM_DEFNS
BEGIN BNE_PARAM_DEFNS “PO” “UPL_PARAM_500224”
OBJECT_VERSION_NUMBER = “3”
PARAM_NAME = “P_PODOCUMENT_TYPE”
PARAM_SOURCE = “DIF:Upload”
PARAM_CATEGORY = “6”
DATATYPE = “1”
DEFN = “” “”
DEFAULT_REQUIRED_FLAG = “N”
DEFAULT_VISIBLE_FLAG = “N”
DEFAULT_USER_MODIFYABLE_FLAG = “N”
DEFAULT_STRING_TRANS = “STANDARD”
DEFAULT_STRING_TRANS_FLAG = “Y”
VAL_TYPE = “2”
VAL_VALUE = “PO_PDOI_STDPO_DOCUMENT_TYPES”
VAL_BNE_QUERY = “” “”
MAX_SIZE = “240”
DISPLAY_TYPE = “3”
DISPLAY_STYLE = “1”
DISPLAY_SIZE = “15”
USER_NAME = “Document Type”
DEFAULT_DESC = “STANDARD”
PROMPT_LEFT = “Document Type”
PROMPT_ABOVE = “Document Type”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
END BNE_PARAM_DEFNS
BEGIN BNE_PARAM_DEFNS “PO” “UPL_PARAM_500226”
OBJECT_VERSION_NUMBER = “2”
PARAM_NAME = “P_DOC_SUB_TYPE”
PARAM_SOURCE = “DIF:Upload”
PARAM_CATEGORY = “6”
DATATYPE = “1”
DEFN = “” “”
DEFAULT_REQUIRED_FLAG = “N”
DEFAULT_VISIBLE_FLAG = “N”
DEFAULT_USER_MODIFYABLE_FLAG = “Y”
DEFAULT_STRING_TRANS_FLAG = “N”
VAL_TYPE = “2”
VAL_VALUE = “PO_PDOI_YES_NO_VALUES”
VAL_BNE_QUERY = “” “”
MAX_SIZE = “240”
DISPLAY_TYPE = “3”
DISPLAY_STYLE = “1”
DISPLAY_SIZE = “10”
USER_NAME = “Document SubType”
PROMPT_LEFT = “Document SubType”
PROMPT_ABOVE = “Document SubType”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
END BNE_PARAM_DEFNS
BEGIN BNE_PARAM_DEFNS “PO” “UPL_PARAM_500227”
OBJECT_VERSION_NUMBER = “1”
PARAM_NAME = “P_POCREATE_ITEMS”
PARAM_SOURCE = “DIF:Upload”
PARAM_CATEGORY = “6”
DATATYPE = “1”
DEFN = “” “”
DEFAULT_REQUIRED_FLAG = “Y”
DEFAULT_VISIBLE_FLAG = “Y”
DEFAULT_USER_MODIFYABLE_FLAG = “Y”
DEFAULT_STRING_TRANS_FLAG = “N”
VAL_TYPE = “2”
VAL_VALUE = “PO_PDOI_YES_NO_VALUES”
VAL_BNE_QUERY = “” “”
MAX_SIZE = “240”
DISPLAY_TYPE = “3”
DISPLAY_STYLE = “1”
DISPLAY_SIZE = “10”
USER_NAME = “Create or Update Items”
PROMPT_LEFT = “Create or Update Items”
PROMPT_ABOVE = “Create or Update Items”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/01”
END BNE_PARAM_DEFNS
BEGIN BNE_PARAM_DEFNS “PO” “UPL_PARAM_500229”
OBJECT_VERSION_NUMBER = “2”
PARAM_NAME = “P_CREATE_SOURCING_RUL”
PARAM_SOURCE = “DIF:Upload”
PARAM_CATEGORY = “6”
DATATYPE = “1”
DEFN = “” “”
DEFAULT_REQUIRED_FLAG = “N”
DEFAULT_VISIBLE_FLAG = “N”
DEFAULT_USER_MODIFYABLE_FLAG = “Y”
DEFAULT_STRING_TRANS_FLAG = “N”
VAL_TYPE = “2”
VAL_VALUE = “PO_PDOI_YES_NO_VALUES”
VAL_BNE_QUERY = “” “”
MAX_SIZE = “240”
DISPLAY_TYPE = “3”
DISPLAY_STYLE = “1”
DISPLAY_SIZE = “15”
USER_NAME = “Create Sourcing Rules”
PROMPT_LEFT = “Create Sourcing Rules”
PROMPT_ABOVE = “Create Sourcing Rules”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
END BNE_PARAM_DEFNS
BEGIN BNE_PARAM_DEFNS “PO” “UPL_PARAM_500230”
OBJECT_VERSION_NUMBER = “2”
PARAM_NAME = “P_APPRVL_STATUS”
PARAM_SOURCE = “DIF:Upload”
PARAM_CATEGORY = “6”
DATATYPE = “1”
DEFN = “” “”
DEFAULT_REQUIRED_FLAG = “N”
DEFAULT_VISIBLE_FLAG = “N”
DEFAULT_USER_MODIFYABLE_FLAG = “N”
DEFAULT_STRING_TRANS = “APPROVED”
DEFAULT_STRING_TRANS_FLAG = “Y”
VAL_TYPE = “2”
VAL_VALUE = “PO_PDOI_STDPO_APPROVAL_STATUS”
VAL_BNE_QUERY = “” “”
MAX_SIZE = “240”
DISPLAY_TYPE = “3”
DISPLAY_STYLE = “1”
DISPLAY_SIZE = “15”
USER_NAME = “Approval Status”
DEFAULT_DESC = “APPROVED”
PROMPT_LEFT = “Approval Status”
PROMPT_ABOVE = “Approval Status”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
END BNE_PARAM_DEFNS
BEGIN BNE_PARAM_DEFNS “PO” “UPL_PARAM_500231”
OBJECT_VERSION_NUMBER = “2”
PARAM_NAME = “P_REL_GEN_METHOD”
PARAM_SOURCE = “DIF:Upload”
PARAM_CATEGORY = “6”
DATATYPE = “1”
DEFN = “” “”
DEFAULT_REQUIRED_FLAG = “N”
DEFAULT_VISIBLE_FLAG = “N”
DEFAULT_USER_MODIFYABLE_FLAG = “Y”
DEFAULT_STRING_TRANS_FLAG = “N”
VAL_TYPE = “2”
VAL_VALUE = “PO_PDOI_REL_GEN_METHOD”
VAL_BNE_QUERY = “” “”
MAX_SIZE = “240”
DISPLAY_TYPE = “3”
DISPLAY_STYLE = “1”
DISPLAY_SIZE = “25”
USER_NAME = “Release Generation Method”
PROMPT_LEFT = “Release Generation Method”
PROMPT_ABOVE = “Release Generation Method”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
END BNE_PARAM_DEFNS
BEGIN BNE_PARAM_DEFNS “PO” “UPL_PARAM_500232”
OBJECT_VERSION_NUMBER = “2”
PARAM_NAME = “P_GLOBAL_AGREEMENT”
PARAM_SOURCE = “DIF:Upload”
PARAM_CATEGORY = “6”
DATATYPE = “1”
DEFN = “” “”
DEFAULT_REQUIRED_FLAG = “N”
DEFAULT_VISIBLE_FLAG = “N”
DEFAULT_USER_MODIFYABLE_FLAG = “Y”
DEFAULT_STRING_TRANS_FLAG = “N”
VAL_TYPE = “2”
VAL_VALUE = “PO_PDOI_YES_NO_VALUES”
VAL_BNE_QUERY = “” “”
MAX_SIZE = “240”
DISPLAY_TYPE = “3”
DISPLAY_STYLE = “1”
DISPLAY_SIZE = “10”
USER_NAME = “Global Agreement”
PROMPT_LEFT = “Global Agreement”
PROMPT_ABOVE = “Global Agreement”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
END BNE_PARAM_DEFNS
BEGIN BNE_PARAM_DEFNS “PO” “UPL_PARAM_500233”
OBJECT_VERSION_NUMBER = “2”
PARAM_NAME = “P_ENABLE_SOURCING_LEV”
PARAM_SOURCE = “DIF:Upload”
PARAM_CATEGORY = “6”
DATATYPE = “1”
DEFN = “” “”
DEFAULT_REQUIRED_FLAG = “N”
DEFAULT_VISIBLE_FLAG = “N”
DEFAULT_USER_MODIFYABLE_FLAG = “Y”
DEFAULT_STRING_TRANS_FLAG = “N”
VAL_TYPE = “2”
VAL_VALUE = “PO_PDOI_ENABLE_FLAG”
VAL_BNE_QUERY = “” “”
MAX_SIZE = “240”
DISPLAY_TYPE = “3”
DISPLAY_STYLE = “1”
DISPLAY_SIZE = “10”
USER_NAME = “Enable Sourcing Level”
PROMPT_LEFT = “Enable Sourcing Level”
PROMPT_ABOVE = “Enable Sourcing Level”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
END BNE_PARAM_DEFNS
BEGIN BNE_PARAM_DEFNS “PO” “UPL_PARAM_500234”
OBJECT_VERSION_NUMBER = “2”
PARAM_NAME = “P_SOURCING_LEVEL”
PARAM_SOURCE = “DIF:Upload”
PARAM_CATEGORY = “6”
DATATYPE = “1”
DEFN = “” “”
DEFAULT_REQUIRED_FLAG = “N”
DEFAULT_VISIBLE_FLAG = “N”
DEFAULT_USER_MODIFYABLE_FLAG = “Y”
DEFAULT_STRING_TRANS_FLAG = “N”
VAL_TYPE = “2”
VAL_VALUE = “PO_PDOI_SOURCING_LEVEL”
VAL_BNE_QUERY = “” “”
MAX_SIZE = “240”
DISPLAY_TYPE = “3”
DISPLAY_STYLE = “1”
DISPLAY_SIZE = “10”
USER_NAME = “Sourcing Level”
PROMPT_LEFT = “Sourcing Level”
PROMPT_ABOVE = “Sourcing Level”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
END BNE_PARAM_DEFNS
BEGIN BNE_PARAM_DEFNS “PO” “UPL_PARAM_500236”
OBJECT_VERSION_NUMBER = “2”
PARAM_NAME = “P_INV_ORG_ENABLE1”
PARAM_SOURCE = “DIF:Upload”
PARAM_CATEGORY = “6”
DATATYPE = “1”
DEFN = “” “”
DEFAULT_REQUIRED_FLAG = “N”
DEFAULT_VISIBLE_FLAG = “N”
DEFAULT_USER_MODIFYABLE_FLAG = “Y”
DEFAULT_STRING_TRANS_FLAG = “N”
VAL_TYPE = “2”
VAL_VALUE = “PO_ASL_ENABLE_FLAG”
VAL_BNE_QUERY = “” “”
MAX_SIZE = “240”
DISPLAY_TYPE = “3”
DISPLAY_STYLE = “1”
DISPLAY_SIZE = “15”
USER_NAME = “Inv Org Enable”
PROMPT_LEFT = “Inv Org Enable”
PROMPT_ABOVE = “Inv Org Enable”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
END BNE_PARAM_DEFNS
BEGIN BNE_PARAM_DEFNS “PO” “UPL_PARAM_500237”
OBJECT_VERSION_NUMBER = “2”
PARAM_NAME = “P_INVENTORY_ORGANIZAT”
PARAM_SOURCE = “DIF:Upload”
PARAM_CATEGORY = “6”
DATATYPE = “1”
DEFN = “” “”
DEFAULT_REQUIRED_FLAG = “N”
DEFAULT_VISIBLE_FLAG = “N”
DEFAULT_USER_MODIFYABLE_FLAG = “Y”
DEFAULT_STRING_TRANS_FLAG = “N”
VAL_TYPE = “2”
VAL_VALUE = “PO_ASL_INV_ORG”
VAL_BNE_QUERY = “” “”
MAX_SIZE = “240”
DISPLAY_TYPE = “3”
DISPLAY_STYLE = “1”
DISPLAY_SIZE = “15”
USER_NAME = “Inventory Organization”
PROMPT_LEFT = “Inventory Organization”
PROMPT_ABOVE = “Inventory Organization”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
END BNE_PARAM_DEFNS
BEGIN BNE_PARAM_LISTS “PO” “UPL_501138”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
PERSISTENT_FLAG = “Y”
COMMENTS = “Upload Page”
LIST = “” “”
USER_NAME = “XXDS:Purchase Order Interface – Uploader”
BEGIN BNE_PARAM_LIST_ITEMS “1”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/01”
OBJECT_VERSION_NUMBER = “3”
DEFN = “BNE” “UPL_PARAM_500203”
PARAM_NAME = “bne:rows”
LIST_ITEM = “” “”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “2”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/01”
OBJECT_VERSION_NUMBER = “3”
DEFN = “BNE” “UPL_PARAM_500204”
PARAM_NAME = “bne:validation”
LIST_ITEM = “” “”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “3”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/01”
OBJECT_VERSION_NUMBER = “3”
DEFN = “BNE” “UPL_PARAM_500205”
PARAM_NAME = “bne:import”
LIST_ITEM = “” “”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “4”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/01”
OBJECT_VERSION_NUMBER = “5”
DEFN = “PO” “UPL_PARAM_500238”
PARAM_NAME = “bne:commitrows”
LIST_ITEM = “” “”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “5”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/01”
OBJECT_VERSION_NUMBER = “4”
DEFN = “PO” “UPL_PARAM_500223”
PARAM_NAME = “P_BUYER_ID”
LIST_ITEM = “” “”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “6”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/01”
OBJECT_VERSION_NUMBER = “4”
DEFN = “PO” “UPL_PARAM_500224”
PARAM_NAME = “P_PODOCUMENT_TYPE”
LIST_ITEM = “” “”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “7”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/01”
OBJECT_VERSION_NUMBER = “3”
DEFN = “PO” “UPL_PARAM_500226”
PARAM_NAME = “P_DOC_SUB_TYPE”
LIST_ITEM = “” “”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “8”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/01”
OBJECT_VERSION_NUMBER = “3”
DEFN = “PO” “UPL_PARAM_500227”
PARAM_NAME = “P_POCREATE_ITEMS”
LIST_ITEM = “” “”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “9”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/01”
OBJECT_VERSION_NUMBER = “3”
DEFN = “PO” “UPL_PARAM_500229”
PARAM_NAME = “P_CREATE_SOURCING_RUL”
LIST_ITEM = “” “”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “10”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/01”
OBJECT_VERSION_NUMBER = “3”
DEFN = “PO” “UPL_PARAM_500230”
PARAM_NAME = “P_APPRVL_STATUS”
LIST_ITEM = “” “”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “11”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/01”
OBJECT_VERSION_NUMBER = “3”
DEFN = “PO” “UPL_PARAM_500231”
PARAM_NAME = “P_REL_GEN_METHOD”
LIST_ITEM = “” “”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “12”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/01”
OBJECT_VERSION_NUMBER = “3”
DEFN = “PO” “UPL_PARAM_500232”
PARAM_NAME = “P_GLOBAL_AGREEMENT”
LIST_ITEM = “” “”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “13”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/01”
OBJECT_VERSION_NUMBER = “3”
DEFN = “PO” “UPL_PARAM_500233”
PARAM_NAME = “P_ENABLE_SOURCING_LEV”
LIST_ITEM = “” “”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “14”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/01”
OBJECT_VERSION_NUMBER = “3”
DEFN = “PO” “UPL_PARAM_500234”
PARAM_NAME = “P_SOURCING_LEVEL”
LIST_ITEM = “” “”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “15”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/01”
OBJECT_VERSION_NUMBER = “3”
DEFN = “PO” “UPL_PARAM_500236”
PARAM_NAME = “P_INV_ORG_ENABLE1”
LIST_ITEM = “” “”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “16”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/01”
OBJECT_VERSION_NUMBER = “3”
DEFN = “PO” “UPL_PARAM_500237”
PARAM_NAME = “P_INVENTORY_ORGANIZAT”
LIST_ITEM = “” “”
END BNE_PARAM_LIST_ITEMS
END BNE_PARAM_LISTS
BEGIN BNE_PARAM_LISTS “PO” “IMP_501501”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
OBJECT_VERSION_NUMBER = “2”
PERSISTENT_FLAG = “Y”
LIST = “” “”
USER_NAME = “POHEADERIFACE”
BEGIN BNE_PARAM_LIST_ITEMS “1”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/09/04”
OBJECT_VERSION_NUMBER = “38”
DEFN = “” “”
PARAM_NAME = “GROUP”
LIST_ITEM = “” “”
STRING_VALUE = “201:GRP_501522”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “2”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/09/04”
OBJECT_VERSION_NUMBER = “36”
DEFN = “” “”
PARAM_NAME = “ROW_MAPPING”
LIST_ITEM = “” “”
STRING_VALUE = “201:RM_501527”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “3”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/09/04”
OBJECT_VERSION_NUMBER = “2”
DEFN = “” “”
PARAM_NAME = “PLSQL”
LIST_ITEM = “” “”
STRING_VALUE = “201:PL_501504”
END BNE_PARAM_LIST_ITEMS
END BNE_PARAM_LISTS
BEGIN BNE_PARAM_LISTS “PO” “GRP_501522”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
OBJECT_VERSION_NUMBER = “1”
PERSISTENT_FLAG = “Y”
COMMENTS = “Group Definition”
LIST = “” “”
USER_NAME = “Group Definition”
BEGIN BNE_PARAM_LIST_ITEMS “1”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
OBJECT_VERSION_NUMBER = “2”
DEFN = “” “”
PARAM_NAME = “INSERT_WEB_ADI_TL.P_BATCH_ID”
LIST_ITEM = “” “”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “2”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
OBJECT_VERSION_NUMBER = “2”
DEFN = “” “”
PARAM_NAME = “INSERT_WEB_ADI_TL.P_ORG_NAME”
LIST_ITEM = “” “”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “3”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
OBJECT_VERSION_NUMBER = “2”
DEFN = “” “”
PARAM_NAME = “INSERT_WEB_ADI_TL.P_DOCUMENT_TYPE_CODE”
LIST_ITEM = “” “”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “4”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “INSERT_WEB_ADI_TL.P_APPROVAL_STATUS”
LIST_ITEM = “” “”
END BNE_PARAM_LIST_ITEMS
END BNE_PARAM_LISTS
BEGIN BNE_ATTRIBUTES “PO” “ATT_500603”
OBJECT_VERSION_NUMBER = “16”
ATTRIBUTE1 = “PROCEDURE”
ATTRIBUTE2 = “XXDS_PO_IFACE_PKG.SUBMIT_PO”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “ATT_500604”
OBJECT_VERSION_NUMBER = “5”
ATTRIBUTE1 = “P_BUYER_ID”
ATTRIBUTE2 = “NUMBER”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE7 = “REQUEST”
ATTRIBUTE8 = “DEFAULT_BUYER_ID”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “ATT_500605”
OBJECT_VERSION_NUMBER = “8”
ATTRIBUTE1 = “P_DOCUMENT_TYPE”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
ATTRIBUTE7 = “IMPORT”
ATTRIBUTE8 = “INSERT_WEB_ADI_TL.P_DOCUMENT_TYPE_CODE”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “ATT_500606”
OBJECT_VERSION_NUMBER = “5”
ATTRIBUTE1 = “P_DOC_SUB_TYPE”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
ATTRIBUTE7 = “REQUEST”
ATTRIBUTE8 = “DOCUMENT_SUB_TYPE”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “ATT_500607”
OBJECT_VERSION_NUMBER = “4”
ATTRIBUTE1 = “P_CREATE_ITEMS”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE5 = “‘N'”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “ATT_500608”
OBJECT_VERSION_NUMBER = “3”
ATTRIBUTE1 = “P_CREATE_SOURCING_RUL”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
ATTRIBUTE7 = “REQUEST”
ATTRIBUTE8 = “CREATE_SOURCING_RUL”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “ATT_500609”
OBJECT_VERSION_NUMBER = “4”
ATTRIBUTE1 = “P_APPROVAL_STATUS”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
ATTRIBUTE7 = “IMPORT”
ATTRIBUTE8 = “INSERT_WEB_ADI_TL.P_APPROVAL_STATUS”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “ATT_500610”
OBJECT_VERSION_NUMBER = “3”
ATTRIBUTE1 = “P_REL_GEN_METHOD”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
ATTRIBUTE7 = “REQUEST”
ATTRIBUTE8 = “REL_GEN_METHOD”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “ATT_500611”
OBJECT_VERSION_NUMBER = “6”
ATTRIBUTE1 = “P_BATCH_ID”
ATTRIBUTE2 = “NUMBER”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE7 = “IMPORT”
ATTRIBUTE8 = “INSERT_WEB_ADI_TL.P_BATCH_ID”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “ATT_500612”
OBJECT_VERSION_NUMBER = “3”
ATTRIBUTE1 = “P_OPERATING_UNIT”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
ATTRIBUTE7 = “IMPORT”
ATTRIBUTE8 = “P_ORG_NAME”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “ATT_500613”
OBJECT_VERSION_NUMBER = “3”
ATTRIBUTE1 = “P_GLOBAL_AGREEMENT”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
ATTRIBUTE7 = “REQUEST”
ATTRIBUTE8 = “GLOBAL_AGREEMENT”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “ATT_500614”
OBJECT_VERSION_NUMBER = “3”
ATTRIBUTE1 = “P_ENABLE_SOURCING_LEVEL”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
ATTRIBUTE7 = “REQUEST”
ATTRIBUTE8 = “ENABLE_SOURCING_LEV”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “ATT_500615”
OBJECT_VERSION_NUMBER = “3”
ATTRIBUTE1 = “P_SOURCING_LEVEL”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
ATTRIBUTE7 = “REQUEST”
ATTRIBUTE8 = “SOURCING_LEVEL”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “ATT_500616”
OBJECT_VERSION_NUMBER = “3”
ATTRIBUTE1 = “P_INV_ORG_ENABLE”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
ATTRIBUTE7 = “REQUEST”
ATTRIBUTE8 = “SOURCING_LEVEL”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “ATT_500617”
OBJECT_VERSION_NUMBER = “3”
ATTRIBUTE1 = “P_INVENTORY_ORGANIZATION”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
ATTRIBUTE7 = “REQUEST”
ATTRIBUTE8 = “INV_ORG_ENABLE1”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “ATT_500618”
OBJECT_VERSION_NUMBER = “2”
ATTRIBUTE1 = “X_REQUEST_ID”
ATTRIBUTE2 = “NUMBER”
ATTRIBUTE3 = “OUT”
ATTRIBUTE4 = “N”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
END BNE_ATTRIBUTES
BEGIN BNE_PARAM_LISTS “PO” “PL_501504”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
OBJECT_VERSION_NUMBER = “1”
PERSISTENT_FLAG = “Y”
COMMENTS = “PLSQL”
LIST = “” “”
USER_NAME = “PLSQL”
BEGIN BNE_PARAM_LIST_ITEMS “1”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “XXDS_PO_IFACE_PKG.SUBMIT_PO”
LIST_ITEM = “PO” “ATT_500603”
DESC_VALUE = “PLSQL”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “2”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_BUYER_ID”
LIST_ITEM = “PO” “ATT_500604”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “3”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_DOCUMENT_TYPE”
LIST_ITEM = “PO” “ATT_500605”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “4”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_DOC_SUB_TYPE”
LIST_ITEM = “PO” “ATT_500606”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “5”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_CREATE_ITEMS”
LIST_ITEM = “PO” “ATT_500607”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “6”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_CREATE_SOURCING_RUL”
LIST_ITEM = “PO” “ATT_500608”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “7”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_APPROVAL_STATUS”
LIST_ITEM = “PO” “ATT_500609”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “8”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_REL_GEN_METHOD”
LIST_ITEM = “PO” “ATT_500610”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “9”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_BATCH_ID”
LIST_ITEM = “PO” “ATT_500611”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “10”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_OPERATING_UNIT”
LIST_ITEM = “PO” “ATT_500612”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “11”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_GLOBAL_AGREEMENT”
LIST_ITEM = “PO” “ATT_500613”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “12”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_ENABLE_SOURCING_LEVEL”
LIST_ITEM = “PO” “ATT_500614”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “13”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_SOURCING_LEVEL”
LIST_ITEM = “PO” “ATT_500615”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “14”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_INV_ORG_ENABLE”
LIST_ITEM = “PO” “ATT_500616”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “15”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_INVENTORY_ORGANIZATION”
LIST_ITEM = “PO” “ATT_500617”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “16”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “X_REQUEST_ID”
LIST_ITEM = “PO” “ATT_500618”
END BNE_PARAM_LIST_ITEMS
END BNE_PARAM_LISTS
BEGIN BNE_PARAM_LISTS “PO” “RM_501527”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
OBJECT_VERSION_NUMBER = “1”
PERSISTENT_FLAG = “Y”
COMMENTS = “Document Row : Interface Attribute Mapping”
LIST = “” “”
USER_NAME = “Document Row : Interface Attribute Mapping”
BEGIN BNE_PARAM_LIST_ITEMS “1”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
OBJECT_VERSION_NUMBER = “2”
DEFN = “” “”
PARAM_NAME = “INSERT_WEB_ADI_TL.P_BATCH_ID”
LIST_ITEM = “” “”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “2”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
OBJECT_VERSION_NUMBER = “2”
DEFN = “” “”
PARAM_NAME = “INSERT_WEB_ADI_TL.P_ORG_NAME”
LIST_ITEM = “” “”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “3”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
OBJECT_VERSION_NUMBER = “2”
DEFN = “” “”
PARAM_NAME = “INSERT_WEB_ADI_TL.P_DOCUMENT_TYPE_CODE”
LIST_ITEM = “” “”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “4”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “INSERT_WEB_ADI_TL.P_APPROVAL_STATUS”
LIST_ITEM = “” “”
END BNE_PARAM_LIST_ITEMS
END BNE_PARAM_LISTS
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A0”
OBJECT_VERSION_NUMBER = “4”
ATTRIBUTE1 = “PROCEDURE”
ATTRIBUTE2 = “XXDS_PO_IFACE_PKG.INSERT_WEB_ADI_TL”
ATTRIBUTE5 = “Y”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A1”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_BATCH_ID”
ATTRIBUTE2 = “NUMBER”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A2”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_MODE”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A3”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_ORG_NAME”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A4”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_ORG_ID”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A5”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_PO_NUMBER”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A6”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_CREATION_DATE”
ATTRIBUTE2 = “DATE”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A7”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_DOCUMENT_TYPE_CODE”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A8”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_VENDOR_NAME”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A9”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_VENDRO_SITE_CODE”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A10”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_SHIP_TO”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A11”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_BILL_TO”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A12”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_VENDOR_CONTACT_NAME”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A13”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_AGENT_NAME”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A14”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_APPROVAL_STATUS”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A15”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_TOTAL”
ATTRIBUTE2 = “NUMBER”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A16”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_CURRENCY”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A17”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_CONVERSION_TYPE”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A18”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_CONVERSION_RATE”
ATTRIBUTE2 = “NUMBER”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A19”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_CONVERSION_DATE”
ATTRIBUTE2 = “DATE”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A20”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_TERMS”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A21”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_FRIGHT_TERMS”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A22”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_CARRIER”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A23”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_DESCRIPTION”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A24”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_LINE_NUM”
ATTRIBUTE2 = “NUMBER”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A25”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_LINE_TYPE”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A26”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_ITEM”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A27”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_ITEM_CATEGORY”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A28”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_ITEM_DESCRIPTION”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A29”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_UOM”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A30”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_QUANTITY”
ATTRIBUTE2 = “NUMBER”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A31”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_PRICE”
ATTRIBUTE2 = “NUMBER”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A32”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_PROMISE_DATE”
ATTRIBUTE2 = “DATE”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A33”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_NEED_BY_DATE”
ATTRIBUTE2 = “DATE”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A34”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_SHIP_TO_ORG”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A35”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_SHIPMENT_NUM”
ATTRIBUTE2 = “NUMBER”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A36”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_DISTRIBUTION_NUM”
ATTRIBUTE2 = “NUMBER”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A37”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_SEGMENT1”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A38”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_SEGMENT2”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A39”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_SEGMENT3”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A40”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_SEGMENT4”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A41”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_SEGMENT5”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A42”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_SEGMENT6”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A43”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_SEGMENT7”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A44”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_SEGMENT8”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A45”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_SEGMENT9”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A46”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_SEGMENT10”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A47”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_ATTRIBUTE1”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A48”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_ATTRIBUTE2”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A49”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_ATTRIBUTE3”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A50”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_ATTRIBUTE4”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A51”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_ATTRIBUTE5”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A52”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_ATTRIBUTE6”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A53”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_ATTRIBUTE7”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A54”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_ATTRIBUTE8”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A55”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_ATTRIBUTE9”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A56”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_ATTRIBUTE10”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A57”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_USER_ID”
ATTRIBUTE2 = “NUMBER”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A58”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_RESP_ID”
ATTRIBUTE2 = “NUMBER”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_PARAM_LISTS “PO” “XXDS_PO_IFACE_WEDAI_XI_UPL1”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
PERSISTENT_FLAG = “Y”
COMMENTS = “Parameter List for Interface XXDS_PO_IFACE_WEDAI_XI_INTF1”
LIST = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A0”
USER_NAME = “Parameter List for Interface XXDS_PO_IFACE_WEDAI_XI_INTF1”
BEGIN BNE_PARAM_LIST_ITEMS “1”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_BATCH_ID”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A1”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “2”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_MODE”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A2”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “3”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_ORG_NAME”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A3”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “4”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_ORG_ID”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A4”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “5”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_PO_NUMBER”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A5”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “6”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_CREATION_DATE”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A6”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “7”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_DOCUMENT_TYPE_CODE”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A7”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “8”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_VENDOR_NAME”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A8”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “9”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_VENDRO_SITE_CODE”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A9”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “10”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_SHIP_TO”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A10”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “11”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_BILL_TO”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A11”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “12”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_VENDOR_CONTACT_NAME”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A12”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “13”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_AGENT_NAME”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A13”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “14”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_APPROVAL_STATUS”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A14”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “15”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_TOTAL”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A15”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “16”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_CURRENCY”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A16”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “17”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_CONVERSION_TYPE”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A17”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “18”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_CONVERSION_RATE”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A18”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “19”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_CONVERSION_DATE”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A19”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “20”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_TERMS”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A20”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “21”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_FRIGHT_TERMS”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A21”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “22”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_CARRIER”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A22”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “23”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_DESCRIPTION”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A23”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “24”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_LINE_NUM”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A24”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “25”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_LINE_TYPE”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A25”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “26”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_ITEM”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A26”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “27”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_ITEM_CATEGORY”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A27”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “28”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_ITEM_DESCRIPTION”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A28”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “29”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_UOM”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A29”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “30”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_QUANTITY”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A30”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “31”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_PRICE”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A31”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “32”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_PROMISE_DATE”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A32”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “33”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_NEED_BY_DATE”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A33”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “34”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_SHIP_TO_ORG”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A34”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “35”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_SHIPMENT_NUM”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A35”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “36”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_DISTRIBUTION_NUM”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A36”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “37”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_SEGMENT1”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A37”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “38”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_SEGMENT2”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A38”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “39”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_SEGMENT3”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A39”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “40”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_SEGMENT4”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A40”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “41”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_SEGMENT5”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A41”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “42”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_SEGMENT6”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A42”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “43”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_SEGMENT7”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A43”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “44”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_SEGMENT8”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A44”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “45”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_SEGMENT9”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A45”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “46”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_SEGMENT10”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A46”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “47”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_ATTRIBUTE1”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A47”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “48”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_ATTRIBUTE2”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A48”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “49”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_ATTRIBUTE3”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A49”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “50”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_ATTRIBUTE4”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A50”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “51”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_ATTRIBUTE5”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A51”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “52”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_ATTRIBUTE6”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A52”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “53”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_ATTRIBUTE7”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A53”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “54”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_ATTRIBUTE8”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A54”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “55”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_ATTRIBUTE9”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A55”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “56”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_ATTRIBUTE10”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A56”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “57”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_USER_ID”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A57”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “58”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_RESP_ID”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A58”
END BNE_PARAM_LIST_ITEMS
END BNE_PARAM_LISTS
BEGIN BNE_INTEGRATORS “PO” “XXDS_PO_IFACE_WEDAI_XINTG”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “3”
ENABLED_FLAG = “Y”
UPL = “PO” “UPL_501138”
UPL_SERV = “” “”
IMPORT = “PO” “IMP_501501”
DATE_FORMAT = “yyyy-MM-dd”
IMPORT_TYPE = “3”
USER_NAME = “XXDS:Purchase Order Interface”
UPLOAD_HEADER = “Upload Parameters”
UPLOAD_TITLE_BAR = “Upload Page”
LAST_UPDATE_DATE = “2020/08/04”
CREATE_DOC = “” “”
SESSION = “” “”
SECURITY = “” “” “”
DISPLAY_FLAG = “Y”
BEGIN BNE_INTEGRATOR_IMPORT_LISTS “PO” “GRP_501522”
END BNE_INTEGRATOR_IMPORT_LISTS
BEGIN BNE_INTEGRATOR_IMPORT_LISTS “PO” “PL_501504”
END BNE_INTEGRATOR_IMPORT_LISTS
BEGIN BNE_INTEGRATOR_IMPORT_LISTS “PO” “RM_501527”
END BNE_INTEGRATOR_IMPORT_LISTS
BEGIN BNE_INTERFACES “PO” “XXDS_PO_IFACE_WEDAI_XI_INTF1”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_NAME = “INSERT_WEB_ADI_TL”
UPLOAD_TYPE = “2”
UPLOAD_PARAMS = “PO” “XXDS_PO_IFACE_WEDAI_XI_UPL1”
UPLOAD_ORDER = “1”
USER_NAME = “XXDSPO_INTERFACE”
LAST_UPDATE_DATE = “2020/07/31”
BEGIN BNE_INTERFACE_COLS “1”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “2”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_BATCH_ID”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “Y”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “1”
DEFAULT_TYPE = “SQL”
DEFAULT_VALUE = “SELECT XXDS_WEBADI_PO_STG_S.NEXTVAL FROM DUAL”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “1”
UPLOAD_PARAM_LIST_ITEM_NUM = “1”
PROMPT_LEFT = “BATCH_ID”
PROMPT_ABOVE = “BATCH_ID”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “2”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “3”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_MODE”
ENABLED_FLAG = “N”
REQUIRED_FLAG = “Y”
DISPLAY_FLAG = “N”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “2”
UPLOAD_PARAM_LIST_ITEM_NUM = “2”
PROMPT_LEFT = “MODE”
PROMPT_ABOVE = “MODE”
LAST_UPDATE_DATE = “2020/08/05”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “3”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “2”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_ORG_NAME”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
DEFAULT_TYPE = “SQL”
DEFAULT_VALUE =
“SELECT NAME FROM hr_operating_units WHERE organization_id = fnd_profile.VALUE (‘ORG_ID’)”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “3”
UPLOAD_PARAM_LIST_ITEM_NUM = “3”
PROMPT_LEFT = “ORG_NAME”
PROMPT_ABOVE = “ORG_NAME”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “4”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “2”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_ORG_ID”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “N”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “4”
UPLOAD_PARAM_LIST_ITEM_NUM = “4”
PROMPT_LEFT = “ORG_ID”
PROMPT_ABOVE = “ORG_ID”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “5”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “3”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_PO_NUMBER”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “5”
UPLOAD_PARAM_LIST_ITEM_NUM = “5”
PROMPT_LEFT = “PO_NUMBER”
PROMPT_ABOVE = “PO_NUMBER”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “6”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_CREATION_DATE”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “3”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “6”
UPLOAD_PARAM_LIST_ITEM_NUM = “6”
PROMPT_LEFT = “CREATION_DATE”
PROMPT_ABOVE = “CREATION_DATE”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “7”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_DOCUMENT_TYPE_CODE”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “7”
UPLOAD_PARAM_LIST_ITEM_NUM = “7”
PROMPT_LEFT = “DOCUMENT_TYPE_CODE”
PROMPT_ABOVE = “DOCUMENT_TYPE_CODE”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “8”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_VENDOR_NAME”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “8”
UPLOAD_PARAM_LIST_ITEM_NUM = “8”
PROMPT_LEFT = “VENDOR_NAME”
PROMPT_ABOVE = “VENDOR_NAME”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “9”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_VENDRO_SITE_CODE”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “9”
UPLOAD_PARAM_LIST_ITEM_NUM = “9”
PROMPT_LEFT = “VENDRO_SITE_CODE”
PROMPT_ABOVE = “VENDRO_SITE_CODE”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “10”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_SHIP_TO”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “10”
UPLOAD_PARAM_LIST_ITEM_NUM = “10”
PROMPT_LEFT = “SHIP_TO”
PROMPT_ABOVE = “SHIP_TO”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “11”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_BILL_TO”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “11”
UPLOAD_PARAM_LIST_ITEM_NUM = “11”
PROMPT_LEFT = “BILL_TO”
PROMPT_ABOVE = “BILL_TO”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “12”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_VENDOR_CONTACT_NAME”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “12”
UPLOAD_PARAM_LIST_ITEM_NUM = “12”
PROMPT_LEFT = “VENDOR_CONTACT_NAME”
PROMPT_ABOVE = “VENDOR_CONTACT_NAME”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “13”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “3”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_AGENT_NAME”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_ID_COL = “p.agent_id”
VAL_MEAN_COL = “hr.full_name”
VAL_DESC_COL = “hr.full_name”
VAL_ADDL_W_C =
“where hr.employee_id = p.agent_id and nvl(p.end_date_active,sysdate +1) > sysdate order by hr.full_name”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “13”
UPLOAD_PARAM_LIST_ITEM_NUM = “13”
PROMPT_LEFT = “AGENT_NAME”
PROMPT_ABOVE = “AGENT_NAME”
LAST_UPDATE_DATE = “2020/08/01”
LOV_TYPE = “STANDARD”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “14”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “2”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_APPROVAL_STATUS”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
DEFAULT_TYPE = “CONSTANT”
DEFAULT_VALUE = “INCOMPLETE”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “14”
UPLOAD_PARAM_LIST_ITEM_NUM = “14”
PROMPT_LEFT = “APPROVAL_STATUS”
PROMPT_ABOVE = “APPROVAL_STATUS”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “15”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_TOTAL”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “1”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “15”
UPLOAD_PARAM_LIST_ITEM_NUM = “15”
PROMPT_LEFT = “TOTAL”
PROMPT_ABOVE = “TOTAL”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “16”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_CURRENCY”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “16”
UPLOAD_PARAM_LIST_ITEM_NUM = “16”
PROMPT_LEFT = “CURRENCY”
PROMPT_ABOVE = “CURRENCY”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “17”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_CONVERSION_TYPE”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “17”
UPLOAD_PARAM_LIST_ITEM_NUM = “17”
PROMPT_LEFT = “CONVERSION_TYPE”
PROMPT_ABOVE = “CONVERSION_TYPE”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “18”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_CONVERSION_RATE”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “1”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “18”
UPLOAD_PARAM_LIST_ITEM_NUM = “18”
PROMPT_LEFT = “CONVERSION_RATE”
PROMPT_ABOVE = “CONVERSION_RATE”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “19”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_CONVERSION_DATE”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “3”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “19”
UPLOAD_PARAM_LIST_ITEM_NUM = “19”
PROMPT_LEFT = “CONVERSION_DATE”
PROMPT_ABOVE = “CONVERSION_DATE”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “20”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_TERMS”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “20”
UPLOAD_PARAM_LIST_ITEM_NUM = “20”
PROMPT_LEFT = “TERMS”
PROMPT_ABOVE = “TERMS”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “21”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_FRIGHT_TERMS”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “21”
UPLOAD_PARAM_LIST_ITEM_NUM = “21”
PROMPT_LEFT = “FRIGHT_TERMS”
PROMPT_ABOVE = “FRIGHT_TERMS”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “22”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_CARRIER”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “22”
UPLOAD_PARAM_LIST_ITEM_NUM = “22”
PROMPT_LEFT = “CARRIER”
PROMPT_ABOVE = “CARRIER”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “23”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_DESCRIPTION”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “23”
UPLOAD_PARAM_LIST_ITEM_NUM = “23”
PROMPT_LEFT = “DESCRIPTION”
PROMPT_ABOVE = “DESCRIPTION”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “24”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_LINE_NUM”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “1”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “24”
UPLOAD_PARAM_LIST_ITEM_NUM = “24”
PROMPT_LEFT = “LINE_NUM”
PROMPT_ABOVE = “LINE_NUM”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “25”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_LINE_TYPE”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “25”
UPLOAD_PARAM_LIST_ITEM_NUM = “25”
PROMPT_LEFT = “LINE_TYPE”
PROMPT_ABOVE = “LINE_TYPE”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “26”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_ITEM”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “26”
UPLOAD_PARAM_LIST_ITEM_NUM = “26”
PROMPT_LEFT = “ITEM”
PROMPT_ABOVE = “ITEM”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “27”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_ITEM_CATEGORY”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “27”
UPLOAD_PARAM_LIST_ITEM_NUM = “27”
PROMPT_LEFT = “ITEM_CATEGORY”
PROMPT_ABOVE = “ITEM_CATEGORY”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “28”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “2”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_ITEM_DESCRIPTION”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “N”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “28”
UPLOAD_PARAM_LIST_ITEM_NUM = “28”
PROMPT_LEFT = “ITEM_DESCRIPTION”
PROMPT_ABOVE = “ITEM_DESCRIPTION”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “29”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_UOM”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “29”
UPLOAD_PARAM_LIST_ITEM_NUM = “29”
PROMPT_LEFT = “UOM”
PROMPT_ABOVE = “UOM”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “30”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_QUANTITY”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “1”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “30”
UPLOAD_PARAM_LIST_ITEM_NUM = “30”
PROMPT_LEFT = “QUANTITY”
PROMPT_ABOVE = “QUANTITY”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “31”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_PRICE”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “1”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “31”
UPLOAD_PARAM_LIST_ITEM_NUM = “31”
PROMPT_LEFT = “PRICE”
PROMPT_ABOVE = “PRICE”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “32”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_PROMISE_DATE”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “3”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “32”
UPLOAD_PARAM_LIST_ITEM_NUM = “32”
PROMPT_LEFT = “PROMISE_DATE”
PROMPT_ABOVE = “PROMISE_DATE”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “33”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_NEED_BY_DATE”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “3”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “33”
UPLOAD_PARAM_LIST_ITEM_NUM = “33”
PROMPT_LEFT = “NEED_BY_DATE”
PROMPT_ABOVE = “NEED_BY_DATE”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “34”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_SHIP_TO_ORG”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “34”
UPLOAD_PARAM_LIST_ITEM_NUM = “34”
PROMPT_LEFT = “SHIP_TO_ORG”
PROMPT_ABOVE = “SHIP_TO_ORG”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “35”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “3”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_SHIPMENT_NUM”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “1”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “35”
UPLOAD_PARAM_LIST_ITEM_NUM = “35”
PROMPT_LEFT = “SHIPMENT_NUM”
PROMPT_ABOVE = “SHIPMENT_NUM”
LAST_UPDATE_DATE = “2020/08/05”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “36”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “3”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_DISTRIBUTION_NUM”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “1”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “36”
UPLOAD_PARAM_LIST_ITEM_NUM = “36”
PROMPT_LEFT = “DISTRIBUTION_NUM”
PROMPT_ABOVE = “DISTRIBUTION_NUM”
LAST_UPDATE_DATE = “2020/08/05”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “37”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_SEGMENT1”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “37”
UPLOAD_PARAM_LIST_ITEM_NUM = “37”
PROMPT_LEFT = “SEGMENT1”
PROMPT_ABOVE = “SEGMENT1”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “38”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_SEGMENT2”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “38”
UPLOAD_PARAM_LIST_ITEM_NUM = “38”
PROMPT_LEFT = “SEGMENT2”
PROMPT_ABOVE = “SEGMENT2”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “39”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_SEGMENT3”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “39”
UPLOAD_PARAM_LIST_ITEM_NUM = “39”
PROMPT_LEFT = “SEGMENT3”
PROMPT_ABOVE = “SEGMENT3”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “40”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_SEGMENT4”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “40”
UPLOAD_PARAM_LIST_ITEM_NUM = “40”
PROMPT_LEFT = “SEGMENT4”
PROMPT_ABOVE = “SEGMENT4”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “41”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_SEGMENT5”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “41”
UPLOAD_PARAM_LIST_ITEM_NUM = “41”
PROMPT_LEFT = “SEGMENT5”
PROMPT_ABOVE = “SEGMENT5”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “42”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_SEGMENT6”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “42”
UPLOAD_PARAM_LIST_ITEM_NUM = “42”
PROMPT_LEFT = “SEGMENT6”
PROMPT_ABOVE = “SEGMENT6”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “43”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_SEGMENT7”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “43”
UPLOAD_PARAM_LIST_ITEM_NUM = “43”
PROMPT_LEFT = “SEGMENT7”
PROMPT_ABOVE = “SEGMENT7”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “44”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “3”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_SEGMENT8”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “44”
UPLOAD_PARAM_LIST_ITEM_NUM = “44”
PROMPT_LEFT = “SEGMENT8”
PROMPT_ABOVE = “SEGMENT8”
LAST_UPDATE_DATE = “2020/09/03”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “45”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “4”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_SEGMENT9”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “45”
UPLOAD_PARAM_LIST_ITEM_NUM = “45”
PROMPT_LEFT = “CONCAT_SEGMENTS”
PROMPT_ABOVE = “CONCAT_SEGMENTS”
LAST_UPDATE_DATE = “2020/09/07”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “46”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “4”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_SEGMENT10”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “46”
UPLOAD_PARAM_LIST_ITEM_NUM = “46”
PROMPT_LEFT = “BATCH_MODE”
PROMPT_ABOVE = “BATCH_MODE”
LAST_UPDATE_DATE = “2020/09/07”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “47”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “4”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_ATTRIBUTE1”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “47”
UPLOAD_PARAM_LIST_ITEM_NUM = “47”
PROMPT_LEFT = “SHIP_TO_LOCATION_CODE”
PROMPT_ABOVE = “SHIP_TO_LOCATION_CODE”
LAST_UPDATE_DATE = “2020/08/01”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “48”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “2”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_ATTRIBUTE2”
ENABLED_FLAG = “N”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “48”
UPLOAD_PARAM_LIST_ITEM_NUM = “48”
PROMPT_LEFT = “ATTRIBUTE2”
PROMPT_ABOVE = “ATTRIBUTE2”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “49”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “2”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_ATTRIBUTE3”
ENABLED_FLAG = “N”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “49”
UPLOAD_PARAM_LIST_ITEM_NUM = “49”
PROMPT_LEFT = “ATTRIBUTE3”
PROMPT_ABOVE = “ATTRIBUTE3”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “50”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “2”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_ATTRIBUTE4”
ENABLED_FLAG = “N”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “50”
UPLOAD_PARAM_LIST_ITEM_NUM = “50”
PROMPT_LEFT = “ATTRIBUTE4”
PROMPT_ABOVE = “ATTRIBUTE4”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “51”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “2”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_ATTRIBUTE5”
ENABLED_FLAG = “N”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “51”
UPLOAD_PARAM_LIST_ITEM_NUM = “51”
PROMPT_LEFT = “ATTRIBUTE5”
PROMPT_ABOVE = “ATTRIBUTE5”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “52”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “2”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_ATTRIBUTE6”
ENABLED_FLAG = “N”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “52”
UPLOAD_PARAM_LIST_ITEM_NUM = “52”
PROMPT_LEFT = “ATTRIBUTE6”
PROMPT_ABOVE = “ATTRIBUTE6”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “53”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “2”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_ATTRIBUTE7”
ENABLED_FLAG = “N”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “53”
UPLOAD_PARAM_LIST_ITEM_NUM = “53”
PROMPT_LEFT = “ATTRIBUTE7”
PROMPT_ABOVE = “ATTRIBUTE7”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “54”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “2”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_ATTRIBUTE8”
ENABLED_FLAG = “N”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “54”
UPLOAD_PARAM_LIST_ITEM_NUM = “54”
PROMPT_LEFT = “ATTRIBUTE8”
PROMPT_ABOVE = “ATTRIBUTE8”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “55”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “2”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_ATTRIBUTE9”
ENABLED_FLAG = “N”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “55”
UPLOAD_PARAM_LIST_ITEM_NUM = “55”
PROMPT_LEFT = “ATTRIBUTE9”
PROMPT_ABOVE = “ATTRIBUTE9”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “56”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “2”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_ATTRIBUTE10”
ENABLED_FLAG = “N”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “Y”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “2”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “56”
UPLOAD_PARAM_LIST_ITEM_NUM = “56”
PROMPT_LEFT = “ATTRIBUTE10”
PROMPT_ABOVE = “ATTRIBUTE10”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “57”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “2”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_USER_ID”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “N”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “1”
DEFAULT_TYPE = “SQL”
DEFAULT_VALUE = “SELECT FND_PROFILE.VALUE(‘USER_ID’) FROM DUAL”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “57”
UPLOAD_PARAM_LIST_ITEM_NUM = “57”
PROMPT_LEFT = “USER_ID”
PROMPT_ABOVE = “USER_ID”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
BEGIN BNE_INTERFACE_COLS “58”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “2”
INTERFACE_COL_TYPE = “1”
INTERFACE_COL_NAME = “P_RESP_ID”
ENABLED_FLAG = “Y”
REQUIRED_FLAG = “N”
DISPLAY_FLAG = “N”
READ_ONLY_FLAG = “N”
NOT_NULL_FLAG = “N”
SUMMARY_FLAG = “N”
MAPPING_ENABLED_FLAG = “Y”
DATA_TYPE = “1”
DEFAULT_TYPE = “SQL”
DEFAULT_VALUE = “SELECT FND_PROFILE.VALUE(‘RESP_ID’) FROM DUAL”
VAL_COMPONENT = “” “”
DISPLAY_ORDER = “58”
UPLOAD_PARAM_LIST_ITEM_NUM = “58”
PROMPT_LEFT = “RESP_ID”
PROMPT_ABOVE = “RESP_ID”
LAST_UPDATE_DATE = “2020/07/31”
VAL_QUERY = “” “”
EXPANDED_SQL = “” “”
END BNE_INTERFACE_COLS
END BNE_INTERFACES
BEGIN BNE_LAYOUTS “PO” “XXDSPURCHASEORDERINTERFACELAYO”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “12”
STYLESHEET_ASN = “BNE”
STYLESHEET_CODE = “DEFAULT”
STYLE = “protected:Y:BOOLEAN;”
STYLE_CLASS = “BNE_PAGE”
REPORTING_FLAG = “N”
USER_NAME = “XXDS:Purchase Order Interface Layout”
LAST_UPDATE_DATE = “2020/09/07”
CREATE_DOC = “” “”
BEGIN BNE_LAYOUT_BLOCKS “1”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
LAYOUT_ELEMENT = “HEADER 1”
STYLE_CLASS = “BNE_HEADER”
ROW_STYLE_CLASS = “BNE_HEADER_ROW”
PROMPT_DISPLAYED_FLAG = “Y”
PROMPT_STYLE_CLASS = “BNE_HEADER_HEADER”
HINT_DISPLAYED_FLAG = “Y”
HINT_STYLE_CLASS = “BNE_HEADER_HINT”
ORIENTATION = “HORIZONTAL”
LAYOUT_CONTROL = “COLUMN_FLOW”
DISPLAY_FLAG = “Y”
BLOCKSIZE = “1”
MINSIZE = “1”
MAXSIZE = “1”
SEQUENCE_NUM = “1”
PROMPT_COLSPAN = “2”
HINT_COLSPAN = “1”
ROW_COLSPAN = “2”
SUMMARY_STYLE_CLASS = “BNE_LINES_TOTAL”
USER_NAME = “Header 1”
LAST_UPDATE_DATE = “2020/09/07”
TITLE_STYLE_CLASS = “TITLE”
BEGIN BNE_LAYOUT_COLS “10”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “1”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “Y”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “20”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “3”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “Y”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “30”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “7”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “40”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “14”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
END BNE_LAYOUT_BLOCKS
BEGIN BNE_LAYOUT_BLOCKS “2”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
PARENT_ID = “1”
LAYOUT_ELEMENT = “LINE”
STYLE_CLASS = “BNE_LINES”
ROW_STYLE_CLASS = “BNE_LINES_ROW”
PROMPT_DISPLAYED_FLAG = “Y”
PROMPT_STYLE_CLASS = “BNE_LINES_HEADER”
HINT_DISPLAYED_FLAG = “Y”
HINT_STYLE_CLASS = “BNE_LINES_HINT”
ORIENTATION = “VERTICAL”
LAYOUT_CONTROL = “TABLE_FLOW”
DISPLAY_FLAG = “Y”
BLOCKSIZE = “100”
MINSIZE = “1”
MAXSIZE = “1”
SEQUENCE_NUM = “2”
PROMPT_COLSPAN = “2”
HINT_COLSPAN = “1”
ROW_COLSPAN = “2”
SUMMARY_STYLE_CLASS = “BNE_LINES_TOTAL”
USER_NAME = “Line”
LAST_UPDATE_DATE = “2020/09/07”
TITLE_STYLE_CLASS = “TITLE”
BEGIN BNE_LAYOUT_COLS “50”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “5”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “60”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “6”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “70”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “8”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “80”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “9”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “90”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “10”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “100”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “11”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “110”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “12”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “120”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “47”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “130”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “13”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “140”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “15”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “150”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “17”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “160”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “16”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “170”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “18”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “180”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “19”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “190”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “20”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “200”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “21”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “210”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “22”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “220”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “23”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “230”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “24”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “240”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “25”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “250”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “26”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “260”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “27”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “270”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “29”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “280”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “30”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “290”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “31”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “300”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “32”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “310”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “33”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “320”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “34”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “330”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “35”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “340”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “36”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “350”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “46”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “360”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “45”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “370”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “37”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “380”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “38”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “390”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “39”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “400”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “40”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “410”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “41”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “420”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “42”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “430”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “43”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
READ_ONLY_FLAG = “N”
END BNE_LAYOUT_COLS
END BNE_LAYOUT_BLOCKS
END BNE_LAYOUTS
BEGIN BNE_CONTENTS “PO” “XXDS_PO_IFACE_WEDAI_CNT1”
OBJECT_VERSION_NUMBER = “1”
OWNER = “OPERATIONS”
CONTENT = “” “”
USER_NAME = “NONE”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_CONTENTS
END BNE_INTEGRATORS
Layout LDT
# $Header$
# dbdrv: exec fnd bin FNDLOAD bin &phase=daa+52 checkfile:~PROD:~PATH:~FILE &ui_apps 0 Y UPLOAD @BNE:patch/115/import/bnelay.lct @~PROD:~PATH/~FILE
LANGUAGE = “US”
LDRCONFIG = “bnelay.lct 120.0”
#Source Database EBSNEW
#RELEASE_NAME 12.1.3
# — Begin Entity Definitions —
DEFINE BNE_LAYOUTS
KEY LAYOUT_ASN VARCHAR2(120)
KEY LAYOUT_CODE VARCHAR2(30)
CTX OWNER VARCHAR2(120)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE STYLESHEET_ASN VARCHAR2(120)
BASE STYLESHEET_CODE VARCHAR2(30)
BASE INTEGRATOR_ASN VARCHAR2(120)
BASE INTEGRATOR_CODE VARCHAR2(50)
BASE STYLE VARCHAR2(2000)
BASE STYLE_CLASS VARCHAR2(50)
BASE REPORTING_FLAG VARCHAR2(1)
BASE REPORTING_INTERFACE_ASN VARCHAR2(120)
BASE REPORT_INTERFACE_CODE VARCHAR2(30)
TRANS USER_NAME VARCHAR2(240)
BASE LAST_UPDATE_DATE VARCHAR2(10)
BASE CREATE_DOC_LIST_ASN VARCHAR2(120)
BASE CREATE_DOC_LIST_CODE VARCHAR2(30)
DEFINE BNE_LAYOUT_BLOCKS
KEY BLOCK_ID VARCHAR2(50)
CTX OWNER VARCHAR2(120)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE PARENT_ID VARCHAR2(50)
BASE LAYOUT_ELEMENT VARCHAR2(240)
BASE STYLE_CLASS VARCHAR2(50)
BASE STYLE VARCHAR2(2000)
BASE ROW_STYLE_CLASS VARCHAR2(50)
BASE ROW_STYLE VARCHAR2(2000)
BASE COL_STYLE_CLASS VARCHAR2(50)
BASE COL_STYLE VARCHAR2(2000)
BASE PROMPT_DISPLAYED_FLAG VARCHAR2(1)
BASE PROMPT_STYLE_CLASS VARCHAR2(50)
BASE PROMPT_STYLE VARCHAR2(2000)
BASE HINT_DISPLAYED_FLAG VARCHAR2(1)
BASE HINT_STYLE_CLASS VARCHAR2(50)
BASE HINT_STYLE VARCHAR2(2000)
BASE ORIENTATION VARCHAR2(20)
BASE LAYOUT_CONTROL VARCHAR2(20)
BASE DISPLAY_FLAG VARCHAR2(1)
BASE BLOCKSIZE VARCHAR2(50)
BASE MINSIZE VARCHAR2(50)
BASE MAXSIZE VARCHAR2(50)
BASE SEQUENCE_NUM VARCHAR2(50)
BASE PROMPT_COLSPAN VARCHAR2(50)
BASE HINT_COLSPAN VARCHAR2(50)
BASE ROW_COLSPAN VARCHAR2(50)
BASE SUMMARY_STYLE_CLASS VARCHAR2(50)
BASE SUMMARY_STYLE VARCHAR2(2000)
TRANS USER_NAME VARCHAR2(240)
BASE LAST_UPDATE_DATE VARCHAR2(10)
DEFINE BNE_LAYOUT_COLS
KEY SEQUENCE_NUM VARCHAR2(50)
CTX OWNER VARCHAR2(120)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE INTERFACE_ASN VARCHAR2(120)
BASE INTERFACE_CODE VARCHAR2(30)
BASE INTERFACE_SEQ_NUM VARCHAR2(50)
BASE STYLE_CLASS VARCHAR2(50)
BASE STYLE VARCHAR2(2000)
BASE PROMPT_STYLE_CLASS VARCHAR2(50)
BASE PROMPT_STYLE VARCHAR2(2000)
BASE HINT_STYLE_CLASS VARCHAR2(50)
BASE HINT_STYLE VARCHAR2(2000)
BASE DEFAULT_VALUE VARCHAR2(2000)
BASE DEFAULT_TYPE VARCHAR2(30)
BASE DISPLAY_WIDTH VARCHAR2(50)
BASE LAST_UPDATE_DATE VARCHAR2(10)
END BNE_LAYOUT_COLS
END BNE_LAYOUT_BLOCKS
END BNE_LAYOUTS
# — End Entity Definitions —
BEGIN BNE_LAYOUTS “PO” “XXDSPURCHASEORDERINTERFACELAYO”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “12”
STYLESHEET_ASN = “BNE”
STYLESHEET_CODE = “DEFAULT”
INTEGRATOR_ASN = “PO”
INTEGRATOR_CODE = “XXDS_PO_IFACE_WEDAI_XINTG”
STYLE = “protected:Y:BOOLEAN;”
STYLE_CLASS = “BNE_PAGE”
REPORTING_FLAG = “N”
USER_NAME = “XXDS:Purchase Order Interface Layout”
LAST_UPDATE_DATE = “2020/09/07”
BEGIN BNE_LAYOUT_BLOCKS “1”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
LAYOUT_ELEMENT = “HEADER 1”
STYLE_CLASS = “BNE_HEADER”
ROW_STYLE_CLASS = “BNE_HEADER_ROW”
PROMPT_DISPLAYED_FLAG = “Y”
PROMPT_STYLE_CLASS = “BNE_HEADER_HEADER”
HINT_DISPLAYED_FLAG = “Y”
HINT_STYLE_CLASS = “BNE_HEADER_HINT”
ORIENTATION = “HORIZONTAL”
LAYOUT_CONTROL = “COLUMN_FLOW”
DISPLAY_FLAG = “Y”
BLOCKSIZE = “1”
MINSIZE = “1”
MAXSIZE = “1”
SEQUENCE_NUM = “1”
PROMPT_COLSPAN = “2”
HINT_COLSPAN = “1”
ROW_COLSPAN = “2”
SUMMARY_STYLE_CLASS = “BNE_LINES_TOTAL”
USER_NAME = “Header 1”
LAST_UPDATE_DATE = “2020/09/07”
BEGIN BNE_LAYOUT_COLS “10”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “1”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “20”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “3”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “30”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “7”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “40”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “14”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
END BNE_LAYOUT_BLOCKS
BEGIN BNE_LAYOUT_BLOCKS “2”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
PARENT_ID = “1”
LAYOUT_ELEMENT = “LINE”
STYLE_CLASS = “BNE_LINES”
ROW_STYLE_CLASS = “BNE_LINES_ROW”
PROMPT_DISPLAYED_FLAG = “Y”
PROMPT_STYLE_CLASS = “BNE_LINES_HEADER”
HINT_DISPLAYED_FLAG = “Y”
HINT_STYLE_CLASS = “BNE_LINES_HINT”
ORIENTATION = “VERTICAL”
LAYOUT_CONTROL = “TABLE_FLOW”
DISPLAY_FLAG = “Y”
BLOCKSIZE = “100”
MINSIZE = “1”
MAXSIZE = “1”
SEQUENCE_NUM = “2”
PROMPT_COLSPAN = “2”
HINT_COLSPAN = “1”
ROW_COLSPAN = “2”
SUMMARY_STYLE_CLASS = “BNE_LINES_TOTAL”
USER_NAME = “Line”
LAST_UPDATE_DATE = “2020/09/07”
BEGIN BNE_LAYOUT_COLS “50”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “5”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “60”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “6”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “70”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “8”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “80”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “9”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “90”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “10”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “100”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “11”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “110”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “12”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “120”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “47”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “130”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “13”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “140”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “15”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “150”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “17”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “160”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “16”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “170”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “18”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “180”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “19”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “190”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “20”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “200”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “21”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “210”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “22”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “220”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “23”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “230”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “24”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “240”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “25”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “250”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “26”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “260”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “27”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “270”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “29”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “280”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “30”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “290”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “31”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “300”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “32”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “310”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “33”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “320”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “34”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “330”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “35”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “340”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “36”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “350”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “46”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “360”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “45”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “370”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “37”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “380”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “38”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “390”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “39”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “400”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “40”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “410”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “41”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “420”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “42”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
BEGIN BNE_LAYOUT_COLS “430”
OWNER = “OPERATIONS”
OBJECT_VERSION_NUMBER = “1”
INTERFACE_ASN = “PO”
INTERFACE_CODE = “XXDS_PO_IFACE_WEDAI_XI_INTF1”
INTERFACE_SEQ_NUM = “43”
DISPLAY_WIDTH = “15”
LAST_UPDATE_DATE = “2020/09/07”
END BNE_LAYOUT_COLS
END BNE_LAYOUT_BLOCKS
END BNE_LAYOUTS
Parameter LDT
# $Header$
# dbdrv: exec fnd bin FNDLOAD bin &phase=daa+52 checkfile:~PROD:~PATH:~FILE &ui_apps 0 Y UPLOAD @BNE:patch/115/import/bneparamlist.lct @~PROD:~PATH/~FILE
LANGUAGE = “US”
LDRCONFIG = “bneparamlist.lct 120.0”
#Source Database EBSNEW
#RELEASE_NAME 12.1.3
# — Begin Entity Definitions —
DEFINE BNE_PARAM_LISTS
KEY PARAM_LIST_ASN VARCHAR2(120)
KEY PARAM_LIST_CODE VARCHAR2(30)
CTX OWNER VARCHAR2(120)
BASE LAST_UPDATE_DATE VARCHAR2(10)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE PERSISTENT_FLAG VARCHAR2(1)
BASE COMMENTS VARCHAR2(240)
BASE LIST REFERENCES BNE_ATTRIBUTES
BASE LIST_RESOLVER VARCHAR2(240)
TRANS USER_TIP VARCHAR2(2000)
TRANS PROMPT_LEFT VARCHAR2(240)
TRANS PROMPT_ABOVE VARCHAR2(240)
TRANS USER_NAME VARCHAR2(240)
DEFINE BNE_PARAM_GROUPS
KEY GROUP_SEQ_NUM VARCHAR2(50)
CTX OWNER VARCHAR2(120)
BASE LAST_UPDATE_DATE VARCHAR2(10)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE GROUP_ITEM REFERENCES BNE_ATTRIBUTES
BASE GROUP_RESOLVER VARCHAR2(240)
TRANS USER_NAME VARCHAR2(240)
DEFINE BNE_PARAM_GROUP_ITEMS
KEY SEQUENCE_NUM VARCHAR2(50)
CTX OWNER VARCHAR2(120)
BASE LAST_UPDATE_DATE VARCHAR2(10)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE PARAM_SEQ_NUM VARCHAR2(50)
END BNE_PARAM_GROUP_ITEMS
END BNE_PARAM_GROUPS
DEFINE BNE_PARAM_LIST_ITEMS
KEY SEQUENCE_NUM VARCHAR2(50)
CTX OWNER VARCHAR2(120)
BASE LAST_UPDATE_DATE VARCHAR2(10)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE DEFN REFERENCES BNE_PARAM_DEFNS
BASE PARAM_NAME VARCHAR2(240)
BASE LIST_ITEM REFERENCES BNE_ATTRIBUTES
BASE STRING_VALUE VARCHAR2(2000)
BASE DATE_VALUE VARCHAR2(19)
BASE NUMBER_VALUE VARCHAR2(50)
BASE BOOLEAN_VALUE_FLAG VARCHAR2(1)
BASE FORMULA_VALUE VARCHAR2(240)
BASE DESC_VALUE VARCHAR2(240)
END BNE_PARAM_LIST_ITEMS
END BNE_PARAM_LISTS
DEFINE BNE_ATTRIBUTES
KEY ATTRIBUTE_ASN VARCHAR2(120)
KEY ATTRIBUTE_CODE VARCHAR2(30)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE ATTRIBUTE1 VARCHAR2(2000)
BASE ATTRIBUTE2 VARCHAR2(2000)
BASE ATTRIBUTE3 VARCHAR2(2000)
BASE ATTRIBUTE4 VARCHAR2(2000)
BASE ATTRIBUTE5 VARCHAR2(2000)
BASE ATTRIBUTE6 VARCHAR2(2000)
BASE ATTRIBUTE7 VARCHAR2(2000)
BASE ATTRIBUTE8 VARCHAR2(2000)
BASE ATTRIBUTE9 VARCHAR2(2000)
BASE ATTRIBUTE10 VARCHAR2(2000)
BASE ATTRIBUTE11 VARCHAR2(2000)
BASE ATTRIBUTE12 VARCHAR2(2000)
BASE ATTRIBUTE13 VARCHAR2(2000)
BASE ATTRIBUTE14 VARCHAR2(2000)
BASE ATTRIBUTE15 VARCHAR2(2000)
BASE ATTRIBUTE16 VARCHAR2(2000)
BASE ATTRIBUTE17 VARCHAR2(2000)
BASE ATTRIBUTE18 VARCHAR2(2000)
BASE ATTRIBUTE19 VARCHAR2(2000)
BASE ATTRIBUTE20 VARCHAR2(2000)
BASE ATTRIBUTE21 VARCHAR2(2000)
BASE ATTRIBUTE22 VARCHAR2(2000)
BASE ATTRIBUTE23 VARCHAR2(2000)
BASE ATTRIBUTE24 VARCHAR2(2000)
BASE ATTRIBUTE25 VARCHAR2(2000)
BASE ATTRIBUTE26 VARCHAR2(2000)
BASE ATTRIBUTE27 VARCHAR2(2000)
BASE ATTRIBUTE28 VARCHAR2(2000)
BASE ATTRIBUTE29 VARCHAR2(2000)
BASE ATTRIBUTE30 VARCHAR2(2000)
CTX OWNER VARCHAR2(120)
BASE LAST_UPDATE_DATE VARCHAR2(10)
BASE ATTRIBUTE_NAME1 VARCHAR2(30)
BASE ATTRIBUTE_NAME2 VARCHAR2(30)
BASE ATTRIBUTE_NAME3 VARCHAR2(30)
BASE ATTRIBUTE_NAME4 VARCHAR2(30)
BASE ATTRIBUTE_NAME5 VARCHAR2(30)
BASE ATTRIBUTE_NAME6 VARCHAR2(30)
BASE ATTRIBUTE_NAME7 VARCHAR2(30)
BASE ATTRIBUTE_NAME8 VARCHAR2(30)
BASE ATTRIBUTE_NAME9 VARCHAR2(30)
BASE ATTRIBUTE_NAME10 VARCHAR2(30)
BASE ATTRIBUTE_NAME11 VARCHAR2(30)
BASE ATTRIBUTE_NAME12 VARCHAR2(30)
BASE ATTRIBUTE_NAME13 VARCHAR2(30)
BASE ATTRIBUTE_NAME14 VARCHAR2(30)
BASE ATTRIBUTE_NAME15 VARCHAR2(30)
BASE ATTRIBUTE_NAME16 VARCHAR2(30)
BASE ATTRIBUTE_NAME17 VARCHAR2(30)
BASE ATTRIBUTE_NAME18 VARCHAR2(30)
BASE ATTRIBUTE_NAME19 VARCHAR2(30)
BASE ATTRIBUTE_NAME20 VARCHAR2(30)
BASE ATTRIBUTE_NAME21 VARCHAR2(30)
BASE ATTRIBUTE_NAME22 VARCHAR2(30)
BASE ATTRIBUTE_NAME23 VARCHAR2(30)
BASE ATTRIBUTE_NAME24 VARCHAR2(30)
BASE ATTRIBUTE_NAME25 VARCHAR2(30)
BASE ATTRIBUTE_NAME26 VARCHAR2(30)
BASE ATTRIBUTE_NAME27 VARCHAR2(30)
BASE ATTRIBUTE_NAME28 VARCHAR2(30)
BASE ATTRIBUTE_NAME29 VARCHAR2(30)
BASE ATTRIBUTE_NAME30 VARCHAR2(30)
END BNE_ATTRIBUTES
DEFINE BNE_PARAM_DEFNS
KEY PARAM_DEFN_ASN VARCHAR2(120)
KEY PARAM_DEFN_CODE VARCHAR2(30)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE PARAM_NAME VARCHAR2(240)
BASE PARAM_SOURCE VARCHAR2(240)
BASE PARAM_CATEGORY VARCHAR2(50)
BASE DATATYPE VARCHAR2(50)
BASE DEFN REFERENCES BNE_ATTRIBUTES
BASE PARAM_RESOLVER VARCHAR2(240)
BASE DEFAULT_REQUIRED_FLAG VARCHAR2(1)
BASE DEFAULT_VISIBLE_FLAG VARCHAR2(1)
BASE DEFAULT_USER_MODIFYABLE_FLAG VARCHAR2(1)
BASE DEFAULT_STRING VARCHAR2(2000)
TRANS DEFAULT_STRING_TRANS VARCHAR2(2000)
BASE DEFAULT_STRING_TRANS_FLAG VARCHAR2(1)
BASE DEFAULT_DATE VARCHAR2(19)
BASE DEFAULT_NUMBER VARCHAR2(50)
BASE DEFAULT_BOOLEAN_FLAG VARCHAR2(1)
BASE DEFAULT_FORMULA VARCHAR2(240)
BASE VAL_TYPE VARCHAR2(30)
BASE VAL_VALUE VARCHAR2(30)
BASE MAX_SIZE VARCHAR2(50)
BASE DISPLAY_TYPE VARCHAR2(50)
BASE DISPLAY_STYLE VARCHAR2(50)
BASE DISPLAY_SIZE VARCHAR2(50)
BASE HELP_URL VARCHAR2(240)
BASE FORMAT_MASK VARCHAR2(240)
TRANS USER_NAME VARCHAR2(240)
TRANS DEFAULT_DESC VARCHAR2(240)
TRANS PROMPT_LEFT VARCHAR2(240)
TRANS PROMPT_ABOVE VARCHAR2(240)
TRANS USER_TIP VARCHAR2(2000)
TRANS ACCESS_KEY VARCHAR2(30)
CTX OWNER VARCHAR2(120)
BASE LAST_UPDATE_DATE VARCHAR2(10)
DEFINE BNE_PARAM_DEFN_OVERRIDES
KEY LVL VARCHAR2(50)
KEY OVERRIDE_ID VARCHAR2(50)
BASE OBJECT_VERSION_NUMBER VARCHAR2(50)
BASE REQUIRED_FLAG VARCHAR2(1)
BASE VISIBLE_FLAG VARCHAR2(1)
BASE USER_MODIFYABLE_FLAG VARCHAR2(1)
BASE DEFAULT_STRING VARCHAR2(2000)
BASE DEFAULT_DATE VARCHAR2(19)
BASE DEFAULT_NUMBER VARCHAR2(50)
BASE DEFAULT_BOOLEAN_FLAG VARCHAR2(1)
BASE DEFAULT_FORMULA VARCHAR2(240)
BASE DESC_VALUE VARCHAR2(240)
CTX OWNER VARCHAR2(120)
BASE LAST_UPDATE_DATE VARCHAR2(10)
END BNE_PARAM_DEFN_OVERRIDES
END BNE_PARAM_DEFNS
# — End Entity Definitions —
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A0”
OBJECT_VERSION_NUMBER = “4”
ATTRIBUTE1 = “PROCEDURE”
ATTRIBUTE2 = “XXDS_PO_IFACE_PKG.INSERT_WEB_ADI_TL”
ATTRIBUTE5 = “Y”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/08/04”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A1”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_BATCH_ID”
ATTRIBUTE2 = “NUMBER”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A2”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_MODE”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A3”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_ORG_NAME”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A4”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_ORG_ID”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A5”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_PO_NUMBER”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A6”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_CREATION_DATE”
ATTRIBUTE2 = “DATE”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A7”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_DOCUMENT_TYPE_CODE”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A8”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_VENDOR_NAME”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A9”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_VENDRO_SITE_CODE”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A10”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_SHIP_TO”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A11”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_BILL_TO”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A12”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_VENDOR_CONTACT_NAME”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A13”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_AGENT_NAME”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A14”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_APPROVAL_STATUS”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A15”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_TOTAL”
ATTRIBUTE2 = “NUMBER”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A16”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_CURRENCY”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A17”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_CONVERSION_TYPE”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A18”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_CONVERSION_RATE”
ATTRIBUTE2 = “NUMBER”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A19”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_CONVERSION_DATE”
ATTRIBUTE2 = “DATE”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A20”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_TERMS”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A21”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_FRIGHT_TERMS”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A22”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_CARRIER”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A23”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_DESCRIPTION”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A24”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_LINE_NUM”
ATTRIBUTE2 = “NUMBER”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A25”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_LINE_TYPE”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A26”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_ITEM”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A27”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_ITEM_CATEGORY”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A28”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_ITEM_DESCRIPTION”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A29”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_UOM”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A30”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_QUANTITY”
ATTRIBUTE2 = “NUMBER”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A31”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_PRICE”
ATTRIBUTE2 = “NUMBER”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A32”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_PROMISE_DATE”
ATTRIBUTE2 = “DATE”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A33”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_NEED_BY_DATE”
ATTRIBUTE2 = “DATE”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A34”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_SHIP_TO_ORG”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A35”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_SHIPMENT_NUM”
ATTRIBUTE2 = “NUMBER”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A36”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_DISTRIBUTION_NUM”
ATTRIBUTE2 = “NUMBER”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A37”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_SEGMENT1”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A38”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_SEGMENT2”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A39”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_SEGMENT3”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A40”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_SEGMENT4”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A41”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_SEGMENT5”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A42”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_SEGMENT6”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A43”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_SEGMENT7”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A44”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_SEGMENT8”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A45”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_SEGMENT9”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A46”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_SEGMENT10”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A47”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_ATTRIBUTE1”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A48”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_ATTRIBUTE2”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A49”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_ATTRIBUTE3”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A50”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_ATTRIBUTE4”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A51”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_ATTRIBUTE5”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A52”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_ATTRIBUTE6”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A53”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_ATTRIBUTE7”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A54”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_ATTRIBUTE8”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A55”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_ATTRIBUTE9”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A56”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_ATTRIBUTE10”
ATTRIBUTE2 = “VARCHAR2”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
ATTRIBUTE6 = “2000”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A57”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_USER_ID”
ATTRIBUTE2 = “NUMBER”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_ATTRIBUTES “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A58”
OBJECT_VERSION_NUMBER = “1”
ATTRIBUTE1 = “P_RESP_ID”
ATTRIBUTE2 = “NUMBER”
ATTRIBUTE3 = “IN”
ATTRIBUTE4 = “N”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
END BNE_ATTRIBUTES
BEGIN BNE_PARAM_LISTS “PO” “XXDS_PO_IFACE_WEDAI_XI_UPL1”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
PERSISTENT_FLAG = “Y”
COMMENTS = “Parameter List for Interface XXDS_PO_IFACE_WEDAI_XI_INTF1”
LIST = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A0”
USER_NAME = “Parameter List for Interface XXDS_PO_IFACE_WEDAI_XI_INTF1”
BEGIN BNE_PARAM_LIST_ITEMS “1”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_BATCH_ID”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A1”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “2”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_MODE”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A2”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “3”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_ORG_NAME”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A3”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “4”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_ORG_ID”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A4”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “5”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_PO_NUMBER”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A5”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “6”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_CREATION_DATE”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A6”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “7”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_DOCUMENT_TYPE_CODE”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A7”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “8”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_VENDOR_NAME”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A8”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “9”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_VENDRO_SITE_CODE”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A9”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “10”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_SHIP_TO”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A10”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “11”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_BILL_TO”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A11”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “12”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_VENDOR_CONTACT_NAME”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A12”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “13”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_AGENT_NAME”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A13”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “14”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_APPROVAL_STATUS”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A14”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “15”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_TOTAL”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A15”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “16”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_CURRENCY”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A16”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “17”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_CONVERSION_TYPE”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A17”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “18”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_CONVERSION_RATE”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A18”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “19”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_CONVERSION_DATE”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A19”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “20”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_TERMS”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A20”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “21”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_FRIGHT_TERMS”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A21”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “22”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_CARRIER”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A22”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “23”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_DESCRIPTION”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A23”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “24”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_LINE_NUM”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A24”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “25”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_LINE_TYPE”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A25”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “26”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_ITEM”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A26”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “27”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_ITEM_CATEGORY”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A27”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “28”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_ITEM_DESCRIPTION”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A28”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “29”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_UOM”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A29”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “30”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_QUANTITY”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A30”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “31”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_PRICE”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A31”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “32”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_PROMISE_DATE”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A32”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “33”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_NEED_BY_DATE”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A33”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “34”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_SHIP_TO_ORG”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A34”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “35”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_SHIPMENT_NUM”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A35”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “36”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_DISTRIBUTION_NUM”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A36”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “37”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_SEGMENT1”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A37”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “38”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_SEGMENT2”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A38”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “39”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_SEGMENT3”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A39”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “40”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_SEGMENT4”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A40”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “41”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_SEGMENT5”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A41”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “42”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_SEGMENT6”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A42”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “43”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_SEGMENT7”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A43”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “44”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_SEGMENT8”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A44”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “45”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_SEGMENT9”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A45”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “46”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_SEGMENT10”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A46”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “47”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_ATTRIBUTE1”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A47”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “48”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_ATTRIBUTE2”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A48”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “49”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_ATTRIBUTE3”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A49”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “50”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_ATTRIBUTE4”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A50”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “51”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_ATTRIBUTE5”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A51”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “52”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_ATTRIBUTE6”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A52”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “53”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_ATTRIBUTE7”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A53”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “54”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_ATTRIBUTE8”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A54”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “55”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_ATTRIBUTE9”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A55”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “56”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_ATTRIBUTE10”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A56”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “57”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_USER_ID”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A57”
END BNE_PARAM_LIST_ITEMS
BEGIN BNE_PARAM_LIST_ITEMS “58”
OWNER = “OPERATIONS”
LAST_UPDATE_DATE = “2020/07/31”
OBJECT_VERSION_NUMBER = “1”
DEFN = “” “”
PARAM_NAME = “P_RESP_ID”
LIST_ITEM = “PO” “XXDS_PO_IFACE_WEDAI_XI_UP_A58”
END BNE_PARAM_LIST_ITEMS
END BNE_PARAM_LISTS
Package Spec
xxds_po_iface_pkg
CREATE OR REPLACE PACKAGE APPS.xxds_po_iface_pkg
AS
— TYPE out_var_rec IS RECORD (
— org_id NUMBER,
— document_type_code VARCHAR2 (240),
— vendor_id NUMBER,
— vendor_site_id NUMBER,
— shipto_id NUMBER,
— billto_id NUMBER,
— buyer_id NUMBER,
— terms_id NUMBER,
— line_type_id NUMBER
— );
gc_module_prefix VARCHAR2 (240) := ‘apps.xxds_po_iface_pkg’;
gc_request_id NUMBER := fnd_global.conc_request_id;
PROCEDURE insert_web_adi_tl (
p_batch_id IN NUMBER,
p_mode IN VARCHAR2,
p_org_name IN VARCHAR2 DEFAULT NULL,
p_org_id IN VARCHAR2 DEFAULT NULL,
p_po_number IN VARCHAR2 DEFAULT NULL,
p_creation_date IN DATE DEFAULT NULL,
p_document_type_code IN VARCHAR2 DEFAULT NULL,
p_vendor_name IN VARCHAR2 DEFAULT NULL,
p_vendro_site_code IN VARCHAR2 DEFAULT NULL,
p_ship_to IN VARCHAR2 DEFAULT NULL,
p_bill_to IN VARCHAR2 DEFAULT NULL,
p_vendor_contact_name IN VARCHAR2 DEFAULT NULL,
p_agent_name IN VARCHAR2 DEFAULT NULL,
p_approval_status IN VARCHAR2 DEFAULT NULL,
p_total IN NUMBER DEFAULT NULL,
p_currency IN VARCHAR2 DEFAULT NULL,
p_conversion_type IN VARCHAR2 DEFAULT NULL,
p_conversion_rate IN NUMBER DEFAULT NULL,
p_conversion_date IN DATE DEFAULT NULL,
p_terms IN VARCHAR2 DEFAULT NULL,
p_fright_terms IN VARCHAR2 DEFAULT NULL,
p_carrier IN VARCHAR2 DEFAULT NULL,
p_description IN VARCHAR2 DEFAULT NULL,
p_line_num IN NUMBER DEFAULT NULL,
p_line_type IN VARCHAR2 DEFAULT NULL,
p_item IN VARCHAR2 DEFAULT NULL,
p_item_category IN VARCHAR2 DEFAULT NULL,
p_item_description IN VARCHAR2 DEFAULT NULL,
p_uom IN VARCHAR2 DEFAULT NULL,
p_quantity IN NUMBER DEFAULT NULL,
p_price IN NUMBER DEFAULT NULL,
p_promise_date IN DATE DEFAULT NULL,
p_need_by_date IN DATE DEFAULT NULL,
p_ship_to_org IN VARCHAR2 DEFAULT NULL,
p_shipment_num IN NUMBER DEFAULT NULL,
p_distribution_num IN NUMBER DEFAULT NULL,
p_segment1 IN VARCHAR2 DEFAULT NULL,
p_segment2 IN VARCHAR2 DEFAULT NULL,
p_segment3 IN VARCHAR2 DEFAULT NULL,
p_segment4 IN VARCHAR2 DEFAULT NULL,
p_segment5 IN VARCHAR2 DEFAULT NULL,
p_segment6 IN VARCHAR2 DEFAULT NULL,
p_segment7 IN VARCHAR2 DEFAULT NULL,
p_segment8 IN VARCHAR2 DEFAULT NULL,
p_segment9 IN VARCHAR2 DEFAULT NULL,
p_segment10 IN VARCHAR2 DEFAULT NULL,
p_attribute1 IN VARCHAR2 DEFAULT NULL,
p_attribute2 IN VARCHAR2 DEFAULT NULL,
p_attribute3 IN VARCHAR2 DEFAULT NULL,
p_attribute4 IN VARCHAR2 DEFAULT NULL,
p_attribute5 IN VARCHAR2 DEFAULT NULL,
p_attribute6 IN VARCHAR2 DEFAULT NULL,
p_attribute7 IN VARCHAR2 DEFAULT NULL,
p_attribute8 IN VARCHAR2 DEFAULT NULL,
p_attribute9 IN VARCHAR2 DEFAULT NULL,
p_attribute10 IN VARCHAR2 DEFAULT NULL,
p_user_id IN NUMBER DEFAULT NULL,
p_resp_id IN NUMBER DEFAULT NULL
);
PROCEDURE insert_po_iface (p_batch_id IN NUMBER);
PROCEDURE submit_po (
p_buyer_id IN NUMBER DEFAULT NULL,
p_document_type IN VARCHAR2 DEFAULT NULL,
p_doc_sub_type IN VARCHAR2 DEFAULT NULL,
p_create_items IN VARCHAR2 DEFAULT NULL,
p_create_sourcing_rul IN VARCHAR2 DEFAULT NULL,
p_approval_status IN VARCHAR2 DEFAULT NULL,
p_rel_gen_method IN VARCHAR2 DEFAULT NULL,
p_batch_id IN NUMBER DEFAULT NULL,
p_operating_unit IN VARCHAR2 DEFAULT NULL,
p_global_agreement IN VARCHAR2 DEFAULT NULL,
p_enable_sourcing_level IN VARCHAR2 DEFAULT NULL,
p_sourcing_level IN VARCHAR2 DEFAULT NULL,
p_inv_org_enable IN VARCHAR2 DEFAULT NULL,
p_inventory_organization IN VARCHAR2 DEFAULT NULL,
x_request_id OUT NUMBER
);
PROCEDURE submit_po1 (
p_errbuf OUT VARCHAR2,
p_retcode OUT NUMBER,
p_buyer_id IN NUMBER DEFAULT NULL,
p_document_type IN VARCHAR2 DEFAULT NULL,
p_doc_sub_type IN VARCHAR2 DEFAULT NULL,
p_create_items IN VARCHAR2 DEFAULT NULL,
p_create_sourcing_rul IN VARCHAR2 DEFAULT NULL,
p_approval_status IN VARCHAR2 DEFAULT NULL,
p_rel_gen_method IN VARCHAR2 DEFAULT NULL,
p_batch_id IN NUMBER DEFAULT NULL,
p_operating_unit IN VARCHAR2 DEFAULT NULL,
p_global_agreement IN VARCHAR2 DEFAULT NULL,
p_enable_sourcing_level IN VARCHAR2 DEFAULT NULL,
p_sourcing_level IN VARCHAR2 DEFAULT NULL,
p_inv_org_enable IN VARCHAR2 DEFAULT NULL,
p_inventory_organization IN VARCHAR2 DEFAULT NULL
);
END xxds_po_iface_pkg;
/
Package Body
CREATE OR REPLACE PACKAGE BODY APPS.xxds_po_iface_pkg
AS
PROCEDURE print_log (p_msg IN LONG)
AS
BEGIN
fnd_file.put_line (fnd_file.LOG, p_msg);
DBMS_OUTPUT.put_line (p_msg);
EXCEPTION
WHEN OTHERS
THEN
NULL;
END;
PROCEDURE print_out (p_msg IN LONG)
AS
BEGIN
fnd_file.put_line (fnd_file.output, p_msg);
DBMS_OUTPUT.put_line (p_msg);
EXCEPTION
WHEN OTHERS
THEN
NULL;
END;
FUNCTION validate_ou_name (p_orgname_i IN VARCHAR2, x_orgid OUT NUMBER)
RETURN VARCHAR2
AS
ln_organization_id NUMBER := NULL;
BEGIN
print_log ( ‘validate_ou_name : Started’
|| CHR (13)
|| ‘ param : ‘
|| p_orgname_i
);
SELECT organization_id
INTO ln_organization_id
FROM hr_operating_units hou
WHERE hou.NAME = TRIM (p_orgname_i);
print_log (‘ OrgId : ‘ || ln_organization_id);
print_log (‘validate_ou_name : Ended’);
x_orgid := ln_organization_id;
RETURN (NULL);
EXCEPTION
WHEN OTHERS
THEN
x_orgid := NULL;
print_log (‘validate_ou_name : Exception ‘ || SQLERRM);
RETURN (‘Organization Name ‘ || SQLERRM);
END validate_ou_name;
FUNCTION validate_ponumber (p_ponumber_i IN VARCHAR2, p_orgname IN VARCHAR2)
RETURN VARCHAR2
AS
ln_poheader_id NUMBER := NULL;
lc_error_msg VARCHAR2 (4000) := NULL;
ln_cnt NUMBER := 0;
BEGIN
print_log ( ‘validate_ponumber : Started’
|| CHR (13)
|| ‘ param1 : ‘
|| p_ponumber_i
|| CHR (13)
|| ‘ param2 : ‘
|| p_orgname
);
IF LENGTH (p_ponumber_i) > 20
THEN
lc_error_msg := ‘PO Number Length should be less than 20.’;
ELSE
SELECT COUNT (*)
INTO ln_cnt
FROM po_headers_all pha, hr_operating_units hou
WHERE pha.org_id = hou.organization_id
AND pha.segment1 = p_ponumber_i
AND NAME = p_orgname;
IF ln_cnt > 0
THEN
lc_error_msg := ‘PO number should be unique.’;
END IF;
END IF;
print_log (‘ Length : ‘ || LENGTH (p_ponumber_i));
print_log (‘ ln_cnt : ‘ || ln_cnt);
print_log (‘ lc_error_msg : ‘ || lc_error_msg);
print_log (‘validate_ponumber : Ended’);
IF lc_error_msg IS NOT NULL
THEN
RETURN (lc_error_msg);
ELSE
RETURN NULL;
END IF;
EXCEPTION
WHEN OTHERS
THEN
print_log (‘validate_ponumber : Exception ‘ || SQLERRM);
RETURN (‘PO Number ‘ || SQLERRM);
END validate_ponumber;
FUNCTION validate_periods (pperiod IN DATE, porgname IN VARCHAR2)
RETURN VARCHAR2
AS
ln_inv_cnt NUMBER := 0;
ln_sob_id NUMBER := NULL;
ln_org_id NUMBER := NULL;
ln_po_cnt NUMBER := 0;
lc_msg VARCHAR2 (240) := NULL;
BEGIN
print_log ( ‘validate_periods : Started’
|| CHR (13)
|| ‘ param1 : ‘
|| pperiod
|| CHR (13)
|| ‘ param2 : ‘
|| porgname
);
SELECT set_of_books_id, organization_id
INTO ln_sob_id, ln_org_id
FROM hr_operating_units
WHERE NAME = porgname;
SELECT COUNT (*)
INTO ln_inv_cnt
FROM org_acct_periods_v
WHERE organization_id = ln_org_id
AND pperiod BETWEEN start_date AND end_date;
SELECT COUNT (*)
INTO ln_po_cnt
FROM gl_period_statuses glperiodstatuseo
WHERE glperiodstatuseo.adjustment_period_flag = ‘N’
AND glperiodstatuseo.closing_status IN (
SELECT lookup_code
FROM ap_lookup_codes
WHERE lookup_type =
‘CLOSING STATUS’)
AND glperiodstatuseo.application_id = 201
AND glperiodstatuseo.set_of_books_id = ln_sob_id
AND pperiod BETWEEN start_date AND end_date;
print_log ( ‘ ln_sob_id : ‘
|| ln_sob_id
|| CHR (13)
|| ‘ ln_org_id : ‘
|| ln_org_id
|| CHR (13)
|| ‘ ln_inv_cnt : ‘
|| ln_inv_cnt
|| CHR (13)
|| ‘ ln_po_cnt : ‘
|| ln_po_cnt
);
IF ln_inv_cnt = 0 AND ln_po_cnt = 0
THEN
lc_msg :=
‘Period Name : Purchasning / Inventory Accounting period is not open’;
ELSIF ln_inv_cnt = 0 AND ln_po_cnt > 0
THEN
lc_msg := ‘Period Name : Inventory Accounting period is not open’;
ELSIF ln_inv_cnt > 0 AND ln_po_cnt = 0
THEN
lc_msg := ‘Period Name : Purchasning Accounting period is not open’;
ELSE
lc_msg := NULL;
END IF;
print_log (‘ lc_msg : ‘ || lc_msg);
print_log (‘validate_periods : Ended’);
RETURN (lc_msg);
EXCEPTION
WHEN OTHERS
THEN
print_log (‘validate_periods : Exception ‘ || SQLERRM);
RETURN (‘Period Name :’ || SQLERRM);
END validate_periods;
FUNCTION validate_documenttype (
p_documenttype IN VARCHAR2,
x_documenttypecode OUT VARCHAR2
)
RETURN VARCHAR2
AS
lc_lookup_code fnd_lookup_values_vl.lookup_code%TYPE := NULL;
BEGIN
print_log ( ‘validate_documenttype : Started’
|| CHR (13)
|| ‘ param : ‘
|| p_documenttype
);
SELECT lookup_code
INTO lc_lookup_code
FROM fnd_lookup_values_vl
WHERE lookup_type = ‘POXMUB_DOCUMENT_TYPE’
AND UPPER (meaning) = UPPER (p_documenttype);
print_log (‘ meaning : ‘ || lc_lookup_code);
print_log (‘validate_documenttype : Ended’);
x_documenttypecode := lc_lookup_code;
RETURN (NULL);
EXCEPTION
WHEN OTHERS
THEN
print_log (‘validate_documenttype : Exception ‘ || SQLERRM);
RETURN (‘DOCUMENT_TYPE : ‘ || SQLERRM);
END validate_documenttype;
FUNCTION validate_vendorname (
p_vendorname IN VARCHAR2,
x_vendor_id OUT NUMBER
)
RETURN VARCHAR2
AS
ln_vendor_id NUMBER := NULL;
BEGIN
print_log ( ‘validate_vendorname : Started’
|| CHR (13)
|| ‘ param : ‘
|| p_vendorname
);
SELECT vendor_id
INTO ln_vendor_id
FROM ap_suppliers
WHERE vendor_name = p_vendorname;
print_log (‘ ln_vendor_id : ‘ || ln_vendor_id);
print_log (‘validate_vendorname : Ended’);
x_vendor_id := ln_vendor_id;
RETURN (NULL);
EXCEPTION
WHEN OTHERS
THEN
x_vendor_id := NULL;
print_log (‘validate_vendorname : Exception ‘ || SQLERRM);
RETURN (‘Supplier Name : ‘ || SQLERRM);
END validate_vendorname;
FUNCTION validate_vendorsite (
p_vendorid IN NUMBER,
p_vendorsite IN VARCHAR2,
p_orgid IN VARCHAR2,
x_vendor_site_id OUT NUMBER
)
RETURN VARCHAR2
AS
ln_vendor_site_id NUMBER := NULL;
BEGIN
print_log ( ‘validate_vendorsite : Started’
|| CHR (13)
|| ‘ param1 : ‘
|| p_vendorid
|| CHR (13)
|| ‘ param2 : ‘
|| p_vendorsite
|| CHR (13)
|| ‘ param3 : ‘
|| p_orgid
);
SELECT vendor_site_id
INTO ln_vendor_site_id
FROM ap_supplier_sites_all
WHERE vendor_id = p_vendorid
AND vendor_site_code = p_vendorsite
AND org_id = p_orgid;
print_log (‘ ln_vendor_site_id : ‘ || ln_vendor_site_id);
print_log (‘validate_vendorsite : Ended’);
x_vendor_site_id := ln_vendor_site_id;
RETURN (NULL);
EXCEPTION
WHEN OTHERS
THEN
x_vendor_site_id := NULL;
print_log (‘validate_vendorsite : Exception ‘ || SQLERRM);
RETURN (‘Supplier Site : ‘ || SQLERRM);
END validate_vendorsite;
FUNCTION validate_shipto (p_shipto IN VARCHAR2, x_location_id OUT NUMBER)
RETURN VARCHAR2
AS
ln_location_id NUMBER := NULL;
BEGIN
print_log ( ‘validate_shipto : Started’
|| CHR (13)
|| ‘ param : ‘
|| p_shipto
);
SELECT location_id
INTO ln_location_id
FROM hr_locations
WHERE UPPER (location_code) = UPPER (p_shipto);
print_log (‘ ln_location_id : ‘ || ln_location_id);
print_log (‘validate_shipto : Ended’);
x_location_id := ln_location_id;
RETURN (NULL);
EXCEPTION
WHEN OTHERS
THEN
x_location_id := NULL;
print_log (‘validate_shipto : Exception ‘ || SQLERRM);
RETURN (‘ShipTo : ‘ || SQLERRM);
END validate_shipto;
FUNCTION validate_billto (p_billto IN VARCHAR2, x_location_id OUT NUMBER)
RETURN VARCHAR2
AS
ln_location_id NUMBER := NULL;
BEGIN
print_log ( ‘validate_billto : Started’
|| CHR (13)
|| ‘ param : ‘
|| p_billto
);
SELECT location_id
INTO ln_location_id
FROM hr_locations
WHERE UPPER (location_code) = UPPER (p_billto);
print_log (‘ ln_location_id : ‘ || ln_location_id);
print_log (‘validate_billto : Ended’);
x_location_id := ln_location_id;
RETURN (NULL);
EXCEPTION
WHEN OTHERS
THEN
x_location_id := NULL;
print_log (‘validate_billto : Exception ‘ || SQLERRM);
RETURN (‘BillTo : ‘ || SQLERRM);
END validate_billto;
FUNCTION validate_agentname (p_agentname IN VARCHAR2, x_buyer_id OUT NUMBER)
RETURN VARCHAR2
AS
ln_buyer_id NUMBER := NULL;
BEGIN
print_log ( ‘validate_agentname : Started’
|| CHR (13)
|| ‘ param : ‘
|| p_agentname
);
SELECT employee_id
INTO ln_buyer_id
FROM po_buyers_all_v
WHERE UPPER (full_name) = UPPER (p_agentname);
print_log (‘ ln_buyer_id : ‘ || ln_buyer_id);
print_log (‘validate_agentname : Ended’);
x_buyer_id := ln_buyer_id;
RETURN (NULL);
EXCEPTION
WHEN OTHERS
THEN
x_buyer_id := NULL;
print_log (‘validate_agentname : Exception ‘ || SQLERRM);
RETURN (‘Buyer Name : ‘ || SQLERRM);
END validate_agentname;
FUNCTION validate_terms (p_terms IN VARCHAR2, x_terms_id OUT NUMBER)
RETURN VARCHAR2
AS
ln_terms_id NUMBER := NULL;
BEGIN
print_log ( ‘validate_TERMS : Started’
|| CHR (13)
|| ‘ param : ‘
|| p_terms
);
SELECT term_id
INTO ln_terms_id
FROM ap_terms_vl
WHERE UPPER (NAME) = UPPER (p_terms);
print_log (‘ ln_terms_id : ‘ || ln_terms_id);
print_log (‘validate_TERMS : Ended’);
x_terms_id := ln_terms_id;
RETURN (NULL);
EXCEPTION
WHEN OTHERS
THEN
x_terms_id := NULL;
print_log (‘validate_terms : Exception ‘ || SQLERRM);
RETURN (‘Terms : ‘ || SQLERRM);
END validate_terms;
FUNCTION validate_currency (p_currcode IN VARCHAR2)
RETURN VARCHAR2
AS
lc_currency_code fnd_currencies_vl.currency_code%TYPE := NULL;
BEGIN
print_log ( ‘validate_currency : Started’
|| CHR (13)
|| ‘ param : ‘
|| p_currcode
);
SELECT currency_code
INTO lc_currency_code
FROM fnd_currencies_vl
WHERE currency_code = p_currcode;
print_log (‘ lc_currency_code : ‘ || lc_currency_code);
print_log (‘validate_currency : Ended’);
RETURN (NULL);
EXCEPTION
WHEN OTHERS
THEN
print_log (‘validate_currency : Exception ‘ || SQLERRM);
RETURN (‘Currency : ‘ || SQLERRM);
END validate_currency;
FUNCTION validate_currrate (
p_currcode IN VARCHAR2,
p_currrate IN NUMBER,
p_currdate IN DATE,
p_currtype IN VARCHAR2,
p_orgid IN NUMBER
)
RETURN VARCHAR2
AS
lc_currency_code fnd_currencies_vl.currency_code%TYPE := NULL;
lx_msg VARCHAR2 (240) := NULL;
BEGIN
print_log ( ‘validate_currrate : Started’
|| CHR (13)
|| ‘ param1 : ‘
|| p_currcode
|| CHR (13)
|| ‘ param2 : ‘
|| p_currrate
|| CHR (13)
|| ‘ param3 : ‘
|| p_currdate
|| CHR (13)
|| ‘ param4 : ‘
|| p_currtype
|| CHR (13)
|| ‘ param5 : ‘
|| p_orgid
);
SELECT currency_code
INTO lc_currency_code
FROM gl_sets_of_books gsb, hr_operating_units hou
WHERE gsb.set_of_books_id = hou.set_of_books_id
AND hou.organization_id = p_orgid;
IF p_currcode != lc_currency_code
THEN
IF p_currrate IS NULL
THEN
lx_msg := ‘Curreny rate is required’;
ELSIF p_currdate IS NULL
THEN
lx_msg := ‘Curreny date is required’;
ELSIF p_currtype IS NULL
THEN
lx_msg := ‘Curreny Type is required’;
END IF;
END IF;
print_log (‘ lc_currency_code : ‘ || lc_currency_code);
print_log (‘validate_currrate : Ended’);
RETURN (lx_msg);
EXCEPTION
WHEN OTHERS
THEN
print_log (‘validate_currrate : Exception ‘ || SQLERRM);
RETURN (‘Curreny rate : ‘ || SQLERRM);
END validate_currrate;
FUNCTION validate_linenum (
p_linenum IN NUMBER,
p_ponum IN VARCHAR2,
p_orgid IN NUMBER
)
RETURN VARCHAR2
AS
ln_cnt NUMBER := 0;
lx_msg VARCHAR2 (240) := NULL;
BEGIN
print_log ( ‘validate_linenum : Started’
|| CHR (13)
|| ‘ param1 : ‘
|| p_linenum
|| CHR (13)
|| ‘ param2 : ‘
|| p_ponum
|| CHR (13)
|| ‘ param3 : ‘
|| p_orgid
);
IF p_linenum IS NULL
THEN
lx_msg := ‘Line Number is Required’;
END IF;
/**/
print_log (‘ ln_cnt : ‘ || ln_cnt);
print_log (‘validate_linenum : Ended’);
RETURN (lx_msg);
EXCEPTION
WHEN OTHERS
THEN
print_log (‘validate_linenum : Exception ‘ || SQLERRM);
RETURN (‘Line No. : ‘ || SQLERRM);
END validate_linenum;
FUNCTION validate_linetype (
p_linetype IN VARCHAR2,
x_line_type_id OUT NUMBER
)
RETURN VARCHAR2
AS
ln_line_type_id NUMBER := 0;
BEGIN
print_log ( ‘validate_linetype : Started’
|| CHR (13)
|| ‘ param1 : ‘
|| p_linetype
);
/**/
SELECT line_type_id
INTO ln_line_type_id
FROM po_line_types_vl
WHERE UPPER (line_type) = UPPER (p_linetype);
print_log (‘ ln_line_type_id : ‘ || ln_line_type_id);
print_log (‘validate_linetype : Ended’);
x_line_type_id := ln_line_type_id;
RETURN (NULL);
EXCEPTION
WHEN OTHERS
THEN
print_log (‘validate_linetype : Exception ‘ || SQLERRM);
RETURN (‘Line Type : ‘ || SQLERRM);
END validate_linetype;
FUNCTION validate_chargsegment (
p_orgid IN NUMBER,
p_segment1 IN VARCHAR2,
p_segment2 IN VARCHAR2,
p_segment3 IN VARCHAR2,
p_segment4 IN VARCHAR2,
p_segment5 IN VARCHAR2,
p_segment6 IN VARCHAR2,
p_segment7 IN VARCHAR2,
p_segment8 IN VARCHAR2,
p_segment9 IN VARCHAR2,
p_segment10 IN VARCHAR2
)
RETURN VARCHAR2
AS
ln_chart_of_accounts_id NUMBER := 0;
lx_delimiter VARCHAR2 (240) := NULL;
lc_segments VARCHAR2 (1000) := NULL;
lb_valid_combination BOOLEAN;
lx_msg VARCHAR2 (4000) := NULL;
lx_status VARCHAR2 (240) := NULL;
BEGIN
print_log ( ‘validate_chargsegment : Started’
|| CHR (13)
|| ‘ param : ‘
|| p_orgid
);
SELECT chart_of_accounts_id
INTO ln_chart_of_accounts_id
FROM gl_sets_of_books gsb, hr_operating_units hou
WHERE gsb.set_of_books_id = hou.set_of_books_id
AND hou.organization_id = p_orgid;
lx_delimiter :=
fnd_flex_ext.get_delimiter
(application_short_name => ‘SQLGL’,
key_flex_code => ‘GL#’,
structure_number => ln_chart_of_accounts_id
);
IF p_segment1 IS NOT NULL
THEN
lc_segments := p_segment1;
END IF;
IF p_segment2 IS NOT NULL
THEN
lc_segments := lc_segments || lx_delimiter || p_segment2;
END IF;
IF p_segment3 IS NOT NULL
THEN
lc_segments := lc_segments || lx_delimiter || p_segment3;
END IF;
IF p_segment4 IS NOT NULL
THEN
lc_segments := lc_segments || lx_delimiter || p_segment4;
END IF;
IF p_segment5 IS NOT NULL
THEN
lc_segments := lc_segments || lx_delimiter || p_segment5;
END IF;
IF p_segment6 IS NOT NULL
THEN
lc_segments := lc_segments || lx_delimiter || p_segment6;
END IF;
IF p_segment7 IS NOT NULL
THEN
lc_segments := lc_segments || lx_delimiter || p_segment7;
END IF;
IF p_segment8 IS NOT NULL
THEN
lc_segments := lc_segments || lx_delimiter || p_segment8;
END IF;
IF p_segment9 IS NOT NULL
THEN
lc_segments := lc_segments || lx_delimiter || p_segment9;
END IF;
IF p_segment10 IS NOT NULL
THEN
lc_segments := lc_segments || lx_delimiter || p_segment10;
END IF;
lb_valid_combination :=
apps.fnd_flex_keyval.validate_segs
(operation => ‘CHECK_SEGMENTS’,
appl_short_name => ‘SQLGL’,
key_flex_code => ‘GL#’,
structure_number => ln_chart_of_accounts_id,
concat_segments => lc_segments
);
— valid_seg (p_key_flex_code => ‘GL#’,
— p_structure_number => ln_chart_of_accounts_id,
— p_concat_segments => lc_segments,
— p_delimiter => lx_delimiter,
— x_status => lx_status,
— x_error_msg => lx_msg
— );
— IF lx_status = ‘S’
— THEN
— lx_msg := NULL;
— END IF;
IF lb_valid_combination
THEN
print_log (‘ lb_valid_combination : True’);
ELSE
lx_msg := fnd_flex_keyval.error_message;
END IF;
print_log (‘ lx_delimiter : ‘ || lx_delimiter);
print_log (‘ ln_chart_of_accounts_id : ‘ || ln_chart_of_accounts_id);
print_log (‘ lc_segments : ‘ || lc_segments);
print_log (‘ lx_msg : ‘ || lx_msg);
print_log (‘validate_chargsegment : Ended’);
RETURN (lx_msg);
EXCEPTION
WHEN OTHERS
THEN
print_log (‘validate_chargsegment : Exception ‘ || SQLERRM);
RETURN (‘Charge Account. : ‘ || SQLERRM);
END validate_chargsegment;
FUNCTION getdelimter_segment (
p_org_id IN NUMBER,
p_segment IN VARCHAR2,
x_concat_segment OUT VARCHAR2
)
RETURN VARCHAR2
AS
CURSOR cur (p_chart_of_account_id IN NUMBER)
IS
SELECT fifseg.segment_num, fifseg.display_size,
concatenated_segment_delimiter
FROM fnd_id_flex_segments_vl fifseg,
fnd_id_flex_structures_vl fifsv
WHERE 1 = 1
AND fifsv.id_flex_num = fifseg.id_flex_num
AND fifsv.id_flex_code = fifseg.id_flex_code
AND fifsv.application_id = fifseg.application_id
AND fifsv.id_flex_code = ‘GL#’
AND fifsv.id_flex_num = p_chart_of_account_id
AND fifseg.enabled_flag = ‘Y’
AND fifseg.application_id = fifsv.application_id
ORDER BY fifseg.segment_num ASC;
lc_segment VARCHAR2 (1000) := NULL;
lc_concat_segment VARCHAR2 (1000) := NULL;
l_first NUMBER := 1;
l_second NUMBER := 0;
l_total NUMBER := 1;
ln_chart_of_accounts_id NUMBER := NULL;
BEGIN
lc_segment := p_segment;
SELECT gsb.chart_of_accounts_id
INTO ln_chart_of_accounts_id
FROM hr_operating_units hou, gl_sets_of_books gsb
WHERE organization_id = p_org_id
AND hou.set_of_books_id = gsb.set_of_books_id;
FOR my_rec IN cur (ln_chart_of_accounts_id)
LOOP
l_second := my_rec.display_size;
IF lc_concat_segment IS NULL
THEN
lc_concat_segment := SUBSTR (lc_segment, l_total, l_second);
ELSE
lc_concat_segment :=
lc_concat_segment
|| my_rec.concatenated_segment_delimiter
|| SUBSTR (lc_segment, l_total, l_second);
END IF;
l_total := l_total + l_second;
END LOOP;
DBMS_OUTPUT.put_line (‘lc_concat_segment : ‘ || lc_concat_segment);
x_concat_segment := lc_concat_segment;
RETURN (NULL);
EXCEPTION
WHEN OTHERS
THEN
RETURN (‘Error : ‘ || SQLERRM (SQLCODE));
x_concat_segment := NULL;
END getdelimter_segment;
FUNCTION validate_segment (
p_org_id IN NUMBER,
p_segment IN VARCHAR2,
p_mode IN VARCHAR2,
p_org_segment IN VARCHAR2,
p_rec_id IN NUMBER
)
RETURN VARCHAR2
AS
ln_chart_of_accounts_id NUMBER := 0;
lx_delimiter VARCHAR2 (240) := NULL;
lc_segments VARCHAR2 (1000) := NULL;
lb_valid_combination BOOLEAN;
lx_msg VARCHAR2 (4000) := NULL;
lx_status VARCHAR2 (240) := NULL;
lc_set_delimiter VARCHAR2 (240) := NULL;
stmt_str VARCHAR2 (4000) := NULL;
lx_segment VARCHAR2 (1240) := NULL;
BEGIN
SELECT gsb.chart_of_accounts_id
INTO ln_chart_of_accounts_id
FROM hr_operating_units hou, gl_sets_of_books gsb
WHERE organization_id = p_org_id
AND hou.set_of_books_id = gsb.set_of_books_id;
DBMS_OUTPUT.put_line ( ‘validate_chargsegment : Started’
|| CHR (13)
|| ‘ param : ‘
|| ln_chart_of_accounts_id
);
lx_delimiter :=
fnd_flex_ext.get_delimiter
(application_short_name => ‘SQLGL’,
key_flex_code => ‘GL#’,
structure_number => ln_chart_of_accounts_id
);
lc_segments := p_segment;
lb_valid_combination :=
apps.fnd_flex_keyval.validate_segs
(operation => ‘CHECK_SEGMENTS’,
appl_short_name => ‘SQLGL’,
key_flex_code => ‘GL#’,
structure_number => ln_chart_of_accounts_id,
concat_segments => lc_segments
);
lc_set_delimiter := ‘[^’ || lx_delimiter || ‘]+’;
SELECT DECODE (p_mode,
‘N’, TO_CHAR (lc_segments),
TO_CHAR (p_org_segment)
)
INTO lx_segment
FROM DUAL;
IF lb_valid_combination
THEN
DBMS_OUTPUT.put_line (‘ lb_valid_combination : True’);
FOR my_rec IN
(SELECT cc_segment, lvl, ‘Segment’ || lvl AS seg_column
FROM (SELECT REGEXP_SUBSTR (lc_segments,
lc_set_delimiter,
1,
LEVEL
) cc_segment,
LEVEL lvl
FROM DUAL
CONNECT BY REGEXP_SUBSTR (lc_segments,
lc_set_delimiter,
1,
LEVEL
) IS NOT NULL))
LOOP
stmt_str :=
‘UPDATE XXDS_WEBADI_PO_STG
SET ‘
|| my_rec.seg_column
|| ‘ = ”’
|| TO_CHAR (my_rec.cc_segment)
|| ”’
WHERE Segment9 = ”’
|| lx_segment
|| ”’
and rec_ID=’
|| p_rec_id;
DBMS_OUTPUT.put_line (‘ stmt_str : ‘ || stmt_str);
EXECUTE IMMEDIATE stmt_str;
COMMIT;
END LOOP;
lx_msg := NULL;
ELSE
lx_msg := fnd_flex_keyval.error_message;
END IF;
DBMS_OUTPUT.put_line (‘ lx_delimiter : ‘ || lx_delimiter);
DBMS_OUTPUT.put_line ( ‘ ln_chart_of_accounts_id : ‘
|| ln_chart_of_accounts_id
);
DBMS_OUTPUT.put_line (‘ lc_segments : ‘ || lc_segments);
DBMS_OUTPUT.put_line (‘ lx_msg : ‘ || lx_msg);
DBMS_OUTPUT.put_line (‘validate_chargsegment : Ended’);
RETURN (lx_msg);
EXCEPTION
WHEN OTHERS
THEN
print_log (‘validate_chargsegment : Exception ‘ || SQLERRM);
RETURN (‘Charge Account. : ‘ || SQLERRM);
END validate_segment;
PROCEDURE pre_validation (
p_batch_id IN NUMBER,
p_rec_id IN NUMBER,
x_status_o OUT VARCHAR2,
x_error_msg_o OUT LONG
)
AS
lc_status VARCHAR2 (240) := NULL;
lc_error_msg LONG := NULL;
l_error_msg LONG := NULL;
lx_org_id NUMBER := NULL;
lx_vendor_id NUMBER := NULL;
lx_vendor_site_id NUMBER := NULL;
lx_shipto_id NUMBER := NULL;
lx_billto_id NUMBER := NULL;
lx_buyer_id NUMBER := NULL;
lx_terms_id NUMBER := NULL;
lx_line_type_id NUMBER := NULL;
lx_document_type_code VARCHAR2 (240) := NULL;
— out_rec out_var_rec;
lr_po_stg xxds_webadi_po_stg%ROWTYPE;
lx_concate_segment VARCHAR2 (500) := NULL;
BEGIN
SELECT *
INTO lr_po_stg
FROM xxds_webadi_po_stg
WHERE batch_id = p_batch_id AND rec_id = p_rec_id;
——
–OU Validation
——
DBMS_OUTPUT.put_line (‘Org-< Name -> ‘ || lr_po_stg.org_name);
l_error_msg := validate_ou_name (lr_po_stg.org_name, lx_org_id);
IF l_error_msg IS NOT NULL
THEN
lc_error_msg := lc_error_msg || l_error_msg || ‘;’;
END IF;
——
–PONumber Validation
——
l_error_msg :=
validate_ponumber (lr_po_stg.po_number, lr_po_stg.org_name);
IF l_error_msg IS NOT NULL
THEN
lc_error_msg := lc_error_msg || l_error_msg || ‘;’;
END IF;
——
–Period Validation
——
l_error_msg :=
validate_periods (lr_po_stg.po_creation_date, lr_po_stg.org_name);
IF l_error_msg IS NOT NULL
THEN
lc_error_msg := lc_error_msg || l_error_msg || ‘;’;
END IF;
——
–documenttype Validation
——
l_error_msg :=
validate_documenttype (lr_po_stg.document_type,
lx_document_type_code);
IF l_error_msg IS NOT NULL
THEN
lc_error_msg := lc_error_msg || l_error_msg || ‘;’;
END IF;
——
–Vendor name Validation
——
l_error_msg := validate_vendorname (lr_po_stg.vendor_name, lx_vendor_id);
IF l_error_msg IS NOT NULL
THEN
lc_error_msg := lc_error_msg || l_error_msg || ‘;’;
END IF;
——
–Vendor Site Validation
——
l_error_msg :=
validate_vendorsite (lx_vendor_id,
lr_po_stg.vendor_site_code,
lx_org_id,
lx_vendor_site_id
);
IF l_error_msg IS NOT NULL
THEN
lc_error_msg := lc_error_msg || l_error_msg || ‘;’;
END IF;
——
–Shipto Validation
——
l_error_msg := validate_shipto (lr_po_stg.ship_to, lx_shipto_id);
IF l_error_msg IS NOT NULL
THEN
lc_error_msg := lc_error_msg || l_error_msg || ‘;’;
END IF;
——
–Billto Validation
——
l_error_msg := validate_billto (lr_po_stg.bill_to, lx_billto_id);
IF l_error_msg IS NOT NULL
THEN
lc_error_msg := lc_error_msg || l_error_msg || ‘;’;
END IF;
——
–AgentNAme Validation
——
l_error_msg := validate_agentname (lr_po_stg.agent_name, lx_buyer_id);
IF l_error_msg IS NOT NULL
THEN
lc_error_msg := lc_error_msg || l_error_msg || ‘;’;
END IF;
——
–Temrs Validation
——
l_error_msg := validate_terms (lr_po_stg.terms, lx_terms_id);
IF l_error_msg IS NOT NULL
THEN
lc_error_msg := lc_error_msg || l_error_msg || ‘;’;
END IF;
——
–Currency Validation
——
l_error_msg := validate_currency (lr_po_stg.currency);
IF l_error_msg IS NOT NULL
THEN
lc_error_msg := lc_error_msg || l_error_msg || ‘;’;
ELSE
——
–Currency Rate Validation
——
l_error_msg :=
validate_currrate (lr_po_stg.currency,
lr_po_stg.conversion_rate,
lr_po_stg.conversion_date,
lr_po_stg.conversion_type,
lx_org_id
);
IF l_error_msg IS NOT NULL
THEN
lc_error_msg := lc_error_msg || l_error_msg || ‘;’;
END IF;
END IF;
——
–Line Number Validation
——
l_error_msg :=
validate_linenum (lr_po_stg.line_num, lr_po_stg.po_number, lx_org_id);
IF l_error_msg IS NOT NULL
THEN
lc_error_msg := lc_error_msg || l_error_msg || ‘;’;
END IF;
——
–Line Type Validation
——
l_error_msg := validate_linetype (lr_po_stg.line_type, lx_line_type_id);
IF l_error_msg IS NOT NULL
THEN
lc_error_msg := lc_error_msg || l_error_msg || ‘;’;
END IF;
——
–Chargs Sgment Validation
——
IF lx_document_type_code = ‘STANDARD’
THEN
IF UPPER (lr_po_stg.segment10) = ‘Y’
THEN
l_error_msg :=
getdelimter_segment (lx_org_id,
lr_po_stg.segment9,
lx_concate_segment
);
ELSE
lx_concate_segment := lr_po_stg.segment9;
END IF;
IF l_error_msg IS NOT NULL
THEN
lc_error_msg := lc_error_msg || l_error_msg || ‘;’;
ELSE
l_error_msg :=
validate_segment (lx_org_id,
lx_concate_segment,
UPPER (lr_po_stg.segment10),
lr_po_stg.segment9,
p_rec_id
);
IF l_error_msg IS NOT NULL
THEN
lc_error_msg := lc_error_msg || l_error_msg || ‘;’;
END IF;
END IF;
END IF;
IF lc_error_msg IS NOT NULL
THEN
UPDATE xxds_webadi_po_stg
SET status = ‘E’,
error_msg = lc_error_msg,
segment1 = NULL,
segment2 = NULL,
segment3 = NULL,
segment4 = NULL,
segment5 = NULL,
segment6 = NULL,
segment7 = NULL,
segment8 = NULL,
last_update_date = SYSDATE,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.login_id
WHERE rec_id = p_rec_id AND batch_id = p_batch_id;
COMMIT;
x_status_o := ‘E’;
x_error_msg_o := lc_error_msg;
ELSE
UPDATE xxds_webadi_po_stg
SET status = ‘V’,
error_msg = NULL,
document_type_code = lx_document_type_code,
org_id = lx_org_id,
vendor_id = lx_vendor_id,
vendor_site_id = lx_vendor_site_id,
shipto_id = lx_shipto_id,
billto_id = lx_billto_id,
buyer_id = lx_buyer_id,
terms_id = lx_terms_id,
line_type_id = lx_line_type_id,
last_update_date = SYSDATE,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.login_id
WHERE rec_id = p_rec_id AND batch_id = p_batch_id;
x_status_o := ‘S’;
x_error_msg_o := NULL;
print_log (‘ S : ‘ || lx_org_id);
END IF;
EXCEPTION
WHEN OTHERS
THEN
lc_error_msg := SQLERRM (SQLCODE);
UPDATE xxds_webadi_po_stg
SET status = ‘E’,
error_msg = lc_error_msg,
segment1 = NULL,
segment2 = NULL,
segment3 = NULL,
segment4 = NULL,
segment5 = NULL,
segment6 = NULL,
segment7 = NULL,
segment8 = NULL,
last_update_date = SYSDATE,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.login_id
WHERE rec_id = p_rec_id AND batch_id = p_batch_id;
COMMIT;
x_status_o := ‘E’;
x_error_msg_o := SQLERRM;
END pre_validation;
PROCEDURE insert_web_adi_tl (
p_batch_id IN NUMBER,
p_mode IN VARCHAR2,
p_org_name IN VARCHAR2 DEFAULT NULL,
p_org_id IN VARCHAR2 DEFAULT NULL,
p_po_number IN VARCHAR2 DEFAULT NULL,
p_creation_date IN DATE DEFAULT NULL,
p_document_type_code IN VARCHAR2 DEFAULT NULL,
p_vendor_name IN VARCHAR2 DEFAULT NULL,
p_vendro_site_code IN VARCHAR2 DEFAULT NULL,
p_ship_to IN VARCHAR2 DEFAULT NULL,
p_bill_to IN VARCHAR2 DEFAULT NULL,
p_vendor_contact_name IN VARCHAR2 DEFAULT NULL,
p_agent_name IN VARCHAR2 DEFAULT NULL,
p_approval_status IN VARCHAR2 DEFAULT NULL,
p_total IN NUMBER DEFAULT NULL,
p_currency IN VARCHAR2 DEFAULT NULL,
p_conversion_type IN VARCHAR2 DEFAULT NULL,
p_conversion_rate IN NUMBER DEFAULT NULL,
p_conversion_date IN DATE DEFAULT NULL,
p_terms IN VARCHAR2 DEFAULT NULL,
p_fright_terms IN VARCHAR2 DEFAULT NULL,
p_carrier IN VARCHAR2 DEFAULT NULL,
p_description IN VARCHAR2 DEFAULT NULL,
p_line_num IN NUMBER DEFAULT NULL,
p_line_type IN VARCHAR2 DEFAULT NULL,
p_item IN VARCHAR2 DEFAULT NULL,
p_item_category IN VARCHAR2 DEFAULT NULL,
p_item_description IN VARCHAR2 DEFAULT NULL,
p_uom IN VARCHAR2 DEFAULT NULL,
p_quantity IN NUMBER DEFAULT NULL,
p_price IN NUMBER DEFAULT NULL,
p_promise_date IN DATE DEFAULT NULL,
p_need_by_date IN DATE DEFAULT NULL,
p_ship_to_org IN VARCHAR2 DEFAULT NULL,
p_shipment_num IN NUMBER DEFAULT NULL,
p_distribution_num IN NUMBER DEFAULT NULL,
p_segment1 IN VARCHAR2 DEFAULT NULL,
p_segment2 IN VARCHAR2 DEFAULT NULL,
p_segment3 IN VARCHAR2 DEFAULT NULL,
p_segment4 IN VARCHAR2 DEFAULT NULL,
p_segment5 IN VARCHAR2 DEFAULT NULL,
p_segment6 IN VARCHAR2 DEFAULT NULL,
p_segment7 IN VARCHAR2 DEFAULT NULL,
p_segment8 IN VARCHAR2 DEFAULT NULL,
p_segment9 IN VARCHAR2 DEFAULT NULL,
p_segment10 IN VARCHAR2 DEFAULT NULL,
p_attribute1 IN VARCHAR2 DEFAULT NULL,
p_attribute2 IN VARCHAR2 DEFAULT NULL,
p_attribute3 IN VARCHAR2 DEFAULT NULL,
p_attribute4 IN VARCHAR2 DEFAULT NULL,
p_attribute5 IN VARCHAR2 DEFAULT NULL,
p_attribute6 IN VARCHAR2 DEFAULT NULL,
p_attribute7 IN VARCHAR2 DEFAULT NULL,
p_attribute8 IN VARCHAR2 DEFAULT NULL,
p_attribute9 IN VARCHAR2 DEFAULT NULL,
p_attribute10 IN VARCHAR2 DEFAULT NULL,
p_user_id IN NUMBER DEFAULT NULL,
p_resp_id IN NUMBER DEFAULT NULL
)
AS
le_exception EXCEPTION;
lc_status VARCHAR2 (240) := NULL;
l_error_msg LONG := NULL;
lx_org_id NUMBER;
lx_document_type_code VARCHAR2 (240);
lx_vendor_id NUMBER;
lx_vendor_site_id NUMBER;
lx_shipto_id NUMBER;
lx_billto_id NUMBER;
lx_buyer_id NUMBER;
lx_terms_id NUMBER;
lx_line_type_id NUMBER;
ln_appl_id NUMBER := fnd_global.resp_appl_id;
ln_resp_id NUMBER := fnd_global.resp_id;
ln_user_id NUMBER := fnd_global.user_id;
ln_login_id NUMBER := fnd_global.login_id;
BEGIN
/*
pre_validation (insert_web_adi_tl.p_org_name,
insert_web_adi_tl.p_po_number,
insert_web_adi_tl.p_creation_date,
insert_web_adi_tl.p_document_type_code,
insert_web_adi_tl.p_vendor_name,
insert_web_adi_tl.p_vendro_site_code,
insert_web_adi_tl.p_ship_to,
insert_web_adi_tl.p_bill_to,
insert_web_adi_tl.p_agent_name,
insert_web_adi_tl.p_terms,
insert_web_adi_tl.p_currency,
insert_web_adi_tl.p_conversion_rate,
insert_web_adi_tl.p_conversion_date,
insert_web_adi_tl.p_conversion_type,
insert_web_adi_tl.p_line_num,
insert_web_adi_tl.p_line_type,
insert_web_adi_tl.p_segment1,
insert_web_adi_tl.p_segment2,
insert_web_adi_tl.p_segment3,
insert_web_adi_tl.p_segment4,
insert_web_adi_tl.p_segment5,
insert_web_adi_tl.p_segment6,
insert_web_adi_tl.p_segment7,
insert_web_adi_tl.p_segment8,
insert_web_adi_tl.p_segment9,
insert_web_adi_tl.p_segment10,
lc_status,
l_error_msg,
lx_org_id,
lx_document_type_code,
lx_vendor_id,
lx_vendor_site_id,
lx_shipto_id,
lx_billto_id,
lx_buyer_id,
lx_terms_id,
lx_line_type_id
);
*/
lc_status := ‘S’;
IF lc_status = ‘E’
THEN
RAISE le_exception;
ELSE
INSERT INTO apps.xxds_webadi_po_stg
(org_name, po_number, po_creation_date, document_type,
vendor_name, vendor_site_code, ship_to, bill_to,
vendor_contact_name, agent_name, approval_status,
total, currency, conversion_type, conversion_rate,
conversion_date, terms, frieght_terms, carrier,
description, line_num, line_type, item_code,
item_category, item_description, uom_code, uom,
quantity, price, promise_date, need_by_date,
ship_to_org, segment1, segment2, segment3, segment4,
segment5, segment6, segment7, segment8, segment9,
segment10, hdr_attribute1, hdr_attribute2,
hdr_attribute3, hdr_attribute4, hdr_attribute5,
hdr_attribute6, hdr_attribute7, hdr_attribute8,
hdr_attribute9, hdr_attribute10, hdr_attribute11,
hdr_attribute12, hdr_attribute13, hdr_attribute14,
hdr_attribute15, ln_attribute1, ln_attribute2,
ln_attribute3, ln_attribute4, ln_attribute5,
ln_attribute6, ln_attribute7, ln_attribute8,
ln_attribute9, ln_attribute10, ln_attribute11,
ln_attribute12, ln_attribute13, ln_attribute14,
ln_attribute15, dist_attribute1, dist_attribute2,
dist_attribute3, dist_attribute4, dist_attribute5,
dist_attribute6, dist_attribute7, dist_attribute8,
dist_attribute9, dist_attribute10, dist_attribute11,
dist_attribute12, dist_attribute13, dist_attribute14,
dist_attribute15, resp_id, appl_id, batch_id,
inst_status, org_id, document_type_code, vendor_id,
vendor_site_id, shipto_id, billto_id, buyer_id,
terms_id, line_type_id, created_by, creation_date,
last_updated_by, last_update_date, last_update_login,
trx_mode, rec_id)
SELECT p_org_name AS org_name, p_po_number AS po_number,
p_creation_date AS po_creation_date,
p_document_type_code AS document_type,
p_vendor_name AS vendor_name,
p_vendro_site_code AS vendor_site_code,
p_ship_to AS ship_to, p_bill_to AS bill_to,
p_vendor_contact_name AS vendor_contact_name,
p_agent_name AS agent_name,
p_approval_status AS approval_status, p_total AS total,
p_currency AS currency,
p_conversion_type AS conversion_type,
p_conversion_rate AS conversion_rate,
p_conversion_date AS conversion_date, p_terms AS terms,
p_fright_terms AS frieght_terms, p_carrier AS carrier,
p_description AS description, p_line_num AS line_num,
p_line_type AS line_type, p_item AS item_code,
p_item_category AS item_category,
p_item_description AS item_description, NULL AS uom_code,
p_uom AS uom, p_quantity AS quantity, p_price AS price,
p_promise_date AS promise_date,
p_need_by_date AS need_by_date,
p_ship_to_org AS ship_to_org, p_segment1 AS segment1,
p_segment2 AS segment2, p_segment3 AS segment3,
p_segment4 AS asegment4, p_segment5 assegment5,
p_segment6 AS segment6, p_segment7 AS segment7,
p_segment8 AS segment8, p_segment9 AS segment9,
p_segment10 AS segment10, p_attribute1 AS hdr_attribute1,
p_attribute2 AS hdr_attribute2,
p_attribute3 AS hdr_attribute3,
p_attribute4 AS hdr_attribute4,
p_attribute5 AS hdr_attribute5,
p_attribute6 AS hdr_attribute6,
p_attribute7 AS hdr_attribute7,
p_attribute8 AS hdr_attribute8,
p_attribute9 AS hdr_attribute9,
p_attribute10 AS hdr_attribute10, NULL AS hdr_attribute11,
NULL AS hdr_attribute12, NULL ashdr_attribute13,
NULL AS hdr_attribute14, NULL AS hdr_attribute15,
NULL AS ln_attribute1, NULL AS ln_attribute2,
NULL AS ln_attribute3, NULL AS ln_attribute4,
NULL AS ln_attribute5, NULL AS ln_attribute6,
NULL AS ln_attribute7, NULL AS ln_attribute8,
NULL AS ln_attribute9, NULL AS ln_attribute10,
NULL AS ln_attribute11, NULL AS ln_attribute12,
NULL AS ln_attribute13, NULL AS ln_attribute14,
NULL AS ln_attribute15, NULL AS dist_attribute1,
NULL AS dist_attribute2, NULL AS dist_attribute3,
NULL AS dist_attribute4, NULL AS dist_attribute5,
NULL AS dist_attribute6, NULL AS dist_attribute7,
NULL AS dist_attribute8, NULL AS dist_attribute9,
NULL AS dist_attribute10, NULL AS dist_attribute11,
NULL AS dist_attribute12, NULL AS dist_attribute13,
NULL AS dist_attribute14, NULL AS dist_attribute15,
ln_resp_id resp_id, ln_appl_id appl_id,
p_batch_id AS batch_id, ‘N’ AS inst_status,
lx_org_id org_id,
lx_document_type_code document_type_code,
lx_vendor_id vendor_id,
lx_vendor_site_id AS vendor_site_id,
lx_shipto_id AS shipto_id, lx_billto_id AS billto_id,
lx_buyer_id AS buyer_id, lx_terms_id AS terms_id,
lx_line_type_id AS line_type_id, ln_user_id AS created_by,
SYSDATE AS creation_date, ln_user_id AS last_updated_by,
SYSDATE AS last_update_date,
ln_login_id AS last_update_login, p_mode,
xxds_webadi_po_stg_rec_s.NEXTVAL
FROM DUAL;
END IF;
EXCEPTION
WHEN le_exception
THEN
— fnd_message.CLEAR;
— fnd_message.set_name (‘BNE’, ‘WEBADI_ERROR’);
— fnd_message.set_token (‘MSG’, l_error_msg);
— fnd_message.raise_error;
l_error_msg :=
SUBSTR (‘Error encountered is : ‘ || l_error_msg, 1, 4000);
raise_application_error (-20001, l_error_msg);
WHEN OTHERS
THEN
l_error_msg := SUBSTR (‘Error is : ‘ || SQLERRM (SQLCODE), 1, 4000);
raise_application_error (-20001, l_error_msg);
–fnd_message.set_name (‘BNE’, ‘WEBADI_ERROR’);
— fnd_message.set_token (‘MSG’, l_error_msg);
— fnd_message.raise_error;
END insert_web_adi_tl;
PROCEDURE insert_po_iface (p_batch_id IN NUMBER)
AS
CURSOR stg_hdr_cur
IS
SELECT x.*
FROM xxds_webadi_po_stg x
WHERE 1 = 1
AND batch_id = p_batch_id
AND status = ‘V’
AND NOT EXISTS (
SELECT 1
FROM xxds_webadi_po_stg x1
WHERE x.po_number = x1.po_number
AND x.batch_id = x1.batch_id
AND x1.status = ‘E’);
ln_header_id NUMBER := NULL;
ln_line_id NUMBER := NULL;
ln_distribution_id NUMBER := NULL;
lc_log_head VARCHAR2 (500)
:= gc_module_prefix || ‘.insert_iface’;
lc_progress VARCHAR2 (240) := NULL;
ln_exists_cnt NUMBER := 0;
BEGIN
print_log ( lc_log_head
|| ‘ : Started: ‘
|| TO_CHAR (SYSDATE, ‘DD-Mon-RRRR HH24:MI:SS’)
);
lc_progress := ‘000’;
FOR hdr_rec IN stg_hdr_cur
LOOP
lc_progress := ‘001’;
ln_header_id := NULL;
ln_line_id := NULL;
ln_distribution_id := NULL;
lc_progress := ‘010’;
ln_exists_cnt := 0;
SELECT COUNT (*)
INTO ln_exists_cnt
FROM po_headers_interface
WHERE batch_id = hdr_rec.batch_id
AND org_id = hdr_rec.org_id
AND document_num = hdr_rec.po_number;
lc_progress := ‘020’;
IF ln_exists_cnt = 0
THEN
lc_progress := ‘030’;
ln_header_id := po_headers_interface_s.NEXTVAL;
INSERT INTO po_headers_interface
(interface_header_id, document_type_code,
process_code, vendor_name, payment_terms,
vendor_site_code, currency_code,
approval_required_flag, comments, org_id,
agent_name, ship_to_location,
bill_to_location, interface_source_code, batch_id,
approval_status, rate_type,
rate_date, rate,
action, creation_date,
document_num, created_by, last_update_date,
last_updated_by, attribute15,
reference_num — WEBADI REFERENCE
)
VALUES (ln_header_id, hdr_rec.document_type_code,
‘PENDING’, hdr_rec.vendor_name, hdr_rec.terms,
hdr_rec.vendor_site_code, hdr_rec.currency,
‘N’, hdr_rec.description, hdr_rec.org_id,
hdr_rec.agent_name, hdr_rec.ship_to,
hdr_rec.bill_to, ‘WEBADIPO’, hdr_rec.batch_id,
hdr_rec.approval_status, hdr_rec.conversion_type,
hdr_rec.conversion_date, hdr_rec.conversion_rate,
‘ORIGINAL’, hdr_rec.po_creation_date,
hdr_rec.po_number, hdr_rec.user_id, SYSDATE,
hdr_rec.user_id, ‘Web ADI PO Integration’,
‘WDIAPO’
);
print_log (SQL%ROWCOUNT || ‘ Insert into po_headers_interface’);
ELSE
SELECT interface_header_id
INTO ln_header_id
FROM po_headers_interface
WHERE batch_id = hdr_rec.batch_id
AND org_id = hdr_rec.org_id
AND document_num = hdr_rec.po_number;
END IF;
lc_progress := ‘040’;
ln_line_id := po_lines_interface_s.NEXTVAL;
IF hdr_rec.document_type_code = ‘STANDARD’
THEN
INSERT INTO po_lines_interface
(interface_line_id, interface_header_id,
line_type_id, item,
item_description, unit_price,
uom_code, quantity,
ship_to_location, shipment_num,
need_by_date,
–PROMISED_DATE,
line_num,
ship_to_organization_code, line_attribute15,
accrue_on_receipt_flag, taxable_flag,
line_attribute14, creation_date, created_by,
last_update_date, last_updated_by, note_to_vendor
)
VALUES (ln_line_id, ln_header_id,
hdr_rec.line_type_id, hdr_rec.item_code,
hdr_rec.item_description, hdr_rec.price,
hdr_rec.uom_code, hdr_rec.quantity,
hdr_rec.hdr_attribute1, hdr_rec.shipment_num,
hdr_rec.need_by_date, hdr_rec.line_num,
hdr_rec.ship_to_org, ‘LNWEBADI’,
‘Y’, ‘Y’,
‘WEBADILNPO’, SYSDATE, hdr_rec.created_by,
SYSDATE, hdr_rec.created_by, ‘WEBADILNNTV’
–I.PO_DESCRIPTION
);
print_log (SQL%ROWCOUNT || ‘ Insert into po_lines_interface’);
lc_progress := ‘050’;
INSERT INTO po.po_distributions_interface
(interface_header_id, interface_line_id,
interface_distribution_id, distribution_num,
quantity_ordered, charge_account_segment1,
charge_account_segment2, charge_account_segment3,
charge_account_segment4, charge_account_segment5,
charge_account_segment6, charge_account_segment7,
charge_account_segment8
–, charge_account_segment9,
–charge_account_segment10
)
VALUES (ln_header_id, ln_line_id,
po.po_distributions_interface_s.NEXTVAL, 1,
hdr_rec.quantity, hdr_rec.segment1,
hdr_rec.segment2, hdr_rec.segment3,
hdr_rec.segment4, hdr_rec.segment5,
hdr_rec.segment6, hdr_rec.segment7,
hdr_rec.segment8
–, hdr_rec.segment9,
–hdr_rec.segment10
— Code Combination ID for the Charge Account to be used on the Distribution
);
print_log ( SQL%ROWCOUNT
|| ‘ Insert into po_distributions_interface’
);
lc_progress := ‘060’;
ELSE
INSERT INTO po_lines_interface
(interface_line_id, interface_header_id,
line_type_id, item,
item_description, unit_price,
uom_code, quantity, ship_to_location,
shipment_num, need_by_date,
–PROMISED_DATE,
line_num,
ship_to_organization_code, line_attribute15,
accrue_on_receipt_flag, taxable_flag,
line_attribute14, creation_date, created_by,
last_update_date, last_updated_by, note_to_vendor
)
VALUES (ln_line_id, ln_header_id,
hdr_rec.line_type_id, hdr_rec.item_code,
hdr_rec.item_description, hdr_rec.price,
hdr_rec.uom_code, NULL, hdr_rec.hdr_attribute1,
hdr_rec.shipment_num, NULL, — hdr_rec.need_by_date,
hdr_rec.line_num,
NULL, ‘LNWEBADI’,
‘Y’, ‘Y’,
‘WEBADILNPO’, SYSDATE, hdr_rec.created_by,
SYSDATE, hdr_rec.created_by, ‘WEBADILNNTV’
–I.PO_DESCRIPTION
);
print_log (SQL%ROWCOUNT || ‘ Insert into BPA po_lines_interface’);
lc_progress := ‘065’;
END IF;
UPDATE xxds_webadi_po_stg wad_stg
SET wad_stg.status = ‘I’,
inst_status = ‘Interfaced’,
last_updated_by = fnd_global.user_id,
last_update_date = SYSDATE,
last_update_login = fnd_global.login_id
WHERE rec_id = hdr_rec.rec_id AND batch_id = p_batch_id;
END LOOP;
COMMIT;
print_log ( lc_log_head
|| ‘ : Ended: : ‘
|| TO_CHAR (SYSDATE, ‘DD-Mon-RRRR HH24:MI:SS’)
);
EXCEPTION
WHEN OTHERS
THEN
print_log ( lc_log_head
|| ‘ : Exception : ‘
|| SQLERRM (SQLCODE)
|| ‘ : ‘
|| lc_progress
);
ROLLBACK;
END insert_po_iface;
PROCEDURE call_insert_poiface (p_batch_id IN NUMBER)
AS
l_ir_request_id NUMBER := NULL;
ln_org_id NUMBER := NULL;
lc_lookup_code fnd_lookup_values_vl.lookup_code%TYPE := NULL;
CURSOR cur_po_stg
IS
SELECT rec_id, batch_id, po_number, status
FROM xxds_webadi_po_stg x
WHERE x.batch_id = p_batch_id AND status IN (‘E’, ‘N’);
lx_status VARCHAR2 (240) := NULL;
lx_error_msg LONG := NULL;
l_log_head VARCHAR2 (1000)
:= gc_module_prefix || ‘call_insert_poiface’;
BEGIN
print_out ( l_log_head
|| ‘ :Started: ‘
|| TO_CHAR (SYSDATE, ‘DD-Mon-RRRR HH24:MI:SS’)
);
FOR po_rec IN cur_po_stg
LOOP
print_out ( ‘ Rec_id : ‘
|| po_rec.rec_id
|| ‘ – BatchId : ‘
|| p_batch_id
);
IF po_rec.status = ‘E’
THEN
DELETE FROM po.po_distributions_interface
WHERE interface_header_id IN (
SELECT interface_header_id
FROM po_headers_interface
WHERE batch_id = p_batch_id
AND document_num = po_rec.po_number);
DELETE FROM po_lines_interface
WHERE interface_header_id IN (
SELECT interface_header_id
FROM po_headers_interface
WHERE batch_id = p_batch_id
AND document_num = po_rec.po_number);
DELETE FROM po_headers_interface
WHERE batch_id = p_batch_id
AND document_num = po_rec.po_number;
END IF;
COMMIT;
pre_validation (p_batch_id, po_rec.rec_id, lx_status, lx_error_msg);
COMMIT;
END LOOP;
insert_po_iface (p_batch_id);
COMMIT;
print_out ( l_log_head
|| ‘ :Ended: ‘
|| TO_CHAR (SYSDATE, ‘DD-Mon-RRRR HH24:MI:SS’)
);
END call_insert_poiface;
PROCEDURE submit_po1 (
p_errbuf OUT VARCHAR2,
p_retcode OUT NUMBER,
p_buyer_id IN NUMBER DEFAULT NULL,
p_document_type IN VARCHAR2 DEFAULT NULL,
p_doc_sub_type IN VARCHAR2 DEFAULT NULL,
p_create_items IN VARCHAR2 DEFAULT NULL,
p_create_sourcing_rul IN VARCHAR2 DEFAULT NULL,
p_approval_status IN VARCHAR2 DEFAULT NULL,
p_rel_gen_method IN VARCHAR2 DEFAULT NULL,
p_batch_id IN NUMBER DEFAULT NULL,
p_operating_unit IN VARCHAR2 DEFAULT NULL,
p_global_agreement IN VARCHAR2 DEFAULT NULL,
p_enable_sourcing_level IN VARCHAR2 DEFAULT NULL,
p_sourcing_level IN VARCHAR2 DEFAULT NULL,
p_inv_org_enable IN VARCHAR2 DEFAULT NULL,
p_inventory_organization IN VARCHAR2 DEFAULT NULL
)
AS
l_ir_request_id NUMBER := NULL;
ln_org_id NUMBER := NULL;
lc_lookup_code fnd_lookup_values_vl.lookup_code%TYPE := NULL;
ln_exists_cnt NUMBER := 0;
BEGIN
call_insert_poiface (p_batch_id);
apps.fnd_global.apps_initialize (user_id => fnd_global.user_id,
resp_id => 50578,
resp_appl_id => 201
);
SELECT lookup_code
INTO lc_lookup_code
FROM fnd_lookup_values_vl
WHERE lookup_type = ‘POXMUB_DOCUMENT_TYPE’
AND UPPER (meaning) = UPPER (p_document_type);
BEGIN
SELECT organization_id
INTO ln_org_id
FROM hr_operating_units hou
WHERE NAME = p_operating_unit;
EXCEPTION
WHEN OTHERS
THEN
ln_org_id := NULL;
END;
COMMIT;
SELECT COUNT (*)
INTO ln_exists_cnt
FROM po_headers_interface
WHERE batch_id = p_batch_id AND process_code = ‘PENDING’;
–MO_GLOBAL.SET_POLICY_CONTEXT(‘S’,204);
IF ln_exists_cnt > 0
THEN
IF lc_lookup_code = ‘STANDARD’
THEN
l_ir_request_id :=
apps.fnd_request.submit_request
(application => ‘PO’,
program => ‘POXPOPDOI’,
description => ‘Import Standard Purchase Orders’,
start_time => SYSDATE,
argument1 => p_buyer_id,
argument2 => lc_lookup_code,
argument3 => p_doc_sub_type,
argument4 => p_create_items,
argument5 => p_create_sourcing_rul,
argument6 => p_approval_status,
argument7 => p_rel_gen_method,
argument8 => p_batch_id,
argument9 => ln_org_id,
argument10 => p_global_agreement,
argument11 => p_enable_sourcing_level,
argument12 => p_sourcing_level,
argument13 => p_inv_org_enable,
argument14 => p_inventory_organization
);
ELSE
l_ir_request_id :=
apps.fnd_request.submit_request
(application => ‘PO’,
program => ‘POXPDOI’,
description => ‘Import Price Catalogs’,
start_time => SYSDATE,
argument1 => p_buyer_id,
argument2 => lc_lookup_code,
argument3 => p_doc_sub_type,
argument4 => p_create_items,
argument5 => p_create_sourcing_rul,
argument6 => p_approval_status,
argument7 => p_rel_gen_method,
argument8 => p_batch_id,
argument9 => ln_org_id,
argument10 => p_global_agreement,
argument11 => p_enable_sourcing_level,
argument12 => p_sourcing_level,
argument13 => p_inv_org_enable,
argument14 => p_inventory_organization
);
END IF;
END IF;
COMMIT;
UPDATE xxds_webadi_po_stg wad_stg
SET imp_request_id = l_ir_request_id
WHERE batch_id = p_batch_id;
COMMIT;
END submit_po1;
PROCEDURE submit_po (
p_buyer_id IN NUMBER DEFAULT NULL,
p_document_type IN VARCHAR2 DEFAULT NULL,
p_doc_sub_type IN VARCHAR2 DEFAULT NULL,
p_create_items IN VARCHAR2 DEFAULT NULL,
p_create_sourcing_rul IN VARCHAR2 DEFAULT NULL,
p_approval_status IN VARCHAR2 DEFAULT NULL,
p_rel_gen_method IN VARCHAR2 DEFAULT NULL,
p_batch_id IN NUMBER DEFAULT NULL,
p_operating_unit IN VARCHAR2 DEFAULT NULL,
p_global_agreement IN VARCHAR2 DEFAULT NULL,
p_enable_sourcing_level IN VARCHAR2 DEFAULT NULL,
p_sourcing_level IN VARCHAR2 DEFAULT NULL,
p_inv_org_enable IN VARCHAR2 DEFAULT NULL,
p_inventory_organization IN VARCHAR2 DEFAULT NULL,
x_request_id OUT NUMBER
)
AS
l_ir_request_id NUMBER := NULL;
ln_org_id NUMBER := NULL;
lc_lookup_code fnd_lookup_values_vl.lookup_code%TYPE := NULL;
BEGIN
x_request_id := NULL;
END submit_po;
END xxds_po_iface_pkg;
/
