[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE InsertOMMessages
(
x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
x_Group_rec IN RLM_DP_SV.t_Group_rec,
x_msg_count IN NUMBER,
x_msg_level IN VARCHAR2,
x_token IN VARCHAR2,
x_msg_name IN VARCHAR2
)
IS
--{
--
--
--
-- Internal Variables
--
k_program_unit_id CONSTANT NUMBER := 707;
RLM_BLANKET_SV.InsertOMMessages
(
x_Sched_rec => x_Sched_rec,
x_Group_rec => x_Group_rec,
x_msg_count => x_msg_count,
x_msg_level => x_msg_level,
x_token => x_token,
x_msg_name => x_msg_name
)
;
END InsertOMMessages;
PROCEDURE InsertRSO
(
x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
x_Group_rec IN RLM_DP_SV.t_Group_rec,
p_rso_hdr_id IN NUMBER,
p_start_date IN DATE,
p_end_date IN DATE
)
IS
--{
--
--
--
-- Internal Variables
--
k_program_unit_id CONSTANT NUMBER := 705;
RLM_BLANKET_SV.InsertRSO
(
x_Sched_rec => x_Sched_rec,
x_Group_rec => x_Group_rec,
p_rso_hdr_id => p_rso_hdr_id,
p_start_date => p_start_date,
p_end_date => p_end_date
)
;
END InsertRSO;
PROCEDURE DeleteDemand
(
x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
x_Demand_ref IN OUT NOCOPY RLM_RD_SV.t_Cursor_ref
)
IS
--{
--
--
--
-- Internal Variables
--
k_program_unit_id CONSTANT NUMBER := 593;
RLM_RD_SV.DeleteDemand
(
x_Sched_rec => x_Sched_rec,
x_Group_rec => x_Group_rec,
x_Key_rec => x_Key_rec,
x_Demand_ref => x_Demand_ref
)
;
END DeleteDemand;
PROCEDURE UpdateDemand
(
x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
x_SumOrderedQty IN NUMBER,
x_DemandType IN VARCHAR2
)
IS
--{
--
--
--
-- Internal Variables
--
k_program_unit_id CONSTANT NUMBER := 591;
RLM_RD_SV.UpdateDemand
(
x_Sched_rec => x_Sched_rec,
x_Group_rec => x_Group_rec,
x_Key_rec => x_Key_rec,
x_SumOrderedQty => x_SumOrderedQty,
x_DemandType => x_DemandType
)
;
END UpdateDemand;
PROCEDURE InsertRequirement
(
x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
x_Reconcile IN BOOLEAN,
x_Quantity IN OUT NOCOPY NUMBER
)
IS
--{
--
--
--
-- Internal Variables
--
k_program_unit_id CONSTANT NUMBER := 590;
RLM_RD_SV.InsertRequirement
(
x_Sched_rec => x_Sched_rec,
x_Group_rec => x_Group_rec,
x_Key_rec => x_Key_rec,
x_Reconcile => x_Reconcile,
x_Quantity => x_Quantity
)
;
END InsertRequirement;
PROCEDURE UpdateGroupStatus
(
x_header_id IN NUMBER,
x_ScheduleHeaderId IN NUMBER,
x_Group_rec IN rlm_dp_sv.t_Group_rec,
x_status IN NUMBER,
x_UpdateLevel IN VARCHAR2 DEFAULT 'GROUP'
)
IS
--{
--
--
--
-- Internal Variables
--
k_program_unit_id CONSTANT NUMBER := 1519;
RLM_FORECAST_SV.UpdateGroupStatus
(
x_header_id => x_header_id,
x_ScheduleHeaderId => x_ScheduleHeaderId,
x_Group_rec => x_Group_rec,
x_status => x_status,
x_UpdateLevel => x_UpdateLevel
)
;
END UpdateGroupStatus;
PROCEDURE UpdateInterfaceLines
(
x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
)
IS
--{
--
--
--
-- Internal Variables
--
k_program_unit_id CONSTANT NUMBER := 1332;
RLM_VALIDATEDEMAND_SV.UpdateInterfaceLines
(
x_header_rec => x_header_rec
)
;
END UpdateInterfaceLines;
PROCEDURE UpdateCumKey
(
x_trip_stop_id IN NUMBER,
x_return_status OUT NOCOPY BOOLEAN
)
IS
--{
--
--
--
-- Internal Variables
--
k_program_unit_id CONSTANT NUMBER := 10691;
RLM_CUM_SV.UpdateCumKey
(
x_trip_stop_id => x_trip_stop_id,
x_return_status => x_return_status
)
;
END UpdateCumKey;