PACKAGE: APPS.OKC_ARTICLES_IMPORT_GRP

Source

1 PACKAGE OKC_ARTICLES_IMPORT_GRP AUTHID CURRENT_USER AS
2 /* $Header: OKCGAIMS.pls 120.3 2010/04/06 08:59:13 aveeraba ship $ */
3 
4 
5   TYPE article_txt_tbl_type is table of OKC_ART_INTERFACE_ALL.ARTICLE_TEXT%TYPE ;
6 
7 
8   ---------------------------------------------------------------------------
9   -- Procedures and Functions
10   ---------------------------------------------------------------------------
11 
12   PROCEDURE conc_purge_interface (
13     errbuf           OUT NOCOPY VARCHAR2,
14     retcode          OUT NOCOPY VARCHAR2,
15     p_start_date     IN VARCHAR2,
16     p_end_date       IN VARCHAR2,
17     p_process_status IN VARCHAR2,
18     p_batch_number   IN VARCHAR2);
19 
20   PROCEDURE conc_import_articles(
21     x_return_status  OUT NOCOPY VARCHAR2,
22     x_msg_count      OUT NOCOPY NUMBER,
23     x_msg_data       OUT NOCOPY VARCHAR2,
24     p_batch_procs_id IN  NUMBER,
25     p_batch_number   IN  VARCHAR2,
26     p_validate_only  IN  VARCHAR2 := 'Y',
27     p_fetchsize      IN  NUMBER  := 100 );
28 
29 
30   PROCEDURE import_articles(
31     x_return_status                OUT NOCOPY VARCHAR2,
32     x_msg_count                    OUT NOCOPY NUMBER,
33     x_msg_data                     OUT NOCOPY VARCHAR2,
34 
35     p_batch_procs_id               IN NUMBER,
36     p_batch_number                 IN VARCHAR2,
37     p_validate_only                IN VARCHAR2 := 'Y',
38     p_fetchsize                    IN NUMBER := 100,
39     p_rows_processed               OUT NOCOPY NUMBER,
40     p_rows_failed                   OUT NOCOPY NUMBER,
41     p_rows_warned                 OUT NOCOPY NUMBER
42   );
43 
44   PROCEDURE import_variables(
45     x_return_status                OUT NOCOPY VARCHAR2,
46     x_msg_count                    OUT NOCOPY NUMBER,
47     x_msg_data                     OUT NOCOPY VARCHAR2,
48 
49     p_batch_procs_id               IN NUMBER,
50     p_batch_number                 IN VARCHAR2,
51     p_validate_only                IN VARCHAR2 := 'Y',
52     p_fetchsize                    IN NUMBER := 100
53   );
54 
55   PROCEDURE import_relationships(
56     x_return_status                OUT NOCOPY VARCHAR2,
57     x_msg_count                    OUT NOCOPY NUMBER,
58     x_msg_data                     OUT NOCOPY VARCHAR2,
59 
60     p_batch_procs_id               IN NUMBER,
61     p_batch_number                 IN VARCHAR2,
62     p_validate_only                IN VARCHAR2 := 'Y',
63     p_fetchsize                    IN NUMBER := 100,
64     p_rows_processed               OUT NOCOPY NUMBER,
65     p_rows_failed                   OUT NOCOPY NUMBER,
66     p_rows_warned                 OUT NOCOPY NUMBER
67   );
68 
69   PROCEDURE import_fnd_flex_value_sets(
70     x_return_status                OUT NOCOPY VARCHAR2,
71     x_msg_count                    OUT NOCOPY NUMBER,
72     x_msg_data                     OUT NOCOPY VARCHAR2,
73 
74     p_batch_procs_id               IN NUMBER,
75     p_batch_number                 IN VARCHAR2,
76     p_validate_only                IN VARCHAR2 := 'Y',
77     p_fetchsize                    IN NUMBER := 100
78   );
79 
80   PROCEDURE import_fnd_flex_values(
81     x_return_status                OUT NOCOPY VARCHAR2,
82     x_msg_count                    OUT NOCOPY NUMBER,
83     x_msg_data                     OUT NOCOPY VARCHAR2,
84 
85     p_batch_procs_id               IN NUMBER,
86     p_batch_number                 IN VARCHAR2,
87     p_validate_only                IN VARCHAR2 := 'Y',
88     p_fetchsize                    IN NUMBER := 100
89   );
90 
91 --CLM impact on contracts changes
92 PROCEDURE import_scn_map(
93     x_return_status                OUT NOCOPY VARCHAR2,
94     p_batch_number                 IN VARCHAR2,
95     p_fetchsize                    IN NUMBER := 100
96    );
97 END OKC_ARTICLES_IMPORT_GRP;