eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.JTF_UM_SUBSCRIPTION_INFO_W

Source


1 package jtf_um_subscription_info_w AUTHID CURRENT_USER as
2   /* $Header: JTFWSBIS.pls 120.2 2005/09/02 18:36:20 applrt ship $ */
3   procedure rosetta_table_copy_in_p2(t out nocopy jtf_um_subscription_info.subscription_info_table, a0 JTF_VARCHAR2_TABLE_1000
4     , a1 JTF_VARCHAR2_TABLE_100
5     , a2 JTF_VARCHAR2_TABLE_2000
6     , a3 JTF_NUMBER_TABLE
7     , a4 JTF_VARCHAR2_TABLE_100
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_NUMBER_TABLE
15     , a12 JTF_VARCHAR2_TABLE_100
16     , a13 JTF_VARCHAR2_TABLE_300
17     , a14 JTF_VARCHAR2_TABLE_300
18     );
19   procedure rosetta_table_copy_out_p2(t jtf_um_subscription_info.subscription_info_table, a0 out nocopy JTF_VARCHAR2_TABLE_1000
20     , a1 out nocopy JTF_VARCHAR2_TABLE_100
21     , a2 out nocopy JTF_VARCHAR2_TABLE_2000
22     , a3 out nocopy JTF_NUMBER_TABLE
23     , a4 out nocopy JTF_VARCHAR2_TABLE_100
24     , a5 out nocopy JTF_NUMBER_TABLE
25     , a6 out nocopy JTF_NUMBER_TABLE
26     , a7 out nocopy JTF_NUMBER_TABLE
27     , a8 out nocopy JTF_NUMBER_TABLE
28     , a9 out nocopy JTF_NUMBER_TABLE
29     , a10 out nocopy JTF_NUMBER_TABLE
30     , a11 out nocopy JTF_NUMBER_TABLE
31     , a12 out nocopy JTF_VARCHAR2_TABLE_100
32     , a13 out nocopy JTF_VARCHAR2_TABLE_300
33     , a14 out nocopy JTF_VARCHAR2_TABLE_300
34     );
35 
36   procedure rosetta_table_copy_in_p3(t out nocopy jtf_um_subscription_info.subscription_list, a0 JTF_NUMBER_TABLE
37     );
38   procedure rosetta_table_copy_out_p3(t jtf_um_subscription_info.subscription_list, a0 out nocopy JTF_NUMBER_TABLE
39     );
40 
41   procedure get_usertype_sub_info(p_usertype_id  NUMBER
42     , p_user_id  NUMBER
43     , p_is_admin  NUMBER
44     , p3_a0 out nocopy JTF_VARCHAR2_TABLE_1000
45     , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
46     , p3_a2 out nocopy JTF_VARCHAR2_TABLE_2000
47     , p3_a3 out nocopy JTF_NUMBER_TABLE
48     , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
49     , p3_a5 out nocopy JTF_NUMBER_TABLE
50     , p3_a6 out nocopy JTF_NUMBER_TABLE
51     , p3_a7 out nocopy JTF_NUMBER_TABLE
52     , p3_a8 out nocopy JTF_NUMBER_TABLE
53     , p3_a9 out nocopy JTF_NUMBER_TABLE
54     , p3_a10 out nocopy JTF_NUMBER_TABLE
55     , p3_a11 out nocopy JTF_NUMBER_TABLE
56     , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
57     , p3_a13 out nocopy JTF_VARCHAR2_TABLE_300
58     , p3_a14 out nocopy JTF_VARCHAR2_TABLE_300
59   );
60   procedure get_user_sub_info(p_user_id  NUMBER
61     , p_is_admin  NUMBER
62     , p_logged_in_user_id  NUMBER
63     , p_administrator  NUMBER
64     , p_sub_status  VARCHAR2
65     , p5_a0 out nocopy JTF_VARCHAR2_TABLE_1000
66     , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
67     , p5_a2 out nocopy JTF_VARCHAR2_TABLE_2000
68     , p5_a3 out nocopy JTF_NUMBER_TABLE
69     , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
70     , p5_a5 out nocopy JTF_NUMBER_TABLE
71     , p5_a6 out nocopy JTF_NUMBER_TABLE
72     , p5_a7 out nocopy JTF_NUMBER_TABLE
73     , p5_a8 out nocopy JTF_NUMBER_TABLE
74     , p5_a9 out nocopy JTF_NUMBER_TABLE
75     , p5_a10 out nocopy JTF_NUMBER_TABLE
76     , p5_a11 out nocopy JTF_NUMBER_TABLE
77     , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
78     , p5_a13 out nocopy JTF_VARCHAR2_TABLE_300
79     , p5_a14 out nocopy JTF_VARCHAR2_TABLE_300
80   );
81   procedure get_conf_sub_info(p_user_id  NUMBER
82     , p_usertype_id  NUMBER
83     , p_is_admin  NUMBER
84     , p_admin_id  NUMBER
85     , p_administrator  NUMBER
86     , p5_a0 JTF_NUMBER_TABLE
87     , p6_a0 out nocopy JTF_VARCHAR2_TABLE_1000
88     , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
89     , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
90     , p6_a3 out nocopy JTF_NUMBER_TABLE
91     , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
92     , p6_a5 out nocopy JTF_NUMBER_TABLE
93     , p6_a6 out nocopy JTF_NUMBER_TABLE
94     , p6_a7 out nocopy JTF_NUMBER_TABLE
95     , p6_a8 out nocopy JTF_NUMBER_TABLE
96     , p6_a9 out nocopy JTF_NUMBER_TABLE
97     , p6_a10 out nocopy JTF_NUMBER_TABLE
98     , p6_a11 out nocopy JTF_NUMBER_TABLE
99     , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
100     , p6_a13 out nocopy JTF_VARCHAR2_TABLE_300
101     , p6_a14 out nocopy JTF_VARCHAR2_TABLE_300
102   );
103   procedure get_usertype_sub(p_usertype_id  NUMBER
104     , p_user_id  NUMBER
105     , p_is_admin  NUMBER
106     , p_admin_id  NUMBER
107     , p4_a0 JTF_NUMBER_TABLE
108     , p5_a0 out nocopy JTF_VARCHAR2_TABLE_1000
109     , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
110     , p5_a2 out nocopy JTF_VARCHAR2_TABLE_2000
111     , p5_a3 out nocopy JTF_NUMBER_TABLE
112     , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
113     , p5_a5 out nocopy JTF_NUMBER_TABLE
114     , p5_a6 out nocopy JTF_NUMBER_TABLE
115     , p5_a7 out nocopy JTF_NUMBER_TABLE
116     , p5_a8 out nocopy JTF_NUMBER_TABLE
117     , p5_a9 out nocopy JTF_NUMBER_TABLE
118     , p5_a10 out nocopy JTF_NUMBER_TABLE
119     , p5_a11 out nocopy JTF_NUMBER_TABLE
120     , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
121     , p5_a13 out nocopy JTF_VARCHAR2_TABLE_300
122     , p5_a14 out nocopy JTF_VARCHAR2_TABLE_300
123   );
124 end jtf_um_subscription_info_w;