[Home] [Help]
PACKAGE: APPS.OKL_SETUP_ACCRUALS_PVT
Source
1 PACKAGE OKL_SETUP_ACCRUALS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRARUS.pls 115.0 2002/02/21 16:02:15 pkm ship $ */
3
4 SUBTYPE agnv_rec_type IS OKL_ACCRUAL_RULES_PUB.agnv_rec_type;
5 SUBTYPE agnv_tbl_type IS OKL_ACCRUAL_RULES_PUB.agnv_tbl_type;
6
7 ---------------------------------------------------------------------------
8 -- GLOBAL VARIABLES
9 ---------------------------------------------------------------------------
10 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
11 G_VERSION_OVERLAPS CONSTANT VARCHAR2(200) := 'OKL_VERSION_OVERLAPS';
12 G_DATES_MISMATCH CONSTANT VARCHAR2(200) := 'OKL_DATES_MISMATCH';
13 G_PAST_RECORDS CONSTANT VARCHAR2(200) := 'OKL_PAST_RECORDS';
14 G_START_DATE CONSTANT VARCHAR2(200) := 'OKL_START_DATE';
15 G_END_DATE CONSTANT VARCHAR2(200) := 'OKL_END_DATE';
16 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
17 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
18 G_TABLE_TOKEN CONSTANT VARCHAR2(100) := 'OKL_TABLE_NAME';
19 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
20 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
21 G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;
22
23 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
24 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUP_ACCRUALS_PVT';
25
26 G_INIT_VERSION CONSTANT NUMBER := 1.0;
27 G_VERSION_MAJOR_INCREMENT CONSTANT NUMBER := 1.0;
28 G_VERSION_MINOR_INCREMENT CONSTANT NUMBER := 0.1;
29 G_VERSION_FORMAT CONSTANT VARCHAR2(100) := 'FM999.0999';
30
31 G_EXCEPTION_HALT_PROCESSING EXCEPTION;
32 G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
33 G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
34 G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
35
36 PROCEDURE create_accrual_rules(
37 p_api_version IN NUMBER,
38 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
39 x_return_status OUT NOCOPY VARCHAR2,
40 x_msg_count OUT NOCOPY NUMBER,
41 x_msg_data OUT NOCOPY VARCHAR2,
42 p_agnv_rec IN agnv_rec_type,
43 x_agnv_rec OUT NOCOPY agnv_rec_type);
44
45 PROCEDURE create_accrual_rules(
46 p_api_version IN NUMBER,
47 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2,
51 p_agnv_tbl IN agnv_tbl_type,
52 x_agnv_tbl OUT NOCOPY agnv_tbl_type);
53
54
55 PROCEDURE update_accrual_rules(
56 p_api_version IN NUMBER,
57 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_agnv_rec IN agnv_rec_type,
62 x_agnv_rec OUT NOCOPY agnv_rec_type);
63
64 PROCEDURE update_accrual_rules(
65 p_api_version IN NUMBER,
66 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_agnv_tbl IN agnv_tbl_type,
71 x_agnv_tbl OUT NOCOPY agnv_tbl_type);
72
73 PROCEDURE delete_accrual_rules(
74 p_api_version IN NUMBER,
75 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_agnv_rec IN agnv_rec_type);
80
81 PROCEDURE delete_accrual_rules(
82 p_api_version IN NUMBER,
83 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_msg_count OUT NOCOPY NUMBER,
86 x_msg_data OUT NOCOPY VARCHAR2,
87 p_agnv_tbl IN agnv_tbl_type);
88
89
90 END OKL_SETUP_ACCRUALS_PVT;