DBA Data[Home] [Help]

PACKAGE: APPS.QP_UTIL_OA

Source


1 package qp_util_oa AUTHID CURRENT_USER as
2   /* $Header: ozfaqpus.pls 115.0 2003/11/07 18:45:30 gramanat noship $ */
3   procedure rosetta_table_copy_in_p1(t out nocopy 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 nocopy JTF_VARCHAR2_TABLE_100
9     , a1 out nocopy JTF_VARCHAR2_TABLE_100
10     , a2 out nocopy JTF_NUMBER_TABLE
11     , a3 out nocopy JTF_VARCHAR2_TABLE_100
12     );
13 
14   procedure rosetta_table_copy_in_p39(t out nocopy qp_util.create_context_out_tbl, a0 JTF_VARCHAR2_TABLE_100
15     , a1 JTF_VARCHAR2_TABLE_300
16     );
17   procedure rosetta_table_copy_out_p39(t qp_util.create_context_out_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
18     , a1 out nocopy JTF_VARCHAR2_TABLE_300
19     );
20 
21   procedure rosetta_table_copy_in_p41(t out nocopy 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_p41(t qp_util.create_attribute_out_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
28     , a1 out nocopy JTF_VARCHAR2_TABLE_300
29     , a2 out nocopy JTF_VARCHAR2_TABLE_100
30     , a3 out nocopy JTF_NUMBER_TABLE
31     , a4 out nocopy 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 nocopy  VARCHAR2
40     , attribute_flag out nocopy  VARCHAR2
41     , value_flag out nocopy  VARCHAR2
42     , datatype out nocopy  VARCHAR2
43     , precedence out nocopy  VARCHAR2
44     , error_code out nocopy  NUMBER
45     , check_enabled  number
46   );
47   procedure get_segs_for_flex(flexfield_name  VARCHAR2
48     , application_short_name  VARCHAR2
49     , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
50     , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
51     , p2_a2 out nocopy JTF_NUMBER_TABLE
52     , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
53     , error_code out nocopy  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 nocopy  NUMBER
62     , x_datatype out nocopy  VARCHAR2
63   );
64   procedure web_create_context_lov(p_field_context  VARCHAR2
65     , p_context_type  VARCHAR2
66     , p_check_enabled  VARCHAR2
67     , p_limits  VARCHAR2
68     , p_list_line_type_code  VARCHAR2
69     , x_return_status out nocopy  VARCHAR2
70     , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
71     , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
72   );
73   procedure web_create_attribute_lov(p_context_code  VARCHAR2
74     , p_context_type  VARCHAR2
75     , p_check_enabled  VARCHAR2
76     , p_limits  VARCHAR2
77     , p_list_line_type_code  VARCHAR2
78     , p_segment_level  NUMBER
79     , p_field_context  VARCHAR2
80     , x_return_status out nocopy  VARCHAR2
81     , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
82     , p8_a1 out nocopy JTF_VARCHAR2_TABLE_300
83     , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
84     , p8_a3 out nocopy JTF_NUMBER_TABLE
85     , p8_a4 out nocopy JTF_NUMBER_TABLE
86   );
87 end qp_util_oa;