DBA Data[Home] [Help]

APPS.OE_BULK_CONFIG_UTIL dependencies on OE_BULK_ORDER_PVT

Line 316: l_profile := OE_BULK_ORDER_PVT.G_CONFIG_EFFECT_DATE;

312: END IF;
313:
314: x_return_status := FND_API.G_RET_STS_SUCCESS;
315:
316: l_profile := OE_BULK_ORDER_PVT.G_CONFIG_EFFECT_DATE;
317:
318: IF l_profile = '1' OR l_profile IS NULL THEN
319: x_old_behavior := 'Y';
320: x_config_effective_date := sysdate;

Line 429: l_context_org_id := OE_BULK_ORDER_PVT.G_ITEM_ORG;

425: oe_debug_pub.add('ENTERING OE_BULK_CONFIG_UTIL.CREATE_HDR_XML' , 1);
426: END IF;
427:
428: -- now set the values from model_rec and org_id
429: l_context_org_id := OE_BULK_ORDER_PVT.G_ITEM_ORG;
430: l_inventory_item_id := to_char(p_line_rec.inventory_item_id(p_line_index));
431: l_config_header_id := to_char(p_line_rec.config_header_id(p_line_index));
432: l_config_rev_nbr := to_char(p_line_rec.config_rev_nbr(p_line_index));
433:

Line 480: param_value(4) := OE_BULK_ORDER_PVT.G_RESP_APPL_ID;

476:
477: param_value(1) := l_database_id;
478: param_value(2) := l_context_org_id;
479: param_value(3) := to_char(sysdate, 'MM-DD-YYYY-HH24-MI-SS');
480: param_value(4) := OE_BULK_ORDER_PVT.G_RESP_APPL_ID;
481: param_value(5) := OE_BULK_ORDER_PVT.G_RESP_ID;
482: param_value(6) := l_inventory_item_id;
483: param_value(7) := l_config_header_id;
484: param_value(8) := l_config_rev_nbr;

Line 481: param_value(5) := OE_BULK_ORDER_PVT.G_RESP_ID;

477: param_value(1) := l_database_id;
478: param_value(2) := l_context_org_id;
479: param_value(3) := to_char(sysdate, 'MM-DD-YYYY-HH24-MI-SS');
480: param_value(4) := OE_BULK_ORDER_PVT.G_RESP_APPL_ID;
481: param_value(5) := OE_BULK_ORDER_PVT.G_RESP_ID;
482: param_value(6) := l_inventory_item_id;
483: param_value(7) := l_config_header_id;
484: param_value(8) := l_config_rev_nbr;
485: param_value(9) := null;

Line 2395: p_validation_org => OE_BULK_ORDER_PVT.G_ITEM_ORG,

2391: l_line_rec.top_model_line_id(I) := l_line_rec.line_id(I);
2392:
2393: OE_Config_UTIL.Explode
2394: (
2395: p_validation_org => OE_BULK_ORDER_PVT.G_ITEM_ORG,
2396: p_group_id => NULL,
2397: p_session_id => 0, -- ( null ?)
2398: p_levels => 60, -- (6 ?)
2399: p_stdcompflag => OE_Config_Util.OE_BMX_OPTION_COMPS,

Line 2445: AND ORGANIZATION_ID = OE_BULK_ORDER_PVT.G_ITEM_ORG

2441: l_config_rec.bom_item_type(I),
2442: l_config_rec.replenish_to_order_flag(I)
2443: FROM bom_explosions
2444: WHERE COMPONENT_ITEM_ID = l_line_rec.inventory_item_id(I)
2445: AND ORGANIZATION_ID = OE_BULK_ORDER_PVT.G_ITEM_ORG
2446: AND PLAN_LEVEL = 0
2447: AND nvl(effectivity_date, sysdate) <= sysdate
2448: AND nvl(disable_date, sysdate+1) > sysdate
2449: AND explosion_type = OE_Config_Util.OE_BMX_OPTION_COMPS;

Line 2518: AND organization_id = OE_BULK_ORDER_PVT.G_ITEM_ORG

2514: AND top_bill_sequence_id = l_line_rec.top_bill_sequence_id(I)
2515: AND plan_level > 0
2516: AND nvl(effectivity_date, sysdate) <= sysdate
2517: AND nvl(disable_date, sysdate+1) > sysdate
2518: AND organization_id = OE_BULK_ORDER_PVT.G_ITEM_ORG
2519: AND component_code = NVL(l_line_rec.component_code(I), component_code);
2520:
2521: EXCEPTION
2522: WHEN NO_DATA_FOUND THEN

Line 3135: ( p_error_rec IN OE_BULK_ORDER_PVT.INVALID_HDR_REC_TYPE

3131:
3132:
3133:
3134: PROCEDURE Delete_Configurations
3135: ( p_error_rec IN OE_BULK_ORDER_PVT.INVALID_HDR_REC_TYPE
3136: ,x_return_status OUT NOCOPY VARCHAR2
3137: )
3138: IS
3139: