[Home] [Help]
PACKAGE: APPS.OKL_SIF_RET_LEVELS_PUB
Source
1 PACKAGE OKL_SIF_RET_LEVELS_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPSRLS.pls 115.2 2002/06/14 17:01:02 pkm ship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL VARIABLES
6 ---------------------------------------------------------------------------
7 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
8 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
9 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
10
11 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
12 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SIF_RET_LEVELS_PUB';
13
14 SUBTYPE srlv_rec_type IS Okl_srl_Pvt.okl_sif_ret_levels_v_rec_type;
15 SUBTYPE srlv_tbl_type IS Okl_srl_Pvt.okl_sif_ret_levels_v_tbl_type;
16
17 PROCEDURE add_language;
18
19 PROCEDURE insert_sif_ret_levels(
20 p_api_version IN NUMBER,
21 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
22 x_return_status OUT NOCOPY VARCHAR2,
23 x_msg_count OUT NOCOPY NUMBER,
24 x_msg_data OUT NOCOPY VARCHAR2,
25 p_srlv_rec IN srlv_rec_type,
26 x_srlv_rec OUT NOCOPY srlv_rec_type);
27
28 PROCEDURE insert_sif_ret_levels(
29 p_api_version IN NUMBER,
30 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
31 x_return_status OUT NOCOPY VARCHAR2,
32 x_msg_count OUT NOCOPY NUMBER,
33 x_msg_data OUT NOCOPY VARCHAR2,
34 p_srlv_tbl IN srlv_tbl_type,
35 x_srlv_tbl OUT NOCOPY srlv_tbl_type);
36
37 PROCEDURE lock_sif_ret_levels(
38 p_api_version IN NUMBER,
39 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2,
43 p_srlv_rec IN srlv_rec_type);
44
45 PROCEDURE lock_sif_ret_levels(
46 p_api_version IN NUMBER,
47 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2,
51 p_srlv_tbl IN srlv_tbl_type);
52
53 PROCEDURE update_sif_ret_levels(
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_srlv_rec IN srlv_rec_type,
60 x_srlv_rec OUT NOCOPY srlv_rec_type);
61
62 PROCEDURE update_sif_ret_levels(
63 p_api_version IN NUMBER,
64 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2,
68 p_srlv_tbl IN srlv_tbl_type,
69 x_srlv_tbl OUT NOCOPY srlv_tbl_type);
70
71 PROCEDURE delete_sif_ret_levels(
72 p_api_version IN NUMBER,
73 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2,
77 p_srlv_rec IN srlv_rec_type,
78 x_srlv_rec OUT NOCOPY srlv_rec_type);
79
80 PROCEDURE delete_sif_ret_levels(
81 p_api_version IN NUMBER,
82 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2,
86 p_srlv_tbl IN srlv_tbl_type,
87 x_srlv_tbl OUT NOCOPY srlv_tbl_type);
88
89 PROCEDURE validate_sif_ret_levels(
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_srlv_rec IN srlv_rec_type,
96 x_srlv_rec OUT NOCOPY srlv_rec_type);
97
98 PROCEDURE validate_sif_ret_levels(
99 p_api_version IN NUMBER,
100 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
101 x_return_status OUT NOCOPY VARCHAR2,
102 x_msg_count OUT NOCOPY NUMBER,
103 x_msg_data OUT NOCOPY VARCHAR2,
104 p_srlv_tbl IN srlv_tbl_type,
105 x_srlv_tbl OUT NOCOPY srlv_tbl_type);
106
107 END OKL_SIF_RET_LEVELS_PUB;