APPS.PV_CATEGORY_MIGRATION dependencies on PV_SELECTED_ATTR_VALUES

Line 53: --| pv_selected_attr_values to single product hierarchy. |

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 |
57: --| |

Line 113: FROM pv_selected_attr_values a,

109:
110: CURSOR c_selected_attr_values IS
111: SELECT DISTINCT
112: a.attribute_value old_value
113: FROM pv_selected_attr_values a,
114: pv_enty_select_criteria c,
115: (
116: select interest_type code,
117: TO_CHAR(interest_type_id) id,

Line 175: FROM pv_selected_attr_values a,

171: 'INSERT INTO pv_single_prod_h_mappings2
172: SELECT a.attr_value_id,
173: b.product_category_id new_value,
174: a.attribute_value old_value
175: FROM pv_selected_attr_values a,
176: pv_enty_select_criteria c,
177: (
178: select to_char(interest_type_id) code, product_category_id
179: from as_interest_types_b

Line 280: -- pv_selected_attr_values: revert back to Sales Product Hierarchy.

276: END IF;
277:
278:
279: -- -----------------------------------------------------------------------
280: -- pv_selected_attr_values: revert back to Sales Product Hierarchy.
281: -- -----------------------------------------------------------------------
282: IF (l_revert_selected_attr) THEN
283: l_update_ddl :=
284: 'UPDATE pv_selected_attr_values a

Line 284: 'UPDATE pv_selected_attr_values a

280: -- pv_selected_attr_values: revert back to Sales Product Hierarchy.
281: -- -----------------------------------------------------------------------
282: IF (l_revert_selected_attr) THEN
283: l_update_ddl :=
284: 'UPDATE pv_selected_attr_values a
285: SET attribute_value =
286: (SELECT old_value
287: FROM pv_single_prod_h_mappings2 b
288: WHERE a.attr_value_id = b.attr_value_id)

Line 354: p_token1_value => 'pv_selected_attr_values'

350: Debug('(3).');
351: Set_Message(
352: p_msg_name => 'PV_SPH_NO_MAPPING',
353: p_token1 => 'TABLE',
354: p_token1_value => 'pv_selected_attr_values'
355: );
356: Debug('-');
357: Debug('------------------------------------------------------------');
358: Debug('-');

Line 461: p_token2_value => 'pv_selected_attr_values'

457: p_msg_name => 'PV_SPH_POPULATE_MAPPING',
458: p_token1 => 'TABLE1',
459: p_token1_value => 'pv_single_prod_h_mappings2',
460: p_token2 => 'TABLE2',
461: p_token2_value => 'pv_selected_attr_values'
462: );
463:
464: Debug('-');
465:

Line 538: -- Update pv_selected_attr_values

534: Debug('-');
535:
536:
537: -- -----------------------------------------------------------------------
538: -- Update pv_selected_attr_values
539: -- -----------------------------------------------------------------------
540: Debug('(7).');
541: Set_Message(
542: p_msg_name => 'PV_SPH_UPDATE_TABLE',

Line 544: p_token1_value => 'pv_selected_attr_values'

540: Debug('(7).');
541: Set_Message(
542: p_msg_name => 'PV_SPH_UPDATE_TABLE',
543: p_token1 => 'TABLE',
544: p_token1_value => 'pv_selected_attr_values'
545: );
546: Debug('-');
547:
548: l_update_ddl :=

Line 549: 'UPDATE pv_selected_attr_values a

545: );
546: Debug('-');
547:
548: l_update_ddl :=
549: 'UPDATE pv_selected_attr_values a
550: SET attribute_value =
551: (SELECT new_value
552: FROM pv_single_prod_h_mappings2 b
553: WHERE a.attr_value_id = b.attr_value_id)

Line 593: p_token1_value => 'pv_selected_attr_values',

589:
590: Set_Message(
591: p_msg_name => 'PV_SPH_VIEW_MAPPING_TABLE',
592: p_token1 => 'TABLE1',
593: p_token1_value => 'pv_selected_attr_values',
594: p_token2 => 'TABLE2',
595: p_token2_value => 'pv_single_prod_h_mappings2'
596: );
597: