PACKAGE: APPS.AMV_MYCHANNEL_GRP_W

Source

1 package amv_mychannel_grp_w as
2   /* $Header: amvwmcgs.pls 120.2 2005/06/30 08:20 appldev ship $ */
3   procedure get_mychannels(p_api_version  NUMBER
4     , p_init_msg_list  VARCHAR2
5     , p_validation_level  NUMBER
6     , x_return_status out nocopy  VARCHAR2
7     , x_msg_count out nocopy  NUMBER
8     , x_msg_data out nocopy  VARCHAR2
9     , p_check_login_user  VARCHAR2
10     , p_user_id  NUMBER
11     , p8_a0 out nocopy JTF_NUMBER_TABLE
12     , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
13     , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
14     , p8_a3 out nocopy JTF_NUMBER_TABLE
15     , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
16     , p8_a5 out nocopy JTF_NUMBER_TABLE
17     , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
18     , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
19     , p8_a8 out nocopy JTF_NUMBER_TABLE
20     , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
21     , p8_a10 out nocopy JTF_VARCHAR2_TABLE_100
22     , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
23   );
24   procedure get_itemsperuser(p_api_version  NUMBER
25     , p_init_msg_list  VARCHAR2
26     , p_validation_level  NUMBER
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_user_id  NUMBER
32     , p9_a0 out nocopy  NUMBER
33     , p9_a1 out nocopy  NUMBER
34     , p9_a2 out nocopy  NUMBER
35     , p10_a0 out nocopy JTF_NUMBER_TABLE
36     , p10_a1 out nocopy JTF_NUMBER_TABLE
37     , p10_a2 out nocopy JTF_VARCHAR2_TABLE_300
38     , p8_a0  NUMBER := 0-1962.0724
39     , p8_a1  NUMBER := 0-1962.0724
40     , p8_a2  VARCHAR2 := fnd_api.g_miss_char
41   );
42 end amv_mychannel_grp_w;