[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
/* To insert lines into lines table, identify all wave lines need to be inserted and populate it into PLSQL table x_custom_line_tbl.
In corresponding record of PLSQL table x_custom_line_action_tbl populate value 'ADD'. For example:
x_custom_line_tbl(i).WAVE_HEADER_ID := p_wave_header_id;
x_custom_line_tbl(i).LAST_UPDATED_BY := fnd_global.user_id;
x_custom_line_tbl(i).LAST_UPDATE_DATE := sysdate;
x_custom_line_tbl(i).LAST_UPDATE_LOGIN := fnd_global.login_id;
To delete lines already added to the lines tables, pupolate PLSQL table x_custom_line_tbl with line's delivery detail id
and in corresponding record of PLSQL table x_custom_line_action_tbl populate value 'REMOVE'. For example:
x_custom_line_tbl(j).DELIVERY_DETAIL_ID := l_DELIVERY_DETAIL_ID;
Either upadte table wms_wp_wave_exceptions if exception for a particular entity is already there or insert new exception record. For example:
INSERT INTO wms_wp_wave_exceptions
(exception_id,
exception_name,
exception_entity,
exception_stage,
exception_level,
exception_msg,
wave_header_id,
trip_id,
delivery_id,
order_number,
order_line_id,
status,
concurrent_request_id,
program_id,
created_by,
creation_date,
last_update_date,
last_updated_by,
last_update_login)
VALUES
(wms_WP_WAVE_exceptions_s.nextval,
p_exception_name,
p_exception_entity,
p_progress_stage,
p_exception_level,
l_msg,
p_wave_id,
p_trip_id,
p_delivery_id,
p_order_number,
p_order_line_id,
'Active',
fnd_global.conc_request_id,
fnd_global.conc_program_id,
fnd_global.user_id,
sysdate,
sysdate,
fnd_global.user_id,
fnd_global.conc_login_id);
/* Using custom logic identify taks which needs to be released and update the pl/sql table with the mmtt's that needs to be released
and pass it back to the task release concurrent program
*/
--
IF (l_debug = 1) THEN
print_debug('***Exiting task_release_cust***');