[Home] [Help]
3292: ,x_line_rec => l_model_line_rec);
3293:
3294: -- now set the values from model_rec and org_id
3295: l_context_org_id :=
3296: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
3297: l_inventory_item_id := to_char(l_model_line_rec.inventory_item_id);
3298: l_config_header_id := to_char(l_model_line_rec.config_header_id);
3299: l_config_rev_nbr := to_char(l_model_line_rec.config_rev_nbr);
3300:
4395: l_return_status := FND_API.G_RET_STS_SUCCESS;
4396: GOTO UPDATE_EXP_DATE;
4397:
4398: END IF;
4399: l_validation_org := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
4400:
4401: IF l_debug_level > 0 THEN
4402: oe_debug_pub.add('EXPLOSION_DATE: ' || L_EXPLOSION_DATE , 2 );
4403: oe_debug_pub.add('P_TOP_ITEM_ID: '
5769: l_component_code VARCHAR2(1000);
5770: l_component_item_id NUMBER;
5771: l_component_seq_id NUMBER;
5772: l_rev_date DATE;
5773: l_validation_org NUMBER := OE_SYS_PARAMETERS.VALUE
5774: ('MASTER_ORGANIZATION_ID');
5775: l_group_id NUMBER := null;
5776: l_session_id NUMBER := 0;
5777: l_levels NUMBER := 60;
8038: select 'Y'
8039: into l_serviceable_item
8040: from mtl_system_items mtl
8041: where mtl.inventory_item_id = p_line_tbl(I).inventory_item_id
8042: and mtl.organization_id = OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID')
8043: and mtl.serviceable_product_flag='Y'
8044: and rownum = 1;
8045:
8046: EXCEPTION
8502:
8503:
8504: IF OE_CODE_CONTROL.get_code_release_level >= '110510' THEN
8505:
8506: l_profile := nvl(OE_Sys_Parameters.VALUE('ONT_CONFIG_EFFECTIVITY_DATE'),
8507: '1');
8508:
8509: IF l_debug_level > 0 THEN
8510: oe_debug_pub.add('pack J code '||l_profile, 1);