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.INV_EBI_CHANGE_ORDER_HELPER dependencies on EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 45: l_pkdata EGO_COL_NAME_VALUE_PAIR_ARRAY;

41: l_attr_group_count NUMBER :=0;
42: l_change_order_type_id NUMBER;
43: l_application_id NUMBER;
44: l_attr_group_id_tbl FND_TABLE_OF_NUMBER;
45: l_pkdata EGO_COL_NAME_VALUE_PAIR_ARRAY;
46: l_uda_output_obj inv_ebi_eco_output_obj;
47: l_output_status inv_ebi_output_status;
48:
49: CURSOR c_attr_group_id IS

Line 71: l_pkdata := EGO_COL_NAME_VALUE_PAIR_ARRAY();

67: FETCH c_attr_group_id BULK COLLECT INTO l_attr_group_id_tbl ;
68: CLOSE c_attr_group_id;
69:
70: IF(l_attr_group_id_tbl IS NOT NULL AND l_attr_group_id_tbl.COUNT > 0) THEN
71: l_pkdata := EGO_COL_NAME_VALUE_PAIR_ARRAY();
72: l_pkdata.extend(1);
73: l_pkdata(1) := EGO_COL_NAME_VALUE_PAIR_OBJ('CHANGE_ID',p_change_id);
74:
75: SELECT change_order_type_id INTO l_change_order_type_id

Line 160: l_pkdata EGO_COL_NAME_VALUE_PAIR_ARRAY;

156: l_attr_group_count NUMBER :=0;
157:
158: l_application_id NUMBER;
159: l_attr_group_id_tbl FND_TABLE_OF_NUMBER;
160: l_pkdata EGO_COL_NAME_VALUE_PAIR_ARRAY;
161: l_uda_output_obj inv_ebi_eco_output_obj;
162: l_output_status inv_ebi_output_status;
163: l_structure_type_id NUMBER;
164: l_bill_sequence_id NUMBER;

Line 214: l_pkdata := EGO_COL_NAME_VALUE_PAIR_ARRAY();

210:
211: IF(c_attr_group_id % ROWCOUNT > 0) THEN
212:
213:
214: l_pkdata := EGO_COL_NAME_VALUE_PAIR_ARRAY();
215: l_pkdata.extend(1);
216: l_pkdata(1) := EGO_COL_NAME_VALUE_PAIR_OBJ('BILL_SEQUENCE_ID',l_bill_sequence_id);
217:
218: l_application_id:= INV_EBI_UTIL.get_application_id(

Line 313: l_pkdata EGO_COL_NAME_VALUE_PAIR_ARRAY;

309: l_uda_count NUMBER :=0;
310: l_attr_group_count NUMBER :=0;
311: l_application_id NUMBER;
312: l_attr_group_id_tbl FND_TABLE_OF_NUMBER;
313: l_pkdata EGO_COL_NAME_VALUE_PAIR_ARRAY;
314: l_uda_output_obj inv_ebi_eco_output_obj;
315: l_output_status inv_ebi_output_status;
316: l_structure_type_id NUMBER;
317: l_bill_sequence_id NUMBER;

Line 392: l_pkdata := EGO_COL_NAME_VALUE_PAIR_ARRAY();

388: FETCH c_attr_group_id BULK COLLECT INTO l_attr_group_id_tbl ;
389:
390: IF(c_attr_group_id % ROWCOUNT > 0) THEN
391:
392: l_pkdata := EGO_COL_NAME_VALUE_PAIR_ARRAY();
393: l_pkdata.extend(2);
394: l_pkdata(1) := EGO_COL_NAME_VALUE_PAIR_OBJ('BILL_SEQUENCE_ID',l_bill_sequence_id);
395: l_pkdata(2) := EGO_COL_NAME_VALUE_PAIR_OBJ('COMPONENT_SEQUENCE_ID',l_component_sequence_id);
396:

Line 1883: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

1879: ,p_api_version IN NUMBER DEFAULT 1.0
1880: ,p_uda_input_obj IN inv_ebi_uda_input_obj
1881: ,p_object_name IN VARCHAR2
1882: ,p_data_level IN VARCHAR2
1883: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1884: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1885: ,x_uda_output_obj OUT NOCOPY inv_ebi_eco_output_obj
1886: )
1887: IS

Line 1884: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

1880: ,p_uda_input_obj IN inv_ebi_uda_input_obj
1881: ,p_object_name IN VARCHAR2
1882: ,p_data_level IN VARCHAR2
1883: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1884: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1885: ,x_uda_output_obj OUT NOCOPY inv_ebi_eco_output_obj
1886: )
1887: IS
1888: l_attributes_row_table ego_user_attr_row_table;

Line 2013: l_pkdata ego_col_name_value_pair_array;

2009: ,p_component_tbl IN inv_ebi_rev_comp_tbl
2010: ,p_structure_header IN inv_ebi_structure_header_obj
2011: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
2012: )IS
2013: l_pkdata ego_col_name_value_pair_array;
2014: l_pkcode ego_col_name_value_pair_array;
2015: l_bill_sequence_id NUMBER;
2016: l_component_sequence_id NUMBER;
2017: l_assembly_item_id NUMBER;

Line 2014: l_pkcode ego_col_name_value_pair_array;

2010: ,p_structure_header IN inv_ebi_structure_header_obj
2011: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
2012: )IS
2013: l_pkdata ego_col_name_value_pair_array;
2014: l_pkcode ego_col_name_value_pair_array;
2015: l_bill_sequence_id NUMBER;
2016: l_component_sequence_id NUMBER;
2017: l_assembly_item_id NUMBER;
2018: l_organization_id NUMBER;

Line 2074: l_pkdata := ego_col_name_value_pair_array();

2070: WHERE bill_sequence_id = l_bill_sequence_id
2071: AND component_item_id = l_component_item_id
2072: AND change_notice = p_eco_name;
2073:
2074: l_pkdata := ego_col_name_value_pair_array();
2075: l_pkdata.extend(2);
2076: l_pkdata(1) := ego_col_name_value_pair_obj('COMPONENT_SEQUENCE_ID',l_component_sequence_id);
2077: l_pkdata(2) := ego_col_name_value_pair_obj('BILL_SEQUENCE_ID',l_bill_sequence_id);
2078: l_pkcode := ego_col_name_value_pair_array();

Line 2078: l_pkcode := ego_col_name_value_pair_array();

2074: l_pkdata := ego_col_name_value_pair_array();
2075: l_pkdata.extend(2);
2076: l_pkdata(1) := ego_col_name_value_pair_obj('COMPONENT_SEQUENCE_ID',l_component_sequence_id);
2077: l_pkdata(2) := ego_col_name_value_pair_obj('BILL_SEQUENCE_ID',l_bill_sequence_id);
2078: l_pkcode := ego_col_name_value_pair_array();
2079: l_pkcode.extend();
2080: l_pkcode(1) := ego_col_name_value_pair_obj('STRUCTURE_TYPE_ID',l_structure_type_id);
2081:
2082: process_uda(

Line 2107: l_pkdata := ego_col_name_value_pair_array();

2103: WHERE assembly_item_id = l_assembly_item_id
2104: AND organization_id = l_organization_id
2105: AND NVL(alternate_bom_designator, 'NONE') = DECODE(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code) ;
2106:
2107: l_pkdata := ego_col_name_value_pair_array();
2108: l_pkdata.extend();
2109: l_pkdata(1) := ego_col_name_value_pair_obj('BILL_SEQUENCE_ID',l_bill_sequence_id);
2110: l_pkcode := ego_col_name_value_pair_array();
2111: l_pkcode.extend();

Line 2110: l_pkcode := ego_col_name_value_pair_array();

2106:
2107: l_pkdata := ego_col_name_value_pair_array();
2108: l_pkdata.extend();
2109: l_pkdata(1) := ego_col_name_value_pair_obj('BILL_SEQUENCE_ID',l_bill_sequence_id);
2110: l_pkcode := ego_col_name_value_pair_array();
2111: l_pkcode.extend();
2112: l_pkcode(1) := ego_col_name_value_pair_obj('STRUCTURE_TYPE_ID',l_structure_type_id);
2113:
2114: process_uda(