[Home] [Help]
PACKAGE: APPS.OKL_RGRP_RULES_PROCESS_PVT
Source
1 PACKAGE okl_rgrp_rules_process_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLRRGRS.pls 115.8 2002/11/30 08:58:31 spillaip noship $ */
3 /* *************************************** */
4 TYPE rgr_rec_type IS RECORD (
5 rgd_code OKC_RULE_GROUPS_B.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
6 --id NUMBER := OKC_API.G_MISS_NUM,
7 rule_id OKC_RULES_V.ID%TYPE := OKC_API.G_MISS_NUM,
8 object_version_number NUMBER := OKC_API.G_MISS_NUM,
9 sfwt_flag OKC_RULES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
10 object1_id1 OKC_RULES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
11 object2_id1 OKC_RULES_V.OBJECT2_ID1%TYPE := OKC_API.G_MISS_CHAR,
12 object3_id1 OKC_RULES_V.OBJECT3_ID1%TYPE := OKC_API.G_MISS_CHAR,
13 object1_id2 OKC_RULES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
14 object2_id2 OKC_RULES_V.OBJECT2_ID2%TYPE := OKC_API.G_MISS_CHAR,
15 object3_id2 OKC_RULES_V.OBJECT3_ID2%TYPE := OKC_API.G_MISS_CHAR,
16 jtot_object1_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
17 jtot_object2_code OKC_RULES_V.JTOT_OBJECT2_CODE%TYPE := OKC_API.G_MISS_CHAR,
18 jtot_object3_code OKC_RULES_V.JTOT_OBJECT3_CODE%TYPE := OKC_API.G_MISS_CHAR,
19 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
20 rgp_id NUMBER := OKC_API.G_MISS_NUM,
21 priority NUMBER := OKC_API.G_MISS_NUM,
22 std_template_yn OKC_RULES_V.STD_TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
23 comments OKC_RULES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
24 warn_yn OKC_RULES_V.WARN_YN%TYPE := OKC_API.G_MISS_CHAR,
25 attribute_category OKC_RULES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
26 attribute1 OKC_RULES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
27 attribute2 OKC_RULES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
28 attribute3 OKC_RULES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
29 attribute4 OKC_RULES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
30 attribute5 OKC_RULES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
31 attribute6 OKC_RULES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
32 attribute7 OKC_RULES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
33 attribute8 OKC_RULES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
34 attribute9 OKC_RULES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
35 attribute10 OKC_RULES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
36 attribute11 OKC_RULES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
37 attribute12 OKC_RULES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
38 attribute13 OKC_RULES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
39 attribute14 OKC_RULES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
40 attribute15 OKC_RULES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
41 created_by NUMBER := OKC_API.G_MISS_NUM,
42 creation_date OKC_RULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
43 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
44 last_update_date OKC_RULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
45 last_update_login NUMBER := OKC_API.G_MISS_NUM,
46 -- text OKC_RULES_V.TEXT%TYPE := NULL,
47 rule_information_category OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
48 rule_information1 OKC_RULES_V.RULE_INFORMATION1%TYPE := OKC_API.G_MISS_CHAR,
49 rule_information2 OKC_RULES_V.RULE_INFORMATION2%TYPE := OKC_API.G_MISS_CHAR,
50 rule_information3 OKC_RULES_V.RULE_INFORMATION3%TYPE := OKC_API.G_MISS_CHAR,
51 rule_information4 OKC_RULES_V.RULE_INFORMATION4%TYPE := OKC_API.G_MISS_CHAR,
52 rule_information5 OKC_RULES_V.RULE_INFORMATION5%TYPE := OKC_API.G_MISS_CHAR,
53 rule_information6 OKC_RULES_V.RULE_INFORMATION6%TYPE := OKC_API.G_MISS_CHAR,
54 rule_information7 OKC_RULES_V.RULE_INFORMATION7%TYPE := OKC_API.G_MISS_CHAR,
55 rule_information8 OKC_RULES_V.RULE_INFORMATION8%TYPE := OKC_API.G_MISS_CHAR,
56 rule_information9 OKC_RULES_V.RULE_INFORMATION9%TYPE := OKC_API.G_MISS_CHAR,
57 rule_information10 OKC_RULES_V.RULE_INFORMATION10%TYPE := OKC_API.G_MISS_CHAR,
58 rule_information11 OKC_RULES_V.RULE_INFORMATION11%TYPE := OKC_API.G_MISS_CHAR,
59 rule_information12 OKC_RULES_V.RULE_INFORMATION12%TYPE := OKC_API.G_MISS_CHAR,
60 rule_information13 OKC_RULES_V.RULE_INFORMATION13%TYPE := OKC_API.G_MISS_CHAR,
61 rule_information14 OKC_RULES_V.RULE_INFORMATION14%TYPE := OKC_API.G_MISS_CHAR,
62 rule_information15 OKC_RULES_V.RULE_INFORMATION15%TYPE := OKC_API.G_MISS_CHAR,
63 template_yn OKC_RULES_B.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
64 ans_set_jtot_object_code OKC_RULES_B.ans_set_jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
65 ans_set_jtot_object_id1 OKC_RULES_B.ans_set_jtot_object_id1%TYPE := OKC_API.G_MISS_CHAR,
66 ans_set_jtot_object_id2 OKC_RULES_B.ans_set_jtot_object_id2%TYPE := OKC_API.G_MISS_CHAR,
67 display_sequence NUMBER:= OKC_API.G_MISS_NUM);
68
69 TYPE rgr_out_rec_type IS RECORD (
70 id OKC_RULES_V.ID%TYPE := OKC_API.G_MISS_NUM,
71 rule_code OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
72 rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
73 new_yn OKC_RULES_B.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR);
74
75 TYPE rgr_tbl_type IS TABLE OF rgr_rec_type INDEX BY BINARY_INTEGER;
76 TYPE rgr_out_tbl_type IS TABLE OF rgr_out_rec_type INDEX BY BINARY_INTEGER;
77 subtype rgpv_rec_type is OKL_RULE_PUB.rgpv_rec_type;
78 subtype rgpv_tbl_type is OKL_RULE_PUB.rgpv_tbl_type;
79 subtype rulv_rec_type is OKL_RULE_PUB.rulv_rec_type;
80 subtype rulv_tbl_type is OKL_RULE_PUB.rulv_tbl_type;
81 subtype rmpv_rec_type is OKL_RULE_PUB.rmpv_rec_type;
82
83 PROCEDURE process_rule_group_rules(
84 p_api_version IN NUMBER,
85 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2,
89 p_chr_id IN NUMBER,
90 p_line_id IN NUMBER,
91 p_cpl_id IN NUMBER,
92 p_rrd_id IN NUMBER,
93 p_rgr_tbl IN rgr_tbl_type);
94
95 PROCEDURE process_template_rules(
96 p_api_version IN NUMBER,
97 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2,
101 p_id IN NUMBER,
102 p_rgr_tbl IN rgr_tbl_type,
103 x_rgr_tbl OUT NOCOPY rgr_out_tbl_type);
104
105 FUNCTION get_header_rule_group_id(
106 p_api_version IN NUMBER,
107 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2,
111 p_chr_id IN NUMBER,
112 p_rgd_code IN VARCHAR2)
113 RETURN OKC_RULE_GROUPS_B.ID%TYPE;
114 /* *************************************** */
115 END OKL_RGRP_RULES_PROCESS_PVT;