DBA Data[Home] [Help]

APPS.RLM_TPA_SV dependencies on RLM_DP_SV

Line 53: x_Group_rec IN RLM_DP_SV.t_Group_rec,

49: --
50: PROCEDURE InsertOMMessages
51: (
52: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
53: x_Group_rec IN RLM_DP_SV.t_Group_rec,
54: x_msg_count IN NUMBER,
55: x_msg_level IN VARCHAR2,
56: x_token IN VARCHAR2,
57: x_msg_name IN VARCHAR2

Line 64: x_Group_rec IN RLM_DP_SV.t_Group_rec,

60: --
61: PROCEDURE CreateRSOHeader
62: (
63: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
64: x_Group_rec IN RLM_DP_SV.t_Group_rec,
65: x_rso_hdr_id OUT NOCOPY NUMBER
66: );
67: --
68: --

Line 72: x_Group_rec IN RLM_DP_SV.t_Group_rec,

68: --
69: PROCEDURE InsertRSO
70: (
71: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
72: x_Group_rec IN RLM_DP_SV.t_Group_rec,
73: p_rso_hdr_id IN NUMBER,
74: p_start_date IN DATE,
75: p_end_date IN DATE
76: );

Line 82: x_Group_rec IN RLM_DP_SV.t_Group_rec,

78: --
79: PROCEDURE DeriveRSO
80: (
81: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
82: x_Group_rec IN RLM_DP_SV.t_Group_rec,
83: x_return_status OUT NOCOPY NUMBER
84: );
85: --
86: --

Line 90: x_group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,

86: --
87: PROCEDURE ReconcileAction
88: (
89: x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
90: x_group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
91: x_key_rec IN OUT NOCOPY RLM_RD_SV.t_key_rec,
92: x_line_id_tab IN RLM_RD_SV.t_matching_line,
93: x_DemandCount IN NUMBER,
94: x_SumOrderedQty IN NUMBER,

Line 102: x_Group_Rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

98: --
99: PROCEDURE BuildMatchQuery
100: (
101: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
102: x_Group_Rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
103: x_Demand_Type IN VARCHAR2,
104: x_Sql OUT NOCOPY VARCHAR2,
105: x_Sql1 OUT NOCOPY VARCHAR2,
106: x_Sql2 OUT NOCOPY VARCHAR2,

Line 114: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,

110: --
111: PROCEDURE OtherDemand
112: (
113: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
114: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
115: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
116: x_Demand_ref IN OUT NOCOPY RLM_RD_SV.t_Cursor_ref
117: );
118: --

Line 123: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,

119: --
120: PROCEDURE DecreaseDemand
121: (
122: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
123: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
124: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
125: x_Demand_ref IN OUT NOCOPY RLM_RD_SV.t_Cursor_ref,
126: x_SumOrderedQty IN NUMBER
127: );

Line 133: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,

129: --
130: PROCEDURE DeleteDemand
131: (
132: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
133: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
134: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
135: x_Demand_ref IN OUT NOCOPY RLM_RD_SV.t_Cursor_ref
136: );
137: --

Line 142: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,

138: --
139: PROCEDURE IncreaseDemand
140: (
141: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
142: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
143: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
144: x_Demand_ref IN OUT NOCOPY RLM_RD_SV.t_Cursor_ref,
145: x_SumOrderedQty IN NUMBER
146: );

Line 152: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,

148: --
149: PROCEDURE UpdateDemand
150: (
151: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
152: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
153: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
154: x_SumOrderedQty IN NUMBER,
155: x_DemandType IN VARCHAR2
156: );

Line 162: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,

158: --
159: PROCEDURE InsertRequirement
160: (
161: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
162: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
163: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
164: x_Reconcile IN BOOLEAN,
165: x_Quantity IN OUT NOCOPY NUMBER
166: );

Line 172: x_Group_rec IN rlm_dp_sv.t_Group_rec,

168: --
169: FUNCTION GetIntransitAcrossOrgs
170: (
171: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
172: x_Group_rec IN rlm_dp_sv.t_Group_rec,
173: x_cum_key_id IN NUMBER
174: )
175: RETURN NUMBER;
176: --

Line 182: x_Group_rec IN rlm_dp_sv.t_Group_rec

178: PROCEDURE InitializeMdGroup
179: (
180: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
181: x_Group_ref IN OUT NOCOPY rlm_manage_demand_sv.t_Cursor_ref,
182: x_Group_rec IN rlm_dp_sv.t_Group_rec
183: );
184: --
185: --
186: PROCEDURE InitializeSoGroup

Line 190: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec

186: PROCEDURE InitializeSoGroup
187: (
188: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
189: x_Group_ref IN OUT NOCOPY rlm_rd_sv.t_Cursor_ref,
190: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
191: );
192: --
193: --
194: PROCEDURE InitializeBlktGrp

Line 198: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec

194: PROCEDURE InitializeBlktGrp
195: (
196: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
197: x_Group_ref IN OUT NOCOPY rlm_rd_sv.t_Cursor_ref,
198: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
199: );
200: --
201: --
202: PROCEDURE CalculateCumKey

Line 212: x_Group_rec IN rlm_dp_sv.t_Group_rec,

208: --
209: FUNCTION GetAllIntransitQty
210: (
211: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
212: x_Group_rec IN rlm_dp_sv.t_Group_rec,
213: x_Source_Tab IN rlm_manage_demand_sv.t_Source_Tab
214: )
215: RETURN NUMBER;
216: --

Line 221: x_Group_rec IN rlm_dp_sv.t_Group_rec

217: --
218: FUNCTION CalculateIntransitQty
219: (
220: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
221: x_Group_rec IN rlm_dp_sv.t_Group_rec
222: )
223: RETURN NUMBER;
224: --
225: --

Line 229: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec

225: --
226: PROCEDURE SynchronizeShipments
227: (
228: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
229: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
230: );
231: --
232: --
233: PROCEDURE ProcessOld

Line 236: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec

232: --
233: PROCEDURE ProcessOld
234: (
235: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
236: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
237: );
238: --
239: --
240: PROCEDURE calc_scheduled_ship_date

Line 259: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,

255: --
256: PROCEDURE EmptyForecast
257: (
258: x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
259: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
260: x_forecast IN OUT NOCOPY
261: mrp_forecast_interface_pk.t_forecast_interface,
262: x_designator IN OUT NOCOPY
263: mrp_forecast_interface_pk.t_forecast_designator,

Line 272: x_Group_rec IN rlm_dp_sv.t_Group_rec DEFAULT NULL,

268: --
269: PROCEDURE GetDesignator
270: (
271: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE DEFAULT NULL,
272: x_Group_rec IN rlm_dp_sv.t_Group_rec DEFAULT NULL,
273: x_Customer_id IN NUMBER,
274: x_ShipFromOrgId IN NUMBER,
275: x_Ship_Site_Id IN NUMBER,
276: x_bill_site_id IN NUMBER,

Line 286: x_Group_rec IN rlm_dp_sv.t_Group_rec,

282: --
283: PROCEDURE LoadForecast
284: (
285: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
286: x_Group_rec IN rlm_dp_sv.t_Group_rec,
287: t_forecast IN OUT NOCOPY mrp_forecast_interface_pk.t_forecast_interface,
288: x_forecast_designator IN mrp_forecast_designators.forecast_designator%TYPE
289: );
290: --

Line 295: x_Group_rec IN rlm_dp_sv.t_Group_rec,

291: --
292: PROCEDURE ProcessTable
293: (
294: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
295: x_Group_rec IN rlm_dp_sv.t_Group_rec,
296: t_Forecast IN mrp_forecast_interface_pk.t_forecast_interface
297: );
298: --
299: --

Line 304: x_Group_rec IN rlm_dp_sv.t_Group_rec,

300: PROCEDURE UpdateGroupStatus
301: (
302: x_header_id IN NUMBER,
303: x_ScheduleHeaderId IN NUMBER,
304: x_Group_rec IN rlm_dp_sv.t_Group_rec,
305: x_status IN NUMBER,
306: x_UpdateLevel IN VARCHAR2 DEFAULT 'GROUP'
307: );
308: --

Line 314: x_Group_rec IN rlm_dp_sv.t_Group_rec

310: PROCEDURE InitializeGroup
311: (
312: x_Sched_rec IN rlm_interface_headers%ROWTYPE,
313: x_Group_ref IN OUT NOCOPY rlm_forecast_sv.t_Cursor_ref,
314: x_Group_rec IN rlm_dp_sv.t_Group_rec
315: );
316: --
317: --
318: PROCEDURE ManageGroupForecast

Line 321: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,

317: --
318: PROCEDURE ManageGroupForecast
319: (
320: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
321: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
322: x_forecast IN OUT NOCOPY
323: mrp_forecast_interface_pk.t_forecast_interface,
324: x_designator IN OUT NOCOPY
325: mrp_forecast_interface_pk.t_forecast_designator,

Line 334: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,

330: PROCEDURE ManageForecast
331: (
332: x_InterfaceHeaderId IN NUMBER,
333: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
334: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
335: x_ReturnStatus OUT NOCOPY NUMBER
336: );
337: --
338: --

Line 523: x_Group_rec IN rlm_dp_sv.t_Group_rec

519: --
520: PROCEDURE RoundStandardPack
521: (
522: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
523: x_Group_rec IN rlm_dp_sv.t_Group_rec
524: );
525: --
526: --
527: FUNCTION MatchShipments

Line 529: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,

525: --
526: --
527: FUNCTION MatchShipments
528: (
529: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
530: x_Current_rec IN RLM_RD_SV.t_Generic_rec,
531: x_Index OUT NOCOPY NUMBER
532: )
533: RETURN BOOLEAN;

Line 538: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,

534: --
535: --
536: PROCEDURE ReconcileShipments
537: (
538: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
539: x_Key_rec IN RLM_RD_SV.t_Key_rec,
540: x_Quantity IN OUT NOCOPY NUMBER
541: );
542: --

Line 547: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec

543: --
544: PROCEDURE ProcessATS
545: (
546: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
547: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
548: );
549: --
550: --
551: PROCEDURE ProcessNATS

Line 554: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec

550: --
551: PROCEDURE ProcessNATS
552: (
553: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
554: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
555: );
556: --
557: --
558: PROCEDURE ProcessPreHorizonATS

Line 561: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec

557: --
558: PROCEDURE ProcessPreHorizonATS
559: (
560: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
561: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
562: );
563: --
564: --
565: PROCEDURE ApplyFFFFences

Line 568: x_Group_rec IN rlm_dp_sv.t_Group_rec,

564: --
565: PROCEDURE ApplyFFFFences
566: (
567: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
568: x_Group_rec IN rlm_dp_sv.t_Group_rec,
569: IsLineProcessed IN OUT NOCOPY BOOLEAN
570: );
571: --
572: --

Line 576: x_Group_rec IN rlm_dp_sv.t_Group_rec

572: --
573: PROCEDURE CalculateShipDate
574: (
575: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
576: x_Group_rec IN rlm_dp_sv.t_Group_rec
577: );
578: --
579: --
580: PROCEDURE ApplySourceRules

Line 583: x_Group_rec IN rlm_dp_sv.t_Group_rec,

579: --
580: PROCEDURE ApplySourceRules
581: (
582: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
583: x_Group_rec IN rlm_dp_sv.t_Group_rec,
584: x_SourcedDemand_tab OUT NOCOPY rlm_manage_demand_sv.t_MD_Tab,
585: x_Source_Tab OUT NOCOPY rlm_manage_demand_sv.t_Source_Tab
586: );
587: --

Line 592: x_Group_rec IN rlm_dp_sv.t_Group_rec

588: --
589: PROCEDURE CUMToDiscrete
590: (
591: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
592: x_Group_rec IN rlm_dp_sv.t_Group_rec
593: );
594: --
595: --
596: PROCEDURE CUMDiscrepancyCheck

Line 599: x_Group_rec IN rlm_dp_sv.t_Group_rec

595: --
596: PROCEDURE CUMDiscrepancyCheck
597: (
598: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
599: x_Group_rec IN rlm_dp_sv.t_Group_rec
600: );
601: --
602: --
603: PROCEDURE UOMConversion

Line 605: x_Group_rec IN rlm_dp_sv.t_Group_rec

601: --
602: --
603: PROCEDURE UOMConversion
604: (
605: x_Group_rec IN rlm_dp_sv.t_Group_rec
606: );
607: --
608: --
609: PROCEDURE PostValidation;