APPS.WMS_TASK_DISPATCH_ENGINE dependencies on STANDARD

Line 23: -- defined task type (standard_operation_id column ) has been

19: -- the most optimal task based on priority, locator picking
20: -- sequence, coordinates approximation, etc.
21: -- or reservation input parameters and creates recommendations
22: -- Pre-reqs : 1. For each record in MTL_MATERIAL_TRANSACTIONS_TEMP, user
23: -- defined task type (standard_operation_id column ) has been
24: -- assigned,
25: -- 2. System task type (wms_task_type column) has been assigned
26: -- 3. Pick methdology code (pick_rule_id column) and pick slip
27: -- number (pick_slip_number column) has been assigned

Line 30: -- p_api_version Standard Input Parameter

26: -- 3. Pick methdology code (pick_rule_id column) and pick slip
27: -- number (pick_slip_number column) has been assigned
28: --
29: -- Parameters :
30: -- p_api_version Standard Input Parameter
31: -- p_init_msg_list Standard Input Parameter
32: -- p_commit Standard Input Parameter
33: -- p_validation_level Standard Input Parameter
34: -- p_sign_on_emp_id NUMBER, sign on emplployee ID, mandatory

Line 31: -- p_init_msg_list Standard Input Parameter

27: -- number (pick_slip_number column) has been assigned
28: --
29: -- Parameters :
30: -- p_api_version Standard Input Parameter
31: -- p_init_msg_list Standard Input Parameter
32: -- p_commit Standard Input Parameter
33: -- p_validation_level Standard Input Parameter
34: -- p_sign_on_emp_id NUMBER, sign on emplployee ID, mandatory
35: -- p_sign_on_org_id NUMBER, org ID, mandatory

Line 32: -- p_commit Standard Input Parameter

28: --
29: -- Parameters :
30: -- p_api_version Standard Input Parameter
31: -- p_init_msg_list Standard Input Parameter
32: -- p_commit Standard Input Parameter
33: -- p_validation_level Standard Input Parameter
34: -- p_sign_on_emp_id NUMBER, sign on emplployee ID, mandatory
35: -- p_sign_on_org_id NUMBER, org ID, mandatory
36: -- p_sign_on_zone VARCHAR2, sign on sub ID, optional

Line 33: -- p_validation_level Standard Input Parameter

29: -- Parameters :
30: -- p_api_version Standard Input Parameter
31: -- p_init_msg_list Standard Input Parameter
32: -- p_commit Standard Input Parameter
33: -- p_validation_level Standard Input Parameter
34: -- p_sign_on_emp_id NUMBER, sign on emplployee ID, mandatory
35: -- p_sign_on_org_id NUMBER, org ID, mandatory
36: -- p_sign_on_zone VARCHAR2, sign on sub ID, optional
37: -- p_sign_on_equipment_id NUMBER, sign on equipment item ID, optional,

Line 48: -- x_return_status Standard Output Parameter

44: -- can be 'PICKING' or 'ALL'
45: --
46: --
47: -- Output Parameters
48: -- x_return_status Standard Output Parameter
49: -- x_msg_count Standard Output Parameter
50: -- x_msg_data Standard Output Parameter
51: -- x_task_cur Reference Cursor to deliver the queried tasks
52: -- It includes following fields:

Line 49: -- x_msg_count Standard Output Parameter

45: --
46: --
47: -- Output Parameters
48: -- x_return_status Standard Output Parameter
49: -- x_msg_count Standard Output Parameter
50: -- x_msg_data Standard Output Parameter
51: -- x_task_cur Reference Cursor to deliver the queried tasks
52: -- It includes following fields:
53: -- mmtt.transaction_temp_id NUMBER

Line 50: -- x_msg_data Standard Output Parameter

46: --
47: -- Output Parameters
48: -- x_return_status Standard Output Parameter
49: -- x_msg_count Standard Output Parameter
50: -- x_msg_data Standard Output Parameter
51: -- x_task_cur Reference Cursor to deliver the queried tasks
52: -- It includes following fields:
53: -- mmtt.transaction_temp_id NUMBER
54: -- mmtt.subinventory_code VARCHAR2

Line 179: (p_standard_operation_id IN NUMBER,

175:
176: /* end of patchset J bulk picking */
177:
178: FUNCTION is_equipment_cap_exceeded
179: (p_standard_operation_id IN NUMBER,
180: p_item_id IN NUMBER,
181: p_organization_id IN NUMBER,
182: p_txn_qty IN NUMBER,
183: p_txn_uom_code IN VARCHAR2)