DBA Data[Home] [Help]

PACKAGE: APPS.OKL_RULE_EXTRACT_PUB_W

Source


1 package okl_rule_extract_pub_w AUTHID CURRENT_USER as
2   /* $Header: OKLUREXS.pls 115.7 2003/10/14 18:36:04 ashariff noship $ */
3   procedure get_subclass_rgs(p_api_version  NUMBER
4     , p_init_msg_list  VARCHAR2
5     , x_return_status out nocopy  VARCHAR2
6     , x_msg_count out nocopy  NUMBER
7     , x_msg_data out nocopy  VARCHAR2
8     , p_chr_id  VARCHAR2
9     , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
10     , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
11     , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
12     , p6_a3 out nocopy JTF_VARCHAR2_TABLE_300
13   );
14   procedure get_rg_rules(p_api_version  NUMBER
15     , p_init_msg_list  VARCHAR2
16     , x_return_status out nocopy  VARCHAR2
17     , x_msg_count out nocopy  NUMBER
18     , x_msg_data out nocopy  VARCHAR2
19     , p_rgd_code  VARCHAR2
20     , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
21     , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
22     , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
23     , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
24     , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
25     , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
26     , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
27   );
28   procedure get_rule_def(p_api_version  NUMBER
29     , p_init_msg_list  VARCHAR2
30     , x_return_status out nocopy  VARCHAR2
31     , x_msg_count out nocopy  NUMBER
32     , x_msg_data out nocopy  VARCHAR2
33     , p_rgd_code  VARCHAR2
34     , p_rgs_code  VARCHAR2
35     , p_buy_or_sell  VARCHAR2
36     , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
37     , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
38     , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
39     , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
40     , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
41     , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
42     , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
43     , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
44     , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
45     , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
46     , p8_a10 out nocopy JTF_VARCHAR2_TABLE_2000
47     , p8_a11 out nocopy JTF_VARCHAR2_TABLE_2000
48     , p8_a12 out nocopy JTF_VARCHAR2_TABLE_2000
49     , p8_a13 out nocopy JTF_VARCHAR2_TABLE_2000
50     , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100
51     , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
52     , p8_a16 out nocopy JTF_VARCHAR2_TABLE_100
53     , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100
54     , p8_a18 out nocopy JTF_VARCHAR2_TABLE_100
55     , p8_a19 out nocopy JTF_VARCHAR2_TABLE_100
56     , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100
57     , p8_a21 out nocopy JTF_VARCHAR2_TABLE_100
58     , p8_a22 out nocopy JTF_VARCHAR2_TABLE_300
59   );
60   procedure get_rules_metadata(p_api_version  NUMBER
61     , p_init_msg_list  VARCHAR2
62     , x_return_status out nocopy  VARCHAR2
63     , x_msg_count out nocopy  NUMBER
64     , x_msg_data out nocopy  VARCHAR2
65     , p_rgd_code  VARCHAR2
66     , p_rgs_code  VARCHAR2
67     , p_buy_or_sell  VARCHAR2
68     , p_contract_id  NUMBER
69     , p_line_id  NUMBER
70     , p_party_id  NUMBER
71     , p_template_table  VARCHAR2
72     , p_rule_id_column  VARCHAR2
73     , p_entity_column  VARCHAR2
74     , p14_a0 out nocopy JTF_VARCHAR2_TABLE_100
75     , p14_a1 out nocopy JTF_VARCHAR2_TABLE_100
76     , p14_a2 out nocopy JTF_VARCHAR2_TABLE_100
77     , p14_a3 out nocopy JTF_VARCHAR2_TABLE_100
78     , p14_a4 out nocopy JTF_VARCHAR2_TABLE_100
79     , p14_a5 out nocopy JTF_VARCHAR2_TABLE_100
80     , p14_a6 out nocopy JTF_VARCHAR2_TABLE_100
81     , p14_a7 out nocopy JTF_VARCHAR2_TABLE_100
82     , p14_a8 out nocopy JTF_VARCHAR2_TABLE_100
83     , p14_a9 out nocopy JTF_VARCHAR2_TABLE_100
84     , p14_a10 out nocopy JTF_VARCHAR2_TABLE_2000
85     , p14_a11 out nocopy JTF_VARCHAR2_TABLE_2000
86     , p14_a12 out nocopy JTF_VARCHAR2_TABLE_2000
87     , p14_a13 out nocopy JTF_VARCHAR2_TABLE_2000
88     , p14_a14 out nocopy JTF_VARCHAR2_TABLE_100
89     , p14_a15 out nocopy JTF_VARCHAR2_TABLE_100
90     , p14_a16 out nocopy JTF_VARCHAR2_TABLE_100
91     , p14_a17 out nocopy JTF_VARCHAR2_TABLE_100
92     , p14_a18 out nocopy JTF_VARCHAR2_TABLE_100
93     , p14_a19 out nocopy JTF_VARCHAR2_TABLE_100
94     , p14_a20 out nocopy JTF_VARCHAR2_TABLE_100
95     , p14_a21 out nocopy JTF_VARCHAR2_TABLE_100
96     , p14_a22 out nocopy JTF_VARCHAR2_TABLE_300
97     , p14_a23 out nocopy JTF_VARCHAR2_TABLE_300
98     , p14_a24 out nocopy JTF_VARCHAR2_TABLE_300
99     , p14_a25 out nocopy JTF_VARCHAR2_TABLE_1000
100     , p14_a26 out nocopy JTF_VARCHAR2_TABLE_1000
101     , p14_a27 out nocopy JTF_VARCHAR2_TABLE_100
102   );
103 end okl_rule_extract_pub_w;