[Home] [Help]
PACKAGE: APPS.OKL_POPULATE_PRCENG_RESULT_PVT
Source
1 PACKAGE OKL_POPULATE_PRCENG_RESULT_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRPERS.pls 115.9 2003/05/12 23:40:03 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_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_POPULATE_PRCENG_RESULT_PVT';
12
13 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
14 G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
15 G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
16 G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
17 G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
18 G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
19
20 G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
21 G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
22 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
23 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
24 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
25
26
27 G_EXCEPTION_HALT_PROCESSING EXCEPTION;
28 G_EXCEPTION_ERROR EXCEPTION;
29 G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
30
31 SUBTYPE sirv_rec_type IS okl_sir_pvt.sirv_rec_type;
32 SUBTYPE srsv_rec_type IS okl_srs_pvt.srsv_rec_type;
33 SUBTYPE srsv_tbl_type IS okl_srs_pvt.srsv_tbl_type;
34 G_SRSV_TBL srsv_tbl_type;
35 G_COUNTER NUMBER := 0;
36 SUBTYPE srmv_rec_type IS okl_srm_pvt.srmv_rec_type;
37 SUBTYPE sifv_rec_type IS okl_sif_pvt.sifv_rec_type;
38 SUBTYPE srlv_rec_type IS okl_srl_pvt.okl_sif_ret_levels_v_rec_type;
39
40 PROCEDURE populate_sif_rets (
41 p_api_version IN NUMBER,
42 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 p_sirv_rec IN sirv_rec_type,
47 x_sirv_rec OUT NOCOPY sirv_rec_type);
48
49 PROCEDURE update_sif_rets (
50 p_api_version IN NUMBER,
51 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2,
55 p_sirv_rec IN sirv_rec_type,
56 x_sirv_rec OUT NOCOPY sirv_rec_type);
57
58
59 PROCEDURE populate_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_rec IN srsv_rec_type,
66 x_srsv_rec OUT NOCOPY srsv_rec_type);
67
68 PROCEDURE populate_sif_ret_errors (
69 p_api_version IN NUMBER,
70 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2,
74 p_srmv_rec IN srmv_rec_type,
75 x_srmv_rec OUT NOCOPY srmv_rec_type);
76
77 PROCEDURE populate_sif_ret_levels (
78 p_api_version IN NUMBER,
79 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
80 p_srlv_rec IN srlv_rec_type,
81 x_srlv_rec OUT NOCOPY srlv_rec_type,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2);
85
86
87 PROCEDURE update_outbound_status (
88 p_api_version IN NUMBER,
89 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
90 p_sifv_rec IN sifv_rec_type,
91 x_sifv_rec OUT NOCOPY sifv_rec_type,
92 x_msg_count OUT NOCOPY NUMBER,
93 x_msg_data OUT NOCOPY VARCHAR2,
94 x_return_status OUT NOCOPY VARCHAR2);
95
96 END OKL_POPULATE_PRCENG_RESULT_PVT;