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_ARRAY

Line 1593: -- l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1589: l_out_organization_id NUMBER ;
1590: l_process_control VARCHAR2(30) ;
1591: l_process_item NUMBER ;
1592:
1593: -- l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1594: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE := EGO_USER_ATTR_DATA_TABLE();
1595: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
1596:
1597: l_mode_for_current_row VARCHAR2(10);

Line 1613: -- l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1609:
1610:
1611: -- l_uom_column_nv_pairs LOCAL_COL_NV_PAIR_TABLE;
1612: -- l_uom_nv_pairs_index NUMBER := 0;
1613: -- l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1614: -- l_current_dl_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
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);

Line 1614: -- l_current_dl_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1610:
1611: -- l_uom_column_nv_pairs LOCAL_COL_NV_PAIR_TABLE;
1612: -- l_uom_nv_pairs_index NUMBER := 0;
1613: -- l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1614: -- l_current_dl_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
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;

Line 1616: -- l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1612: -- l_uom_nv_pairs_index NUMBER := 0;
1613: -- l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1614: -- l_current_dl_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
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);

Line 2988: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

2984: l_current_production_ext_id NUMBER;
2985: l_ext_id_for_current_row NUMBER;
2986:
2987:
2988: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2989: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE := EGO_USER_ATTR_DATA_TABLE();
2990: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
2991:
2992: l_num_value NUMBER ;

Line 3047: -- l_current_dl_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

3043: l_orig_territory VARCHAR2(64);
3044: l_orig_chrs VARCHAR2(64);
3045:
3046: ind NUMBER;
3047: -- l_current_dl_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3048: -- l_object_id NUMBER;
3049: -- l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
3050:
3051:

Line 3778: EGO_COL_NAME_VALUE_PAIR_ARRAY(

3774: -- the column values and then calling Process_Row --
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:

Line 4490: ,p_old_data_level_nv_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

4486: ,p_change_b_table_name IN VARCHAR2
4487: ,p_change_tl_table_name IN VARCHAR2
4488: ,p_tables_application_id IN NUMBER
4489: ,p_change_line_id IN NUMBER
4490: ,p_old_data_level_nv_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
4491: ,p_new_data_level_nv_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
4492: ,p_related_class_code_function IN VARCHAR2
4493: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
4494: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 4491: ,p_new_data_level_nv_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

4487: ,p_change_tl_table_name IN VARCHAR2
4488: ,p_tables_application_id IN NUMBER
4489: ,p_change_line_id IN NUMBER
4490: ,p_old_data_level_nv_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
4491: ,p_new_data_level_nv_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
4492: ,p_related_class_code_function IN VARCHAR2
4493: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
4494: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
4495: ,x_return_status OUT NOCOPY VARCHAR2

Line 4509: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY ;

4505: --if we change optional parameters, version goes FROM x.n to x.(n+1)
4506: l_api_version CONSTANT NUMBER := 1.0;
4507:
4508: l_object_id NUMBER;
4509: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY ;
4510: l_current_dl_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
4511: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
4512: l_chng_col_names_list VARCHAR2(20000);
4513: l_cols_to_exclude_list VARCHAR2(2000);

Line 4510: l_current_dl_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

4506: l_api_version CONSTANT NUMBER := 1.0;
4507:
4508: l_object_id NUMBER;
4509: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY ;
4510: l_current_dl_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
4511: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
4512: l_chng_col_names_list VARCHAR2(20000);
4513: l_cols_to_exclude_list VARCHAR2(2000);
4514: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

Line 4514: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

4510: l_current_dl_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
4511: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
4512: l_chng_col_names_list VARCHAR2(20000);
4513: l_cols_to_exclude_list VARCHAR2(2000);
4514: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
4515: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
4516: l_b_chng_cols_list VARCHAR2(10000);
4517: l_tl_chng_cols_list VARCHAR2(10000);
4518: l_history_b_chng_cols_list VARCHAR2(10000);

Line 4515: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

4511: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
4512: l_chng_col_names_list VARCHAR2(20000);
4513: l_cols_to_exclude_list VARCHAR2(2000);
4514: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
4515: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
4516: l_b_chng_cols_list VARCHAR2(10000);
4517: l_tl_chng_cols_list VARCHAR2(10000);
4518: l_history_b_chng_cols_list VARCHAR2(10000);
4519: l_history_tl_chng_cols_list VARCHAR2(10000);

Line 4613: EGO_COL_NAME_VALUE_PAIR_ARRAY(

4609: -- ASSUMPTION: no PKs will ever be DATE objects
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(

Line 4653: EGO_COL_NAME_VALUE_PAIR_ARRAY(

4649: l_ext_table_metadata_obj.pk_column_metadata(5).COL_NAME||
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(

Line 4686: EGO_COL_NAME_VALUE_PAIR_ARRAY(

4682: l_ext_table_metadata_obj.pk_column_metadata(4).COL_NAME||
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(

Line 4712: EGO_COL_NAME_VALUE_PAIR_ARRAY(

4708: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME||
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(

Line 4731: EGO_COL_NAME_VALUE_PAIR_ARRAY(

4727: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME||
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: );

Line 4755: EGO_COL_NAME_VALUE_PAIR_ARRAY(

4751: IF (l_ext_table_metadata_obj.class_code_metadata IS NOT NULL AND
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(

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 5888: l_old_data_level_nv_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

5884:
5885: plsql_block VARCHAR2(5000);
5886:
5887:
5888: l_old_data_level_nv_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
5889: l_new_data_level_nv_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
5890:
5891: BEGIN
5892:

Line 5889: l_new_data_level_nv_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

5885: plsql_block VARCHAR2(5000);
5886:
5887:
5888: l_old_data_level_nv_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
5889: l_new_data_level_nv_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
5890:
5891: BEGIN
5892:
5893:

Line 5997: l_old_data_level_nv_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

5993: ---------------------------------------------------------------------
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;

Line 6004: l_new_data_level_nv_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

6000: );
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;