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.ENG_IMPL_ITEM_CHANGES_PKG dependencies on EGO_COL_NAME_VALUE_PAIR_OBJ

Line 125: TYPE LOCAL_COL_NV_PAIR_TABLE IS TABLE OF EGO_COL_NAME_VALUE_PAIR_OBJ

121:
122: ------------------------
123: -- Private Data Types --
124: ------------------------
125: TYPE LOCAL_COL_NV_PAIR_TABLE IS TABLE OF EGO_COL_NAME_VALUE_PAIR_OBJ
126: INDEX BY BINARY_INTEGER;
127:
128:
129:

Line 1619: -- l_current_uom_col_nv_obj EGO_COL_NAME_VALUE_PAIR_OBJ;

1615: -- l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
1616: -- l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1617: -- l_dummy_err_msg_name VARCHAR2(30);
1618: -- l_token_table ERROR_HANDLER.Token_Tbl_Type;
1619: -- l_current_uom_col_nv_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
1620: -- l_attr_col_name_for_uom_col VARCHAR2(30);
1621:
1622: BEGIN
1623:

Line 2034: -- EGO_COL_NAME_VALUE_PAIR_OBJ(l_current_column_name, l_retrieved_value);

2030: -- in a PL/SQL table for assignment below --
2031: --------------------------------------------
2032: -- l_uom_nv_pairs_index := l_uom_nv_pairs_index + 1;
2033: -- l_uom_column_nv_pairs(l_uom_nv_pairs_index) :=
2034: -- EGO_COL_NAME_VALUE_PAIR_OBJ(l_current_column_name, l_retrieved_value);
2035: --
2036: -------------------------------------------------------------------------
2037:
2038: ELSIF (l_current_column_name = 'LANGUAGE') THEN

Line 3478: -- EGO_COL_NAME_VALUE_PAIR_OBJ(l_current_column_name, l_retrieved_value);

3474: -- in a PL/SQL table for assignment below --
3475: --------------------------------------------
3476: -- l_uom_nv_pairs_index := l_uom_nv_pairs_index + 1;
3477: -- l_uom_column_nv_pairs(l_uom_nv_pairs_index) :=
3478: -- EGO_COL_NAME_VALUE_PAIR_OBJ(l_current_column_name, l_retrieved_value);
3479: --
3480: -------------------------------------------------------------------------
3481:
3482: END IF;

Line 3779: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', NULL)

3775: ----------------------------------------------------
3776:
3777: l_pk_column_name_value_pairs :=
3778: EGO_COL_NAME_VALUE_PAIR_ARRAY(
3779: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', NULL)
3780: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', NULL)
3781: );
3782:
3783:

Line 3780: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', NULL)

3776:
3777: l_pk_column_name_value_pairs :=
3778: EGO_COL_NAME_VALUE_PAIR_ARRAY(
3779: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', NULL)
3780: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', NULL)
3781: );
3782:
3783:
3784: -- l_object_id := Get_Object_Id_From_Name(G_EGO_ITEM);

Line 3959: -- EGO_COL_NAME_VALUE_PAIR_OBJ(l_current_column_name, l_retrieved_value);

3955: -- in a PL/SQL table for assignment below --
3956: --------------------------------------------
3957: -- l_uom_nv_pairs_index := l_uom_nv_pairs_index + 1;
3958: -- l_uom_column_nv_pairs(l_uom_nv_pairs_index) :=
3959: -- EGO_COL_NAME_VALUE_PAIR_OBJ(l_current_column_name, l_retrieved_value);
3960: --
3961: -------------------------------------------------------------------------
3962: /***********************************************/
3963:

Line 4542: l_current_uom_col_nv_obj EGO_COL_NAME_VALUE_PAIR_OBJ;

4538: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE := EGO_USER_ATTR_DATA_TABLE();
4539: l_impl_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE := EGO_USER_ATTR_DATA_TABLE();
4540: l_uom_column_nv_pairs LOCAL_COL_NV_PAIR_TABLE;
4541: l_uom_nv_pairs_index NUMBER := 0;
4542: l_current_uom_col_nv_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
4543: l_attr_col_name_for_uom_col VARCHAR2(30);
4544: l_current_production_ext_id NUMBER;
4545: l_mode_for_current_row VARCHAR2(10);
4546: l_ext_id_for_current_row NUMBER;

Line 4614: EGO_COL_NAME_VALUE_PAIR_OBJ(

4610: --
4611: IF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 5) THEN
4612: l_pk_column_name_value_pairs :=
4613: EGO_COL_NAME_VALUE_PAIR_ARRAY(
4614: EGO_COL_NAME_VALUE_PAIR_OBJ(
4615: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
4616: )
4617: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4618: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL

Line 4617: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

4613: EGO_COL_NAME_VALUE_PAIR_ARRAY(
4614: EGO_COL_NAME_VALUE_PAIR_OBJ(
4615: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
4616: )
4617: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4618: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL
4619: )
4620: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4621: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, NULL

Line 4620: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

4616: )
4617: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4618: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL
4619: )
4620: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4621: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, NULL
4622: )
4623: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4624: l_ext_table_metadata_obj.pk_column_metadata(4).COL_NAME, NULL

Line 4623: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

4619: )
4620: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4621: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, NULL
4622: )
4623: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4624: l_ext_table_metadata_obj.pk_column_metadata(4).COL_NAME, NULL
4625: )
4626: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4627: l_ext_table_metadata_obj.pk_column_metadata(5).COL_NAME, NULL

Line 4626: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

4622: )
4623: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4624: l_ext_table_metadata_obj.pk_column_metadata(4).COL_NAME, NULL
4625: )
4626: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4627: l_ext_table_metadata_obj.pk_column_metadata(5).COL_NAME, NULL
4628: )
4629: );
4630: l_chng_col_names_list := 'B.'||

Line 4654: EGO_COL_NAME_VALUE_PAIR_OBJ(

4650: '''';
4651: ELSIF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 4) THEN
4652: l_pk_column_name_value_pairs :=
4653: EGO_COL_NAME_VALUE_PAIR_ARRAY(
4654: EGO_COL_NAME_VALUE_PAIR_OBJ(
4655: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
4656: )
4657: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4658: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL

Line 4657: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

4653: EGO_COL_NAME_VALUE_PAIR_ARRAY(
4654: EGO_COL_NAME_VALUE_PAIR_OBJ(
4655: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
4656: )
4657: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4658: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL
4659: )
4660: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4661: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, NULL

Line 4660: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

4656: )
4657: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4658: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL
4659: )
4660: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4661: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, NULL
4662: )
4663: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4664: l_ext_table_metadata_obj.pk_column_metadata(4).COL_NAME, NULL

Line 4663: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

4659: )
4660: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4661: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, NULL
4662: )
4663: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4664: l_ext_table_metadata_obj.pk_column_metadata(4).COL_NAME, NULL
4665: )
4666: );
4667: l_chng_col_names_list := 'B.'||

Line 4687: EGO_COL_NAME_VALUE_PAIR_OBJ(

4683: '''';
4684: ELSIF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 3) THEN
4685: l_pk_column_name_value_pairs :=
4686: EGO_COL_NAME_VALUE_PAIR_ARRAY(
4687: EGO_COL_NAME_VALUE_PAIR_OBJ(
4688: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
4689: )
4690: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4691: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL

Line 4690: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

4686: EGO_COL_NAME_VALUE_PAIR_ARRAY(
4687: EGO_COL_NAME_VALUE_PAIR_OBJ(
4688: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
4689: )
4690: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4691: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL
4692: )
4693: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4694: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, NULL

Line 4693: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

4689: )
4690: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4691: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL
4692: )
4693: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4694: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, NULL
4695: )
4696: );
4697: l_chng_col_names_list := 'B.'||

Line 4713: EGO_COL_NAME_VALUE_PAIR_OBJ(

4709: '''';
4710: ELSIF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 2) THEN
4711: l_pk_column_name_value_pairs :=
4712: EGO_COL_NAME_VALUE_PAIR_ARRAY(
4713: EGO_COL_NAME_VALUE_PAIR_OBJ(
4714: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
4715: )
4716: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4717: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL

Line 4716: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

4712: EGO_COL_NAME_VALUE_PAIR_ARRAY(
4713: EGO_COL_NAME_VALUE_PAIR_OBJ(
4714: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
4715: )
4716: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4717: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL
4718: )
4719: );
4720: l_chng_col_names_list := 'B.'||

Line 4732: EGO_COL_NAME_VALUE_PAIR_OBJ(

4728: '''';
4729: ELSIF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 1) THEN
4730: l_pk_column_name_value_pairs :=
4731: EGO_COL_NAME_VALUE_PAIR_ARRAY(
4732: EGO_COL_NAME_VALUE_PAIR_OBJ(
4733: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
4734: )
4735: );
4736: l_chng_col_names_list := 'B.'||

Line 4756: EGO_COL_NAME_VALUE_PAIR_OBJ(

4752: l_ext_table_metadata_obj.class_code_metadata.COUNT > 0 AND
4753: l_ext_table_metadata_obj.class_code_metadata(1).COL_NAME IS NOT NULL) THEN
4754: l_class_code_name_value_pairs :=
4755: EGO_COL_NAME_VALUE_PAIR_ARRAY(
4756: EGO_COL_NAME_VALUE_PAIR_OBJ(
4757: l_ext_table_metadata_obj.class_code_metadata(1).COL_NAME, NULL
4758: ),
4759: EGO_COL_NAME_VALUE_PAIR_OBJ(
4760: 'RELATED_CLASS_CODE_LIST_1', NULL

Line 4759: EGO_COL_NAME_VALUE_PAIR_OBJ(

4755: EGO_COL_NAME_VALUE_PAIR_ARRAY(
4756: EGO_COL_NAME_VALUE_PAIR_OBJ(
4757: l_ext_table_metadata_obj.class_code_metadata(1).COL_NAME, NULL
4758: ),
4759: EGO_COL_NAME_VALUE_PAIR_OBJ(
4760: 'RELATED_CLASS_CODE_LIST_1', NULL
4761: )
4762: );
4763:

Line 5005: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(

5001: IF L_DATA_LEVEL_NAME='ITEM_REVISION_LEVEL'
5002: THEN
5003: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
5004: l_current_column_index := l_current_column_index + 5;
5005: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(
5006: L_DATA_LEVEL_META_DATA.PK_COLUMN_NAME1,
5007: l_retrieved_value));
5008:
5009:

Line 5011: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(

5007: l_retrieved_value));
5008:
5009:
5010: ELSE
5011: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(
5012: null,
5013: null));
5014: l_current_column_index := l_current_column_index + 1;
5015: if L_DATA_LEVEL_META_DATA.PK_COLUMN_NAME1 IS NOT NULL

Line 5020: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(

5016: THEN
5017: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
5018:
5019: --l_current_column_index := l_current_column_index + 1;
5020: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(
5021: L_DATA_LEVEL_META_DATA.PK_COLUMN_NAME1,
5022: l_retrieved_value));
5023: -- ELSE
5024: -- l_current_column_index := l_current_column_index + 1;

Line 5034: l_data_level_name_value_pairs(l_data_level_name_value_pairs.LAST):= EGO_COL_NAME_VALUE_PAIR_OBJ(

5030:
5031: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
5032: --l_current_column_index := l_current_column_index + 1;
5033: l_data_level_name_value_pairs.EXTEND;
5034: l_data_level_name_value_pairs(l_data_level_name_value_pairs.LAST):= EGO_COL_NAME_VALUE_PAIR_OBJ(
5035: L_DATA_LEVEL_META_DATA.PK_COLUMN_NAME2,
5036: l_retrieved_value);
5037: -- else
5038: --l_current_column_index := l_current_column_index + 1;

Line 5048: l_data_level_name_value_pairs(l_data_level_name_value_pairs.LAST):= EGO_COL_NAME_VALUE_PAIR_OBJ(

5044:
5045: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
5046: -- l_current_column_index := l_current_column_index + 1;
5047: l_data_level_name_value_pairs.EXTEND;
5048: l_data_level_name_value_pairs(l_data_level_name_value_pairs.LAST):= EGO_COL_NAME_VALUE_PAIR_OBJ(
5049: L_DATA_LEVEL_META_DATA.PK_COLUMN_NAME3,
5050: l_retrieved_value);
5051: -- else
5052: -- l_current_column_index := l_current_column_index + 1;

Line 5062: l_data_level_name_value_pairs(l_data_level_name_value_pairs.LAST):= EGO_COL_NAME_VALUE_PAIR_OBJ(

5058:
5059: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
5060: --l_current_column_index := l_current_column_index + 1;
5061: l_data_level_name_value_pairs.EXTEND;
5062: l_data_level_name_value_pairs(l_data_level_name_value_pairs.LAST):= EGO_COL_NAME_VALUE_PAIR_OBJ(
5063: L_DATA_LEVEL_META_DATA.PK_COLUMN_NAME4,
5064: l_retrieved_value);
5065: --else
5066: --l_current_column_index := l_current_column_index + 1;

Line 5076: l_data_level_name_value_pairs(l_data_level_name_value_pairs.LAST):= EGO_COL_NAME_VALUE_PAIR_OBJ(

5072:
5073: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
5074: --l_current_column_index := l_current_column_index + 1;
5075: l_data_level_name_value_pairs.EXTEND;
5076: l_data_level_name_value_pairs(l_data_level_name_value_pairs.LAST):= EGO_COL_NAME_VALUE_PAIR_OBJ(
5077: L_DATA_LEVEL_META_DATA.PK_COLUMN_NAME5,
5078: l_retrieved_value);
5079: --else
5080: -- l_current_column_index := l_current_column_index + 1;

Line 5193: EGO_COL_NAME_VALUE_PAIR_OBJ(l_current_column_name, l_retrieved_value);

5189: -- in a PL/SQL table for assignment below --
5190: --------------------------------------------
5191: l_uom_nv_pairs_index := l_uom_nv_pairs_index + 1;
5192: l_uom_column_nv_pairs(l_uom_nv_pairs_index) :=
5193: EGO_COL_NAME_VALUE_PAIR_OBJ(l_current_column_name, l_retrieved_value);
5194:
5195: ELSIF (l_current_column_name = 'LANGUAGE') THEN
5196:
5197: -------------------------------------------------------

Line 5998: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID',

5994: -- Build data structures to pass in Data Level info, if applicable --
5995: ---------------------------------------------------------------------
5996: IF (l_old_revision_id IS NOT NULL) THEN
5997: l_old_data_level_nv_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
5998: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID',
5999: l_old_revision_id)
6000: );
6001: END IF;
6002:

Line 6005: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID',

6001: END IF;
6002:
6003: IF (l_new_revision_id IS NOT NULL) THEN
6004: l_new_data_level_nv_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
6005: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID',
6006: l_new_revision_id)
6007: );
6008: END IF;
6009: