[Home] [Help]
1173: v_num := fnd_flex_ext.breakup_segments( X_locator_hi, v_delim, seg_high);
1174:
1175:
1176: -- bug 4662395 set the profile mfg_organization_id so
1177: -- the call to MTL_PROJECT_V will return data.
1178:
1179: FND_PROFILE.put('MFG_ORGANIZATION_ID',X_org_id);
1180:
1181: -- Building the where clause
1194: ( CUR2.APPLICATION_COLUMN_NAME = 'SEGMENT19' OR
1195: CUR2.APPLICATION_COLUMN_NAME = 'SEGMENT20') then
1196: if CUR2.APPLICATION_COLUMN_NAME = 'SEGMENT19' then
1197: v_where := v_append ||' to_number(SEGMENT19) in '||
1198: '(select project_id from mtl_project_v where '||
1199: 'project_name >= nvl('||comma||seg_low(v_cnt)||comma||
1200: ', project_name) '|| 'and project_name <= nvl('||
1201: comma||seg_high(v_cnt)||comma||', project_name))';
1202: elsif CUR2.APPLICATION_COLUMN_NAME = 'SEGMENT20' then
1461: from MTL_PARAMETERS
1462: where organization_id = X_org_id;
1463:
1464: -- bug 4662395 set the profile mfg_organization_id so
1465: -- the call to MTL_PROJECT_V will return data.
1466:
1467: FND_PROFILE.put('MFG_ORGANIZATION_ID',X_org_id);
1468:
1469: v_delim := fnd_flex_ext.get_delimiter('INV',v_flex_code, v_flex_num);
1477: if CUR2.APPLICATION_COLUMN_NAME = 'SEGMENT19' then
1478: begin
1479: v_seg19_f := True;
1480: select distinct project_name into v_proj_name
1481: from mtl_project_v where
1482: project_id = ( select nvl(to_number(SEGMENT19), 0)
1483: from mtl_item_locations
1484: where inventory_location_id = X_loc_id and
1485: organization_id = X_org_id );