eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RLM_BLANKET_SV dependencies on RLM_DP_SV

Line 15: x_Group_rec IN RLM_DP_SV.t_Group_rec,

11: PROCEDURE DeriveRSO
12:
13: ==============================================================================*/
14: PROCEDURE DeriveRSO(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
15: x_Group_rec IN RLM_DP_SV.t_Group_rec,
16: x_return_status OUT NOCOPY NUMBER) IS
17: --
18: CURSOR c_lines IS
19: SELECT *

Line 41: l_Group_rec RLM_DP_SV.t_Group_rec;

37: --4302492
38: v_req_date DATE;
39: v_fence_days NUMBER;
40: v_RFFlag VARCHAR2(1) := 'N';
41: l_Group_rec RLM_DP_SV.t_Group_rec;
42: --
43: BEGIN
44: --
45: IF (l_debug <> -1) THEN

Line 103: IF (v_RFFlag = 'Y' AND RLM_RD_SV.IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time),l_Group_rec,v_req_date)) THEN

99: --
100: --Bugfix 10053830 Start
101: /*IF v_RFFlag = 'Y' AND RLM_RD_SV.IsFrozen(TRUNC(SYSDATE),l_Group_rec,c_lines_rec.request_date)THEN
102: v_req_date := TRUNC(SYSDATE) + nvl(v_fence_days,0) ; --Bugfix 6485729*/
103: IF (v_RFFlag = 'Y' AND RLM_RD_SV.IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time),l_Group_rec,v_req_date)) THEN
104: v_req_date := TRUNC(rlm_dp_sv.g_dsp_start_time) + nvl(v_fence_days,0) ;
105: --Bugfix 10053830 End
106: ELSE
107: v_req_date := c_lines_rec.request_date;

Line 104: v_req_date := TRUNC(rlm_dp_sv.g_dsp_start_time) + nvl(v_fence_days,0) ;

100: --Bugfix 10053830 Start
101: /*IF v_RFFlag = 'Y' AND RLM_RD_SV.IsFrozen(TRUNC(SYSDATE),l_Group_rec,c_lines_rec.request_date)THEN
102: v_req_date := TRUNC(SYSDATE) + nvl(v_fence_days,0) ; --Bugfix 6485729*/
103: IF (v_RFFlag = 'Y' AND RLM_RD_SV.IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time),l_Group_rec,v_req_date)) THEN
104: v_req_date := TRUNC(rlm_dp_sv.g_dsp_start_time) + nvl(v_fence_days,0) ;
105: --Bugfix 10053830 End
106: ELSE
107: v_req_date := c_lines_rec.request_date;
108: END IF;

Line 275: x_Group_rec IN RLM_DP_SV.t_Group_rec,

271: ==============================================================================*/
272: PROCEDURE QueryRSO(p_customer_id IN NUMBER,
273: p_request_date IN DATE,
274: p_cust_item_id IN NUMBER,
275: x_Group_rec IN RLM_DP_SV.t_Group_rec,
276: x_rso_hdr_id OUT NOCOPY NUMBER,
277: x_start_date OUT NOCOPY DATE,
278: x_end_date OUT NOCOPY DATE,
279: x_maxend_date OUT NOCOPY DATE,

Line 429: PROCEDURE CalcEffectiveDates(x_Group_rec IN RLM_DP_SV.t_Group_rec,

425:
426: PROCEDURE CalcEffectiveDates
427:
428: ==============================================================================*/
429: PROCEDURE CalcEffectiveDates(x_Group_rec IN RLM_DP_SV.t_Group_rec,
430: p_request_date IN DATE,
431: x_start_date OUT NOCOPY DATE,
432: x_end_date OUT NOCOPY DATE,
433: x_maxend_date IN OUT NOCOPY DATE) IS

Line 499: PROCEDURE CalcPriorEffectDates(x_Group_rec IN RLM_DP_SV.t_Group_rec,

495:
496: PROCEDURE CalcPriorEffectDates
497:
498: ==============================================================================*/
499: PROCEDURE CalcPriorEffectDates(x_Group_rec IN RLM_DP_SV.t_Group_rec,
500: p_request_date IN DATE,
501: x_start_date OUT NOCOPY DATE,
502: x_end_date OUT NOCOPY DATE,
503: x_minstart_date IN OUT NOCOPY DATE) IS

Line 541: x_Group_rec IN RLM_DP_SV.t_Group_rec,

537: PROCEDURE InsertRSO
538:
539: ==============================================================================*/
540: PROCEDURE InsertRSO(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
541: x_Group_rec IN RLM_DP_SV.t_Group_rec,
542: p_rso_hdr_id IN NUMBER,
543: p_start_date IN DATE,
544: p_end_date IN DATE) IS
545: --

Line 605: x_Group_rec IN RLM_DP_SV.t_Group_rec,

601: PROCEDURE CreateRSOHeader
602:
603: ==============================================================================*/
604: PROCEDURE CreateRSOHeader(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
605: x_Group_rec IN RLM_DP_SV.t_Group_rec,
606: x_rso_hdr_id OUT NOCOPY NUMBER) IS
607: --
608: l_oe_header_rec oe_order_pub.header_rec_type;
609: l_oe_header_val_rec oe_order_pub.header_val_rec_type;

Line 831: x_Group_rec IN RLM_DP_SV.t_Group_rec,

827: PROCEDURE InsertOMMessages
828:
829: ==============================================================================*/
830: PROCEDURE InsertOMMessages(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
831: x_Group_rec IN RLM_DP_SV.t_Group_rec,
832: x_msg_count IN NUMBER,
833: x_msg_level IN VARCHAR2,
834: x_token IN VARCHAR2,
835: x_msg_name IN VARCHAR2) IS

Line 1018: x_Group_rec IN rlm_dp_sv.t_Group_rec,

1014: FUNCTION NAME: GetTPContext
1015:
1016: ===========================================================================*/
1017: PROCEDURE GetTPContext( x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1018: x_Group_rec IN rlm_dp_sv.t_Group_rec,
1019: x_customer_number OUT NOCOPY VARCHAR2,
1020: x_ship_to_ece_locn_code OUT NOCOPY VARCHAR2,
1021: x_bill_to_ece_locn_code OUT NOCOPY VARCHAR2,
1022: x_inter_ship_to_ece_locn_code OUT NOCOPY VARCHAR2,

Line 1127: x_Group_rec IN rlm_dp_sv.t_Group_rec,

1123:
1124: ==============================================================================*/
1125:
1126: PROCEDURE CalFenceDays(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1127: x_Group_rec IN rlm_dp_sv.t_Group_rec,
1128: x_fence_days OUT NOCOPY NUMBER)
1129: IS
1130: --
1131: v_FrozenFenceDayFrom NUMBER;