DBA Data[Home] [Help]

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 1313: ego_col_name_value_pair_array

1309: THEN
1310:
1311: /* Bug : 4185500 Structure Level Attribute copy */
1312: l_src_pk_col_name_val_pairs :=
1313: ego_col_name_value_pair_array
1314: (ego_col_name_value_pair_obj ('BILL_SEQUENCE_ID',
1315: TO_CHAR (from_sequence_id)
1316: )
1317: );

Line 1319: ego_col_name_value_pair_array

1315: TO_CHAR (from_sequence_id)
1316: )
1317: );
1318: l_dest_pk_col_name_val_pairs :=
1319: ego_col_name_value_pair_array
1320: (ego_col_name_value_pair_obj ('BILL_SEQUENCE_ID',
1321: TO_CHAR (to_sequence_id)
1322: )
1323: );

Line 1325: ego_col_name_value_pair_array

1321: TO_CHAR (to_sequence_id)
1322: )
1323: );
1324: l_new_str_type :=
1325: ego_col_name_value_pair_array
1326: (ego_col_name_value_pair_obj ('STRUCTURE_TYPE_ID',
1327: TO_CHAR (l_str_type)
1328: )
1329: );

Line 3642: ego_col_name_value_pair_array

3638: l_index := l_from_comps.FIRST;
3639: WHILE l_index IS NOT NULL
3640: LOOP
3641: l_src_pk_col_name_val_pairs :=
3642: ego_col_name_value_pair_array
3643: (ego_col_name_value_pair_obj ('COMPONENT_SEQUENCE_ID',
3644: TO_CHAR (l_from_comps (l_index))
3645: ),
3646: ego_col_name_value_pair_obj ('BILL_SEQUENCE_ID',

Line 3651: ego_col_name_value_pair_array

3647: TO_CHAR (from_sequence_id)
3648: )
3649: );
3650: l_dest_pk_col_name_val_pairs :=
3651: ego_col_name_value_pair_array
3652: (ego_col_name_value_pair_obj ('COMPONENT_SEQUENCE_ID',
3653: TO_CHAR (l_to_comps (l_index))
3654: ),
3655: ego_col_name_value_pair_obj ('BILL_SEQUENCE_ID',

Line 3660: ego_col_name_value_pair_array

3656: TO_CHAR (to_sequence_id)
3657: )
3658: );
3659: l_new_str_type :=
3660: ego_col_name_value_pair_array
3661: (ego_col_name_value_pair_obj ('STRUCTURE_TYPE_ID',
3662: TO_CHAR (l_str_type)
3663: )
3664: );

Line 7191: l_dest_pk_col_name_val_pairs ego_col_name_value_pair_array;

7187: l_msg_count NUMBER := 0;
7188: l_item_rec_in inv_item_grp.item_rec_type;
7189: l_item_rec_out inv_item_grp.item_rec_type;
7190: l_error_tbl inv_item_grp.error_tbl_type;
7191: l_dest_pk_col_name_val_pairs ego_col_name_value_pair_array;
7192: l_src_pk_col_name_val_pairs ego_col_name_value_pair_array;
7193: l_new_str_type ego_col_name_value_pair_array;
7194: l_str_type NUMBER;
7195: l_errorcode NUMBER;

Line 7192: l_src_pk_col_name_val_pairs ego_col_name_value_pair_array;

7188: l_item_rec_in inv_item_grp.item_rec_type;
7189: l_item_rec_out inv_item_grp.item_rec_type;
7190: l_error_tbl inv_item_grp.error_tbl_type;
7191: l_dest_pk_col_name_val_pairs ego_col_name_value_pair_array;
7192: l_src_pk_col_name_val_pairs ego_col_name_value_pair_array;
7193: l_new_str_type ego_col_name_value_pair_array;
7194: l_str_type NUMBER;
7195: l_errorcode NUMBER;
7196: l_msg_data VARCHAR2 (100);

Line 7193: l_new_str_type ego_col_name_value_pair_array;

7189: l_item_rec_out inv_item_grp.item_rec_type;
7190: l_error_tbl inv_item_grp.error_tbl_type;
7191: l_dest_pk_col_name_val_pairs ego_col_name_value_pair_array;
7192: l_src_pk_col_name_val_pairs ego_col_name_value_pair_array;
7193: l_new_str_type ego_col_name_value_pair_array;
7194: l_str_type NUMBER;
7195: l_errorcode NUMBER;
7196: l_msg_data VARCHAR2 (100);
7197: x_acd_type NUMBER;

Line 7585: ego_col_name_value_pair_array

7581: sql_stmt_num := 20;
7582:
7583: /* Bug : 4185500 Structure Level Attribute copy */
7584: l_src_pk_col_name_val_pairs :=
7585: ego_col_name_value_pair_array
7586: (ego_col_name_value_pair_obj ('BILL_SEQUENCE_ID',
7587: TO_CHAR (from_sequence_id)
7588: )
7589: );

Line 7591: ego_col_name_value_pair_array

7587: TO_CHAR (from_sequence_id)
7588: )
7589: );
7590: l_dest_pk_col_name_val_pairs :=
7591: ego_col_name_value_pair_array
7592: (ego_col_name_value_pair_obj ('BILL_SEQUENCE_ID',
7593: TO_CHAR (to_sequence_id)
7594: )
7595: );

Line 7597: ego_col_name_value_pair_array

7593: TO_CHAR (to_sequence_id)
7594: )
7595: );
7596: l_new_str_type :=
7597: ego_col_name_value_pair_array
7598: (ego_col_name_value_pair_obj ('STRUCTURE_TYPE_ID',
7599: TO_CHAR (l_str_type)
7600: )
7601: );

Line 9573: ego_col_name_value_pair_array

9569: l_index := l_from_comps.FIRST;
9570: WHILE l_index IS NOT NULL
9571: LOOP
9572: l_src_pk_col_name_val_pairs :=
9573: ego_col_name_value_pair_array
9574: (ego_col_name_value_pair_obj ('COMPONENT_SEQUENCE_ID',
9575: TO_CHAR (l_from_comps (l_index))
9576: ),
9577: ego_col_name_value_pair_obj ('BILL_SEQUENCE_ID',

Line 9582: ego_col_name_value_pair_array

9578: TO_CHAR (from_sequence_id)
9579: )
9580: );
9581: l_dest_pk_col_name_val_pairs :=
9582: ego_col_name_value_pair_array
9583: (ego_col_name_value_pair_obj ('COMPONENT_SEQUENCE_ID',
9584: TO_CHAR (l_to_comps (l_index))
9585: ),
9586: ego_col_name_value_pair_obj ('BILL_SEQUENCE_ID',

Line 9591: ego_col_name_value_pair_array

9587: TO_CHAR (to_sequence_id)
9588: )
9589: );
9590: l_new_str_type :=
9591: ego_col_name_value_pair_array
9592: (ego_col_name_value_pair_obj ('STRUCTURE_TYPE_ID',
9593: TO_CHAR (l_str_type)
9594: )
9595: );