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 ship_from_org_id = x_Group_rec.ship_from_org_id --Bugfix 12863728
315: AND ship_to_address_id = x_Group_rec.ship_to_address_id --Bugfix 12863728

Line 334: UPDATE rlm_schedule_lines_all sl

330: IF (l_debug <> -1) THEN
331: rlm_core_sv.dlog(C_DEBUG, 'Sales order version of Update', x_Group_rec.order_header_id);
332: END IF;
333: --
334: UPDATE rlm_schedule_lines_all sl
335: SET process_status = rlm_core_sv.k_PS_Processed
336: WHERE header_id = x_Sched_rec.schedule_header_id
337: AND ship_from_org_id = x_Group_rec.ship_from_org_id --Bugfix 12863728
338: AND ship_to_address_id = x_Group_rec.ship_to_address_id --Bugfix 12863728

Line 4790: UPDATE rlm_schedule_lines_all

4786: --
4787: -- JAUTOMO: update schedule lines with the interface line id
4788: -- created when sourcing rule is applied
4789: --
4790: UPDATE rlm_schedule_lines_all
4791: SET interface_line_id = x_ManageDemand_rec.line_id
4792: WHERE line_id = x_ManageDemand_rec.schedule_line_id
4793: AND x_ManageDemand_rec.line_source = 'SOURCED';
4794: --

Line 4924: UPDATE rlm_schedule_lines_all

4920: END IF;
4921: --
4922: IF x_ManageDemand_rec.program_id <> k_INSERT THEN
4923: --
4924: UPDATE rlm_schedule_lines_all
4925: SET interface_line_id = x_AggregateDemand_rec.line_id
4926: WHERE line_id = x_ManageDemand_rec.schedule_line_id;
4927: --
4928: IF (l_debug <> -1) THEN