[Home] [Help]
PACKAGE: APPS.RLM_TPA_SV
Source
1 PACKAGE RLM_TPA_SV AS
2 /* $Header: RLMTPDPS.pls 120.1.12000000.2 2007/07/30 09:26:14 brana ship $ */
3 --{
4 --
5 --
6 -- =================================================================
7 -- *** PLEASE DO NOT EDIT THIS FILE. ***
8 -- *** THIS FILE IS ALWAYS GENERATED BY TPA GENERATE UTILITY. ***
9 -- =================================================================
10 --
11 PROCEDURE populate_record_cust
12 (
13 x_ship_from_org_id IN NUMBER,
14 x_customer_id IN NUMBER,
15 x_terms_definition_level IN OUT NOCOPY VARCHAR2,
16 x_terms_rec OUT NOCOPY rlm_setup_terms_sv.setup_terms_rec_typ,
17 x_return_message IN OUT NOCOPY VARCHAR2,
18 x_return_status OUT NOCOPY BOOLEAN
19 );
20 --
21 --
22 PROCEDURE get_setup_terms
23 (
24 x_ship_from_org_id IN NUMBER,
25 x_customer_id IN NUMBER,
26 x_ship_to_address_id IN NUMBER,
27 x_customer_item_id IN NUMBER,
28 x_terms_definition_level IN OUT NOCOPY VARCHAR2,
29 x_terms_rec OUT NOCOPY rlm_setup_terms_sv.setup_terms_rec_typ,
30 x_return_message OUT NOCOPY VARCHAR2,
31 x_return_status OUT NOCOPY BOOLEAN
32 );
33 --
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 --
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 --
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
58 );
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 --
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 );
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 --
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,
95 x_DemandType IN VARCHAR2
96 );
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,
106 x_Sql2 OUT NOCOPY VARCHAR2,
107 x_Sum_Sql OUT NOCOPY VARCHAR2
108 );
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
127 );
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
146 );
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
156 );
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
166 );
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 --
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 --
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 --
201 --
202 PROCEDURE CalculateCumKey
203 (
204 x_cum_key_record IN RLM_CUM_SV.cum_key_attrib_rec_type,
205 x_cum_record IN OUT NOCOPY RLM_CUM_SV.cum_rec_type
206 );
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 --
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
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
241 (
242 x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
243 x_QuantityDate OUT NOCOPY rlm_ship_delivery_pattern_sv.t_OutputTable,
244 x_ReturnMessage OUT NOCOPY rlm_ship_delivery_pattern_sv.t_ErrorMsgTable,
245 x_ReturnStatus OUT NOCOPY NUMBER
246 );
247 --
248 --
249 PROCEDURE BuildOELine
250 (
251 x_oe_line_rec IN OUT NOCOPY oe_order_pub.line_rec_type,
252 x_Op_rec IN rlm_rd_sv.t_generic_rec
253 );
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
263 mrp_forecast_interface_pk.t_forecast_designator,
264 x_t_designator IN OUT NOCOPY
265 mrp_forecast_interface_pk.t_forecast_designator
266 );
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,
276 x_bill_site_id IN NUMBER,
277 x_bill_address_Id IN NUMBER,
278 x_ForecastDesignator IN OUT NOCOPY VARCHAR2,
279 x_ship_to_customer_id IN NUMBER DEFAULT NULL
280 );
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 --
299 --
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 --
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 --
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,
326 x_ReturnStatus OUT NOCOPY NUMBER
327 );
328 --
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 --
338 --
339 PROCEDURE UpdateInterfaceLines
340 (
341 x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
342 );
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 --
352 --
353 PROCEDURE SetHdrTPAttCategory
354 (
355 x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE
356 );
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 --
366 --
367 PROCEDURE populate_record_cust_item
368 (
369 x_ship_from_org_id IN NUMBER,
370 x_customer_id IN NUMBER,
371 x_ship_to_address_id IN NUMBER,
372 x_customer_item_id IN NUMBER,
373 x_terms_definition_level IN OUT NOCOPY VARCHAR2,
374 x_terms_rec OUT NOCOPY rlm_setup_terms_sv.setup_terms_rec_typ,
375 x_return_message IN OUT NOCOPY VARCHAR2,
376 x_return_status OUT NOCOPY BOOLEAN
377 );
378 --
379 --
380 PROCEDURE populate_record_item
381 (
382 x_ship_from_org_id IN NUMBER,
383 x_customer_id IN NUMBER,
384 x_ship_to_address_id IN NUMBER,
385 x_customer_item_id IN NUMBER,
386 x_terms_definition_level IN OUT NOCOPY VARCHAR2,
387 x_terms_rec OUT NOCOPY rlm_setup_terms_sv.setup_terms_rec_typ,
388 x_return_message IN OUT NOCOPY VARCHAR2,
389 x_return_status OUT NOCOPY BOOLEAN
390 );
391 --
392 --
393 PROCEDURE populate_record_add
394 (
395 x_ship_from_org_id IN NUMBER,
396 x_customer_id IN NUMBER,
397 x_ship_to_address_id IN NUMBER,
398 x_customer_item_id IN NUMBER,
399 x_terms_definition_level IN OUT NOCOPY VARCHAR2,
400 x_terms_rec OUT NOCOPY rlm_setup_terms_sv.setup_terms_rec_typ,
401 x_return_message IN OUT NOCOPY VARCHAR2,
402 x_return_status OUT NOCOPY BOOLEAN
403 );
404 --
405 --
406 PROCEDURE BuildTPOELine
407 (
408 x_oe_line_rec IN OUT NOCOPY oe_order_pub.line_rec_type,
409 x_Op_rec IN rlm_rd_sv.t_generic_rec
410 );
411 --
412 --
413 PROCEDURE determine_send_date
414 (
415 x_Input IN rlm_ship_delivery_pattern_sv.t_inputRec,
416 x_DailyPercent IN rlm_core_sv.t_NumberTable,
417 x_ShipmentDate IN OUT NOCOPY DATE
418 );
419 --
420 --
421 FUNCTION check_send_date
422 (
423 x_Input IN rlm_ship_delivery_pattern_sv.t_inputRec,
424 x_ShipmentDate IN DATE
425 )
426 RETURN BOOLEAN;
427 --
428 --
429 PROCEDURE determine_receive_date
430 (
431 x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
432 x_DailyPercent IN rlm_core_sv.t_NumberTable,
433 x_ReceiveDate IN OUT NOCOPY DATE
434 );
435 --
436 --
437 FUNCTION check_receive_date
438 (
439 x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
440 x_ReceiveDate IN DATE
441 )
442 RETURN BOOLEAN;
443 --
444 --
445 FUNCTION previous_valid_sdp_date
446 (
447 x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
448 x_Date IN DATE,
449 x_DailyPercent IN rlm_core_sv.t_NumberTable
450 )
451 RETURN DATE;
452 --
453 --
454 FUNCTION valid_sdp_date
455 (
456 x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
457 x_DailyPercent IN rlm_core_sv.t_NumberTable
458 )
459 RETURN BOOLEAN;
460 --
461 --
462 FUNCTION find_monday_date
463 (
464 x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
465 x_Date IN DATE
466 )
467 RETURN DATE;
468 --
469 --
470 FUNCTION check_start_date
471 (
472 x_Input IN rlm_ship_delivery_pattern_sv.t_Inputrec,
473 x_BucketType IN VARCHAR2
474 )
475 RETURN BOOLEAN;
476 --
477 --
478 PROCEDURE apply_sdp_to_daily_bucket
479 (
480 x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
481 x_ItemDetailSubtype IN VARCHAR2,
482 x_DailyPercent IN rlm_core_sv.t_NumberTable,
483 x_StartDateTime IN DATE,
484 x_PrimaryQuantity IN NUMBER,
485 x_QuantityDate IN OUT NOCOPY rlm_ship_delivery_pattern_sv.t_OutputTable
486 );
487 --
488 --
489 PROCEDURE apply_sdp_to_weekly_bucket
490 (
491 x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
492 x_ItemDetailSubtype IN VARCHAR2,
493 x_DailyPercent IN rlm_core_sv.t_NumberTable,
494 x_StartDateTime IN DATE,
495 x_PrimaryQuantity IN NUMBER,
496 x_WholeNumber IN BOOLEAN,
497 x_QuantityDate IN OUT NOCOPY RLM_SHIP_DELIVERY_PATTERN_SV.t_OutputTable
498 );
499 --
500 --
501 FUNCTION get_weekly_quantity
502 (
503 x_WholeNumber IN BOOLEAN,
504 x_Count IN NUMBER,
505 x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
506 x_DivideBy IN NUMBER
507 )
508 RETURN NUMBER;
509 --
510 --
511 PROCEDURE break_bucket
512 (
513 x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
514 x_ReturnMessage IN OUT NOCOPY rlm_ship_delivery_pattern_sv.t_ErrorMsgTable,
515 x_WeeklyBucket OUT NOCOPY rlm_ship_delivery_pattern_sv.t_BucketTable,
516 x_ReturnStatus OUT NOCOPY NUMBER
517 );
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 --
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;
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 --
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
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
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
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 --
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
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 --
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
604 (
605 x_Group_rec IN rlm_dp_sv.t_Group_rec
606 );
607 --
608 --
609 PROCEDURE PostValidation;
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 --
619 PROCEDURE ValidSchedulePurpose
620 (
621 x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE
622 );
623 --
624 --
625 FUNCTION ValidLookup
626 (
627 p_lookup_type IN VARCHAR2,
628 p_lookup_code IN VARCHAR2,
629 p_date IN DATE
630 )
631 RETURN BOOLEAN;
632 --
633 --
634 PROCEDURE ValidScheduleType
635 (
636 x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE
637 );
638 --
639 --
640 PROCEDURE ValidScheduleReferenceNum
641 (
642 x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE
643 );
644 --
645 --
646 PROCEDURE ValidHorizonDates
647 (
648 x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE
649 );
650 --
651 --
652 PROCEDURE ValidScheduleSource
653 (
654 x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE
655 );
656 --
657 --
658 PROCEDURE ValidNumberLines
659 (
660 x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE
661 );
662 --
663 --
664 PROCEDURE ValidScheduleHeader
665 (
666 x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE
667 );
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 --
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 --
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 --
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 --
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 --
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 --
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 --
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 --
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 --
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 --
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 --
752 PROCEDURE UpdateCumKey
753 (
754 x_trip_stop_id IN NUMBER,
755 x_return_status OUT NOCOPY BOOLEAN
756 );
757 --
758 --
759 PROCEDURE CalculateSupplierCum
760 (
761 x_new_ship_count IN RLM_CUM_SV.t_new_ship_count DEFAULT RLM_CUM_SV.g_miss_new_ship_count,
762 x_cum_key_record IN RLM_CUM_SV.cum_key_attrib_rec_type,
763 x_cum_record IN OUT NOCOPY RLM_CUM_SV.cum_rec_type
764 );
765 --
766 --
767 --
768 --}
769 END RLM_TPA_SV;
770 --