DBA Data[Home] [Help]

APPS.RLM_AD_SV dependencies on RLM_SCHEDULE_HEADERS_ALL

Line 75: INSERT INTO rlm_schedule_headers_all (

71: IF (v_HdrRec.ORG_ID IS NULL) THEN
72: RAISE e_NullOrgIdHdr;
73: END IF;
74: --
75: INSERT INTO rlm_schedule_headers_all (
76: HEADER_ID,
77: INTERFACE_HEADER_ID,
78: CUSTOMER_ID,
79: SCHEDULE_TYPE,

Line 984: Update rlm_schedule_headers_all

980: c_rec.schedule_header_id);
981: rlm_core_sv.dlog(C_DEBUG, 'request_id ',rlm_message_sv.g_conc_req_id );
982: END IF;
983: --
984: Update rlm_schedule_headers_all
985: SET request_id = rlm_message_sv.g_conc_req_id ,
986: last_update_date = sysdate,
987: last_updated_by = fnd_global.user_id
988: WHERE header_id = c_rec.schedule_header_id;

Line 1072: UPDATE rlm_schedule_headers_all

1068: --
1069: -- Update the schedule headers with v_RlmScheduleID instead of
1070: -- c_rec.header_id for new schedules bug 1085917
1071: --
1072: UPDATE rlm_schedule_headers_all
1073: SET process_status = rlm_core_sv.k_PS_PROCESSED
1074: WHERE header_id = v_RlmScheduleID
1075: AND process_status = rlm_core_sv.k_PS_AVAILABLE;
1076: --