PACKAGE: APPS.AMV_MATCH_PVT_W

Source

1 package amv_match_pvt_w as
2   /* $Header: amvwmats.pls 120.2 2005/06/30 08:06 appldev ship $ */
3   procedure rosetta_table_copy_in_p3(t out nocopy amv_match_pvt.terr_id_tbl_type, a0 JTF_NUMBER_TABLE);
4   procedure rosetta_table_copy_out_p3(t amv_match_pvt.terr_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
5 
6   procedure rosetta_table_copy_in_p4(t out nocopy amv_match_pvt.terr_name_tbl_type, a0 JTF_VARCHAR2_TABLE_4000);
7   procedure rosetta_table_copy_out_p4(t amv_match_pvt.terr_name_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_4000);
8 
9   procedure do_itemchannelmatch(p_api_version  NUMBER
10     , p_init_msg_list  VARCHAR2
11     , p_commit  VARCHAR2
12     , p_validation_level  NUMBER
13     , x_return_status out nocopy  VARCHAR2
14     , x_msg_count out nocopy  NUMBER
15     , x_msg_data out nocopy  VARCHAR2
16     , p_check_login_user  VARCHAR2
17     , p_application_id  NUMBER
18     , p_category_id  NUMBER
19     , p_channel_id  NUMBER
20     , p_item_id  NUMBER
21     , p_table_name_code  VARCHAR2
22     , p_match_type  VARCHAR2
23     , p_territory_tbl JTF_NUMBER_TABLE
24   );
25   procedure get_userterritory(p_api_version  NUMBER
26     , p_init_msg_list  VARCHAR2
27     , x_return_status out nocopy  VARCHAR2
28     , x_msg_count out nocopy  NUMBER
29     , x_msg_data out nocopy  VARCHAR2
30     , p_check_login_user  VARCHAR2
31     , p_resource_id  NUMBER
32     , p_resource_type  VARCHAR2
33     , x_terr_id_tbl out nocopy JTF_NUMBER_TABLE
34     , x_terr_name_tbl out nocopy JTF_VARCHAR2_TABLE_4000
35   );
36   procedure get_publishedterritories(p_api_version  NUMBER
37     , p_init_msg_list  VARCHAR2
38     , x_return_status out nocopy  VARCHAR2
39     , x_msg_count out nocopy  NUMBER
40     , x_msg_data out nocopy  VARCHAR2
41     , p_check_login_user  VARCHAR2
42     , p_terr_id  NUMBER
43     , p_table_name_code  VARCHAR2
44     , x_item_id_tbl out nocopy JTF_NUMBER_TABLE
45   );
46 end amv_match_pvt_w;