[Home] [Help]
29: l_count number;
30: l_material_billable_flag varchar2(2);
31: l_dummy varchar2(2) := null;
32: l_inventory_item_id number;
33: l_org_id NUMBER := fnd_profile.value('CSD_DEF_REP_INV_ORG'); --cs_std.get_item_valdn_orgzn_id; bug#10187275,subhat
34: l_profile_id number;
35: --bug#6930575,subhat.
36: l_effectivity_control number;
37: l_max_level number;
52: END IF;
53: --bug#6930575, subhat.
54: -- we will use exploder_userexit API no need for profile_id
55: -- get the security profile id for the current session
56: --l_profile_id := fnd_profile.value('PER_SECURITY_PROFILE_ID');
57:
58: t_org_code_list(1) := l_org_id;
59: -- bug#6930575, subhat
60: -- export_bom api doesnt work fine for Model Unit Controlled items.
70: if nvl(l_effectivity_control,0) = 2 then
71: select min(unit_number),max(unit_number) into
72: l_unit_number_from,l_unit_number_to
73: from pjm_unit_numbers
74: where master_organization_id = fnd_profile.value('ORG_ID');
75: end if;
76: -- get the maximum explosion level.
77: SELECT MAXIMUM_BOM_LEVEL INTO l_max_level
78: FROM BOM_PARAMETERS
599: END IF;
600:
601: -- retrieve the Unit cost of the item.
602: --bug#10187275,subhat
603: l_item_cost := get_item_Cost(l_item_id,l_uom,p_currency_code, fnd_profile.value('CSD_DEF_REP_INV_ORG'),x_msg_count,x_msg_data,x_return_status);
604:
605: -- retrieve the selling price for the item.
606: -- bug#13980152, yvchen
607: -- if the SR header doesn't have the operating unit information, then derive the same.
937:
938: BEGIN
939:
940: -- enable costing manually. probably when running from apps context this is not required.
941: fnd_profile.put('CSD_ENABLE_COSTING','Y');
942: CSD_COST_ANALYSIS_PVT.Get_InvItemCost(
943: p_api_version => 1.0,
944: p_commit => csd_process_util.g_false,
945: p_init_msg_list => csd_process_util.g_true,