37: --
38: -- 2. Serial Number Detailing in Picking
39: -- Currently the serial number detailing is quite simple. If the caller
40: -- gives a range (start, and end) serial numbers in the move order line
41: -- and pass p_suggest_serial as fnd_api.true, the engine will filter
42: -- the locations found from a rule, and suggest unused serial numbers
43: -- in the locator. If p_suggest_serial is passed as fnd_api.g_false
44: -- (default), the engine will not give serial numbers in the output.
45: --
39: -- Currently the serial number detailing is quite simple. If the caller
40: -- gives a range (start, and end) serial numbers in the move order line
41: -- and pass p_suggest_serial as fnd_api.true, the engine will filter
42: -- the locations found from a rule, and suggest unused serial numbers
43: -- in the locator. If p_suggest_serial is passed as fnd_api.g_false
44: -- (default), the engine will not give serial numbers in the output.
45: --
46: -- Input Parameters
47: -- p_api_version_number standard input parameter
70: -- This project is available only in for R121 and mainline. To retain dual maintenance INV code changes are made in branchline, however it will not affect any existing flow.
71: PROCEDURE create_suggestions
72: (
73: p_api_version IN NUMBER,
74: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
75: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
76: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_none,
77: x_return_status OUT NOCOPY VARCHAR2,
78: x_msg_count OUT NOCOPY NUMBER,
71: PROCEDURE create_suggestions
72: (
73: p_api_version IN NUMBER,
74: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
75: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
76: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_none,
77: x_return_status OUT NOCOPY VARCHAR2,
78: x_msg_count OUT NOCOPY NUMBER,
79: x_msg_data OUT NOCOPY VARCHAR2,
72: (
73: p_api_version IN NUMBER,
74: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
75: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
76: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_none,
77: x_return_status OUT NOCOPY VARCHAR2,
78: x_msg_count OUT NOCOPY NUMBER,
79: x_msg_data OUT NOCOPY VARCHAR2,
80: p_transaction_temp_id IN NUMBER,
78: x_msg_count OUT NOCOPY NUMBER,
79: x_msg_data OUT NOCOPY VARCHAR2,
80: p_transaction_temp_id IN NUMBER,
81: p_reservations IN inv_reservation_global.mtl_reservation_tbl_type,
82: p_suggest_serial IN VARCHAR2 DEFAULT fnd_api.g_false,
83: p_plan_tasks IN BOOLEAN DEFAULT FALSE,
84: p_quick_pick_flag IN VARCHAR2 DEFAULT 'N',
85: p_wave_simulation_mode IN VARCHAR2 DEFAULT 'N'
86: ) ;
93: -- Overloaded to add a new parameter p_organization_id for Performance bug 5264987
94: PROCEDURE create_suggestions
95: (
96: p_api_version IN NUMBER,
97: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
98: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
99: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_none,
100: x_return_status OUT NOCOPY VARCHAR2,
101: x_msg_count OUT NOCOPY NUMBER,
94: PROCEDURE create_suggestions
95: (
96: p_api_version IN NUMBER,
97: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
98: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
99: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_none,
100: x_return_status OUT NOCOPY VARCHAR2,
101: x_msg_count OUT NOCOPY NUMBER,
102: x_msg_data OUT NOCOPY VARCHAR2,
95: (
96: p_api_version IN NUMBER,
97: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
98: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
99: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_none,
100: x_return_status OUT NOCOPY VARCHAR2,
101: x_msg_count OUT NOCOPY NUMBER,
102: x_msg_data OUT NOCOPY VARCHAR2,
103: p_transaction_temp_id IN NUMBER,
101: x_msg_count OUT NOCOPY NUMBER,
102: x_msg_data OUT NOCOPY VARCHAR2,
103: p_transaction_temp_id IN NUMBER,
104: p_reservations IN inv_reservation_global.mtl_reservation_tbl_type,
105: p_suggest_serial IN VARCHAR2 DEFAULT fnd_api.g_false,
106: p_plan_tasks IN BOOLEAN DEFAULT FALSE,
107: p_quick_pick_flag IN VARCHAR2 DEFAULT 'N',
108: p_organization_id IN NUMBER,
109: p_wave_simulation_mode IN VARCHAR2 DEFAULT 'N'