APPS.PV_CATEGORY_MIGRATION dependencies on PV_ENTY_ATTR_VALUES

Line 52: --| This script is used to migrate pv_enty_attr_values and |

48: --| Public Procedure |
49: --| Category_Migration |
50: --| |
51: --| Purpose |
52: --| This script is used to migrate pv_enty_attr_values and |
53: --| pv_selected_attr_values to single product hierarchy. |
54: --| |
55: --| |
56: --| NOTES |

Line 82: FROM pv_enty_attr_values a,

78:
79: CURSOR c_enty_attr_values IS
80: SELECT DISTINCT
81: b.code old_value, b.product_category_id
82: FROM pv_enty_attr_values a,
83: (
84: select interest_type code,
85: TO_CHAR(interest_type_id) id,
86: product_category_id

Line 148: FROM pv_enty_attr_values a,

144: 'INSERT INTO pv_single_prod_h_mappings
145: SELECT a.enty_attr_val_id,
146: b.product_category_id new_value,
147: b.code old_value
148: FROM pv_enty_attr_values a,
149: (
150: select to_char(interest_type_id) code, product_category_id
151: from as_interest_types_b
152: union

Line 254: -- pv_enty_attr_values: revert back to Sales Product Hierarchy.

250: l_revert_selected_attr := TRUE;
251: END LOOP;
252:
253: -- -----------------------------------------------------------------------
254: -- pv_enty_attr_values: revert back to Sales Product Hierarchy.
255: -- -----------------------------------------------------------------------
256: IF (l_revert_entity_attr) THEN
257: l_update_ddl :=
258: 'UPDATE pv_enty_attr_values a

Line 258: 'UPDATE pv_enty_attr_values a

254: -- pv_enty_attr_values: revert back to Sales Product Hierarchy.
255: -- -----------------------------------------------------------------------
256: IF (l_revert_entity_attr) THEN
257: l_update_ddl :=
258: 'UPDATE pv_enty_attr_values a
259: SET attr_value = (SELECT old_value
260: FROM pv_single_prod_h_mappings b
261: WHERE a.enty_attr_val_id = b.enty_attr_val_id)
262: WHERE EXISTS (SELECT 1

Line 305: -- Check if all the data in pv_enty_attr_values have proper mapping.

301: );
302: END IF;
303:
304: -- -----------------------------------------------------------------------
305: -- Check if all the data in pv_enty_attr_values have proper mapping.
306: -- -----------------------------------------------------------------------
307: l_no_data_found := TRUE;
308:
309: Debug('-');

Line 315: p_token1_value => 'pv_enty_attr_values'

311: Debug('(2).');
312: Set_Message(
313: p_msg_name => 'PV_SPH_NO_MAPPING',
314: p_token1 => 'TABLE',
315: p_token1_value => 'pv_enty_attr_values'
316: );
317: Debug('-');
318: Debug('------------------------------------------------------------');
319:

Line 404: p_token2_value => 'pv_enty_attr_values'

400: p_msg_name => 'PV_SPH_POPULATE_MAPPING',
401: p_token1 => 'TABLE1',
402: p_token1_value => 'pv_single_prod_h_mappings',
403: p_token2 => 'TABLE2',
404: p_token2_value => 'pv_enty_attr_values'
405: );
406:
407: Debug('-');
408:

Line 505: -- Update pv_enty_attr_values

501: Debug('-');
502:
503:
504: -- -----------------------------------------------------------------------
505: -- Update pv_enty_attr_values
506: -- -----------------------------------------------------------------------
507: Debug('(6).');
508: Set_Message(
509: p_msg_name => 'PV_SPH_UPDATE_TABLE',

Line 511: p_token1_value => 'pv_enty_attr_values'

507: Debug('(6).');
508: Set_Message(
509: p_msg_name => 'PV_SPH_UPDATE_TABLE',
510: p_token1 => 'TABLE',
511: p_token1_value => 'pv_enty_attr_values'
512: );
513: Debug('-');
514:
515: l_update_ddl :=

Line 516: 'UPDATE pv_enty_attr_values a

512: );
513: Debug('-');
514:
515: l_update_ddl :=
516: 'UPDATE pv_enty_attr_values a
517: SET attr_value = (SELECT new_value
518: FROM pv_single_prod_h_mappings b
519: WHERE a.enty_attr_val_id = b.enty_attr_val_id)
520: WHERE EXISTS (SELECT 1

Line 579: p_token1_value => 'pv_enty_attr_values',

575: Debug('-');
576: Set_Message(
577: p_msg_name => 'PV_SPH_VIEW_MAPPING_TABLE',
578: p_token1 => 'TABLE1',
579: p_token1_value => 'pv_enty_attr_values',
580: p_token2 => 'TABLE2',
581: p_token2_value => 'pv_single_prod_h_mappings'
582: );
583: