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_DATA_OBJ

Line 24: TYPE LOCAL_USER_ATTR_DATA_TABLE IS TABLE OF EGO_USER_ATTR_DATA_OBJ

20:
21: TYPE LOCAL_COL_NV_PAIR_TABLE IS TABLE OF EGO_COL_NAME_VALUE_PAIR_OBJ
22: INDEX BY BINARY_INTEGER;
23:
24: TYPE LOCAL_USER_ATTR_DATA_TABLE IS TABLE OF EGO_USER_ATTR_DATA_OBJ
25: INDEX BY BINARY_INTEGER;
26:
27: TYPE LOCAL_USER_ATTR_ROW_TABLE IS TABLE OF EGO_USER_ATTR_ROW_OBJ
28: INDEX BY BINARY_INTEGER;

Line 768: l_attr_name_value_rec EGO_USER_ATTR_DATA_OBJ;

764: l_cursor_id NUMBER;
765: l_extension_id NUMBER;
766: l_dummy NUMBER;
767:
768: l_attr_name_value_rec EGO_USER_ATTR_DATA_OBJ;
769: l_retrieved_value VARCHAR2(4000); --bug 12979914
770: l_data_type_codes_table LOCAL_VARCHAR_TABLE;
771: l_attr_diffs_last NUMBER;
772: l_data_level_id NUMBER;

Line 1390: EGO_USER_ATTR_DATA_OBJ

1386: px_attr_data_tbl.EXTEND;
1387:
1388: IF (p_true_if_new) THEN
1389: px_attr_data_tbl(i) :=
1390: EGO_USER_ATTR_DATA_OBJ
1391: ( l_row_identifier
1392: , p_attr_diff_tbl(i).ATTR_NAME
1393: , p_attr_diff_tbl(i).NEW_ATTR_VALUE_STR
1394: , p_attr_diff_tbl(i).NEW_ATTR_VALUE_NUM

Line 1402: EGO_USER_ATTR_DATA_OBJ

1398: , NULL--p_attr_diff_tbl(i).USER_ROW_IDENTIFIER
1399: );
1400: ELSE
1401: px_attr_data_tbl(i) :=
1402: EGO_USER_ATTR_DATA_OBJ
1403: ( l_row_identifier
1404: , p_attr_diff_tbl(i).ATTR_NAME
1405: , p_attr_diff_tbl(i).OLD_ATTR_VALUE_STR
1406: , p_attr_diff_tbl(i).OLD_ATTR_VALUE_NUM

Line 1454: l_current_data_element EGO_USER_ATTR_DATA_OBJ;

1450: IS
1451:
1452:
1453: l_attr_data_table_index NUMBER;
1454: l_current_data_element EGO_USER_ATTR_DATA_OBJ;
1455: l_current_row_id NUMBER;
1456: l_row_id_ordinality_table LOCAL_NUMBER_TABLE;
1457: l_row_id_ordinality NUMBER;
1458: l_sorted_data_index_table LOCAL_NUMBER_TABLE;

Line 1463: temp EGO_USER_ATTR_DATA_OBJ;

1459: l_s_a_d_table_index NUMBER;
1460: l_sorted_attr_data_table LOCAL_USER_ATTR_DATA_TABLE;
1461: l_sorted_row_id_table LOCAL_NUMBER_TABLE;
1462: l_sorted_data_element EGO_USER_ATTR_DATA_TABLE;
1463: temp EGO_USER_ATTR_DATA_OBJ;
1464:
1465: BEGIN
1466:
1467: Debug_Msg('In Build_Sorted_Data_Table, starting', 2);

Line 1878: RETURN EGO_USER_ATTR_DATA_OBJ

1874: FUNCTION Find_Name_Value_Pair_For_Attr (
1875: p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
1876: ,p_attr_name IN VARCHAR2
1877: )
1878: RETURN EGO_USER_ATTR_DATA_OBJ
1879: IS
1880:
1881: l_table_index NUMBER;
1882: l_attr_data_obj EGO_USER_ATTR_DATA_OBJ;

Line 1882: l_attr_data_obj EGO_USER_ATTR_DATA_OBJ;

1878: RETURN EGO_USER_ATTR_DATA_OBJ
1879: IS
1880:
1881: l_table_index NUMBER;
1882: l_attr_data_obj EGO_USER_ATTR_DATA_OBJ;
1883:
1884: BEGIN
1885:
1886: Debug_Msg('In Find_Name_Value_Pair_For_Attr, starting for p_attr_name '||p_attr_name, 2);

Line 1999: l_attr_data_obj EGO_USER_ATTR_DATA_OBJ;

1995: l_metadata_driven BOOLEAN;
1996: l_for_loop_index NUMBER;
1997: l_for_loop_last NUMBER;
1998: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
1999: l_attr_data_obj EGO_USER_ATTR_DATA_OBJ;
2000: l_unique_key_flag VARCHAR2(1);
2001: l_data_type VARCHAR2(1);
2002: l_column_name VARCHAR2(30);
2003: l_default_value EGO_ATTRS_V.DEFAULT_VALUE%TYPE;

Line 2559: l_replacement_attr_data EGO_USER_ATTR_DATA_OBJ;

2555: l_token_replacement VARCHAR2(4000); -- Bug 8757354
2556: l_token_data_type VARCHAR2(1);
2557: l_pk_array_index NUMBER;
2558: l_replacement_attr_metadata EGO_ATTR_METADATA_OBJ;
2559: l_replacement_attr_data EGO_USER_ATTR_DATA_OBJ;
2560: l_retrieved_value VARCHAR2(4000); --bug 12979914
2561: l_error_message_name VARCHAR2(30);
2562: l_token_table ERROR_HANDLER.Token_Tbl_Type;
2563: l_cursor_id NUMBER;

Line 2918: ,p_attr_value_obj IN EGO_USER_ATTR_DATA_OBJ

2914: ----------------------------------------------------------------------
2915:
2916: FUNCTION Get_Int_Val_For_Disp_Val (
2917: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
2918: ,p_attr_value_obj IN EGO_USER_ATTR_DATA_OBJ
2919: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
2920: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
2921: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2922: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 3026: ,p_attr_value_obj IN EGO_USER_ATTR_DATA_OBJ DEFAULT NULL

3022: ----------------------------------------------------------------------
3023:
3024: FUNCTION Get_Disp_Val_For_Int_Val (
3025: p_attr_int_value IN VARCHAR2 DEFAULT NULL
3026: ,p_attr_value_obj IN EGO_USER_ATTR_DATA_OBJ DEFAULT NULL
3027: ,p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
3028: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
3029: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
3030: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

Line 4952: ,px_attr_value_obj IN OUT NOCOPY EGO_USER_ATTR_DATA_OBJ

4948: ----------------------------------------------------------------------
4949:
4950: FUNCTION Disp_Val_Replacement_Is_Bad (
4951: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
4952: ,px_attr_value_obj IN OUT NOCOPY EGO_USER_ATTR_DATA_OBJ
4953: )
4954: RETURN BOOLEAN
4955: IS
4956: l_conv_rate NUMBER; -- Bug 16502567

Line 5047: ,p_attr_value_obj IN EGO_USER_ATTR_DATA_OBJ

5043:
5044: FUNCTION Is_Required_Flag_Respected (
5045: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
5046: ,p_mode IN VARCHAR2
5047: ,p_attr_value_obj IN EGO_USER_ATTR_DATA_OBJ
5048: ,p_attr_group_disp_name IN VARCHAR2
5049: ,x_err_msg_name OUT NOCOPY VARCHAR2
5050: ,x_token_table OUT NOCOPY ERROR_HANDLER.Token_Tbl_Type
5051: )

Line 5119: ,p_attr_value_obj IN EGO_USER_ATTR_DATA_OBJ

5115: ----------------------------------------------------------------------
5116:
5117: FUNCTION Is_Data_Type_Correct (
5118: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
5119: ,p_attr_value_obj IN EGO_USER_ATTR_DATA_OBJ
5120: ,p_attr_group_disp_name IN VARCHAR2
5121: ,x_err_msg_name OUT NOCOPY VARCHAR2
5122: ,x_token_table OUT NOCOPY ERROR_HANDLER.Token_Tbl_Type
5123: )

Line 5217: ,p_attr_value_obj IN EGO_USER_ATTR_DATA_OBJ

5213: ----------------------------------------------------------------------
5214:
5215: FUNCTION Is_Min_Or_Max_Value_Respected (
5216: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
5217: ,p_attr_value_obj IN EGO_USER_ATTR_DATA_OBJ
5218: ,p_min_or_max IN VARCHAR2
5219: )
5220: RETURN BOOLEAN
5221: IS

Line 5335: ,p_attr_value_obj IN EGO_USER_ATTR_DATA_OBJ

5331: ----------------------------------------------------------------------
5332:
5333: FUNCTION Is_Max_Size_Respected (
5334: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
5335: ,p_attr_value_obj IN EGO_USER_ATTR_DATA_OBJ
5336: ,p_attr_group_disp_name IN VARCHAR2
5337: ,x_err_msg_name OUT NOCOPY VARCHAR2
5338: ,x_token_table OUT NOCOPY ERROR_HANDLER.Token_Tbl_Type
5339: )

Line 5404: ,px_attr_value_obj IN OUT NOCOPY EGO_USER_ATTR_DATA_OBJ

5400: ----------------------------------------------------------------------
5401:
5402: FUNCTION Is_UOM_Valid (
5403: p_attr_metadata_obj IN EGO_ATTR_METADATA_OBJ
5404: ,px_attr_value_obj IN OUT NOCOPY EGO_USER_ATTR_DATA_OBJ
5405: )
5406: RETURN BOOLEAN
5407: IS
5408:

Line 5469: ,px_attr_value_obj IN OUT NOCOPY EGO_USER_ATTR_DATA_OBJ

5465: ,p_entity_id IN VARCHAR2
5466: ,p_entity_index IN NUMBER
5467: ,p_entity_code IN VARCHAR2
5468: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
5469: ,px_attr_value_obj IN OUT NOCOPY EGO_USER_ATTR_DATA_OBJ
5470: )
5471: RETURN BOOLEAN
5472: IS
5473:

Line 5782: l_attr_data_obj EGO_USER_ATTR_DATA_OBJ;

5778: Debug_Msg('In Verify_All_Required_Attrs, non-passed required Attribute '||l_attr_metadata_obj.ATTR_DISP_NAME||' has a default value');
5779:
5780: DECLARE
5781:
5782: l_attr_data_obj EGO_USER_ATTR_DATA_OBJ;
5783:
5784: BEGIN
5785:
5786: l_attr_data_obj := EGO_USER_ATTR_DATA_OBJ(

Line 5786: l_attr_data_obj := EGO_USER_ATTR_DATA_OBJ(

5782: l_attr_data_obj EGO_USER_ATTR_DATA_OBJ;
5783:
5784: BEGIN
5785:
5786: l_attr_data_obj := EGO_USER_ATTR_DATA_OBJ(
5787: px_attr_name_value_pairs(px_attr_name_value_pairs.FIRST).ROW_IDENTIFIER
5788: ,l_attr_metadata_obj.ATTR_NAME
5789: ,null -- ATTR_VALUE_STR
5790: ,null -- ATTR_VALUE_NUM

Line 10361: l_current_data_element EGO_USER_ATTR_DATA_OBJ;

10357: l_current_row_element EGO_USER_ATTR_ROW_OBJ;
10358: l_mode VARCHAR2(10);
10359: l_sorted_data_table_index NUMBER;
10360: l_got_all_attrs_for_this_row BOOLEAN := FALSE;
10361: l_current_data_element EGO_USER_ATTR_DATA_OBJ;
10362: l_next_row_id NUMBER;
10363: l_row_attrs_table EGO_USER_ATTR_DATA_TABLE;
10364: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
10365: l_current_row_change_obj EGO_USER_ATTR_CHANGE_OBJ;

Line 12173: EGO_USER_ATTR_DATA_OBJ(

12169: x_attributes_data_table(x_attributes_data_table.LAST) :=
12170: --changed as a part of
12171: --ENHR12:for passing the internal value of the attribute along
12172: --with the display value.
12173: EGO_USER_ATTR_DATA_OBJ(
12174: l_extension_id
12175: ,l_curr_augmented_attr_rec.ATTR_NAME
12176: ,l_curr_augmented_attr_rec.ATTR_VALUE_STR-- ATTR_VALUE_STR
12177: ,l_curr_augmented_attr_rec.ATTR_VALUE_NUM-- ATTR_VALUE_NUM

Line 13079: l_b_dml_bind_list(i) := EGO_USER_ATTR_DATA_OBJ(NULL,l_bind_name,NULL,NULL,G_B_BIND_DATE_TBL(i),G_B_BIND_IDENTIFIER_TBL(i),NULL,NULL);

13075:
13076: l_bind_name := ':FND_BIND'||TO_CHAR(i);
13077: l_b_dml_bind_list.EXTEND();
13078: IF(G_B_BIND_DATATYPE_TBL(i) = 'D') THEN
13079: l_b_dml_bind_list(i) := EGO_USER_ATTR_DATA_OBJ(NULL,l_bind_name,NULL,NULL,G_B_BIND_DATE_TBL(i),G_B_BIND_IDENTIFIER_TBL(i),NULL,NULL);
13080: ELSIF (G_B_BIND_DATATYPE_TBL(i) = 'N') THEN
13081: l_b_dml_bind_list(i) := EGO_USER_ATTR_DATA_OBJ(NULL,l_bind_name,NULL,G_B_BIND_NUMBER_TBL(i),NULL,G_B_BIND_IDENTIFIER_TBL(i),NULL,NULL);
13082: ELSE
13083: l_b_dml_bind_list(i) := EGO_USER_ATTR_DATA_OBJ(NULL,l_bind_name,G_B_BIND_TEXT_TBL(i),NULL,NULL,G_B_BIND_IDENTIFIER_TBL(i),NULL,NULL);

Line 13081: l_b_dml_bind_list(i) := EGO_USER_ATTR_DATA_OBJ(NULL,l_bind_name,NULL,G_B_BIND_NUMBER_TBL(i),NULL,G_B_BIND_IDENTIFIER_TBL(i),NULL,NULL);

13077: l_b_dml_bind_list.EXTEND();
13078: IF(G_B_BIND_DATATYPE_TBL(i) = 'D') THEN
13079: l_b_dml_bind_list(i) := EGO_USER_ATTR_DATA_OBJ(NULL,l_bind_name,NULL,NULL,G_B_BIND_DATE_TBL(i),G_B_BIND_IDENTIFIER_TBL(i),NULL,NULL);
13080: ELSIF (G_B_BIND_DATATYPE_TBL(i) = 'N') THEN
13081: l_b_dml_bind_list(i) := EGO_USER_ATTR_DATA_OBJ(NULL,l_bind_name,NULL,G_B_BIND_NUMBER_TBL(i),NULL,G_B_BIND_IDENTIFIER_TBL(i),NULL,NULL);
13082: ELSE
13083: l_b_dml_bind_list(i) := EGO_USER_ATTR_DATA_OBJ(NULL,l_bind_name,G_B_BIND_TEXT_TBL(i),NULL,NULL,G_B_BIND_IDENTIFIER_TBL(i),NULL,NULL);
13084: END IF;
13085: END LOOP;

Line 13083: l_b_dml_bind_list(i) := EGO_USER_ATTR_DATA_OBJ(NULL,l_bind_name,G_B_BIND_TEXT_TBL(i),NULL,NULL,G_B_BIND_IDENTIFIER_TBL(i),NULL,NULL);

13079: l_b_dml_bind_list(i) := EGO_USER_ATTR_DATA_OBJ(NULL,l_bind_name,NULL,NULL,G_B_BIND_DATE_TBL(i),G_B_BIND_IDENTIFIER_TBL(i),NULL,NULL);
13080: ELSIF (G_B_BIND_DATATYPE_TBL(i) = 'N') THEN
13081: l_b_dml_bind_list(i) := EGO_USER_ATTR_DATA_OBJ(NULL,l_bind_name,NULL,G_B_BIND_NUMBER_TBL(i),NULL,G_B_BIND_IDENTIFIER_TBL(i),NULL,NULL);
13082: ELSE
13083: l_b_dml_bind_list(i) := EGO_USER_ATTR_DATA_OBJ(NULL,l_bind_name,G_B_BIND_TEXT_TBL(i),NULL,NULL,G_B_BIND_IDENTIFIER_TBL(i),NULL,NULL);
13084: END IF;
13085: END LOOP;
13086:
13087:

Line 13094: l_tl_dml_bind_list(j) := EGO_USER_ATTR_DATA_OBJ(NULL,l_bind_name,NULL,NULL,G_TL_BIND_DATE_TBL(j),G_TL_BIND_IDENTIFIER_TBL(j),NULL,NULL);

13090:
13091: l_bind_name := ':FND_BIND'||TO_CHAR(j);
13092: l_tl_dml_bind_list.EXTEND();
13093: IF(G_TL_BIND_DATATYPE_TBL(j) = 'D') THEN
13094: l_tl_dml_bind_list(j) := EGO_USER_ATTR_DATA_OBJ(NULL,l_bind_name,NULL,NULL,G_TL_BIND_DATE_TBL(j),G_TL_BIND_IDENTIFIER_TBL(j),NULL,NULL);
13095: ELSIF (G_TL_BIND_DATATYPE_TBL(j) = 'N') THEN
13096: l_tl_dml_bind_list(j) := EGO_USER_ATTR_DATA_OBJ(NULL,l_bind_name,NULL,G_TL_BIND_NUMBER_TBL(j),NULL,G_TL_BIND_IDENTIFIER_TBL(j),NULL,NULL);
13097: ELSE
13098: l_tl_dml_bind_list(j) := EGO_USER_ATTR_DATA_OBJ(NULL,l_bind_name,G_TL_BIND_TEXT_TBL(j),NULL,NULL,G_TL_BIND_IDENTIFIER_TBL(j),NULL,NULL);

Line 13096: l_tl_dml_bind_list(j) := EGO_USER_ATTR_DATA_OBJ(NULL,l_bind_name,NULL,G_TL_BIND_NUMBER_TBL(j),NULL,G_TL_BIND_IDENTIFIER_TBL(j),NULL,NULL);

13092: l_tl_dml_bind_list.EXTEND();
13093: IF(G_TL_BIND_DATATYPE_TBL(j) = 'D') THEN
13094: l_tl_dml_bind_list(j) := EGO_USER_ATTR_DATA_OBJ(NULL,l_bind_name,NULL,NULL,G_TL_BIND_DATE_TBL(j),G_TL_BIND_IDENTIFIER_TBL(j),NULL,NULL);
13095: ELSIF (G_TL_BIND_DATATYPE_TBL(j) = 'N') THEN
13096: l_tl_dml_bind_list(j) := EGO_USER_ATTR_DATA_OBJ(NULL,l_bind_name,NULL,G_TL_BIND_NUMBER_TBL(j),NULL,G_TL_BIND_IDENTIFIER_TBL(j),NULL,NULL);
13097: ELSE
13098: l_tl_dml_bind_list(j) := EGO_USER_ATTR_DATA_OBJ(NULL,l_bind_name,G_TL_BIND_TEXT_TBL(j),NULL,NULL,G_TL_BIND_IDENTIFIER_TBL(j),NULL,NULL);
13099: END IF;
13100: END LOOP;

Line 13098: l_tl_dml_bind_list(j) := EGO_USER_ATTR_DATA_OBJ(NULL,l_bind_name,G_TL_BIND_TEXT_TBL(j),NULL,NULL,G_TL_BIND_IDENTIFIER_TBL(j),NULL,NULL);

13094: l_tl_dml_bind_list(j) := EGO_USER_ATTR_DATA_OBJ(NULL,l_bind_name,NULL,NULL,G_TL_BIND_DATE_TBL(j),G_TL_BIND_IDENTIFIER_TBL(j),NULL,NULL);
13095: ELSIF (G_TL_BIND_DATATYPE_TBL(j) = 'N') THEN
13096: l_tl_dml_bind_list(j) := EGO_USER_ATTR_DATA_OBJ(NULL,l_bind_name,NULL,G_TL_BIND_NUMBER_TBL(j),NULL,G_TL_BIND_IDENTIFIER_TBL(j),NULL,NULL);
13097: ELSE
13098: l_tl_dml_bind_list(j) := EGO_USER_ATTR_DATA_OBJ(NULL,l_bind_name,G_TL_BIND_TEXT_TBL(j),NULL,NULL,G_TL_BIND_IDENTIFIER_TBL(j),NULL,NULL);
13099: END IF;
13100: END LOOP;
13101:
13102: x_b_bind_attr_table := l_b_dml_bind_list;

Line 14095: EGO_USER_ATTR_DATA_OBJ(

14091: IF (l_attr_metadata_obj.VS_BIND_VALUES_CODE IS NOT NULL AND
14092: l_attr_metadata_obj.VS_BIND_VALUES_CODE <> 'N') THEN
14093:
14094: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST) :=
14095: EGO_USER_ATTR_DATA_OBJ(
14096: l_row_index
14097: ,l_attr_metadata_obj.ATTR_NAME
14098: ,null -- ATTR_VALUE_STR
14099: ,l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE

Line 14109: EGO_USER_ATTR_DATA_OBJ(

14105:
14106: ELSE
14107:
14108: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST) :=
14109: EGO_USER_ATTR_DATA_OBJ(
14110: l_row_index
14111: ,l_attr_metadata_obj.ATTR_NAME
14112: ,NVL(l_templ_attr_rec.ATTRIBUTE_STRING_VALUE,l_templ_attr_rec.ATTRIBUTE_TRANSLATED_VALUE)
14113: ,l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE

Line 15553: EGO_USER_ATTR_DATA_OBJ(

15549: -- ...then we add its value to our Attr data table --
15550: -----------------------------------------------------
15551: l_attr_name_value_pairs.EXTEND();
15552: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST) :=
15553: EGO_USER_ATTR_DATA_OBJ(
15554: 1
15555: ,l_attr_metadata_obj.ATTR_NAME
15556: ,null -- ATTR_VALUE_STR
15557: ,null -- ATTR_VALUE_NUM

Line 16609: EGO_USER_ATTR_DATA_OBJ (

16605: );
16606:
16607: l_attr_name_value_pairs.EXTEND();
16608: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST) :=
16609: EGO_USER_ATTR_DATA_OBJ (
16610: 1
16611: ,l_temp_attr_metadata.ATTR_NAME
16612: ,l_temp_str -- ATTR_VALUE_STR
16613: ,l_temp_num -- ATTR_VALUE_NUM

Line 16931: l_attr_name_value_rec EGO_USER_ATTR_DATA_OBJ;

16927: , x_error_message OUT NOCOPY VARCHAR2
16928: )
16929: IS
16930: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
16931: l_attr_name_value_rec EGO_USER_ATTR_DATA_OBJ;
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;

Line 16962: EGO_USER_ATTR_DATA_OBJ(1

16958:
16959: -- add all attributes to the name_value pairs table, to pass into Get_Change_Attrs
16960: l_attr_name_value_pairs.EXTEND();
16961: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST) :=
16962: EGO_USER_ATTR_DATA_OBJ(1
16963: ,l_attr_metadata_obj.ATTR_NAME
16964: ,null
16965: ,null
16966: ,null

Line 17064: l_attr_value_obj EGO_USER_ATTR_DATA_OBJ;

17060: ,p_data_level3_value IN VARCHAR2 DEFAULT NULL
17061: )
17062: RETURN VARCHAR2
17063: IS
17064: l_attr_value_obj EGO_USER_ATTR_DATA_OBJ;
17065: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
17066: l_attr_metadata_obj_table EGO_ATTR_METADATA_TABLE;
17067: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
17068: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

Line 17072: l_attr_value_obj := EGO_USER_ATTR_DATA_OBJ (null

17068: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
17069: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
17070: l_attr_disp_value VARCHAR2(5000);
17071: BEGIN
17072: l_attr_value_obj := EGO_USER_ATTR_DATA_OBJ (null
17073: ,p_attr_internal_name
17074: ,p_attr_internal_str_value
17075: ,p_attr_internal_num_value
17076: ,p_attr_internal_date_value

Line 17180: l_attr_value_obj EGO_USER_ATTR_DATA_OBJ;

17176: ,p_entity_code IN VARCHAR2
17177: )
17178: RETURN VARCHAR2
17179: IS
17180: l_attr_value_obj EGO_USER_ATTR_DATA_OBJ;
17181: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
17182: l_attr_metadata_obj_table EGO_ATTR_METADATA_TABLE;
17183: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
17184: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

Line 17189: l_attr_value_obj := EGO_USER_ATTR_DATA_OBJ (null

17185: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
17186: l_attr_internal_value VARCHAR2(4000);
17187: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
17188: BEGIN
17189: l_attr_value_obj := EGO_USER_ATTR_DATA_OBJ (null
17190: ,p_attr_internal_name
17191: ,null
17192: ,null
17193: ,null

Line 18686: EGO_USER_ATTR_DATA_OBJ( l_attr_record.ATTR_GROUP_ID, --ROW_IDENTIFIER

18682:
18683: l_temp_attr_data_table.EXTEND();
18684: l_counter2 := l_counter2 + 1;
18685: l_temp_attr_data_table(l_counter2) :=
18686: EGO_USER_ATTR_DATA_OBJ( l_attr_record.ATTR_GROUP_ID, --ROW_IDENTIFIER
18687: l_attr_record.ATTR_NAME, --ATTR_NAME
18688: l_str_val, --ATTR_VALUE_STR
18689: l_number_val, --ATTR_VALUE_NUM
18690: l_date_val, --ATTR_VALUE_DATE

Line 18763: EGO_USER_ATTR_DATA_OBJ ( l_temp_attr_data_table(i).ROW_IDENTIFIER

18759:
18760: l_counter1 := l_counter1+1;
18761: l_attr_data_table.EXTEND();
18762: l_attr_data_table(l_counter1) :=
18763: EGO_USER_ATTR_DATA_OBJ ( l_temp_attr_data_table(i).ROW_IDENTIFIER
18764: ,l_temp_attr_data_table(i).ATTR_NAME
18765: ,l_temp_attr_data_table(i).ATTR_VALUE_STR
18766: ,l_temp_attr_data_table(i).ATTR_VALUE_NUM
18767: ,l_temp_attr_data_table(i).ATTR_VALUE_DATE