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

Line 156: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

152: l_bill_seq_id Number;
153: l_new_component_seq_id Number;
154: l_structure_type_id Number;
155:
156: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
157: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
158: l_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
159: l_data_level_pks EGO_COL_NAME_VALUE_PAIR_ARRAY;
160: l_data_level_id Number;

Line 157: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

153: l_new_component_seq_id Number;
154: l_structure_type_id Number;
155:
156: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
157: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
158: l_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
159: l_data_level_pks EGO_COL_NAME_VALUE_PAIR_ARRAY;
160: l_data_level_id Number;
161:

Line 158: l_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;

154: l_structure_type_id Number;
155:
156: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
157: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
158: l_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
159: l_data_level_pks EGO_COL_NAME_VALUE_PAIR_ARRAY;
160: l_data_level_id Number;
161:
162: l_errorcode Number;

Line 159: l_data_level_pks EGO_COL_NAME_VALUE_PAIR_ARRAY;

155:
156: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
157: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
158: l_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
159: l_data_level_pks EGO_COL_NAME_VALUE_PAIR_ARRAY;
160: l_data_level_id Number;
161:
162: l_errorcode Number;
163: l_msg_count Number;

Line 303: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' ,

299: from BOM_COMPONENTS_B BCB
300: where BCB.COMPONENT_SEQUENCE_ID = component.component_sequence_id
301: and BCB.BILL_SEQUENCE_ID = l_bill_seq_id;
302:
303: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' ,
304: to_char(component.component_sequence_id)),
305: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' ,
306: to_char(l_bill_seq_id)));
307: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' ,

Line 307: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' ,

303: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' ,
304: to_char(component.component_sequence_id)),
305: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' ,
306: to_char(l_bill_seq_id)));
307: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' ,
308: to_char(l_new_component_seq_id)),
309: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' ,
310: to_char(l_bill_seq_id)));
311: l_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID',

Line 311: l_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID',

307: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' ,
308: to_char(l_new_component_seq_id)),
309: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' ,
310: to_char(l_bill_seq_id)));
311: l_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID',
312: TO_CHAR(l_structure_type_id)));
313:
314: l_data_level_pks := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID' , null));
315:

Line 314: l_data_level_pks := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID' , null));

310: to_char(l_bill_seq_id)));
311: l_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID',
312: TO_CHAR(l_structure_type_id)));
313:
314: l_data_level_pks := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID' , null));
315:
316:
317: EGO_USER_ATTRS_DATA_PVT.Copy_User_Attrs_Data
318: (

Line 466: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

462: l_par_alternate_bom_designator VARCHAR2(10);
463: l_par_structure_type_id NUMBER;
464: l_parent_ver_seq_id Number;
465:
466: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
467: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
468: l_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
469: l_data_level_pks EGO_COL_NAME_VALUE_PAIR_ARRAY;
470: l_data_level_id Number;

Line 467: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

463: l_par_structure_type_id NUMBER;
464: l_parent_ver_seq_id Number;
465:
466: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
467: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
468: l_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
469: l_data_level_pks EGO_COL_NAME_VALUE_PAIR_ARRAY;
470: l_data_level_id Number;
471:

Line 468: l_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;

464: l_parent_ver_seq_id Number;
465:
466: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
467: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
468: l_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
469: l_data_level_pks EGO_COL_NAME_VALUE_PAIR_ARRAY;
470: l_data_level_id Number;
471:
472: l_errorcode Number;

Line 469: l_data_level_pks EGO_COL_NAME_VALUE_PAIR_ARRAY;

465:
466: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
467: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
468: l_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
469: l_data_level_pks EGO_COL_NAME_VALUE_PAIR_ARRAY;
470: l_data_level_id Number;
471:
472: l_errorcode Number;
473: l_msg_count Number;

Line 735: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' ,

731: /* from mtl_system_items msi
732: where inventory_item_id = v_struct_comp(cntr).component_item_id
733: and organization_id = v_struct_comp(cntr).pk2_value; */
734:
735: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' ,
736: to_char(v_struct_comp(cntr).component_sequence_id)),
737: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' ,
738: to_char(nvl(v_struct_comp(cntr).parent_bill_seq_id,l_bill_seq_id))));
739: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' ,

Line 739: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' ,

735: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' ,
736: to_char(v_struct_comp(cntr).component_sequence_id)),
737: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' ,
738: to_char(nvl(v_struct_comp(cntr).parent_bill_seq_id,l_bill_seq_id))));
739: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' ,
740: to_char(l_new_component_seq_id)),
741: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' ,
742: to_char(l_bill_seq_id)));
743: l_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID',

Line 743: l_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID',

739: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' ,
740: to_char(l_new_component_seq_id)),
741: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' ,
742: to_char(l_bill_seq_id)));
743: l_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID',
744: TO_CHAR(l_structure_type_id)));
745: l_data_level_pks := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID' , null));
746:
747: EGO_USER_ATTRS_DATA_PVT.Copy_User_Attrs_Data

Line 745: l_data_level_pks := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID' , null));

741: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' ,
742: to_char(l_bill_seq_id)));
743: l_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID',
744: TO_CHAR(l_structure_type_id)));
745: l_data_level_pks := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID' , null));
746:
747: EGO_USER_ATTRS_DATA_PVT.Copy_User_Attrs_Data
748: (
749: p_api_version => 1.0

Line 1735: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1731: /* This PL/SQL table is used for final DML Operations. */
1732: type component_rec is table of component_record index by binary_integer;
1733: v_insert_comp_tbl component_rec;
1734:
1735: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1736: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1737: l_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
1738: l_data_level_pks EGO_COL_NAME_VALUE_PAIR_ARRAY;
1739: l_data_level_id Number;

Line 1736: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1732: type component_rec is table of component_record index by binary_integer;
1733: v_insert_comp_tbl component_rec;
1734:
1735: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1736: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1737: l_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
1738: l_data_level_pks EGO_COL_NAME_VALUE_PAIR_ARRAY;
1739: l_data_level_id Number;
1740:

Line 1737: l_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;

1733: v_insert_comp_tbl component_rec;
1734:
1735: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1736: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1737: l_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
1738: l_data_level_pks EGO_COL_NAME_VALUE_PAIR_ARRAY;
1739: l_data_level_id Number;
1740:
1741: l_assy_bom_item_type MTL_SYSTEM_ITEMS_VL.bom_item_type%type;

Line 1738: l_data_level_pks EGO_COL_NAME_VALUE_PAIR_ARRAY;

1734:
1735: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1736: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1737: l_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
1738: l_data_level_pks EGO_COL_NAME_VALUE_PAIR_ARRAY;
1739: l_data_level_id Number;
1740:
1741: l_assy_bom_item_type MTL_SYSTEM_ITEMS_VL.bom_item_type%type;
1742: l_assy_eam_item_type MTL_SYSTEM_ITEMS_VL.eam_item_type%type;

Line 2158: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' ,

2154: /* UT Fix : Commented as component_seq_id is primary key in bom_components_b */
2155: -- and BCB.BILL_SEQUENCE_ID = l_catalog_bill_sequence_id;
2156:
2157: l_stmt_no := 350;
2158: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' ,
2159: to_char(v_insert_comp_tbl(cntr).component_sequence_id)),
2160: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' ,
2161: to_char(v_insert_comp_tbl(cntr).bill_sequence_id)));
2162: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' ,

Line 2162: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' ,

2158: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' ,
2159: to_char(v_insert_comp_tbl(cntr).component_sequence_id)),
2160: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' ,
2161: to_char(v_insert_comp_tbl(cntr).bill_sequence_id)));
2162: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' ,
2163: to_char(l_new_component_seq_id)),
2164: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' ,
2165: to_char(p_bill_seq_id)));
2166: l_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID',

Line 2166: l_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID',

2162: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' ,
2163: to_char(l_new_component_seq_id)),
2164: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' ,
2165: to_char(p_bill_seq_id)));
2166: l_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID',
2167: TO_CHAR(p_structure_type_id)));
2168:
2169:
2170: l_data_level_pks := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID' , null));

Line 2170: l_data_level_pks := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID' , null));

2166: l_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID',
2167: TO_CHAR(p_structure_type_id)));
2168:
2169:
2170: l_data_level_pks := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID' , null));
2171: l_stmt_no := 360;
2172: EGO_USER_ATTRS_DATA_PVT.Copy_User_Attrs_Data
2173: (
2174: p_api_version => 1.0

Line 2349: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

2345:
2346: type item_component_rec is table of item_component_record index by binary_integer;
2347: v_item_comp_tbl item_component_rec;
2348:
2349: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2350: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2351: l_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
2352: l_data_level_pks EGO_COL_NAME_VALUE_PAIR_ARRAY;
2353: l_data_level_id Number;

Line 2350: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

2346: type item_component_rec is table of item_component_record index by binary_integer;
2347: v_item_comp_tbl item_component_rec;
2348:
2349: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2350: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2351: l_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
2352: l_data_level_pks EGO_COL_NAME_VALUE_PAIR_ARRAY;
2353: l_data_level_id Number;
2354: l_Return_Status Varchar2(1) := 'S';

Line 2351: l_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;

2347: v_item_comp_tbl item_component_rec;
2348:
2349: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2350: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2351: l_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
2352: l_data_level_pks EGO_COL_NAME_VALUE_PAIR_ARRAY;
2353: l_data_level_id Number;
2354: l_Return_Status Varchar2(1) := 'S';
2355:

Line 2352: l_data_level_pks EGO_COL_NAME_VALUE_PAIR_ARRAY;

2348:
2349: l_dest_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2350: l_src_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2351: l_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
2352: l_data_level_pks EGO_COL_NAME_VALUE_PAIR_ARRAY;
2353: l_data_level_id Number;
2354: l_Return_Status Varchar2(1) := 'S';
2355:
2356: l_item_seq_incr_prof VARCHAR2(10) := nvl(fnd_profile.value('BOM:ITEM_SEQUENCE_INCREMENT'),10);

Line 2858: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' ,

2854: BCB.COMPONENT_SEQUENCE_ID = v_insert_comp_tbl(cntr).component_sequence_id;
2855: /* UT Fix : Commented as Comp_seq_id is alone enough to find a record in bom_components_b */
2856: -- and BCB.BILL_SEQUENCE_ID = l_catalog_bill_sequence_id) );
2857: l_stmt_no := 430;
2858: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' ,
2859: to_char(v_insert_comp_tbl(cntr).component_sequence_id)),
2860: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' ,
2861: to_char(v_insert_comp_tbl(cntr).bill_seq_id)));
2862: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' ,

Line 2862: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' ,

2858: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' ,
2859: to_char(v_insert_comp_tbl(cntr).component_sequence_id)),
2860: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' ,
2861: to_char(v_insert_comp_tbl(cntr).bill_seq_id)));
2862: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' ,
2863: l_new_component_seq_id),
2864: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' ,
2865: to_char(l_item_bill_sequence_id)));
2866: l_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID',

Line 2866: l_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID',

2862: l_dest_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' ,
2863: l_new_component_seq_id),
2864: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' ,
2865: to_char(l_item_bill_sequence_id)));
2866: l_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID',
2867: TO_CHAR(l_catalog_str_type_id)));
2868: l_data_level_pks := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID' , null));
2869: l_stmt_no := 440;
2870: EGO_USER_ATTRS_DATA_PVT.Copy_User_Attrs_Data

Line 2868: l_data_level_pks := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID' , null));

2864: EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' ,
2865: to_char(l_item_bill_sequence_id)));
2866: l_str_type := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'STRUCTURE_TYPE_ID',
2867: TO_CHAR(l_catalog_str_type_id)));
2868: l_data_level_pks := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID' , null));
2869: l_stmt_no := 440;
2870: EGO_USER_ATTRS_DATA_PVT.Copy_User_Attrs_Data
2871: (
2872: p_api_version => 1.0