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 737: ,px_attr_diffs IN OUT NOCOPY EGO_USER_ATTR_DIFF_TABLE

733: ,p_extension_id IN NUMBER DEFAULT NULL
734: ,p_entity_id IN NUMBER DEFAULT NULL
735: ,p_entity_index IN NUMBER DEFAULT NULL
736: ,p_entity_code IN VARCHAR2 DEFAULT NULL
737: ,px_attr_diffs IN OUT NOCOPY EGO_USER_ATTR_DIFF_TABLE
738: )
739: IS
740:
741: l_api_name VARCHAR2(30) := 'Get_Changed_Attributes';

Line 786: px_attr_diffs := EGO_USER_ATTR_DIFF_TABLE();

782: -- For the INSERT case, just record the new attribute values --
783: -----------------------------------------------------------------------
784: Debug_Msg(l_api_name||' insert', 1);
785:
786: px_attr_diffs := EGO_USER_ATTR_DIFF_TABLE();
787: l_attrs_index := p_attr_name_value_pairs.FIRST;
788: WHILE (l_attrs_index <= p_attr_name_value_pairs.LAST)
789: LOOP
790:

Line 840: px_attr_diffs := EGO_USER_ATTR_DIFF_TABLE();

836: -- which we then add to a table for later use in correlating a given --
837: -- Database Column to the appropriate Attribute and then building an --
838: -- Attr Data object for that Attr and its value. --
839: -----------------------------------------------------------------------
840: px_attr_diffs := EGO_USER_ATTR_DIFF_TABLE();
841: l_attrs_index := p_attr_name_value_pairs.FIRST;
842: WHILE (l_attrs_index <= p_attr_name_value_pairs.LAST)
843: LOOP
844:

Line 1226: px_attr_diffs := EGO_USER_ATTR_DIFF_TABLE();

1222: -- Start ssingal -For Ucc Net Attribute Propagation
1223: ELSIF (p_dml_operation = 'DELETE' ) THEN
1224: Debug_Msg(l_api_name||' Transaction Type is Delete ', 1);
1225:
1226: px_attr_diffs := EGO_USER_ATTR_DIFF_TABLE();
1227: l_attrs_index := p_attr_name_value_pairs.FIRST;
1228:
1229: WHILE (l_attrs_index <= p_attr_name_value_pairs.LAST)
1230: LOOP

Line 1295: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE

1291: PROCEDURE Propagate_Attributes (
1292: p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1293: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1294: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1295: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE
1296: , p_transaction_type IN VARCHAR2
1297: , p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
1298: , x_return_status OUT NOCOPY VARCHAR2
1299: , x_error_message OUT NOCOPY VARCHAR2

Line 1349: p_attr_diff_tbl IN EGO_USER_ATTR_DIFF_TABLE

1345: --
1346: -- Private
1347: --
1348: PROCEDURE Convert_Attr_Diff_To_Data (
1349: p_attr_diff_tbl IN EGO_USER_ATTR_DIFF_TABLE
1350: , px_attr_data_tbl IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
1351: , p_true_if_new IN BOOLEAN := TRUE
1352: -- px_is_delete returns true if this diff object contains a delete operation
1353: , px_is_delete OUT NOCOPY BOOLEAN

Line 6134: ,px_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE

6130: ,p_entity_index IN NUMBER
6131: ,p_entity_code IN VARCHAR2
6132: ,p_pre_event_flag IN VARCHAR2 DEFAULT NULL --4105841
6133: ,p_data_level_id IN VARCHAR2 DEFAULT NULL
6134: ,px_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE
6135: ) IS
6136:
6137: l_api_name CONSTANT VARCHAR2(30) := 'Raise_WF_Event_If_Enabled';
6138: l_event_name VARCHAR2(240);

Line 7293: ,px_attr_diffs IN OUT NOCOPY EGO_USER_ATTR_DIFF_TABLE

7289: ,p_entity_index IN NUMBER
7290: ,p_entity_code IN VARCHAR2
7291: ,p_commit IN VARCHAR2
7292: ,p_bulkload_flag IN BOOLEAN DEFAULT FALSE
7293: ,px_attr_diffs IN OUT NOCOPY EGO_USER_ATTR_DIFF_TABLE
7294: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
7295: ,x_extension_id OUT NOCOPY NUMBER
7296: ,x_return_status OUT NOCOPY VARCHAR2
7297: ) IS

Line 7333: l_attr_diffs_event EGO_USER_ATTR_DIFF_TABLE;

7329: l_parameter_list WF_PARAMETER_LIST_T := WF_PARAMETER_LIST_T();
7330: l_parameter_t WF_PARAMETER_T:= WF_PARAMETER_T(null, null);
7331:
7332: l_propagate_hierarchy BOOLEAN := TRUE;
7333: l_attr_diffs_event EGO_USER_ATTR_DIFF_TABLE;
7334: l_pre_raise_flag VARCHAR2(1); --4105841
7335:
7336: l_extra_col_names VARCHAR2(10000);
7337: l_extra_col_values VARCHAR2(10000);

Line 8200: ,px_attr_diffs IN OUT NOCOPY EGO_USER_ATTR_DIFF_TABLE

8196: ,p_entity_index IN NUMBER
8197: ,p_entity_code IN VARCHAR2
8198: ,p_commit IN VARCHAR2
8199: ,p_bulkload_flag IN BOOLEAN DEFAULT FALSE
8200: ,px_attr_diffs IN OUT NOCOPY EGO_USER_ATTR_DIFF_TABLE
8201: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
8202: ,x_return_status OUT NOCOPY VARCHAR2
8203: ) IS
8204:

Line 8232: l_attr_diffs_event EGO_USER_ATTR_DIFF_TABLE;

8228: l_parameter_t WF_PARAMETER_T:= WF_PARAMETER_T(null, null);
8229: l_error_message VARCHAR2(4000);
8230: l_propagate_hierarchy BOOLEAN := TRUE;
8231: --Start 4105841
8232: l_attr_diffs_event EGO_USER_ATTR_DIFF_TABLE;
8233: l_pre_event_flag VARCHAR2(1);
8234: --End 4105841
8235: ctr NUMBER;
8236: l_index NUMBER;

Line 8845: ,px_attr_diffs IN OUT NOCOPY EGO_USER_ATTR_DIFF_TABLE

8841: ,p_pending_tl_table_name IN VARCHAR2
8842: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_TRUE
8843: -- Start ssingal -For Ucc Net Attribute Propagation
8844: ,p_bulkload_flag IN BOOLEAN DEFAULT FALSE
8845: ,px_attr_diffs IN OUT NOCOPY EGO_USER_ATTR_DIFF_TABLE
8846: -- End ssingal -For Ucc Net Attribute Propagation
8847: ,p_entity_id IN VARCHAR2
8848: ,p_entity_index IN NUMBER
8849: ,p_entity_code IN VARCHAR2

Line 8876: l_attr_diffs_event EGO_USER_ATTR_DIFF_TABLE;

8872: -- Start ssingal -For Ucc Net Attribute Propagation
8873: l_propagate_hierarchy BOOLEAN :=TRUE;
8874: -- End ssingal -For Ucc Net Attribute Propagation
8875: --Start 4105841
8876: l_attr_diffs_event EGO_USER_ATTR_DIFF_TABLE;
8877: l_extra_col_where_string VARCHAR2(1000);
8878: l_index NUMBER;
8879: l_data_level_id NUMBER;
8880:

Line 9661: l_attr_diffs EGO_USER_ATTR_DIFF_TABLE := EGO_USER_ATTR_DIFF_TABLE();

9657: --we don't use l_api_version yet, but eventually we might:
9658: --if we change required parameters, version goes FROM n.x to (n+1).x
9659: --if we change optional parameters, version goes FROM x.n to x.(n+1)
9660: l_api_version CONSTANT NUMBER := 1.0;
9661: l_attr_diffs EGO_USER_ATTR_DIFF_TABLE := EGO_USER_ATTR_DIFF_TABLE();
9662:
9663: BEGIN
9664:
9665: Debug_Msg(l_api_name || ' starting with p_data_level '||p_data_level, 1);

Line 16761: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE

16757: p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16758: , p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16759: , p_data_level IN VARCHAR2 DEFAULT NULL
16760: , p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16761: , p_attr_diffs IN EGO_USER_ATTR_DIFF_TABLE
16762: , p_transaction_type IN VARCHAR2
16763: , p_attr_group_id IN NUMBER DEFAULT NULL
16764: , x_error_message OUT NOCOPY VARCHAR2
16765: )

Line 16926: , px_attr_diffs IN OUT NOCOPY EGO_USER_ATTR_DIFF_TABLE

16922: , p_attr_group_id IN NUMBER DEFAULT NULL
16923: , p_application_id IN NUMBER DEFAULT NULL
16924: , p_attr_group_type IN VARCHAR2 DEFAULT NULL
16925: , p_attr_group_name IN VARCHAR2 DEFAULT NULL
16926: , px_attr_diffs IN OUT NOCOPY EGO_USER_ATTR_DIFF_TABLE
16927: , x_error_message OUT NOCOPY VARCHAR2
16928: )
16929: IS
16930: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;

Line 16936: l_attr_diffs EGO_USER_ATTR_DIFF_TABLE;

16932: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
16933: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
16934: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
16935: l_object_id NUMBER;
16936: l_attr_diffs EGO_USER_ATTR_DIFF_TABLE;
16937:
16938: BEGIN
16939:
16940: Debug_Msg('In Get_Attr_Diffs, starting');

Line 17008: px_attr_diffs := EGO_USER_ATTR_DIFF_TABLE();

17004: l_attr_diffs(i).old_attr_uom IS NOT NULL OR
17005: l_attr_diffs(i).new_attr_uom IS NOT NULL) THEN
17006:
17007: IF px_attr_diffs IS NULL THEN
17008: px_attr_diffs := EGO_USER_ATTR_DIFF_TABLE();
17009: END IF;
17010:
17011: px_attr_diffs.EXTEND();
17012: px_attr_diffs(px_attr_diffs.LAST) := l_attr_diffs(i);