[Home] [Help]
PACKAGE: APPS.OKL_CONTRACT_LINE_ITEM_PUB
Source
1 Package okl_contract_line_item_pub AUTHID CURRENT_USER as
2 /* $Header: OKLPCLIS.pls 115.2 2002/12/20 19:08:33 smereddy noship $ */
3
4 subtype klev_rec_type is OKL_CONTRACT_LINE_ITEM_PVT.klev_rec_type;
5 subtype klev_tbl_type is OKL_CONTRACT_LINE_ITEM_PVT.klev_tbl_type;
6 subtype clev_rec_type is OKL_CONTRACT_LINE_ITEM_PVT.clev_rec_type;
7 subtype clev_tbl_type is OKL_CONTRACT_LINE_ITEM_PVT.clev_tbl_type;
8 subtype cimv_rec_type is OKL_CONTRACT_LINE_ITEM_PVT.cimv_rec_type;
9 subtype cimv_tbl_type is OKL_CONTRACT_LINE_ITEM_PVT.cimv_tbl_type;
10
11 subtype line_item_tbl_type is okl_contract_line_item_pvt.line_item_tbl_type;
12
13 -- Global variables for user hooks
14 G_PKG_NAME CONSTANT VARCHAR2(200) := 'okl_contract_line_item_pub';
15 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKL';
16
17 g_klev_rec klev_rec_type;
18 g_klev_tbl klev_tbl_type;
19 g_clev_rec clev_rec_type;
20 g_clev_tbl clev_tbl_type;
21 g_cimv_rec cimv_rec_type;
22 g_cimv_tbl cimv_tbl_type;
23
24 PROCEDURE create_contract_line_item(
25 p_api_version IN NUMBER,
26 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
27 x_return_status OUT NOCOPY VARCHAR2,
28 x_msg_count OUT NOCOPY NUMBER,
29 x_msg_data OUT NOCOPY VARCHAR2,
30 p_line_item_tbl IN line_item_tbl_type,
31 x_line_item_tbl OUT NOCOPY line_item_tbl_type
32 );
33
34 PROCEDURE update_contract_line_item(
35 p_api_version IN NUMBER,
36 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
37 x_return_status OUT NOCOPY VARCHAR2,
38 x_msg_count OUT NOCOPY NUMBER,
39 x_msg_data OUT NOCOPY VARCHAR2,
40 p_line_item_tbl IN line_item_tbl_type,
41 x_line_item_tbl OUT NOCOPY line_item_tbl_type
42 );
43
44 PROCEDURE delete_contract_line_item(
45 p_api_version IN NUMBER,
46 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_msg_count OUT NOCOPY NUMBER,
49 x_msg_data OUT NOCOPY VARCHAR2,
50 p_line_item_tbl IN line_item_tbl_type
51 );
52
53 PROCEDURE create_contract_line_item(
54 p_api_version IN NUMBER,
55 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.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 x_clev_rec OUT NOCOPY clev_rec_type,
63 x_klev_rec OUT NOCOPY klev_rec_type,
64 x_cimv_rec OUT NOCOPY cimv_rec_type);
65
66 PROCEDURE update_contract_line_item(
67 p_api_version IN NUMBER,
68 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
69 x_return_status OUT NOCOPY VARCHAR2,
70 x_msg_count OUT NOCOPY NUMBER,
71 x_msg_data OUT NOCOPY VARCHAR2,
72 p_clev_rec IN clev_rec_type,
73 p_klev_rec IN klev_rec_type,
74 p_cimv_rec IN cimv_rec_type,
75 x_clev_rec OUT NOCOPY clev_rec_type,
76 x_klev_rec OUT NOCOPY klev_rec_type,
77 x_cimv_rec OUT NOCOPY cimv_rec_type);
78
79 PROCEDURE delete_contract_line_item(
80 p_api_version IN NUMBER,
81 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2,
85 p_clev_rec IN clev_rec_type,
86 p_klev_rec IN klev_rec_type,
87 p_cimv_rec IN cimv_rec_type);
88
89 PROCEDURE create_contract_line_item(
90 p_api_version IN NUMBER,
91 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
92 x_return_status OUT NOCOPY VARCHAR2,
93 x_msg_count OUT NOCOPY NUMBER,
94 x_msg_data OUT NOCOPY VARCHAR2,
95 p_clev_tbl IN clev_tbl_type,
96 p_klev_tbl IN klev_tbl_type,
97 p_cimv_tbl IN cimv_tbl_type,
98 x_clev_tbl OUT NOCOPY clev_tbl_type,
99 x_klev_tbl OUT NOCOPY klev_tbl_type,
100 x_cimv_tbl OUT NOCOPY cimv_tbl_type);
101
102 PROCEDURE delete_contract_line_item(
103 p_api_version IN NUMBER,
104 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
105 x_return_status OUT NOCOPY VARCHAR2,
106 x_msg_count OUT NOCOPY NUMBER,
107 x_msg_data OUT NOCOPY VARCHAR2,
108 p_clev_tbl IN clev_tbl_type,
109 p_klev_tbl IN klev_tbl_type,
110 p_cimv_tbl IN cimv_tbl_type);
111
112 PROCEDURE update_contract_line_item(
113 p_api_version IN NUMBER,
114 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_msg_count OUT NOCOPY NUMBER,
117 x_msg_data OUT NOCOPY VARCHAR2,
118 p_clev_tbl IN clev_tbl_type,
119 p_klev_tbl IN klev_tbl_type,
120 p_cimv_tbl IN cimv_tbl_type,
121 x_clev_tbl OUT NOCOPY clev_tbl_type,
122 x_klev_tbl OUT NOCOPY klev_tbl_type,
123 x_cimv_tbl OUT NOCOPY cimv_tbl_type);
124
125 End OKL_CONTRACT_LINE_ITEM_PUB;