[Home] [Help]
1379: --
1380: --
1381: PROCEDURE calc_scheduled_ship_date
1382: (
1383: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
1384: x_QuantityDate OUT NOCOPY rlm_ship_delivery_pattern_sv.t_OutputTable,
1385: x_ReturnMessage OUT NOCOPY rlm_ship_delivery_pattern_sv.t_ErrorMsgTable,
1386: x_ReturnStatus OUT NOCOPY NUMBER
1387: )
1380: --
1381: PROCEDURE calc_scheduled_ship_date
1382: (
1383: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
1384: x_QuantityDate OUT NOCOPY rlm_ship_delivery_pattern_sv.t_OutputTable,
1385: x_ReturnMessage OUT NOCOPY rlm_ship_delivery_pattern_sv.t_ErrorMsgTable,
1386: x_ReturnStatus OUT NOCOPY NUMBER
1387: )
1388: IS
1381: PROCEDURE calc_scheduled_ship_date
1382: (
1383: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
1384: x_QuantityDate OUT NOCOPY rlm_ship_delivery_pattern_sv.t_OutputTable,
1385: x_ReturnMessage OUT NOCOPY rlm_ship_delivery_pattern_sv.t_ErrorMsgTable,
1386: x_ReturnStatus OUT NOCOPY NUMBER
1387: )
1388: IS
1389: --{
1408: BEGIN
1409: --{
1410: --
1411: --
1412: RLM_SHIP_DELIVERY_PATTERN_SV.calc_scheduled_ship_date
1413: (
1414: x_Input => x_Input,
1415: x_QuantityDate => x_QuantityDate,
1416: x_ReturnMessage => x_ReturnMessage,
2368: --
2369: --
2370: PROCEDURE determine_send_date
2371: (
2372: x_Input IN rlm_ship_delivery_pattern_sv.t_inputRec,
2373: x_DailyPercent IN rlm_core_sv.t_NumberTable,
2374: x_ShipmentDate IN OUT NOCOPY DATE
2375: )
2376: IS
2396: BEGIN
2397: --{
2398: --
2399: --
2400: RLM_SHIP_DELIVERY_PATTERN_SV.determine_send_date
2401: (
2402: x_Input => x_Input,
2403: x_DailyPercent => x_DailyPercent,
2404: x_ShipmentDate => x_ShipmentDate
2420: --
2421: --
2422: FUNCTION check_send_date
2423: (
2424: x_Input IN rlm_ship_delivery_pattern_sv.t_inputRec,
2425: x_ShipmentDate IN DATE
2426: )
2427: RETURN BOOLEAN
2428: IS
2450: BEGIN
2451: --{
2452: --
2453: --
2454: l_return_value := RLM_SHIP_DELIVERY_PATTERN_SV.check_send_date
2455: (
2456: x_Input => x_Input,
2457: x_ShipmentDate => x_ShipmentDate
2458: )
2476: --
2477: --
2478: PROCEDURE determine_receive_date
2479: (
2480: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
2481: x_DailyPercent IN rlm_core_sv.t_NumberTable,
2482: x_ReceiveDate IN OUT NOCOPY DATE
2483: )
2484: IS
2504: BEGIN
2505: --{
2506: --
2507: --
2508: RLM_SHIP_DELIVERY_PATTERN_SV.determine_receive_date
2509: (
2510: x_Input => x_Input,
2511: x_DailyPercent => x_DailyPercent,
2512: x_ReceiveDate => x_ReceiveDate
2528: --
2529: --
2530: FUNCTION check_receive_date
2531: (
2532: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
2533: x_ReceiveDate IN DATE
2534: )
2535: RETURN BOOLEAN
2536: IS
2558: BEGIN
2559: --{
2560: --
2561: --
2562: l_return_value := RLM_SHIP_DELIVERY_PATTERN_SV.check_receive_date
2563: (
2564: x_Input => x_Input,
2565: x_ReceiveDate => x_ReceiveDate
2566: )
2584: --
2585: --
2586: FUNCTION previous_valid_sdp_date
2587: (
2588: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
2589: x_Date IN DATE,
2590: x_DailyPercent IN rlm_core_sv.t_NumberTable
2591: )
2592: RETURN DATE
2615: BEGIN
2616: --{
2617: --
2618: --
2619: l_return_value := RLM_SHIP_DELIVERY_PATTERN_SV.previous_valid_sdp_date
2620: (
2621: x_Input => x_Input,
2622: x_Date => x_Date,
2623: x_DailyPercent => x_DailyPercent
2642: --
2643: --
2644: FUNCTION valid_sdp_date
2645: (
2646: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
2647: x_DailyPercent IN rlm_core_sv.t_NumberTable
2648: )
2649: RETURN BOOLEAN
2650: IS
2672: BEGIN
2673: --{
2674: --
2675: --
2676: l_return_value := RLM_SHIP_DELIVERY_PATTERN_SV.valid_sdp_date
2677: (
2678: x_Input => x_Input,
2679: x_DailyPercent => x_DailyPercent
2680: )
2698: --
2699: --
2700: FUNCTION find_monday_date
2701: (
2702: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
2703: x_Date IN DATE
2704: )
2705: RETURN DATE
2706: IS
2728: BEGIN
2729: --{
2730: --
2731: --
2732: l_return_value := RLM_SHIP_DELIVERY_PATTERN_SV.find_monday_date
2733: (
2734: x_Input => x_Input,
2735: x_Date => x_Date
2736: )
2754: --
2755: --
2756: FUNCTION check_start_date
2757: (
2758: x_Input IN rlm_ship_delivery_pattern_sv.t_Inputrec,
2759: x_BucketType IN VARCHAR2
2760: )
2761: RETURN BOOLEAN
2762: IS
2784: BEGIN
2785: --{
2786: --
2787: --
2788: l_return_value := RLM_SHIP_DELIVERY_PATTERN_SV.check_start_date
2789: (
2790: x_Input => x_Input,
2791: x_BucketType => x_BucketType
2792: )
2810: --
2811: --
2812: PROCEDURE apply_sdp_to_daily_bucket
2813: (
2814: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
2815: x_ItemDetailSubtype IN VARCHAR2,
2816: x_DailyPercent IN rlm_core_sv.t_NumberTable,
2817: x_StartDateTime IN DATE,
2818: x_PrimaryQuantity IN NUMBER,
2815: x_ItemDetailSubtype IN VARCHAR2,
2816: x_DailyPercent IN rlm_core_sv.t_NumberTable,
2817: x_StartDateTime IN DATE,
2818: x_PrimaryQuantity IN NUMBER,
2819: x_QuantityDate IN OUT NOCOPY rlm_ship_delivery_pattern_sv.t_OutputTable
2820: )
2821: IS
2822: --{
2823: --
2841: BEGIN
2842: --{
2843: --
2844: --
2845: RLM_SHIP_DELIVERY_PATTERN_SV.apply_sdp_to_daily_bucket
2846: (
2847: x_Input => x_Input,
2848: x_ItemDetailSubtype => x_ItemDetailSubtype,
2849: x_DailyPercent => x_DailyPercent,
2868: --
2869: --
2870: PROCEDURE apply_sdp_to_weekly_bucket
2871: (
2872: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
2873: x_ItemDetailSubtype IN VARCHAR2,
2874: x_DailyPercent IN rlm_core_sv.t_NumberTable,
2875: x_StartDateTime IN DATE,
2876: x_PrimaryQuantity IN NUMBER,
2874: x_DailyPercent IN rlm_core_sv.t_NumberTable,
2875: x_StartDateTime IN DATE,
2876: x_PrimaryQuantity IN NUMBER,
2877: x_WholeNumber IN BOOLEAN,
2878: x_QuantityDate IN OUT NOCOPY RLM_SHIP_DELIVERY_PATTERN_SV.t_OutputTable
2879: )
2880: IS
2881: --{
2882: --
2900: BEGIN
2901: --{
2902: --
2903: --
2904: RLM_SHIP_DELIVERY_PATTERN_SV.apply_sdp_to_weekly_bucket
2905: (
2906: x_Input => x_Input,
2907: x_ItemDetailSubtype => x_ItemDetailSubtype,
2908: x_DailyPercent => x_DailyPercent,
2930: FUNCTION get_weekly_quantity
2931: (
2932: x_WholeNumber IN BOOLEAN,
2933: x_Count IN NUMBER,
2934: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
2935: x_DivideBy IN NUMBER
2936: )
2937: RETURN NUMBER
2938: IS
2960: BEGIN
2961: --{
2962: --
2963: --
2964: l_return_value := RLM_SHIP_DELIVERY_PATTERN_SV.get_weekly_quantity
2965: (
2966: x_WholeNumber => x_WholeNumber,
2967: x_Count => x_Count,
2968: x_Input => x_Input,
2988: --
2989: --
2990: PROCEDURE break_bucket
2991: (
2992: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
2993: x_ReturnMessage IN OUT NOCOPY rlm_ship_delivery_pattern_sv.t_ErrorMsgTable,
2994: x_WeeklyBucket OUT NOCOPY rlm_ship_delivery_pattern_sv.t_BucketTable,
2995: x_ReturnStatus OUT NOCOPY NUMBER
2996: )
2989: --
2990: PROCEDURE break_bucket
2991: (
2992: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
2993: x_ReturnMessage IN OUT NOCOPY rlm_ship_delivery_pattern_sv.t_ErrorMsgTable,
2994: x_WeeklyBucket OUT NOCOPY rlm_ship_delivery_pattern_sv.t_BucketTable,
2995: x_ReturnStatus OUT NOCOPY NUMBER
2996: )
2997: IS
2990: PROCEDURE break_bucket
2991: (
2992: x_Input IN rlm_ship_delivery_pattern_sv.t_InputRec,
2993: x_ReturnMessage IN OUT NOCOPY rlm_ship_delivery_pattern_sv.t_ErrorMsgTable,
2994: x_WeeklyBucket OUT NOCOPY rlm_ship_delivery_pattern_sv.t_BucketTable,
2995: x_ReturnStatus OUT NOCOPY NUMBER
2996: )
2997: IS
2998: --{
3017: BEGIN
3018: --{
3019: --
3020: --
3021: RLM_SHIP_DELIVERY_PATTERN_SV.break_bucket
3022: (
3023: x_Input => x_Input,
3024: x_ReturnMessage => x_ReturnMessage,
3025: x_WeeklyBucket => x_WeeklyBucket,