DBA Data[Home] [Help]

APPS.RLM_MANAGE_DEMAND_SV dependencies on RLM_DP_SV

Line 136: g_Group_rec rlm_dp_sv.t_Group_rec;

132: k_ATTRIBUTE14 CONSTANT VARCHAR2(30) := 'ATTRIBUTE14,8';
133: k_ATTRIBUTE15 CONSTANT VARCHAR2(30) := 'ATTRIBUTE15,9';
134:
135: g_ManageDemand_tab t_MD_tab;
136: g_Group_rec rlm_dp_sv.t_Group_rec;
137: g_LastReceipt_rec t_Ship_rec;
138: g_CUM_rec t_Ship_rec;
139: g_CUM_tab t_Ship_tab; --Bugfix 7007638
140:

Line 173: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,

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: /*===========================================================================
177: PROCEDURE NAME: ManageGroupDemand

Line 199: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,

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: /*===========================================================================
203: PROCEDURE NAME: PopulateLastReceiptRec

Line 225: x_Group_rec IN rlm_dp_sv.t_Group_rec);

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

Line 249: x_Group_rec IN rlm_dp_sv.t_Group_rec,

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

Line 275: x_Group_rec IN rlm_dp_sv.t_Group_rec);

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: /*===========================================================================
279: PROCEDURE NAME: PopulateCUMRec

Line 303: x_Group_rec IN rlm_dp_sv.t_Group_rec );

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

Line 326: PROCEDURE UOMConversion(x_Group_rec IN rlm_dp_sv.t_Group_rec);

322: CLOSED ISSUES:
323:
324: CHANGE HISTORY: jhaulund 8/6/98 created
325: ===========================================================================*/
326: PROCEDURE UOMConversion(x_Group_rec IN rlm_dp_sv.t_Group_rec);
327: --
328:
329: /*===========================================================================
330: PROCEDURE NAME: CUMDiscrepancyCheck

Line 352: x_Group_rec IN rlm_dp_sv.t_Group_rec);

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: /*===========================================================================
356: PROCEDURE NAME: SetOperation

Line 405: x_Group_rec IN rlm_dp_sv.t_Group_rec,

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: );
409: --

Line 433: x_Group_rec IN rlm_dp_sv.t_Group_rec);

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

Line 458: x_Group_rec IN rlm_dp_sv.t_Group_rec,

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

Line 598: PROCEDURE MatchDemand(x_Group_rec IN rlm_dp_sv.t_Group_rec,

594: CLOSED ISSUES:
595:
596: CHANGE HISTORY: mnandell 8/6/98/28 created
597: ===========================================================================*/
598: PROCEDURE MatchDemand(x_Group_rec IN rlm_dp_sv.t_Group_rec,
599: x_Index IN NUMBER,
600: x_AggregateDemand_tab IN OUT NOCOPY t_MD_tab,
601: x_Delete_tab IN OUT NOCOPY t_Number_tab,
602: x_ExcpTab IN OUT NOCOPY t_Match_Tab);

Line 626: PROCEDURE AggregateDemand(x_Group_rec IN rlm_dp_sv.t_Group_rec);

622: CLOSED ISSUES:
623:
624: CHANGE HISTORY: mnandell 8/6/98 created
625: ===========================================================================*/
626: PROCEDURE AggregateDemand(x_Group_rec IN rlm_dp_sv.t_Group_rec);
627:
628: /*===========================================================================
629: PROCEDURE NAME: SortDemand
630:

Line 745: x_Group_rec IN rlm_dp_sv.t_Group_rec);

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

Line 770: x_Group_rec IN rlm_dp_sv.t_Group_rec);

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: /*===========================================================================
773: FUNCTION NAME: FetchGroup
774:

Line 793: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)

789:
790: CHANGE HISTORY: created jhaulund 03/08/99
791: ===========================================================================*/
792: FUNCTION FetchGroup(x_Group_ref IN OUT NOCOPY t_Cursor_ref,
793: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)
794: RETURN BOOLEAN;
795:
796: /*===========================================================================
797: PROCEDURE NAME: CallSetups

Line 818: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec);

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

Line 863: x_GroupRec IN rlm_dp_sv.t_Group_rec)

859:
860: CHANGE HISTORY: created mnandell 03/08/99
861: ===========================================================================*/
862: FUNCTION LockLines (x_headerId IN NUMBER,
863: x_GroupRec IN rlm_dp_sv.t_Group_rec)
864: RETURN BOOLEAN;
865:
866: /*===========================================================================
867: PROCEDURE NAME: UpdateHeaderStatus

Line 915: x_GroupRec IN rlm_dp_sv.t_Group_rec,

911: CHANGE HISTORY: created mnandell 03/08/99
912: ===========================================================================*/
913: PROCEDURE UpdateGroupStatus(x_HeaderId IN NUMBER,
914: x_ScheduleHeaderId IN NUMBER,
915: x_GroupRec IN rlm_dp_sv.t_Group_rec,
916: x_ProcessStatus IN NUMBER ,
917: x_UpdateLevel IN VARCHAR2 DEFAULT 'GROUP');
918:
919: /*===========================================================================

Line 956: x_group_rec IN rlm_dp_sv.t_Group_rec,

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,
960: x_inter_ship_to_ece_locn_code OUT NOCOPY VARCHAR2,

Line 972: x_Group_rec IN rlm_dp_sv.t_Group_rec

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:
976: ALGORITHM:

Line 987: x_Group_rec IN rlm_dp_sv.t_Group_rec)

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

Line 993: x_Group_rec IN rlm_dp_sv.t_Group_rec,

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

Line 1047: x_Group_rec IN rlm_dp_sv.t_Group_rec,

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