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

Line 2433: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

2429: Procedure copy_Comp_User_Attrs(p_src_comp_seq_id IN NUMBER,
2430: p_dest_comp_seq_id IN NUMBER,
2431: x_Return_Status OUT NOCOPY VARCHAR2)
2432: IS
2433: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2434: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2435: l_new_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
2436: l_bill_seq_id NUMBER;
2437: l_errorcode NUMBER;

Line 2434: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

2430: p_dest_comp_seq_id IN NUMBER,
2431: x_Return_Status OUT NOCOPY VARCHAR2)
2432: IS
2433: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2434: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2435: l_new_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
2436: l_bill_seq_id NUMBER;
2437: l_errorcode NUMBER;
2438: l_msg_data VARCHAR2(100);

Line 2435: l_new_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;

2431: x_Return_Status OUT NOCOPY VARCHAR2)
2432: IS
2433: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2434: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2435: l_new_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
2436: l_bill_seq_id NUMBER;
2437: l_errorcode NUMBER;
2438: l_msg_data VARCHAR2(100);
2439: l_msg_count NUMBER := 0;

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

2461: Open get_structure_type(p_bill_seq_id => l_bill_seq_id);
2462: Fetch get_structure_type INTO l_str_type;
2463: Close get_structure_type;
2464:
2465: 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))
2466: ,EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(l_bill_seq_id)) );
2467: 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)),
2468: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(l_bill_seq_id)) );
2469: 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 2467: 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)),

2463: Close get_structure_type;
2464:
2465: 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))
2466: ,EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(l_bill_seq_id)) );
2467: 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)),
2468: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(l_bill_seq_id)) );
2469: l_new_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID', TO_CHAR(l_str_type)));
2470: EGO_USER_ATTRS_DATA_PUB.Copy_User_Attrs_Data(
2471: p_api_version => 1.0

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

2465: 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))
2466: ,EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(l_bill_seq_id)) );
2467: 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)),
2468: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(l_bill_seq_id)) );
2469: l_new_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID', TO_CHAR(l_str_type)));
2470: EGO_USER_ATTRS_DATA_PUB.Copy_User_Attrs_Data(
2471: p_api_version => 1.0
2472: ,p_application_id => 702
2473: ,p_object_name => 'BOM_COMPONENTS'

Line 3076: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

3072: l_msg_count NUMBER;
3073: l_msg_data VARCHAR2(2000);
3074: l_failed_row_id_list VARCHAR2(2000);
3075:
3076: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3077: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3078: l_data_level_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
3079:
3080: l_object_name VARCHAR2(50);

Line 3077: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

3073: l_msg_data VARCHAR2(2000);
3074: l_failed_row_id_list VARCHAR2(2000);
3075:
3076: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3077: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3078: l_data_level_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
3079:
3080: l_object_name VARCHAR2(50);
3081: l_application_id NUMBER;

Line 3078: l_data_level_values EGO_COL_NAME_VALUE_PAIR_ARRAY;

3074: l_failed_row_id_list VARCHAR2(2000);
3075:
3076: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3077: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3078: l_data_level_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
3079:
3080: l_object_name VARCHAR2(50);
3081: l_application_id NUMBER;
3082: l_additional_class_Code_list VARCHAR2(32000);

Line 3103: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY

3099: IF p_object_name = 'BOM_STRUCTURE' THEN
3100: l_object_name := 'BOM_STRUCTURE';
3101: l_attribute_group_type := 'BOM_STRUCTUREMGMT_GROUP';
3102:
3103: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
3104: ( EGO_COL_NAME_VALUE_PAIR_OBJ('BILL_SEQUENCE_ID', p_bill_sequence_id));
3105:
3106: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
3107: (EGO_COL_NAME_VALUE_PAIR_OBJ('STRUCTURE_TYPE_ID', p_structure_type_id));

Line 3106: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY

3102:
3103: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
3104: ( EGO_COL_NAME_VALUE_PAIR_OBJ('BILL_SEQUENCE_ID', p_bill_sequence_id));
3105:
3106: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
3107: (EGO_COL_NAME_VALUE_PAIR_OBJ('STRUCTURE_TYPE_ID', p_structure_type_id));
3108:
3109: ELSIF p_object_name = 'BOM_COMPONENTS' THEN
3110: l_object_name := 'BOM_COMPONENTS';

Line 3112: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY

3108:
3109: ELSIF p_object_name = 'BOM_COMPONENTS' THEN
3110: l_object_name := 'BOM_COMPONENTS';
3111: l_attribute_group_type := 'BOM_COMPONENTMGMT_GROUP';
3112: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
3113: ( EGO_COL_NAME_VALUE_PAIR_OBJ('COMPONENT_SEQUENCE_ID', p_component_sequence_id)
3114: , EGO_COL_NAME_VALUE_PAIR_OBJ('BILL_SEQUENCE_ID', p_bill_sequence_id));
3115:
3116: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 3116: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY

3112: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
3113: ( EGO_COL_NAME_VALUE_PAIR_OBJ('COMPONENT_SEQUENCE_ID', p_component_sequence_id)
3114: , EGO_COL_NAME_VALUE_PAIR_OBJ('BILL_SEQUENCE_ID', p_bill_sequence_id));
3115:
3116: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
3117: (EGO_COL_NAME_VALUE_PAIR_OBJ('STRUCTURE_TYPE_ID', p_structure_type_id));
3118:
3119: END IF;
3120: