451: PROCEDURE ReconcileAction
452: (
453: x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
454: x_group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
455: x_key_rec IN OUT NOCOPY RLM_RD_SV.t_key_rec,
456: x_line_id_tab IN RLM_RD_SV.t_matching_line,
457: x_DemandCount IN NUMBER,
458: x_SumOrderedQty IN NUMBER,
459: x_DemandType IN VARCHAR2
452: (
453: x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
454: x_group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
455: x_key_rec IN OUT NOCOPY RLM_RD_SV.t_key_rec,
456: x_line_id_tab IN RLM_RD_SV.t_matching_line,
457: x_DemandCount IN NUMBER,
458: x_SumOrderedQty IN NUMBER,
459: x_DemandType IN VARCHAR2
460: )
481: BEGIN
482: --{
483: --
484: --
485: RLM_RD_SV.ReconcileAction
486: (
487: x_sched_rec => x_sched_rec,
488: x_group_rec => x_group_rec,
489: x_key_rec => x_key_rec,
541: BEGIN
542: --{
543: --
544: --
545: RLM_RD_SV.BuildMatchQuery
546: (
547: x_Sched_rec => x_Sched_rec,
548: x_Group_Rec => x_Group_Rec,
549: x_Demand_Type => x_Demand_Type,
571: PROCEDURE OtherDemand
572: (
573: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
574: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
575: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
576: x_Demand_ref IN OUT NOCOPY RLM_RD_SV.t_Cursor_ref
577: )
578: IS
579: --{
572: (
573: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
574: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
575: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
576: x_Demand_ref IN OUT NOCOPY RLM_RD_SV.t_Cursor_ref
577: )
578: IS
579: --{
580: --
598: BEGIN
599: --{
600: --
601: --
602: RLM_RD_SV.OtherDemand
603: (
604: x_Sched_rec => x_Sched_rec,
605: x_Group_rec => x_Group_rec,
606: x_Key_rec => x_Key_rec,
625: PROCEDURE DecreaseDemand
626: (
627: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
628: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
629: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
630: x_Demand_ref IN OUT NOCOPY RLM_RD_SV.t_Cursor_ref,
631: x_SumOrderedQty IN NUMBER
632: )
633: IS
626: (
627: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
628: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
629: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
630: x_Demand_ref IN OUT NOCOPY RLM_RD_SV.t_Cursor_ref,
631: x_SumOrderedQty IN NUMBER
632: )
633: IS
634: --{
653: BEGIN
654: --{
655: --
656: --
657: RLM_RD_SV.DecreaseDemand
658: (
659: x_Sched_rec => x_Sched_rec,
660: x_Group_rec => x_Group_rec,
661: x_Key_rec => x_Key_rec,
681: PROCEDURE DeleteDemand
682: (
683: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
684: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
685: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
686: x_Demand_ref IN OUT NOCOPY RLM_RD_SV.t_Cursor_ref
687: )
688: IS
689: --{
682: (
683: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
684: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
685: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
686: x_Demand_ref IN OUT NOCOPY RLM_RD_SV.t_Cursor_ref
687: )
688: IS
689: --{
690: --
708: BEGIN
709: --{
710: --
711: --
712: RLM_RD_SV.DeleteDemand
713: (
714: x_Sched_rec => x_Sched_rec,
715: x_Group_rec => x_Group_rec,
716: x_Key_rec => x_Key_rec,
735: PROCEDURE IncreaseDemand
736: (
737: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
738: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
739: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
740: x_Demand_ref IN OUT NOCOPY RLM_RD_SV.t_Cursor_ref,
741: x_SumOrderedQty IN NUMBER
742: )
743: IS
736: (
737: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
738: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
739: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
740: x_Demand_ref IN OUT NOCOPY RLM_RD_SV.t_Cursor_ref,
741: x_SumOrderedQty IN NUMBER
742: )
743: IS
744: --{
763: BEGIN
764: --{
765: --
766: --
767: RLM_RD_SV.IncreaseDemand
768: (
769: x_Sched_rec => x_Sched_rec,
770: x_Group_rec => x_Group_rec,
771: x_Key_rec => x_Key_rec,
791: PROCEDURE UpdateDemand
792: (
793: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
794: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
795: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
796: x_SumOrderedQty IN NUMBER,
797: x_DemandType IN VARCHAR2
798: )
799: IS
819: BEGIN
820: --{
821: --
822: --
823: RLM_RD_SV.UpdateDemand
824: (
825: x_Sched_rec => x_Sched_rec,
826: x_Group_rec => x_Group_rec,
827: x_Key_rec => x_Key_rec,
847: PROCEDURE InsertRequirement
848: (
849: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
850: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
851: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
852: x_Reconcile IN BOOLEAN,
853: x_Quantity IN OUT NOCOPY NUMBER
854: )
855: IS
875: BEGIN
876: --{
877: --
878: --
879: RLM_RD_SV.InsertRequirement
880: (
881: x_Sched_rec => x_Sched_rec,
882: x_Group_rec => x_Group_rec,
883: x_Key_rec => x_Key_rec,
1012: --
1013: PROCEDURE InitializeSoGroup
1014: (
1015: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1016: x_Group_ref IN OUT NOCOPY rlm_rd_sv.t_Cursor_ref,
1017: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
1018: )
1019: IS
1020: --{
1039: BEGIN
1040: --{
1041: --
1042: --
1043: RLM_RD_SV.InitializeSoGroup
1044: (
1045: x_Sched_rec => x_Sched_rec,
1046: x_Group_ref => x_Group_ref,
1047: x_Group_rec => x_Group_rec
1064: --
1065: PROCEDURE InitializeBlktGrp
1066: (
1067: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1068: x_Group_ref IN OUT NOCOPY rlm_rd_sv.t_Cursor_ref,
1069: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
1070: )
1071: IS
1072: --{
1091: BEGIN
1092: --{
1093: --
1094: --
1095: RLM_RD_SV.InitializeBlktGrp
1096: (
1097: x_Sched_rec => x_Sched_rec,
1098: x_Group_ref => x_Group_ref,
1099: x_Group_rec => x_Group_rec
1306: BEGIN
1307: --{
1308: --
1309: --
1310: RLM_RD_SV.SynchronizeShipments
1311: (
1312: x_Sched_rec => x_Sched_rec,
1313: x_Group_rec => x_Group_rec
1314: )
1356: BEGIN
1357: --{
1358: --
1359: --
1360: RLM_RD_SV.ProcessOld
1361: (
1362: x_Sched_rec => x_Sched_rec,
1363: x_Group_rec => x_Group_rec
1364: )
1434: --
1435: PROCEDURE BuildOELine
1436: (
1437: x_oe_line_rec IN OUT NOCOPY oe_order_pub.line_rec_type,
1438: x_Op_rec IN rlm_rd_sv.t_generic_rec
1439: )
1440: IS
1441: --{
1442: --
2319: --
2320: PROCEDURE BuildTPOELine
2321: (
2322: x_oe_line_rec IN OUT NOCOPY oe_order_pub.line_rec_type,
2323: x_Op_rec IN rlm_rd_sv.t_generic_rec
2324: )
2325: IS
2326: --{
2327: --
3093: --
3094: FUNCTION MatchShipments
3095: (
3096: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
3097: x_Current_rec IN RLM_RD_SV.t_Generic_rec,
3098: x_Index OUT NOCOPY NUMBER
3099: )
3100: RETURN BOOLEAN
3101: IS
3123: BEGIN
3124: --{
3125: --
3126: --
3127: l_return_value := RLM_RD_SV.MatchShipments
3128: (
3129: x_Group_rec => x_Group_rec,
3130: x_Current_rec => x_Current_rec,
3131: x_Index => x_Index
3151: --
3152: PROCEDURE ReconcileShipments
3153: (
3154: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
3155: x_Key_rec IN RLM_RD_SV.t_Key_rec,
3156: x_Quantity IN OUT NOCOPY NUMBER
3157: )
3158: IS
3159: --{
3178: BEGIN
3179: --{
3180: --
3181: --
3182: RLM_RD_SV.ReconcileShipments
3183: (
3184: x_Group_rec => x_Group_rec,
3185: x_Key_rec => x_Key_rec,
3186: x_Quantity => x_Quantity
3229: BEGIN
3230: --{
3231: --
3232: --
3233: RLM_RD_SV.ProcessATS
3234: (
3235: x_Sched_rec => x_Sched_rec,
3236: x_Group_rec => x_Group_rec
3237: )
3279: BEGIN
3280: --{
3281: --
3282: --
3283: RLM_RD_SV.ProcessNATS
3284: (
3285: x_Sched_rec => x_Sched_rec,
3286: x_Group_rec => x_Group_rec
3287: )
3329: BEGIN
3330: --{
3331: --
3332: --
3333: RLM_RD_SV.ProcessPreHorizonATS
3334: (
3335: x_Sched_rec => x_Sched_rec,
3336: x_Group_rec => x_Group_rec
3337: )