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 1584: -- l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1580: l_out_organization_id NUMBER ;
1581: l_process_control VARCHAR2(30) ;
1582: l_process_item NUMBER ;
1583:
1584: -- l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1585: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE := EGO_USER_ATTR_DATA_TABLE();
1586: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
1587:
1588: l_mode_for_current_row VARCHAR2(10);

Line 1604: -- l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1600:
1601:
1602: -- l_uom_column_nv_pairs LOCAL_COL_NV_PAIR_TABLE;
1603: -- l_uom_nv_pairs_index NUMBER := 0;
1604: -- l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1605: -- l_current_dl_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
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);

Line 1605: -- l_current_dl_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1601:
1602: -- l_uom_column_nv_pairs LOCAL_COL_NV_PAIR_TABLE;
1603: -- l_uom_nv_pairs_index NUMBER := 0;
1604: -- l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1605: -- l_current_dl_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
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;

Line 1607: -- l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1603: -- l_uom_nv_pairs_index NUMBER := 0;
1604: -- l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1605: -- l_current_dl_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
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);

Line 3004: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

3000: l_current_production_ext_id NUMBER;
3001: l_ext_id_for_current_row NUMBER;
3002:
3003:
3004: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3005: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE := EGO_USER_ATTR_DATA_TABLE();
3006: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
3007:
3008: l_num_value NUMBER ;

Line 3063: -- l_current_dl_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

3059: l_orig_territory VARCHAR2(64);
3060: l_orig_chrs VARCHAR2(64);
3061:
3062: ind NUMBER;
3063: -- l_current_dl_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3064: -- l_object_id NUMBER;
3065: -- l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
3066:
3067:

Line 3794: EGO_COL_NAME_VALUE_PAIR_ARRAY(

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

Line 4506: ,p_old_data_level_nv_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

4502: ,p_change_b_table_name IN VARCHAR2
4503: ,p_change_tl_table_name IN VARCHAR2
4504: ,p_tables_application_id IN NUMBER
4505: ,p_change_line_id IN NUMBER
4506: ,p_old_data_level_nv_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
4507: ,p_new_data_level_nv_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
4508: ,p_related_class_code_function IN VARCHAR2
4509: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
4510: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 4507: ,p_new_data_level_nv_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

4503: ,p_change_tl_table_name IN VARCHAR2
4504: ,p_tables_application_id IN NUMBER
4505: ,p_change_line_id IN NUMBER
4506: ,p_old_data_level_nv_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
4507: ,p_new_data_level_nv_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
4508: ,p_related_class_code_function IN VARCHAR2
4509: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
4510: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
4511: ,x_return_status OUT NOCOPY VARCHAR2

Line 4525: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY ;

4521: --if we change optional parameters, version goes FROM x.n to x.(n+1)
4522: l_api_version CONSTANT NUMBER := 1.0;
4523:
4524: l_object_id NUMBER;
4525: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY ;
4526: l_current_dl_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
4527: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
4528: l_chng_col_names_list VARCHAR2(20000);
4529: l_cols_to_exclude_list VARCHAR2(2000);

Line 4526: l_current_dl_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

4522: l_api_version CONSTANT NUMBER := 1.0;
4523:
4524: l_object_id NUMBER;
4525: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY ;
4526: l_current_dl_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
4527: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
4528: l_chng_col_names_list VARCHAR2(20000);
4529: l_cols_to_exclude_list VARCHAR2(2000);
4530: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

Line 4530: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

4526: l_current_dl_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
4527: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
4528: l_chng_col_names_list VARCHAR2(20000);
4529: l_cols_to_exclude_list VARCHAR2(2000);
4530: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
4531: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
4532: l_b_chng_cols_list VARCHAR2(10000);
4533: l_tl_chng_cols_list VARCHAR2(10000);
4534: l_history_b_chng_cols_list VARCHAR2(10000);

Line 4531: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

4527: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
4528: l_chng_col_names_list VARCHAR2(20000);
4529: l_cols_to_exclude_list VARCHAR2(2000);
4530: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
4531: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
4532: l_b_chng_cols_list VARCHAR2(10000);
4533: l_tl_chng_cols_list VARCHAR2(10000);
4534: l_history_b_chng_cols_list VARCHAR2(10000);
4535: l_history_tl_chng_cols_list VARCHAR2(10000);

Line 4629: EGO_COL_NAME_VALUE_PAIR_ARRAY(

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

Line 4669: EGO_COL_NAME_VALUE_PAIR_ARRAY(

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

Line 4702: EGO_COL_NAME_VALUE_PAIR_ARRAY(

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

Line 4728: EGO_COL_NAME_VALUE_PAIR_ARRAY(

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

Line 4747: EGO_COL_NAME_VALUE_PAIR_ARRAY(

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

Line 4771: EGO_COL_NAME_VALUE_PAIR_ARRAY(

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

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

5846:
5847: plsql_block VARCHAR2(5000);
5848:
5849:
5850: l_old_data_level_nv_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
5851: l_new_data_level_nv_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
5852:
5853: BEGIN
5854:

Line 5851: l_new_data_level_nv_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

5847: plsql_block VARCHAR2(5000);
5848:
5849:
5850: l_old_data_level_nv_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
5851: l_new_data_level_nv_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
5852:
5853: BEGIN
5854:
5855:

Line 5959: l_old_data_level_nv_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

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

Line 5966: l_new_data_level_nv_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

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