DBA Data[Home] [Help]

PACKAGE: APPS.AMV_SEARCH_GRP_W

Source


1 package amv_search_grp_w as
2   /* $Header: amvwsrgs.pls 120.2 2005/06/30 08:44 appldev ship $ */
3   procedure find_repositories(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_object_version_number  NUMBER
11     , p_repository_id  NUMBER
12     , p_repository_code  VARCHAR2
13     , p_repository_name  VARCHAR2
14     , p_status  VARCHAR2
15     , p12_a0 out nocopy JTF_NUMBER_TABLE
16     , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
17     , p12_a2 out nocopy JTF_VARCHAR2_TABLE_100
18     , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
19     , p12_a4 out nocopy JTF_NUMBER_TABLE
20   );
21   procedure find_repository_areas(p_api_version  NUMBER
22     , p_init_msg_list  VARCHAR2
23     , p_validation_level  NUMBER
24     , x_return_status out nocopy  VARCHAR2
25     , x_msg_count out nocopy  NUMBER
26     , x_msg_data out nocopy  VARCHAR2
27     , p_check_login_user  VARCHAR2
28     , p8_a0 out nocopy JTF_NUMBER_TABLE
29     , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
30     , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
31     , p8_a3 out nocopy JTF_NUMBER_TABLE
32     , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
33     , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
34     , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
35     , p8_a7 out nocopy JTF_NUMBER_TABLE
36     , p7_a0  NUMBER := 0-1962.0724
37     , p7_a1  VARCHAR2 := fnd_api.g_miss_char
38     , p7_a2  VARCHAR2 := fnd_api.g_miss_char
39     , p7_a3  NUMBER := 0-1962.0724
40     , p7_a4  VARCHAR2 := fnd_api.g_miss_char
41     , p7_a5  VARCHAR2 := fnd_api.g_miss_char
42     , p7_a6  VARCHAR2 := fnd_api.g_miss_char
43     , p7_a7  NUMBER := 0-1962.0724
44   );
45   procedure content_search(p_api_version  NUMBER
46     , p_init_msg_list  VARCHAR2
47     , p_validation_level  NUMBER
48     , x_return_status out nocopy  VARCHAR2
49     , x_msg_count out nocopy  NUMBER
50     , x_msg_data out nocopy  VARCHAR2
51     , p_check_login_user  VARCHAR2
52     , p_application_id  NUMBER
53     , p_area_array JTF_VARCHAR2_TABLE_4000
54     , p_content_array JTF_VARCHAR2_TABLE_4000
55     , p10_a0 JTF_VARCHAR2_TABLE_100
56     , p10_a1 JTF_VARCHAR2_TABLE_400
57     , p_imt_string  VARCHAR2
58     , p_days  NUMBER
59     , p_user_id  NUMBER
60     , p_category_id JTF_NUMBER_TABLE
61     , p_include_subcats  VARCHAR2
62     , p_external_contents  VARCHAR2
63     , p18_a0 out nocopy  NUMBER
64     , p18_a1 out nocopy  NUMBER
65     , p18_a2 out nocopy  NUMBER
66     , p19_a0 out nocopy JTF_VARCHAR2_TABLE_300
67     , p19_a1 out nocopy JTF_VARCHAR2_TABLE_2000
68     , p19_a2 out nocopy JTF_VARCHAR2_TABLE_4000
69     , p19_a3 out nocopy JTF_NUMBER_TABLE
70     , p19_a4 out nocopy JTF_NUMBER_TABLE
71     , p19_a5 out nocopy JTF_VARCHAR2_TABLE_100
72     , p19_a6 out nocopy JTF_VARCHAR2_TABLE_300
73     , p19_a7 out nocopy JTF_VARCHAR2_TABLE_300
74     , p19_a8 out nocopy JTF_VARCHAR2_TABLE_300
75     , p17_a0  NUMBER := 0-1962.0724
76     , p17_a1  NUMBER := 0-1962.0724
77     , p17_a2  VARCHAR2 := fnd_api.g_miss_char
78   );
79 end amv_search_grp_w;