[Home] [Help]
232: --
233: PROCEDURE InsertOMMessages
234: (
235: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
236: x_Group_rec IN RLM_DP_SV.t_Group_rec,
237: x_msg_count IN NUMBER,
238: x_msg_level IN VARCHAR2,
239: x_token IN VARCHAR2,
240: x_msg_name IN VARCHAR2
290: --
291: PROCEDURE CreateRSOHeader
292: (
293: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
294: x_Group_rec IN RLM_DP_SV.t_Group_rec,
295: x_rso_hdr_id OUT NOCOPY NUMBER
296: )
297: IS
298: --{
342: --
343: PROCEDURE InsertRSO
344: (
345: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
346: x_Group_rec IN RLM_DP_SV.t_Group_rec,
347: p_rso_hdr_id IN NUMBER,
348: p_start_date IN DATE,
349: p_end_date IN DATE
350: )
398: --
399: PROCEDURE DeriveRSO
400: (
401: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
402: x_Group_rec IN RLM_DP_SV.t_Group_rec,
403: x_return_status OUT NOCOPY NUMBER
404: )
405: IS
406: --{
450: --
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,
510: --
511: PROCEDURE BuildMatchQuery
512: (
513: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
514: x_Group_Rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
515: x_Demand_Type IN VARCHAR2,
516: x_Sql OUT NOCOPY VARCHAR2,
517: x_Sql1 OUT NOCOPY VARCHAR2,
518: x_Sql2 OUT NOCOPY VARCHAR2,
570: --
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
624: --
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: )
680: --
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
734: --
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: )
790: --
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: )
846: --
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: )
902: --
903: FUNCTION GetIntransitAcrossOrgs
904: (
905: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
906: x_Group_rec IN rlm_dp_sv.t_Group_rec,
907: x_cum_key_id IN NUMBER
908: )
909: RETURN NUMBER
910: IS
961: PROCEDURE InitializeMdGroup
962: (
963: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
964: x_Group_ref IN OUT NOCOPY rlm_manage_demand_sv.t_Cursor_ref,
965: x_Group_rec IN rlm_dp_sv.t_Group_rec
966: )
967: IS
968: --{
969: --
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: --{
1021: --
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: --{
1073: --
1166: --
1167: FUNCTION GetAllIntransitQty
1168: (
1169: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1170: x_Group_rec IN rlm_dp_sv.t_Group_rec,
1171: x_Source_Tab IN rlm_manage_demand_sv.t_Source_Tab
1172: )
1173: RETURN NUMBER
1174: IS
1224: --
1225: FUNCTION CalculateIntransitQty
1226: (
1227: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1228: x_Group_rec IN rlm_dp_sv.t_Group_rec
1229: )
1230: RETURN NUMBER
1231: IS
1232: --{
1280: --
1281: PROCEDURE SynchronizeShipments
1282: (
1283: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1284: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
1285: )
1286: IS
1287: --{
1288: --
1330: --
1331: PROCEDURE ProcessOld
1332: (
1333: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1334: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
1335: )
1336: IS
1337: --{
1338: --
1484: --
1485: PROCEDURE EmptyForecast
1486: (
1487: x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1488: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
1489: x_forecast IN OUT NOCOPY
1490: mrp_forecast_interface_pk.t_forecast_interface,
1491: x_designator IN OUT NOCOPY
1492: mrp_forecast_interface_pk.t_forecast_designator,
1543: --
1544: PROCEDURE GetDesignator
1545: (
1546: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE DEFAULT NULL,
1547: x_Group_rec IN rlm_dp_sv.t_Group_rec DEFAULT NULL,
1548: x_Customer_id IN NUMBER,
1549: x_ShipFromOrgId IN NUMBER,
1550: x_Ship_Site_Id IN NUMBER,
1551: x_bill_site_id IN NUMBER,
1607: --
1608: PROCEDURE LoadForecast
1609: (
1610: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1611: x_Group_rec IN rlm_dp_sv.t_Group_rec,
1612: t_forecast IN OUT NOCOPY mrp_forecast_interface_pk.t_forecast_interface,
1613: x_forecast_designator IN mrp_forecast_designators.forecast_designator%TYPE
1614: )
1615: IS
1661: --
1662: PROCEDURE ProcessTable
1663: (
1664: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1665: x_Group_rec IN rlm_dp_sv.t_Group_rec,
1666: t_Forecast IN mrp_forecast_interface_pk.t_forecast_interface
1667: )
1668: IS
1669: --{
1714: PROCEDURE UpdateGroupStatus
1715: (
1716: x_header_id IN NUMBER,
1717: x_ScheduleHeaderId IN NUMBER,
1718: x_Group_rec IN rlm_dp_sv.t_Group_rec,
1719: x_status IN NUMBER,
1720: x_UpdateLevel IN VARCHAR2 DEFAULT 'GROUP'
1721: )
1722: IS
1770: PROCEDURE InitializeGroup
1771: (
1772: x_Sched_rec IN rlm_interface_headers%ROWTYPE,
1773: x_Group_ref IN OUT NOCOPY rlm_forecast_sv.t_Cursor_ref,
1774: x_Group_rec IN rlm_dp_sv.t_Group_rec
1775: )
1776: IS
1777: --{
1778: --
1821: --
1822: PROCEDURE ManageGroupForecast
1823: (
1824: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1825: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
1826: x_forecast IN OUT NOCOPY
1827: mrp_forecast_interface_pk.t_forecast_interface,
1828: x_designator IN OUT NOCOPY
1829: mrp_forecast_interface_pk.t_forecast_designator,
1880: PROCEDURE ManageForecast
1881: (
1882: x_InterfaceHeaderId IN NUMBER,
1883: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1884: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
1885: x_ReturnStatus OUT NOCOPY NUMBER
1886: )
1887: IS
1888: --{
3043: --
3044: PROCEDURE RoundStandardPack
3045: (
3046: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
3047: x_Group_rec IN rlm_dp_sv.t_Group_rec
3048: )
3049: IS
3050: --{
3051: --
3092: --
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
3150: --
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
3203: --
3204: PROCEDURE ProcessATS
3205: (
3206: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
3207: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
3208: )
3209: IS
3210: --{
3211: --
3253: --
3254: PROCEDURE ProcessNATS
3255: (
3256: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
3257: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
3258: )
3259: IS
3260: --{
3261: --
3303: --
3304: PROCEDURE ProcessPreHorizonATS
3305: (
3306: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
3307: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
3308: )
3309: IS
3310: --{
3311: --
3353: --
3354: PROCEDURE ApplyFFFFences
3355: (
3356: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
3357: x_Group_rec IN rlm_dp_sv.t_Group_rec,
3358: IsLineProcessed IN OUT NOCOPY BOOLEAN
3359: )
3360: IS
3361: --{
3405: --
3406: PROCEDURE CalculateShipDate
3407: (
3408: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
3409: x_Group_rec IN rlm_dp_sv.t_Group_rec
3410: )
3411: IS
3412: --{
3413: --
3455: --
3456: PROCEDURE ApplySourceRules
3457: (
3458: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
3459: x_Group_rec IN rlm_dp_sv.t_Group_rec,
3460: x_SourcedDemand_tab OUT NOCOPY rlm_manage_demand_sv.t_MD_Tab,
3461: x_Source_Tab OUT NOCOPY rlm_manage_demand_sv.t_Source_Tab
3462: )
3463: IS
3509: --
3510: PROCEDURE CUMToDiscrete
3511: (
3512: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
3513: x_Group_rec IN rlm_dp_sv.t_Group_rec
3514: )
3515: IS
3516: --{
3517: --
3559: --
3560: PROCEDURE CUMDiscrepancyCheck
3561: (
3562: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
3563: x_Group_rec IN rlm_dp_sv.t_Group_rec
3564: )
3565: IS
3566: --{
3567: --
3608: --
3609: --
3610: PROCEDURE UOMConversion
3611: (
3612: x_Group_rec IN rlm_dp_sv.t_Group_rec
3613: )
3614: IS
3615: --{
3616: --