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 837: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

833: l_dest_org_id number;
834: l_src_comp_seq_id NUMBER;
835: l_err_text VARCHAR2(2000);
836: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
837: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
838: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
839: l_new_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
840: l_str_type NUMBER;
841: l_errorcode NUMBER;

Line 838: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

834: l_src_comp_seq_id NUMBER;
835: l_err_text VARCHAR2(2000);
836: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
837: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
838: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
839: l_new_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
840: l_str_type NUMBER;
841: l_errorcode NUMBER;
842: l_msg_data VARCHAR2(100);

Line 839: l_new_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;

835: l_err_text VARCHAR2(2000);
836: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
837: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
838: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
839: l_new_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
840: l_str_type NUMBER;
841: l_errorcode NUMBER;
842: l_msg_data VARCHAR2(100);
843: l_msg_count NUMBER := 0;

Line 1113: /*l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

1109:
1110: --Copy user attrs only if the str type is same
1111: IF l_src_str_type = l_str_type
1112: THEN
1113: /*l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1114: EGO_COL_NAME_VALUE_PAIR_OBJ('BILL_SEQUENCE_ID',to_char(p_src_bill_sequence_id)));
1115: 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)));
1116: l_new_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('STRUCTURE_TYPE_ID',TO_CHAR(l_str_type)));
1117: EGO_USER_ATTRS_DATA_PUB.Copy_User_Attrs_Data(

Line 1115: 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)));

1111: IF l_src_str_type = l_str_type
1112: THEN
1113: /*l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1114: EGO_COL_NAME_VALUE_PAIR_OBJ('BILL_SEQUENCE_ID',to_char(p_src_bill_sequence_id)));
1115: 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)));
1116: l_new_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('STRUCTURE_TYPE_ID',TO_CHAR(l_str_type)));
1117: EGO_USER_ATTRS_DATA_PUB.Copy_User_Attrs_Data(
1118: p_api_version =>1.0
1119: ,p_application_id =>702

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

1112: THEN
1113: /*l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1114: EGO_COL_NAME_VALUE_PAIR_OBJ('BILL_SEQUENCE_ID',to_char(p_src_bill_sequence_id)));
1115: 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)));
1116: l_new_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('STRUCTURE_TYPE_ID',TO_CHAR(l_str_type)));
1117: EGO_USER_ATTRS_DATA_PUB.Copy_User_Attrs_Data(
1118: p_api_version =>1.0
1119: ,p_application_id =>702
1120: ,p_object_name =>'BOM_STRUCTURE'

Line 3616: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

3612: Procedure Replicate_Comp_User_Attrs(p_src_bill_seq_id IN NUMBER,
3613: p_dest_bill_seq_id IN NUMBER,
3614: x_Return_Status OUT NOCOPY VARCHAR2)
3615: IS
3616: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3617: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3618: l_new_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
3619: l_str_type NUMBER;
3620: l_errorcode NUMBER;

Line 3617: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

3613: p_dest_bill_seq_id IN NUMBER,
3614: x_Return_Status OUT NOCOPY VARCHAR2)
3615: IS
3616: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3617: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3618: l_new_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
3619: l_str_type NUMBER;
3620: l_errorcode NUMBER;
3621: l_msg_data VARCHAR2(100);

Line 3618: l_new_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;

3614: x_Return_Status OUT NOCOPY VARCHAR2)
3615: IS
3616: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3617: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3618: l_new_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
3619: l_str_type NUMBER;
3620: l_errorcode NUMBER;
3621: l_msg_data VARCHAR2(100);
3622: l_msg_count NUMBER := 0;

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

3654: END IF; --IF l_src_str_type <> l_str_type
3655:
3656: for comp in get_source_and_dest_components(p_bill_sequence_id => p_dest_bill_seq_id)
3657: loop
3658: 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))
3659: ,EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(p_src_bill_seq_id)) );
3660: 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)),
3661: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(p_dest_bill_seq_id)) );
3662: 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 3660: 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)),

3656: for comp in get_source_and_dest_components(p_bill_sequence_id => p_dest_bill_seq_id)
3657: loop
3658: 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))
3659: ,EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(p_src_bill_seq_id)) );
3660: 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)),
3661: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(p_dest_bill_seq_id)) );
3662: l_new_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID', TO_CHAR(l_str_type)));
3663: EGO_USER_ATTRS_DATA_PUB.Copy_User_Attrs_Data(
3664: p_api_version => 1.0

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

3658: 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))
3659: ,EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(p_src_bill_seq_id)) );
3660: 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)),
3661: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(p_dest_bill_seq_id)) );
3662: l_new_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID', TO_CHAR(l_str_type)));
3663: EGO_USER_ATTRS_DATA_PUB.Copy_User_Attrs_Data(
3664: p_api_version => 1.0
3665: ,p_application_id => 702
3666: ,p_object_name => 'BOM_COMPONENTS'

Line 3691: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

3687: Procedure Propagate_Comp_User_Attributes(p_src_comp_seq_id IN NUMBER
3688: , p_attr_grp_id IN NUMBER
3689: , x_Return_Status OUT NOCOPY VARCHAR2)
3690: IS
3691: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3692: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3693: l_new_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
3694: l_str_type NUMBER;
3695: l_errorcode NUMBER;

Line 3692: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

3688: , p_attr_grp_id IN NUMBER
3689: , x_Return_Status OUT NOCOPY VARCHAR2)
3690: IS
3691: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3692: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3693: l_new_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
3694: l_str_type NUMBER;
3695: l_errorcode NUMBER;
3696: l_msg_data VARCHAR2(100);

Line 3693: l_new_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;

3689: , x_Return_Status OUT NOCOPY VARCHAR2)
3690: IS
3691: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3692: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3693: l_new_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
3694: l_str_type NUMBER;
3695: l_errorcode NUMBER;
3696: l_msg_data VARCHAR2(100);
3697: l_msg_count NUMBER := 0;

Line 3712: --l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

3708: --l_msg_data VARCHAR2(100);
3709: l_row_table_index NUMBER := 1;
3710: l_data_table_index NUMBER := 1;
3711: l_failed_row_count NUMBER;
3712: --l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3713: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
3714: l_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
3715: l_attr_group_request_table EGO_ATTR_GROUP_REQUEST_TABLE;
3716: l_current_row_element EGO_USER_ATTR_ROW_OBJ;

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

3756: Open get_structure_type(p_bill_seq_id => l_src_bill_seq_id);
3757: Fetch get_structure_type into l_src_str_type;
3758: Close get_structure_type;
3759:
3760: 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))
3761: ,EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(l_src_bill_seq_id)) );
3762: --Table to maintain the attr grp data
3763: --l_cons_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();
3764:

Line 3815: 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)));

3811: */
3812: -- end loop; --End for attr_grp IN Get_Attribute_Groups
3813:
3814: --Classification code
3815: 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)));
3816: 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)
3817: LOOP
3818: 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)),
3819: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(dest_comps.bill_sequence_id)) );

Line 3818: 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)),

3814: --Classification code
3815: 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)));
3816: 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)
3817: LOOP
3818: 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)),
3819: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(dest_comps.bill_sequence_id)) );
3820: EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data (
3821: p_api_version => 1.0
3822: ,p_object_name => 'BOM_COMPONENTS'