The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT hsecs INTO v_start_time from v$timer;
SELECT hsecs INTO v_end_time FROM v$timer;
SELECT hsecs INTO l_val_start_time from v$timer;
SELECT hsecs INTO l_val_end_time FROM v$timer;
rlm_dp_sv.UpdateGroupPS(v_header_id,
g_Sch_rec.schedule_header_id,
g_Grp_rec,
rlm_core_sv.k_PS_ERROR,
'ALL');
rlm_dp_sv.UpdateHeaderPS(v_header_id,
g_Sch_rec.schedule_header_id);
rlm_dp_sv.UpdateGroupPS(v_header_id,
g_Sch_rec.schedule_header_id,
g_Grp_rec,
rlm_core_sv.k_PS_ERROR,
'ALL');
rlm_dp_sv.UpdateHeaderPS(v_header_id,
g_Sch_rec.schedule_header_id);
SELECT hsecs INTO v_md_start_time FROM v$timer;
SELECT hsecs INTO v_md_end_time FROM v$timer;
rlm_dp_sv.UpdateGroupPS(g_Sch_rec.header_id,
g_Sch_rec.schedule_header_id,
g_Grp_rec,
rlm_core_sv.k_PS_ERROR);
SELECT hsecs INTO v_mf_start_time FROM v$timer;
SELECT hsecs INTO v_mf_end_time FROM v$timer;
rlm_dp_sv.UpdateGroupPS(g_Sch_rec.header_id,
g_Sch_rec.schedule_header_id,
g_Grp_rec,
rlm_core_sv.k_PS_ERROR);
SELECT hsecs INTO v_rd_start_time from v$timer;
SELECT hsecs INTO v_rd_end_time FROM v$timer;
SELECT hsecs INTO v_rlm_gps_start_time from v$timer; --Bugfix 12863728
rlm_dp_sv.UpdateGroupPS(g_Sch_rec.header_id,
g_Sch_rec.schedule_header_id,
g_Grp_rec,
rlm_core_sv.k_PS_PROCESSED);
SELECT hsecs INTO v_rlm_gps_end_time FROM v$timer; --Bugfix 12863728
v_rlm_gps_msg_text:='Total Time spent in Update GroupPS call - '|| v_rlm_gps_total ; --Bugfix 12863728
rlm_dp_sv.UpdateGroupPS(g_Sch_rec.header_id,
g_Sch_rec.schedule_header_id,
g_Grp_rec,
rlm_core_sv.k_PS_ERROR);
SELECT process_status
FROM rlm_schedule_headers
WHERE header_id = p_header_id;
SELECT process_status
FROM rlm_interface_headers
WHERE header_id = p_header_id;
SELECT COUNT(*)
INTO x_errors
FROM rlm_interface_headers
WHERE header_id = v_header_id;
select schedule_reference_num, cust_name_ext, sched_generation_date
into x_Schedule_Num, x_Customer_Name , x_Schedule_Gen_Date
from rlm_interface_headers
where header_id = x_Header_Id ;
rlm_core_sv.dlog(C_DEBUG,' Successful select');
PROCEDURE UpdateHeaderPS(
itemtype IN VARCHAR2,
itemkey IN VARCHAR2,
actid IN NUMBER,
funcmode IN VARCHAR2,
resultout OUT NOCOPY VARCHAR2)
IS
--
v_header_id NUMBER;
rlm_core_sv.dpush(C_SDEBUG,'UpdateHeaderPS');
SELECT * INTO g_Sch_rec
FROM rlm_interface_headers
WHERE header_id = v_header_id;
rlm_dp_sv.UpdateHeaderPS(g_Sch_rec.header_id,
g_Sch_rec.schedule_header_id);
wf_core.context('RLM_WF_SV','UpdateHeaderPS',
itemtype, itemkey,TO_CHAR(actid),funcmode);
wf_core.context('RLM_WF_SV','UpdateHeaderPS',
itemtype, itemkey,TO_CHAR(actid),funcmode);
END UpdateHeaderPS;
SELECT hsecs INTO v_md_start_time FROM v$timer;
SELECT hsecs INTO v_md_end_time FROM v$timer;
SELECT hsecs INTO v_mf_start_time FROM v$timer;
SELECT hsecs INTO v_mf_end_time FROM v$timer;
SELECT hsecs INTO v_rd_start_time FROM v$timer;
SELECT hsecs INTO v_rd_end_time FROM v$timer;
SELECT hsecs INTO v_rlm_pg_gps_start_time from v$timer; --Bugfix 12863728
rlm_dp_sv.UpdateGroupPS(g_Sch_rec.header_id,
g_Sch_rec.schedule_header_id,
g_Grp_rec,
rlm_core_sv.k_PS_PROCESSED);
SELECT hsecs INTO v_rlm_pg_gps_end_time FROM v$timer; --Bugfix 12863728
v_rlm_pg_gps_msg_text:='Total Time spent in ProcessGroup Update GroupPS call - '|| v_rlm_pg_gps_total ; --Bugfix 12863728
rlm_dp_sv.UpdateGroupPS(g_Sch_rec.header_id,
g_Sch_rec.schedule_header_id,
g_Grp_rec,
rlm_core_sv.k_PS_ERROR);
rlm_dp_sv.UpdateGroupPS(g_Sch_rec.header_id,
g_Sch_rec.schedule_header_id,
g_Grp_rec,
rlm_core_sv.k_PS_ERROR);
rlm_dp_sv.UpdateGroupPS(g_Sch_rec.header_id,
g_Sch_rec.schedule_header_id,
g_Grp_rec,
rlm_core_sv.k_PS_ERROR);
rlm_dp_sv.UpdateGroupPS(g_Sch_rec.header_id,
g_Sch_rec.schedule_header_id,
g_Grp_rec,
rlm_core_sv.k_PS_ERROR,
'ALL');
rlm_dp_sv.UpdateGroupPS(g_Sch_rec.header_id,
g_Sch_rec.schedule_header_id,
g_Grp_rec,
rlm_core_sv.k_PS_ERROR);
rlm_dp_sv.UpdateGroupPS(v_header_id,
g_Sch_rec.schedule_header_id,
g_Grp_rec,
rlm_core_sv.k_PS_ERROR,
'ALL');
rlm_dp_sv.UpdateHeaderPS(v_header_id,
g_Sch_rec.schedule_header_id);
SELECT rih.customer_id,
ril.ship_from_org_id,
ril.ship_to_address_id,
ril.ship_to_site_use_id,
ril.ship_to_org_id,
ril.customer_item_id,
ril.inventory_item_id,
ril.industry_attribute15, --Bugfix 12947017
ril.intrmd_ship_to_id, --Bugfix 5911991
ril.intmed_ship_to_org_id, --Bugfix 5911991
ril.order_header_id,
ril.blanket_number,
min(ril.start_date_time),
ril.ship_to_customer_id
FROM rlm_interface_headers rih,
rlm_interface_lines_all ril
WHERE ril.header_id = v_hdr_id
AND ril.org_id = rih.org_id
AND ril.header_id = rih.header_id
AND ril.process_status in ( rlm_core_sv.k_PS_AVAILABLE,
rlm_core_sv.k_PS_PARTIAL_PROCESSED)
GROUP BY rih.customer_id,
ril.ship_from_org_id,
ril.ship_to_address_id,
ril.ship_to_site_use_id,
ril.ship_to_org_id,
ril.customer_item_id,
ril.inventory_item_id,
ril.industry_attribute15,
ril.intrmd_ship_to_id, --Bugfix 5911991
ril.intmed_ship_to_org_id, --Bugfix 5911991
ril.order_header_id,
ril.blanket_number,
ril.ship_to_customer_id
ORDER BY min(ril.start_date_time),
ril.ship_to_address_id,
ril.customer_item_id;
SELECT process_status
INTO v_tmp_status
FROM rlm_interface_headers
WHERE header_id = v_Header_Id;
v_child_req_id.delete;
rlm_dp_sv.UpdateGroupPS(g_Sch_rec.header_id,
g_Sch_rec.schedule_header_id,
g_Grp_rec,
rlm_core_sv.k_PS_ERROR,
'ALL');
SELECT hsecs INTO l_comp_start_time FROM v$timer;
SELECT hsecs INTO l_comp_end_time FROM v$timer;
rlm_dp_sv.UpdateGroupPS(v_header_id,
g_Sch_rec.schedule_header_id,
g_Grp_rec,
rlm_core_sv.k_PS_ERROR,
'ALL');
rlm_dp_sv.UpdateHeaderPS(v_header_id,
g_Sch_rec.schedule_header_id);
rlm_dp_sv.UpdateGroupPS(g_Sch_rec.header_id,
g_Sch_rec.Schedule_header_id,
g_Grp_rec,
rlm_core_sv.K_PS_PROCESSED,
'ALL');
rlm_dp_sv.UpdateHeaderPS(g_Sch_rec.header_id,
g_Sch_rec.Schedule_header_id);
rlm_dp_sv.UpdateGroupPS(v_header_id,
g_Sch_rec.schedule_header_id,
g_Grp_rec,
rlm_core_sv.k_PS_ERROR,
'ALL');
rlm_dp_sv.UpdateHeaderPS(v_header_id,
g_Sch_rec.schedule_header_id);
rlm_dp_sv.UpdateGroupPS(v_header_id,
g_Sch_rec.schedule_header_id,
g_Grp_rec,
rlm_core_sv.k_PS_ERROR,
'ALL');
rlm_dp_sv.UpdateHeaderPS(v_header_id,
g_Sch_rec.schedule_header_id);
SELECT user_name
FROM fnd_user
WHERE user_id = v_user_id;
SELECT display_name
FROM wf_roles
WHERE name =
(
SELECT 'FND_RESP' || r.application_id || ':' || r.responsibility_id
FROM fnd_responsibility_vl r
WHERE r.responsibility_id = v_resp_id
AND r.application_id = v_appl_id);
SELECT process_status
FROM rlm_schedule_headers
WHERE header_id = p_header_id;
SELECT process_status
FROM rlm_interface_headers
WHERE header_id = p_header_id;