DBA Data[Home] [Help]

APPS.RLM_TPA_SV dependencies on RLM_SHIP_DELIVERY_PATTERN_SV

Line 242: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,

238: --
239: --
240: PROCEDURE calc_scheduled_ship_date
241: (
242: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
243: x_QuantityDate OUT NOCOPY rlm_ship_delivery_pattern_sv.t_OutputTable,
244: x_ReturnMessage OUT NOCOPY rlm_ship_delivery_pattern_sv.t_ErrorMsgTable,
245: x_ReturnStatus OUT NOCOPY NUMBER
246: );

Line 243: x_QuantityDate OUT NOCOPY rlm_ship_delivery_pattern_sv.t_OutputTable,

239: --
240: PROCEDURE calc_scheduled_ship_date
241: (
242: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
243: x_QuantityDate OUT NOCOPY rlm_ship_delivery_pattern_sv.t_OutputTable,
244: x_ReturnMessage OUT NOCOPY rlm_ship_delivery_pattern_sv.t_ErrorMsgTable,
245: x_ReturnStatus OUT NOCOPY NUMBER
246: );
247: --

Line 244: x_ReturnMessage OUT NOCOPY rlm_ship_delivery_pattern_sv.t_ErrorMsgTable,

240: PROCEDURE calc_scheduled_ship_date
241: (
242: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
243: x_QuantityDate OUT NOCOPY rlm_ship_delivery_pattern_sv.t_OutputTable,
244: x_ReturnMessage OUT NOCOPY rlm_ship_delivery_pattern_sv.t_ErrorMsgTable,
245: x_ReturnStatus OUT NOCOPY NUMBER
246: );
247: --
248: --

Line 415: x_Input IN rlm_ship_delivery_pattern_sv.t_inputRec,

411: --
412: --
413: PROCEDURE determine_send_date
414: (
415: x_Input IN rlm_ship_delivery_pattern_sv.t_inputRec,
416: x_DailyPercent IN rlm_core_sv.t_NumberTable,
417: x_ShipmentDate IN OUT NOCOPY DATE
418: );
419: --

Line 423: x_Input IN rlm_ship_delivery_pattern_sv.t_inputRec,

419: --
420: --
421: FUNCTION check_send_date
422: (
423: x_Input IN rlm_ship_delivery_pattern_sv.t_inputRec,
424: x_ShipmentDate IN DATE
425: )
426: RETURN BOOLEAN;
427: --

Line 431: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,

427: --
428: --
429: PROCEDURE determine_receive_date
430: (
431: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
432: x_DailyPercent IN rlm_core_sv.t_NumberTable,
433: x_ReceiveDate IN OUT NOCOPY DATE
434: );
435: --

Line 439: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,

435: --
436: --
437: FUNCTION check_receive_date
438: (
439: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
440: x_ReceiveDate IN DATE
441: )
442: RETURN BOOLEAN;
443: --

Line 447: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,

443: --
444: --
445: FUNCTION previous_valid_sdp_date
446: (
447: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
448: x_Date IN DATE,
449: x_DailyPercent IN rlm_core_sv.t_NumberTable
450: )
451: RETURN DATE;

Line 456: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,

452: --
453: --
454: FUNCTION valid_sdp_date
455: (
456: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
457: x_DailyPercent IN rlm_core_sv.t_NumberTable
458: )
459: RETURN BOOLEAN;
460: --

Line 464: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,

460: --
461: --
462: FUNCTION find_monday_date
463: (
464: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
465: x_Date IN DATE
466: )
467: RETURN DATE;
468: --

Line 472: x_Input IN rlm_ship_delivery_pattern_sv.t_Inputrec,

468: --
469: --
470: FUNCTION check_start_date
471: (
472: x_Input IN rlm_ship_delivery_pattern_sv.t_Inputrec,
473: x_BucketType IN VARCHAR2
474: )
475: RETURN BOOLEAN;
476: --

Line 480: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,

476: --
477: --
478: PROCEDURE apply_sdp_to_daily_bucket
479: (
480: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
481: x_ItemDetailSubtype IN VARCHAR2,
482: x_DailyPercent IN rlm_core_sv.t_NumberTable,
483: x_StartDateTime IN DATE,
484: x_PrimaryQuantity IN NUMBER,

Line 485: x_QuantityDate IN OUT NOCOPY rlm_ship_delivery_pattern_sv.t_OutputTable

481: x_ItemDetailSubtype IN VARCHAR2,
482: x_DailyPercent IN rlm_core_sv.t_NumberTable,
483: x_StartDateTime IN DATE,
484: x_PrimaryQuantity IN NUMBER,
485: x_QuantityDate IN OUT NOCOPY rlm_ship_delivery_pattern_sv.t_OutputTable
486: );
487: --
488: --
489: PROCEDURE apply_sdp_to_weekly_bucket

Line 491: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,

487: --
488: --
489: PROCEDURE apply_sdp_to_weekly_bucket
490: (
491: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
492: x_ItemDetailSubtype IN VARCHAR2,
493: x_DailyPercent IN rlm_core_sv.t_NumberTable,
494: x_StartDateTime IN DATE,
495: x_PrimaryQuantity IN NUMBER,

Line 497: x_QuantityDate IN OUT NOCOPY RLM_SHIP_DELIVERY_PATTERN_SV.t_OutputTable

493: x_DailyPercent IN rlm_core_sv.t_NumberTable,
494: x_StartDateTime IN DATE,
495: x_PrimaryQuantity IN NUMBER,
496: x_WholeNumber IN BOOLEAN,
497: x_QuantityDate IN OUT NOCOPY RLM_SHIP_DELIVERY_PATTERN_SV.t_OutputTable
498: );
499: --
500: --
501: FUNCTION get_weekly_quantity

Line 505: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,

501: FUNCTION get_weekly_quantity
502: (
503: x_WholeNumber IN BOOLEAN,
504: x_Count IN NUMBER,
505: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
506: x_DivideBy IN NUMBER
507: )
508: RETURN NUMBER;
509: --

Line 513: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,

509: --
510: --
511: PROCEDURE break_bucket
512: (
513: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
514: x_ReturnMessage IN OUT NOCOPY rlm_ship_delivery_pattern_sv.t_ErrorMsgTable,
515: x_WeeklyBucket OUT NOCOPY rlm_ship_delivery_pattern_sv.t_BucketTable,
516: x_ReturnStatus OUT NOCOPY NUMBER
517: );

Line 514: x_ReturnMessage IN OUT NOCOPY rlm_ship_delivery_pattern_sv.t_ErrorMsgTable,

510: --
511: PROCEDURE break_bucket
512: (
513: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
514: x_ReturnMessage IN OUT NOCOPY rlm_ship_delivery_pattern_sv.t_ErrorMsgTable,
515: x_WeeklyBucket OUT NOCOPY rlm_ship_delivery_pattern_sv.t_BucketTable,
516: x_ReturnStatus OUT NOCOPY NUMBER
517: );
518: --

Line 515: x_WeeklyBucket OUT NOCOPY rlm_ship_delivery_pattern_sv.t_BucketTable,

511: PROCEDURE break_bucket
512: (
513: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
514: x_ReturnMessage IN OUT NOCOPY rlm_ship_delivery_pattern_sv.t_ErrorMsgTable,
515: x_WeeklyBucket OUT NOCOPY rlm_ship_delivery_pattern_sv.t_BucketTable,
516: x_ReturnStatus OUT NOCOPY NUMBER
517: );
518: --
519: --