[Home] [Help]
PACKAGE: APPS.OKL_CONTRACT_LINE_ITEM_PVT
Source
1 PACKAGE okl_contract_line_item_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLRCLIS.pls 115.4 2003/09/23 14:20:31 kthiruva noship $ */
3
4 subtype klev_rec_type is okl_kle_pvt.klev_rec_type;
5 subtype klev_tbl_type is okl_kle_pvt.klev_tbl_type;
6 subtype clev_rec_type is okl_okc_migration_pvt.clev_rec_type;
7 subtype clev_tbl_type is okl_okc_migration_pvt.clev_tbl_type;
8 subtype cimv_rec_type is okl_okc_migration_pvt.cimv_rec_type;
9 subtype cimv_tbl_type is okl_okc_migration_pvt.cimv_tbl_type;
10
11 TYPE link_ast_rec_type is record (id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR,
12 id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR,
13 name VARCHAR2(250) := OKL_API.G_MISS_CHAR,
14 object_code VARCHAR2(30) := OKL_API.G_MISS_CHAR);
15 TYPE link_ast_tbl_type is table of link_ast_rec_type INDEX BY BINARY_INTEGER;
16
17 G_PKG_NAME CONSTANT VARCHAR2(200) := 'okl_contract_line_item_pvt';
18 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKL';
19
20 TYPE line_item_rec_type is record (
21 chr_id okl_k_lines_full_v.id%type,
22 parent_cle_id okl_k_lines_full_v.id%type,
23 cle_id okl_k_lines_full_v.id%type,
24 item_id okc_k_items_v.id%type,
25 item_id1 okc_k_items_v.object1_id1%type,
26 item_id2 okc_k_items_v.object1_id2%type,
27 item_object1_code okc_k_items_v.jtot_object1_code%type,
28 item_description okc_k_lines_tl.item_description%type,
29 name okc_k_lines_tl.name%type,
30 capital_amount okl_k_lines_full_v.capital_amount%type,
31 serv_cov_prd_id okl_k_lines.id%type
32 );
33 TYPE line_item_tbl_type is table of line_item_rec_type INDEX BY BINARY_INTEGER;
34
35 PROCEDURE create_contract_line_item(
36 p_api_version IN NUMBER,
37 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
38 x_return_status OUT NOCOPY VARCHAR2,
39 x_msg_count OUT NOCOPY NUMBER,
40 x_msg_data OUT NOCOPY VARCHAR2,
41 p_line_item_tbl IN line_item_tbl_type,
42 x_line_item_tbl OUT NOCOPY line_item_tbl_type
43 );
44
45
46 PROCEDURE update_contract_line_item(
47 p_api_version IN NUMBER,
48 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2,
52 p_line_item_tbl IN line_item_tbl_type,
53 x_line_item_tbl OUT NOCOPY line_item_tbl_type
54 );
55
56 PROCEDURE delete_contract_line_item(
57 p_api_version IN NUMBER,
58 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_msg_count OUT NOCOPY NUMBER,
61 x_msg_data OUT NOCOPY VARCHAR2,
62 p_line_item_tbl IN line_item_tbl_type
63 );
64
65
66 PROCEDURE create_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 update_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 x_clev_rec OUT NOCOPY clev_rec_type,
89 x_klev_rec OUT NOCOPY klev_rec_type,
90 x_cimv_rec OUT NOCOPY cimv_rec_type);
91
92 PROCEDURE delete_contract_line_item(
93 p_api_version IN NUMBER,
94 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2,
98 p_clev_rec IN clev_rec_type,
99 p_klev_rec IN klev_rec_type,
100 p_cimv_rec IN cimv_rec_type);
101
102 PROCEDURE create_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 x_clev_tbl OUT NOCOPY clev_tbl_type,
112 x_klev_tbl OUT NOCOPY klev_tbl_type,
113 x_cimv_tbl OUT NOCOPY cimv_tbl_type);
114
115 PROCEDURE update_contract_line_item(
116 p_api_version IN NUMBER,
117 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2,
121 p_clev_tbl IN clev_tbl_type,
122 p_klev_tbl IN klev_tbl_type,
123 p_cimv_tbl IN cimv_tbl_type,
124 x_clev_tbl OUT NOCOPY clev_tbl_type,
125 x_klev_tbl OUT NOCOPY klev_tbl_type,
126 x_cimv_tbl OUT NOCOPY cimv_tbl_type);
127
128 PROCEDURE delete_contract_line_item(
129 p_api_version IN NUMBER,
130 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
131 x_return_status OUT NOCOPY VARCHAR2,
132 x_msg_count OUT NOCOPY NUMBER,
133 x_msg_data OUT NOCOPY VARCHAR2,
134 p_clev_tbl IN clev_tbl_type,
135 p_klev_tbl IN klev_tbl_type,
136 p_cimv_tbl IN cimv_tbl_type);
137
138 END OKL_CONTRACT_LINE_ITEM_PVT;