[Home] [Help]
4326: -- generate a new config item
4327:
4328: /*--------------------------------------------------+
4329: Check to see if the config_segment_name exists in
4330: bom_parameters for the given organization.
4331: BOM_parameters are organization dependent, we will use
4332: BOM_parameter settings in the OE validation org.
4333: +---------------------------------------------------*/
4334:
4327:
4328: /*--------------------------------------------------+
4329: Check to see if the config_segment_name exists in
4330: bom_parameters for the given organization.
4331: BOM_parameters are organization dependent, we will use
4332: BOM_parameter settings in the OE validation org.
4333: +---------------------------------------------------*/
4334:
4335: lStmtNumber := 15;
4336: select config_segment_name,
4337: config_number_method_type
4338: into lConfigSegName,
4339: lNumberMethod
4340: from bom_parameters
4341: where organization_id = lValidationOrg;
4342:
4343:
4344: if lConfigSegName is NULL then
4370: -- Bugfix 1736339 : sql%notfound will not be raised in case of SELECT, instead NO_DATA_FOUND
4371: -- exception is raised.
4372: -- Added outer join to the query so that we'll default the maximum_size to 40
4373: -- Merged stmt# 40 in the same query.
4374: -- Since lConfigSegName is available, we will use this instead of joining bom_parameters.
4375:
4376: select nvl(fv.maximum_size,40), fs.application_column_name
4377: into lFndSize, app_column
4378: from -- bom_parameters p,
4374: -- Since lConfigSegName is available, we will use this instead of joining bom_parameters.
4375:
4376: select nvl(fv.maximum_size,40), fs.application_column_name
4377: into lFndSize, app_column
4378: from -- bom_parameters p,
4379: fnd_id_flex_segments fs,
4380: fnd_flex_value_sets fv
4381: where --p.organization_id = lValidationOrg and
4382: fs.id_flex_code = 'MSTK'