DBA Data[Home] [Help]

APPS.BOM_MIXED_MODEL_MAP_PVT dependencies on BOM_MIXED_MODEL_MAP_RES

Line 1436: -- Insert these values into the table BOM_MIXED_MODEL_MAP_RES.

1432: -- NAME : GetDetails
1433: -- DESCRIPTION: Get the Detail of resource usage on the line, according
1434: -- to the given demand
1435: --
1436: -- Insert these values into the table BOM_MIXED_MODEL_MAP_RES.
1437: -- REQUIRES : err_text out buffer to return error message
1438: -- MODIFIES : BOM_MIXED_MODEL_MAP_RESOURCES
1439: --
1440: -- ==========================================================================

Line 1438: -- MODIFIES : BOM_MIXED_MODEL_MAP_RESOURCES

1434: -- to the given demand
1435: --
1436: -- Insert these values into the table BOM_MIXED_MODEL_MAP_RES.
1437: -- REQUIRES : err_text out buffer to return error message
1438: -- MODIFIES : BOM_MIXED_MODEL_MAP_RESOURCES
1439: --
1440: -- ==========================================================================
1441:
1442: PROCEDURE GetDetails (

Line 1721: insert into BOM_MIXED_MODEL_MAP_RES (

1717: l_stmt_num := 4;
1718: l_index := l_res_detail_table.FIRST;
1719: LOOP
1720: if l_res_detail_table(l_index).activity_id <> -1 then
1721: insert into BOM_MIXED_MODEL_MAP_RES (
1722: mixed_model_map_id,
1723: resource_id,
1724: resource_code,
1725: activity_id,

Line 1751: insert into BOM_MIXED_MODEL_MAP_RES (

1747: where ca.activity_id = l_res_detail_table(l_index).activity_id
1748: and bso.standard_operation_id = l_res_detail_table(l_index).standard_operation_id
1749: and br.resource_id = l_res_detail_table(l_index).resource_id;
1750: else
1751: insert into BOM_MIXED_MODEL_MAP_RES (
1752: mixed_model_map_id,
1753: resource_id,
1754: resource_code,
1755: activity_id,