DBA Data[Home] [Help]

APPS.INV_EBI_CHANGE_ORDER_HELPER dependencies on EGO_COL_NAME_VALUE_PAIR_OBJ

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

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

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

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

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

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

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:
397: l_application_id:= INV_EBI_UTIL.get_application_id(
398: p_application_short_name => 'BOM'
399: );

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

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

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();
2079: l_pkcode.extend();
2080: l_pkcode(1) := ego_col_name_value_pair_obj('STRUCTURE_TYPE_ID',l_structure_type_id);
2081:

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

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

Line 2109: l_pkdata(1) := ego_col_name_value_pair_obj('BILL_SEQUENCE_ID',l_bill_sequence_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();
2112: l_pkcode(1) := ego_col_name_value_pair_obj('STRUCTURE_TYPE_ID',l_structure_type_id);
2113:

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

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