[Home] [Help]
3298: ,x_line_rec => l_model_line_rec);
3299:
3300: -- now set the values from model_rec and org_id
3301: l_context_org_id :=
3302: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
3303: l_inventory_item_id := to_char(l_model_line_rec.inventory_item_id);
3304: l_config_header_id := to_char(l_model_line_rec.config_header_id);
3305: l_config_rev_nbr := to_char(l_model_line_rec.config_rev_nbr);
3306:
4401: l_return_status := FND_API.G_RET_STS_SUCCESS;
4402: GOTO UPDATE_EXP_DATE;
4403:
4404: END IF;
4405: l_validation_org := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
4406:
4407: IF l_debug_level > 0 THEN
4408: oe_debug_pub.add('EXPLOSION_DATE: ' || L_EXPLOSION_DATE , 2 );
4409: oe_debug_pub.add('P_TOP_ITEM_ID: '
5776: l_component_code VARCHAR2(1000);
5777: l_component_item_id NUMBER;
5778: l_component_seq_id NUMBER;
5779: l_rev_date DATE;
5780: l_validation_org NUMBER := OE_SYS_PARAMETERS.VALUE
5781: ('MASTER_ORGANIZATION_ID');
5782: l_group_id NUMBER := null;
5783: l_session_id NUMBER := 0;
5784: l_levels NUMBER := 60;
8164: select 'Y'
8165: into l_serviceable_item
8166: from mtl_system_items mtl
8167: where mtl.inventory_item_id = p_line_tbl(I).inventory_item_id
8168: and mtl.organization_id = OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID')
8169: and mtl.serviceable_product_flag='Y'
8170: and rownum = 1;
8171:
8172: EXCEPTION
8672:
8673:
8674: IF OE_CODE_CONTROL.get_code_release_level >= '110510' THEN
8675:
8676: l_profile := nvl(OE_Sys_Parameters.VALUE('ONT_CONFIG_EFFECTIVITY_DATE'),
8677: '1');
8678:
8679: IF l_debug_level > 0 THEN
8680: oe_debug_pub.add('pack J code '||l_profile, 1);
9061: oe_debug_pub.add(' Count of Included Items under Kit : '||l_included_item_tbl.COUNT,5);
9062: end if;
9063:
9064: l_explosion_date := SYSDATE;
9065: l_validation_org := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
9066:
9067: Explode( p_validation_org => l_validation_org,
9068: p_levels => 6, --??
9069: p_stdcompflag => OE_BMX_STD_COMPS_ONLY,