DBA Data[Home] [Help]

PACKAGE: APPS.AHL_UMP_SR_PVT_W

Source


1 package ahl_ump_sr_pvt_w as
2   /* $Header: AHLWUSRS.pls 120.0 2005/07/21 00:07 tamdas noship $ */
3   procedure rosetta_table_copy_in_p1(t out nocopy ahl_ump_sr_pvt.sr_mr_association_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4     , a1 JTF_VARCHAR2_TABLE_100
5     , a2 JTF_NUMBER_TABLE
6     , a3 JTF_NUMBER_TABLE
7     , a4 JTF_NUMBER_TABLE
8     , a5 JTF_NUMBER_TABLE
9     , a6 JTF_NUMBER_TABLE
10     , a7 JTF_VARCHAR2_TABLE_100
11     , a8 JTF_NUMBER_TABLE
12     , a9 JTF_VARCHAR2_TABLE_100
13     );
14   procedure rosetta_table_copy_out_p1(t ahl_ump_sr_pvt.sr_mr_association_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
15     , a1 out nocopy JTF_VARCHAR2_TABLE_100
16     , a2 out nocopy JTF_NUMBER_TABLE
17     , a3 out nocopy JTF_NUMBER_TABLE
18     , a4 out nocopy JTF_NUMBER_TABLE
19     , a5 out nocopy JTF_NUMBER_TABLE
20     , a6 out nocopy JTF_NUMBER_TABLE
21     , a7 out nocopy JTF_VARCHAR2_TABLE_100
22     , a8 out nocopy JTF_NUMBER_TABLE
23     , a9 out nocopy JTF_VARCHAR2_TABLE_100
24     );
25 
26   procedure process_sr_mr_associations(p_api_version  NUMBER
27     , p_init_msg_list  VARCHAR2
28     , p_commit  VARCHAR2
29     , p_validation_level  NUMBER
30     , x_return_status out nocopy  VARCHAR2
31     , x_msg_count out nocopy  NUMBER
32     , x_msg_data out nocopy  VARCHAR2
33     , p_user_id  NUMBER
34     , p_login_id  NUMBER
35     , p_request_id  NUMBER
36     , p_object_version_number  NUMBER
37     , p_request_number  VARCHAR2
38     , p12_a0 in out nocopy JTF_VARCHAR2_TABLE_100
39     , p12_a1 in out nocopy JTF_VARCHAR2_TABLE_100
40     , p12_a2 in out nocopy JTF_NUMBER_TABLE
41     , p12_a3 in out nocopy JTF_NUMBER_TABLE
42     , p12_a4 in out nocopy JTF_NUMBER_TABLE
43     , p12_a5 in out nocopy JTF_NUMBER_TABLE
44     , p12_a6 in out nocopy JTF_NUMBER_TABLE
45     , p12_a7 in out nocopy JTF_VARCHAR2_TABLE_100
46     , p12_a8 in out nocopy JTF_NUMBER_TABLE
47     , p12_a9 in out nocopy JTF_VARCHAR2_TABLE_100
48   );
49 end ahl_ump_sr_pvt_w;