168:
169: CHANGE HISTORY: mnandell 8/6/98 created
170: ===========================================================================*/
171: PROCEDURE ManageDemand(x_InterfaceHeaderId IN NUMBER,
172: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
173: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
174: x_ReturnStatus OUT NOCOPY NUMBER);
175:
176: /*===========================================================================
194: CLOSED ISSUES:
195:
196: CHANGE HISTORY: mnandell 8/6/98 created
197: ===========================================================================*/
198: PROCEDURE ManageGroupDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
199: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
200: x_ReturnStatus OUT NOCOPY NUMBER);
201:
202: /*===========================================================================
220: CLOSED ISSUES:
221:
222: CHANGE HISTORY: jhaulund 8/6/98 created
223: ===========================================================================*/
224: PROCEDURE PopulateLastReceiptRec(x_Sched_rec IN rlm_interface_headers%ROWTYPE,
225: x_Group_rec IN rlm_dp_sv.t_Group_rec);
226:
227: /*===========================================================================
228: PROCEDURE NAME: PopulateMD
244: CLOSED ISSUES:
245:
246: CHANGE HISTORY: jhaulund 8/6/98 created
247: ===========================================================================*/
248: PROCEDURE PopulateMD(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
249: x_Group_rec IN rlm_dp_sv.t_Group_rec,
250: x_IncludeCUM IN VARCHAR2 DEFAULT 'N');
251:
252:
270: CLOSED ISSUES:
271:
272: CHANGE HISTORY: jhaulund 8/6/98 created
273: ===========================================================================*/
274: PROCEDURE CUMToDiscrete(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
275: x_Group_rec IN rlm_dp_sv.t_Group_rec);
276: --
277:
278: /*===========================================================================
298: CLOSED ISSUES:
299:
300: CHANGE HISTORY: jhaulund 8/6/98 created
301: ===========================================================================*/
302: PROCEDURE PopulateCUMRec(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
303: x_Group_rec IN rlm_dp_sv.t_Group_rec );
304:
305: /*===========================================================================
306: PROCEDURE NAME: UOMConversion
347: CLOSED ISSUES:
348:
349: CHANGE HISTORY: jhaulund 8/6/98 created
350: ===========================================================================*/
351: PROCEDURE CUMDiscrepancyCheck( x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
352: x_Group_rec IN rlm_dp_sv.t_Group_rec);
353: --
354:
355: /*===========================================================================
400: CLOSED ISSUES:
401:
402: CHANGE HISTORY: jhaulund 8/6/98 created
403: ===========================================================================*/
404: PROCEDURE ApplySourceRules(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
405: x_Group_rec IN rlm_dp_sv.t_Group_rec,
406: x_SourcedDemand_tab OUT NOCOPY rlm_manage_demand_sv.t_MD_Tab,
407: x_Source_Tab OUT NOCOPY rlm_manage_demand_sv.t_Source_Tab
408: );
428: CLOSED ISSUES:
429:
430: CHANGE HISTORY: jhaulund 8/6/98 created
431: ===========================================================================*/
432: PROCEDURE CalculateShipDate( x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
433: x_Group_rec IN rlm_dp_sv.t_Group_rec);
434: --
435:
436: /*===========================================================================
437: PROCEDURE NAME: ApplyFFFFences
438:
439: DESCRIPTION: Applys the applicable fence days to incoming demand.
440:
441: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
442: x_Group_rec IN t_Group_rec
443: IsLineProcessed IN OUT NOCOPY BOOLEAN
444:
445: DESIGN REFERENCES: rlmdpmdd.rtf
453: CLOSED ISSUES:
454:
455: CHANGE HISTORY: mnandell 8/6/98 created
456: ===========================================================================*/
457: PROCEDURE ApplyFFFFences(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
458: x_Group_rec IN rlm_dp_sv.t_Group_rec,
459: IsLineProcessed IN OUT NOCOPY BOOLEAN );
460: --
461:
740: CLOSED ISSUES:
741:
742: CHANGE HISTORY: mnandell 8/6/99 created
743: ===========================================================================*/
744: PROCEDURE RoundStandardPack(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
745: x_Group_rec IN rlm_dp_sv.t_Group_rec);
746: --
747: /*===========================================================================
748: PROCEDURE NAME: InitializeMdGroup
748: PROCEDURE NAME: InitializeMdGroup
749:
750: DESCRIPTION: This procedure sets up the group cursor.
751:
752: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
753: x_Group_ref IN OUT NOCOPY t_Cursor_ref
754:
755: DESIGN REFERENCES: RLADPRDD.rtf
756:
764:
765: CHANGE HISTORY: created jhaulund 03/08/99
766: ===========================================================================*/
767: --Bugfix 6084578 changed procedure name
768: Procedure InitializeMdGroup(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
769: x_Group_ref IN OUT NOCOPY rlm_manage_demand_sv.t_Cursor_ref,
770: x_Group_rec IN rlm_dp_sv.t_Group_rec);
771: --
772: /*===========================================================================
798:
799: DESCRIPTION: This procedure calls rla setups to populate group record
800: with setup informations.
801:
802: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
803: x_Group_rec IN t_Group_rec
804:
805: DESIGN REFERENCES: RLADPRDD.rtf
806:
813: CLOSED ISSUES:
814:
815: CHANGE HISTORY: created mnandell 03/08/99
816: ===========================================================================*/
817: Procedure CallSetups(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
818: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec);
819:
820: /*===========================================================================
821: PROCEDURE NAME: LockHeader
819:
820: /*===========================================================================
821: PROCEDURE NAME: LockHeader
822:
823: DESCRIPTION: This procedure locks the header in RLM_INTERFACE_HEADERS
824:
825: PARAMETERS: x_HeaderId IN NUMBER
826:
827: DESIGN REFERENCES: RLADPRDD.rtf
941: PROCEDURE NAME: GetTPContext
942: DESCRIPTION: This procedure returns the tp group context.
943: This procedure returns a null x_ship_to_ece_locn_code,
944: and null x_inter_ship_to_ece_locn_code
945: PARAMETERS: x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
946: x_group_rec IN t_Group_rec
947: x_customer_number OUT NOCOPY VARCHAR2
948: x_ship_to_ece_locn_code OUT NOCOPY VARCHAR2
949: x_bill_to_ece_locn_code OUT NOCOPY VARCHAR2
951: x_tp_group_code OUT NOCOPY VARCHAR2
952: DESIGN REFERENCES: RLMDPRDD.rtf
953: CHANGE HISTORY: created mnandell 03/08/99
954: ===========================================================================*/
955: PROCEDURE GetTPContext( x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
956: x_group_rec IN rlm_dp_sv.t_Group_rec,
957: x_customer_number OUT NOCOPY VARCHAR2,
958: x_ship_to_ece_locn_code OUT NOCOPY VARCHAR2,
959: x_bill_to_ece_locn_code OUT NOCOPY VARCHAR2,
967: DESCRIPTION: This procedure fetches information about supplier shipments
968: which took place after the last customer recognized shipment
969: to ship for the current schedule item
970:
971: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
972: x_Group_rec IN rlm_dp_sv.t_Group_rec
973:
974: DESIGN REFERENCES: RLADPRDD.rtf
975:
982: CLOSED ISSUES:
983:
984: CHANGE HISTORY: created kvenkate 01/16/01
985: ===========================================================================*/
986: FUNCTION CalculateIntransitQty(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
987: x_Group_rec IN rlm_dp_sv.t_Group_rec)
988: RETURN NUMBER;
989: --
990:
988: RETURN NUMBER;
989: --
990:
991:
992: FUNCTION GetAllIntransitQty(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
993: x_Group_rec IN rlm_dp_sv.t_Group_rec,
994: x_Source_Tab IN rlm_manage_demand_sv.t_Source_Tab)
995: RETURN NUMBER;
996: --
1042: x_customerItem IN VARCHAR2);
1043:
1044:
1045:
1046: FUNCTION GetIntransitAcrossOrgs(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1047: x_Group_rec IN rlm_dp_sv.t_Group_rec,
1048: x_cum_key_id IN NUMBER)
1049: RETURN NUMBER;
1050: --