DBA Data[Home] [Help]

PACKAGE: APPS.AHL_CMP_PVT_W

Source


1 package ahl_cmp_pvt_w AUTHID CURRENT_USER as
2   /* $Header: AHLWCMPS.pls 120.0.12020000.2 2012/12/13 05:16:35 shnatu noship $ */
3   procedure rosetta_table_copy_in_p4(t out nocopy ahl_cmp_pvt.ahl_mtlxfr_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_VARCHAR2_TABLE_100
5     , a2 JTF_NUMBER_TABLE
6     , a3 JTF_VARCHAR2_TABLE_100
7     , a4 JTF_NUMBER_TABLE
8     , a5 JTF_VARCHAR2_TABLE_100
9     , a6 JTF_NUMBER_TABLE
10     , a7 JTF_VARCHAR2_TABLE_300
11     , a8 JTF_NUMBER_TABLE
12     , a9 JTF_VARCHAR2_TABLE_100
13     , a10 JTF_NUMBER_TABLE
14     , a11 JTF_VARCHAR2_TABLE_300
15     , a12 JTF_VARCHAR2_TABLE_100
16     , a13 JTF_VARCHAR2_TABLE_100
17     );
18   procedure rosetta_table_copy_out_p4(t ahl_cmp_pvt.ahl_mtlxfr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
19     , a1 out nocopy JTF_VARCHAR2_TABLE_100
20     , a2 out nocopy JTF_NUMBER_TABLE
21     , a3 out nocopy JTF_VARCHAR2_TABLE_100
22     , a4 out nocopy JTF_NUMBER_TABLE
23     , a5 out nocopy JTF_VARCHAR2_TABLE_100
24     , a6 out nocopy JTF_NUMBER_TABLE
25     , a7 out nocopy JTF_VARCHAR2_TABLE_300
26     , a8 out nocopy JTF_NUMBER_TABLE
27     , a9 out nocopy JTF_VARCHAR2_TABLE_100
28     , a10 out nocopy JTF_NUMBER_TABLE
29     , a11 out nocopy JTF_VARCHAR2_TABLE_300
30     , a12 out nocopy JTF_VARCHAR2_TABLE_100
31     , a13 out nocopy JTF_VARCHAR2_TABLE_100
32     );
33 
34   procedure rosetta_table_copy_in_p6(t out nocopy ahl_cmp_pvt.ahl_mtlrtn_tbl_type, a0 JTF_NUMBER_TABLE
35     , a1 JTF_VARCHAR2_TABLE_300
36     , a2 JTF_NUMBER_TABLE
37     , a3 JTF_VARCHAR2_TABLE_100
38     , a4 JTF_NUMBER_TABLE
39     , a5 JTF_VARCHAR2_TABLE_100
40     , a6 JTF_NUMBER_TABLE
41     , a7 JTF_VARCHAR2_TABLE_100
42     , a8 JTF_NUMBER_TABLE
43     , a9 JTF_VARCHAR2_TABLE_300
44     , a10 JTF_NUMBER_TABLE
45     , a11 JTF_NUMBER_TABLE
46     , a12 JTF_VARCHAR2_TABLE_100
47     , a13 JTF_VARCHAR2_TABLE_100
48     , a14 JTF_VARCHAR2_TABLE_100
49     , a15 JTF_NUMBER_TABLE
50     , a16 JTF_NUMBER_TABLE
51     );
52   procedure rosetta_table_copy_out_p6(t ahl_cmp_pvt.ahl_mtlrtn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
53     , a1 out nocopy JTF_VARCHAR2_TABLE_300
54     , a2 out nocopy JTF_NUMBER_TABLE
55     , a3 out nocopy JTF_VARCHAR2_TABLE_100
56     , a4 out nocopy JTF_NUMBER_TABLE
57     , a5 out nocopy JTF_VARCHAR2_TABLE_100
58     , a6 out nocopy JTF_NUMBER_TABLE
59     , a7 out nocopy JTF_VARCHAR2_TABLE_100
60     , a8 out nocopy JTF_NUMBER_TABLE
61     , a9 out nocopy JTF_VARCHAR2_TABLE_300
62     , a10 out nocopy JTF_NUMBER_TABLE
63     , a11 out nocopy JTF_NUMBER_TABLE
64     , a12 out nocopy JTF_VARCHAR2_TABLE_100
65     , a13 out nocopy JTF_VARCHAR2_TABLE_100
66     , a14 out nocopy JTF_VARCHAR2_TABLE_100
67     , a15 out nocopy JTF_NUMBER_TABLE
68     , a16 out nocopy JTF_NUMBER_TABLE
69     );
70 
71   procedure perform_mtl_xfr(p_api_version  NUMBER
72     , p_init_msg_list  VARCHAR2
73     , p_commit  VARCHAR2
74     , p_validation_level  NUMBER
75     , p4_a0 in out nocopy JTF_NUMBER_TABLE
76     , p4_a1 in out nocopy JTF_VARCHAR2_TABLE_100
77     , p4_a2 in out nocopy JTF_NUMBER_TABLE
78     , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
79     , p4_a4 in out nocopy JTF_NUMBER_TABLE
80     , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
81     , p4_a6 in out nocopy JTF_NUMBER_TABLE
82     , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_300
83     , p4_a8 in out nocopy JTF_NUMBER_TABLE
84     , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
85     , p4_a10 in out nocopy JTF_NUMBER_TABLE
86     , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_300
87     , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
88     , p4_a13 in out nocopy JTF_VARCHAR2_TABLE_100
89     , x_return_status out nocopy  VARCHAR2
90     , x_msg_count out nocopy  NUMBER
91     , x_msg_data out nocopy  VARCHAR2
92   );
93   procedure perform_return_txn(p_api_version  NUMBER
94     , p_init_msg_list  VARCHAR2
95     , p_commit  VARCHAR2
96     , p_validation_level  NUMBER
97     , p4_a0 in out nocopy JTF_NUMBER_TABLE
98     , p4_a1 in out nocopy JTF_VARCHAR2_TABLE_300
99     , p4_a2 in out nocopy JTF_NUMBER_TABLE
100     , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
101     , p4_a4 in out nocopy JTF_NUMBER_TABLE
102     , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
103     , p4_a6 in out nocopy JTF_NUMBER_TABLE
104     , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
105     , p4_a8 in out nocopy JTF_NUMBER_TABLE
106     , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_300
107     , p4_a10 in out nocopy JTF_NUMBER_TABLE
108     , p4_a11 in out nocopy JTF_NUMBER_TABLE
109     , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
110     , p4_a13 in out nocopy JTF_VARCHAR2_TABLE_100
111     , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_100
112     , p4_a15 in out nocopy JTF_NUMBER_TABLE
113     , p4_a16 in out nocopy JTF_NUMBER_TABLE
114     , x_return_status out nocopy  VARCHAR2
115     , x_msg_count out nocopy  NUMBER
116     , x_msg_data out nocopy  VARCHAR2
117   );
118 end ahl_cmp_pvt_w;