Following is the script to insert XML
data from a file to oracle database tables
INSERT INTO XX_ONRPTS_STG_TAB (DOCUMENT_NUM,
HEADER_ID,
RELEASE_NO,
RELEASE_ID,
DOCUMENT_LINE_NUM,
ITEM_NUM,
REC_QUANTITY,
LINE_ID,
LINE_LOCATION_ID,
TRANSACTION_ID,
FILE_NAME)