[Home] [Help]
PACKAGE: APPS.OKS_CCMIGRATE_PVT
Source
1 PACKAGE OKS_CCMIGRATE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKSCMIGS.pls 120.4 2005/11/18 18:27 hvaladip noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL EXCEPTIONS
6
7 ---------------------------------------------------------------------------
8 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
9
10
11 ---------------------------------------------------------------------------
12 -- GLOBAL VARIABLES
13
14 ---------------------------------------------------------------------------
15 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_rule_report';
16 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
17
18
19 ---------------------------------------------------------------------------
20 -- Procedures and Functions
21
22 ---------------------------------------------------------------------------
23
24 Procedure Generate_report
25 (
26 ERRBUF OUT NOCOPY VARCHAR2,
27 RETCODE OUT NOCOPY NUMBER
28 );
29
30 PROCEDURE MIGRATE_CC (
31 ERRBUF OUT NOCOPY VARCHAR2,
32 RETCODE OUT NOCOPY NUMBER,
33 P_SUB_REQUESTS IN NUMBER,
34 P_BATCH_SIZE IN NUMBER);
35
36 PROCEDURE MIGRATE_CC_HDR(
37 ERRBUF OUT NOCOPY VARCHAR2,
38 RETCODE OUT NOCOPY NUMBER,
39 p_id_low IN NUMBER,
40 p_id_high IN NUMBER,
41 p_batchsize IN NUMBER );
42
43 PROCEDURE MIGRATE_CC_LINE(
44 ERRBUF OUT NOCOPY VARCHAR2,
45 RETCODE OUT NOCOPY NUMBER,
46 p_id_low IN NUMBER,
47 p_id_high IN NUMBER,
48 p_batchsize IN NUMBER );
49
50 PROCEDURE MIGRATE_CC_LINEH(
51 ERRBUF OUT NOCOPY VARCHAR2,
52 RETCODE OUT NOCOPY NUMBER,
53 p_id_low IN NUMBER,
54 p_id_high IN NUMBER,
55 p_batchsize IN NUMBER );
56
57
58 PROCEDURE MIGRATE_CC_HDRH(
59 ERRBUF OUT NOCOPY VARCHAR2,
60 RETCODE OUT NOCOPY NUMBER,
61 p_id_low IN NUMBER,
62 p_id_high IN NUMBER,
63 p_batchsize IN NUMBER );
64
65 Procedure Purge_CC_Number
66 (
67 ERRBUF OUT NOCOPY VARCHAR2,
68 RETCODE OUT NOCOPY NUMBER,
69 P_BATCH_SIZE IN NUMBER
70 );
71
72 PROCEDURE UPDATE_CC_LINEH(
73 ERRBUF OUT NOCOPY VARCHAR2,
74 RETCODE OUT NOCOPY NUMBER,
75 p_id_low IN NUMBER,
76 p_id_high IN NUMBER,
77 p_batchsize IN NUMBER );
78 PROCEDURE UPDATE_CC_HEADERH(
79 ERRBUF OUT NOCOPY VARCHAR2,
80 RETCODE OUT NOCOPY NUMBER,
81 p_id_low IN NUMBER,
82 p_id_high IN NUMBER,
83 p_batchsize IN NUMBER );
84
85 PROCEDURE UPDATE_CC_HEADER(
86 ERRBUF OUT NOCOPY VARCHAR2,
87 RETCODE OUT NOCOPY NUMBER,
88 p_id_low IN NUMBER,
89 p_id_high IN NUMBER,
90 p_batchsize IN NUMBER );
91 PROCEDURE UPDATE_CC_HEADER_RULE(
92 ERRBUF OUT NOCOPY VARCHAR2,
93 RETCODE OUT NOCOPY NUMBER,
94 p_id_low IN NUMBER,
95 p_id_high IN NUMBER,
96 p_batchsize IN NUMBER );
97 PROCEDURE UPDATE_CC_LINE(
98 ERRBUF OUT NOCOPY VARCHAR2,
99 RETCODE OUT NOCOPY NUMBER,
100 p_id_low IN NUMBER,
101 p_id_high IN NUMBER,
102 p_batchsize IN NUMBER );
103
104
105 END OKS_CCMIGRATE_PVT; -- Package spec