PACKAGE: APPS.HZ_IMP_DQM_STAGE

Source

1 PACKAGE HZ_IMP_DQM_STAGE AUTHID CURRENT_USER AS
2 /* $Header: ARHDISTS.pls 120.5 2005/10/30 03:51:45 appldev noship $ */
3 
4 PROCEDURE gen_pkg_spec (
5 	    p_pkg_name 	IN	VARCHAR2,
6         p_rule_id	IN	NUMBER
7 );
8 
9 PROCEDURE gen_pkg_body (
10         p_pkg_name      IN      VARCHAR2,
11         p_rule_id	IN	NUMBER
12 );
13 
14 PROCEDURE dqm_pre_imp_cleanup (
15     p_batch_id  IN NUMBER,
16      x_return_status                    OUT NOCOPY    VARCHAR2,
17      x_msg_count                        OUT NOCOPY    NUMBER,
18      x_msg_data                         OUT NOCOPY    VARCHAR2
19 );
20 
21 PROCEDURE dqm_inter_imp_cleanup (
22     p_batch_id  IN NUMBER,
23      x_return_status                    OUT NOCOPY    VARCHAR2,
24      x_msg_count                        OUT NOCOPY    NUMBER,
25      x_msg_data                         OUT NOCOPY    VARCHAR2
26 );
27 
28 PROCEDURE dqm_post_imp_cleanup (
29     p_batch_id  IN NUMBER,
30      x_return_status                    OUT NOCOPY    VARCHAR2,
31      x_msg_count                        OUT NOCOPY    NUMBER,
32      x_msg_data                         OUT NOCOPY    VARCHAR2
33 ) ;
34 
35 PROCEDURE interface_dup_id(
36     retcode  OUT NOCOPY   VARCHAR2,
37     err             OUT NOCOPY    VARCHAR2,
38     p_batch_id IN   VARCHAR2,
39     p_match_rule_id IN  VARCHAR2,
40     p_num_of_workers    IN  VARCHAR2
41 );
42 
43 PROCEDURE interface_dup_id_worker (
44     retcode  OUT NOCOPY   VARCHAR2,
45     err             OUT NOCOPY    VARCHAR2,
46     p_batch_id IN   VARCHAR2,
47     p_match_rule_id IN  VARCHAR2,
48     p_worker_num    IN VARCHAR2,
49     p_num_of_workers    IN  VARCHAR2,
50     p_phase IN  OUT NOCOPY VARCHAR2
51 );
52 
53 PROCEDURE POP_INTERFACE_SEARCH_TAB (
54     p_batch_id				 IN   NUMBER,
55     p_match_rule_id         IN      NUMBER,
56     p_from_osr                       IN   VARCHAR2,
57     p_to_osr                         IN   VARCHAR2,
58     x_return_status                    OUT NOCOPY    VARCHAR2,
59     x_msg_count                        OUT NOCOPY    NUMBER,
60     x_msg_data                         OUT NOCOPY    VARCHAR2
61   );
62 
63  PROCEDURE POP_INT_TCA_SEARCH_TAB (
64      p_batch_id				 IN   NUMBER,
65      p_match_rule_id         IN      NUMBER,
66      p_from_osr                       IN   VARCHAR2,
67      p_to_osr                         IN   VARCHAR2 ,
68      p_batch_mode_flag                 IN VARCHAR2,
69      x_return_status                    OUT NOCOPY    VARCHAR2,
70      x_msg_count                        OUT NOCOPY    NUMBER,
71      x_msg_data                         OUT NOCOPY    VARCHAR2
72    );
73 
74 
75 FUNCTION get_os (p_batch_id IN NUMBER
76 ) RETURN VARCHAR2 ;
77 
78   FUNCTION get_owner_name (
79     p_object_name IN  VARCHAR2,
80     p_object_type IN VARCHAR2
81 ) RETURN VARCHAR2;
82 
83 FUNCTION EXIST_COL (attr_name IN VARCHAR2,
84                 entity IN VARCHAR2)
85 RETURN VARCHAR2;
86 
87 /*
88 procedure gen_hz_dqm_imp_debug(
89 	    p_rule_id	IN	NUMBER,
90         x_return_status         OUT NOCOPY     VARCHAR2,
91         x_msg_count             OUT NOCOPY     NUMBER,
92         x_msg_data              OUT NOCOPY     VARCHAR2
93 );
94 */
95 END HZ_IMP_DQM_STAGE;
96