[Home] [Help]
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;