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

Line 1041: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1037: l_dest_org_id number;
1038: l_src_comp_seq_id NUMBER;
1039: l_err_text VARCHAR2(2000);
1040: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1041: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1042: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1043: l_new_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
1044: l_str_type NUMBER;
1045: l_errorcode NUMBER;

Line 1042: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1038: l_src_comp_seq_id NUMBER;
1039: l_err_text VARCHAR2(2000);
1040: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1041: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1042: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1043: l_new_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
1044: l_str_type NUMBER;
1045: l_errorcode NUMBER;
1046: l_msg_data VARCHAR2(100);

Line 1043: l_new_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;

1039: l_err_text VARCHAR2(2000);
1040: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1041: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1042: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1043: l_new_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
1044: l_str_type NUMBER;
1045: l_errorcode NUMBER;
1046: l_msg_data VARCHAR2(100);
1047: l_msg_count NUMBER := 0;

Line 1318: /*l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

1314:
1315: --Copy user attrs only if the str type is same
1316: IF l_src_str_type = l_str_type
1317: THEN
1318: /*l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1319: EGO_COL_NAME_VALUE_PAIR_OBJ('BILL_SEQUENCE_ID',to_char(p_src_bill_sequence_id)));
1320: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('BILL_SEQUENCE_ID',to_char(p_dest_bill_sequence_id)));
1321: l_new_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('STRUCTURE_TYPE_ID',TO_CHAR(l_str_type)));
1322: EGO_USER_ATTRS_DATA_PUB.Copy_User_Attrs_Data(

Line 1320: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('BILL_SEQUENCE_ID',to_char(p_dest_bill_sequence_id)));

1316: IF l_src_str_type = l_str_type
1317: THEN
1318: /*l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1319: EGO_COL_NAME_VALUE_PAIR_OBJ('BILL_SEQUENCE_ID',to_char(p_src_bill_sequence_id)));
1320: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('BILL_SEQUENCE_ID',to_char(p_dest_bill_sequence_id)));
1321: l_new_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('STRUCTURE_TYPE_ID',TO_CHAR(l_str_type)));
1322: EGO_USER_ATTRS_DATA_PUB.Copy_User_Attrs_Data(
1323: p_api_version =>1.0
1324: ,p_application_id =>702

Line 1321: l_new_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('STRUCTURE_TYPE_ID',TO_CHAR(l_str_type)));

1317: THEN
1318: /*l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1319: EGO_COL_NAME_VALUE_PAIR_OBJ('BILL_SEQUENCE_ID',to_char(p_src_bill_sequence_id)));
1320: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('BILL_SEQUENCE_ID',to_char(p_dest_bill_sequence_id)));
1321: l_new_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('STRUCTURE_TYPE_ID',TO_CHAR(l_str_type)));
1322: EGO_USER_ATTRS_DATA_PUB.Copy_User_Attrs_Data(
1323: p_api_version =>1.0
1324: ,p_application_id =>702
1325: ,p_object_name =>'BOM_STRUCTURE'

Line 3911: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

3907: Procedure Replicate_Comp_User_Attrs(p_src_bill_seq_id IN NUMBER,
3908: p_dest_bill_seq_id IN NUMBER,
3909: x_Return_Status OUT NOCOPY VARCHAR2)
3910: IS
3911: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3912: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3913: l_new_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
3914: l_str_type NUMBER;
3915: l_errorcode NUMBER;

Line 3912: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

3908: p_dest_bill_seq_id IN NUMBER,
3909: x_Return_Status OUT NOCOPY VARCHAR2)
3910: IS
3911: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3912: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3913: l_new_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
3914: l_str_type NUMBER;
3915: l_errorcode NUMBER;
3916: l_msg_data VARCHAR2(100);

Line 3913: l_new_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;

3909: x_Return_Status OUT NOCOPY VARCHAR2)
3910: IS
3911: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3912: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3913: l_new_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
3914: l_str_type NUMBER;
3915: l_errorcode NUMBER;
3916: l_msg_data VARCHAR2(100);
3917: l_msg_count NUMBER := 0;

Line 3922: l_old_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

3918: --l_return_status VARCHAR2(1);
3919: l_src_str_type NUMBER;
3920: l_data_level_name_comp VARCHAR2(30) := 'COMPONENTS_LEVEL';
3921: l_data_level_id_comp NUMBER;
3922: l_old_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3923: l_new_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3924:
3925: Cursor get_source_and_dest_components(p_bill_sequence_id Number)
3926: IS

Line 3923: l_new_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

3919: l_src_str_type NUMBER;
3920: l_data_level_name_comp VARCHAR2(30) := 'COMPONENTS_LEVEL';
3921: l_data_level_id_comp NUMBER;
3922: l_old_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3923: l_new_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3924:
3925: Cursor get_source_and_dest_components(p_bill_sequence_id Number)
3926: IS
3927: SELECT

Line 3966: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' , to_char(comp.common_component_sequence_id))

3962: END IF; --IF l_src_str_type <> l_str_type
3963:
3964: for comp in get_source_and_dest_components(p_bill_sequence_id => p_dest_bill_seq_id)
3965: loop
3966: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' , to_char(comp.common_component_sequence_id))
3967: ,EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(p_src_bill_seq_id)) );
3968: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' , to_char(comp.component_sequence_id)),
3969: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(p_dest_bill_seq_id)) );
3970: l_new_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID', TO_CHAR(l_str_type)));

Line 3968: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' , to_char(comp.component_sequence_id)),

3964: for comp in get_source_and_dest_components(p_bill_sequence_id => p_dest_bill_seq_id)
3965: loop
3966: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' , to_char(comp.common_component_sequence_id))
3967: ,EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(p_src_bill_seq_id)) );
3968: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' , to_char(comp.component_sequence_id)),
3969: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(p_dest_bill_seq_id)) );
3970: l_new_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID', TO_CHAR(l_str_type)));
3971: l_old_dtlevel_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID', ''));
3972: l_new_dtlevel_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID', ''));

Line 3970: l_new_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID', TO_CHAR(l_str_type)));

3966: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' , to_char(comp.common_component_sequence_id))
3967: ,EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(p_src_bill_seq_id)) );
3968: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' , to_char(comp.component_sequence_id)),
3969: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(p_dest_bill_seq_id)) );
3970: l_new_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID', TO_CHAR(l_str_type)));
3971: l_old_dtlevel_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID', ''));
3972: l_new_dtlevel_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID', ''));
3973: EGO_USER_ATTRS_DATA_PVT.Copy_User_Attrs_Data(
3974: p_api_version => 1.0

Line 3971: l_old_dtlevel_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID', ''));

3967: ,EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(p_src_bill_seq_id)) );
3968: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' , to_char(comp.component_sequence_id)),
3969: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(p_dest_bill_seq_id)) );
3970: l_new_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID', TO_CHAR(l_str_type)));
3971: l_old_dtlevel_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID', ''));
3972: l_new_dtlevel_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID', ''));
3973: EGO_USER_ATTRS_DATA_PVT.Copy_User_Attrs_Data(
3974: p_api_version => 1.0
3975: ,p_application_id => 702

Line 3972: l_new_dtlevel_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID', ''));

3968: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' , to_char(comp.component_sequence_id)),
3969: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(p_dest_bill_seq_id)) );
3970: l_new_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID', TO_CHAR(l_str_type)));
3971: l_old_dtlevel_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID', ''));
3972: l_new_dtlevel_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID', ''));
3973: EGO_USER_ATTRS_DATA_PVT.Copy_User_Attrs_Data(
3974: p_api_version => 1.0
3975: ,p_application_id => 702
3976: ,p_object_name => 'BOM_COMPONENTS'

Line 4005: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

4001: Procedure Propagate_Comp_User_Attributes(p_src_comp_seq_id IN NUMBER
4002: , p_attr_grp_id IN NUMBER
4003: , x_Return_Status OUT NOCOPY VARCHAR2)
4004: IS
4005: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
4006: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
4007: l_new_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
4008: l_str_type NUMBER;
4009: l_errorcode NUMBER;

Line 4006: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

4002: , p_attr_grp_id IN NUMBER
4003: , x_Return_Status OUT NOCOPY VARCHAR2)
4004: IS
4005: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
4006: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
4007: l_new_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
4008: l_str_type NUMBER;
4009: l_errorcode NUMBER;
4010: l_msg_data VARCHAR2(100);

Line 4007: l_new_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;

4003: , x_Return_Status OUT NOCOPY VARCHAR2)
4004: IS
4005: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
4006: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
4007: l_new_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
4008: l_str_type NUMBER;
4009: l_errorcode NUMBER;
4010: l_msg_data VARCHAR2(100);
4011: l_msg_count NUMBER := 0;

Line 4026: --l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

4022: --l_msg_data VARCHAR2(100);
4023: l_row_table_index NUMBER := 1;
4024: l_data_table_index NUMBER := 1;
4025: l_failed_row_count NUMBER;
4026: --l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
4027: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
4028: l_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
4029: l_attr_group_request_table EGO_ATTR_GROUP_REQUEST_TABLE;
4030: l_current_row_element EGO_USER_ATTR_ROW_OBJ;

Line 4074: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' , to_char(p_src_comp_seq_id))

4070: Open get_structure_type(p_bill_seq_id => l_src_bill_seq_id);
4071: Fetch get_structure_type into l_src_str_type;
4072: Close get_structure_type;
4073:
4074: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' , to_char(p_src_comp_seq_id))
4075: ,EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(l_src_bill_seq_id)) );
4076: --Table to maintain the attr grp data
4077: --l_cons_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();
4078:

Line 4136: l_new_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID', TO_CHAR(l_src_str_type)));

4132: */
4133: -- end loop; --End for attr_grp IN Get_Attribute_Groups
4134:
4135: --Classification code
4136: l_new_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID', TO_CHAR(l_src_str_type)));
4137: FOR dest_comps in get_dest_comps(p_src_comp_seq_id => p_src_comp_seq_id, p_str_type_id => l_src_str_type)
4138: LOOP
4139: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' , to_char(dest_comps.component_sequence_id)),
4140: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(dest_comps.bill_sequence_id)) );

Line 4139: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' , to_char(dest_comps.component_sequence_id)),

4135: --Classification code
4136: l_new_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID', TO_CHAR(l_src_str_type)));
4137: FOR dest_comps in get_dest_comps(p_src_comp_seq_id => p_src_comp_seq_id, p_str_type_id => l_src_str_type)
4138: LOOP
4139: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' , to_char(dest_comps.component_sequence_id)),
4140: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(dest_comps.bill_sequence_id)) );
4141: EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data (
4142: p_api_version => 1.0
4143: ,p_object_name => 'BOM_COMPONENTS'