[Home] [Help]
PACKAGE: APPS.OKL_SETUP_DISB_RULES_PVT
Source
1 PACKAGE OKL_SETUP_DISB_RULES_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRSDRS.pls 120.2 2007/06/25 13:29:58 gkhuntet noship $ */
3
4 -------------------------------------------------------------------------------
5 -- Global Variables
6 -------------------------------------------------------------------------------
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUP_DISB_RULES_PVT';
8 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
9 G_VALUE CONSTANT VARCHAR2(5) := 'VALUE';
10
11 -- Messages
12 G_OKL_ST_DISB_NAME_EXIST CONSTANT VARCHAR2(30) := 'OKL_ST_DISB_NAME_EXIST';
13 G_OKL_ST_DISB_RUL_STY_MISSING CONSTANT VARCHAR2(30) := 'OKL_ST_DISB_RUL_STY_MISSING';
14 G_OKL_ST_DISB_FEE_OPTION_REQ CONSTANT VARCHAR2(30) := 'OKL_ST_DISB_FEE_OPTION_REQ';
15 G_OKL_ST_DISB_FEE_AMNT_REQ CONSTANT VARCHAR2(30) := 'OKL_ST_DISB_FEE_AMNT_REQ';
16 G_OKL_ST_DISB_FEE_PERCENT_REQ CONSTANT VARCHAR2(30) := 'OKL_ST_DISB_FEE_PERCENT_REQ';
17 G_OKL_ST_DISB_FEE_PERCENT_ERR CONSTANT VARCHAR2(30) := 'OKL_ST_DISB_FEE_PERCENT_ERR';
18 G_OKL_ST_DISB_FREQ_REQ CONSTANT VARCHAR2(30) := 'OKL_ST_DISB_FREQ_REQ';
19 G_OKL_ST_DISB_DAY_MON_REQ CONSTANT VARCHAR2(30) := 'OKL_ST_DISB_DAY_MON_REQ';
20 G_OKL_ST_DISB_SCHED_MON_REQ CONSTANT VARCHAR2(30) := 'OKL_ST_DISB_SCHED_MON_REQ';
21 G_OKL_ST_DISB_SEQ_RANGE_ERR CONSTANT VARCHAR2(30) := 'OKL_ST_DISB_SEQ_RANGE_ERR';
22 G_OKL_ST_DISB_SEQ_OVERLAP CONSTANT VARCHAR2(30) := 'OKL_ST_DISB_SEQ_OVERLAP';
23 G_OKL_ST_DISB_EFF_DATE_ERR CONSTANT VARCHAR2(30) := 'OKL_ST_DISB_EFF_DATE_ERR';
24 G_OKL_ST_DISB_VSITE_DATE_ERR CONSTANT VARCHAR2(30) := 'OKL_ST_DISB_VSITE_DATE_ERR';
25 G_OKL_ST_START_SEQ_NO_REQ CONSTANT VARCHAR2(30) := 'OKL_ST_START_SEQ_NO_REQ';
26 G_OKL_ST_END_SEQ_NO_LESS CONSTANT VARCHAR2(30) := 'OKL_ST_END_SEQ_NO_LESS';
27 G_OKL_ST_START_SEQ_LOCK CONSTANT VARCHAR2(30) := 'OKL_ST_START_SEQ_LOCK';
28
29 SUBTYPE drav_rec_type IS okl_dra_pvt.drav_rec_type;
30 SUBTYPE drs_tbl_type IS okl_drs_pvt.drs_tbl_type;
31 SUBTYPE drs_rec_type IS okl_drs_pvt.drs_rec_type;
32 SUBTYPE drv_tbl_type IS okl_drv_pvt.drv_tbl_type;
33 SUBTYPE drv_rec_type IS okl_drv_pvt.drv_rec_type;
34
35 PROCEDURE create_disbursement_rule( p_api_version IN NUMBER
36 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
37 , x_return_status OUT NOCOPY VARCHAR2
38 , x_msg_count OUT NOCOPY NUMBER
39 , x_msg_data OUT NOCOPY VARCHAR2
40 , p_drav_rec IN drav_rec_type
41 , p_drs_tbl IN drs_tbl_type
42 , p_drv_tbl IN drv_tbl_type
43 , x_drav_rec OUT NOCOPY drav_rec_type
44 );
45
46 PROCEDURE update_disbursement_rule( p_api_version IN NUMBER
47 , p_init_msg_list IN VARCHAR2 DEFAULT FND_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_drav_rec IN drav_rec_type
52 , p_drs_tbl IN drs_tbl_type
53 , p_drv_tbl IN drv_tbl_type
54 , x_drav_rec OUT NOCOPY drav_rec_type
55 );
56
57 PROCEDURE validate_disbursement_rule( p_api_version IN NUMBER
58 , p_init_msg_list IN VARCHAR2 DEFAULT FND_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_drav_rec IN drav_rec_type
63 , p_drs_tbl IN drs_tbl_type
64 , p_drv_tbl IN drv_tbl_type
65 );
66
67 PROCEDURE create_v_disbursement_rule( p_api_version IN NUMBER
68 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
69 , x_return_status OUT NOCOPY VARCHAR2
70 , x_msg_count OUT NOCOPY NUMBER
71 , x_msg_data OUT NOCOPY VARCHAR2
72 , p_drv_tbl IN drv_tbl_type
73 , x_drv_tbl OUT NOCOPY drv_tbl_type
74 );
75
76
77 END OKL_SETUP_DISB_RULES_PVT;