PACKAGE: APPS.QP_UTIL_W

Source

1 package qp_util_w AUTHID CURRENT_USER as
2   /* $Header: amswqpus.pls 115.1 2002/07/31 20:32:46 julou noship $ */
3   procedure rosetta_table_copy_in_p1(t out qp_util.v_segs_upg_tab, a0 JTF_VARCHAR2_TABLE_100
4     , a1 JTF_VARCHAR2_TABLE_100
5     , a2 JTF_NUMBER_TABLE
6     , a3 JTF_VARCHAR2_TABLE_100
7     );
8   procedure rosetta_table_copy_out_p1(t qp_util.v_segs_upg_tab, a0 out JTF_VARCHAR2_TABLE_100
9     , a1 out JTF_VARCHAR2_TABLE_100
10     , a2 out JTF_NUMBER_TABLE
11     , a3 out JTF_VARCHAR2_TABLE_100
12     );
13 
14   procedure rosetta_table_copy_in_p41(t out qp_util.create_context_out_tbl, a0 JTF_VARCHAR2_TABLE_100
15     , a1 JTF_VARCHAR2_TABLE_300
16     );
17   procedure rosetta_table_copy_out_p41(t qp_util.create_context_out_tbl, a0 out JTF_VARCHAR2_TABLE_100
18     , a1 out JTF_VARCHAR2_TABLE_300
19     );
20 
21   procedure rosetta_table_copy_in_p43(t out qp_util.create_attribute_out_tbl, a0 JTF_VARCHAR2_TABLE_100
22     , a1 JTF_VARCHAR2_TABLE_300
23     , a2 JTF_VARCHAR2_TABLE_100
24     , a3 JTF_NUMBER_TABLE
25     , a4 JTF_NUMBER_TABLE
26     );
27   procedure rosetta_table_copy_out_p43(t qp_util.create_attribute_out_tbl, a0 out JTF_VARCHAR2_TABLE_100
28     , a1 out JTF_VARCHAR2_TABLE_300
29     , a2 out JTF_VARCHAR2_TABLE_100
30     , a3 out JTF_NUMBER_TABLE
31     , a4 out JTF_NUMBER_TABLE
32     );
33 
34   procedure validate_qp_flexfield(flexfield_name  VARCHAR2
35     , context  VARCHAR2
36     , attribute  VARCHAR2
37     , value  VARCHAR2
38     , application_short_name  VARCHAR2
39     , context_flag out  VARCHAR2
40     , attribute_flag out  VARCHAR2
41     , value_flag out  VARCHAR2
42     , datatype out  VARCHAR2
43     , precedence out  VARCHAR2
44     , error_code out  NUMBER
45     , check_enabled  number
46   );
47   procedure get_segs_for_flex(flexfield_name  VARCHAR2
48     , application_short_name  VARCHAR2
49     , p2_a0 out JTF_VARCHAR2_TABLE_100
50     , p2_a1 out JTF_VARCHAR2_TABLE_100
51     , p2_a2 out JTF_NUMBER_TABLE
52     , p2_a3 out JTF_VARCHAR2_TABLE_100
53     , error_code out  NUMBER
54   );
55   procedure get_segs_flex_precedence(p0_a0 JTF_VARCHAR2_TABLE_100
56     , p0_a1 JTF_VARCHAR2_TABLE_100
57     , p0_a2 JTF_NUMBER_TABLE
58     , p0_a3 JTF_VARCHAR2_TABLE_100
59     , p_context  VARCHAR2
60     , p_attribute  VARCHAR2
61     , x_precedence out  NUMBER
62     , x_datatype out  VARCHAR2
63   );
64   procedure correct_active_dates(p_active_date_first_type in out  VARCHAR2
65     , p_start_date_active_first in out  date
66     , p_end_date_active_first in out  date
67     , p_active_date_second_type in out  VARCHAR2
68     , p_start_date_active_second in out  date
69     , p_end_date_active_second in out  date
70   );
71   procedure web_create_context_lov(p_field_context  VARCHAR2
72     , p_context_type  VARCHAR2
73     , p_check_enabled  VARCHAR2
74     , p_limits  VARCHAR2
75     , p_list_line_type_code  VARCHAR2
76     , x_return_status out  VARCHAR2
77     , p6_a0 out JTF_VARCHAR2_TABLE_100
78     , p6_a1 out JTF_VARCHAR2_TABLE_300
79   );
80   procedure web_create_attribute_lov(p_context_code  VARCHAR2
81     , p_context_type  VARCHAR2
82     , p_check_enabled  VARCHAR2
83     , p_limits  VARCHAR2
84     , p_list_line_type_code  VARCHAR2
85     , p_segment_level  NUMBER
86     , p_field_context  VARCHAR2
87     , x_return_status out  VARCHAR2
88     , p8_a0 out JTF_VARCHAR2_TABLE_100
89     , p8_a1 out JTF_VARCHAR2_TABLE_300
90     , p8_a2 out JTF_VARCHAR2_TABLE_100
91     , p8_a3 out JTF_NUMBER_TABLE
92     , p8_a4 out JTF_NUMBER_TABLE
93   );
94 end qp_util_w;