[Home] [Help]
PACKAGE: APPS.OKL_VP_RULE_PVT
Source
1 PACKAGE OKL_VP_RULE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRRLGS.pls 120.4 2005/10/23 23:41:35 smereddy noship $ */
3 -- simple entity object subtype definitions
4
5 SUBTYPE rgpv_rec_type IS OKL_OKC_MIGRATION_A_PVT.rgpv_rec_type;
6 SUBTYPE rgpv_tbl_type IS OKL_OKC_MIGRATION_A_PVT.rgpv_tbl_type;
7
8 TYPE vrs_rec_type IS RECORD (
9 rul_id NUMBER := OKC_API.G_MISS_NUM,
10 rgd_code OKC_RULE_GROUPS_B.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
11 rul_code OKC_RULES_B.rule_information_category%TYPE := OKC_API.G_MISS_CHAR,
12 rule_info1 OKC_RULES_B.RULE_INFORMATION1%TYPE := OKC_API.G_MISS_CHAR,
13 rule_info2 OKC_RULES_B.RULE_INFORMATION2%TYPE := OKC_API.G_MISS_CHAR,
14 rle_code OKC_K_PARTY_ROLES_B.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR);
15
16 TYPE vrs_tbl_type IS TABLE OF vrs_rec_type
17 INDEX BY BINARY_INTEGER;
18
19
20 ---------------------------------------------------------------------------
21 -- GLOBAL MESSAGE CONSTANTS
22 ---------------------------------------------------------------------------
23 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
24 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
25 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
26 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
27 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
28 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
29 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
30 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
31 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
32 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
33 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
34 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
35 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
36 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPERCASE_REQUIRED';
37 ------------------------------------------------------------------------------------
38 -- GLOBAL EXCEPTION
39 ---------------------------------------------------------------------------
40 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
41 -- GLOBAL VARIABLES
42 ---------------------------------------------------------------------------
43 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_VP_RULE_PVT';
44 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
45 ---------------------------------------------------------------------------
46
47 PROCEDURE create_rule_group(
48 p_api_version IN NUMBER,
49 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
50 x_return_status OUT NOCOPY VARCHAR2,
51 x_msg_count OUT NOCOPY NUMBER,
52 x_msg_data OUT NOCOPY VARCHAR2,
53 p_rgpv_rec IN rgpv_rec_type,
54 x_rgpv_rec OUT NOCOPY rgpv_rec_type);
55
56 PROCEDURE update_rule_group(
57 p_api_version IN NUMBER,
58 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_rgpv_rec IN rgpv_rec_type,
63 x_rgpv_rec OUT NOCOPY rgpv_rec_type);
64
65 PROCEDURE delete_rule_group(
66 p_api_version IN NUMBER,
67 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_msg_count OUT NOCOPY NUMBER,
70 x_msg_data OUT NOCOPY VARCHAR2,
71 p_rgpv_rec IN rgpv_rec_type);
72
73 PROCEDURE delete_vrs_rule(
74 p_api_version IN NUMBER,
75 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_chr_id IN NUMBER,
80 p_rul_id IN NUMBER);
81
82 PROCEDURE process_vrs_rules(
83 p_api_version IN NUMBER,
84 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2,
88 p_chr_id IN NUMBER,
89 p_rgp_id IN NUMBER,
90 p_vrs_tbl IN vrs_tbl_type);
91
92 PROCEDURE validate_vrs_percent(
93 p_api_version IN NUMBER,
94 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2,
98 p_chr_id IN NUMBER);
99
100 END OKL_VP_RULE_PVT;