APPS.EGO_ITEM_BULKLOAD_PKG dependencies on BOM_COMPONENT_COLUMNS

Line 1117: FROM bom_component_columns

1113: -- To check if the given attribute code is a valid BOM Component Column.
1114: --------------------------------------------------------------------------
1115: CURSOR c_bom_comp_col_exists(c_attribute_code IN VARCHAR2) IS
1116: SELECT 'x'
1117: FROM bom_component_columns
1118: WHERE attribute_code = c_attribute_code
1119: AND parent_entity = 'ITEM';
1120: -- AND whereclause IS NOT NULL;
1121:

Line 1255: -- BOM_COMPONENT_COLUMNS then fetch the Correct prod column

1251: Write_Debug('The caller identity is : '|| p_caller_identifier);
1252:
1253: --------------------------------------------------------------------
1254: -- If the Caller Identifer is G_BOM and the column exists in
1255: -- BOM_COMPONENT_COLUMNS then fetch the Correct prod column
1256: -- name from BOM_COMPONENT_COLUMNS.
1257: --------------------------------------------------------------------
1258: IF (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_BOM AND
1259: l_bom_col_exists = TRUE AND l_prod_col_name <> G_ITEM_NUMBER)

Line 1256: -- name from BOM_COMPONENT_COLUMNS.

1252:
1253: --------------------------------------------------------------------
1254: -- If the Caller Identifer is G_BOM and the column exists in
1255: -- BOM_COMPONENT_COLUMNS then fetch the Correct prod column
1256: -- name from BOM_COMPONENT_COLUMNS.
1257: --------------------------------------------------------------------
1258: IF (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_BOM AND
1259: l_bom_col_exists = TRUE AND l_prod_col_name <> G_ITEM_NUMBER)
1260: THEN

Line 1262: FROM BOM_COMPONENT_COLUMNS

1258: IF (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_BOM AND
1259: l_bom_col_exists = TRUE AND l_prod_col_name <> G_ITEM_NUMBER)
1260: THEN
1261: SELECT BOM_INTF_COLUMN_NAME INTO l_bom_prod_col_name
1262: FROM BOM_COMPONENT_COLUMNS
1263: WHERE Attribute_Code = l_prod_col_name AND Parent_Entity = 'ITEM';
1264: Write_Debug('The column value from BCC: ' || l_bom_prod_col_name);
1265: IF l_bom_prod_col_name IS NOT NULL THEN
1266: l_prod_col_name := l_bom_prod_col_name;

Line 1274: -- BOM_COMPONENT_COLUMNS, then save the column info.

1270:
1271: --------------------------------------------------------------------
1272: -- If the Caller Identifer is G_ITEM, then save the column info.
1273: -- If the Caller Identifer is G_BOM, and the column exists in
1274: -- BOM_COMPONENT_COLUMNS, then save the column info.
1275: --------------------------------------------------------------------
1276: IF (
1277: (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_ITEM) OR
1278: (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_BOM AND