eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_ROLLUP_PUB dependencies on BOM_ROLLUP_PUB

Line 1: PACKAGE BODY Bom_Rollup_Pub AS

1: PACKAGE BODY Bom_Rollup_Pub AS
2: /* $Header: BOMRLUPB.pls 120.7.12020000.2 2012/07/13 01:49:42 mshirkol ship $ */
3: /***************************************************************************
4: --
5: -- Copyright (c) 1996 Oracle Corporation, Redwood Shores, CA, USA

Line 14: -- Body of package Bom_Rollup_Pub

10: -- BOMRLUPB.pls
11: --
12: -- DESCRIPTION
13: --
14: -- Body of package Bom_Rollup_Pub
15: --
16: -- NOTES
17: -- Rollup will happen on the objects within a BOM. Every object would have a
18: -- Attribute Map, with every attribute identifying the compute function. If the

Line 38: pG_Attribute_Map Bom_Rollup_Pub.Attribute_Map;

34: ***************************************************************************/
35:
36:
37: /* Package Globals */
38: pG_Attribute_Map Bom_Rollup_Pub.Attribute_Map;
39: pG_Rollup_Action_Map Bom_Rollup_Pub.Rollup_Action_Map;
40:
41: pG_Item_Org_Tbl Bom_Rollup_Pub.Item_Org_Tbl;
42:

Line 39: pG_Rollup_Action_Map Bom_Rollup_Pub.Rollup_Action_Map;

35:
36:
37: /* Package Globals */
38: pG_Attribute_Map Bom_Rollup_Pub.Attribute_Map;
39: pG_Rollup_Action_Map Bom_Rollup_Pub.Rollup_Action_Map;
40:
41: pG_Item_Org_Tbl Bom_Rollup_Pub.Item_Org_Tbl;
42:
43: /****************** Local procedures Section ******************/

Line 41: pG_Item_Org_Tbl Bom_Rollup_Pub.Item_Org_Tbl;

37: /* Package Globals */
38: pG_Attribute_Map Bom_Rollup_Pub.Attribute_Map;
39: pG_Rollup_Action_Map Bom_Rollup_Pub.Rollup_Action_Map;
40:
41: pG_Item_Org_Tbl Bom_Rollup_Pub.Item_Org_Tbl;
42:
43: /****************** Local procedures Section ******************/
44:
45:

Line 557: , p_action_map IN Bom_Rollup_Pub.Rollup_Action_Map

553: PROCEDURE Handle_Attribute_Updates
554: ( p_Header_Item_Id IN NUMBER
555: , p_Organization_Id IN NUMBER
556: , p_Header_Attrs_Flag IN VARCHAR2
557: , p_action_map IN Bom_Rollup_Pub.Rollup_Action_Map
558: , x_return_status OUT NOCOPY VARCHAR2
559: , x_msg_count OUT NOCOPY NUMBER
560: , x_msg_data OUT NOCOPY VARCHAR2
561: )

Line 625: , p_action_map IN Bom_Rollup_Pub.Rollup_Action_Map

621: Get_Current_Organization_Id.
622: */
623: PROCEDURE Handle_Rollup_Actions
624: ( p_rollup_id IN NUMBER
625: , p_action_map IN Bom_Rollup_Pub.Rollup_Action_Map
626: , p_item_id IN NUMBER
627: , p_organization_id IN NUMBER
628: , p_parent_item_id IN NUMBER := NULL -- passed in if add/delete comp case
629: , p_component_item_id IN NUMBER := NULL -- passed in if add/delete comp case

Line 647: l_Component_Attrs Bom_Rollup_Pub.Attribute_Map;

643: WHERE
644: group_id = p_rollup_id;
645:
646: l_depth number;
647: l_Component_Attrs Bom_Rollup_Pub.Attribute_Map;
648:
649: CURSOR c_assy_csr(
650: p_level NUMBER
651: , p_rollup_id NUMBER

Line 1232: IF l_assy_rec.inventory_item_id = Bom_Rollup_Pub.Get_top_Item_Id

1228: -- write the data for that sub-tree node.
1229: --
1230:
1231: -- For the TOP Item also process the attributes only maintained at the top level.
1232: IF l_assy_rec.inventory_item_id = Bom_Rollup_Pub.Get_top_Item_Id
1233: THEN
1234: Handle_Attribute_Updates( p_Header_Item_Id => l_assy_rec.inventory_item_id
1235: , p_organization_id => p_organization_id
1236: , p_header_attrs_flag => 'N'

Line 1283: , p_action_map IN Bom_Rollup_Pub.Rollup_Action_Map := G_EMPTY_ACTION_MAP

1279: ( p_item_id IN NUMBER
1280: , p_organization_id IN NUMBER
1281: , p_parent_item_id IN NUMBER
1282: , p_structure_type_id IN NUMBER
1283: , p_action_map IN Bom_Rollup_Pub.Rollup_Action_Map := G_EMPTY_ACTION_MAP
1284: , p_validate IN VARCHAR2
1285: , p_halt_on_error IN VARCHAR2
1286: , x_error_message OUT NOCOPY VARCHAR2
1287: )

Line 1390: if (Bom_Rollup_Pub.g_attr_diffs is null) then

1386: l_rollup_item_id number;
1387: l_return_status VARCHAR2(1);
1388: l_msg_count NUMBER;
1389: BEGIN
1390: if (Bom_Rollup_Pub.g_attr_diffs is null) then
1391: --Initialize Error Hanlder
1392: Initialize_ErrorDebug_Handler;
1393: end if;
1394:

Line 1615: , p_action_map IN Bom_Rollup_Pub.Rollup_Action_Map := G_EMPTY_ACTION_MAP

1611: PROCEDURE Perform_Rollup_Private
1612: ( p_item_id IN NUMBER
1613: , p_organization_id IN NUMBER
1614: , p_alternate_bom_code IN VARCHAR2
1615: , p_action_map IN Bom_Rollup_Pub.Rollup_Action_Map := G_EMPTY_ACTION_MAP
1616: , p_validate IN VARCHAR2
1617: , p_halt_on_error IN VARCHAR2
1618: , x_error_message OUT NOCOPY VARCHAR2
1619: )

Line 1634: if (Bom_Rollup_Pub.g_attr_diffs is null) then

1630: l_Sequence NUMBER;
1631: l_return_status VARCHAR2(1);
1632: l_msg_count NUMBER;
1633: BEGIN
1634: if (Bom_Rollup_Pub.g_attr_diffs is null) then
1635: --Initialize Error Hanlder
1636: Initialize_ErrorDebug_Handler;
1637: end if;
1638:

Line 1760: , p_action_map IN Bom_Rollup_Pub.Rollup_Action_Map DEFAULT G_EMPTY_ACTION_MAP

1756: PROCEDURE Perform_Rollup
1757: ( p_item_id IN NUMBER
1758: , p_organization_id IN NUMBER
1759: , p_alternate_bom_code IN VARCHAR2
1760: , p_action_map IN Bom_Rollup_Pub.Rollup_Action_Map DEFAULT G_EMPTY_ACTION_MAP
1761: , p_validate IN VARCHAR2 /*DEFAULT 'N'*/
1762: , p_halt_on_error IN VARCHAR2 /*DEFAULT 'N'*/
1763: , x_error_message OUT NOCOPY VARCHAR2
1764: )

Line 1796: , p_action_map IN Bom_Rollup_Pub.Rollup_Action_Map := G_EMPTY_ACTION_MAP

1792: ( p_item_id IN NUMBER
1793: , p_organization_id IN NUMBER
1794: , p_parent_item_id IN NUMBER := NULL
1795: , p_structure_type_id IN NUMBER
1796: , p_action_map IN Bom_Rollup_Pub.Rollup_Action_Map := G_EMPTY_ACTION_MAP
1797: , p_validate IN VARCHAR2 /*DEFAULT 'N'*/
1798: , p_halt_on_error IN VARCHAR2 /*DEFAULT 'N'*/
1799: , x_error_message OUT NOCOPY VARCHAR2
1800: )

Line 1832: , p_action_map IN Bom_Rollup_Pub.Rollup_Action_Map := G_EMPTY_ACTION_MAP

1828: ( p_item_id IN NUMBER
1829: , p_organization_id IN NUMBER
1830: , p_parent_item_id IN NUMBER := NULL
1831: , p_structure_type_name IN VARCHAR2
1832: , p_action_map IN Bom_Rollup_Pub.Rollup_Action_Map := G_EMPTY_ACTION_MAP
1833: , p_validate IN VARCHAR2 /*DEFAULT 'N'*/
1834: , p_halt_on_error IN VARCHAR2 /*DEFAULT 'N'*/
1835: , x_error_message OUT NOCOPY VARCHAR2
1836: )

Line 1892: , x_Rollup_Action_Map IN OUT NOCOPY Bom_Rollup_Pub.Rollup_Action_Map

1888: ( p_Object_Name IN VARCHAR2
1889: , p_Rollup_Action IN VARCHAR2
1890: , p_DML_Function IN VARCHAR2
1891: , p_DML_Delayed_Write IN VARCHAR2
1892: , x_Rollup_Action_Map IN OUT NOCOPY Bom_Rollup_Pub.Rollup_Action_Map
1893: )
1894: IS
1895: l_map_index NUMBER := x_Rollup_Action_Map.COUNT + 1;
1896: BEGIN

Line 1926: RETURN Bom_Rollup_Pub.Rollup_Action_Map

1922: *
1923: ************************************************************************/
1924: Function Get_Item_Rollup_Map
1925: ( p_Object_Name IN VARCHAR2 )
1926: RETURN Bom_Rollup_Pub.Rollup_Action_Map
1927: IS
1928: BEGIN
1929: return G_EMPTY_ACTION_MAP;
1930: -- not implemented yet.

Line 2016: FOR cmp_index IN Bom_Rollup_Pub.l_component_seq_attrs_tbl.FIRST..Bom_Rollup_Pub.l_component_seq_attrs_tbl.LAST

2012: )
2013: RETURN VARCHAR2
2014: IS
2015: BEGIN
2016: FOR cmp_index IN Bom_Rollup_Pub.l_component_seq_attrs_tbl.FIRST..Bom_Rollup_Pub.l_component_seq_attrs_tbl.LAST
2017: LOOP
2018: IF Bom_Rollup_Pub.l_component_seq_attrs_tbl.EXISTS(cmp_index) AND
2019: Bom_Rollup_Pub.l_component_seq_attrs_tbl(cmp_index).component_sequence_id = p_component_sequence_id AND
2020: Bom_Rollup_Pub.l_component_seq_attrs_tbl(cmp_index).attribute_name = p_attribute_name

Line 2018: IF Bom_Rollup_Pub.l_component_seq_attrs_tbl.EXISTS(cmp_index) AND

2014: IS
2015: BEGIN
2016: FOR cmp_index IN Bom_Rollup_Pub.l_component_seq_attrs_tbl.FIRST..Bom_Rollup_Pub.l_component_seq_attrs_tbl.LAST
2017: LOOP
2018: IF Bom_Rollup_Pub.l_component_seq_attrs_tbl.EXISTS(cmp_index) AND
2019: Bom_Rollup_Pub.l_component_seq_attrs_tbl(cmp_index).component_sequence_id = p_component_sequence_id AND
2020: Bom_Rollup_Pub.l_component_seq_attrs_tbl(cmp_index).attribute_name = p_attribute_name
2021: THEN
2022: return Bom_Rollup_Pub.l_component_seq_attrs_tbl(cmp_index).attribute_value;

Line 2019: Bom_Rollup_Pub.l_component_seq_attrs_tbl(cmp_index).component_sequence_id = p_component_sequence_id AND

2015: BEGIN
2016: FOR cmp_index IN Bom_Rollup_Pub.l_component_seq_attrs_tbl.FIRST..Bom_Rollup_Pub.l_component_seq_attrs_tbl.LAST
2017: LOOP
2018: IF Bom_Rollup_Pub.l_component_seq_attrs_tbl.EXISTS(cmp_index) AND
2019: Bom_Rollup_Pub.l_component_seq_attrs_tbl(cmp_index).component_sequence_id = p_component_sequence_id AND
2020: Bom_Rollup_Pub.l_component_seq_attrs_tbl(cmp_index).attribute_name = p_attribute_name
2021: THEN
2022: return Bom_Rollup_Pub.l_component_seq_attrs_tbl(cmp_index).attribute_value;
2023: END IF;

Line 2020: Bom_Rollup_Pub.l_component_seq_attrs_tbl(cmp_index).attribute_name = p_attribute_name

2016: FOR cmp_index IN Bom_Rollup_Pub.l_component_seq_attrs_tbl.FIRST..Bom_Rollup_Pub.l_component_seq_attrs_tbl.LAST
2017: LOOP
2018: IF Bom_Rollup_Pub.l_component_seq_attrs_tbl.EXISTS(cmp_index) AND
2019: Bom_Rollup_Pub.l_component_seq_attrs_tbl(cmp_index).component_sequence_id = p_component_sequence_id AND
2020: Bom_Rollup_Pub.l_component_seq_attrs_tbl(cmp_index).attribute_name = p_attribute_name
2021: THEN
2022: return Bom_Rollup_Pub.l_component_seq_attrs_tbl(cmp_index).attribute_value;
2023: END IF;
2024: END LOOP;

Line 2022: return Bom_Rollup_Pub.l_component_seq_attrs_tbl(cmp_index).attribute_value;

2018: IF Bom_Rollup_Pub.l_component_seq_attrs_tbl.EXISTS(cmp_index) AND
2019: Bom_Rollup_Pub.l_component_seq_attrs_tbl(cmp_index).component_sequence_id = p_component_sequence_id AND
2020: Bom_Rollup_Pub.l_component_seq_attrs_tbl(cmp_index).attribute_name = p_attribute_name
2021: THEN
2022: return Bom_Rollup_Pub.l_component_seq_attrs_tbl(cmp_index).attribute_value;
2023: END IF;
2024: END LOOP;
2025:
2026: END Get_Attribute_Value;

Line 2044: IF Bom_Rollup_Pub.l_Top_Item_Attrs_Map.COUNT = 0

2040: )
2041: RETURN VARCHAR2
2042: IS
2043: BEGIN
2044: IF Bom_Rollup_Pub.l_Top_Item_Attrs_Map.COUNT = 0
2045: THEN
2046: RETURN NULL;
2047: END IF;
2048:

Line 2049: FOR cmp_index IN Bom_Rollup_Pub.l_Top_Item_Attrs_Map.FIRST..Bom_Rollup_Pub.l_Top_Item_Attrs_Map.LAST

2045: THEN
2046: RETURN NULL;
2047: END IF;
2048:
2049: FOR cmp_index IN Bom_Rollup_Pub.l_Top_Item_Attrs_Map.FIRST..Bom_Rollup_Pub.l_Top_Item_Attrs_Map.LAST
2050: LOOP
2051: IF Bom_Rollup_Pub.l_Top_Item_Attrs_Map.EXISTS(cmp_index) AND
2052: Bom_Rollup_Pub.l_Top_Item_Attrs_Map(cmp_index).attribute_name = p_attribute_name
2053: THEN

Line 2051: IF Bom_Rollup_Pub.l_Top_Item_Attrs_Map.EXISTS(cmp_index) AND

2047: END IF;
2048:
2049: FOR cmp_index IN Bom_Rollup_Pub.l_Top_Item_Attrs_Map.FIRST..Bom_Rollup_Pub.l_Top_Item_Attrs_Map.LAST
2050: LOOP
2051: IF Bom_Rollup_Pub.l_Top_Item_Attrs_Map.EXISTS(cmp_index) AND
2052: Bom_Rollup_Pub.l_Top_Item_Attrs_Map(cmp_index).attribute_name = p_attribute_name
2053: THEN
2054: return Bom_Rollup_Pub.l_Top_Item_Attrs_Map(cmp_index).attribute_value;
2055: END IF;

Line 2052: Bom_Rollup_Pub.l_Top_Item_Attrs_Map(cmp_index).attribute_name = p_attribute_name

2048:
2049: FOR cmp_index IN Bom_Rollup_Pub.l_Top_Item_Attrs_Map.FIRST..Bom_Rollup_Pub.l_Top_Item_Attrs_Map.LAST
2050: LOOP
2051: IF Bom_Rollup_Pub.l_Top_Item_Attrs_Map.EXISTS(cmp_index) AND
2052: Bom_Rollup_Pub.l_Top_Item_Attrs_Map(cmp_index).attribute_name = p_attribute_name
2053: THEN
2054: return Bom_Rollup_Pub.l_Top_Item_Attrs_Map(cmp_index).attribute_value;
2055: END IF;
2056: END LOOP;

Line 2054: return Bom_Rollup_Pub.l_Top_Item_Attrs_Map(cmp_index).attribute_value;

2050: LOOP
2051: IF Bom_Rollup_Pub.l_Top_Item_Attrs_Map.EXISTS(cmp_index) AND
2052: Bom_Rollup_Pub.l_Top_Item_Attrs_Map(cmp_index).attribute_name = p_attribute_name
2053: THEN
2054: return Bom_Rollup_Pub.l_Top_Item_Attrs_Map(cmp_index).attribute_value;
2055: END IF;
2056: END LOOP;
2057:
2058: -- else return NULL

Line 2082: , p_action_map IN Bom_Rollup_Pub.Rollup_Action_Map DEFAULT G_EMPTY_ACTION_MAP

2078: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2079: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE
2080: , p_transaction_type IN VARCHAR2
2081: , p_attr_group_id IN NUMBER
2082: , p_action_map IN Bom_Rollup_Pub.Rollup_Action_Map DEFAULT G_EMPTY_ACTION_MAP
2083: , x_error_message OUT NOCOPY VARCHAR2
2084: ) is
2085: begin
2086:

Line 2094: Bom_Rollup_Pub.g_pk_column_name_value_pairs := p_pk_column_name_value_pairs;

2090: p_bo_identifier => G_BO_IDENTIFIER
2091: , p_message => 'INSIDE Multi-Row Item Call');
2092:
2093: IF (p_attr_diffs IS NOT NULL AND p_attr_diffs.COUNT > 0) THEN -- is the object null
2094: Bom_Rollup_Pub.g_pk_column_name_value_pairs := p_pk_column_name_value_pairs;
2095: Bom_Rollup_Pub.g_class_code_name_value_pairs := p_class_code_name_value_pairs;
2096: Bom_Rollup_Pub.g_data_level_name_value_pairs := p_data_level_name_value_pairs;
2097: Bom_Rollup_Pub.g_attr_diffs := p_attr_diffs;
2098: Bom_Rollup_Pub.g_transaction_type := p_transaction_type;

Line 2095: Bom_Rollup_Pub.g_class_code_name_value_pairs := p_class_code_name_value_pairs;

2091: , p_message => 'INSIDE Multi-Row Item Call');
2092:
2093: IF (p_attr_diffs IS NOT NULL AND p_attr_diffs.COUNT > 0) THEN -- is the object null
2094: Bom_Rollup_Pub.g_pk_column_name_value_pairs := p_pk_column_name_value_pairs;
2095: Bom_Rollup_Pub.g_class_code_name_value_pairs := p_class_code_name_value_pairs;
2096: Bom_Rollup_Pub.g_data_level_name_value_pairs := p_data_level_name_value_pairs;
2097: Bom_Rollup_Pub.g_attr_diffs := p_attr_diffs;
2098: Bom_Rollup_Pub.g_transaction_type := p_transaction_type;
2099: Bom_Rollup_Pub.g_attr_group_id := p_attr_group_id;

Line 2096: Bom_Rollup_Pub.g_data_level_name_value_pairs := p_data_level_name_value_pairs;

2092:
2093: IF (p_attr_diffs IS NOT NULL AND p_attr_diffs.COUNT > 0) THEN -- is the object null
2094: Bom_Rollup_Pub.g_pk_column_name_value_pairs := p_pk_column_name_value_pairs;
2095: Bom_Rollup_Pub.g_class_code_name_value_pairs := p_class_code_name_value_pairs;
2096: Bom_Rollup_Pub.g_data_level_name_value_pairs := p_data_level_name_value_pairs;
2097: Bom_Rollup_Pub.g_attr_diffs := p_attr_diffs;
2098: Bom_Rollup_Pub.g_transaction_type := p_transaction_type;
2099: Bom_Rollup_Pub.g_attr_group_id := p_attr_group_id;
2100: WRITE_DEBUG_LOG (

Line 2097: Bom_Rollup_Pub.g_attr_diffs := p_attr_diffs;

2093: IF (p_attr_diffs IS NOT NULL AND p_attr_diffs.COUNT > 0) THEN -- is the object null
2094: Bom_Rollup_Pub.g_pk_column_name_value_pairs := p_pk_column_name_value_pairs;
2095: Bom_Rollup_Pub.g_class_code_name_value_pairs := p_class_code_name_value_pairs;
2096: Bom_Rollup_Pub.g_data_level_name_value_pairs := p_data_level_name_value_pairs;
2097: Bom_Rollup_Pub.g_attr_diffs := p_attr_diffs;
2098: Bom_Rollup_Pub.g_transaction_type := p_transaction_type;
2099: Bom_Rollup_Pub.g_attr_group_id := p_attr_group_id;
2100: WRITE_DEBUG_LOG (
2101: p_bo_identifier => G_BO_IDENTIFIER

Line 2098: Bom_Rollup_Pub.g_transaction_type := p_transaction_type;

2094: Bom_Rollup_Pub.g_pk_column_name_value_pairs := p_pk_column_name_value_pairs;
2095: Bom_Rollup_Pub.g_class_code_name_value_pairs := p_class_code_name_value_pairs;
2096: Bom_Rollup_Pub.g_data_level_name_value_pairs := p_data_level_name_value_pairs;
2097: Bom_Rollup_Pub.g_attr_diffs := p_attr_diffs;
2098: Bom_Rollup_Pub.g_transaction_type := p_transaction_type;
2099: Bom_Rollup_Pub.g_attr_group_id := p_attr_group_id;
2100: WRITE_DEBUG_LOG (
2101: p_bo_identifier => G_BO_IDENTIFIER
2102: , p_message => 'INSIDE Multi-Row Item Call with txn type' || p_transaction_type);

Line 2099: Bom_Rollup_Pub.g_attr_group_id := p_attr_group_id;

2095: Bom_Rollup_Pub.g_class_code_name_value_pairs := p_class_code_name_value_pairs;
2096: Bom_Rollup_Pub.g_data_level_name_value_pairs := p_data_level_name_value_pairs;
2097: Bom_Rollup_Pub.g_attr_diffs := p_attr_diffs;
2098: Bom_Rollup_Pub.g_transaction_type := p_transaction_type;
2099: Bom_Rollup_Pub.g_attr_group_id := p_attr_group_id;
2100: WRITE_DEBUG_LOG (
2101: p_bo_identifier => G_BO_IDENTIFIER
2102: , p_message => 'INSIDE Multi-Row Item Call with txn type' || p_transaction_type);
2103: END IF;

Line 2259: END Bom_Rollup_Pub;

2255: );
2256: END;
2257:
2258:
2259: END Bom_Rollup_Pub;