[Home] [Help]
PACKAGE: APPS.OKL_TRNS_ACC_DSTRS_PUB
Source
1 PACKAGE OKL_TRNS_ACC_DSTRS_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPTABS.pls 120.2 2007/02/12 13:35:55 zrehman 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_TRNS_ACC_DSTRS_PUB';
13 -- Added as part of SLA Uptake Bug#5707866 by zrehman on 7-Feb-2006 start
14 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
15 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
16 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
17 -- Added as part of SLA Uptake Bug#5707866 by zrehman on 7-Feb-2006 end
18 ---------------------------------------------------------------------------
19 -- GLOBAL EXCEPTION
20 ---------------------------------------------------------------------------
21 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
22
23 SUBTYPE tabv_rec_type IS okl_tab_pvt.tabv_rec_type;
24 SUBTYPE tabv_tbl_type IS okl_tab_pvt.tabv_tbl_type;
25
26 PROCEDURE add_language;
27
28 PROCEDURE insert_trns_acc_dstrs(
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_tabv_rec IN tabv_rec_type,
35 x_tabv_rec OUT NOCOPY tabv_rec_type);
36
37 PROCEDURE insert_trns_acc_dstrs(
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_tabv_tbl IN tabv_tbl_type,
44 x_tabv_tbl OUT NOCOPY tabv_tbl_type);
45
46 PROCEDURE lock_trns_acc_dstrs(
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_tabv_rec IN tabv_rec_type);
53
54 PROCEDURE lock_trns_acc_dstrs(
55 p_api_version IN NUMBER,
56 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2,
60 p_tabv_tbl IN tabv_tbl_type);
61
62 PROCEDURE update_trns_acc_dstrs(
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_tabv_rec IN tabv_rec_type,
69 x_tabv_rec OUT NOCOPY tabv_rec_type);
70
71 PROCEDURE update_trns_acc_dstrs(
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_tabv_tbl IN tabv_tbl_type,
78 x_tabv_tbl OUT NOCOPY tabv_tbl_type);
79
80 PROCEDURE delete_trns_acc_dstrs(
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_tabv_rec IN tabv_rec_type);
87
88 PROCEDURE delete_trns_acc_dstrs(
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_tabv_tbl IN tabv_tbl_type);
95
96 PROCEDURE validate_trns_acc_dstrs(
97 p_api_version IN NUMBER,
98 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2,
102 p_tabv_rec IN tabv_rec_type);
103
104 PROCEDURE validate_trns_acc_dstrs(
105 p_api_version IN NUMBER,
106 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
107 x_return_status OUT NOCOPY VARCHAR2,
108 x_msg_count OUT NOCOPY NUMBER,
109 x_msg_data OUT NOCOPY VARCHAR2,
110 p_tabv_tbl IN tabv_tbl_type);
111
112 END OKL_TRNS_ACC_DSTRS_PUB;