DBA Data[Home] [Help]

APPS.BOM_GLOBALS dependencies on EGO_COL_NAME_VALUE_PAIR_OBJ

Line 2480: 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))

2476: FOR c_comp_level IN C_DATA_LEVEL(l_data_level_name_comp) LOOP
2477: l_data_level_id_comp := c_comp_level.DATA_LEVEL_ID;
2478: END LOOP;
2479:
2480: 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))
2481: ,EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(l_bill_seq_id)) );
2482: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' , to_char(p_dest_comp_seq_id)),
2483: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(l_bill_seq_id)) );
2484: 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 2481: ,EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(l_bill_seq_id)) );

2477: l_data_level_id_comp := c_comp_level.DATA_LEVEL_ID;
2478: END LOOP;
2479:
2480: 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))
2481: ,EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(l_bill_seq_id)) );
2482: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' , to_char(p_dest_comp_seq_id)),
2483: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(l_bill_seq_id)) );
2484: l_new_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID', TO_CHAR(l_str_type)));
2485: l_old_dtlevel_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID', ''));

Line 2482: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' , to_char(p_dest_comp_seq_id)),

2478: END LOOP;
2479:
2480: 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))
2481: ,EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(l_bill_seq_id)) );
2482: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' , to_char(p_dest_comp_seq_id)),
2483: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(l_bill_seq_id)) );
2484: l_new_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID', TO_CHAR(l_str_type)));
2485: l_old_dtlevel_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID', ''));
2486: l_new_dtlevel_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID', ''));

Line 2483: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(l_bill_seq_id)) );

2479:
2480: 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))
2481: ,EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(l_bill_seq_id)) );
2482: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' , to_char(p_dest_comp_seq_id)),
2483: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(l_bill_seq_id)) );
2484: l_new_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID', TO_CHAR(l_str_type)));
2485: l_old_dtlevel_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID', ''));
2486: l_new_dtlevel_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID', ''));
2487: /*

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

2480: 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))
2481: ,EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(l_bill_seq_id)) );
2482: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' , to_char(p_dest_comp_seq_id)),
2483: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(l_bill_seq_id)) );
2484: l_new_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID', TO_CHAR(l_str_type)));
2485: l_old_dtlevel_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID', ''));
2486: l_new_dtlevel_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID', ''));
2487: /*
2488: EGO_USER_ATTRS_DATA_PUB.Copy_User_Attrs_Data(

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

2481: ,EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(l_bill_seq_id)) );
2482: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' , to_char(p_dest_comp_seq_id)),
2483: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(l_bill_seq_id)) );
2484: l_new_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID', TO_CHAR(l_str_type)));
2485: l_old_dtlevel_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID', ''));
2486: l_new_dtlevel_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID', ''));
2487: /*
2488: EGO_USER_ATTRS_DATA_PUB.Copy_User_Attrs_Data(
2489: p_api_version => 1.0

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

2482: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' , to_char(p_dest_comp_seq_id)),
2483: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(l_bill_seq_id)) );
2484: l_new_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID', TO_CHAR(l_str_type)));
2485: l_old_dtlevel_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID', ''));
2486: l_new_dtlevel_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID', ''));
2487: /*
2488: EGO_USER_ATTRS_DATA_PUB.Copy_User_Attrs_Data(
2489: p_api_version => 1.0
2490: ,p_application_id => 702

Line 3151: ( EGO_COL_NAME_VALUE_PAIR_OBJ('BILL_SEQUENCE_ID', p_bill_sequence_id));

3147: l_object_name := 'BOM_STRUCTURE';
3148: l_attribute_group_type := 'BOM_STRUCTUREMGMT_GROUP';
3149:
3150: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
3151: ( EGO_COL_NAME_VALUE_PAIR_OBJ('BILL_SEQUENCE_ID', p_bill_sequence_id));
3152:
3153: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
3154: (EGO_COL_NAME_VALUE_PAIR_OBJ('STRUCTURE_TYPE_ID', p_structure_type_id));
3155:

Line 3154: (EGO_COL_NAME_VALUE_PAIR_OBJ('STRUCTURE_TYPE_ID', p_structure_type_id));

3150: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
3151: ( EGO_COL_NAME_VALUE_PAIR_OBJ('BILL_SEQUENCE_ID', p_bill_sequence_id));
3152:
3153: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
3154: (EGO_COL_NAME_VALUE_PAIR_OBJ('STRUCTURE_TYPE_ID', p_structure_type_id));
3155:
3156: ELSIF p_object_name = 'BOM_COMPONENTS' THEN
3157: l_object_name := 'BOM_COMPONENTS';
3158: l_attribute_group_type := 'BOM_COMPONENTMGMT_GROUP';

Line 3160: ( EGO_COL_NAME_VALUE_PAIR_OBJ('COMPONENT_SEQUENCE_ID', p_component_sequence_id)

3156: ELSIF p_object_name = 'BOM_COMPONENTS' THEN
3157: l_object_name := 'BOM_COMPONENTS';
3158: l_attribute_group_type := 'BOM_COMPONENTMGMT_GROUP';
3159: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
3160: ( EGO_COL_NAME_VALUE_PAIR_OBJ('COMPONENT_SEQUENCE_ID', p_component_sequence_id)
3161: , EGO_COL_NAME_VALUE_PAIR_OBJ('BILL_SEQUENCE_ID', p_bill_sequence_id));
3162:
3163: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
3164: (EGO_COL_NAME_VALUE_PAIR_OBJ('STRUCTURE_TYPE_ID', p_structure_type_id));

Line 3161: , EGO_COL_NAME_VALUE_PAIR_OBJ('BILL_SEQUENCE_ID', p_bill_sequence_id));

3157: l_object_name := 'BOM_COMPONENTS';
3158: l_attribute_group_type := 'BOM_COMPONENTMGMT_GROUP';
3159: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
3160: ( EGO_COL_NAME_VALUE_PAIR_OBJ('COMPONENT_SEQUENCE_ID', p_component_sequence_id)
3161: , EGO_COL_NAME_VALUE_PAIR_OBJ('BILL_SEQUENCE_ID', p_bill_sequence_id));
3162:
3163: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
3164: (EGO_COL_NAME_VALUE_PAIR_OBJ('STRUCTURE_TYPE_ID', p_structure_type_id));
3165:

Line 3164: (EGO_COL_NAME_VALUE_PAIR_OBJ('STRUCTURE_TYPE_ID', p_structure_type_id));

3160: ( EGO_COL_NAME_VALUE_PAIR_OBJ('COMPONENT_SEQUENCE_ID', p_component_sequence_id)
3161: , EGO_COL_NAME_VALUE_PAIR_OBJ('BILL_SEQUENCE_ID', p_bill_sequence_id));
3162:
3163: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
3164: (EGO_COL_NAME_VALUE_PAIR_OBJ('STRUCTURE_TYPE_ID', p_structure_type_id));
3165:
3166: --EMTAPIA: Start support for data levels in component udas
3167: l_data_level := 'COMPONENTS_LEVEL';
3168: --EMTAPIA: End support for data levels in component udas