1 PACKAGE AS_INT_TYP_COD_MIGRATION AUTHID CURRENT_USER as
2 /* $Header: asxmints.pls 120.1 2005/12/22 22:53:19 subabu noship $ */
3
4 /*
5 This procedure migrates all the perz data and transaction data
6 This is called by concurrent program 'Product Catalog Migration'
7 */
8 PROCEDURE Migrate_All (
9 ERRBUF OUT NOCOPY VARCHAR2,
10 RETCODE OUT NOCOPY VARCHAR2,
11 p_Debug_Flag IN VARCHAR2 Default 'N'
12 );
13
14 /*
15 This is called by concurrent program 'Product Catalog Migration for Perz Data'
16
17 This procedure migrates all the perz data
18 If parameter_name is 'productCategory' or 'prodCat', the parameter name is converted
19 to the format rep.ROW0.ProdCategory and the corresponding parameter_value is converted
20 to category id (mapped to the interest type id stored previously).
21
22 Here is an example:
23 old scheme:
24 parameter name parameter value
25 -------------- ---------------
26 prodCat 207
27 prodCat 208
28
29
30 new scheme:
31 parameter name parameter value
32 -------------- ---------------
33 rep.ROW0.ProdCategory xxxxxx (where xxxxxx is the new category_id corresponding to interest type 207)
34 rep.ROW1.ProdCategory yyyyyy (where yyyyyy is the new category_id corresponding to interest type 208)
35
36 For 'Opportunity by Products Report', the perz data is stored differently
37 old scheme:
38 parameter name parameter value
39 -------------- ---------------
40 ROW0ProductCategory 207/434/435
41 ROW1ProductCategory 208
42 ROW2ProductCategory 208/460
43 ROW0.Invt CM18761
44 invItemID0 253
45
46
47 new scheme:
48 parameter name parameter value
49 -------------- ---------------
50 rep.ROW0.ProdCategory xxxxxx (where xxxxxx is the new category id corresponding to interest code 435)
51 rep.ROW1.ProdCategory yyyyyy (where yyyyyy is the new category id corresponding to interest type 208)
52 rep.ROW2.ProdCategory zzzzzz (where zzzzzz is the new category id corresponding to interest code 460)
53 rep.ROW0.invItemID 253
54 rep.ROW0.invItem CM18761
55 */
56 PROCEDURE Migrate_Perz_Data (
57 ERRBUF OUT NOCOPY VARCHAR2,
58 RETCODE OUT NOCOPY VARCHAR2,
59 p_Debug_Flag IN VARCHAR2 Default 'N'
60 );
61
62 /*
63 This is called by concurrent program 'Product Catalog Migration for Opportunity Lines'
64
65 This procedure migrates product_category_id and product_cat_set_id into the
66 AS_LEAD_LNES_ALL table.
67
68 Note that it disables the trigger before
69 starting the migration. The triggers are re-enabled after the migration.
70 */
71 PROCEDURE Migrate_AS_LEAD_LINES_ALL (
72 ERRBUF OUT NOCOPY VARCHAR2,
73 RETCODE OUT NOCOPY VARCHAR2,
74 p_Debug_Flag IN VARCHAR2 Default 'N'
75 );
76
77 /*
78 This is called by concurrent program 'Product Catalog Migration for Forecast Categories'
79
80 This procedure migrates product_category_id and product_cat_set_id into the
81 AS_FST_SALES_CATEGORIES table.
82 */
83 PROCEDURE Migrate_FST_SALES_CATEGORIES (
84 ERRBUF OUT NOCOPY VARCHAR2,
85 RETCODE OUT NOCOPY VARCHAR2,
86 p_Debug_Flag IN VARCHAR2 Default 'N'
87 );
88
89 /*
90 This is called by concurrent program 'Product Catalog Migration for Opportunity Logs'
91
92 This procedure migrates product_category_id and product_cat_set_id into the
93 AS_LEAD_LINES_LOG table.
94 */
95 PROCEDURE Migrate_AS_LEAD_LINES_LOG (
96 ERRBUF OUT NOCOPY VARCHAR2,
97 RETCODE OUT NOCOPY VARCHAR2,
98 p_Debug_Flag IN VARCHAR2 Default 'N'
99 );
100
101 /*
102 This is called by concurrent program 'Product Catalog Migration for Product Interests'
103
104 This procedure migrates product_category_id and product_cat_set_id into the
105 AS_INTERESTS_ALL table.
106 */
107 PROCEDURE Migrate_AS_INTERESTS_ALL (
108 ERRBUF OUT NOCOPY VARCHAR2,
109 RETCODE OUT NOCOPY VARCHAR2,
110 p_Debug_Flag IN VARCHAR2 Default 'N'
111 );
112
113 /*
114 This is called by concurrent program 'Product Catalog Migration for Sales Credits'
115
116 This procedure migrates product_category_id and product_cat_set_id into the
117 AS_SALES_CREDITS_DENORM table.
118 */
119 PROCEDURE Migrate_AS_SALES_C_DENORM (
120 ERRBUF OUT NOCOPY VARCHAR2,
121 RETCODE OUT NOCOPY VARCHAR2,
122 p_Debug_Flag IN VARCHAR2 Default 'N'
123 );
124 /*
125 This is called by concurrent program 'Product Catalog Migration for Forecast Product Worksheet'
126
127 This procedure migrates product_category_id and product_cat_set_id into the
128 AS_PROD_WORKSHEET_LINES table.
129 */
130 PROCEDURE Migrate_AS_PRODWKS_LINES (
131 ERRBUF OUT NOCOPY VARCHAR2,
132 RETCODE OUT NOCOPY VARCHAR2,
133 p_Debug_Flag IN VARCHAR2 Default 'N'
134 );
135
136 /*
137 This is called by concurrent program 'Product Catalog Migration for Plan Element Mapping'
138
139 This procedure migrates product_category_id and product_cat_set_id into the
140 AS_PE_INT_CATEGORIES table.
141 */
142 PROCEDURE Migrate_AS_PE_INT_CATEGORIES (
143 ERRBUF OUT NOCOPY VARCHAR2,
144 RETCODE OUT NOCOPY VARCHAR2,
145 p_Debug_Flag IN VARCHAR2 Default 'N'
146 );
147
148
149
150 END AS_INT_TYP_COD_MIGRATION;