[Home] [Help]
PACKAGE: APPS.OKL_INTEREST_MAINT_PVT
Source
1 PACKAGE OKL_INTEREST_MAINT_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRINMS.pls 115.2 2002/03/01 16:06:03 pkm ship $ */
3
4
5 SUBTYPE ivev_rec_type IS OKL_INDICES_PUB.ivev_rec_type;
6 SUBTYPE ivev_tbl_type IS OKL_INDICES_PUB.ivev_tbl_type;
7
8 SUBTYPE idxv_rec_type IS OKL_INDICES_PUB.idxv_rec_type;
9 SUBTYPE idxv_tbl_type IS OKL_INDICES_PUB.idxv_tbl_type;
10
11
12 FUNCTION OVERLAP_EXISTS (p_idx_type IN VARCHAR2,
13 p_idx_name IN VARCHAR2,
14 p_datetime_valid IN DATE,
15 p_datetime_invalid IN DATE)
16 RETURN VARCHAR2;
17
18
19 FUNCTION OVERLAP_EXISTS (p_idx_id IN NUMBER,
20 p_datetime_valid IN DATE,
21 p_datetime_invalid IN DATE)
22 RETURN VARCHAR2;
23
24
25
26 PROCEDURE INT_HDR_INS_UPDT(p_api_version IN NUMBER,
27 p_init_msg_list IN VARCHAR2,
28 x_return_status OUT NOCOPY VARCHAR2,
29 x_msg_count OUT NOCOPY NUMBER,
30 x_msg_data OUT NOCOPY VARCHAR2,
31 p_idxv_rec IN idxv_rec_type);
32
33
34 PROCEDURE INT_HDR_INS_UPDT(p_api_version IN NUMBER,
35 p_init_msg_list IN VARCHAR2,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2,
39 p_idxv_tbl IN idxv_tbl_type);
40
41
42 PROCEDURE INT_DTL_INS_UPDT(p_api_version IN NUMBER,
43 p_init_msg_list IN VARCHAR2,
44 x_return_status OUT NOCOPY VARCHAR2,
45 x_msg_count OUT NOCOPY NUMBER,
46 x_msg_data OUT NOCOPY VARCHAR2,
47 p_ivev_rec IN ivev_rec_type);
48
49
50 PROCEDURE INT_DTL_INS_UPDT(p_api_version IN NUMBER,
51 p_init_msg_list IN VARCHAR2,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2,
55 p_ivev_tbl IN ivev_tbl_type);
56
57
58
59 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_INTEREST_MAINT_PVT' ;
60 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
61
62 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
63 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
64 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
65 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
66 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
67 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKL_UPPER_CASE_REQUIRED';
68 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
69
70 END;