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_COPY_BILL dependencies on EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 635: l_dest_pk_col_name_val_pairs ego_col_name_value_pair_array;

631: l_msg_count NUMBER := 0;
632: l_item_rec_in inv_item_grp.item_rec_type;
633: l_item_rec_out inv_item_grp.item_rec_type;
634: l_error_tbl inv_item_grp.error_tbl_type;
635: l_dest_pk_col_name_val_pairs ego_col_name_value_pair_array;
636: l_src_pk_col_name_val_pairs ego_col_name_value_pair_array;
637: l_new_str_type ego_col_name_value_pair_array;
638: l_str_type NUMBER;
639: l_errorcode NUMBER;

Line 636: l_src_pk_col_name_val_pairs ego_col_name_value_pair_array;

632: l_item_rec_in inv_item_grp.item_rec_type;
633: l_item_rec_out inv_item_grp.item_rec_type;
634: l_error_tbl inv_item_grp.error_tbl_type;
635: l_dest_pk_col_name_val_pairs ego_col_name_value_pair_array;
636: l_src_pk_col_name_val_pairs ego_col_name_value_pair_array;
637: l_new_str_type ego_col_name_value_pair_array;
638: l_str_type NUMBER;
639: l_errorcode NUMBER;
640: l_msg_data VARCHAR2 (100);

Line 637: l_new_str_type ego_col_name_value_pair_array;

633: l_item_rec_out inv_item_grp.item_rec_type;
634: l_error_tbl inv_item_grp.error_tbl_type;
635: l_dest_pk_col_name_val_pairs ego_col_name_value_pair_array;
636: l_src_pk_col_name_val_pairs ego_col_name_value_pair_array;
637: l_new_str_type ego_col_name_value_pair_array;
638: l_str_type NUMBER;
639: l_errorcode NUMBER;
640: l_msg_data VARCHAR2 (100);
641: x_acd_type NUMBER;

Line 695: l_old_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

691: l_to_comps num_varray := num_varray
692: ();
693: l_data_level_name_comp VARCHAR2(30) := 'COMPONENTS_LEVEL';
694: l_data_level_id_comp NUMBER;
695: l_old_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
696: l_new_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
697:
698:
699: CURSOR l_common_csr

Line 696: l_new_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

692: ();
693: l_data_level_name_comp VARCHAR2(30) := 'COMPONENTS_LEVEL';
694: l_data_level_id_comp NUMBER;
695: l_old_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
696: l_new_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
697:
698:
699: CURSOR l_common_csr
700: IS

Line 1365: ego_col_name_value_pair_array

1361: THEN
1362:
1363: /* Bug : 4185500 Structure Level Attribute copy */
1364: l_src_pk_col_name_val_pairs :=
1365: ego_col_name_value_pair_array
1366: (ego_col_name_value_pair_obj ('BILL_SEQUENCE_ID',
1367: TO_CHAR (from_sequence_id)
1368: )
1369: );

Line 1371: ego_col_name_value_pair_array

1367: TO_CHAR (from_sequence_id)
1368: )
1369: );
1370: l_dest_pk_col_name_val_pairs :=
1371: ego_col_name_value_pair_array
1372: (ego_col_name_value_pair_obj ('BILL_SEQUENCE_ID',
1373: TO_CHAR (to_sequence_id)
1374: )
1375: );

Line 1377: ego_col_name_value_pair_array

1373: TO_CHAR (to_sequence_id)
1374: )
1375: );
1376: l_new_str_type :=
1377: ego_col_name_value_pair_array
1378: (ego_col_name_value_pair_obj ('STRUCTURE_TYPE_ID',
1379: TO_CHAR (l_str_type)
1380: )
1381: );

Line 3696: ego_col_name_value_pair_array

3692: l_index := l_from_comps.FIRST;
3693: WHILE l_index IS NOT NULL
3694: LOOP
3695: l_src_pk_col_name_val_pairs :=
3696: ego_col_name_value_pair_array
3697: (ego_col_name_value_pair_obj ('COMPONENT_SEQUENCE_ID',
3698: TO_CHAR (l_from_comps (l_index))
3699: ),
3700: ego_col_name_value_pair_obj ('BILL_SEQUENCE_ID',

Line 3705: ego_col_name_value_pair_array

3701: TO_CHAR (from_sequence_id)
3702: )
3703: );
3704: l_dest_pk_col_name_val_pairs :=
3705: ego_col_name_value_pair_array
3706: (ego_col_name_value_pair_obj ('COMPONENT_SEQUENCE_ID',
3707: TO_CHAR (l_to_comps (l_index))
3708: ),
3709: ego_col_name_value_pair_obj ('BILL_SEQUENCE_ID',

Line 3714: ego_col_name_value_pair_array

3710: TO_CHAR (to_sequence_id)
3711: )
3712: );
3713: l_new_str_type :=
3714: ego_col_name_value_pair_array
3715: (ego_col_name_value_pair_obj ('STRUCTURE_TYPE_ID',
3716: TO_CHAR (l_str_type)
3717: )
3718: );

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

3716: TO_CHAR (l_str_type)
3717: )
3718: );
3719:
3720: l_old_dtlevel_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID', ''));
3721: l_new_dtlevel_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID', ''));
3722:
3723: ego_user_attrs_data_pvt.copy_user_attrs_data
3724: (p_api_version => 1.0,

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

3717: )
3718: );
3719:
3720: l_old_dtlevel_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID', ''));
3721: l_new_dtlevel_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID', ''));
3722:
3723: ego_user_attrs_data_pvt.copy_user_attrs_data
3724: (p_api_version => 1.0,
3725: p_application_id => bom_application_id,

Line 7287: l_dest_pk_col_name_val_pairs ego_col_name_value_pair_array;

7283: l_msg_count NUMBER := 0;
7284: l_item_rec_in inv_item_grp.item_rec_type;
7285: l_item_rec_out inv_item_grp.item_rec_type;
7286: l_error_tbl inv_item_grp.error_tbl_type;
7287: l_dest_pk_col_name_val_pairs ego_col_name_value_pair_array;
7288: l_src_pk_col_name_val_pairs ego_col_name_value_pair_array;
7289: l_new_str_type ego_col_name_value_pair_array;
7290: l_str_type NUMBER;
7291: l_errorcode NUMBER;

Line 7288: l_src_pk_col_name_val_pairs ego_col_name_value_pair_array;

7284: l_item_rec_in inv_item_grp.item_rec_type;
7285: l_item_rec_out inv_item_grp.item_rec_type;
7286: l_error_tbl inv_item_grp.error_tbl_type;
7287: l_dest_pk_col_name_val_pairs ego_col_name_value_pair_array;
7288: l_src_pk_col_name_val_pairs ego_col_name_value_pair_array;
7289: l_new_str_type ego_col_name_value_pair_array;
7290: l_str_type NUMBER;
7291: l_errorcode NUMBER;
7292: l_msg_data VARCHAR2 (100);

Line 7289: l_new_str_type ego_col_name_value_pair_array;

7285: l_item_rec_out inv_item_grp.item_rec_type;
7286: l_error_tbl inv_item_grp.error_tbl_type;
7287: l_dest_pk_col_name_val_pairs ego_col_name_value_pair_array;
7288: l_src_pk_col_name_val_pairs ego_col_name_value_pair_array;
7289: l_new_str_type ego_col_name_value_pair_array;
7290: l_str_type NUMBER;
7291: l_errorcode NUMBER;
7292: l_msg_data VARCHAR2 (100);
7293: x_acd_type NUMBER;

Line 7321: l_old_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

7317: l_last_copied_comp_seq_id NUMBER := -1;
7318: l_default_wip_params NUMBER;
7319: l_data_level_name_comp VARCHAR2(30) := 'COMPONENTS_LEVEL';
7320: l_data_level_id_comp NUMBER;
7321: l_old_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
7322: l_new_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
7323:
7324:
7325: CURSOR l_common_csr

Line 7322: l_new_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

7318: l_default_wip_params NUMBER;
7319: l_data_level_name_comp VARCHAR2(30) := 'COMPONENTS_LEVEL';
7320: l_data_level_id_comp NUMBER;
7321: l_old_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
7322: l_new_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
7323:
7324:
7325: CURSOR l_common_csr
7326: IS

Line 7726: ego_col_name_value_pair_array

7722: sql_stmt_num := 20;
7723:
7724: /* Bug : 4185500 Structure Level Attribute copy */
7725: l_src_pk_col_name_val_pairs :=
7726: ego_col_name_value_pair_array
7727: (ego_col_name_value_pair_obj ('BILL_SEQUENCE_ID',
7728: TO_CHAR (from_sequence_id)
7729: )
7730: );

Line 7732: ego_col_name_value_pair_array

7728: TO_CHAR (from_sequence_id)
7729: )
7730: );
7731: l_dest_pk_col_name_val_pairs :=
7732: ego_col_name_value_pair_array
7733: (ego_col_name_value_pair_obj ('BILL_SEQUENCE_ID',
7734: TO_CHAR (to_sequence_id)
7735: )
7736: );

Line 7738: ego_col_name_value_pair_array

7734: TO_CHAR (to_sequence_id)
7735: )
7736: );
7737: l_new_str_type :=
7738: ego_col_name_value_pair_array
7739: (ego_col_name_value_pair_obj ('STRUCTURE_TYPE_ID',
7740: TO_CHAR (l_str_type)
7741: )
7742: );

Line 9718: ego_col_name_value_pair_array

9714: l_index := l_from_comps.FIRST;
9715: WHILE l_index IS NOT NULL
9716: LOOP
9717: l_src_pk_col_name_val_pairs :=
9718: ego_col_name_value_pair_array
9719: (ego_col_name_value_pair_obj ('COMPONENT_SEQUENCE_ID',
9720: TO_CHAR (l_from_comps (l_index))
9721: ),
9722: ego_col_name_value_pair_obj ('BILL_SEQUENCE_ID',

Line 9727: ego_col_name_value_pair_array

9723: TO_CHAR (from_sequence_id)
9724: )
9725: );
9726: l_dest_pk_col_name_val_pairs :=
9727: ego_col_name_value_pair_array
9728: (ego_col_name_value_pair_obj ('COMPONENT_SEQUENCE_ID',
9729: TO_CHAR (l_to_comps (l_index))
9730: ),
9731: ego_col_name_value_pair_obj ('BILL_SEQUENCE_ID',

Line 9736: ego_col_name_value_pair_array

9732: TO_CHAR (to_sequence_id)
9733: )
9734: );
9735: l_new_str_type :=
9736: ego_col_name_value_pair_array
9737: (ego_col_name_value_pair_obj ('STRUCTURE_TYPE_ID',
9738: TO_CHAR (l_str_type)
9739: )
9740: );

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

9738: TO_CHAR (l_str_type)
9739: )
9740: );
9741:
9742: l_old_dtlevel_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID', ''));
9743: l_new_dtlevel_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID', ''));
9744:
9745: ego_user_attrs_data_pvt.copy_user_attrs_data
9746: (p_api_version => 1.0,

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

9739: )
9740: );
9741:
9742: l_old_dtlevel_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID', ''));
9743: l_new_dtlevel_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTEXT_ID', ''));
9744:
9745: ego_user_attrs_data_pvt.copy_user_attrs_data
9746: (p_api_version => 1.0,
9747: p_application_id => bom_application_id,