DBA Data[Home] [Help]

APPS.RLM_RD_SV dependencies on RLM_MANAGE_DEMAND_SV

Line 316: IF RLM_MANAGE_DEMAND_SV.IsATPItem(x_group_rec.ship_from_org_id,x_group_rec.inventory_item_id) THEN

312: rlm_core_sv.dlog(k_DEBUG, 'Order Header Id', x_Group_rec.order_header_id); rlm_core_sv.dlog(k_DEBUG, 'Blanket Number', x_Group_rec.blanket_number);
313: END IF;
314: --
315: --global_atp
316: IF RLM_MANAGE_DEMAND_SV.IsATPItem(x_group_rec.ship_from_org_id,x_group_rec.inventory_item_id) THEN
317: g_ATP := k_ATP;
318: ELSE
319: g_ATP := k_NON_ATP;
320: END IF;

Line 3808: (rlm_manage_demand_sv.k_SHIP_RECEIPT_INFO,

3804: AND il.ship_to_org_id = x_Group_rec.ship_to_org_id
3805: AND il.inventory_item_id = x_Group_rec.inventory_item_id
3806: AND il.customer_item_id = x_Group_rec.customer_item_id
3807: AND NVL(il.item_detail_type, ' ') NOT IN
3808: (rlm_manage_demand_sv.k_SHIP_RECEIPT_INFO,
3809: rlm_manage_demand_sv.k_AUTHORIZATION,
3810: rlm_manage_demand_sv.k_OTHER_DETAIL_TYPE)
3811: AND il.schedule_line_id = sl.line_id
3812: AND sl.qty_type_code = rlm_manage_demand_sv.k_CUMULATIVE

Line 3809: rlm_manage_demand_sv.k_AUTHORIZATION,

3805: AND il.inventory_item_id = x_Group_rec.inventory_item_id
3806: AND il.customer_item_id = x_Group_rec.customer_item_id
3807: AND NVL(il.item_detail_type, ' ') NOT IN
3808: (rlm_manage_demand_sv.k_SHIP_RECEIPT_INFO,
3809: rlm_manage_demand_sv.k_AUTHORIZATION,
3810: rlm_manage_demand_sv.k_OTHER_DETAIL_TYPE)
3811: AND il.schedule_line_id = sl.line_id
3812: AND sl.qty_type_code = rlm_manage_demand_sv.k_CUMULATIVE
3813: AND il.org_id = sl.org_id;

Line 3810: rlm_manage_demand_sv.k_OTHER_DETAIL_TYPE)

3806: AND il.customer_item_id = x_Group_rec.customer_item_id
3807: AND NVL(il.item_detail_type, ' ') NOT IN
3808: (rlm_manage_demand_sv.k_SHIP_RECEIPT_INFO,
3809: rlm_manage_demand_sv.k_AUTHORIZATION,
3810: rlm_manage_demand_sv.k_OTHER_DETAIL_TYPE)
3811: AND il.schedule_line_id = sl.line_id
3812: AND sl.qty_type_code = rlm_manage_demand_sv.k_CUMULATIVE
3813: AND il.org_id = sl.org_id;
3814: --

Line 3812: AND sl.qty_type_code = rlm_manage_demand_sv.k_CUMULATIVE

3808: (rlm_manage_demand_sv.k_SHIP_RECEIPT_INFO,
3809: rlm_manage_demand_sv.k_AUTHORIZATION,
3810: rlm_manage_demand_sv.k_OTHER_DETAIL_TYPE)
3811: AND il.schedule_line_id = sl.line_id
3812: AND sl.qty_type_code = rlm_manage_demand_sv.k_CUMULATIVE
3813: AND il.org_id = sl.org_id;
3814: --
3815: IF (l_debug <> -1) THEN
3816: rlm_core_sv.dlog(k_DEBUG,'v_cumDiscrete', v_cumDiscrete);

Line 10084: <> rlm_manage_demand_sv.k_SHIP_RECEIPT_INFO

10080: AND il.inventory_item_id = x_Group_rec.inventory_item_id
10081: AND il.customer_item_id = x_Group_rec.customer_item_id
10082: AND il.schedule_line_id = sl.line_id
10083: AND NVL(il.item_detail_type, ' ')
10084: <> rlm_manage_demand_sv.k_SHIP_RECEIPT_INFO
10085: AND sl.qty_type_code = rlm_manage_demand_sv.k_ACTUAL
10086: AND il.org_id = sl.org_id;
10087: --
10088: IF (l_debug <> -1) THEN

Line 10085: AND sl.qty_type_code = rlm_manage_demand_sv.k_ACTUAL

10081: AND il.customer_item_id = x_Group_rec.customer_item_id
10082: AND il.schedule_line_id = sl.line_id
10083: AND NVL(il.item_detail_type, ' ')
10084: <> rlm_manage_demand_sv.k_SHIP_RECEIPT_INFO
10085: AND sl.qty_type_code = rlm_manage_demand_sv.k_ACTUAL
10086: AND il.org_id = sl.org_id;
10087: --
10088: IF (l_debug <> -1) THEN
10089: rlm_core_sv.dlog(k_DEBUG,'number of lines with qty_type_code ACTUAL: ',v_ActualCount);

Line 13274: IF x_Sched_rec.Schedule_type = RLM_MANAGE_DEMAND_SV.k_PLANNING THEN

13270: END IF;
13271: --
13272: IF x_Sched_rec.Schedule_Source <> 'MANUAL' THEN
13273:
13274: IF x_Sched_rec.Schedule_type = RLM_MANAGE_DEMAND_SV.k_PLANNING THEN
13275: --
13276: IF (l_debug <> -1) THEN
13277: rlm_core_sv.dlog(k_DEBUG, 'pln_mrp_forecast_day_from',
13278: x_group_rec.setup_terms_rec.pln_mrp_forecast_day_from);

Line 13299: ELSIF x_Sched_rec.Schedule_type = RLM_MANAGE_DEMAND_SV.k_SHIPPING THEN

13295: RETURN FALSE;
13296: --
13297: END IF;
13298: --
13299: ELSIF x_Sched_rec.Schedule_type = RLM_MANAGE_DEMAND_SV.k_SHIPPING THEN
13300: --
13301: IF (l_debug <> -1) THEN
13302: rlm_core_sv.dlog(k_DEBUG, 'shp_mrp_forecast_day_from',
13303: x_group_rec.setup_terms_rec.shp_mrp_forecast_day_from);

Line 13324: ELSIF x_Sched_rec.Schedule_type = RLM_MANAGE_DEMAND_SV.k_SEQUENCED THEN

13320: RETURN FALSE;
13321: --
13322: END IF;
13323: --
13324: ELSIF x_Sched_rec.Schedule_type = RLM_MANAGE_DEMAND_SV.k_SEQUENCED THEN
13325: --
13326: IF (l_debug <> -1) THEN
13327: rlm_core_sv.dlog(k_DEBUG, 'seq_mrp_forecast_day_from',
13328: x_group_rec.setup_terms_rec.seq_mrp_forecast_day_from);

Line 14052: v_SrcIntransitTab RLM_MANAGE_DEMAND_SV.t_SrcIntransitQtyTab;

14048: IS
14049: --
14050: i NUMBER;
14051: j NUMBER;
14052: v_SrcIntransitTab RLM_MANAGE_DEMAND_SV.t_SrcIntransitQtyTab;
14053: v_Progress VARCHAR2(3);
14054: v_Key_rec t_Key_rec;
14055: --
14056: BEGIN

Line 14210: AND item_detail_type = RLM_MANAGE_DEMAND_SV.k_SHIP_RECEIPT_INFO

14206: v_cum_key_record.cust_record_year,
14207: v_LineID
14208: FROM rlm_interface_lines
14209: WHERE header_id = x_Sched_rec.header_id
14210: AND item_detail_type = RLM_MANAGE_DEMAND_SV.k_SHIP_RECEIPT_INFO
14211: AND item_detail_subtype = RLM_MANAGE_DEMAND_SV.k_CUM
14212: AND ship_from_org_id = x_Group_rec.ship_from_org_id
14213: AND ship_to_address_id = x_Group_rec.ship_to_address_id
14214: AND inventory_item_id = x_Group_rec.inventory_item_id

Line 14211: AND item_detail_subtype = RLM_MANAGE_DEMAND_SV.k_CUM

14207: v_LineID
14208: FROM rlm_interface_lines
14209: WHERE header_id = x_Sched_rec.header_id
14210: AND item_detail_type = RLM_MANAGE_DEMAND_SV.k_SHIP_RECEIPT_INFO
14211: AND item_detail_subtype = RLM_MANAGE_DEMAND_SV.k_CUM
14212: AND ship_from_org_id = x_Group_rec.ship_from_org_id
14213: AND ship_to_address_id = x_Group_rec.ship_to_address_id
14214: AND inventory_item_id = x_Group_rec.inventory_item_id
14215: AND customer_item_id = x_Group_rec.customer_item_id

Line 15170: AND item_detail_type = RLM_MANAGE_DEMAND_SV.k_SHIP_RECEIPT_INFO

15166: industry_attribute1 cust_record_year,
15167: line_id
15168: FROM rlm_interface_lines
15169: WHERE header_id = x_Sched_rec.header_id
15170: AND item_detail_type = RLM_MANAGE_DEMAND_SV.k_SHIP_RECEIPT_INFO
15171: AND item_detail_subtype = RLM_MANAGE_DEMAND_SV.k_CUM
15172: AND ship_from_org_id = x_Group_rec.ship_from_org_id
15173: AND ship_to_address_id = x_Group_rec.ship_to_address_id
15174: AND inventory_item_id = x_Group_rec.inventory_item_id

Line 15171: AND item_detail_subtype = RLM_MANAGE_DEMAND_SV.k_CUM

15167: line_id
15168: FROM rlm_interface_lines
15169: WHERE header_id = x_Sched_rec.header_id
15170: AND item_detail_type = RLM_MANAGE_DEMAND_SV.k_SHIP_RECEIPT_INFO
15171: AND item_detail_subtype = RLM_MANAGE_DEMAND_SV.k_CUM
15172: AND ship_from_org_id = x_Group_rec.ship_from_org_id
15173: AND ship_to_address_id = x_Group_rec.ship_to_address_id
15174: AND inventory_item_id = x_Group_rec.inventory_item_id
15175: AND customer_item_id = x_Group_rec.customer_item_id