DBA Data[Home] [Help]

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 271: x_Group_rec IN RLM_DP_SV.t_Group_rec,

267: ==============================================================================*/
268: PROCEDURE QueryRSO(p_customer_id IN NUMBER,
269: p_request_date IN DATE,
270: p_cust_item_id IN NUMBER,
271: x_Group_rec IN RLM_DP_SV.t_Group_rec,
272: x_rso_hdr_id OUT NOCOPY NUMBER,
273: x_start_date OUT NOCOPY DATE,
274: x_end_date OUT NOCOPY DATE,
275: x_maxend_date OUT NOCOPY DATE,

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

421:
422: PROCEDURE CalcEffectiveDates
423:
424: ==============================================================================*/
425: PROCEDURE CalcEffectiveDates(x_Group_rec IN RLM_DP_SV.t_Group_rec,
426: p_request_date IN DATE,
427: x_start_date OUT NOCOPY DATE,
428: x_end_date OUT NOCOPY DATE,
429: x_maxend_date IN OUT NOCOPY DATE) IS

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

491:
492: PROCEDURE CalcPriorEffectDates
493:
494: ==============================================================================*/
495: PROCEDURE CalcPriorEffectDates(x_Group_rec IN RLM_DP_SV.t_Group_rec,
496: p_request_date IN DATE,
497: x_start_date OUT NOCOPY DATE,
498: x_end_date OUT NOCOPY DATE,
499: x_minstart_date IN OUT NOCOPY DATE) IS

Line 537: x_Group_rec IN RLM_DP_SV.t_Group_rec,

533: PROCEDURE InsertRSO
534:
535: ==============================================================================*/
536: PROCEDURE InsertRSO(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
537: x_Group_rec IN RLM_DP_SV.t_Group_rec,
538: p_rso_hdr_id IN NUMBER,
539: p_start_date IN DATE,
540: p_end_date IN DATE) IS
541: --

Line 601: x_Group_rec IN RLM_DP_SV.t_Group_rec,

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

Line 827: x_Group_rec IN RLM_DP_SV.t_Group_rec,

823: PROCEDURE InsertOMMessages
824:
825: ==============================================================================*/
826: PROCEDURE InsertOMMessages(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
827: x_Group_rec IN RLM_DP_SV.t_Group_rec,
828: x_msg_count IN NUMBER,
829: x_msg_level IN VARCHAR2,
830: x_token IN VARCHAR2,
831: x_msg_name IN VARCHAR2) IS

Line 1014: x_Group_rec IN rlm_dp_sv.t_Group_rec,

1010: FUNCTION NAME: GetTPContext
1011:
1012: ===========================================================================*/
1013: PROCEDURE GetTPContext( x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1014: x_Group_rec IN rlm_dp_sv.t_Group_rec,
1015: x_customer_number OUT NOCOPY VARCHAR2,
1016: x_ship_to_ece_locn_code OUT NOCOPY VARCHAR2,
1017: x_bill_to_ece_locn_code OUT NOCOPY VARCHAR2,
1018: x_inter_ship_to_ece_locn_code OUT NOCOPY VARCHAR2,

Line 1123: x_Group_rec IN rlm_dp_sv.t_Group_rec,

1119:
1120: ==============================================================================*/
1121:
1122: PROCEDURE CalFenceDays(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1123: x_Group_rec IN rlm_dp_sv.t_Group_rec,
1124: x_fence_days OUT NOCOPY NUMBER)
1125: IS
1126: --
1127: v_FrozenFenceDayFrom NUMBER;