[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
/* If many of the lines selected are part of a smc/ato/non-smc model, then delayed
* request must get logged only for one of the lines.
*/
IF oe_model_id_tbl.EXISTS(p_model_id) THEN
l_found := TRUE;
/* If many of the lines selected are part of a ship set / Arrival set, then delayed
* request must get logged only for one of the lines.
*/
IF oe_set_id_tbl.EXISTS(p_set_id) THEN
l_found := TRUE;
SELECT ACTIVITY_STATUS
INTO l_activity_status_code
FROM wf_item_activity_statuses wias, wf_process_activities wpa
WHERE wias.item_type = 'OEOL' AND
wias.item_key = to_char(p_line_id) AND
wias.process_activity = wpa.instance_id AND
wpa.activity_item_type = 'OEOL' AND
wpa.activity_name = 'SCHEDULING_ELIGIBLE' AND
wias.activity_status = 'NOTIFIED';
l_selected_line_tbl OE_GLOBALS.Selected_Record_Tbl; -- R12.MOAC
SELECT item_key, l.org_id,wias.process_activity --added process_activity for bug 13542899
FROM wf_item_activity_statuses wias,
wf_process_activities wpa,
oe_order_lines l
WHERE wias.item_type = 'OEOL'
AND wias.process_activity = wpa.instance_id
AND wpa.activity_item_type = 'OEOL'
AND wpa.activity_name = 'SCHEDULING_ELIGIBLE'
AND wias.activity_status = 'NOTIFIED'
AND wias.item_key = l.line_id
AND wias.begin_date < l_prg_start_date --13426757
Order by l.org_id;
SELECT line_id
FROM oe_order_lines_all
WHERE header_id = l_header_id
AND top_model_line_id = l_line_id
AND item_type_code in ('MODEL','KIT','CLASS','OPTION')
AND ((ato_line_id is not null AND
ato_line_id = line_id) OR
ato_line_id is null)
AND open_flag = 'Y';
SELECT fnd_date.canonical_to_date(p_request_date_low),
fnd_date.canonical_to_date(p_request_date_high),
fnd_date.canonical_to_date(p_ordered_date_low),
fnd_date.canonical_to_date(p_ordered_date_high),
fnd_date.canonical_to_date(p_line_request_date_low),
fnd_date.canonical_to_date(p_line_request_date_high),
fnd_date.canonical_to_date(p_sch_ship_date_low),
fnd_date.canonical_to_date(p_sch_ship_date_high),
fnd_date.canonical_to_date(p_sch_arrival_date_low),
fnd_date.canonical_to_date(p_sch_arrival_date_high)
-- fnd_date.canonical_to_date(p_apply_sch_date)
INTO l_request_date_low,
l_request_date_high,
l_ordered_date_low,
l_ordered_date_high,
l_line_request_date_low,
l_line_request_date_high,
l_sch_ship_date_low,
l_sch_ship_date_high,
l_sch_arrival_date_low,
l_sch_arrival_date_high
-- l_apply_sch_date
FROM DUAL;
SELECT fnd_date.chardt_to_date(p_apply_sch_date)
INTO l_apply_sch_date
FROM dual;
SELECT line_id
INTO l_locked_line_id
FROM oe_order_lines_all
WHERE line_id = to_number(l_wf_item_rec(K).ITEM_KEY)
FOR UPDATE NOWAIT;
l_stmt := 'SELECT ' ;
l_stmt := l_stmt || ' AND not exists (select 1 from wsh_delivery_details wdd';
SELECT L.line_id,
L.booked_flag,
L.request_date,
L.ship_from_org_id,
L.ship_set_id,
L.arrival_set_id,
L.ato_line_id,
L.top_model_line_id,
L.link_to_line_id,
L.ship_model_complete_flag,
L.item_type_code,
L.schedule_status_code
INTO l_temp_line_id,
l_booked_flag,
l_request_date,
l_ship_from_org_id,
l_ship_set_id,
l_arrival_set_id,
l_ato_line_id,
l_top_model_line_id,
l_link_to_line_id,
l_smc_flag,
l_item_type_code,
l_schedule_status_code
FROM oe_order_lines_all L
WHERE L.open_flag = 'Y'
AND L.line_id = l_line_id;
SELECT line_id
INTO l_locked_line_id
FROM oe_order_lines_all
WHERE line_id = l_line_id
FOR UPDATE NOWAIT;
l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
l_selected_line_tbl(1).id1 := l_line_id;
(p_selected_line_tbl => l_selected_line_tbl, --R12.MOAC
p_line_count => 1,
p_sch_action => 'SCHEDULE',
x_atp_tbl => l_atp_tbl,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data);
l_selected_line_tbl(1).id1 := l_line_id;
(p_selected_line_tbl => l_selected_line_tbl,
p_line_count => 1,
p_sch_action => 'UNSCHEDULE',
x_atp_tbl => l_atp_tbl,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data);
/* If many of the lines selected are part of a set, then delayed
* request must get logged only for one of the lines.
*/
IF l_ship_set_id IS NOT NULL OR
l_arrival_set_id IS NOT NULL THEN
l_temp_flag := set_processed( NVL(l_ship_set_id,l_arrival_set_id));
l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Lines Selected : ' || l_rec_processed);