[Home] [Help]
4231: -- generate a new config item
4232:
4233: /*--------------------------------------------------+
4234: Check to see if the config_segment_name exists in
4235: bom_parameters for the given organization.
4236: BOM_parameters are organization dependent, we will use
4237: BOM_parameter settings in the OE validation org.
4238: +---------------------------------------------------*/
4239:
4232:
4233: /*--------------------------------------------------+
4234: Check to see if the config_segment_name exists in
4235: bom_parameters for the given organization.
4236: BOM_parameters are organization dependent, we will use
4237: BOM_parameter settings in the OE validation org.
4238: +---------------------------------------------------*/
4239:
4240: lStmtNumber := 15;
4241: select config_segment_name,
4242: config_number_method_type
4243: into lConfigSegName,
4244: lNumberMethod
4245: from bom_parameters
4246: where organization_id = lValidationOrg;
4247:
4248:
4249: if lConfigSegName is NULL then
4275: -- Bugfix 1736339 : sql%notfound will not be raised in case of SELECT, instead NO_DATA_FOUND
4276: -- exception is raised.
4277: -- Added outer join to the query so that we'll default the maximum_size to 40
4278: -- Merged stmt# 40 in the same query.
4279: -- Since lConfigSegName is available, we will use this instead of joining bom_parameters.
4280:
4281: select nvl(fv.maximum_size,40), fs.application_column_name
4282: into lFndSize, app_column
4283: from -- bom_parameters p,
4279: -- Since lConfigSegName is available, we will use this instead of joining bom_parameters.
4280:
4281: select nvl(fv.maximum_size,40), fs.application_column_name
4282: into lFndSize, app_column
4283: from -- bom_parameters p,
4284: fnd_id_flex_segments fs,
4285: fnd_flex_value_sets fv
4286: where --p.organization_id = lValidationOrg and
4287: fs.id_flex_code = 'MSTK'