DBA Data[Home] [Help]

APPS.RLM_MANAGE_DEMAND_SV dependencies on RLM_SCHEDULE_LINES_ALL

Line 311: UPDATE rlm_schedule_lines_all sl

307: IF (l_debug <> -1) THEN
308: rlm_core_sv.dlog(C_DEBUG, 'Blanket Version of Update', x_Group_rec.blanket_number);
309: END IF;
310: --
311: UPDATE rlm_schedule_lines_all sl
312: SET process_status = rlm_core_sv.k_PS_Processed
313: WHERE header_id = x_Sched_rec.schedule_header_id
314: AND line_id IN (
315: SELECT schedule_line_id

Line 331: UPDATE rlm_schedule_lines_all sl

327: IF (l_debug <> -1) THEN
328: rlm_core_sv.dlog(C_DEBUG, 'Sales order version of Update', x_Group_rec.order_header_id);
329: END IF;
330: --
331: UPDATE rlm_schedule_lines_all sl
332: SET process_status = rlm_core_sv.k_PS_Processed
333: WHERE header_id = x_Sched_rec.schedule_header_id
334: AND line_id IN (
335: SELECT schedule_line_id

Line 4699: UPDATE rlm_schedule_lines_all

4695: --
4696: -- JAUTOMO: update schedule lines with the interface line id
4697: -- created when sourcing rule is applied
4698: --
4699: UPDATE rlm_schedule_lines_all
4700: SET interface_line_id = x_ManageDemand_rec.line_id
4701: WHERE line_id = x_ManageDemand_rec.schedule_line_id
4702: AND x_ManageDemand_rec.line_source = 'SOURCED';
4703: --

Line 4833: UPDATE rlm_schedule_lines_all

4829: END IF;
4830: --
4831: IF x_ManageDemand_rec.program_id <> k_INSERT THEN
4832: --
4833: UPDATE rlm_schedule_lines_all
4834: SET interface_line_id = x_AggregateDemand_rec.line_id
4835: WHERE line_id = x_ManageDemand_rec.schedule_line_id;
4836: --
4837: IF (l_debug <> -1) THEN