34: --
35: PROCEDURE CheckCUMKeyPO
36: (
37: x_group_rec IN RLM_VALIDATEDEMAND_SV.t_group_rec,
38: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
39: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE
40: );
41: --
42: --
41: --
42: --
43: PROCEDURE DeriveInventoryItemId
44: (
45: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
46: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE
47: );
48: --
49: --
48: --
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,
59: --
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: --
67: --
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
77: --
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: --
85: --
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,
97: --
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,
109: --
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: --
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
128: --
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: --
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
147: --
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
157: --
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
167: --
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: --
177: --
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: --
184: --
185: --
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: --
192: --
193: --
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: --
207: --
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: --
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: --
224: --
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: --
231: --
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: --
254: --
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
267: --
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,
281: --
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: --
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: --
308: --
309: --
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: --
316: --
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
329: --
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: --
337: --
338: --
339: PROCEDURE UpdateInterfaceLines
340: (
341: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
342: );
343: --
344: --
345: PROCEDURE SetLineTPAttCategory
343: --
344: --
345: PROCEDURE SetLineTPAttCategory
346: (
347: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,
348: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,
349: x_group_rec IN OUT NOCOPY RLM_VALIDATEDEMAND_SV.t_Group_rec
350: );
351: --
351: --
352: --
353: PROCEDURE SetHdrTPAttCategory
354: (
355: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE
356: );
357: --
358: --
359: PROCEDURE SetTPAttCategory
357: --
358: --
359: PROCEDURE SetTPAttCategory
360: (
361: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,
362: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,
363: x_group_rec IN OUT NOCOPY RLM_VALIDATEDEMAND_SV.t_Group_rec
364: );
365: --
518: --
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: --
542: --
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: --
549: --
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: --
556: --
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: --
563: --
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: --
571: --
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: --
578: --
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: --
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: --
594: --
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: --
610: --
611: --
612: PROCEDURE ValidateCustomerItem
613: (
614: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
615: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE
616: );
617: --
618: --
617: --
618: --
619: PROCEDURE ValidSchedulePurpose
620: (
621: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE
622: );
623: --
624: --
625: FUNCTION ValidLookup
632: --
633: --
634: PROCEDURE ValidScheduleType
635: (
636: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE
637: );
638: --
639: --
640: PROCEDURE ValidScheduleReferenceNum
638: --
639: --
640: PROCEDURE ValidScheduleReferenceNum
641: (
642: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE
643: );
644: --
645: --
646: PROCEDURE ValidHorizonDates
644: --
645: --
646: PROCEDURE ValidHorizonDates
647: (
648: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE
649: );
650: --
651: --
652: PROCEDURE ValidScheduleSource
650: --
651: --
652: PROCEDURE ValidScheduleSource
653: (
654: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE
655: );
656: --
657: --
658: PROCEDURE ValidNumberLines
656: --
657: --
658: PROCEDURE ValidNumberLines
659: (
660: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE
661: );
662: --
663: --
664: PROCEDURE ValidScheduleHeader
662: --
663: --
664: PROCEDURE ValidScheduleHeader
665: (
666: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE
667: );
668: --
669: --
670: PROCEDURE ValidItemDetailType
668: --
669: --
670: PROCEDURE ValidItemDetailType
671: (
672: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
673: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE
674: );
675: --
676: --
675: --
676: --
677: PROCEDURE ValidItemDetailSubtype
678: (
679: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
680: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE
681: );
682: --
683: --
683: --
684: PROCEDURE ValidQtyTypeCode
685: (
686: x_setup_terms_rec IN rlm_setup_terms_sv.setup_terms_rec_typ,
687: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
688: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE
689: );
690: --
691: --
690: --
691: --
692: PROCEDURE ValidItemDetailQty
693: (
694: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
695: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE
696: );
697: --
698: --
697: --
698: --
699: PROCEDURE ValidDateTypeCode
700: (
701: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
702: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE
703: );
704: --
705: --
704: --
705: --
706: PROCEDURE ValidDateRange
707: (
708: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
709: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE
710: );
711: --
712: --
711: --
712: --
713: PROCEDURE ValidateUOM
714: (
715: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
716: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE
717: );
718: --
719: --
719: --
720: PROCEDURE ValidOrderHeaderId
721: (
722: x_setup_terms_rec IN rlm_setup_terms_sv.setup_terms_rec_typ,
723: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
724: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE
725: );
726: --
727: --
727: --
728: PROCEDURE ValidateLineDetails
729: (
730: x_setup_terms_rec IN rlm_setup_terms_sv.setup_terms_rec_typ,
731: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
732: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,
733: x_line_source IN VARCHAR2
734: );
735: --
735: --
736: --
737: PROCEDURE ValidLineScheduleType
738: (
739: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
740: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE
741: );
742: --
743: --
743: --
744: PROCEDURE ValidPlanningProdSeqNum
745: (
746: x_setup_terms_rec IN rlm_setup_terms_sv.setup_terms_rec_typ,
747: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
748: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE
749: );
750: --
751: --