DBA Data[Home] [Help]

APPS.RLM_SHIP_DELIVERY_PATTERN_SV dependencies on RLM_CORE_SV

Line 104: g_SDEBUG NUMBER :=rlm_core_sv.C_LEVEL5;

100: INDEX BY BINARY_INTEGER;
101: TYPE t_ErrorMsgTable IS TABLE OF t_ErrorMsgRec
102: INDEX BY BINARY_INTEGER;
103:
104: g_SDEBUG NUMBER :=rlm_core_sv.C_LEVEL5;
105: g_DEBUG NUMBER :=rlm_core_sv.C_LEVEL6;
106: g_PRECISION CONSTANT NUMBER :=2;
107: g_DAY CONSTANT VARCHAR2(10) := '1';
108: g_WEEK CONSTANT VARCHAR2(10) := '2';

Line 105: g_DEBUG NUMBER :=rlm_core_sv.C_LEVEL6;

101: TYPE t_ErrorMsgTable IS TABLE OF t_ErrorMsgRec
102: INDEX BY BINARY_INTEGER;
103:
104: g_SDEBUG NUMBER :=rlm_core_sv.C_LEVEL5;
105: g_DEBUG NUMBER :=rlm_core_sv.C_LEVEL6;
106: g_PRECISION CONSTANT NUMBER :=2;
107: g_DAY CONSTANT VARCHAR2(10) := '1';
108: g_WEEK CONSTANT VARCHAR2(10) := '2';
109: g_FLEXIBLE CONSTANT VARCHAR2(10) := '3';

Line 265: RETURN rlm_core_sv.t_NumberTable;

261:
262: CHANGE HISTORY: amitra 7/14/98 created
263: ===========================================================================*/
264: FUNCTION find_daily_percent(x_RuleName IN VARCHAR2)
265: RETURN rlm_core_sv.t_NumberTable;
266:
267:
268: /*===========================================================================
269: PROCEDURE NAME: break_bucket

Line 355: x_DailyPercent IN rlm_core_sv.t_NumberTable

351: DESCRIPTION: This procedure applies the Ship Delivery Pattern to daily
352: buckets.
353:
354: PARAMETERS: x_Input IN t_InputRec
355: x_DailyPercent IN rlm_core_sv.t_NumberTable
356: x_ItemDetailSubtype IN VARCHAR2
357: x_StartDateTime IN DATE
358: x_PrimaryQuantity IN NUMBER
359: x_WholeNumber IN BOOLEAN

Line 377: x_DailyPercent IN rlm_core_sv.t_NumberTable,

373: ===========================================================================*/
374: PROCEDURE apply_sdp_to_weekly_bucket(
375: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
376: x_ItemDetailSubtype IN VARCHAR2,
377: x_DailyPercent IN rlm_core_sv.t_NumberTable,
378: x_StartDateTime IN DATE,
379: x_PrimaryQuantity IN NUMBER,
380: x_WholeNumber IN BOOLEAN,
381: x_QuantityDate IN OUT NOCOPY RLM_SHIP_DELIVERY_PATTERN_SV.t_OutputTable);

Line 392: x_DailyPercent IN rlm_core_sv.t_NumberTable

388: buckets.
389:
390: PARAMETERS: x_Input IN t_InputRec
391: x_ItemDetailSubtype IN VARCHAR2
392: x_DailyPercent IN rlm_core_sv.t_NumberTable
393: x_StartDateTime IN DATE
394: x_PrimaryQuantity IN NUMBER
395: x_QuantityDate IN OUT NOCOPY t_OutputTable
396:

Line 412: x_DailyPercent IN rlm_core_sv.t_NumberTable,

408: ===========================================================================*/
409: PROCEDURE apply_sdp_to_daily_bucket(
410: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
411: x_ItemDetailSubtype IN VARCHAR2,
412: x_DailyPercent IN rlm_core_sv.t_NumberTable,
413: x_StartDateTime IN DATE,
414: x_PrimaryQuantity IN NUMBER,
415: x_QuantityDate IN OUT NOCOPY rlm_ship_delivery_pattern_sv.t_OutputTable);
416: --

Line 478: x_DailyPercent IN rlm_core_sv.t_NumberTable

474: for given date.
475:
476: PARAMETERS: x_Input IN t_InputRec
477: x_Date IN DATE
478: x_DailyPercent IN rlm_core_sv.t_NumberTable
479:
480: DESIGN REFERENCES: rladsdpc.rtf
481:
482: ALGORITHM:

Line 493: x_DailyPercent IN rlm_core_sv.t_NumberTable)

489:
490: CHANGE HISTORY: amitra 7/15/98 created
491: ===========================================================================*/
492: FUNCTION valid_sdp_date(x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
493: x_DailyPercent IN rlm_core_sv.t_NumberTable)
494: RETURN BOOLEAN;
495: --
496: /*===========================================================================
497: FUNCTION NAME: previous_valid_sdp_date

Line 504: x_DailyPercent IN rlm_core_sv.t_NumberTable

500: with a daily percent.
501:
502: PARAMETERS: x_Input IN t_InputRec
503: x_Date IN DATE
504: x_DailyPercent IN rlm_core_sv.t_NumberTable
505:
506: DESIGN REFERENCES: rladsdpc.rtf
507:
508: ALGORITHM:

Line 521: x_DailyPercent IN rlm_core_sv.t_NumberTable)

517: ===========================================================================*/
518: FUNCTION previous_valid_sdp_date(
519: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
520: x_Date IN DATE,
521: x_DailyPercent IN rlm_core_sv.t_NumberTable)
522: RETURN DATE;
523: --
524: /*===========================================================================
525: FUNCTION NAME: get_ship_method

Line 611: x_DailyPercent IN rlm_core_sv.t_NumberTable

607:
608: DESCRIPTION: This calls procedure to deterine previous valid receiving date.
609:
610: PARAMETERS: x_Input IN t_InputRec
611: x_DailyPercent IN rlm_core_sv.t_NumberTable
612: x_ReceiveDate IN OUT DATE
613:
614: DESIGN REFERENCES: rladsdpc.rtf
615:

Line 628: x_DailyPercent IN rlm_core_sv.t_NumberTable,

624: CHANGE HISTORY: amitra 7/20/98 created
625: ===========================================================================*/
626: PROCEDURE determine_receive_date(
627: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
628: x_DailyPercent IN rlm_core_sv.t_NumberTable,
629: x_ReceiveDate IN OUT NOCOPY DATE);
630: --
631:
632: /*===========================================================================

Line 704: x_DailyPercent IN rlm_core_sv.t_NumberTable,

700:
701: CHANGE HISTORY: amitra 7/20/98 created
702: ===========================================================================*/
703: PROCEDURE determine_send_date(x_Input IN rlm_ship_delivery_pattern_sv.t_inputRec,
704: x_DailyPercent IN rlm_core_sv.t_NumberTable,
705: x_ShipmentDate IN OUT NOCOPY DATE );
706: --
707:
708: /*=============================================================================