APPS.RLM_AD_SV dependencies on RLM_SCHEDULE_LINES

Line 341: SET schedule_line_id = rlm_schedule_lines_s.nextval

337: RAISE e_NullOrgID;
338: END IF;
339: --
340: UPDATE rlm_interface_lines_all
341: SET schedule_line_id = rlm_schedule_lines_s.nextval
342: WHERE header_id = c_rec.interface_header_id
343: AND line_id = c_rec.interface_line_id
344: AND schedule_line_id IS NULL
345: AND process_status = rlm_core_sv.k_PS_AVAILABLE ;

Line 357: INSERT INTO rlm_schedule_lines_all(

353: x_progress :='020';
354: --
355: IF SQL%ROWCOUNT <> 0 THEN
356: --
357: INSERT INTO rlm_schedule_lines_all(
358: LINE_ID,
359: CUSTOMER_ITEM_EXT,
360: CUSTOMER_ITEM_ID,
361: DATE_TYPE_CODE,

Line 855: UPDATE rlm_schedule_lines_all

851: END IF;
852: --
853: ELSE
854: --
855: UPDATE rlm_schedule_lines_all
856: SET request_id = rlm_message_sv.g_conc_req_id,
857: interface_line_id = c_rec.interface_line_id,
858: order_header_id = c_rec.order_header_id,
859: blanket_number = c_rec.blanket_number,

Line 889: UPDATE rlm_schedule_lines

885: ,SQL%ROWCOUNT);
886: END IF;
887:
888: --
889: UPDATE rlm_schedule_lines
890: SET process_status = rlm_core_sv.k_PS_PROCESSED
891: WHERE header_id = x_RLMScheduleID
892: AND interface_line_id = c_rec.interface_line_id
893: AND process_status = rlm_core_sv.k_PS_AVAILABLE;

Line 997: Update rlm_schedule_lines

993: --
994: -- The lines are updated in Archive Lines no need to do this again
995: --
996: /*
997: Update rlm_schedule_lines
998: SET request_id = rlm_message_sv.g_conc_req_id ,
999: last_update_date = sysdate,
1000: last_updated_by = fnd_global.user_id
1001: WHERE header_id = c_rec.schedule_header_id;

Line 1051: UPDATE rlm_schedule_lines

1047: IF (l_debug <> -1) THEN
1048: rlm_core_sv.dlog(C_SDEBUG, 'No of Records Updated in interface lines for test',SQL%ROWCOUNT);
1049: END IF;
1050: --
1051: UPDATE rlm_schedule_lines
1052: SET process_status = rlm_core_sv.k_PS_PROCESSED
1053: WHERE header_id = v_RlmScheduleID
1054: AND process_status = rlm_core_sv.k_PS_AVAILABLE;
1055: --