[Home] [Help]
PACKAGE: APPS.OKS_CONTRACT_SLL_PUB
Source
1 PACKAGE oks_contract_sll_pub AUTHID CURRENT_USER AS
2 /* $Header: OKSPSLLS.pls 120.0 2005/05/25 17:59:18 appldev noship $ */
3 subtype sllv_rec_type is oks_sll_pvt.sllv_rec_type;
4 subtype sllv_tbl_type is oks_sll_pvt.sllv_tbl_type;
5 ---------------------------------------------------------------------------
6 -- GLOBAL VARIABLES
7 ---------------------------------------------------------------------------
8 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_SLL_PUB';
9 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
10 G_RET_STS_SUCCESS CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_SUCCESS;
11 G_RET_STS_ERROR CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_ERROR;
12 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_UNEXP_ERROR;
13 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
14 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
15 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
16 G_FALSE CONSTANT VARCHAR2(10) := OKC_API.G_FALSE;
17 G_TRUE CONSTANT VARCHAR2(10) := OKC_API.G_TRUE;
18 ---------------------------------------------------------------------------
19
20 PROCEDURE create_sll(
21 p_api_version IN NUMBER,
22 p_init_msg_list IN VARCHAR2,
23 x_return_status OUT NOCOPY VARCHAR2,
24 x_msg_count OUT NOCOPY NUMBER,
25 x_msg_data OUT NOCOPY VARCHAR2,
26 p_sllv_rec IN sllv_rec_type,
27 x_sllv_rec OUT NOCOPY sllv_rec_type,
28 p_validate_yn IN VARCHAR2);
29 PROCEDURE create_sll(
30 p_api_version IN NUMBER,
31 p_init_msg_list IN VARCHAR2,
32 x_return_status OUT NOCOPY VARCHAR2,
33 x_msg_count OUT NOCOPY NUMBER,
34 x_msg_data OUT NOCOPY VARCHAR2,
35 p_sllv_tbl IN sllv_tbl_type,
36 x_sllv_tbl OUT NOCOPY sllv_tbl_type,
37 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,
38 p_validate_yn IN VARCHAR2);
39 PROCEDURE create_sll(
40 p_api_version IN NUMBER,
41 p_init_msg_list IN VARCHAR2,
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_msg_count OUT NOCOPY NUMBER,
44 x_msg_data OUT NOCOPY VARCHAR2,
45 p_sllv_tbl IN sllv_tbl_type,
46 x_sllv_tbl OUT NOCOPY sllv_tbl_type,
47 p_validate_yn IN VARCHAR2);
48 PROCEDURE lock_sll(
49 p_api_version IN NUMBER,
50 p_init_msg_list IN VARCHAR2,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2,
54 p_sllv_rec IN sllv_rec_type);
55 PROCEDURE lock_sll(
56 p_api_version IN NUMBER,
57 p_init_msg_list IN VARCHAR2,
58 x_return_status OUT NOCOPY VARCHAR2,
59 x_msg_count OUT NOCOPY NUMBER,
60 x_msg_data OUT NOCOPY VARCHAR2,
61 p_sllv_tbl IN sllv_tbl_type,
62 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
63 PROCEDURE lock_sll(
64 p_api_version IN NUMBER,
65 p_init_msg_list IN VARCHAR2,
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_msg_data OUT NOCOPY VARCHAR2,
69 p_sllv_tbl IN sllv_tbl_type);
70 PROCEDURE update_sll(
71 p_api_version IN NUMBER,
72 p_init_msg_list IN VARCHAR2,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2,
76 p_sllv_rec IN sllv_rec_type,
77 x_sllv_rec OUT NOCOPY sllv_rec_type,
78 p_validate_yn IN VARCHAR2);
79 PROCEDURE update_sll(
80 p_api_version IN NUMBER,
81 p_init_msg_list IN VARCHAR2,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2,
85 p_sllv_tbl IN sllv_tbl_type,
86 x_sllv_tbl OUT NOCOPY sllv_tbl_type,
87 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,
88 p_validate_yn IN VARCHAR2);
89 PROCEDURE update_sll(
90 p_api_version IN NUMBER,
91 p_init_msg_list IN VARCHAR2,
92 x_return_status OUT NOCOPY VARCHAR2,
93 x_msg_count OUT NOCOPY NUMBER,
94 x_msg_data OUT NOCOPY VARCHAR2,
95 p_sllv_tbl IN sllv_tbl_type,
96 x_sllv_tbl OUT NOCOPY sllv_tbl_type,
97 p_validate_yn IN VARCHAR2);
98 PROCEDURE delete_sll(
99 p_api_version IN NUMBER,
100 p_init_msg_list IN VARCHAR2,
101 x_return_status OUT NOCOPY VARCHAR2,
102 x_msg_count OUT NOCOPY NUMBER,
103 x_msg_data OUT NOCOPY VARCHAR2,
104 p_sllv_rec IN sllv_rec_type);
105 PROCEDURE delete_sll(
106 p_api_version IN NUMBER,
107 p_init_msg_list IN VARCHAR2,
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2,
111 p_sllv_tbl IN sllv_tbl_type,
112 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
113 PROCEDURE delete_sll(
114 p_api_version IN NUMBER,
115 p_init_msg_list IN VARCHAR2,
116 x_return_status OUT NOCOPY VARCHAR2,
117 x_msg_count OUT NOCOPY NUMBER,
118 x_msg_data OUT NOCOPY VARCHAR2,
119 p_sllv_tbl IN sllv_tbl_type);
120 PROCEDURE validate_sll(
121 p_api_version IN NUMBER,
122 p_init_msg_list IN VARCHAR2,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER,
125 x_msg_data OUT NOCOPY VARCHAR2,
126 p_sllv_rec IN sllv_rec_type);
127 PROCEDURE validate_sll(
128 p_api_version IN NUMBER,
129 p_init_msg_list IN VARCHAR2,
130 x_return_status OUT NOCOPY VARCHAR2,
131 x_msg_count OUT NOCOPY NUMBER,
132 x_msg_data OUT NOCOPY VARCHAR2,
133 p_sllv_tbl IN sllv_tbl_type,
134 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
135 PROCEDURE validate_sll(
136 p_api_version IN NUMBER,
137 p_init_msg_list IN VARCHAR2,
138 x_return_status OUT NOCOPY VARCHAR2,
139 x_msg_count OUT NOCOPY NUMBER,
140 x_msg_data OUT NOCOPY VARCHAR2,
141 p_sllv_tbl IN sllv_tbl_type);
142
143 PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,
144 p_sllv_tbl IN sllv_tbl_type);
145
146 END oks_contract_sll_pub;
147