[Home] [Help]
PACKAGE: APPS.OKL_SIF_RET_STRMS_PUB
Source
1 PACKAGE OKL_SIF_RET_STRMS_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPSRSS.pls 115.3 2003/05/12 23:39:48 bakuchib noship $ */
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_STRMS_PUB';
13
14 SUBTYPE srsv_rec_type IS okl_srs_pvt.srsv_rec_type;
15 SUBTYPE srsv_tbl_type IS okl_srs_pvt.srsv_tbl_type;
16
17 PROCEDURE add_language;
18
19 PROCEDURE insert_sif_ret_strms(
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_srsv_rec IN srsv_rec_type,
26 x_srsv_rec OUT NOCOPY srsv_rec_type);
27
28
29 --BAKUCHIB Bug#2807737 start
30 PROCEDURE insert_sif_ret_strms_per(
31 p_api_version IN NUMBER,
32 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
33 x_return_status OUT NOCOPY VARCHAR2,
34 x_msg_count OUT NOCOPY NUMBER,
35 x_msg_data OUT NOCOPY VARCHAR2,
36 p_srsv_rec IN srsv_rec_type,
37 x_srsv_rec OUT NOCOPY srsv_rec_type);
38
39 PROCEDURE mass_insert_sif_ret(p_srsv_tbl IN srsv_tbl_type);
40 --BAKUCHIB Bug#2807737 End
41
42 PROCEDURE insert_sif_ret_strms(
43 p_api_version IN NUMBER,
44 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2,
48 p_srsv_tbl IN srsv_tbl_type,
49 x_srsv_tbl OUT NOCOPY srsv_tbl_type);
50
51 PROCEDURE lock_sif_ret_strms(
52 p_api_version IN NUMBER,
53 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
54 x_return_status OUT NOCOPY VARCHAR2,
55 x_msg_count OUT NOCOPY NUMBER,
56 x_msg_data OUT NOCOPY VARCHAR2,
57 p_srsv_rec IN srsv_rec_type);
58
59 PROCEDURE lock_sif_ret_strms(
60 p_api_version IN NUMBER,
61 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2,
65 p_srsv_tbl IN srsv_tbl_type);
66
67 PROCEDURE update_sif_ret_strms(
68 p_api_version IN NUMBER,
69 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2,
73 p_srsv_rec IN srsv_rec_type,
74 x_srsv_rec OUT NOCOPY srsv_rec_type);
75
76 PROCEDURE update_sif_ret_strms(
77 p_api_version IN NUMBER,
78 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
79 x_return_status OUT NOCOPY VARCHAR2,
80 x_msg_count OUT NOCOPY NUMBER,
81 x_msg_data OUT NOCOPY VARCHAR2,
82 p_srsv_tbl IN srsv_tbl_type,
83 x_srsv_tbl OUT NOCOPY srsv_tbl_type);
84
85 PROCEDURE delete_sif_ret_strms(
86 p_api_version IN NUMBER,
87 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2,
91 p_srsv_rec IN srsv_rec_type,
92 x_srsv_rec OUT NOCOPY srsv_rec_type);
93
94 PROCEDURE delete_sif_ret_strms(
95 p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 p_srsv_tbl IN srsv_tbl_type,
101 x_srsv_tbl OUT NOCOPY srsv_tbl_type);
102
103 PROCEDURE validate_sif_ret_strms(
104 p_api_version IN NUMBER,
105 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2,
109 p_srsv_rec IN srsv_rec_type,
110 x_srsv_rec OUT NOCOPY srsv_rec_type);
111
112 PROCEDURE validate_sif_ret_strms(
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_srsv_tbl IN srsv_tbl_type,
119 x_srsv_tbl OUT NOCOPY srsv_tbl_type);
120
121 END OKL_SIF_RET_STRMS_PUB;