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 1610: -- l_current_uom_col_nv_obj EGO_COL_NAME_VALUE_PAIR_OBJ;

1606: -- l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
1607: -- l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1608: -- l_dummy_err_msg_name VARCHAR2(30);
1609: -- l_token_table ERROR_HANDLER.Token_Tbl_Type;
1610: -- l_current_uom_col_nv_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
1611: -- l_attr_col_name_for_uom_col VARCHAR2(30);
1612:
1613: BEGIN
1614:

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

2021: -- in a PL/SQL table for assignment below --
2022: --------------------------------------------
2023: -- l_uom_nv_pairs_index := l_uom_nv_pairs_index + 1;
2024: -- l_uom_column_nv_pairs(l_uom_nv_pairs_index) :=
2025: -- EGO_COL_NAME_VALUE_PAIR_OBJ(l_current_column_name, l_retrieved_value);
2026: --
2027: -------------------------------------------------------------------------
2028:
2029: ELSIF (l_current_column_name = 'LANGUAGE') THEN

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

3490: -- in a PL/SQL table for assignment below --
3491: --------------------------------------------
3492: -- l_uom_nv_pairs_index := l_uom_nv_pairs_index + 1;
3493: -- l_uom_column_nv_pairs(l_uom_nv_pairs_index) :=
3494: -- EGO_COL_NAME_VALUE_PAIR_OBJ(l_current_column_name, l_retrieved_value);
3495: --
3496: -------------------------------------------------------------------------
3497:
3498: END IF;

Line 3795: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', NULL)

3791: ----------------------------------------------------
3792:
3793: l_pk_column_name_value_pairs :=
3794: EGO_COL_NAME_VALUE_PAIR_ARRAY(
3795: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', NULL)
3796: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', NULL)
3797: );
3798:
3799:

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

3792:
3793: l_pk_column_name_value_pairs :=
3794: EGO_COL_NAME_VALUE_PAIR_ARRAY(
3795: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', NULL)
3796: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', NULL)
3797: );
3798:
3799:
3800: -- l_object_id := Get_Object_Id_From_Name(G_EGO_ITEM);

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

3971: -- in a PL/SQL table for assignment below --
3972: --------------------------------------------
3973: -- l_uom_nv_pairs_index := l_uom_nv_pairs_index + 1;
3974: -- l_uom_column_nv_pairs(l_uom_nv_pairs_index) :=
3975: -- EGO_COL_NAME_VALUE_PAIR_OBJ(l_current_column_name, l_retrieved_value);
3976: --
3977: -------------------------------------------------------------------------
3978: /***********************************************/
3979:

Line 4558: l_current_uom_col_nv_obj EGO_COL_NAME_VALUE_PAIR_OBJ;

4554: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE := EGO_USER_ATTR_DATA_TABLE();
4555: l_impl_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE := EGO_USER_ATTR_DATA_TABLE();
4556: l_uom_column_nv_pairs LOCAL_COL_NV_PAIR_TABLE;
4557: l_uom_nv_pairs_index NUMBER := 0;
4558: l_current_uom_col_nv_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
4559: l_attr_col_name_for_uom_col VARCHAR2(30);
4560: l_current_production_ext_id NUMBER;
4561: l_mode_for_current_row VARCHAR2(10);
4562: l_ext_id_for_current_row NUMBER;

Line 4630: EGO_COL_NAME_VALUE_PAIR_OBJ(

4626: --
4627: IF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 5) THEN
4628: l_pk_column_name_value_pairs :=
4629: EGO_COL_NAME_VALUE_PAIR_ARRAY(
4630: EGO_COL_NAME_VALUE_PAIR_OBJ(
4631: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
4632: )
4633: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4634: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL

Line 4633: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

4629: EGO_COL_NAME_VALUE_PAIR_ARRAY(
4630: EGO_COL_NAME_VALUE_PAIR_OBJ(
4631: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
4632: )
4633: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4634: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL
4635: )
4636: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4637: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, NULL

Line 4636: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

4632: )
4633: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4634: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL
4635: )
4636: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4637: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, NULL
4638: )
4639: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4640: l_ext_table_metadata_obj.pk_column_metadata(4).COL_NAME, NULL

Line 4639: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

4635: )
4636: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4637: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, NULL
4638: )
4639: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4640: l_ext_table_metadata_obj.pk_column_metadata(4).COL_NAME, NULL
4641: )
4642: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4643: l_ext_table_metadata_obj.pk_column_metadata(5).COL_NAME, NULL

Line 4642: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

4638: )
4639: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4640: l_ext_table_metadata_obj.pk_column_metadata(4).COL_NAME, NULL
4641: )
4642: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4643: l_ext_table_metadata_obj.pk_column_metadata(5).COL_NAME, NULL
4644: )
4645: );
4646: l_chng_col_names_list := 'B.'||

Line 4670: EGO_COL_NAME_VALUE_PAIR_OBJ(

4666: '''';
4667: ELSIF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 4) THEN
4668: l_pk_column_name_value_pairs :=
4669: EGO_COL_NAME_VALUE_PAIR_ARRAY(
4670: EGO_COL_NAME_VALUE_PAIR_OBJ(
4671: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
4672: )
4673: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4674: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL

Line 4673: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

4669: EGO_COL_NAME_VALUE_PAIR_ARRAY(
4670: EGO_COL_NAME_VALUE_PAIR_OBJ(
4671: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
4672: )
4673: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4674: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL
4675: )
4676: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4677: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, NULL

Line 4676: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

4672: )
4673: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4674: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL
4675: )
4676: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4677: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, NULL
4678: )
4679: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4680: l_ext_table_metadata_obj.pk_column_metadata(4).COL_NAME, NULL

Line 4679: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

4675: )
4676: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4677: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, NULL
4678: )
4679: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4680: l_ext_table_metadata_obj.pk_column_metadata(4).COL_NAME, NULL
4681: )
4682: );
4683: l_chng_col_names_list := 'B.'||

Line 4703: EGO_COL_NAME_VALUE_PAIR_OBJ(

4699: '''';
4700: ELSIF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 3) THEN
4701: l_pk_column_name_value_pairs :=
4702: EGO_COL_NAME_VALUE_PAIR_ARRAY(
4703: EGO_COL_NAME_VALUE_PAIR_OBJ(
4704: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
4705: )
4706: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4707: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL

Line 4706: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

4702: EGO_COL_NAME_VALUE_PAIR_ARRAY(
4703: EGO_COL_NAME_VALUE_PAIR_OBJ(
4704: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
4705: )
4706: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4707: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL
4708: )
4709: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4710: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, NULL

Line 4709: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

4705: )
4706: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4707: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL
4708: )
4709: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4710: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, NULL
4711: )
4712: );
4713: l_chng_col_names_list := 'B.'||

Line 4729: EGO_COL_NAME_VALUE_PAIR_OBJ(

4725: '''';
4726: ELSIF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 2) THEN
4727: l_pk_column_name_value_pairs :=
4728: EGO_COL_NAME_VALUE_PAIR_ARRAY(
4729: EGO_COL_NAME_VALUE_PAIR_OBJ(
4730: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
4731: )
4732: ,EGO_COL_NAME_VALUE_PAIR_OBJ(
4733: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, NULL

Line 4732: ,EGO_COL_NAME_VALUE_PAIR_OBJ(

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

Line 4748: EGO_COL_NAME_VALUE_PAIR_OBJ(

4744: '''';
4745: ELSIF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 1) THEN
4746: l_pk_column_name_value_pairs :=
4747: EGO_COL_NAME_VALUE_PAIR_ARRAY(
4748: EGO_COL_NAME_VALUE_PAIR_OBJ(
4749: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, NULL
4750: )
4751: );
4752: l_chng_col_names_list := 'B.'||

Line 4772: EGO_COL_NAME_VALUE_PAIR_OBJ(

4768: l_ext_table_metadata_obj.class_code_metadata.COUNT > 0 AND
4769: l_ext_table_metadata_obj.class_code_metadata(1).COL_NAME IS NOT NULL) THEN
4770: l_class_code_name_value_pairs :=
4771: EGO_COL_NAME_VALUE_PAIR_ARRAY(
4772: EGO_COL_NAME_VALUE_PAIR_OBJ(
4773: l_ext_table_metadata_obj.class_code_metadata(1).COL_NAME, NULL
4774: ),
4775: EGO_COL_NAME_VALUE_PAIR_OBJ(
4776: 'RELATED_CLASS_CODE_LIST_1', NULL

Line 4775: EGO_COL_NAME_VALUE_PAIR_OBJ(

4771: EGO_COL_NAME_VALUE_PAIR_ARRAY(
4772: EGO_COL_NAME_VALUE_PAIR_OBJ(
4773: l_ext_table_metadata_obj.class_code_metadata(1).COL_NAME, NULL
4774: ),
4775: EGO_COL_NAME_VALUE_PAIR_OBJ(
4776: 'RELATED_CLASS_CODE_LIST_1', NULL
4777: )
4778: );
4779:

Line 5006: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(

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

Line 5012: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(

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

Line 5021: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(

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

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

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

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

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

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

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

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

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

Line 5194: EGO_COL_NAME_VALUE_PAIR_OBJ(l_current_column_name, l_retrieved_value);

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

Line 5960: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID',

5956: -- Build data structures to pass in Data Level info, if applicable --
5957: ---------------------------------------------------------------------
5958: IF (l_old_revision_id IS NOT NULL) THEN
5959: l_old_data_level_nv_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
5960: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID',
5961: l_old_revision_id)
5962: );
5963: END IF;
5964:

Line 5967: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID',

5963: END IF;
5964:
5965: IF (l_new_revision_id IS NOT NULL) THEN
5966: l_new_data_level_nv_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
5967: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID',
5968: l_new_revision_id)
5969: );
5970: END IF;
5971: