[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT *
FROM mtl_demand_interface
WHERE rowid = X_Rowid
FOR UPDATE NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
PROCEDURE Update_Row( X_ROWID VARCHAR2,
X_SCHEDULE_GROUP_ID NUMBER,
X_DEMAND_SOURCE_TYPE NUMBER,
X_DEMAND_SOURCE_HEADER_ID NUMBER,
X_DEMAND_SOURCE_LINE VARCHAR2,
X_DEMAND_SOURCE_DELIVERY VARCHAR2,
X_ATP_CHECK NUMBER,
X_ACTION_CODE NUMBER,
X_VALIDATE_ROWS NUMBER,
X_TRANSACTION_MODE NUMBER,
X_PROCESS_FLAG NUMBER,
X_SINGLE_LOT_FLAG NUMBER,
X_DETAIL_RESERVE_FLAG NUMBER,
X_RESERVE_LEVEL NUMBER,
X_CHECK_ATR NUMBER,
X_LAST_UPDATE_DATE DATE,
X_LAST_UPDATED_BY NUMBER,
X_LAST_UPDATE_LOGIN NUMBER,
X_ERROR_CODE NUMBER,
X_ERR_EXPLANATION VARCHAR2,
X_REQUIREMENT_DATE DATE,
X_LINE_ITEM_UNIT_OF_MEASURE VARCHAR2,
X_LINE_ITEM_UOM VARCHAR2,
X_LINE_ITEM_QUANTITY NUMBER,
X_LINE_ITEM_RESERVATION_QTY NUMBER,
X_PRIMARY_UOM VARCHAR2,
X_PRIMARY_UOM_QUANTITY NUMBER,
X_RESERVATION_QUANTITY NUMBER,
X_ATP_RULE_ID NUMBER,
X_ORGANIZATION_ID NUMBER,
X_ORGANIZATION_NAME VARCHAR2,
X_INVENTORY_ITEM_ID NUMBER,
X_ITEM_SEGMENT1 VARCHAR2,
X_ITEM_SEGMENT2 VARCHAR2,
X_ITEM_SEGMENT3 VARCHAR2,
X_ITEM_SEGMENT4 VARCHAR2,
X_ITEM_SEGMENT5 VARCHAR2,
X_ITEM_SEGMENT6 VARCHAR2,
X_ITEM_SEGMENT7 VARCHAR2,
X_ITEM_SEGMENT8 VARCHAR2,
X_ITEM_SEGMENT9 VARCHAR2,
X_ITEM_SEGMENT10 VARCHAR2,
X_ITEM_SEGMENT11 VARCHAR2,
X_ITEM_SEGMENT12 VARCHAR2,
X_ITEM_SEGMENT13 VARCHAR2,
X_ITEM_SEGMENT14 VARCHAR2,
X_ITEM_SEGMENT15 VARCHAR2,
X_ITEM_SEGMENT16 VARCHAR2,
X_ITEM_SEGMENT17 VARCHAR2,
X_ITEM_SEGMENT18 VARCHAR2,
X_ITEM_SEGMENT19 VARCHAR2,
X_ITEM_SEGMENT20 VARCHAR2,
X_DEMAND_HEADER_SEGMENT1 VARCHAR2,
X_DEMAND_HEADER_SEGMENT2 VARCHAR2,
X_DEMAND_HEADER_SEGMENT3 VARCHAR2,
X_DEMAND_HEADER_SEGMENT4 VARCHAR2,
X_DEMAND_HEADER_SEGMENT5 VARCHAR2,
X_DEMAND_HEADER_SEGMENT6 VARCHAR2,
X_DEMAND_HEADER_SEGMENT7 VARCHAR2,
X_DEMAND_HEADER_SEGMENT8 VARCHAR2,
X_DEMAND_HEADER_SEGMENT9 VARCHAR2,
X_DEMAND_HEADER_SEGMENT10 VARCHAR2,
X_DEMAND_HEADER_SEGMENT11 VARCHAR2,
X_DEMAND_HEADER_SEGMENT12 VARCHAR2,
X_DEMAND_HEADER_SEGMENT13 VARCHAR2,
X_DEMAND_HEADER_SEGMENT14 VARCHAR2,
X_DEMAND_HEADER_SEGMENT15 VARCHAR2,
X_DEMAND_HEADER_SEGMENT16 VARCHAR2,
X_DEMAND_HEADER_SEGMENT17 VARCHAR2,
X_DEMAND_HEADER_SEGMENT18 VARCHAR2,
X_DEMAND_HEADER_SEGMENT19 VARCHAR2,
X_DEMAND_HEADER_SEGMENT20 VARCHAR2,
X_DEMAND_HEADER_SEGMENT21 VARCHAR2,
X_DEMAND_HEADER_SEGMENT22 VARCHAR2,
X_DEMAND_HEADER_SEGMENT23 VARCHAR2,
X_DEMAND_HEADER_SEGMENT24 VARCHAR2,
X_DEMAND_HEADER_SEGMENT25 VARCHAR2,
X_DEMAND_HEADER_SEGMENT26 VARCHAR2,
X_DEMAND_HEADER_SEGMENT27 VARCHAR2,
X_DEMAND_HEADER_SEGMENT28 VARCHAR2,
X_DEMAND_HEADER_SEGMENT29 VARCHAR2,
X_DEMAND_HEADER_SEGMENT30 VARCHAR2,
X_EXTERNAL_SOURCE_CODE VARCHAR2,
X_EXTERNAL_SOURCE_LINE_ID NUMBER,
X_SUPPLY_SOURCE_TYPE NUMBER,
X_SUPPLY_HEADER_ID NUMBER,
X_USER_LINE_NUM VARCHAR2,
X_USER_DELIVERY VARCHAR2,
X_REVISION VARCHAR2,
X_LOT_NUMBER VARCHAR2,
X_SERIAL_NUMBER VARCHAR2,
X_SUBINVENTORY VARCHAR2,
X_LOCATOR_ID NUMBER,
X_LOC_SEGMENT1 VARCHAR2,
X_LOC_SEGMENT2 VARCHAR2,
X_LOC_SEGMENT3 VARCHAR2,
X_LOC_SEGMENT4 VARCHAR2,
X_LOC_SEGMENT5 VARCHAR2,
X_LOC_SEGMENT6 VARCHAR2,
X_LOC_SEGMENT7 VARCHAR2,
X_LOC_SEGMENT8 VARCHAR2,
X_LOC_SEGMENT9 VARCHAR2,
X_LOC_SEGMENT10 VARCHAR2,
X_LOC_SEGMENT11 VARCHAR2,
X_LOC_SEGMENT12 VARCHAR2,
X_LOC_SEGMENT13 VARCHAR2,
X_LOC_SEGMENT14 VARCHAR2,
X_LOC_SEGMENT15 VARCHAR2,
X_LOC_SEGMENT16 VARCHAR2,
X_LOC_SEGMENT17 VARCHAR2,
X_LOC_SEGMENT18 VARCHAR2,
X_LOC_SEGMENT19 VARCHAR2,
X_LOC_SEGMENT20 VARCHAR2,
X_AUTODETAIL_GROUP_ID NUMBER,
X_COMPONENT_SEQUENCE_ID NUMBER,
X_PARENT_COMPONENT_SEQ_ID NUMBER,
X_RTO_MODEL_SOURCE_LINE VARCHAR2,
X_CONFIG_STATUS NUMBER,
X_OLD_REVISION VARCHAR2,
X_OLD_LOT_NUMBER VARCHAR2,
X_OLD_SUBINVENTORY VARCHAR2,
X_OLD_LOCATOR_ID NUMBER,
X_OLD_LOC_SEGMENT1 VARCHAR2,
X_OLD_LOC_SEGMENT2 VARCHAR2,
X_OLD_LOC_SEGMENT3 VARCHAR2,
X_OLD_LOC_SEGMENT4 VARCHAR2,
X_OLD_LOC_SEGMENT5 VARCHAR2,
X_OLD_LOC_SEGMENT6 VARCHAR2,
X_OLD_LOC_SEGMENT7 VARCHAR2,
X_OLD_LOC_SEGMENT8 VARCHAR2,
X_OLD_LOC_SEGMENT9 VARCHAR2,
X_OLD_LOC_SEGMENT10 VARCHAR2,
X_OLD_LOC_SEGMENT11 VARCHAR2,
X_OLD_LOC_SEGMENT12 VARCHAR2,
X_OLD_LOC_SEGMENT13 VARCHAR2,
X_OLD_LOC_SEGMENT14 VARCHAR2,
X_OLD_LOC_SEGMENT15 VARCHAR2,
X_OLD_LOC_SEGMENT16 VARCHAR2,
X_OLD_LOC_SEGMENT17 VARCHAR2,
X_OLD_LOC_SEGMENT18 VARCHAR2,
X_OLD_LOC_SEGMENT19 VARCHAR2,
X_OLD_LOC_SEGMENT20 VARCHAR2,
X_DEMAND_CLASS VARCHAR2,
X_CUSTOMER_ID NUMBER,
X_TERRITORY_ID NUMBER,
X_BILL_TO_SITE_USE_ID NUMBER,
X_SHIP_TO_SITE_USE_ID NUMBER,
X_LOT_EXPIRATION_CUTOFF_DATE DATE,
X_PARTIALS_ALLOWED_FLAG NUMBER,
X_REQUEST_DATE_ATP_QUANTITY NUMBER,
X_EARLIEST_ATP_DATE DATE,
X_EARLIEST_ATP_DATE_QUANTITY NUMBER,
X_REQUEST_ATP_DATE DATE,
X_REQUEST_ATP_DATE_QUANTITY NUMBER,
X_GROUP_AVAILABLE_DATE DATE,
X_ATP_LEAD_TIME NUMBER,
X_INFINITE_TIME_FENCE_DATE DATE,
X_GROUP_ATP_CHECK NUMBER,
X_BOM_LEVEL NUMBER,
X_EXPLOSION_EFFECTIVITY_DATE DATE,
X_ATTRIBUTE_CATEGORY VARCHAR2,
X_ATTRIBUTE1 VARCHAR2,
X_ATTRIBUTE2 VARCHAR2,
X_ATTRIBUTE3 VARCHAR2,
X_ATTRIBUTE4 VARCHAR2,
X_ATTRIBUTE5 VARCHAR2,
X_ATTRIBUTE6 VARCHAR2,
X_ATTRIBUTE7 VARCHAR2,
X_ATTRIBUTE8 VARCHAR2,
X_ATTRIBUTE9 VARCHAR2,
X_ATTRIBUTE10 VARCHAR2,
X_ATTRIBUTE11 VARCHAR2,
X_ATTRIBUTE12 VARCHAR2,
X_ATTRIBUTE13 VARCHAR2,
X_ATTRIBUTE14 VARCHAR2,
X_ATTRIBUTE15 VARCHAR2,
X_C_COLUMN1 VARCHAR2,
X_C_COLUMN2 VARCHAR2,
X_C_COLUMN3 VARCHAR2,
X_C_COLUMN4 VARCHAR2,
X_C_COLUMN5 VARCHAR2,
X_C_COLUMN6 VARCHAR2,
X_C_COLUMN7 VARCHAR2,
X_C_COLUMN8 VARCHAR2,
X_N_COLUMN1 NUMBER,
X_N_COLUMN2 NUMBER,
X_N_COLUMN3 NUMBER,
X_N_COLUMN4 NUMBER,
X_N_COLUMN5 NUMBER,
X_D_COLUMN1 DATE,
X_D_COLUMN2 DATE,
X_D_COLUMN3 DATE,
X_D_COLUMN4 DATE,
X_D_COLUMN5 DATE,
X_TRANSACTION_PROCESS_ORDER NUMBER,
X_DEMAND_ID NUMBER,
X_DEMAND_SOURCE_NAME VARCHAR2,
X_DEMAND_TYPE NUMBER,
X_AVAILABLE_TO_RESERVE NUMBER,
X_QUANTITY_ON_HAND NUMBER,
X_ATP_COMPONENTS_FLAG NUMBER,
X_ATP_CALENDAR_ORGANIZATION_ID NUMBER,
X_AUTODETAIL_EXPENSE_SUBINV NUMBER
) IS
BEGIN
UPDATE mtl_demand_interface
SET
SCHEDULE_GROUP_ID = X_Schedule_Group_Id,
DEMAND_SOURCE_TYPE = X_DEMAND_SOURCE_TYPE,
DEMAND_SOURCE_HEADER_ID = X_DEMAND_SOURCE_HEADER_ID,
DEMAND_SOURCE_LINE = X_DEMAND_SOURCE_LINE,
DEMAND_SOURCE_DELIVERY = X_DEMAND_SOURCE_DELIVERY,
ATP_CHECK = X_ATP_CHECK,
ACTION_CODE = X_ACTION_CODE,
VALIDATE_ROWS = X_VALIDATE_ROWS,
TRANSACTION_MODE = X_TRANSACTION_MODE,
PROCESS_FLAG = X_PROCESS_FLAG,
SINGLE_LOT_FLAG = X_SINGLE_LOT_FLAG,
DETAIL_RESERVE_FLAG = X_DETAIL_RESERVE_FLAG,
RESERVE_LEVEL = X_RESERVE_LEVEL,
CHECK_ATR = X_CHECK_ATR,
LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
LAST_UPDATED_BY = X_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
ERROR_CODE = X_ERROR_CODE,
ERR_EXPLANATION = X_ERR_EXPLANATION,
REQUIREMENT_DATE = X_REQUIREMENT_DATE,
LINE_ITEM_UNIT_OF_MEASURE = X_LINE_ITEM_UNIT_OF_MEASURE,
LINE_ITEM_UOM = X_LINE_ITEM_UOM,
LINE_ITEM_QUANTITY = X_LINE_ITEM_QUANTITY,
LINE_ITEM_RESERVATION_QTY = X_LINE_ITEM_RESERVATION_QTY,
PRIMARY_UOM = X_PRIMARY_UOM,
PRIMARY_UOM_QUANTITY = X_PRIMARY_UOM_QUANTITY,
RESERVATION_QUANTITY = X_RESERVATION_QUANTITY,
ATP_RULE_ID = X_ATP_RULE_ID,
ORGANIZATION_ID = X_ORGANIZATION_ID,
ORGANIZATION_NAME = X_ORGANIZATION_NAME,
INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID,
ITEM_SEGMENT1 = X_ITEM_SEGMENT1,
ITEM_SEGMENT2 = X_ITEM_SEGMENT2,
ITEM_SEGMENT3 = X_ITEM_SEGMENT3,
ITEM_SEGMENT4 = X_ITEM_SEGMENT4,
ITEM_SEGMENT5 = X_ITEM_SEGMENT5,
ITEM_SEGMENT6 = X_ITEM_SEGMENT6,
ITEM_SEGMENT7 = X_ITEM_SEGMENT7,
ITEM_SEGMENT8 = X_ITEM_SEGMENT8,
ITEM_SEGMENT9 = X_ITEM_SEGMENT9,
ITEM_SEGMENT10 = X_ITEM_SEGMENT10,
ITEM_SEGMENT11 = X_ITEM_SEGMENT11,
ITEM_SEGMENT12 = X_ITEM_SEGMENT12,
ITEM_SEGMENT13 = X_ITEM_SEGMENT13,
ITEM_SEGMENT14 = X_ITEM_SEGMENT14,
ITEM_SEGMENT15 = X_ITEM_SEGMENT15,
ITEM_SEGMENT16 = X_ITEM_SEGMENT16,
ITEM_SEGMENT17 = X_ITEM_SEGMENT17,
ITEM_SEGMENT18 = X_ITEM_SEGMENT18,
ITEM_SEGMENT19 = X_ITEM_SEGMENT19,
ITEM_SEGMENT20 = X_ITEM_SEGMENT20,
DEMAND_HEADER_SEGMENT1 = X_DEMAND_HEADER_SEGMENT1,
DEMAND_HEADER_SEGMENT2 = X_DEMAND_HEADER_SEGMENT2,
DEMAND_HEADER_SEGMENT3 = X_DEMAND_HEADER_SEGMENT3,
DEMAND_HEADER_SEGMENT4 = X_DEMAND_HEADER_SEGMENT4,
DEMAND_HEADER_SEGMENT5 = X_DEMAND_HEADER_SEGMENT5,
DEMAND_HEADER_SEGMENT6 = X_DEMAND_HEADER_SEGMENT6,
DEMAND_HEADER_SEGMENT7 = X_DEMAND_HEADER_SEGMENT7,
DEMAND_HEADER_SEGMENT8 = X_DEMAND_HEADER_SEGMENT8,
DEMAND_HEADER_SEGMENT9 = X_DEMAND_HEADER_SEGMENT9,
DEMAND_HEADER_SEGMENT10 = X_DEMAND_HEADER_SEGMENT10,
DEMAND_HEADER_SEGMENT11 = X_DEMAND_HEADER_SEGMENT11,
DEMAND_HEADER_SEGMENT12 = X_DEMAND_HEADER_SEGMENT12,
DEMAND_HEADER_SEGMENT13 = X_DEMAND_HEADER_SEGMENT13,
DEMAND_HEADER_SEGMENT14 = X_DEMAND_HEADER_SEGMENT14,
DEMAND_HEADER_SEGMENT15 = X_DEMAND_HEADER_SEGMENT15,
DEMAND_HEADER_SEGMENT16 = X_DEMAND_HEADER_SEGMENT16,
DEMAND_HEADER_SEGMENT17 = X_DEMAND_HEADER_SEGMENT17,
DEMAND_HEADER_SEGMENT18 = X_DEMAND_HEADER_SEGMENT18,
DEMAND_HEADER_SEGMENT19 = X_DEMAND_HEADER_SEGMENT19,
DEMAND_HEADER_SEGMENT20 = X_DEMAND_HEADER_SEGMENT20,
DEMAND_HEADER_SEGMENT21 = X_DEMAND_HEADER_SEGMENT21,
DEMAND_HEADER_SEGMENT22 = X_DEMAND_HEADER_SEGMENT22,
DEMAND_HEADER_SEGMENT23 = X_DEMAND_HEADER_SEGMENT23,
DEMAND_HEADER_SEGMENT24 = X_DEMAND_HEADER_SEGMENT24,
DEMAND_HEADER_SEGMENT25 = X_DEMAND_HEADER_SEGMENT25,
DEMAND_HEADER_SEGMENT26 = X_DEMAND_HEADER_SEGMENT26,
DEMAND_HEADER_SEGMENT27 = X_DEMAND_HEADER_SEGMENT27,
DEMAND_HEADER_SEGMENT28 = X_DEMAND_HEADER_SEGMENT28,
DEMAND_HEADER_SEGMENT29 = X_DEMAND_HEADER_SEGMENT29,
DEMAND_HEADER_SEGMENT30 = X_DEMAND_HEADER_SEGMENT30,
EXTERNAL_SOURCE_CODE = X_EXTERNAL_SOURCE_CODE,
EXTERNAL_SOURCE_LINE_ID = X_EXTERNAL_SOURCE_LINE_ID ,
SUPPLY_SOURCE_TYPE = X_SUPPLY_SOURCE_TYPE,
SUPPLY_HEADER_ID = X_SUPPLY_HEADER_ID,
USER_LINE_NUM = X_USER_LINE_NUM,
USER_DELIVERY = X_USER_DELIVERY,
REVISION = X_REVISION,
LOT_NUMBER = X_LOT_NUMBER,
SERIAL_NUMBER = X_SERIAL_NUMBER,
SUBINVENTORY = X_SUBINVENTORY,
LOCATOR_ID = X_LOCATOR_ID,
LOC_SEGMENT1 = X_LOC_SEGMENT1,
LOC_SEGMENT2 = X_LOC_SEGMENT2,
LOC_SEGMENT3 = X_LOC_SEGMENT3,
LOC_SEGMENT4 = X_LOC_SEGMENT4,
LOC_SEGMENT5 = X_LOC_SEGMENT5,
LOC_SEGMENT6 = X_LOC_SEGMENT6,
LOC_SEGMENT7 = X_LOC_SEGMENT7,
LOC_SEGMENT8 = X_LOC_SEGMENT8,
LOC_SEGMENT9 = X_LOC_SEGMENT9,
LOC_SEGMENT10 = X_LOC_SEGMENT10,
LOC_SEGMENT11 = X_LOC_SEGMENT11,
LOC_SEGMENT12 = X_LOC_SEGMENT12,
LOC_SEGMENT13 = X_LOC_SEGMENT13,
LOC_SEGMENT14 = X_LOC_SEGMENT14,
LOC_SEGMENT15 = X_LOC_SEGMENT15,
LOC_SEGMENT16 = X_LOC_SEGMENT16,
LOC_SEGMENT17 = X_LOC_SEGMENT17,
LOC_SEGMENT18 = X_LOC_SEGMENT18,
LOC_SEGMENT19 = X_LOC_SEGMENT19,
LOC_SEGMENT20 = X_LOC_SEGMENT20,
AUTODETAIL_GROUP_ID = X_AUTODETAIL_GROUP_ID,
COMPONENT_SEQUENCE_ID = X_COMPONENT_SEQUENCE_ID,
PARENT_COMPONENT_SEQ_ID = X_PARENT_COMPONENT_SEQ_ID,
RTO_MODEL_SOURCE_LINE = X_RTO_MODEL_SOURCE_LINE,
CONFIG_STATUS = X_CONFIG_STATUS,
OLD_REVISION = X_OLD_REVISION,
OLD_LOT_NUMBER = X_OLD_LOT_NUMBER,
OLD_SUBINVENTORY = X_OLD_SUBINVENTORY,
OLD_LOCATOR_ID = X_OLD_LOCATOR_ID,
OLD_LOC_SEGMENT1 = X_OLD_LOC_SEGMENT1,
OLD_LOC_SEGMENT2 = X_OLD_LOC_SEGMENT2,
OLD_LOC_SEGMENT3 = X_OLD_LOC_SEGMENT3,
OLD_LOC_SEGMENT4 = X_OLD_LOC_SEGMENT4,
OLD_LOC_SEGMENT5 = X_OLD_LOC_SEGMENT5,
OLD_LOC_SEGMENT6 = X_OLD_LOC_SEGMENT6,
OLD_LOC_SEGMENT7 = X_OLD_LOC_SEGMENT7,
OLD_LOC_SEGMENT8 = X_OLD_LOC_SEGMENT8,
OLD_LOC_SEGMENT9 = X_OLD_LOC_SEGMENT9,
OLD_LOC_SEGMENT10 = X_OLD_LOC_SEGMENT10,
OLD_LOC_SEGMENT11 = X_OLD_LOC_SEGMENT11,
OLD_LOC_SEGMENT12 = X_OLD_LOC_SEGMENT12,
OLD_LOC_SEGMENT13 = X_OLD_LOC_SEGMENT13,
OLD_LOC_SEGMENT14 = X_OLD_LOC_SEGMENT14,
OLD_LOC_SEGMENT15 = X_OLD_LOC_SEGMENT15,
OLD_LOC_SEGMENT16 = X_OLD_LOC_SEGMENT16,
OLD_LOC_SEGMENT17 = X_OLD_LOC_SEGMENT17,
OLD_LOC_SEGMENT18 = X_OLD_LOC_SEGMENT18,
OLD_LOC_SEGMENT19 = X_OLD_LOC_SEGMENT19,
OLD_LOC_SEGMENT20 = X_OLD_LOC_SEGMENT20,
DEMAND_CLASS = X_DEMAND_CLASS,
CUSTOMER_ID = X_CUSTOMER_ID,
TERRITORY_ID = X_TERRITORY_ID,
BILL_TO_SITE_USE_ID = X_BILL_TO_SITE_USE_ID,
SHIP_TO_SITE_USE_ID = X_SHIP_TO_SITE_USE_ID,
LOT_EXPIRATION_CUTOFF_DATE = X_LOT_EXPIRATION_CUTOFF_DATE,
PARTIALS_ALLOWED_FLAG = X_PARTIALS_ALLOWED_FLAG,
REQUEST_DATE_ATP_QUANTITY = X_REQUEST_DATE_ATP_QUANTITY ,
EARLIEST_ATP_DATE = X_EARLIEST_ATP_DATE,
EARLIEST_ATP_DATE_QUANTITY = X_EARLIEST_ATP_DATE_QUANTITY ,
REQUEST_ATP_DATE = X_REQUEST_ATP_DATE,
REQUEST_ATP_DATE_QUANTITY = X_REQUEST_ATP_DATE_QUANTITY,
GROUP_AVAILABLE_DATE = X_GROUP_AVAILABLE_DATE,
ATP_LEAD_TIME = X_ATP_LEAD_TIME,
INFINITE_TIME_FENCE_DATE = X_INFINITE_TIME_FENCE_DATE,
GROUP_ATP_CHECK = X_GROUP_ATP_CHECK,
BOM_LEVEL = X_BOM_LEVEL,
EXPLOSION_EFFECTIVITY_DATE = X_EXPLOSION_EFFECTIVITY_DATE ,
ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
ATTRIBUTE1 = X_ATTRIBUTE1,
ATTRIBUTE2 = X_ATTRIBUTE2,
ATTRIBUTE3 = X_ATTRIBUTE3,
ATTRIBUTE4 = X_ATTRIBUTE4,
ATTRIBUTE5 = X_ATTRIBUTE5,
ATTRIBUTE6 = X_ATTRIBUTE6,
ATTRIBUTE7 = X_ATTRIBUTE7,
ATTRIBUTE8 = X_ATTRIBUTE8,
ATTRIBUTE9 = X_ATTRIBUTE9,
ATTRIBUTE10 = X_ATTRIBUTE10,
ATTRIBUTE11 = X_ATTRIBUTE11,
ATTRIBUTE12 = X_ATTRIBUTE12,
ATTRIBUTE13 = X_ATTRIBUTE13,
ATTRIBUTE14 = X_ATTRIBUTE14,
ATTRIBUTE15 = X_ATTRIBUTE15,
C_COLUMN1 = X_C_COLUMN1,
C_COLUMN2 = X_C_COLUMN2,
C_COLUMN3 = X_C_COLUMN3,
C_COLUMN4 = X_C_COLUMN4,
C_COLUMN5 = X_C_COLUMN5,
C_COLUMN6 = X_C_COLUMN6,
C_COLUMN7 = X_C_COLUMN7,
C_COLUMN8 = X_C_COLUMN8,
N_COLUMN1 = X_N_COLUMN1,
N_COLUMN2 = X_N_COLUMN2,
N_COLUMN3 = X_N_COLUMN3,
N_COLUMN4 = X_N_COLUMN4,
N_COLUMN5 = X_N_COLUMN5,
D_COLUMN1 = X_D_COLUMN1 ,
D_COLUMN2 = X_D_COLUMN2,
D_COLUMN3 = X_D_COLUMN3,
D_COLUMN4 = X_D_COLUMN4,
D_COLUMN5 = X_D_COLUMN5,
TRANSACTION_PROCESS_ORDER = X_TRANSACTION_PROCESS_ORDER,
DEMAND_ID = X_DEMAND_ID,
DEMAND_SOURCE_NAME = X_DEMAND_SOURCE_NAME,
DEMAND_TYPE = X_DEMAND_TYPE,
AVAILABLE_TO_RESERVE = X_AVAILABLE_TO_RESERVE,
QUANTITY_ON_HAND = X_QUANTITY_ON_HAND,
ATP_COMPONENTS_FLAG = X_ATP_COMPONENTS_FLAG,
ATP_CALENDAR_ORGANIZATION_ID = X_ATP_CALENDAR_ORGANIZATION_ID,
AUTODETAIL_EXPENSE_SUBINV_FLAG = X_AUTODETAIL_EXPENSE_SUBINV
WHERE rowid = X_Rowid;
END Update_Row;