[Home] [Help]
PACKAGE: APPS.OKL_SERVICE_LINE_PROCESS_PVT
Source
1 PACKAGE OKL_SERVICE_LINE_PROCESS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRSLPS.pls 120.2 2005/10/30 04:38:00 appldev noship $ */
3
4 -----------------------------------------------------------------------------
5 -- PACKAGE SPECIFIC CONSTANTS
6 -----------------------------------------------------------------------------
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SERVICE_LINE_PROCESS_PVT';
8
9 -----------------------------------------------------------------------------
10 -- APPLICATION GLOBAL CONSTANTS
11 -----------------------------------------------------------------------------
12 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
13 G_API_VERSION CONSTANT NUMBER := 1;
14 G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
15 G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
16 G_DB_ERROR CONSTANT VARCHAR2(12) := 'OKL_DB_ERROR';
17 G_PROG_NAME_TOKEN CONSTANT VARCHAR2(9) := 'PROG_NAME';
18 G_SQLCODE_TOKEN CONSTANT VARCHAR2(7) := 'SQLCODE';
19 G_SQLERRM_TOKEN CONSTANT VARCHAR2(7) := 'SQLERRM';
20 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
21 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
22 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
23
24 -----------------------------------------------------------------------------
25 -- DATA STRUCTURES
26 -----------------------------------------------------------------------------
27 SUBTYPE klev_rec_type IS okl_kle_pvt.klev_rec_type;
28 SUBTYPE klev_tbl_type IS okl_kle_pvt.klev_tbl_type;
29 SUBTYPE clev_rec_type IS okl_okc_migration_pvt.clev_rec_type;
30 SUBTYPE clev_tbl_type IS okl_okc_migration_pvt.clev_tbl_type;
31 SUBTYPE cimv_rec_type IS okl_okc_migration_pvt.cimv_rec_type;
32 SUBTYPE cimv_tbl_type IS okl_okc_migration_pvt.cimv_tbl_type;
33 SUBTYPE cplv_rec_type IS okl_okc_migration_pvt.cplv_rec_type;
34 SUBTYPE cplv_tbl_type IS okl_okc_migration_pvt.cplv_tbl_type;
35
36 -----------------------------------------------------------------------------
37 -- PROGRAM UNITS
38 -----------------------------------------------------------------------------
39
40 PROCEDURE create_service_line(p_api_version IN NUMBER,
41 p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE,
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_msg_count OUT NOCOPY NUMBER,
44 x_msg_data OUT NOCOPY VARCHAR2,
45 p_clev_rec IN clev_rec_type,
46 p_klev_rec IN klev_rec_type,
47 p_cimv_rec IN cimv_rec_type,
48 p_cplv_rec IN cplv_rec_type,
49 x_clev_rec OUT NOCOPY clev_rec_type,
50 x_klev_rec OUT NOCOPY klev_rec_type,
51 x_cimv_rec OUT NOCOPY cimv_rec_type,
52 x_cplv_rec OUT NOCOPY cplv_rec_type);
53
54 PROCEDURE create_service_asset(p_api_version IN NUMBER,
55 p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2,
59 p_clev_rec IN clev_rec_type,
60 p_klev_rec IN klev_rec_type,
61 p_cimv_rec IN cimv_rec_type,
62 p_cplv_rec IN cplv_rec_type,
63 p_sub_clev_rec IN clev_rec_type,
64 p_sub_klev_rec IN klev_rec_type,
65 p_sub_cimv_rec IN cimv_rec_type,
66 x_clev_rec OUT NOCOPY clev_rec_type,
67 x_klev_rec OUT NOCOPY klev_rec_type,
68 x_cimv_rec OUT NOCOPY cimv_rec_type,
69 x_cplv_rec OUT NOCOPY cplv_rec_type,
70 x_sub_clev_rec OUT NOCOPY clev_rec_type,
71 x_sub_klev_rec OUT NOCOPY klev_rec_type,
72 x_sub_cimv_rec OUT NOCOPY cimv_rec_type);
73
74 PROCEDURE update_service_line(p_api_version IN NUMBER,
75 p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE,
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_msg_count OUT NOCOPY NUMBER,
78 x_msg_data OUT NOCOPY VARCHAR2,
79 p_clev_rec IN clev_rec_type,
80 p_klev_rec IN klev_rec_type,
81 p_cimv_rec IN cimv_rec_type,
82 p_cplv_rec IN cplv_rec_type,
83 x_clev_rec OUT NOCOPY clev_rec_type,
84 x_klev_rec OUT NOCOPY klev_rec_type,
85 x_cimv_rec OUT NOCOPY cimv_rec_type,
86 x_cplv_rec OUT NOCOPY cplv_rec_type);
87
88 PROCEDURE delete_service_line(p_api_version IN NUMBER,
89 p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2,
93 p_clev_rec IN clev_rec_type,
94 p_klev_rec IN klev_rec_type,
95 p_cimv_rec IN cimv_rec_type,
96 p_cplv_rec IN cplv_rec_type);
97
98 END OKL_SERVICE_LINE_PROCESS_PVT;