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_COL_NAME_VALUE_PAIR_OBJ

Line 20: TYPE LOCAL_COL_NV_PAIR_TABLE IS TABLE OF EGO_COL_NAME_VALUE_PAIR_OBJ

16:
17: TYPE LOCAL_BIG_VARCHAR_TABLE IS TABLE OF VARCHAR2(5000)
18: INDEX BY BINARY_INTEGER;
19:
20: TYPE LOCAL_COL_NV_PAIR_TABLE IS TABLE OF EGO_COL_NAME_VALUE_PAIR_OBJ
21: INDEX BY BINARY_INTEGER;
22:
23: TYPE LOCAL_USER_ATTR_DATA_TABLE IS TABLE OF EGO_USER_ATTR_DATA_OBJ
24: INDEX BY BINARY_INTEGER;

Line 1557: l_data_level_1_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;

1553:
1554: l_object_id NUMBER;
1555: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
1556: l_data_level_metadata_array EGO_COL_METADATA_ARRAY;
1557: l_data_level_1_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1558: l_data_level_2_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1559: l_data_level_3_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1560: l_data_level_4_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1561: l_data_level_5_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;

Line 1558: l_data_level_2_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;

1554: l_object_id NUMBER;
1555: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
1556: l_data_level_metadata_array EGO_COL_METADATA_ARRAY;
1557: l_data_level_1_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1558: l_data_level_2_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1559: l_data_level_3_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1560: l_data_level_4_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1561: l_data_level_5_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1562: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

Line 1559: l_data_level_3_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;

1555: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
1556: l_data_level_metadata_array EGO_COL_METADATA_ARRAY;
1557: l_data_level_1_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1558: l_data_level_2_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1559: l_data_level_3_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1560: l_data_level_4_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1561: l_data_level_5_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1562: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1563: l_data_level_metadata EGO_DATA_LEVEL_METADATA_OBJ;

Line 1560: l_data_level_4_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;

1556: l_data_level_metadata_array EGO_COL_METADATA_ARRAY;
1557: l_data_level_1_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1558: l_data_level_2_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1559: l_data_level_3_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1560: l_data_level_4_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1561: l_data_level_5_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1562: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1563: l_data_level_metadata EGO_DATA_LEVEL_METADATA_OBJ;
1564: BEGIN

Line 1561: l_data_level_5_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;

1557: l_data_level_1_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1558: l_data_level_2_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1559: l_data_level_3_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1560: l_data_level_4_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1561: l_data_level_5_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1562: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1563: l_data_level_metadata EGO_DATA_LEVEL_METADATA_OBJ;
1564: BEGIN
1565:

Line 1576: l_data_level_1_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME1,p_data_level_1);

1572: IF(p_data_level_id IS NOT NULL) THEN
1573:
1574: l_data_level_metadata := EGO_USER_ATTRS_COMMON_PVT.get_data_level_metadata(p_data_level_id);
1575: IF(l_data_level_metadata.PK_COLUMN_NAME1 IS NOT NULL) THEN
1576: l_data_level_1_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME1,p_data_level_1);
1577: END IF;
1578:
1579: IF(l_data_level_metadata.PK_COLUMN_NAME2 IS NOT NULL) THEN
1580: l_data_level_2_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME2,p_data_level_2);

Line 1580: l_data_level_2_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME2,p_data_level_2);

1576: l_data_level_1_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME1,p_data_level_1);
1577: END IF;
1578:
1579: IF(l_data_level_metadata.PK_COLUMN_NAME2 IS NOT NULL) THEN
1580: l_data_level_2_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME2,p_data_level_2);
1581: END IF;
1582:
1583: IF(l_data_level_metadata.PK_COLUMN_NAME3 IS NOT NULL) THEN
1584: l_data_level_3_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME3,p_data_level_3);

Line 1584: l_data_level_3_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME3,p_data_level_3);

1580: l_data_level_2_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME2,p_data_level_2);
1581: END IF;
1582:
1583: IF(l_data_level_metadata.PK_COLUMN_NAME3 IS NOT NULL) THEN
1584: l_data_level_3_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME3,p_data_level_3);
1585: END IF;
1586:
1587: IF(l_data_level_metadata.PK_COLUMN_NAME4 IS NOT NULL) THEN
1588: l_data_level_4_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME4,p_data_level_4);

Line 1588: l_data_level_4_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME4,p_data_level_4);

1584: l_data_level_3_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME3,p_data_level_3);
1585: END IF;
1586:
1587: IF(l_data_level_metadata.PK_COLUMN_NAME4 IS NOT NULL) THEN
1588: l_data_level_4_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME4,p_data_level_4);
1589: END IF;
1590:
1591: IF(l_data_level_metadata.PK_COLUMN_NAME5 IS NOT NULL) THEN
1592: l_data_level_5_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME5,p_data_level_5);

Line 1592: l_data_level_5_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME5,p_data_level_5);

1588: l_data_level_4_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME4,p_data_level_4);
1589: END IF;
1590:
1591: IF(l_data_level_metadata.PK_COLUMN_NAME5 IS NOT NULL) THEN
1592: l_data_level_5_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME5,p_data_level_5);
1593: END IF;
1594:
1595: IF (l_data_level_5_name_value_pair IS NOT NULL) THEN
1596: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

Line 1638: l_data_level_1_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(

1634: l_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(l_object_id);
1635: l_data_level_metadata_array := l_ext_table_metadata_obj.data_level_metadata;
1636:
1637: IF (l_data_level_metadata_array IS NOT NULL AND l_data_level_metadata_array(1) IS NOT NULL) THEN
1638: l_data_level_1_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(
1639: l_data_level_metadata_array(1).COL_NAME
1640: ,p_data_level_1
1641: );
1642: IF (l_data_level_metadata_array.EXISTS(2) AND l_data_level_metadata_array(2) IS NOT NULL) THEN

Line 1643: l_data_level_2_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(

1639: l_data_level_metadata_array(1).COL_NAME
1640: ,p_data_level_1
1641: );
1642: IF (l_data_level_metadata_array.EXISTS(2) AND l_data_level_metadata_array(2) IS NOT NULL) THEN
1643: l_data_level_2_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(
1644: l_data_level_metadata_array(2).COL_NAME
1645: ,p_data_level_2
1646: );
1647: IF (l_data_level_metadata_array.EXISTS(3) AND l_data_level_metadata_array(3) IS NOT NULL) THEN

Line 1648: l_data_level_3_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(

1644: l_data_level_metadata_array(2).COL_NAME
1645: ,p_data_level_2
1646: );
1647: IF (l_data_level_metadata_array.EXISTS(3) AND l_data_level_metadata_array(3) IS NOT NULL) THEN
1648: l_data_level_3_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(
1649: l_data_level_metadata_array(3).COL_NAME
1650: ,p_data_level_3
1651: );
1652: END IF;

Line 13921: l_current_uom_col_nv_obj EGO_COL_NAME_VALUE_PAIR_OBJ;

13917: l_token_table ERROR_HANDLER.Token_Tbl_Type;
13918: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE := EGO_USER_ATTR_DATA_TABLE();
13919: l_uom_column_nv_pairs LOCAL_COL_NV_PAIR_TABLE;
13920: l_uom_nv_pairs_index NUMBER := 0;
13921: l_current_uom_col_nv_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
13922: l_attr_col_name_for_uom_col VARCHAR2(30);
13923: l_current_production_ext_id NUMBER;
13924: l_mode_for_current_row VARCHAR2(10);
13925: l_ext_id_for_current_row NUMBER;

Line 13985: EGO_COL_NAME_VALUE_PAIR_OBJ(

13981: --
13982: IF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 5) THEN
13983: l_pk_column_name_value_pairs :=
13984: EGO_COL_NAME_VALUE_PAIR_ARRAY(
13985: EGO_COL_NAME_VALUE_PAIR_OBJ(
13986: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
13987: )
13988: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
13989: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL

Line 13988: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

13984: EGO_COL_NAME_VALUE_PAIR_ARRAY(
13985: EGO_COL_NAME_VALUE_PAIR_OBJ(
13986: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
13987: )
13988: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
13989: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL
13990: )
13991: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
13992: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, NULL

Line 13991: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

13987: )
13988: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
13989: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL
13990: )
13991: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
13992: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, NULL
13993: )
13994: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
13995: l_ext_table_metadata_obj.pk_column_metadata(4).COL_NAME, NULL

Line 13994: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

13990: )
13991: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
13992: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, NULL
13993: )
13994: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
13995: l_ext_table_metadata_obj.pk_column_metadata(4).COL_NAME, NULL
13996: )
13997: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
13998: l_ext_table_metadata_obj.pk_column_metadata(5).COL_NAME, NULL

Line 13997: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

13993: )
13994: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
13995: l_ext_table_metadata_obj.pk_column_metadata(4).COL_NAME, NULL
13996: )
13997: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
13998: l_ext_table_metadata_obj.pk_column_metadata(5).COL_NAME, NULL
13999: )
14000: );
14001: l_chng_col_names_list := 'B.'||

Line 14025: EGO_COL_NAME_VALUE_PAIR_OBJ(

14021: '''';
14022: ELSIF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 4) THEN
14023: l_pk_column_name_value_pairs :=
14024: EGO_COL_NAME_VALUE_PAIR_ARRAY(
14025: EGO_COL_NAME_VALUE_PAIR_OBJ(
14026: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
14027: )
14028: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
14029: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL

Line 14028: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

14024: EGO_COL_NAME_VALUE_PAIR_ARRAY(
14025: EGO_COL_NAME_VALUE_PAIR_OBJ(
14026: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
14027: )
14028: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
14029: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL
14030: )
14031: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
14032: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, NULL

Line 14031: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

14027: )
14028: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
14029: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL
14030: )
14031: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
14032: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, NULL
14033: )
14034: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
14035: l_ext_table_metadata_obj.pk_column_metadata(4).COL_NAME, NULL

Line 14034: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

14030: )
14031: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
14032: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, NULL
14033: )
14034: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
14035: l_ext_table_metadata_obj.pk_column_metadata(4).COL_NAME, NULL
14036: )
14037: );
14038: l_chng_col_names_list := 'B.'||

Line 14058: EGO_COL_NAME_VALUE_PAIR_OBJ(

14054: '''';
14055: ELSIF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 3) THEN
14056: l_pk_column_name_value_pairs :=
14057: EGO_COL_NAME_VALUE_PAIR_ARRAY(
14058: EGO_COL_NAME_VALUE_PAIR_OBJ(
14059: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
14060: )
14061: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
14062: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL

Line 14061: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

14057: EGO_COL_NAME_VALUE_PAIR_ARRAY(
14058: EGO_COL_NAME_VALUE_PAIR_OBJ(
14059: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
14060: )
14061: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
14062: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL
14063: )
14064: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
14065: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, NULL

Line 14064: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

14060: )
14061: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
14062: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL
14063: )
14064: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
14065: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, NULL
14066: )
14067: );
14068: l_chng_col_names_list := 'B.'||

Line 14084: EGO_COL_NAME_VALUE_PAIR_OBJ(

14080: '''';
14081: ELSIF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 2) THEN
14082: l_pk_column_name_value_pairs :=
14083: EGO_COL_NAME_VALUE_PAIR_ARRAY(
14084: EGO_COL_NAME_VALUE_PAIR_OBJ(
14085: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
14086: )
14087: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
14088: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL

Line 14087: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

14083: EGO_COL_NAME_VALUE_PAIR_ARRAY(
14084: EGO_COL_NAME_VALUE_PAIR_OBJ(
14085: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
14086: )
14087: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
14088: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL
14089: )
14090: );
14091: l_chng_col_names_list := 'B.'||

Line 14103: EGO_COL_NAME_VALUE_PAIR_OBJ(

14099: '''';
14100: ELSIF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 1) THEN
14101: l_pk_column_name_value_pairs :=
14102: EGO_COL_NAME_VALUE_PAIR_ARRAY(
14103: EGO_COL_NAME_VALUE_PAIR_OBJ(
14104: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
14105: )
14106: );
14107: l_chng_col_names_list := 'B.'||

Line 14124: EGO_COL_NAME_VALUE_PAIR_OBJ(

14120: l_ext_table_metadata_obj.class_code_metadata.COUNT > 0 AND
14121: l_ext_table_metadata_obj.class_code_metadata(1).COL_NAME IS NOT NULL) THEN
14122: l_class_code_name_value_pairs :=
14123: EGO_COL_NAME_VALUE_PAIR_ARRAY(
14124: EGO_COL_NAME_VALUE_PAIR_OBJ(
14125: l_ext_table_metadata_obj.class_code_metadata(1).COL_NAME, NULL
14126: ),
14127: EGO_COL_NAME_VALUE_PAIR_OBJ(
14128: 'RELATED_CLASS_CODE_LIST_1', NULL

Line 14127: EGO_COL_NAME_VALUE_PAIR_OBJ(

14123: EGO_COL_NAME_VALUE_PAIR_ARRAY(
14124: EGO_COL_NAME_VALUE_PAIR_OBJ(
14125: l_ext_table_metadata_obj.class_code_metadata(1).COL_NAME, NULL
14126: ),
14127: EGO_COL_NAME_VALUE_PAIR_OBJ(
14128: 'RELATED_CLASS_CODE_LIST_1', NULL
14129: )
14130: );
14131:

Line 14441: EGO_COL_NAME_VALUE_PAIR_OBJ(l_current_column_name, l_retrieved_value);

14437: -- in a PL/SQL table for assignment below --
14438: --------------------------------------------
14439: l_uom_nv_pairs_index := l_uom_nv_pairs_index + 1;
14440: l_uom_column_nv_pairs(l_uom_nv_pairs_index) :=
14441: EGO_COL_NAME_VALUE_PAIR_OBJ(l_current_column_name, l_retrieved_value);
14442:
14443: ELSIF (l_current_column_name = 'LANGUAGE') THEN
14444:
14445: -------------------------------------------------------

Line 15325: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)

15321: p_pk_col4 IS NOT NULL AND
15322: p_pk_col5 IS NOT NULL) THEN
15323:
15324: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
15325: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
15326: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
15327: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)
15328: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col4, p_pk_value4)
15329: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col5, p_pk_value5)

Line 15326: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)

15322: p_pk_col5 IS NOT NULL) THEN
15323:
15324: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
15325: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
15326: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
15327: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)
15328: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col4, p_pk_value4)
15329: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col5, p_pk_value5)
15330: );

Line 15327: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)

15323:
15324: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
15325: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
15326: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
15327: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)
15328: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col4, p_pk_value4)
15329: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col5, p_pk_value5)
15330: );
15331:

Line 15328: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col4, p_pk_value4)

15324: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
15325: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
15326: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
15327: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)
15328: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col4, p_pk_value4)
15329: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col5, p_pk_value5)
15330: );
15331:
15332: ------------------------------------------------------------------

Line 15329: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col5, p_pk_value5)

15325: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
15326: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
15327: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)
15328: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col4, p_pk_value4)
15329: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col5, p_pk_value5)
15330: );
15331:
15332: ------------------------------------------------------------------
15333: -- We build a name/value pair array for our Primary Keys to use --

Line 15342: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)

15338: p_pk_col3 IS NOT NULL AND
15339: p_pk_col4 IS NOT NULL) THEN
15340:
15341: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
15342: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
15343: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
15344: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)
15345: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col4, p_pk_value4)
15346: );

Line 15343: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)

15339: p_pk_col4 IS NOT NULL) THEN
15340:
15341: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
15342: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
15343: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
15344: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)
15345: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col4, p_pk_value4)
15346: );
15347:

Line 15344: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)

15340:
15341: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
15342: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
15343: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
15344: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)
15345: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col4, p_pk_value4)
15346: );
15347:
15348: ELSIF (p_pk_col2 IS NOT NULL AND

Line 15345: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col4, p_pk_value4)

15341: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
15342: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
15343: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
15344: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)
15345: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col4, p_pk_value4)
15346: );
15347:
15348: ELSIF (p_pk_col2 IS NOT NULL AND
15349: p_pk_col3 IS NOT NULL) THEN

Line 15352: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)

15348: ELSIF (p_pk_col2 IS NOT NULL AND
15349: p_pk_col3 IS NOT NULL) THEN
15350:
15351: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
15352: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
15353: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
15354: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)
15355: );
15356:

Line 15353: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)

15349: p_pk_col3 IS NOT NULL) THEN
15350:
15351: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
15352: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
15353: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
15354: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)
15355: );
15356:
15357: ELSIF (p_pk_col2 IS NOT NULL) THEN

Line 15354: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)

15350:
15351: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
15352: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
15353: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
15354: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)
15355: );
15356:
15357: ELSIF (p_pk_col2 IS NOT NULL) THEN
15358:

Line 15360: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)

15356:
15357: ELSIF (p_pk_col2 IS NOT NULL) THEN
15358:
15359: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
15360: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
15361: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
15362: );
15363:
15364: ELSE

Line 15361: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)

15357: ELSIF (p_pk_col2 IS NOT NULL) THEN
15358:
15359: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
15360: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
15361: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
15362: );
15363:
15364: ELSE
15365:

Line 15367: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)

15363:
15364: ELSE
15365:
15366: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
15367: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
15368: );
15369:
15370: END IF;
15371:

Line 15944: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk1_column_name,p_pk1_value)

15940: END LOOP;
15941: END IF;
15942:
15943: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
15944: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk1_column_name,p_pk1_value)
15945: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk2_column_name,p_pk2_value)
15946: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk3_column_name,p_pk3_value)
15947: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)
15948: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)

Line 15945: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk2_column_name,p_pk2_value)

15941: END IF;
15942:
15943: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
15944: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk1_column_name,p_pk1_value)
15945: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk2_column_name,p_pk2_value)
15946: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk3_column_name,p_pk3_value)
15947: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)
15948: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)
15949: );

Line 15946: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk3_column_name,p_pk3_value)

15942:
15943: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
15944: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk1_column_name,p_pk1_value)
15945: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk2_column_name,p_pk2_value)
15946: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk3_column_name,p_pk3_value)
15947: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)
15948: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)
15949: );
15950: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

Line 15947: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)

15943: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
15944: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk1_column_name,p_pk1_value)
15945: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk2_column_name,p_pk2_value)
15946: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk3_column_name,p_pk3_value)
15947: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)
15948: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)
15949: );
15950: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
15951: EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level1_column_name,p_data_level1_value)

Line 15948: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)

15944: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk1_column_name,p_pk1_value)
15945: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk2_column_name,p_pk2_value)
15946: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk3_column_name,p_pk3_value)
15947: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)
15948: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)
15949: );
15950: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
15951: EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level1_column_name,p_data_level1_value)
15952: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level2_column_name,p_data_level2_value)

Line 15951: EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level1_column_name,p_data_level1_value)

15947: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)
15948: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)
15949: );
15950: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
15951: EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level1_column_name,p_data_level1_value)
15952: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level2_column_name,p_data_level2_value)
15953: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level3_column_name,p_data_level3_value)
15954: );
15955: l_attr_disp_value := Get_Disp_Val_For_Int_Val(

Line 15952: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level2_column_name,p_data_level2_value)

15948: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)
15949: );
15950: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
15951: EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level1_column_name,p_data_level1_value)
15952: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level2_column_name,p_data_level2_value)
15953: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level3_column_name,p_data_level3_value)
15954: );
15955: l_attr_disp_value := Get_Disp_Val_For_Int_Val(
15956: p_attr_value_obj => l_attr_value_obj

Line 15953: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level3_column_name,p_data_level3_value)

15949: );
15950: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
15951: EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level1_column_name,p_data_level1_value)
15952: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level2_column_name,p_data_level2_value)
15953: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level3_column_name,p_data_level3_value)
15954: );
15955: l_attr_disp_value := Get_Disp_Val_For_Int_Val(
15956: p_attr_value_obj => l_attr_value_obj
15957: ,p_attr_metadata_obj => l_attr_metadata_obj

Line 16118: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk1_column_name,p_pk1_value)

16114:
16115: END IF;
16116:
16117: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
16118: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk1_column_name,p_pk1_value)
16119: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk2_column_name,p_pk2_value)
16120: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk3_column_name,p_pk3_value)
16121: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)
16122: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)

Line 16119: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk2_column_name,p_pk2_value)

16115: END IF;
16116:
16117: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
16118: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk1_column_name,p_pk1_value)
16119: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk2_column_name,p_pk2_value)
16120: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk3_column_name,p_pk3_value)
16121: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)
16122: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)
16123: );

Line 16120: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk3_column_name,p_pk3_value)

16116:
16117: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
16118: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk1_column_name,p_pk1_value)
16119: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk2_column_name,p_pk2_value)
16120: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk3_column_name,p_pk3_value)
16121: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)
16122: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)
16123: );
16124:

Line 16121: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)

16117: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
16118: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk1_column_name,p_pk1_value)
16119: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk2_column_name,p_pk2_value)
16120: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk3_column_name,p_pk3_value)
16121: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)
16122: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)
16123: );
16124:
16125: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

Line 16122: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)

16118: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk1_column_name,p_pk1_value)
16119: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk2_column_name,p_pk2_value)
16120: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk3_column_name,p_pk3_value)
16121: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)
16122: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)
16123: );
16124:
16125: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
16126: EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level1_column_name,p_data_level1_value)

Line 16126: EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level1_column_name,p_data_level1_value)

16122: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)
16123: );
16124:
16125: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
16126: EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level1_column_name,p_data_level1_value)
16127: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level2_column_name,p_data_level2_value)
16128: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level3_column_name,p_data_level3_value)
16129: );
16130:

Line 16127: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level2_column_name,p_data_level2_value)

16123: );
16124:
16125: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
16126: EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level1_column_name,p_data_level1_value)
16127: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level2_column_name,p_data_level2_value)
16128: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level3_column_name,p_data_level3_value)
16129: );
16130:
16131:

Line 16128: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level3_column_name,p_data_level3_value)

16124:
16125: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
16126: EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level1_column_name,p_data_level1_value)
16127: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level2_column_name,p_data_level2_value)
16128: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level3_column_name,p_data_level3_value)
16129: );
16130:
16131:
16132: IF (p_ext_table_metadata_obj IS NOT NULL) THEN

Line 16182: ,x_data_level_obj OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_OBJ

16178: ---------------------------------------------------------------------------
16179:
16180: PROCEDURE Process_Data_Level_Nvp(
16181: p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16182: ,x_data_level_obj OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_OBJ
16183: ,x_data_level_index OUT NOCOPY NUMBER
16184: ) IS
16185: l_api_name VARCHAR2(30) := 'Process_data_level_nvp';
16186: BEGIN

Line 16232: ,x_base_class_obj OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_OBJ

16228: ---------------------------------------------------------------------------
16229:
16230: PROCEDURE Process_Class_Code_Nvp(
16231: p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16232: ,x_base_class_obj OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_OBJ
16233: ,x_related_class_obj OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_OBJ
16234: ) IS
16235: l_api_name VARCHAR2(30) := 'Process_Class_Code_Nvp';
16236: BEGIN

Line 16233: ,x_related_class_obj OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_OBJ

16229:
16230: PROCEDURE Process_Class_Code_Nvp(
16231: p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16232: ,x_base_class_obj OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_OBJ
16233: ,x_related_class_obj OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_OBJ
16234: ) IS
16235: l_api_name VARCHAR2(30) := 'Process_Class_Code_Nvp';
16236: BEGIN
16237:

Line 16282: l_base_class_obj EGO_COL_NAME_VALUE_PAIR_OBJ;

16278: PROCEDURE Build_Class_Code_Table(
16279: p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16280: ,x_class_code_table OUT NOCOPY LOCAL_MEDIUM_VARCHAR_TABLE
16281: ) IS
16282: l_base_class_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
16283: l_related_class_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
16284: l_remaining VARCHAR2(300);
16285: l_current_val VARCHAR2(300); --EGO_COL_NAME_VALUE_PAIR_OBJ.VALUE%TYPE;
16286: l_index NUMBER;

Line 16283: l_related_class_obj EGO_COL_NAME_VALUE_PAIR_OBJ;

16279: p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16280: ,x_class_code_table OUT NOCOPY LOCAL_MEDIUM_VARCHAR_TABLE
16281: ) IS
16282: l_base_class_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
16283: l_related_class_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
16284: l_remaining VARCHAR2(300);
16285: l_current_val VARCHAR2(300); --EGO_COL_NAME_VALUE_PAIR_OBJ.VALUE%TYPE;
16286: l_index NUMBER;
16287: BEGIN

Line 16285: l_current_val VARCHAR2(300); --EGO_COL_NAME_VALUE_PAIR_OBJ.VALUE%TYPE;

16281: ) IS
16282: l_base_class_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
16283: l_related_class_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
16284: l_remaining VARCHAR2(300);
16285: l_current_val VARCHAR2(300); --EGO_COL_NAME_VALUE_PAIR_OBJ.VALUE%TYPE;
16286: l_index NUMBER;
16287: BEGIN
16288:
16289: Debug_Msg('In Build_Class_Code_Table, starting', 2);

Line 16436: p_data_level_obj IN EGO_COL_NAME_VALUE_PAIR_OBJ

16432: ----------------------------------------------------------------------------
16433:
16434:
16435: PROCEDURE Process_Data_Level_Values(
16436: p_data_level_obj IN EGO_COL_NAME_VALUE_PAIR_OBJ
16437: ,p_data_level_ind IN NUMBER
16438: ,x_data_level_1 OUT NOCOPY VARCHAR2
16439: ,x_data_level_2 OUT NOCOPY VARCHAR2
16440: ,x_data_level_3 OUT NOCOPY VARCHAR2

Line 16495: l_data_level_obj EGO_COL_NAME_VALUE_PAIR_OBJ;

16491:
16492: l_api_name VARCHAR2(30) := 'Build_Request_Table_For_Obj';
16493: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
16494: l_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
16495: l_data_level_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
16496: l_data_level_index NUMBER;
16497: l_class_code_table LOCAL_MEDIUM_VARCHAR_TABLE;
16498: l_attr_group_id ego_obj_ag_assocs_b.attr_group_id%TYPE;
16499: l_data_level_1 VARCHAR2(150);

Line 17630: l_cc_name_value_pairs(2) := EGO_COL_NAME_VALUE_PAIR_OBJ('RELATED_CLASS_CODE_LIST',l_related_class_Code_list);

17626: IF(l_attr_data_table.COUNT > 0 AND l_attr_row_table.COUNT > 0 ) THEN
17627:
17628: l_cc_name_value_pairs := p_class_code_name_value_pairs;
17629: l_cc_name_value_pairs.EXTEND();
17630: l_cc_name_value_pairs(2) := EGO_COL_NAME_VALUE_PAIR_OBJ('RELATED_CLASS_CODE_LIST',l_related_class_Code_list);
17631: Debug_Msg(l_api_name ||' Calling Process_User_Attrs_Data ');
17632: Process_User_Attrs_Data(
17633: p_api_version => 1.0
17634: ,p_object_name => p_object_name