eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RLM_RD_SV dependencies on RLM_INTERFACE_HEADERS

Line 49: schedule_type rlm_interface_headers.schedule_type%TYPE,

45: schedule_item_number NUMBER,
46: ship_from_org_id rlm_interface_lines.ship_from_org_id%TYPE,
47: ship_to_address_id NUMBER,
48: ship_to_org_id NUMBER,
49: schedule_type rlm_interface_headers.schedule_type%TYPE,
50: price_list_id rlm_interface_lines.price_list_id%TYPE,
51: agreement_id rlm_interface_lines.agreement_id%TYPE,
52: item_detail_type rlm_interface_lines.item_detail_type%TYPE,
53: item_detail_subtype rlm_interface_lines.item_detail_subtype%TYPE,

Line 407: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

403:
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: /*============================================================================

Line 417: PROCEDURE RecGroupDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

413: PROCEDURE NAME: RecGroupDemand
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: /*===========================================================================

Line 427: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

423:
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:

Line 442: Procedure CallSetups(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

438: CLOSED ISSUES:
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: /*===========================================================================

Line 452: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

448:
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:

Line 467: Procedure ExecOperations(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

463: CLOSED ISSUES:
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: /*===========================================================================

Line 477: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

473:
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:

Line 492: Procedure CancelPreHorizonNATS(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

488: CLOSED ISSUES:
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: /*===========================================================================

Line 503: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

499: DESCRIPTION: This procedure fetches information about supplier shipments
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:

Line 518: Procedure SynchronizeShipments(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

514: CLOSED ISSUES:
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:

Line 528: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

524: PROCEDURE NAME: ProcessPreHorizonATS
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:

Line 543: Procedure ProcessPreHorizonATS(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

539: CLOSED ISSUES:
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:

Line 554: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

550:
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:

Line 569: Procedure ProcessNATS(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

565: CLOSED ISSUES:
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:

Line 579: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

575: PROCEDURE NAME: ProcessATS
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:

Line 594: Procedure ProcessATS(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

590: CLOSED ISSUES:
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:

Line 681: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

677: PROCEDURE NAME: DeleteRequirement
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

Line 699: Procedure DeleteRequirement(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

695: CLOSED ISSUES:
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);

Line 712: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

708: PROCEDURE NAME: UpdateRequirement
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:

Line 729: Procedure UpdateRequirement(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

725: CLOSED ISSUES:
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:

Line 741: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

737: PROCEDURE NAME: InsertRequirement
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

Line 759: Procedure InsertRequirement(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

755: CLOSED ISSUES:
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);

Line 791: Procedure UpdateDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

787: CLOSED ISSUES:
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);

Line 822: Procedure IncreaseDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

818: CLOSED ISSUES:
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);

Line 852: Procedure DeleteDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

848: CLOSED ISSUES:
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: --

Line 882: Procedure DecreaseDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

878: CLOSED ISSUES:
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);

Line 913: Procedure OtherDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

909: CLOSED ISSUES:
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: --

Line 924: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

920: PROCEDURE NAME: CancelRequirement
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:

Line 941: Procedure CancelRequirement(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

937: CLOSED ISSUES:
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:

Line 1081: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

1077:
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:

Line 1098: Procedure StoreReconcile(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

1094: CLOSED ISSUES:
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:

Line 1138: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

1134:
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:

Line 1153: Procedure ProcessOld(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

1149: CLOSED ISSUES:
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:

Line 1165: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

1161:
1162: DESCRIPTION: This procedure sets up the group cursor, when blankets
1163: are not used
1164:
1165: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
1166: x_Group_ref IN OUT NOCOPY t_Cursor_ref
1167:
1168: DESIGN REFERENCES: RLADPRDD.rtf
1169:

Line 1180: Procedure InitializeSoGroup(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

1176: CLOSED ISSUES:
1177:
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

Line 1191: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

1187:
1188: DESCRIPTION: This procedure checks for irreconcileable differences and
1189: attempts to reconcile or generates exceptions.
1190:
1191: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
1192: x_Group_ref IN OUT NOCOPY t_Cursor_ref
1193:
1194: DESIGN REFERENCES: RLADPRDD.rtf
1195:

Line 1206: Procedure CheckRec(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

1202: CLOSED ISSUES:
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:

Line 1216: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

1212: PROCEDURE NAME: InitializeReq
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:

Line 1233: Procedure InitializeReq(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

1229: CLOSED ISSUES:
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:

Line 1344: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

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:
1348: /*===========================================================================

Line 1373: PROCEDURE StoreShipments(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

1369: CLOSED ISSUES:
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:

Line 1630: PROCEDURE CheckTolerance(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

1626: CLOSED ISSUES:
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);

Line 1668: PARAMETERS: x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

1664: ProcessPreHorizonATS, ProcessNATS, and
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

Line 1686: PROCEDURE GetTPContext(x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE DEFAULT NULL,

1682: CLOSED ISSUES:
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,

Line 1706: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

1702: which optional matching attributes to use when
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

Line 1712: Procedure InitializeMatchRec(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

1708: x_match_ref IN OUT NOCOPY t_Cursor_ref
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:

Line 1760: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

1756:
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: ===========================================================================*/

Line 1765: FUNCTION MRPOnly(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,
1766: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)
1767: RETURN BOOLEAN;
1768:
1769:

Line 1793: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

1789: Shipping API to determine in-transit quantities.
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

Line 1801: Procedure InitializeIntransitParam(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

1797: x_Shipment_date IN OUT NOCOPY DATE
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);

Line 1828: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

1824:
1825: DESCRIPTION: This procedure sets up the group cursor, when blankets
1826: are used.
1827:
1828: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
1829: x_Group_ref IN OUT NOCOPY t_Cursor_ref
1830:
1831: DESIGN REFERENCES: rlmbldld.rtf
1832:

Line 1843: Procedure InitializeBlktGrp(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

1839: CLOSED ISSUES:
1840:
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:

Line 1901: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

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

Line 1919: Procedure InitializeDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

1915: CLOSED ISSUES:
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);

Line 1938: PROCEDURE BuildMatchQuery(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

1934: DESIGN REFERENCES: RLADPRDD.rtf
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,

Line 1960: PROCEDURE ReconcileAction(x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

1956: DESIGN REFERENCES: RLADPRDD.rtf
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,

Line 2040: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

2036: intransit quantity (Supplier CUM - Customer CUM) and is
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:

Line 2058: PROCEDURE SourceCUMIntransitQty(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

2054: CLOSED ISSUES:
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:

Line 2072: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

2068: in order to calculate the supplier CUM and hence the
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:

Line 2093: PROCEDURE CalculateCUMIntransit(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

2089: CLOSED ISSUES:
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:

Line 2150: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

2146:
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:

Line 2164: Procedure FrozenFenceWarning(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

2160: CLOSED ISSUES:
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

Line 2173: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

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:

Line 2191: PROCEDURE GetMatchAttributes(x_sched_rec IN rlm_interface_headers%ROWTYPE,

2187:
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:

Line 2203: PARAMETERS: x_Sched_rec IN rlm_interface_headers%ROWTYPE

2199:
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

Line 2215: PROCEDURE ProcessReleases(x_Sched_rec IN rlm_interface_headers%ROWTYPE,

2211:
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: /*===========================================================================

Line 2247: PARAMETERS: x_Sched_rec IN rlm_interface_headers%ROWTYPE

2243: /*============================================================================
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

Line 2257: PROCEDURE PopulateReconcileCumRec(x_Sched_rec IN rlm_interface_headers%ROWTYPE,

2253:
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: /*===========================================================================