[Home] [Help]
404: CHANGE HISTORY: created jhaulund 03/05/99
405: ===========================================================================*/
406: PROCEDURE RecDemand(x_InterfaceHeaderId IN NUMBER,
407: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
408: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
409: x_ReturnStatus OUT NOCOPY NUMBER);
410:
411: /*============================================================================
412:
414:
415: ============================================================================*/
416:
417: PROCEDURE RecGroupDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
418: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec);
419:
420:
421: /*===========================================================================
422: PROCEDURE NAME: CallSetups
424: DESCRIPTION: This procedure calls rla setups to populate group
425: record with setup informations.
426:
427: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
428: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
429:
430: DESIGN REFERENCES: RLADPRDD.rtf
431:
432: ALGORITHM:
439:
440: CHANGE HISTORY: created mnandell 03/11/99
441: ===========================================================================*/
442: Procedure CallSetups(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
443: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec);
444:
445:
446: /*===========================================================================
447: PROCEDURE NAME: ExecOperations
449: DESCRIPTION: This procedure calls process order api using the global
450: operations table loaded in reconcile demand.
451:
452: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
453: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
454:
455: DESIGN REFERENCES: RLADPRDD.rtf
456:
457: ALGORITHM:
464:
465: CHANGE HISTORY: created jhaulund 03/08/99
466: ===========================================================================*/
467: Procedure ExecOperations(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
468: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec);
469:
470:
471: /*===========================================================================
472: PROCEDURE NAME: CancelPreHorizonNATS
474: DESCRIPTION: This procedure cancels prehorizon demand which are not authorized
475: to ship for the current schedule item
476:
477: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
478: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
479:
480: DESIGN REFERENCES: RLADPRDD.rtf
481:
482: ALGORITHM:
489:
490: CHANGE HISTORY: created jhaulund 03/08/99
491: ===========================================================================*/
492: Procedure CancelPreHorizonNATS(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
493: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec);
494:
495:
496: /*===========================================================================
497: PROCEDURE NAME: SynchronizeShipments
500: which took place after the last customer recognized shipment
501: to ship for the current schedule item
502:
503: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
504: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
505:
506: DESIGN REFERENCES: RLADPRDD.rtf
507:
508: ALGORITHM:
515:
516: CHANGE HISTORY: created jhaulund 03/08/99
517: ===========================================================================*/
518: Procedure SynchronizeShipments(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
519: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec);
520: --
521:
522:
523: /*===========================================================================
525:
526: DESCRIPTION: This procedure processes pre-horizon firm demand.
527:
528: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
529: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
530:
531: DESIGN REFERENCES: RLADPRDD.rtf
532:
533: ALGORITHM:
540:
541: CHANGE HISTORY: created jhaulund 03/08/99
542: ===========================================================================*/
543: Procedure ProcessPreHorizonATS(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
544: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec);
545: --
546:
547:
548: /*===========================================================================
551: DESCRIPTION: This procedure will process incoming requirements which are
552: not authorized to ship.
553:
554: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
555: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
556:
557: DESIGN REFERENCES: RLADPRDD.rtf
558:
559: ALGORITHM:
566:
567: CHANGE HISTORY: created jhaulund 03/08/99
568: ===========================================================================*/
569: Procedure ProcessNATS(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
570: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec);
571: --
572:
573:
574: /*===========================================================================
576:
577: DESCRIPTION: This procedure will process incoming firm requirements
578:
579: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
580: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
581:
582: DESIGN REFERENCES: RLADPRDD.rtf
583:
584: ALGORITHM:
591:
592: CHANGE HISTORY: created jhaulund 03/08/99
593: ===========================================================================*/
594: Procedure ProcessATS(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
595: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec);
596: --
597:
598:
599: /*===========================================================================
678:
679: DESCRIPTION: This procedure will delete the passed requirement
680:
681: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
682: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
683: x_Key_rec IN OUT NOCOPY t_Key_rec
684: x_Reconcile IN BOOLEAN
685: x_DeleteQty OUT NOCOPY NUMBER
686:
696:
697: CHANGE HISTORY: created jhaulund 03/08/99
698: ===========================================================================*/
699: Procedure DeleteRequirement(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
700: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
701: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
702: x_Reconcile IN BOOLEAN,
703: x_DeleteQty OUT NOCOPY NUMBER);
704:
709:
710: DESCRIPTION: This procedure will update the passed demand
711:
712: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
713: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
714: x_Key_rec IN t_Key_rec
715: x_Quantity IN NUMBER
716:
717: DESIGN REFERENCES: RLADPRDD.rtf
726:
727: CHANGE HISTORY: created jhaulund 03/08/99
728: ===========================================================================*/
729: Procedure UpdateRequirement(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
730: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
731: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
732: x_Quantity IN NUMBER);
733:
734:
738:
739: DESCRIPTION: This procedure will insert the passed requirement
740:
741: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
742: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
743: x_Key_rec IN t_Key_rec
744: x_Quantity IN NUMBER
745: x_Reconcile IN BOOLEAN
746:
756:
757: CHANGE HISTORY: created jhaulund 03/08/99
758: ===========================================================================*/
759: Procedure InsertRequirement(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
760: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
761: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
762: x_Reconcile IN BOOLEAN,
763: x_Quantity IN OUT NOCOPY NUMBER);
764: --
770:
771: DESCRIPTION: This procedure will update demand for the passed requirement
772:
773: PARAMETERS: x_Sched_rec IN t_Sched_type
774: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
775: x_Key_rec IN t_Key_rec
776: x_SumOrderedQty IN NUMBER
777: x_Demand_type IN VARCHAR2
778:
788:
789: CHANGE HISTORY: created jhaulund 03/08/99
790: ===========================================================================*/
791: Procedure UpdateDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
792: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
793: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
794: x_SumOrderedQty IN NUMBER,
795: x_DemandType IN VARCHAR2);
796: --
801:
802: DESCRIPTION: This procedure will increase demand for the passed requirement
803:
804: PARAMETERS: x_Sched_rec IN t_Sched_type
805: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
806: x_Key_rec IN t_Key_rec
807: x_Demand_ref IN OUT NOCOPY t_Cursor_ref
808: x_SumOrderedQty IN NUMBER
809:
819:
820: CHANGE HISTORY: created jhaulund 03/08/99
821: ===========================================================================*/
822: Procedure IncreaseDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
823: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
824: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
825: x_Demand_ref IN OUT NOCOPY RLM_RD_SV.t_Cursor_ref,
826: x_SumOrderedQty IN NUMBER);
827: --
832:
833: DESCRIPTION: This procedure will delete demand for the passed requirement
834:
835: PARAMETERS: x_Sched_rec IN t_Sched_type
836: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
837: x_Key_rec IN t_Key_rec
838: x_Demand_ref IN OUT NOCOPY t_Cursor_ref
839:
840: DESIGN REFERENCES: RLADPRDD.rtf
849:
850: CHANGE HISTORY: created jhaulund 03/08/99
851: ===========================================================================*/
852: Procedure DeleteDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
853: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
854: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
855: x_Demand_ref IN OUT NOCOPY RLM_RD_SV.t_Cursor_ref);
856: --
857:
861:
862: DESCRIPTION: This procedure will decrease demand for the passed requirement
863:
864: PARAMETERS: x_Sched_rec IN t_Sched_type
865: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
866: x_Key_rec IN t_Key_rec
867: x_Demand_ref IN OUT NOCOPY t_Cursor_ref
868: x_SumOrderedQty IN NUMBER
869:
879:
880: CHANGE HISTORY: created jhaulund 03/08/99
881: ===========================================================================*/
882: Procedure DecreaseDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
883: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
884: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
885: x_Demand_ref IN OUT NOCOPY RLM_RD_SV.t_Cursor_ref,
886: x_SumOrderedQty IN NUMBER);
887: --
893: DESCRIPTION: This procedure will update demand for the passed requirement
894: where the attributes have changed.
895:
896: PARAMETERS: x_Sched_rec IN t_Sched_type
897: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
898: x_Key_rec IN OUT NOCOPY t_Key_rec
899: x_Demand_ref IN OUT NOCOPY t_Cursor_ref
900:
901: DESIGN REFERENCES: RLADPRDD.rtf
910:
911: CHANGE HISTORY: created jhaulund 03/08/99
912: ===========================================================================*/
913: Procedure OtherDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
914: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
915: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
916: x_Demand_ref IN OUT NOCOPY RLM_RD_SV.t_Cursor_ref);
917: --
918:
921:
922: DESCRIPTION: This procedure will cancel the passed requirement
923:
924: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
925: x_Group_rec IN rlm_dp_sv.t_Group_rec
926: x_Key_rec IN t_Key_rec
927: x_CancelQty IN NUMBER
928:
929: DESIGN REFERENCES: RLADPRDD.rtf
938:
939: CHANGE HISTORY: created jhaulund 03/08/99
940: ===========================================================================*/
941: Procedure CancelRequirement(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
942: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
943: x_Key_rec IN RLM_RD_SV.t_Key_rec,
944: x_CancelQty IN NUMBER);
945:
946:
975: FUNCTION NAME: MatchReconcile
976:
977: DESCRIPTION: This procedure will match against the reconcile table
978:
979: PARAMETERS: x_Group_rec IN rlm_dp_sv.t_Group_rec
980: x_Current_rec IN t_Generic_rec
981: x_Index OUT NOCOPY NUMBER
982:
983: DESIGN REFERENCES: RLADPRDD.rtf
991: CLOSED ISSUES:
992:
993: CHANGE HISTORY: created jhaulund 03/08/99
994: ===========================================================================*/
995: Function MatchReconcile(x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
996: x_Current_rec IN t_Generic_rec,
997: x_Index OUT NOCOPY NUMBER)
998: RETURN BOOLEAN;
999:
1078: DESCRIPTION: This procedure will store unreconcilable quantities to be
1079: reconciled against incoming requirements.
1080:
1081: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
1082: x_Group_rec IN rlm_dp_sv.t_Group_rec
1083: x_Key_rec IN t_Key_rec
1084: x_RecQty IN NUMBER
1085:
1086: DESIGN REFERENCES: RLADPRDD.rtf
1095:
1096: CHANGE HISTORY: created jhaulund 03/08/99
1097: ===========================================================================*/
1098: Procedure StoreReconcile(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1099: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
1100: x_Key_rec IN RLM_RD_SV.t_Key_rec,
1101: x_Quantity IN NUMBER);
1102:
1103:
1107: DESCRIPTION: This procedure will reconcile quantities
1108: of incoming requirements against unreconcilable
1109: demand.
1110:
1111: PARAMETERS: x_Group_rec IN rlm_dp_sv.t_Group_rec
1112: x_Key_rec IN OUT NOCOPY t_Key_rec
1113: x_RecQty IN NUMBER
1114:
1115: DESIGN REFERENCES: RLADPRDD.rtf
1123: CLOSED ISSUES:
1124:
1125: CHANGE HISTORY: created jhaulund 03/08/99
1126: ===========================================================================*/
1127: Procedure Reconcile(x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
1128: x_Key_rec IN RLM_RD_SV.t_Key_rec,
1129: x_Quantity IN OUT NOCOPY NUMBER);
1130:
1131:
1135: DESCRIPTION: This procedure delete demand which is not included on the
1136: incoming schedule.
1137:
1138: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
1139: x_Group_rec IN rlm_dp_sv.t_Group_rec
1140:
1141: DESIGN REFERENCES: RLADPRDD.rtf
1142:
1143: ALGORITHM:
1150:
1151: CHANGE HISTORY: created jhaulund 03/08/99
1152: ===========================================================================*/
1153: Procedure ProcessOld(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1154: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec);
1155:
1156: --
1157:
1158:
1178: CHANGE HISTORY: created jhaulund 03/08/99
1179: ===========================================================================*/
1180: Procedure InitializeSoGroup(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1181: x_Group_ref IN OUT NOCOPY rlm_rd_sv.t_Cursor_ref,
1182: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec);
1183: --
1184: -- NOTE: need to add for checking irreconcileable differences
1185: /*===========================================================================
1186: PROCEDURE NAME: CheckRec
1203:
1204: CHANGE HISTORY: created jhaulund 03/08/99
1205: ===========================================================================
1206: Procedure CheckRec(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1207: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec);
1208: */
1209:
1210:
1211: /*===========================================================================
1213:
1214: DESCRIPTION: This procedure sets up the requirements cursor.
1215:
1216: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
1217: x_Group_rec IN rlm_dp_sv.t_Group_rec
1218: x_Req_ref IN OUT NOCOPY t_Cursor_ref
1219: x_ReqType IN VARCHAR2
1220:
1221: DESIGN REFERENCES: RLADPRDD.rtf
1230:
1231: CHANGE HISTORY: created jhaulund 03/08/99
1232: ===========================================================================*/
1233: Procedure InitializeReq(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1234: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
1235: x_Req_ref IN OUT NOCOPY t_Cursor_ref,
1236: x_ReqType IN VARCHAR2);
1237:
1238:
1241:
1242: DESCRIPTION: This function fetches next group, when blankets are not used.
1243:
1244: PARAMETERS: x_Group_ref IN OUT NOCOPY t_Cursor_ref
1245: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
1246:
1247: DESIGN REFERENCES: RLADPRDD.rtf
1248:
1249: ALGORITHM:
1256:
1257: CHANGE HISTORY: created jhaulund 03/08/99
1258: ===========================================================================*/
1259: Function FetchGroup(x_Group_ref IN OUT NOCOPY t_Cursor_ref,
1260: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)
1261: RETURN BOOLEAN;
1262:
1263:
1264: /*===========================================================================
1322: FUNCTION NAME: SchedulePrecedence
1323:
1324: DESCRIPTION: Check for schedule precedence.
1325:
1326: PARAMETERS: x_Group_rec IN rlm_dp_sv.t_Group_rec
1327: x_ScheduleType IN VARCHAR2
1328:
1329:
1330: DESIGN REFERENCES: RLADPHLD.rtf
1339: CLOSED ISSUES:
1340:
1341: CHANGE HISTORY: created mnandell 03/09/99
1342: ===========================================================================*/
1343: FUNCTION SchedulePrecedence(x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
1344: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1345: x_ScheduleType IN VARCHAR2)
1346: RETURN BOOLEAN;
1347:
1352: DESCRIPTION: This procedure will store the shipments information in the
1353: reconcile_tab. This shipment information will be useful for
1354: shipment reconciliation
1355:
1356: PARAMETERS: x_Group_rec IN rlm_dp_sv.t_Group_rec
1357: x_ScheduleType IN VARCHAR2
1358:
1359:
1360: DESIGN REFERENCES: RLADPHLD.rtf
1370:
1371: CHANGE HISTORY: created jhaulund 03/05/99
1372: ===========================================================================*/
1373: PROCEDURE StoreShipments(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1374: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
1375: x_Key_rec IN RLM_RD_SV.t_Key_rec,
1376: x_Quantity IN NUMBER);
1377:
1378: /*===========================================================================
1381:
1382: DESCRIPTION: This procedure will reconcile the shipments withe the new demand
1383: which comes in
1384:
1385: PARAMETERS: x_Group_rec IN rlm_dp_sv.t_Group_rec
1386: x_ScheduleType IN VARCHAR2
1387:
1388:
1389: DESIGN REFERENCES: RLADPHLD.rtf
1398: CLOSED ISSUES:
1399:
1400: CHANGE HISTORY: created jhaulund 03/05/99
1401: ===========================================================================*/
1402: PROCEDURE ReconcileShipments(x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
1403: x_Key_rec IN RLM_RD_SV.t_Key_rec,
1404: x_Quantity IN OUT NOCOPY NUMBER);
1405: --
1406:
1411:
1412: DESCRIPTION: Check to see if the current_rec line matches the shipment info in
1413: reconcile tab
1414:
1415: PARAMETERS: x_Group_rec IN rlm_dp_sv.t_Group_rec
1416: x_ScheduleType IN VARCHAR2
1417:
1418:
1419: DESIGN REFERENCES: RLADPHLD.rtf
1428: CLOSED ISSUES:
1429:
1430: CHANGE HISTORY: created jhaulund 03/05/99
1431: ===========================================================================*/
1432: FUNCTION MatchShipments(x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
1433: x_Current_rec IN RLM_RD_SV.t_Generic_rec,
1434: x_Index OUT NOCOPY NUMBER)
1435: RETURN BOOLEAN;
1436: --
1444: part of the x_consume_tab
1445: If it is part of the consume tab then the line should not
1446: be used for consumption
1447:
1448: PARAMETERS: x_Group_rec IN rlm_dp_sv.t_Group_rec
1449: x_ScheduleType IN VARCHAR2
1450:
1451:
1452: DESIGN REFERENCES: RLADPHLD.rtf
1474:
1475: DESCRIPTION: Updates the process status to x_status for the entire
1476: group passed in with the x_group_rec
1477:
1478: PARAMETERS: x_Group_rec IN rlm_dp_sv.t_Group_rec
1479: x_header_id IN NUMBER,
1480: x_ScheduleHeaderId IN NUMBER,
1481: x_status IN NUMBER
1482:
1496: CHANGE HISTORY: created mnandell 03/05/99
1497: ===========================================================================*/
1498: PROCEDURE UpdateGroupStatus( x_header_id IN NUMBER,
1499: x_ScheduleHeaderId IN NUMBER,
1500: x_Group_rec IN rlm_dp_sv.t_Group_rec,
1501: x_status IN NUMBER,
1502: x_UpdateLevel IN VARCHAR2 DEFAULT 'GROUP');
1503:
1504:
1509:
1510: DESCRIPTION: Checks whether a lines fall within the frozen fence
1511:
1512: PARAMETERS: x_horizon_start_date IN DATE
1513: x_Group_rec IN rlm_dp_sv.t_Group_rec
1514: x_ShipDate IN DATE
1515:
1516: DESIGN REFERENCES: RLADPHLD.rtf
1517: RLADPRDD.rtf
1526:
1527: CHANGE HISTORY: created mnandell 03/05/99
1528: ===========================================================================*/
1529: FUNCTION IsFrozen(x_horizon_start_date IN DATE,
1530: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
1531: x_ShipDate IN DATE)
1532: RETURN BOOLEAN;
1533:
1534: /*===========================================================================
1549: CLOSED ISSUES:
1550:
1551: CHANGE HISTORY: created mnandell 03/05/99
1552: ===========================================================================*/
1553: FUNCTION LockLines (x_Group_rec IN rlm_dp_sv.t_Group_rec,
1554: x_header_id IN NUMBER)
1555: RETURN BOOLEAN;
1556:
1557: /*===========================================================================
1627:
1628: CHANGE HISTORY: created mnandell 12/15/99
1629: ===========================================================================*/
1630: PROCEDURE CheckTolerance(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1631: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
1632: x_Key_rec IN RLM_RD_SV.t_Key_rec,
1633: x_OldQty IN NUMBER,
1634: x_NewQty IN NUMBER);
1635:
1665: ProcessATS it returns null for x_bill_to_ece_locn_code
1666: and x_inter_ship_to_ece_locn_code
1667:
1668: PARAMETERS: x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
1669: x_group_rec IN rlm_dp_sv.t_Group_rec
1670: x_req_rec IN t_generic_rec
1671: x_customer_number OUT NOCOPY VARCHAR2
1672: x_ship_to_ece_locn_code OUT NOCOPY VARCHAR2
1673: x_bill_to_ece_locn_code OUT NOCOPY VARCHAR2
1683:
1684: CHANGE HISTORY: bsadri 01/12/00 created
1685: ===========================================================================*/
1686: PROCEDURE GetTPContext(x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE DEFAULT NULL,
1687: x_group_rec IN rlm_dp_sv.t_Group_rec DEFAULT NULL,
1688: x_req_rec IN rlm_rd_sv.t_generic_rec DEFAULT NULL,
1689: x_customer_number OUT NOCOPY VARCHAR2,
1690: x_ship_to_ece_locn_code OUT NOCOPY VARCHAR2,
1691: x_bill_to_ece_locn_code OUT NOCOPY VARCHAR2,
1703: calculating in-transit quantities.
1704:
1705:
1706: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
1707: x_Group_rec IN rlm_dp_sv.t_Group_rec
1708: x_match_ref IN OUT NOCOPY t_Cursor_ref
1709:
1710: CHANGE HISTORY: rlanka 01/14/02 created
1711: ===========================================================================*/
1709:
1710: CHANGE HISTORY: rlanka 01/14/02 created
1711: ===========================================================================*/
1712: Procedure InitializeMatchRec(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1713: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
1714: x_match_ref IN OUT NOCOPY t_Cursor_ref);
1715:
1716:
1717: /*===========================================================================
1739: matching criteria have already been used for
1740: calculation of intransit shipments
1741:
1742:
1743: PARAMETERS: x_Group_rec IN RLM_DP_SV.t_Group_rec
1744: x_match_rec IN WSH_RLM_INTERFACE.t_optional_match_rec
1745: x_Index OUT NOCOPY NUMBER
1746:
1747: CHANGE HISTORY: rlanka 01/14/02 created
1745: x_Index OUT NOCOPY NUMBER
1746:
1747: CHANGE HISTORY: rlanka 01/14/02 created
1748: ===========================================================================*/
1749: Function AlreadyMatched(x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
1750: x_match_rec IN WSH_RLM_INTERFACE.t_optional_match_rec,
1751: x_Index OUT NOCOPY NUMBER)
1752: RETURN BOOLEAN;
1753:
1757: DESCRIPTION: This function is used to determine if the schedule
1758: in process contains only MRP Forecast Requirement.
1759:
1760: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
1761: x_Group_rec IN rlm_dp_sv.t_Group_rec
1762:
1763: CHANGE HISTORY: jautomo 01/17/02 created
1764: ===========================================================================*/
1765: FUNCTION MRPOnly(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1762:
1763: CHANGE HISTORY: jautomo 01/17/02 created
1764: ===========================================================================*/
1765: FUNCTION MRPOnly(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1766: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)
1767: RETURN BOOLEAN;
1768:
1769:
1770: /*===========================================================================
1790:
1791: DESIGN REFERENCE: intransit.rtf
1792:
1793: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
1794: x_Group_rec IN rlm_dp_sv.t_Group_rec
1795: x_intransit_calc_basis IN VARCHAR2
1796: x_Shipper_rec IN OUT NOCOPY WSH_RLM_INTERFACE.t_shipper_rec
1797: x_Shipment_date IN OUT NOCOPY DATE
1798:
1798:
1799: CHANGE HISTORY: rlanka 01/14/02 created
1800: ===========================================================================*/
1801: Procedure InitializeIntransitParam(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1802: x_Group_rec IN rlm_dp_sv.t_Group_rec,
1803: x_intransit_calc_basis IN VARCHAR2,
1804: x_Shipper_rec IN OUT NOCOPY WSH_RLM_INTERFACE.t_shipper_rec,
1805: x_Shipment_date IN OUT NOCOPY DATE);
1806:
1841: CHANGE HISTORY: created rlanka 10/10/02
1842: ===========================================================================*/
1843: Procedure InitializeBlktGrp(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1844: x_Group_ref IN OUT NOCOPY rlm_rd_sv.t_Cursor_ref,
1845: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec);
1846: --
1847:
1848: /*===========================================================================
1849: FUNCTION NAME: FetchBlktGroup
1850:
1851: DESCRIPTION: This function fetches next group, when blankets are used
1852:
1853: PARAMETERS: x_Group_ref IN OUT NOCOPY t_Cursor_ref
1854: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
1855:
1856: DESIGN REFERENCES: rlmbldld.rtf
1857:
1858: ALGORITHM:
1865:
1866: CHANGE HISTORY: created rlanka 10/11/02
1867: ===========================================================================*/
1868: Function FetchBlktGrp(x_Group_ref IN OUT NOCOPY t_Cursor_ref,
1869: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)
1870: RETURN BOOLEAN;
1871:
1872: /*===========================================================================
1873: PROCEDURE NAME: GetDemand
1889:
1890: CHANGE HISTORY: created jhaulund 03/08/99
1891: ===========================================================================*/
1892: Procedure GetDemand(x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
1893: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec);
1894:
1895:
1896: /*===========================================================================
1897: PROCEDURE NAME: InitializeDemand
1898:
1899: DESCRIPTION: This procedure sets up the demand cursor.
1900:
1901: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
1902: x_Group_rec IN rlm_dp_sv.t_Group_rec
1903: x_Key_rec, IN t_Key_rec
1904: x_Demand_ref IN OUT NOCOPY t_Cursor_ref
1905: x_DemandType IN VARCHAR2
1906:
1916:
1917: CHANGE HISTORY: created jhaulund 03/08/99
1918: ===========================================================================*/
1919: Procedure InitializeDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1920: x_Group_rec In OUT NOCOPY rlm_dp_sv.t_Group_rec,
1921: x_Key_rec IN RLM_RD_SV.t_Key_rec,
1922: x_Demand_ref IN OUT NOCOPY t_Cursor_ref,
1923: x_DemandType IN VARCHAR2);
1924:
1935:
1936: CHANGE HISTORY: created jautomo 01/14/02
1937: ==================================================================================*/
1938: PROCEDURE BuildMatchQuery(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1939: x_Group_Rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
1940: x_Demand_Type IN VARCHAR2,
1941: x_Sql OUT NOCOPY VARCHAR2,
1942: x_Sql1 OUT NOCOPY VARCHAR2,
1943: x_Sql2 OUT NOCOPY VARCHAR2,
1957:
1958: CHANGE HISTORY: created jautomo
1959: ===================================================================================*/
1960: PROCEDURE ReconcileAction(x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1961: x_group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
1962: x_key_rec IN OUT NOCOPY RLM_RD_SV.t_key_rec,
1963: x_line_id_tab IN RLM_RD_SV.t_matching_line,
1964: x_DemandCount IN NUMBER,
1965: x_SumOrderedQty IN NUMBER,
2037: used only when the intransit calculation basis is
2038: Customer CUM and the CUM org level is XXX/All Ship Froms.
2039:
2040: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
2041: x_Group_rec IN OUT rlm_dp_sv.t_Group_rec
2042: x_Cum_rec IN RLM_RD_SV.t_Ship_rec --Bugfix 7007638
2043:
2044: DESIGN REFERENCES:
2045:
2055:
2056: CHANGE HISTORY: created rlanka 06/21/04
2057: ===========================================================================*/
2058: PROCEDURE SourceCUMIntransitQty(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
2059: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
2060: x_Cum_rec IN RLM_RD_SV.t_Ship_rec); --Bugfix 7007638
2061:
2062:
2063:
2069: intransit quantity (Supplier - Customer CUM). This
2070: is called from within SynchronizeShipments.
2071:
2072: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
2073: x_Group_rec IN OUT rlm_dp_sv.t_Group_rec
2074: x_Line_id IN NUMBER --Bugfix 7007638
2075: x_IntransitQty IN NUMBER
2076:
2077: DESIGN REFERENCES:
2090:
2091: CHANGE HISTORY: created rlanka 06/21/04
2092: ===========================================================================*/
2093: PROCEDURE CalculateCUMIntransit(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
2094: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
2095: x_Line_id IN NUMBER, --Bugfix 7007638
2096: x_Intransit OUT NOCOPY NUMBER);
2097:
2098:
2119: FUNCTION NAME: MatchFrozen
2120:
2121: DESCRIPTION: This procedure will match against the reconcile table
2122:
2123: PARAMETERS: x_Group_rec IN rlm_dp_sv.t_Group_rec
2124: x_Index2 IN NUMBER
2125: x_Current_rec IN t_Generic_rec
2126: x_Index OUT NOCOPY NUMBER
2127:
2134: CLOSED ISSUES:
2135:
2136: CHANGE HISTORY: created mnandell 03/28/05
2137: ===========================================================================*/
2138: Function MatchFrozen(x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
2139: x_index2 NUMBER,
2140: x_Current_rec IN t_Generic_rec,
2141: x_Index OUT NOCOPY NUMBER)
2142: RETURN BOOLEAN;
2147: DESCRIPTION: Logs the Aggregate frozen fence message with the net qty
2148: within the frozen fence period.
2149:
2150: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
2151: x_Group_rec IN rlm_dp_sv.t_Group_rec
2152:
2153: DESIGN REFERENCES:
2154: ALGORITHM:
2155:
2161:
2162: CHANGE HISTORY: created mnandell 03/28/05
2163: ===========================================================================*/
2164: Procedure FrozenFenceWarning(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
2165: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec);
2166:
2167: /*===========================================================================
2168: PROCEDURE NAME: GetMatchAttributes
2169:
2170: DESCRIPTION: Get the code Values pair of the matching attributes excluding the request date
2171: Original Customer request Date.
2172:
2173: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
2174: x_Group_rec IN rlm_dp_sv.t_Group_rec
2175: x_frozenTabRec IN t_generic_rec,
2176: x_MatAttrCodeValue OUT NOCOPY VARCHAR2
2177:
2178: DESIGN REFERENCES:
2188: CHANGE HISTORY: created mnandell 03/28/05
2189: ==============================================================================*/
2190:
2191: PROCEDURE GetMatchAttributes(x_sched_rec IN rlm_interface_headers%ROWTYPE,
2192: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
2193: x_frozenTabRec IN t_Generic_rec,
2194: x_MatAttrCodeValue OUT NOCOPY VARCHAR2);
2195:
2196:
2200: PROCEDURE NAME: ProcessReleases
2201:
2202:
2203: PARAMETERS: x_Sched_rec IN rlm_interface_headers%ROWTYPE
2204: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
2205: x_Processed IN OUT NOCOPY VARCHAR2
2206:
2207: DESCRIPTION: This procedure is called from within RecDemand() for
2208: each SF/ST/CI group. For each such group, this procedure
2212: HISTORY: Created rlanka 04/25/2005 (for Bug 4255553)
2213:
2214: =======================================================================*/
2215: PROCEDURE ProcessReleases(x_Sched_rec IN rlm_interface_headers%ROWTYPE,
2216: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
2217: x_Processed IN OUT NOCOPY VARCHAR2);
2218:
2219: /*===========================================================================
2220: PROCEDURE NAME: AssignMatchAttribValues
2244:
2245: PROCEDURE NAME: PopulateReconcileCumRec
2246:
2247: PARAMETERS: x_Sched_rec IN rlm_interface_headers%ROWTYPE
2248: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
2249:
2250: DESCRIPTION: This procedure is called from within SynchronizeShipments() for
2251: each SF/ST/CI group. This procedure retrieves the cumulative
2252: received/shipped quantity for a particular ship-to and item.
2254: HISTORY: Created sunilku 03/19/2008 (for Bug 7007638)
2255:
2256: ============================================================================*/
2257: PROCEDURE PopulateReconcileCumRec(x_Sched_rec IN rlm_interface_headers%ROWTYPE,
2258: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec);
2259:
2260:
2261: /*===========================================================================
2262: FUNCTION NAME: Match_PO_RY_Reconcile
2262: FUNCTION NAME: Match_PO_RY_Reconcile
2263:
2264: DESCRIPTION: This procedure will match against the reconcile table
2265:
2266: PARAMETERS: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec
2267: x_Current_rec IN t_Generic_rec
2268: x_Index OUT NOCOPY NUMBER
2269:
2270: HISTORY: created sunilku 04/03/2008 (for Bug 7007638)
2268: x_Index OUT NOCOPY NUMBER
2269:
2270: HISTORY: created sunilku 04/03/2008 (for Bug 7007638)
2271: ===========================================================================*/
2272: Function Match_PO_RY_Reconcile(x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
2273: x_Current_rec IN t_Generic_rec,
2274: x_Index OUT NOCOPY NUMBER)
2275: RETURN BOOLEAN;
2276: