[Home] [Help]
PACKAGE: APPS.OKL_ACCT_SOURCES_PVT
Source
1 Package OKL_ACCT_SOURCES_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRASES.pls 120.2 2005/10/14 11:28:26 gboomina 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_ACCT_SOURCES_PVT';
13
14 SUBTYPE asev_rec_type IS Okl_Ase_Pvt.asev_rec_type;
15 SUBTYPE asev_tbl_type IS Okl_Ase_Pvt.asev_tbl_type;
16
17 PROCEDURE insert_acct_sources(
18 p_api_version IN NUMBER,
19 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
20 x_return_status OUT NOCOPY VARCHAR2,
21 x_msg_count OUT NOCOPY NUMBER,
22 x_msg_data OUT NOCOPY VARCHAR2,
23 p_asev_rec IN asev_rec_type,
24 x_asev_rec OUT NOCOPY asev_rec_type);
25
26 PROCEDURE insert_acct_sources(
27 p_api_version IN NUMBER,
28 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
29 x_return_status OUT NOCOPY VARCHAR2,
30 x_msg_count OUT NOCOPY NUMBER,
31 x_msg_data OUT NOCOPY VARCHAR2,
32 p_asev_tbl IN asev_tbl_type,
33 x_asev_tbl OUT NOCOPY asev_tbl_type);
34
35 --Added by gboomina on 14-Oct-2005 for Accruals Performance Improvement
36 --Bug 4662173 - Start of Changes
37
38 PROCEDURE insert_acct_sources_bulk(
39 p_api_version IN NUMBER,
40 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
41 x_return_status OUT NOCOPY VARCHAR2,
42 x_msg_count OUT NOCOPY NUMBER,
43 x_msg_data OUT NOCOPY VARCHAR2,
44 p_asev_tbl IN asev_tbl_type,
45 x_asev_tbl OUT NOCOPY asev_tbl_type);
46 --Bug 4662173 - End of Changes
47
48 PROCEDURE lock_acct_sources(
49 p_api_version IN NUMBER,
50 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2,
54 p_asev_rec IN asev_rec_type);
55
56 PROCEDURE lock_acct_sources(
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_asev_tbl IN asev_tbl_type);
63
64 PROCEDURE update_acct_sources(
65 p_api_version IN NUMBER,
66 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
67 x_return_status OUT NOCOPY VARCHAR2,
68 x_msg_count OUT NOCOPY NUMBER,
69 x_msg_data OUT NOCOPY VARCHAR2,
70 p_asev_rec IN asev_rec_type,
71 x_asev_rec OUT NOCOPY asev_rec_type);
72
73 PROCEDURE update_acct_sources(
74 p_api_version IN NUMBER,
75 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_msg_count OUT NOCOPY NUMBER,
78 x_msg_data OUT NOCOPY VARCHAR2,
79 p_asev_tbl IN asev_tbl_type,
80 x_asev_tbl OUT NOCOPY asev_tbl_type);
81
82 PROCEDURE delete_acct_sources(
83 p_api_version IN NUMBER,
84 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2,
88 p_asev_rec IN asev_rec_type);
89
90 PROCEDURE delete_acct_sources(
91 p_api_version IN NUMBER,
92 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
93 x_return_status OUT NOCOPY VARCHAR2,
94 x_msg_count OUT NOCOPY NUMBER,
95 x_msg_data OUT NOCOPY VARCHAR2,
96 p_asev_tbl IN asev_tbl_type);
97
98 PROCEDURE validate_acct_sources(
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_asev_rec IN asev_rec_type);
105
106 PROCEDURE validate_acct_sources(
107 p_api_version IN NUMBER,
108 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
109 x_return_status OUT NOCOPY VARCHAR2,
110 x_msg_count OUT NOCOPY NUMBER,
111 x_msg_data OUT NOCOPY VARCHAR2,
112 p_asev_tbl IN asev_tbl_type);
113
114 PROCEDURE update_acct_src_custom_status(
115 p_api_version IN NUMBER,
116 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_msg_count OUT NOCOPY NUMBER,
119 x_msg_data OUT NOCOPY VARCHAR2,
120 p_asev_rec IN asev_rec_type,
121 x_asev_rec OUT NOCOPY asev_rec_type);
122
123 END OKL_ACCT_SOURCES_PVT;