[Home] [Help]
PACKAGE: APPS.OKS_REV_DISTR_PUB
Source
1 Package OKS_REV_DISTR_PUB AUTHID CURRENT_USER as
2 /* $Header: OKSPRDSS.pls 120.1 2005/10/03 07:51:52 upillai noship $ */
3
4 subtype rdsv_rec_type is oks_rev_distr_pvt.rdsv_rec_type;
5 subtype rdsv_tbl_type is oks_rev_distr_pvt.rdsv_tbl_type;
6
7 ---------------------------------------------------------------------------
8 -- Procedures and Functions
9 ---------------------------------------------------------------------------
10
11
12 PROCEDURE insert_Revenue_Distr(
13 p_api_version IN NUMBER,
14 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
15 x_return_status OUT NOCOPY VARCHAR2,
16 x_msg_count OUT NOCOPY NUMBER,
17 x_msg_data OUT NOCOPY VARCHAR2,
18 p_rdsv_rec IN rdsv_rec_type,
19 x_rdsv_rec OUT NOCOPY rdsv_rec_type);
20
21 PROCEDURE insert_Revenue_Distr(
22 p_api_version IN NUMBER,
23 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
24 x_return_status OUT NOCOPY VARCHAR2,
25 x_msg_count OUT NOCOPY NUMBER,
26 x_msg_data OUT NOCOPY VARCHAR2,
27 p_rdsv_tbl IN rdsv_tbl_type,
28 x_rdsv_tbl OUT NOCOPY rdsv_tbl_type);
29
30 PROCEDURE lock_Revenue_Distr(
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_rdsv_rec IN rdsv_rec_type);
37
38 PROCEDURE lock_Revenue_Distr(
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_rdsv_tbl IN rdsv_tbl_type);
45
46 PROCEDURE update_Revenue_Distr(
47 p_api_version IN NUMBER,
48 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2,
52 p_rdsv_rec IN rdsv_rec_type,
53 x_rdsv_rec OUT NOCOPY rdsv_rec_type);
54
55 PROCEDURE update_Revenue_Distr(
56 p_api_version IN NUMBER,
57 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
58 x_return_status OUT NOCOPY VARCHAR2,
59 x_msg_count OUT NOCOPY NUMBER,
60 x_msg_data OUT NOCOPY VARCHAR2,
61 p_rdsv_tbl IN rdsv_tbl_type,
62 x_rdsv_tbl OUT NOCOPY rdsv_tbl_type);
63
64 PROCEDURE delete_Revenue_Distr(
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_rdsv_rec IN rdsv_rec_type);
71
72 PROCEDURE delete_Revenue_Distr(
73 p_api_version IN NUMBER,
74 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
75 x_return_status OUT NOCOPY VARCHAR2,
76 x_msg_count OUT NOCOPY NUMBER,
77 x_msg_data OUT NOCOPY VARCHAR2,
78 p_rdsv_tbl IN rdsv_tbl_type);
79
80 PROCEDURE validate_Revenue_Distr(
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_rdsv_rec IN rdsv_rec_type);
87
88 PROCEDURE validate_Revenue_Distr(
89 p_api_version IN NUMBER,
90 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
91 x_return_status OUT NOCOPY VARCHAR2,
92 x_msg_count OUT NOCOPY NUMBER,
93 x_msg_data OUT NOCOPY VARCHAR2,
94 p_rdsv_tbl IN rdsv_tbl_type);
95
96 FUNCTION GET_GL_CODE_COMBINATION ( P_Id IN Varchar2,
97 P_Org_Id IN Number,
98 x_return_status OUT NOCOPY Varchar2 ) RETURN Varchar2;
99
100
101 END OKS_REV_DISTR_PUB ;