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 73: l_pkdata := EGO_COL_NAME_VALUE_PAIR_ARRAY();

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

Line 163: l_pkdata EGO_COL_NAME_VALUE_PAIR_ARRAY;

159: l_attr_group_count NUMBER :=0;
160:
161: l_application_id NUMBER;
162: l_attr_group_id_tbl FND_TABLE_OF_NUMBER;
163: l_pkdata EGO_COL_NAME_VALUE_PAIR_ARRAY;
164: l_uda_output_obj inv_ebi_eco_output_obj;
165: l_output_status inv_ebi_output_status;
166: l_structure_type_id NUMBER;
167: l_bill_sequence_id NUMBER;

Line 219: l_pkdata := EGO_COL_NAME_VALUE_PAIR_ARRAY();

215:
216: IF(c_attr_group_id % ROWCOUNT > 0) THEN
217:
218:
219: l_pkdata := EGO_COL_NAME_VALUE_PAIR_ARRAY();
220: l_pkdata.extend(1);
221: l_pkdata(1) := EGO_COL_NAME_VALUE_PAIR_OBJ('BILL_SEQUENCE_ID',l_bill_sequence_id);
222:
223: l_application_id:= INV_EBI_UTIL.get_application_id(

Line 318: l_pkdata EGO_COL_NAME_VALUE_PAIR_ARRAY;

314: l_uda_count NUMBER :=0;
315: l_attr_group_count NUMBER :=0;
316: l_application_id NUMBER;
317: l_attr_group_id_tbl FND_TABLE_OF_NUMBER;
318: l_pkdata EGO_COL_NAME_VALUE_PAIR_ARRAY;
319: l_uda_output_obj inv_ebi_eco_output_obj;
320: l_output_status inv_ebi_output_status;
321: l_structure_type_id NUMBER;
322: l_bill_sequence_id NUMBER;

Line 401: l_pkdata := EGO_COL_NAME_VALUE_PAIR_ARRAY();

397: FETCH c_attr_group_id BULK COLLECT INTO l_attr_group_id_tbl ;
398:
399: IF(c_attr_group_id % ROWCOUNT > 0) THEN
400:
401: l_pkdata := EGO_COL_NAME_VALUE_PAIR_ARRAY();
402: l_pkdata.extend(2);
403: l_pkdata(1) := EGO_COL_NAME_VALUE_PAIR_OBJ('BILL_SEQUENCE_ID',l_bill_sequence_id);
404: l_pkdata(2) := EGO_COL_NAME_VALUE_PAIR_OBJ('COMPONENT_SEQUENCE_ID',l_component_sequence_id);
405:

Line 2523: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

2519: ,p_api_version IN NUMBER DEFAULT 1.0
2520: ,p_uda_input_obj IN inv_ebi_uda_input_obj
2521: ,p_object_name IN VARCHAR2
2522: ,p_data_level IN VARCHAR2
2523: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2524: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2525: ,x_uda_output_obj OUT NOCOPY inv_ebi_eco_output_obj
2526: )
2527: IS

Line 2524: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

2520: ,p_uda_input_obj IN inv_ebi_uda_input_obj
2521: ,p_object_name IN VARCHAR2
2522: ,p_data_level IN VARCHAR2
2523: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2524: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2525: ,x_uda_output_obj OUT NOCOPY inv_ebi_eco_output_obj
2526: )
2527: IS
2528: l_attributes_row_table ego_user_attr_row_table;

Line 2654: l_pkdata ego_col_name_value_pair_array;

2650: ,p_component_tbl IN inv_ebi_rev_comp_tbl
2651: ,p_structure_header IN inv_ebi_structure_header_obj
2652: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
2653: )IS
2654: l_pkdata ego_col_name_value_pair_array;
2655: l_pkcode ego_col_name_value_pair_array;
2656: l_bill_sequence_id NUMBER;
2657: l_component_sequence_id NUMBER;
2658: l_assembly_item_id NUMBER;

Line 2655: l_pkcode ego_col_name_value_pair_array;

2651: ,p_structure_header IN inv_ebi_structure_header_obj
2652: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
2653: )IS
2654: l_pkdata ego_col_name_value_pair_array;
2655: l_pkcode ego_col_name_value_pair_array;
2656: l_bill_sequence_id NUMBER;
2657: l_component_sequence_id NUMBER;
2658: l_assembly_item_id NUMBER;
2659: l_organization_id NUMBER;

Line 2717: l_pkdata := ego_col_name_value_pair_array();

2713: WHERE bill_sequence_id = l_bill_sequence_id
2714: AND component_item_id = l_component_item_id
2715: AND change_notice = p_eco_name;
2716:
2717: l_pkdata := ego_col_name_value_pair_array();
2718: l_pkdata.extend(2);
2719: l_pkdata(1) := ego_col_name_value_pair_obj('COMPONENT_SEQUENCE_ID',l_component_sequence_id);
2720: l_pkdata(2) := ego_col_name_value_pair_obj('BILL_SEQUENCE_ID',l_bill_sequence_id);
2721: l_pkcode := ego_col_name_value_pair_array();

Line 2721: l_pkcode := ego_col_name_value_pair_array();

2717: l_pkdata := ego_col_name_value_pair_array();
2718: l_pkdata.extend(2);
2719: l_pkdata(1) := ego_col_name_value_pair_obj('COMPONENT_SEQUENCE_ID',l_component_sequence_id);
2720: l_pkdata(2) := ego_col_name_value_pair_obj('BILL_SEQUENCE_ID',l_bill_sequence_id);
2721: l_pkcode := ego_col_name_value_pair_array();
2722: l_pkcode.extend();
2723: l_pkcode(1) := ego_col_name_value_pair_obj('STRUCTURE_TYPE_ID',l_structure_type_id);
2724: INV_EBI_UTIL.debug_line('STEP 50: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_uda');
2725: process_uda(

Line 2750: l_pkdata := ego_col_name_value_pair_array();

2746: WHERE assembly_item_id = l_assembly_item_id
2747: AND organization_id = l_organization_id
2748: AND NVL(alternate_bom_designator, 'NONE') = DECODE(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code) ;
2749:
2750: l_pkdata := ego_col_name_value_pair_array();
2751: l_pkdata.extend();
2752: l_pkdata(1) := ego_col_name_value_pair_obj('BILL_SEQUENCE_ID',l_bill_sequence_id);
2753: l_pkcode := ego_col_name_value_pair_array();
2754: l_pkcode.extend();

Line 2753: l_pkcode := ego_col_name_value_pair_array();

2749:
2750: l_pkdata := ego_col_name_value_pair_array();
2751: l_pkdata.extend();
2752: l_pkdata(1) := ego_col_name_value_pair_obj('BILL_SEQUENCE_ID',l_bill_sequence_id);
2753: l_pkcode := ego_col_name_value_pair_array();
2754: l_pkcode.extend();
2755: l_pkcode(1) := ego_col_name_value_pair_obj('STRUCTURE_TYPE_ID',l_structure_type_id);
2756: INV_EBI_UTIL.debug_line('STEP 70: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_uda FOR STRUCTURE HEADER');
2757: process_uda(