[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_update_status_method IN VARCHAR2 DEFAULT NULL,
P_LOT_NUMBER IN VARCHAR2 DEFAULT NULL,
p_to_lot_number IN VARCHAR2 DEFAULT NULL,
P_LOT_STATUS IN VARCHAR2 DEFAULT NULL,
P_SUBLOT_NUMBER IN VARCHAR2 DEFAULT NULL,
P_SUBLOT_STATUS IN VARCHAR2 DEFAULT NULL,
P_SOURCE_SUBINVENTORY IN VARCHAR2 DEFAULT NULL,
P_SOURCE_SUBINVENTORY_STATUS IN VARCHAR2 DEFAULT NULL,
P_DESTINATION_SUBINVENTORY IN VARCHAR2 DEFAULT NULL,
P_DESTINATION_SUBINVENTORY_ST IN VARCHAR2 DEFAULT NULL,
P_SOURCE_LOCATOR IN NUMBER DEFAULT NULL,
P_SOURCE_LOCATOR_STATUS IN VARCHAR2 DEFAULT NULL,
P_DESTINATION_LOCATOR IN NUMBER DEFAULT NULL,
P_DESTINATION_LOCATOR_STATUS IN VARCHAR2 DEFAULT NULL,
P_SOURCE_IMMEDIATE_LPN_ID IN NUMBER DEFAULT NULL,
P_SOURCE_IMMEDIATE_LPN_STATUS IN VARCHAR2 DEFAULT NULL,
P_SOURCE_TOPLEVEL_LPN_ID IN NUMBER DEFAULT NULL,
P_SOURCE_TOPLEVEL_LPN_STATUS IN VARCHAR2 DEFAULT NULL,
P_DEST_IMMEDIATE_LPN_ID IN NUMBER DEFAULT NULL,
P_DEST_IMMEDIATE_LPN_STATUS IN VARCHAR2 DEFAULT NULL,
P_DEST_TOPLEVEL_LPN_ID IN NUMBER DEFAULT NULL,
P_DEST_TOPLEVEL_LPN_STATUS IN VARCHAR2 DEFAULT NULL,
P_SERIAL_NUMBER IN VARCHAR2 DEFAULT NULL,
p_to_serial_number IN VARCHAR2 DEFAULT NULL,
P_SERIAL_NUMBER_STATUS IN VARCHAR2 DEFAULT NULL,
P_PRIMARY_UOM IN VARCHAR2 DEFAULT NULL,
P_TRANSACTION_UOM IN VARCHAR2 DEFAULT NULL,
P_PRIMARY_QUANTITY IN NUMBER DEFAULT NULL,
P_TRANSACTION_QUANTITY IN NUMBER DEFAULT NULL,
P_TRANSACTION_ACTION_ID IN NUMBER DEFAULT NULL,
P_TRANSACTION_SOURCE_TYPE_ID IN NUMBER DEFAULT NULL,
P_TRANSACTION_SOURCE IN VARCHAR2 DEFAULT NULL,
P_PARENT_TRANSACTION_SOURCE IN VARCHAR2 DEFAULT NULL,
P_PARENT_TRANS_ACTION_ID IN NUMBER DEFAULT NULL,
P_PARENT_TRANS_SOURCE_TYPE_ID IN NUMBER DEFAULT NULL,
P_RESERVATION_ID IN NUMBER DEFAULT NULL,
P_EQUIPMENT_ID IN NUMBER DEFAULT NULL,
P_ROLE_ID IN NUMBER DEFAULT NULL,
P_EMPLOYEE_ID IN NUMBER DEFAULT NULL,
P_TASK_TYPE_ID IN NUMBER DEFAULT NULL,
P_TASK_ID IN NUMBER DEFAULT NULL,
P_CALLING_PROGRAM_NAME IN VARCHAR2 DEFAULT NULL,
P_EMAIL_ID IN VARCHAR2 DEFAULT NULL,
P_PROGRAM_NAME IN VARCHAR2 DEFAULT NULL,
P_RUN_MODE IN VARCHAR2 DEFAULT NULL,
P_INIT_MSG_LST IN VARCHAR2 DEFAULT fnd_api.g_false,
P_PROGRAM_CONTROL_ARG1 IN VARCHAR2 DEFAULT NULL,
P_PROGRAM_CONTROL_ARG2 IN VARCHAR2 DEFAULT NULL,
P_PROGRAM_CONTROL_ARG3 IN VARCHAR2 DEFAULT NULL,
P_PROGRAM_CONTROL_ARG4 IN VARCHAR2 DEFAULT NULL,
P_PROGRAM_CONTROL_ARG5 IN VARCHAR2 DEFAULT NULL,
P_PROGRAM_CONTROL_ARG6 IN VARCHAR2 DEFAULT NULL,
X_RETURN_STATUS OUT NOCOPY VARCHAR2,
X_MSG_DATA OUT NOCOPY VARCHAR2,
X_MSG_COUNT OUT NOCOPY NUMBER,
X_REVISION OUT NOCOPY VARCHAR2,
X_LOT_NUMBER OUT NOCOPY VARCHAR2,
X_LOT_STATUS OUT NOCOPY VARCHAR2,
X_SUBLOT_NUMBER OUT NOCOPY VARCHAR2,
X_SUBLOT_STATUS OUT NOCOPY VARCHAR2,
X_LPN_ID OUT NOCOPY NUMBER,
X_LPN_STATUS OUT NOCOPY VARCHAR2,
X_UOM_CODE OUT NOCOPY VARCHAR2,
X_QUANTITY OUT NOCOPY NUMBER,
X_INVENTORY_ITEM_ID OUT NOCOPY NUMBER,
X_ORGANIZATION_ID OUT NOCOPY NUMBER,
X_SUBINVENTORY OUT NOCOPY VARCHAR2,
X_SUBINVENTORY_STATUS OUT NOCOPY VARCHAR2,
X_LOCATOR OUT NOCOPY NUMBER,
X_LOCATOR_STATUS OUT NOCOPY VARCHAR2,
X_PRIMARY_QUANTITY OUT NOCOPY NUMBER,
X_TRANSACTION_QUANTITY OUT NOCOPY NUMBER,
X_NEXT_FORM OUT NOCOPY VARCHAR2,
X_NEXT_MOBILE_FORM OUT NOCOPY VARCHAR2,
X_NEXT_PLSQL_PROGRAM OUT NOCOPY VARCHAR2,
X_RESERVATION_ID OUT NOCOPY NUMBER,
X_IS_RESERVATION_SUCCESSFUL OUT NOCOPY VARCHAR2,
X_IS_CYCLE_COUNT_SUCCESSFUL OUT NOCOPY VARCHAR2
) IS
l_reason_name varchar2(250);
mdebug('Before Select WORKFLOW_NAME, WORKFLOW_PROCESS ');
SELECT WORKFLOW_NAME, WORKFLOW_PROCESS
INTO l_workflow_name, l_workflow_process
FROM MTL_TRANSACTION_REASONS
WHERE P_REASON_ID = REASON_ID ;
SELECT WMS_DISPATCHED_TASKS_S.nextval
INTO l_sequence_number
FROM DUAL ;
aname => 'PW_UPDATE_STATUS_METHOD',
avalue => P_UPDATE_STATUS_METHOD);