[Home] [Help]
PACKAGE: APPS.IEM_SPV_MONITORING_PVT_W
Source
1 package iem_spv_monitoring_pvt_w AUTHID CURRENT_USER as
2 /* $Header: IEMPSPMS.pls 115.4 2003/09/08 23:46:50 chtang noship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy iem_spv_monitoring_pvt.email_activity_tbl, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_VARCHAR2_TABLE_300
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_NUMBER_TABLE
13 , a10 JTF_NUMBER_TABLE
14 , a11 JTF_VARCHAR2_TABLE_100
15 , a12 JTF_VARCHAR2_TABLE_100
16 );
17 procedure rosetta_table_copy_out_p1(t iem_spv_monitoring_pvt.email_activity_tbl, a0 out nocopy JTF_NUMBER_TABLE
18 , a1 out nocopy JTF_NUMBER_TABLE
19 , a2 out nocopy JTF_VARCHAR2_TABLE_300
20 , a3 out nocopy JTF_NUMBER_TABLE
21 , a4 out nocopy JTF_NUMBER_TABLE
22 , a5 out nocopy JTF_NUMBER_TABLE
23 , a6 out nocopy JTF_NUMBER_TABLE
24 , a7 out nocopy JTF_NUMBER_TABLE
25 , a8 out nocopy JTF_NUMBER_TABLE
26 , a9 out nocopy JTF_NUMBER_TABLE
27 , a10 out nocopy JTF_NUMBER_TABLE
28 , a11 out nocopy JTF_VARCHAR2_TABLE_100
29 , a12 out nocopy JTF_VARCHAR2_TABLE_100
30 );
31
32 procedure rosetta_table_copy_in_p3(t out nocopy iem_spv_monitoring_pvt.agent_activity_tbl, a0 JTF_NUMBER_TABLE
33 , a1 JTF_NUMBER_TABLE
34 , a2 JTF_VARCHAR2_TABLE_800
35 , a3 JTF_NUMBER_TABLE
36 , a4 JTF_NUMBER_TABLE
37 , a5 JTF_NUMBER_TABLE
38 , a6 JTF_NUMBER_TABLE
39 , a7 JTF_VARCHAR2_TABLE_500
40 , a8 JTF_NUMBER_TABLE
41 , a9 JTF_VARCHAR2_TABLE_100
42 , a10 JTF_VARCHAR2_TABLE_100
43 );
44 procedure rosetta_table_copy_out_p3(t iem_spv_monitoring_pvt.agent_activity_tbl, a0 out nocopy JTF_NUMBER_TABLE
45 , a1 out nocopy JTF_NUMBER_TABLE
46 , a2 out nocopy JTF_VARCHAR2_TABLE_800
47 , a3 out nocopy JTF_NUMBER_TABLE
48 , a4 out nocopy JTF_NUMBER_TABLE
49 , a5 out nocopy JTF_NUMBER_TABLE
50 , a6 out nocopy JTF_NUMBER_TABLE
51 , a7 out nocopy JTF_VARCHAR2_TABLE_500
52 , a8 out nocopy JTF_NUMBER_TABLE
53 , a9 out nocopy JTF_VARCHAR2_TABLE_100
54 , a10 out nocopy JTF_VARCHAR2_TABLE_100
55 );
56
57 procedure get_email_activity(p_api_version_number NUMBER
58 , p_init_msg_list VARCHAR2
59 , p_commit VARCHAR2
60 , p3_a0 out nocopy JTF_NUMBER_TABLE
61 , p3_a1 out nocopy JTF_NUMBER_TABLE
62 , p3_a2 out nocopy JTF_VARCHAR2_TABLE_300
63 , p3_a3 out nocopy JTF_NUMBER_TABLE
64 , p3_a4 out nocopy JTF_NUMBER_TABLE
65 , p3_a5 out nocopy JTF_NUMBER_TABLE
66 , p3_a6 out nocopy JTF_NUMBER_TABLE
67 , p3_a7 out nocopy JTF_NUMBER_TABLE
68 , p3_a8 out nocopy JTF_NUMBER_TABLE
69 , p3_a9 out nocopy JTF_NUMBER_TABLE
70 , p3_a10 out nocopy JTF_NUMBER_TABLE
71 , p3_a11 out nocopy JTF_VARCHAR2_TABLE_100
72 , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
73 , x_return_status out nocopy VARCHAR2
74 , x_msg_count out nocopy NUMBER
75 , x_msg_data out nocopy VARCHAR2
76 );
77 procedure get_agent_activity(p_api_version_number NUMBER
78 , p_init_msg_list VARCHAR2
79 , p_commit VARCHAR2
80 , p_resource_role NUMBER
81 , p_resource_name VARCHAR2
82 , p5_a0 out nocopy JTF_NUMBER_TABLE
83 , p5_a1 out nocopy JTF_NUMBER_TABLE
84 , p5_a2 out nocopy JTF_VARCHAR2_TABLE_800
85 , p5_a3 out nocopy JTF_NUMBER_TABLE
86 , p5_a4 out nocopy JTF_NUMBER_TABLE
87 , p5_a5 out nocopy JTF_NUMBER_TABLE
88 , p5_a6 out nocopy JTF_NUMBER_TABLE
89 , p5_a7 out nocopy JTF_VARCHAR2_TABLE_500
90 , p5_a8 out nocopy JTF_NUMBER_TABLE
91 , p5_a9 out nocopy JTF_VARCHAR2_TABLE_100
92 , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
93 , x_return_status out nocopy VARCHAR2
94 , x_msg_count out nocopy NUMBER
95 , x_msg_data out nocopy VARCHAR2
96 );
97 end iem_spv_monitoring_pvt_w;