1 PACKAGE JTY_CUST_QUAL_PKG AS
2 /* $Header: jtfcusqs.pls 120.1 2006/09/22 22:16:24 chchandr noship $ */
3 -- Start of Comments
4 -- ---------------------------------------------------
5 -- PACKAGE NAME: JTY_CUST_QUAL_PKG
6 -- ---------------------------------------------------
7 -- PURPOSE
8 -- This package is used to create custom qualifiers
9 --
10 -- Procedures:
11 -- (see below for specification)
12 --
13 -- NOTES
14 -- This package is publicly available for use
15 --
16 -- HISTORY
17 -- 09/08/05 ACHANDA Created
18 --
19 -- End of Comments
20 --
21
22 PROCEDURE create_qual(
23 p_seeded_qual_id IN NUMBER,
24 p_name IN VARCHAR2,
25 p_description IN VARCHAR2,
26 p_language IN VARCHAR2,
27 p_source_id IN NUMBER,
28 p_trans_type_id IN NUMBER,
29 p_enabled_flag IN VARCHAR2,
30 p_qual_col1 IN VARCHAR2,
31 p_convert_to_id_flag IN VARCHAR2,
32 p_display_type IN VARCHAR2,
33 p_alias_rule1 IN VARCHAR2,
34 p_op_eql IN VARCHAR2,
35 p_op_like IN VARCHAR2,
36 p_op_between IN VARCHAR2,
37 p_op_common_where IN VARCHAR2,
38 p_qual_relation_factor IN NUMBER,
39 p_comparison_operator IN VARCHAR2,
40 p_low_value_char IN VARCHAR2,
41 p_high_value_char IN VARCHAR2,
42 p_low_value_char_id IN VARCHAR2,
43 p_low_value_number IN VARCHAR2,
44 p_high_value_number IN VARCHAR2,
45 p_interest_type_id IN VARCHAR2,
46 p_primary_interest_code_id IN VARCHAR2,
47 p_sec_interest_code_id IN VARCHAR2,
48 p_value1_id IN VARCHAR2,
49 p_value2_id IN VARCHAR2,
50 p_value3_id IN VARCHAR2,
51 p_value4_id IN VARCHAR2,
52 p_first_char IN VARCHAR2,
53 p_currency_code IN VARCHAR2,
54 p_real_time_select IN VARCHAR2,
55 p_real_time_where IN VARCHAR2,
56 p_real_time_from IN VARCHAR2,
57 p_html_lov_sql1 IN VARCHAR2,
58 p_html_lov_sql2 IN VARCHAR2,
59 p_html_lov_sql3 IN VARCHAR2,
60 p_display_sql1 IN VARCHAR2,
61 p_display_sql2 IN VARCHAR2,
62 p_display_sql3 IN VARCHAR2,
63 p_hierarchy_type IN VARCHAR2,
64 p_equal_flag IN VARCHAR2,
65 p_like_flag IN VARCHAR2,
66 p_between_flag IN VARCHAR2,
67 retcode OUT NOCOPY VARCHAR2,
68 errbuf OUT NOCOPY VARCHAR2);
69
70 END JTY_CUST_QUAL_PKG;