[Home] [Help]
1599: v_num := fnd_flex_ext.breakup_segments( X_locator_hi, v_delim, seg_high);
1600:
1601:
1602: -- bug 4662395 set the profile mfg_organization_id so
1603: -- the call to MTL_PROJECT_V will return data.
1604:
1605: FND_PROFILE.put('MFG_ORGANIZATION_ID',X_org_id);
1606:
1607: -- Building the where clause
1620: ( CUR2.APPLICATION_COLUMN_NAME = 'SEGMENT19' OR
1621: CUR2.APPLICATION_COLUMN_NAME = 'SEGMENT20') then
1622: if CUR2.APPLICATION_COLUMN_NAME = 'SEGMENT19' then
1623: v_where := v_append ||' to_number(SEGMENT19) in '||
1624: '(select project_id from mtl_project_v where '||
1625: 'project_name >= nvl('||comma||seg_low(v_cnt)||comma||
1626: ', project_name) '|| 'and project_name <= nvl('||
1627: comma||seg_high(v_cnt)||comma||', project_name))';
1628: elsif CUR2.APPLICATION_COLUMN_NAME = 'SEGMENT20' then
1914: from MTL_PARAMETERS
1915: where organization_id = X_org_id;
1916:
1917: -- bug 4662395 set the profile mfg_organization_id so
1918: -- the call to MTL_PROJECT_V will return data.
1919:
1920: FND_PROFILE.put('MFG_ORGANIZATION_ID',X_org_id);
1921:
1922: v_delim := fnd_flex_ext.get_delimiter('INV',v_flex_code, v_flex_num);
1930: if CUR2.APPLICATION_COLUMN_NAME = 'SEGMENT19' then
1931: begin
1932: v_seg19_f := True;
1933: select distinct project_name into v_proj_name
1934: from mtl_project_v where
1935: project_id = ( select nvl(to_number(SEGMENT19), 0)
1936: from mtl_item_locations
1937: where inventory_location_id = X_loc_id and
1938: organization_id = X_org_id );