1 PACKAGE OKC_ARTICLES_MIGRATE_GRP AS
2 /* $Header: OKCGARTMIGS.pls 120.0 2005/05/25 23:15:03 appldev noship $ */
3
4
5
6 TYPE article_txt_tbl_type is table of OKC_ART_INTERFACE_ALL.ARTICLE_TEXT%TYPE ;
7
8
9 ---------------------------------------------------------------------------
10 -- Procedures and Functions
11 ---------------------------------------------------------------------------
12
13 /*===================================================
14 | PROCEDURE conc_migrate_articles
15 | conc. program wrapper for migrate_articles
16 | This will internally call the main API.
17 | Parameters passed are
18 | 1. p_fetchsize is fetch and/or commit size for BULK operations
19 +==================================================*/
20 PROCEDURE conc_migrate_articles(
21 errbuf OUT NOCOPY VARCHAR2,
22 retcode OUT NOCOPY VARCHAR2,
23 p_fetchsize IN NUMBER := 100 );
24
25
26 /*===================================================
27 | PROCEDURE migrate articles
28 | The users can specify if this is to be run only for an org.
29 | The default behavior is to run for all orgs that are setup
30 | through HR Org EITs.
31 | If the user specifies that this is for the current org and that
32 | belongs to the Global Org, this will be run as a regular migration
33 | The users will need to specify a batch size or commit size.
34 |
35 | Parameters passed are
36 | 1. p_fetchsize is fetch and/or commit size for BULK operations
37 +==================================================*/
38 PROCEDURE migrate_articles(
39 x_return_status OUT NOCOPY VARCHAR2,
40 x_msg_count OUT NOCOPY NUMBER,
41 x_msg_data OUT NOCOPY VARCHAR2,
42 p_fetchsize IN NUMBER := 100
43 );
44
45
46 END OKC_ARTICLES_MIGRATE_GRP;