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.EGO_USER_ATTRS_DATA_PVT dependencies on EGO_USER_ATTR_DIFF_TABLE

Line 637: ,px_attr_diffs IN OUT NOCOPY EGO_USER_ATTR_DIFF_TABLE

633: ,p_extension_id IN NUMBER DEFAULT NULL
634: ,p_entity_id IN NUMBER DEFAULT NULL
635: ,p_entity_index IN NUMBER DEFAULT NULL
636: ,p_entity_code IN VARCHAR2 DEFAULT NULL
637: ,px_attr_diffs IN OUT NOCOPY EGO_USER_ATTR_DIFF_TABLE
638: )
639: IS
640:
641: l_api_name VARCHAR2(30) := 'Get_Changed_Attributes';

Line 686: px_attr_diffs := EGO_USER_ATTR_DIFF_TABLE();

682: -- For the INSERT case, just record the new attribute values --
683: -----------------------------------------------------------------------
684: Debug_Msg(l_api_name||' insert', 1);
685:
686: px_attr_diffs := EGO_USER_ATTR_DIFF_TABLE();
687: l_attrs_index := p_attr_name_value_pairs.FIRST;
688: WHILE (l_attrs_index <= p_attr_name_value_pairs.LAST)
689: LOOP
690:

Line 740: px_attr_diffs := EGO_USER_ATTR_DIFF_TABLE();

736: -- which we then add to a table for later use in correlating a given --
737: -- Database Column to the appropriate Attribute and then building an --
738: -- Attr Data object for that Attr and its value. --
739: -----------------------------------------------------------------------
740: px_attr_diffs := EGO_USER_ATTR_DIFF_TABLE();
741: l_attrs_index := p_attr_name_value_pairs.FIRST;
742: WHILE (l_attrs_index <= p_attr_name_value_pairs.LAST)
743: LOOP
744:

Line 1126: px_attr_diffs := EGO_USER_ATTR_DIFF_TABLE();

1122: -- Start ssingal -For Ucc Net Attribute Propagation
1123: ELSIF (p_dml_operation = 'DELETE' ) THEN
1124: Debug_Msg(l_api_name||' Transaction Type is Delete ', 1);
1125:
1126: px_attr_diffs := EGO_USER_ATTR_DIFF_TABLE();
1127: l_attrs_index := p_attr_name_value_pairs.FIRST;
1128:
1129: WHILE (l_attrs_index <= p_attr_name_value_pairs.LAST)
1130: LOOP

Line 1195: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE

1191: PROCEDURE Propagate_Attributes (
1192: p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1193: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1194: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1195: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE
1196: , p_transaction_type IN VARCHAR2
1197: , p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
1198: , x_return_status OUT NOCOPY VARCHAR2
1199: , x_error_message OUT NOCOPY VARCHAR2

Line 1249: p_attr_diff_tbl IN EGO_USER_ATTR_DIFF_TABLE

1245: --
1246: -- Private
1247: --
1248: PROCEDURE Convert_Attr_Diff_To_Data (
1249: p_attr_diff_tbl IN EGO_USER_ATTR_DIFF_TABLE
1250: , px_attr_data_tbl IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
1251: , p_true_if_new IN BOOLEAN := TRUE
1252: -- px_is_delete returns true if this diff object contains a delete operation
1253: , px_is_delete OUT NOCOPY BOOLEAN

Line 5639: ,px_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE

5635: ,p_entity_index IN NUMBER
5636: ,p_entity_code IN VARCHAR2
5637: ,p_pre_event_flag IN VARCHAR2 DEFAULT NULL --4105841
5638: ,p_data_level_id IN VARCHAR2 DEFAULT NULL
5639: ,px_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE
5640: ) IS
5641:
5642: l_api_name CONSTANT VARCHAR2(30) := 'Raise_WF_Event_If_Enabled';
5643: l_event_name VARCHAR2(240);

Line 6779: ,px_attr_diffs IN OUT NOCOPY EGO_USER_ATTR_DIFF_TABLE

6775: ,p_entity_index IN NUMBER
6776: ,p_entity_code IN VARCHAR2
6777: ,p_commit IN VARCHAR2
6778: ,p_bulkload_flag IN BOOLEAN DEFAULT FALSE
6779: ,px_attr_diffs IN OUT NOCOPY EGO_USER_ATTR_DIFF_TABLE
6780: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
6781: ,x_extension_id OUT NOCOPY NUMBER
6782: ,x_return_status OUT NOCOPY VARCHAR2
6783: ) IS

Line 6819: l_attr_diffs_event EGO_USER_ATTR_DIFF_TABLE;

6815: l_parameter_list WF_PARAMETER_LIST_T := WF_PARAMETER_LIST_T();
6816: l_parameter_t WF_PARAMETER_T:= WF_PARAMETER_T(null, null);
6817:
6818: l_propagate_hierarchy BOOLEAN := TRUE;
6819: l_attr_diffs_event EGO_USER_ATTR_DIFF_TABLE;
6820: l_pre_raise_flag VARCHAR2(1); --4105841
6821:
6822: l_extra_col_names VARCHAR2(10000);
6823: l_extra_col_values VARCHAR2(10000);

Line 7647: ,px_attr_diffs IN OUT NOCOPY EGO_USER_ATTR_DIFF_TABLE

7643: ,p_entity_index IN NUMBER
7644: ,p_entity_code IN VARCHAR2
7645: ,p_commit IN VARCHAR2
7646: ,p_bulkload_flag IN BOOLEAN DEFAULT FALSE
7647: ,px_attr_diffs IN OUT NOCOPY EGO_USER_ATTR_DIFF_TABLE
7648: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
7649: ,x_return_status OUT NOCOPY VARCHAR2
7650: ) IS
7651:

Line 7679: l_attr_diffs_event EGO_USER_ATTR_DIFF_TABLE;

7675: l_parameter_t WF_PARAMETER_T:= WF_PARAMETER_T(null, null);
7676: l_error_message VARCHAR2(4000);
7677: l_propagate_hierarchy BOOLEAN := TRUE;
7678: --Start 4105841
7679: l_attr_diffs_event EGO_USER_ATTR_DIFF_TABLE;
7680: l_pre_event_flag VARCHAR2(1);
7681: --End 4105841
7682: ctr NUMBER;
7683: l_index NUMBER;

Line 8266: ,px_attr_diffs IN OUT NOCOPY EGO_USER_ATTR_DIFF_TABLE

8262: ,p_pending_tl_table_name IN VARCHAR2
8263: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_TRUE
8264: -- Start ssingal -For Ucc Net Attribute Propagation
8265: ,p_bulkload_flag IN BOOLEAN DEFAULT FALSE
8266: ,px_attr_diffs IN OUT NOCOPY EGO_USER_ATTR_DIFF_TABLE
8267: -- End ssingal -For Ucc Net Attribute Propagation
8268: ,p_entity_id IN VARCHAR2
8269: ,p_entity_index IN NUMBER
8270: ,p_entity_code IN VARCHAR2

Line 8297: l_attr_diffs_event EGO_USER_ATTR_DIFF_TABLE;

8293: -- Start ssingal -For Ucc Net Attribute Propagation
8294: l_propagate_hierarchy BOOLEAN :=TRUE;
8295: -- End ssingal -For Ucc Net Attribute Propagation
8296: --Start 4105841
8297: l_attr_diffs_event EGO_USER_ATTR_DIFF_TABLE;
8298: l_extra_col_where_string VARCHAR2(1000);
8299: l_index NUMBER;
8300: l_data_level_id NUMBER;
8301:

Line 9082: l_attr_diffs EGO_USER_ATTR_DIFF_TABLE := EGO_USER_ATTR_DIFF_TABLE();

9078: --we don't use l_api_version yet, but eventually we might:
9079: --if we change required parameters, version goes FROM n.x to (n+1).x
9080: --if we change optional parameters, version goes FROM x.n to x.(n+1)
9081: l_api_version CONSTANT NUMBER := 1.0;
9082: l_attr_diffs EGO_USER_ATTR_DIFF_TABLE := EGO_USER_ATTR_DIFF_TABLE();
9083:
9084: BEGIN
9085:
9086: Debug_Msg(l_api_name || ' starting with p_data_level '||p_data_level, 1);

Line 15600: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE

15596: p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
15597: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
15598: , p_data_level IN VARCHAR2 DEFAULT NULL
15599: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
15600: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE
15601: , p_transaction_type IN VARCHAR2
15602: , p_attr_group_id IN NUMBER DEFAULT NULL
15603: , x_error_message OUT NOCOPY VARCHAR2
15604: )

Line 15765: , px_attr_diffs IN OUT NOCOPY EGO_USER_ATTR_DIFF_TABLE

15761: , p_attr_group_id IN NUMBER DEFAULT NULL
15762: , p_application_id IN NUMBER DEFAULT NULL
15763: , p_attr_group_type IN VARCHAR2 DEFAULT NULL
15764: , p_attr_group_name IN VARCHAR2 DEFAULT NULL
15765: , px_attr_diffs IN OUT NOCOPY EGO_USER_ATTR_DIFF_TABLE
15766: , x_error_message OUT NOCOPY VARCHAR2
15767: )
15768: IS
15769: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;

Line 15775: l_attr_diffs EGO_USER_ATTR_DIFF_TABLE;

15771: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
15772: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
15773: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
15774: l_object_id NUMBER;
15775: l_attr_diffs EGO_USER_ATTR_DIFF_TABLE;
15776:
15777: BEGIN
15778:
15779: Debug_Msg('In Get_Attr_Diffs, starting');

Line 15847: px_attr_diffs := EGO_USER_ATTR_DIFF_TABLE();

15843: l_attr_diffs(i).old_attr_uom IS NOT NULL OR
15844: l_attr_diffs(i).new_attr_uom IS NOT NULL) THEN
15845:
15846: IF px_attr_diffs IS NULL THEN
15847: px_attr_diffs := EGO_USER_ATTR_DIFF_TABLE();
15848: END IF;
15849:
15850: px_attr_diffs.EXTEND();
15851: px_attr_diffs(px_attr_diffs.LAST) := l_attr_diffs(i);