1 PACKAGE JTF_TTY_PROD_CAT_MIGRATE_PVT AUTHID CURRENT_USER as
2 /* $Header: jtftrmps.pls 120.0 2005/06/02 18:21:40 appldev noship $ */
3
4 /* This procedure calls other procedure(s) to migrate the interest types, primary
5 interest codes and secondary interest codes for Opportunity Expected Purchase
6 and Lead Expected Purchase in the JTF_TERR_VALUES_ALL table. It also updates
7 the JTF_TERR_QUAL_ALL table with new qual_usg_ids */
8 PROCEDURE Migrate_All( ERRBUF OUT NOCOPY VARCHAR2,
9 RETCODE OUT NOCOPY VARCHAR2,
10 p_Debug_Flag IN VARCHAR2 default 'N');
11
12 /* This procedure migrates interest types, primary interest codes and secondary
13 interest codes in the JTF_TERR_VALUES_ALL table */
14 PROCEDURE Migrate_Product_Cat_Terr(p_Qual_Usg_Id IN NUMBER,
15 p_Qual_Usg_Id_New IN NUMBER,
16 p_Debug_Flag IN VARCHAR2 Default 'N');
17
18 /* This procedure migrates interest types in the JTF_TTY_ROLE_PROD_INT table */
19 PROCEDURE Migrate_Product_Cat_Role(p_Debug_Flag IN VARCHAR2 Default 'N');
20
21 END JTF_TTY_PROD_CAT_MIGRATE_PVT;
22