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 21: TYPE LOCAL_COL_NV_PAIR_TABLE IS TABLE OF EGO_COL_NAME_VALUE_PAIR_OBJ

17:
18: TYPE LOCAL_BIG_VARCHAR_TABLE IS TABLE OF VARCHAR2(5000)
19: INDEX BY BINARY_INTEGER;
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;

Line 1700: l_data_level_1_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;

1696:
1697: l_object_id NUMBER;
1698: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
1699: l_data_level_metadata_array EGO_COL_METADATA_ARRAY;
1700: l_data_level_1_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1701: l_data_level_2_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1702: l_data_level_3_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1703: l_data_level_4_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1704: l_data_level_5_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;

Line 1701: l_data_level_2_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;

1697: l_object_id NUMBER;
1698: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
1699: l_data_level_metadata_array EGO_COL_METADATA_ARRAY;
1700: l_data_level_1_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1701: l_data_level_2_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1702: l_data_level_3_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1703: l_data_level_4_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1704: l_data_level_5_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1705: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

Line 1702: l_data_level_3_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;

1698: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
1699: l_data_level_metadata_array EGO_COL_METADATA_ARRAY;
1700: l_data_level_1_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1701: l_data_level_2_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1702: l_data_level_3_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1703: l_data_level_4_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1704: l_data_level_5_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1705: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1706: l_data_level_metadata EGO_DATA_LEVEL_METADATA_OBJ;

Line 1703: l_data_level_4_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;

1699: l_data_level_metadata_array EGO_COL_METADATA_ARRAY;
1700: l_data_level_1_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1701: l_data_level_2_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1702: l_data_level_3_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1703: l_data_level_4_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1704: l_data_level_5_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1705: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1706: l_data_level_metadata EGO_DATA_LEVEL_METADATA_OBJ;
1707: BEGIN

Line 1704: l_data_level_5_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;

1700: l_data_level_1_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1701: l_data_level_2_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1702: l_data_level_3_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1703: l_data_level_4_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1704: l_data_level_5_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
1705: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1706: l_data_level_metadata EGO_DATA_LEVEL_METADATA_OBJ;
1707: BEGIN
1708:

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

1715: IF(p_data_level_id IS NOT NULL) THEN
1716:
1717: l_data_level_metadata := EGO_USER_ATTRS_COMMON_PVT.get_data_level_metadata(p_data_level_id);
1718: IF(l_data_level_metadata.PK_COLUMN_NAME1 IS NOT NULL) THEN
1719: l_data_level_1_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME1,p_data_level_1);
1720: END IF;
1721:
1722: IF(l_data_level_metadata.PK_COLUMN_NAME2 IS NOT NULL) THEN
1723: 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 1723: l_data_level_2_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME2,p_data_level_2);

1719: l_data_level_1_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME1,p_data_level_1);
1720: END IF;
1721:
1722: IF(l_data_level_metadata.PK_COLUMN_NAME2 IS NOT NULL) THEN
1723: l_data_level_2_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME2,p_data_level_2);
1724: END IF;
1725:
1726: IF(l_data_level_metadata.PK_COLUMN_NAME3 IS NOT NULL) THEN
1727: 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 1727: l_data_level_3_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME3,p_data_level_3);

1723: l_data_level_2_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME2,p_data_level_2);
1724: END IF;
1725:
1726: IF(l_data_level_metadata.PK_COLUMN_NAME3 IS NOT NULL) THEN
1727: l_data_level_3_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME3,p_data_level_3);
1728: END IF;
1729:
1730: IF(l_data_level_metadata.PK_COLUMN_NAME4 IS NOT NULL) THEN
1731: 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 1731: l_data_level_4_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME4,p_data_level_4);

1727: l_data_level_3_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME3,p_data_level_3);
1728: END IF;
1729:
1730: IF(l_data_level_metadata.PK_COLUMN_NAME4 IS NOT NULL) THEN
1731: l_data_level_4_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME4,p_data_level_4);
1732: END IF;
1733:
1734: IF(l_data_level_metadata.PK_COLUMN_NAME5 IS NOT NULL) THEN
1735: 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 1735: l_data_level_5_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME5,p_data_level_5);

1731: l_data_level_4_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME4,p_data_level_4);
1732: END IF;
1733:
1734: IF(l_data_level_metadata.PK_COLUMN_NAME5 IS NOT NULL) THEN
1735: l_data_level_5_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME5,p_data_level_5);
1736: END IF;
1737:
1738: IF (l_data_level_5_name_value_pair IS NOT NULL) THEN
1739: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

Line 1785: l_data_level_1_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(

1781: l_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(l_object_id);
1782: l_data_level_metadata_array := l_ext_table_metadata_obj.data_level_metadata;
1783:
1784: IF (l_data_level_metadata_array IS NOT NULL AND l_data_level_metadata_array(1) IS NOT NULL) THEN
1785: l_data_level_1_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(
1786: l_data_level_metadata_array(1).COL_NAME
1787: ,p_data_level_1
1788: );
1789: IF (l_data_level_metadata_array.EXISTS(2) AND l_data_level_metadata_array(2) IS NOT NULL) THEN

Line 1790: l_data_level_2_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(

1786: l_data_level_metadata_array(1).COL_NAME
1787: ,p_data_level_1
1788: );
1789: IF (l_data_level_metadata_array.EXISTS(2) AND l_data_level_metadata_array(2) IS NOT NULL) THEN
1790: l_data_level_2_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(
1791: l_data_level_metadata_array(2).COL_NAME
1792: ,p_data_level_2
1793: );
1794: IF (l_data_level_metadata_array.EXISTS(3) AND l_data_level_metadata_array(3) IS NOT NULL) THEN

Line 1795: l_data_level_3_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(

1791: l_data_level_metadata_array(2).COL_NAME
1792: ,p_data_level_2
1793: );
1794: IF (l_data_level_metadata_array.EXISTS(3) AND l_data_level_metadata_array(3) IS NOT NULL) THEN
1795: l_data_level_3_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(
1796: l_data_level_metadata_array(3).COL_NAME
1797: ,p_data_level_3
1798: );
1799: END IF;

Line 11076: (EGO_COL_NAME_VALUE_PAIR_OBJ( 'INVENTORY_ITEM_ID' , to_char(l_style_item_id))

11072: -- style flag is N for SKUs
11073: IF (l_style_item_flag = 'N') THEN
11074:
11075: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
11076: (EGO_COL_NAME_VALUE_PAIR_OBJ( 'INVENTORY_ITEM_ID' , to_char(l_style_item_id))
11077: ,EGO_COL_NAME_VALUE_PAIR_OBJ( 'ORGANIZATION_ID' , to_char(l_organization_id))
11078: );
11079:
11080: END IF; --END IF FOR STYLE_ITEM_FLAG

Line 11077: ,EGO_COL_NAME_VALUE_PAIR_OBJ( 'ORGANIZATION_ID' , to_char(l_organization_id))

11073: IF (l_style_item_flag = 'N') THEN
11074:
11075: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
11076: (EGO_COL_NAME_VALUE_PAIR_OBJ( 'INVENTORY_ITEM_ID' , to_char(l_style_item_id))
11077: ,EGO_COL_NAME_VALUE_PAIR_OBJ( 'ORGANIZATION_ID' , to_char(l_organization_id))
11078: );
11079:
11080: END IF; --END IF FOR STYLE_ITEM_FLAG
11081: END IF; -- defaulting

Line 15071: l_current_uom_col_nv_obj EGO_COL_NAME_VALUE_PAIR_OBJ;

15067: l_token_table ERROR_HANDLER.Token_Tbl_Type;
15068: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE := EGO_USER_ATTR_DATA_TABLE();
15069: l_uom_column_nv_pairs LOCAL_COL_NV_PAIR_TABLE;
15070: l_uom_nv_pairs_index NUMBER := 0;
15071: l_current_uom_col_nv_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
15072: l_attr_col_name_for_uom_col VARCHAR2(30);
15073: l_current_production_ext_id NUMBER;
15074: l_mode_for_current_row VARCHAR2(10);
15075: l_ext_id_for_current_row NUMBER;

Line 15135: EGO_COL_NAME_VALUE_PAIR_OBJ(

15131: --
15132: IF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 5) THEN
15133: l_pk_column_name_value_pairs :=
15134: EGO_COL_NAME_VALUE_PAIR_ARRAY(
15135: EGO_COL_NAME_VALUE_PAIR_OBJ(
15136: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
15137: )
15138: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
15139: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL

Line 15138: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

15134: EGO_COL_NAME_VALUE_PAIR_ARRAY(
15135: EGO_COL_NAME_VALUE_PAIR_OBJ(
15136: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
15137: )
15138: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
15139: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL
15140: )
15141: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
15142: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, NULL

Line 15141: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

15137: )
15138: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
15139: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL
15140: )
15141: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
15142: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, NULL
15143: )
15144: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
15145: l_ext_table_metadata_obj.pk_column_metadata(4).COL_NAME, NULL

Line 15144: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

15140: )
15141: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
15142: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, NULL
15143: )
15144: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
15145: l_ext_table_metadata_obj.pk_column_metadata(4).COL_NAME, NULL
15146: )
15147: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
15148: l_ext_table_metadata_obj.pk_column_metadata(5).COL_NAME, NULL

Line 15147: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

15143: )
15144: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
15145: l_ext_table_metadata_obj.pk_column_metadata(4).COL_NAME, NULL
15146: )
15147: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
15148: l_ext_table_metadata_obj.pk_column_metadata(5).COL_NAME, NULL
15149: )
15150: );
15151: l_chng_col_names_list := 'B.'||

Line 15175: EGO_COL_NAME_VALUE_PAIR_OBJ(

15171: '''';
15172: ELSIF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 4) THEN
15173: l_pk_column_name_value_pairs :=
15174: EGO_COL_NAME_VALUE_PAIR_ARRAY(
15175: EGO_COL_NAME_VALUE_PAIR_OBJ(
15176: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
15177: )
15178: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
15179: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL

Line 15178: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

15174: EGO_COL_NAME_VALUE_PAIR_ARRAY(
15175: EGO_COL_NAME_VALUE_PAIR_OBJ(
15176: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
15177: )
15178: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
15179: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL
15180: )
15181: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
15182: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, NULL

Line 15181: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

15177: )
15178: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
15179: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL
15180: )
15181: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
15182: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, NULL
15183: )
15184: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
15185: l_ext_table_metadata_obj.pk_column_metadata(4).COL_NAME, NULL

Line 15184: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

15180: )
15181: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
15182: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, NULL
15183: )
15184: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
15185: l_ext_table_metadata_obj.pk_column_metadata(4).COL_NAME, NULL
15186: )
15187: );
15188: l_chng_col_names_list := 'B.'||

Line 15208: EGO_COL_NAME_VALUE_PAIR_OBJ(

15204: '''';
15205: ELSIF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 3) THEN
15206: l_pk_column_name_value_pairs :=
15207: EGO_COL_NAME_VALUE_PAIR_ARRAY(
15208: EGO_COL_NAME_VALUE_PAIR_OBJ(
15209: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
15210: )
15211: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
15212: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL

Line 15211: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

15207: EGO_COL_NAME_VALUE_PAIR_ARRAY(
15208: EGO_COL_NAME_VALUE_PAIR_OBJ(
15209: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
15210: )
15211: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
15212: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL
15213: )
15214: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
15215: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, NULL

Line 15214: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

15210: )
15211: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
15212: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL
15213: )
15214: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
15215: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, NULL
15216: )
15217: );
15218: l_chng_col_names_list := 'B.'||

Line 15234: EGO_COL_NAME_VALUE_PAIR_OBJ(

15230: '''';
15231: ELSIF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 2) THEN
15232: l_pk_column_name_value_pairs :=
15233: EGO_COL_NAME_VALUE_PAIR_ARRAY(
15234: EGO_COL_NAME_VALUE_PAIR_OBJ(
15235: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
15236: )
15237: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
15238: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL

Line 15237: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

15233: EGO_COL_NAME_VALUE_PAIR_ARRAY(
15234: EGO_COL_NAME_VALUE_PAIR_OBJ(
15235: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
15236: )
15237: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
15238: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL
15239: )
15240: );
15241: l_chng_col_names_list := 'B.'||

Line 15253: EGO_COL_NAME_VALUE_PAIR_OBJ(

15249: '''';
15250: ELSIF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 1) THEN
15251: l_pk_column_name_value_pairs :=
15252: EGO_COL_NAME_VALUE_PAIR_ARRAY(
15253: EGO_COL_NAME_VALUE_PAIR_OBJ(
15254: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
15255: )
15256: );
15257: l_chng_col_names_list := 'B.'||

Line 15274: EGO_COL_NAME_VALUE_PAIR_OBJ(

15270: l_ext_table_metadata_obj.class_code_metadata.COUNT > 0 AND
15271: l_ext_table_metadata_obj.class_code_metadata(1).COL_NAME IS NOT NULL) THEN
15272: l_class_code_name_value_pairs :=
15273: EGO_COL_NAME_VALUE_PAIR_ARRAY(
15274: EGO_COL_NAME_VALUE_PAIR_OBJ(
15275: l_ext_table_metadata_obj.class_code_metadata(1).COL_NAME, NULL
15276: ),
15277: EGO_COL_NAME_VALUE_PAIR_OBJ(
15278: 'RELATED_CLASS_CODE_LIST_1', NULL

Line 15277: EGO_COL_NAME_VALUE_PAIR_OBJ(

15273: EGO_COL_NAME_VALUE_PAIR_ARRAY(
15274: EGO_COL_NAME_VALUE_PAIR_OBJ(
15275: l_ext_table_metadata_obj.class_code_metadata(1).COL_NAME, NULL
15276: ),
15277: EGO_COL_NAME_VALUE_PAIR_OBJ(
15278: 'RELATED_CLASS_CODE_LIST_1', NULL
15279: )
15280: );
15281:

Line 15591: EGO_COL_NAME_VALUE_PAIR_OBJ(l_current_column_name, l_retrieved_value);

15587: -- in a PL/SQL table for assignment below --
15588: --------------------------------------------
15589: l_uom_nv_pairs_index := l_uom_nv_pairs_index + 1;
15590: l_uom_column_nv_pairs(l_uom_nv_pairs_index) :=
15591: EGO_COL_NAME_VALUE_PAIR_OBJ(l_current_column_name, l_retrieved_value);
15592:
15593: ELSIF (l_current_column_name = 'LANGUAGE') THEN
15594:
15595: -------------------------------------------------------

Line 16475: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)

16471: p_pk_col4 IS NOT NULL AND
16472: p_pk_col5 IS NOT NULL) THEN
16473:
16474: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
16475: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
16476: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
16477: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)
16478: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col4, p_pk_value4)
16479: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col5, p_pk_value5)

Line 16476: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)

16472: p_pk_col5 IS NOT NULL) THEN
16473:
16474: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
16475: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
16476: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
16477: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)
16478: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col4, p_pk_value4)
16479: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col5, p_pk_value5)
16480: );

Line 16477: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)

16473:
16474: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
16475: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
16476: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
16477: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)
16478: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col4, p_pk_value4)
16479: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col5, p_pk_value5)
16480: );
16481:

Line 16478: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col4, p_pk_value4)

16474: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
16475: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
16476: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
16477: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)
16478: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col4, p_pk_value4)
16479: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col5, p_pk_value5)
16480: );
16481:
16482: ------------------------------------------------------------------

Line 16479: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col5, p_pk_value5)

16475: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
16476: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
16477: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)
16478: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col4, p_pk_value4)
16479: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col5, p_pk_value5)
16480: );
16481:
16482: ------------------------------------------------------------------
16483: -- We build a name/value pair array for our Primary Keys to use --

Line 16492: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)

16488: p_pk_col3 IS NOT NULL AND
16489: p_pk_col4 IS NOT NULL) THEN
16490:
16491: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
16492: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
16493: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
16494: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)
16495: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col4, p_pk_value4)
16496: );

Line 16493: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)

16489: p_pk_col4 IS NOT NULL) THEN
16490:
16491: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
16492: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
16493: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
16494: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)
16495: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col4, p_pk_value4)
16496: );
16497:

Line 16494: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)

16490:
16491: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
16492: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
16493: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
16494: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)
16495: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col4, p_pk_value4)
16496: );
16497:
16498: ELSIF (p_pk_col2 IS NOT NULL AND

Line 16495: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col4, p_pk_value4)

16491: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
16492: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
16493: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
16494: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)
16495: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col4, p_pk_value4)
16496: );
16497:
16498: ELSIF (p_pk_col2 IS NOT NULL AND
16499: p_pk_col3 IS NOT NULL) THEN

Line 16502: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)

16498: ELSIF (p_pk_col2 IS NOT NULL AND
16499: p_pk_col3 IS NOT NULL) THEN
16500:
16501: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
16502: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
16503: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
16504: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)
16505: );
16506:

Line 16503: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)

16499: p_pk_col3 IS NOT NULL) THEN
16500:
16501: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
16502: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
16503: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
16504: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)
16505: );
16506:
16507: ELSIF (p_pk_col2 IS NOT NULL) THEN

Line 16504: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)

16500:
16501: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
16502: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
16503: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
16504: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col3, p_pk_value3)
16505: );
16506:
16507: ELSIF (p_pk_col2 IS NOT NULL) THEN
16508:

Line 16510: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)

16506:
16507: ELSIF (p_pk_col2 IS NOT NULL) THEN
16508:
16509: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
16510: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
16511: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
16512: );
16513:
16514: ELSE

Line 16511: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)

16507: ELSIF (p_pk_col2 IS NOT NULL) THEN
16508:
16509: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
16510: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
16511: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col2, p_pk_value2)
16512: );
16513:
16514: ELSE
16515:

Line 16517: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)

16513:
16514: ELSE
16515:
16516: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
16517: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk_col1, p_pk_value1)
16518: );
16519:
16520: END IF;
16521:

Line 17105: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk1_column_name,p_pk1_value)

17101: END LOOP;
17102: END IF;
17103:
17104: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
17105: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk1_column_name,p_pk1_value)
17106: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk2_column_name,p_pk2_value)
17107: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk3_column_name,p_pk3_value)
17108: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)
17109: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)

Line 17106: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk2_column_name,p_pk2_value)

17102: END IF;
17103:
17104: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
17105: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk1_column_name,p_pk1_value)
17106: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk2_column_name,p_pk2_value)
17107: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk3_column_name,p_pk3_value)
17108: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)
17109: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)
17110: );

Line 17107: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk3_column_name,p_pk3_value)

17103:
17104: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
17105: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk1_column_name,p_pk1_value)
17106: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk2_column_name,p_pk2_value)
17107: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk3_column_name,p_pk3_value)
17108: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)
17109: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)
17110: );
17111: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

Line 17108: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)

17104: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
17105: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk1_column_name,p_pk1_value)
17106: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk2_column_name,p_pk2_value)
17107: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk3_column_name,p_pk3_value)
17108: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)
17109: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)
17110: );
17111: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
17112: EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level1_column_name,p_data_level1_value)

Line 17109: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)

17105: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk1_column_name,p_pk1_value)
17106: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk2_column_name,p_pk2_value)
17107: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk3_column_name,p_pk3_value)
17108: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)
17109: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)
17110: );
17111: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
17112: EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level1_column_name,p_data_level1_value)
17113: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level2_column_name,p_data_level2_value)

Line 17112: EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level1_column_name,p_data_level1_value)

17108: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)
17109: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)
17110: );
17111: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
17112: EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level1_column_name,p_data_level1_value)
17113: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level2_column_name,p_data_level2_value)
17114: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level3_column_name,p_data_level3_value)
17115: );
17116: l_attr_disp_value := Get_Disp_Val_For_Int_Val(

Line 17113: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level2_column_name,p_data_level2_value)

17109: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)
17110: );
17111: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
17112: EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level1_column_name,p_data_level1_value)
17113: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level2_column_name,p_data_level2_value)
17114: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level3_column_name,p_data_level3_value)
17115: );
17116: l_attr_disp_value := Get_Disp_Val_For_Int_Val(
17117: p_attr_value_obj => l_attr_value_obj

Line 17114: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level3_column_name,p_data_level3_value)

17110: );
17111: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
17112: EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level1_column_name,p_data_level1_value)
17113: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level2_column_name,p_data_level2_value)
17114: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level3_column_name,p_data_level3_value)
17115: );
17116: l_attr_disp_value := Get_Disp_Val_For_Int_Val(
17117: p_attr_value_obj => l_attr_value_obj
17118: ,p_attr_metadata_obj => l_attr_metadata_obj

Line 17279: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk1_column_name,p_pk1_value)

17275:
17276: END IF;
17277:
17278: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
17279: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk1_column_name,p_pk1_value)
17280: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk2_column_name,p_pk2_value)
17281: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk3_column_name,p_pk3_value)
17282: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)
17283: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)

Line 17280: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk2_column_name,p_pk2_value)

17276: END IF;
17277:
17278: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
17279: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk1_column_name,p_pk1_value)
17280: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk2_column_name,p_pk2_value)
17281: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk3_column_name,p_pk3_value)
17282: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)
17283: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)
17284: );

Line 17281: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk3_column_name,p_pk3_value)

17277:
17278: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
17279: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk1_column_name,p_pk1_value)
17280: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk2_column_name,p_pk2_value)
17281: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk3_column_name,p_pk3_value)
17282: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)
17283: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)
17284: );
17285:

Line 17282: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)

17278: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
17279: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk1_column_name,p_pk1_value)
17280: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk2_column_name,p_pk2_value)
17281: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk3_column_name,p_pk3_value)
17282: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)
17283: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)
17284: );
17285:
17286: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

Line 17283: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)

17279: EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk1_column_name,p_pk1_value)
17280: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk2_column_name,p_pk2_value)
17281: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk3_column_name,p_pk3_value)
17282: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk4_column_name,p_pk4_value)
17283: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)
17284: );
17285:
17286: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
17287: EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level1_column_name,p_data_level1_value)

Line 17287: EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level1_column_name,p_data_level1_value)

17283: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_pk5_column_name,p_pk5_value)
17284: );
17285:
17286: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
17287: EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level1_column_name,p_data_level1_value)
17288: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level2_column_name,p_data_level2_value)
17289: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level3_column_name,p_data_level3_value)
17290: );
17291:

Line 17288: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level2_column_name,p_data_level2_value)

17284: );
17285:
17286: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
17287: EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level1_column_name,p_data_level1_value)
17288: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level2_column_name,p_data_level2_value)
17289: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level3_column_name,p_data_level3_value)
17290: );
17291:
17292:

Line 17289: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level3_column_name,p_data_level3_value)

17285:
17286: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
17287: EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level1_column_name,p_data_level1_value)
17288: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level2_column_name,p_data_level2_value)
17289: ,EGO_COL_NAME_VALUE_PAIR_OBJ(p_data_level3_column_name,p_data_level3_value)
17290: );
17291:
17292:
17293: IF (p_ext_table_metadata_obj IS NOT NULL) THEN

Line 17343: ,x_data_level_obj OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_OBJ

17339: ---------------------------------------------------------------------------
17340:
17341: PROCEDURE Process_Data_Level_Nvp(
17342: p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
17343: ,x_data_level_obj OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_OBJ
17344: ,x_data_level_index OUT NOCOPY NUMBER
17345: ) IS
17346: l_api_name VARCHAR2(30) := 'Process_data_level_nvp';
17347: BEGIN

Line 17393: ,x_base_class_obj OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_OBJ

17389: ---------------------------------------------------------------------------
17390:
17391: PROCEDURE Process_Class_Code_Nvp(
17392: p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
17393: ,x_base_class_obj OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_OBJ
17394: ,x_related_class_obj OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_OBJ
17395: ) IS
17396: l_api_name VARCHAR2(30) := 'Process_Class_Code_Nvp';
17397: BEGIN

Line 17394: ,x_related_class_obj OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_OBJ

17390:
17391: PROCEDURE Process_Class_Code_Nvp(
17392: p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
17393: ,x_base_class_obj OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_OBJ
17394: ,x_related_class_obj OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_OBJ
17395: ) IS
17396: l_api_name VARCHAR2(30) := 'Process_Class_Code_Nvp';
17397: BEGIN
17398:

Line 17443: l_base_class_obj EGO_COL_NAME_VALUE_PAIR_OBJ;

17439: PROCEDURE Build_Class_Code_Table(
17440: p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
17441: ,x_class_code_table OUT NOCOPY LOCAL_MEDIUM_VARCHAR_TABLE
17442: ) IS
17443: l_base_class_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
17444: l_related_class_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
17445: l_remaining VARCHAR2(300);
17446: l_current_val VARCHAR2(300); --EGO_COL_NAME_VALUE_PAIR_OBJ.VALUE%TYPE;
17447: l_index NUMBER;

Line 17444: l_related_class_obj EGO_COL_NAME_VALUE_PAIR_OBJ;

17440: p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
17441: ,x_class_code_table OUT NOCOPY LOCAL_MEDIUM_VARCHAR_TABLE
17442: ) IS
17443: l_base_class_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
17444: l_related_class_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
17445: l_remaining VARCHAR2(300);
17446: l_current_val VARCHAR2(300); --EGO_COL_NAME_VALUE_PAIR_OBJ.VALUE%TYPE;
17447: l_index NUMBER;
17448: BEGIN

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

17442: ) IS
17443: l_base_class_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
17444: l_related_class_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
17445: l_remaining VARCHAR2(300);
17446: l_current_val VARCHAR2(300); --EGO_COL_NAME_VALUE_PAIR_OBJ.VALUE%TYPE;
17447: l_index NUMBER;
17448: BEGIN
17449:
17450: Debug_Msg('In Build_Class_Code_Table, starting', 2);

Line 17597: p_data_level_obj IN EGO_COL_NAME_VALUE_PAIR_OBJ

17593: ----------------------------------------------------------------------------
17594:
17595:
17596: PROCEDURE Process_Data_Level_Values(
17597: p_data_level_obj IN EGO_COL_NAME_VALUE_PAIR_OBJ
17598: ,p_data_level_ind IN NUMBER
17599: ,x_data_level_1 OUT NOCOPY VARCHAR2
17600: ,x_data_level_2 OUT NOCOPY VARCHAR2
17601: ,x_data_level_3 OUT NOCOPY VARCHAR2

Line 17656: l_data_level_obj EGO_COL_NAME_VALUE_PAIR_OBJ;

17652:
17653: l_api_name VARCHAR2(30) := 'Build_Request_Table_For_Obj';
17654: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
17655: l_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
17656: l_data_level_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
17657: l_data_level_index NUMBER;
17658: l_class_code_table LOCAL_MEDIUM_VARCHAR_TABLE;
17659: l_attr_group_id ego_obj_ag_assocs_b.attr_group_id%TYPE;
17660: l_data_level_1 VARCHAR2(150);

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

18789: IF(l_attr_data_table.COUNT > 0 AND l_attr_row_table.COUNT > 0 ) THEN
18790:
18791: l_cc_name_value_pairs := p_class_code_name_value_pairs;
18792: l_cc_name_value_pairs.EXTEND();
18793: l_cc_name_value_pairs(2) := EGO_COL_NAME_VALUE_PAIR_OBJ('RELATED_CLASS_CODE_LIST',l_related_class_Code_list);
18794: Debug_Msg(l_api_name ||' Calling Process_User_Attrs_Data ');
18795: Process_User_Attrs_Data(
18796: p_api_version => 1.0
18797: ,p_object_name => p_object_name