APPS.EGO_ITEM_BULKLOAD_PKG dependencies on BOM_COMPONENT_COLUMNS

Line 1155: FROM bom_component_columns

1151: -- To check if the given attribute code is a valid BOM Component Column.
1152: --------------------------------------------------------------------------
1153: CURSOR c_bom_comp_col_exists(c_attribute_code IN VARCHAR2) IS
1154: SELECT 'x'
1155: FROM bom_component_columns
1156: WHERE attribute_code = c_attribute_code
1157: AND parent_entity = 'ITEM';
1158: -- AND whereclause IS NOT NULL;
1159:

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

1293: Write_Debug('The caller identity is : '|| p_caller_identifier);
1294:
1295: --------------------------------------------------------------------
1296: -- If the Caller Identifer is G_BOM and the column exists in
1297: -- BOM_COMPONENT_COLUMNS then fetch the Correct prod column
1298: -- name from BOM_COMPONENT_COLUMNS.
1299: --------------------------------------------------------------------
1300: IF (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_BOM AND
1301: l_bom_col_exists = TRUE AND l_prod_col_name <> G_ITEM_NUMBER)

Line 1298: -- name from BOM_COMPONENT_COLUMNS.

1294:
1295: --------------------------------------------------------------------
1296: -- If the Caller Identifer is G_BOM and the column exists in
1297: -- BOM_COMPONENT_COLUMNS then fetch the Correct prod column
1298: -- name from BOM_COMPONENT_COLUMNS.
1299: --------------------------------------------------------------------
1300: IF (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_BOM AND
1301: l_bom_col_exists = TRUE AND l_prod_col_name <> G_ITEM_NUMBER)
1302: THEN

Line 1304: FROM BOM_COMPONENT_COLUMNS

1300: IF (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_BOM AND
1301: l_bom_col_exists = TRUE AND l_prod_col_name <> G_ITEM_NUMBER)
1302: THEN
1303: SELECT BOM_INTF_COLUMN_NAME INTO l_bom_prod_col_name
1304: FROM BOM_COMPONENT_COLUMNS
1305: WHERE Attribute_Code = l_prod_col_name AND Parent_Entity = 'ITEM';
1306: Write_Debug('The column value from BCC: ' || l_bom_prod_col_name);
1307: IF l_bom_prod_col_name IS NOT NULL THEN
1308: l_prod_col_name := l_bom_prod_col_name;

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

1312:
1313: --------------------------------------------------------------------
1314: -- If the Caller Identifer is G_ITEM, then save the column info.
1315: -- If the Caller Identifer is G_BOM, and the column exists in
1316: -- BOM_COMPONENT_COLUMNS, then save the column info.
1317: --------------------------------------------------------------------
1318: IF (
1319: (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_ITEM) OR
1320: (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_BOM AND