DBA Data[Home] [Help]

APPS.RLM_VALIDATEDEMAND_SV dependencies on RLM_SHIP_DELIVERY_PATTERN_SV

Line 2880: AND item_detail_subtype = rlm_ship_delivery_pattern_sv.g_FLEXIBLE;

2876: INTO v_end_date_f
2877: FROM rlm_interface_lines
2878: WHERE header_id = g_header_rec.header_id
2879: AND item_detail_type IN (0,1,2,6) --Bug 5478817
2880: AND item_detail_subtype = rlm_ship_delivery_pattern_sv.g_FLEXIBLE;
2881: --
2882: IF (l_debug <> -1) THEN
2883: rlm_core_sv.dlog(C_DEBUG,'v_End_Date_f',v_End_Date_f);
2884: END IF;

Line 2891: AND item_detail_subtype = rlm_ship_delivery_pattern_sv.g_DAY;

2887: INTO v_End_Date_d
2888: FROM rlm_interface_lines
2889: WHERE header_id = g_header_rec.header_id
2890: AND item_detail_type IN (0,1,2,6) --Bug 5478817
2891: AND item_detail_subtype = rlm_ship_delivery_pattern_sv.g_DAY;
2892: --
2893: IF (l_debug <> -1) THEN
2894: rlm_core_sv.dlog(C_DEBUG,'v_End_Date_d',v_End_Date_d);
2895: END IF;

Line 2902: AND item_detail_subtype = rlm_ship_delivery_pattern_sv.g_WEEK;

2898: INTO v_End_Date_w
2899: FROM rlm_interface_lines
2900: WHERE header_id = g_header_rec.header_id
2901: AND item_detail_type IN (0,1,2,6) --Bug 5478817
2902: AND item_detail_subtype = rlm_ship_delivery_pattern_sv.g_WEEK;
2903: --
2904: IF (l_debug <> -1) THEN
2905: rlm_core_sv.dlog(C_DEBUG, 'v_End_Date_w', v_End_Date_w);
2906: END IF;

Line 2913: AND item_detail_subtype = rlm_ship_delivery_pattern_sv.g_MONTH;

2909: INTO v_End_Date_m
2910: FROM rlm_interface_lines
2911: WHERE header_id = g_header_rec.header_id
2912: AND item_detail_type IN (0,1,2,6) --Bug 5478817
2913: AND item_detail_subtype = rlm_ship_delivery_pattern_sv.g_MONTH;
2914: --
2915: IF (l_debug <> -1) THEN
2916: rlm_core_sv.dlog(C_DEBUG, 'v_End_Date_m', v_End_Date_m);
2917: END IF;