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_OBJ

Line 75: l_pkdata(1) := EGO_COL_NAME_VALUE_PAIR_OBJ('CHANGE_ID',p_change_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
78: FROM eng_engineering_changes
79: WHERE change_id = p_change_id;

Line 221: l_pkdata(1) := EGO_COL_NAME_VALUE_PAIR_OBJ('BILL_SEQUENCE_ID',l_bill_sequence_id);

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(
224: p_application_short_name => 'BOM'
225: );

Line 403: l_pkdata(1) := EGO_COL_NAME_VALUE_PAIR_OBJ('BILL_SEQUENCE_ID',l_bill_sequence_id);

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:
406: l_application_id:= INV_EBI_UTIL.get_application_id(
407: p_application_short_name => 'BOM'

Line 404: l_pkdata(2) := EGO_COL_NAME_VALUE_PAIR_OBJ('COMPONENT_SEQUENCE_ID',l_component_sequence_id);

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:
406: l_application_id:= INV_EBI_UTIL.get_application_id(
407: p_application_short_name => 'BOM'
408: );

Line 2719: l_pkdata(1) := ego_col_name_value_pair_obj('COMPONENT_SEQUENCE_ID',l_component_sequence_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();
2722: l_pkcode.extend();
2723: l_pkcode(1) := ego_col_name_value_pair_obj('STRUCTURE_TYPE_ID',l_structure_type_id);

Line 2720: l_pkdata(2) := ego_col_name_value_pair_obj('BILL_SEQUENCE_ID',l_bill_sequence_id);

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();
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');

Line 2723: l_pkcode(1) := ego_col_name_value_pair_obj('STRUCTURE_TYPE_ID',l_structure_type_id);

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(
2726: p_commit => p_commit
2727: ,p_uda_input_obj => p_component_tbl(i).component_revision_uda

Line 2752: l_pkdata(1) := ego_col_name_value_pair_obj('BILL_SEQUENCE_ID',l_bill_sequence_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();
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');

Line 2755: l_pkcode(1) := ego_col_name_value_pair_obj('STRUCTURE_TYPE_ID',l_structure_type_id);

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(
2758: p_uda_input_obj => p_structure_header.structure_header_uda
2759: ,p_commit => p_commit