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 3973: (rlm_manage_demand_sv.k_SHIP_RECEIPT_INFO,

3969: AND il.ship_to_org_id = x_Group_rec.ship_to_org_id
3970: AND il.inventory_item_id = x_Group_rec.inventory_item_id
3971: AND il.customer_item_id = x_Group_rec.customer_item_id
3972: AND NVL(il.item_detail_type, ' ') NOT IN
3973: (rlm_manage_demand_sv.k_SHIP_RECEIPT_INFO,
3974: rlm_manage_demand_sv.k_AUTHORIZATION,
3975: rlm_manage_demand_sv.k_OTHER_DETAIL_TYPE)
3976: AND il.schedule_line_id = sl.line_id
3977: AND sl.qty_type_code = rlm_manage_demand_sv.k_CUMULATIVE

Line 3974: rlm_manage_demand_sv.k_AUTHORIZATION,

3970: AND il.inventory_item_id = x_Group_rec.inventory_item_id
3971: AND il.customer_item_id = x_Group_rec.customer_item_id
3972: AND NVL(il.item_detail_type, ' ') NOT IN
3973: (rlm_manage_demand_sv.k_SHIP_RECEIPT_INFO,
3974: rlm_manage_demand_sv.k_AUTHORIZATION,
3975: rlm_manage_demand_sv.k_OTHER_DETAIL_TYPE)
3976: AND il.schedule_line_id = sl.line_id
3977: AND sl.qty_type_code = rlm_manage_demand_sv.k_CUMULATIVE
3978: AND il.org_id = sl.org_id;

Line 3975: rlm_manage_demand_sv.k_OTHER_DETAIL_TYPE)

3971: AND il.customer_item_id = x_Group_rec.customer_item_id
3972: AND NVL(il.item_detail_type, ' ') NOT IN
3973: (rlm_manage_demand_sv.k_SHIP_RECEIPT_INFO,
3974: rlm_manage_demand_sv.k_AUTHORIZATION,
3975: rlm_manage_demand_sv.k_OTHER_DETAIL_TYPE)
3976: AND il.schedule_line_id = sl.line_id
3977: AND sl.qty_type_code = rlm_manage_demand_sv.k_CUMULATIVE
3978: AND il.org_id = sl.org_id;
3979: --

Line 3977: AND sl.qty_type_code = rlm_manage_demand_sv.k_CUMULATIVE

3973: (rlm_manage_demand_sv.k_SHIP_RECEIPT_INFO,
3974: rlm_manage_demand_sv.k_AUTHORIZATION,
3975: rlm_manage_demand_sv.k_OTHER_DETAIL_TYPE)
3976: AND il.schedule_line_id = sl.line_id
3977: AND sl.qty_type_code = rlm_manage_demand_sv.k_CUMULATIVE
3978: AND il.org_id = sl.org_id;
3979: --
3980: IF (l_debug <> -1) THEN
3981: rlm_core_sv.dlog(k_DEBUG,'v_cumDiscrete', v_cumDiscrete);

Line 10258: <> rlm_manage_demand_sv.k_SHIP_RECEIPT_INFO

10254: AND il.inventory_item_id = x_Group_rec.inventory_item_id
10255: AND il.customer_item_id = x_Group_rec.customer_item_id
10256: AND il.schedule_line_id = sl.line_id
10257: AND NVL(il.item_detail_type, ' ')
10258: <> rlm_manage_demand_sv.k_SHIP_RECEIPT_INFO
10259: AND sl.qty_type_code = rlm_manage_demand_sv.k_ACTUAL
10260: AND il.org_id = sl.org_id;
10261: --
10262: IF (l_debug <> -1) THEN

Line 10259: AND sl.qty_type_code = rlm_manage_demand_sv.k_ACTUAL

10255: AND il.customer_item_id = x_Group_rec.customer_item_id
10256: AND il.schedule_line_id = sl.line_id
10257: AND NVL(il.item_detail_type, ' ')
10258: <> rlm_manage_demand_sv.k_SHIP_RECEIPT_INFO
10259: AND sl.qty_type_code = rlm_manage_demand_sv.k_ACTUAL
10260: AND il.org_id = sl.org_id;
10261: --
10262: IF (l_debug <> -1) THEN
10263: rlm_core_sv.dlog(k_DEBUG,'number of lines with qty_type_code ACTUAL: ',v_ActualCount);

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

13464: END IF;
13465: --
13466: IF x_Sched_rec.Schedule_Source <> 'MANUAL' THEN
13467:
13468: IF x_Sched_rec.Schedule_type = RLM_MANAGE_DEMAND_SV.k_PLANNING THEN
13469: --
13470: IF (l_debug <> -1) THEN
13471: rlm_core_sv.dlog(k_DEBUG, 'pln_mrp_forecast_day_from',
13472: x_group_rec.setup_terms_rec.pln_mrp_forecast_day_from);

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

13489: RETURN FALSE;
13490: --
13491: END IF;
13492: --
13493: ELSIF x_Sched_rec.Schedule_type = RLM_MANAGE_DEMAND_SV.k_SHIPPING THEN
13494: --
13495: IF (l_debug <> -1) THEN
13496: rlm_core_sv.dlog(k_DEBUG, 'shp_mrp_forecast_day_from',
13497: x_group_rec.setup_terms_rec.shp_mrp_forecast_day_from);

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

13514: RETURN FALSE;
13515: --
13516: END IF;
13517: --
13518: ELSIF x_Sched_rec.Schedule_type = RLM_MANAGE_DEMAND_SV.k_SEQUENCED THEN
13519: --
13520: IF (l_debug <> -1) THEN
13521: rlm_core_sv.dlog(k_DEBUG, 'seq_mrp_forecast_day_from',
13522: x_group_rec.setup_terms_rec.seq_mrp_forecast_day_from);

Line 14246: v_SrcIntransitTab RLM_MANAGE_DEMAND_SV.t_SrcIntransitQtyTab;

14242: IS
14243: --
14244: i NUMBER;
14245: j NUMBER;
14246: v_SrcIntransitTab RLM_MANAGE_DEMAND_SV.t_SrcIntransitQtyTab;
14247: v_Progress VARCHAR2(3);
14248: v_Key_rec t_Key_rec;
14249: --
14250: BEGIN

Line 14404: AND item_detail_type = RLM_MANAGE_DEMAND_SV.k_SHIP_RECEIPT_INFO

14400: v_cum_key_record.cust_record_year,
14401: v_LineID
14402: FROM rlm_interface_lines
14403: WHERE header_id = x_Sched_rec.header_id
14404: AND item_detail_type = RLM_MANAGE_DEMAND_SV.k_SHIP_RECEIPT_INFO
14405: AND item_detail_subtype = RLM_MANAGE_DEMAND_SV.k_CUM
14406: AND ship_from_org_id = x_Group_rec.ship_from_org_id
14407: AND ship_to_address_id = x_Group_rec.ship_to_address_id
14408: AND inventory_item_id = x_Group_rec.inventory_item_id

Line 14405: AND item_detail_subtype = RLM_MANAGE_DEMAND_SV.k_CUM

14401: v_LineID
14402: FROM rlm_interface_lines
14403: WHERE header_id = x_Sched_rec.header_id
14404: AND item_detail_type = RLM_MANAGE_DEMAND_SV.k_SHIP_RECEIPT_INFO
14405: AND item_detail_subtype = RLM_MANAGE_DEMAND_SV.k_CUM
14406: AND ship_from_org_id = x_Group_rec.ship_from_org_id
14407: AND ship_to_address_id = x_Group_rec.ship_to_address_id
14408: AND inventory_item_id = x_Group_rec.inventory_item_id
14409: AND customer_item_id = x_Group_rec.customer_item_id

Line 15364: AND item_detail_type = RLM_MANAGE_DEMAND_SV.k_SHIP_RECEIPT_INFO

15360: industry_attribute1 cust_record_year,
15361: line_id
15362: FROM rlm_interface_lines
15363: WHERE header_id = x_Sched_rec.header_id
15364: AND item_detail_type = RLM_MANAGE_DEMAND_SV.k_SHIP_RECEIPT_INFO
15365: AND item_detail_subtype = RLM_MANAGE_DEMAND_SV.k_CUM
15366: AND ship_from_org_id = x_Group_rec.ship_from_org_id
15367: AND ship_to_address_id = x_Group_rec.ship_to_address_id
15368: AND inventory_item_id = x_Group_rec.inventory_item_id

Line 15365: AND item_detail_subtype = RLM_MANAGE_DEMAND_SV.k_CUM

15361: line_id
15362: FROM rlm_interface_lines
15363: WHERE header_id = x_Sched_rec.header_id
15364: AND item_detail_type = RLM_MANAGE_DEMAND_SV.k_SHIP_RECEIPT_INFO
15365: AND item_detail_subtype = RLM_MANAGE_DEMAND_SV.k_CUM
15366: AND ship_from_org_id = x_Group_rec.ship_from_org_id
15367: AND ship_to_address_id = x_Group_rec.ship_to_address_id
15368: AND inventory_item_id = x_Group_rec.inventory_item_id
15369: AND customer_item_id = x_Group_rec.customer_item_id