APPS.OZF_OFFER_PUB dependencies on FND_PROFILE

Line 2367: l_act_product_rec.organization_id := FND_PROFILE.value('QP_ORGANIZATION_ID');

2363: l_act_product_rec.arc_act_product_used_by := 'OFFR';
2364: l_act_product_rec.act_product_used_by_id := x_qp_list_header_id;
2365: l_act_product_rec.level_type_code := 'PRODUCT';
2366: l_act_product_rec.inventory_item_id := p_modifier_line_tbl(i).product_attr_val;
2367: l_act_product_rec.organization_id := FND_PROFILE.value('QP_ORGANIZATION_ID');
2368: l_act_product_rec.line_lumpsum_qty := l_lumpsum_distr_value;
2369: l_act_product_rec.enabled_flag := 'N';
2370: l_act_product_rec.excluded_flag := 'N';
2371: l_act_product_rec.attribute1 := p_modifier_line_tbl(i).list_line_no;

Line 2373: OPEN c_uom(l_act_product_rec.inventory_item_id, fnd_profile.value('QP_ORGANIZATION_ID'));

2369: l_act_product_rec.enabled_flag := 'N';
2370: l_act_product_rec.excluded_flag := 'N';
2371: l_act_product_rec.attribute1 := p_modifier_line_tbl(i).list_line_no;
2372:
2373: OPEN c_uom(l_act_product_rec.inventory_item_id, fnd_profile.value('QP_ORGANIZATION_ID'));
2374: FETCH c_uom INTO l_uom;
2375: IF (c_uom%NOTFOUND) THEN
2376: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2377: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_UOM');

Line 2495: ,fnd_profile.value('QP_ORGANIZATION_ID')

2491: l_modifier_line_tbl(l_line_index).price_by_formula := NVL(p_modifier_line_tbl(i).price_by_formula,Fnd_Api.g_miss_char);
2492: l_modifier_line_tbl(l_line_index).list_line_no := NVL(p_modifier_line_tbl(i).list_line_no,Fnd_Api.g_miss_char);
2493:
2494: OPEN c_uom ( l_modifier_line_tbl(l_line_index).product_attr_val
2495: ,fnd_profile.value('QP_ORGANIZATION_ID')
2496: );
2497: FETCH c_uom INTO l_uom;
2498: IF ( c_uom%NOTFOUND) THEN
2499: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN