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.IBC_CITEM_RUNTIME_PUB_W

Source


1 package ibc_citem_runtime_pub_w as
2   /* $Header: ibcwcirs.pls 120.0 2005/05/27 14:56:48 appldev noship $ */
3   procedure rosetta_table_copy_in_p0(t out nocopy ibc_citem_runtime_pub.rendition_file_name_tbl, a0 JTF_VARCHAR2_TABLE_300);
4   procedure rosetta_table_copy_out_p0(t ibc_citem_runtime_pub.rendition_file_name_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300);
5 
6   procedure rosetta_table_copy_in_p1(t out nocopy ibc_citem_runtime_pub.rendition_file_id_tbl, a0 JTF_NUMBER_TABLE);
7   procedure rosetta_table_copy_out_p1(t ibc_citem_runtime_pub.rendition_file_id_tbl, a0 out nocopy JTF_NUMBER_TABLE);
8 
9   procedure rosetta_table_copy_in_p2(t out nocopy ibc_citem_runtime_pub.rendition_mime_type_tbl, a0 JTF_VARCHAR2_TABLE_100);
10   procedure rosetta_table_copy_out_p2(t ibc_citem_runtime_pub.rendition_mime_type_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100);
11 
12   procedure rosetta_table_copy_in_p3(t out nocopy ibc_citem_runtime_pub.rendition_name_tbl, a0 JTF_VARCHAR2_TABLE_300);
13   procedure rosetta_table_copy_out_p3(t ibc_citem_runtime_pub.rendition_name_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300);
14 
15   procedure rosetta_table_copy_in_p4(t out nocopy ibc_citem_runtime_pub.comp_item_attrib_tcode_tbl, a0 JTF_VARCHAR2_TABLE_100);
16   procedure rosetta_table_copy_out_p4(t ibc_citem_runtime_pub.comp_item_attrib_tcode_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100);
17 
18   procedure rosetta_table_copy_in_p5(t out nocopy ibc_citem_runtime_pub.comp_item_citem_id_tbl, a0 JTF_NUMBER_TABLE);
19   procedure rosetta_table_copy_out_p5(t ibc_citem_runtime_pub.comp_item_citem_id_tbl, a0 out nocopy JTF_NUMBER_TABLE);
20 
21   procedure rosetta_table_copy_in_p7(t out nocopy ibc_citem_runtime_pub.content_item_meta_tbl, a0 JTF_NUMBER_TABLE
22     , a1 JTF_NUMBER_TABLE
23     , a2 JTF_DATE_TABLE
24     , a3 JTF_DATE_TABLE
25     , a4 JTF_VARCHAR2_TABLE_100
26     , a5 JTF_VARCHAR2_TABLE_100
27     , a6 JTF_VARCHAR2_TABLE_100
28     , a7 JTF_VARCHAR2_TABLE_300
29     , a8 JTF_VARCHAR2_TABLE_2000
30     , a9 JTF_VARCHAR2_TABLE_300
31     , a10 JTF_NUMBER_TABLE
32     , a11 JTF_VARCHAR2_TABLE_100
33     , a12 JTF_VARCHAR2_TABLE_300
34     );
35   procedure rosetta_table_copy_out_p7(t ibc_citem_runtime_pub.content_item_meta_tbl, a0 out nocopy JTF_NUMBER_TABLE
36     , a1 out nocopy JTF_NUMBER_TABLE
37     , a2 out nocopy JTF_DATE_TABLE
38     , a3 out nocopy JTF_DATE_TABLE
39     , a4 out nocopy JTF_VARCHAR2_TABLE_100
40     , a5 out nocopy JTF_VARCHAR2_TABLE_100
41     , a6 out nocopy JTF_VARCHAR2_TABLE_100
42     , a7 out nocopy JTF_VARCHAR2_TABLE_300
43     , a8 out nocopy JTF_VARCHAR2_TABLE_2000
44     , a9 out nocopy JTF_VARCHAR2_TABLE_300
45     , a10 out nocopy JTF_NUMBER_TABLE
46     , a11 out nocopy JTF_VARCHAR2_TABLE_100
47     , a12 out nocopy JTF_VARCHAR2_TABLE_300
48     );
49 
50   procedure rosetta_table_copy_in_p9(t out nocopy ibc_citem_runtime_pub.content_item_id_tbl, a0 JTF_NUMBER_TABLE);
51   procedure rosetta_table_copy_out_p9(t ibc_citem_runtime_pub.content_item_id_tbl, a0 out nocopy JTF_NUMBER_TABLE);
52 
53   procedure get_citems_meta_by_assoc(p_api_version  NUMBER
54     , p_init_msg_list  VARCHAR2
55     , p_association_type_code  VARCHAR2
56     , p_associated_object_val1  VARCHAR2
57     , p_associated_object_val2  VARCHAR2
58     , p_associated_object_val3  VARCHAR2
59     , p_associated_object_val4  VARCHAR2
60     , p_associated_object_val5  VARCHAR2
61     , p_label_code  VARCHAR2
62     , x_return_status out nocopy  VARCHAR2
63     , x_msg_count out nocopy  NUMBER
64     , x_msg_data out nocopy  VARCHAR2
65     , p12_a0 out nocopy JTF_NUMBER_TABLE
66     , p12_a1 out nocopy JTF_NUMBER_TABLE
67     , p12_a2 out nocopy JTF_DATE_TABLE
68     , p12_a3 out nocopy JTF_DATE_TABLE
69     , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
70     , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
71     , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
72     , p12_a7 out nocopy JTF_VARCHAR2_TABLE_300
73     , p12_a8 out nocopy JTF_VARCHAR2_TABLE_2000
74     , p12_a9 out nocopy JTF_VARCHAR2_TABLE_300
75     , p12_a10 out nocopy JTF_NUMBER_TABLE
76     , p12_a11 out nocopy JTF_VARCHAR2_TABLE_100
77     , p12_a12 out nocopy JTF_VARCHAR2_TABLE_300
78   );
79   procedure get_citems_meta_by_assoc_ctyp(p_api_version  NUMBER
80     , p_init_msg_list  VARCHAR2
81     , p_association_type_code  VARCHAR2
82     , p_associated_object_val1  VARCHAR2
83     , p_associated_object_val2  VARCHAR2
84     , p_associated_object_val3  VARCHAR2
85     , p_associated_object_val4  VARCHAR2
86     , p_associated_object_val5  VARCHAR2
87     , p_content_type_code  VARCHAR2
88     , p_label_code  VARCHAR2
89     , x_return_status out nocopy  VARCHAR2
90     , x_msg_count out nocopy  NUMBER
91     , x_msg_data out nocopy  VARCHAR2
92     , p13_a0 out nocopy JTF_NUMBER_TABLE
93     , p13_a1 out nocopy JTF_NUMBER_TABLE
94     , p13_a2 out nocopy JTF_DATE_TABLE
95     , p13_a3 out nocopy JTF_DATE_TABLE
96     , p13_a4 out nocopy JTF_VARCHAR2_TABLE_100
97     , p13_a5 out nocopy JTF_VARCHAR2_TABLE_100
98     , p13_a6 out nocopy JTF_VARCHAR2_TABLE_100
99     , p13_a7 out nocopy JTF_VARCHAR2_TABLE_300
100     , p13_a8 out nocopy JTF_VARCHAR2_TABLE_2000
101     , p13_a9 out nocopy JTF_VARCHAR2_TABLE_300
102     , p13_a10 out nocopy JTF_NUMBER_TABLE
103     , p13_a11 out nocopy JTF_VARCHAR2_TABLE_100
104     , p13_a12 out nocopy JTF_VARCHAR2_TABLE_300
105   );
106   procedure get_citems_meta(p_api_version  NUMBER
107     , p_init_msg_list  VARCHAR2
108     , p_content_item_ids JTF_NUMBER_TABLE
109     , p_label_code  VARCHAR2
110     , x_return_status out nocopy  VARCHAR2
111     , x_msg_count out nocopy  NUMBER
112     , x_msg_data out nocopy  VARCHAR2
113     , p7_a0 out nocopy JTF_NUMBER_TABLE
114     , p7_a1 out nocopy JTF_NUMBER_TABLE
115     , p7_a2 out nocopy JTF_DATE_TABLE
116     , p7_a3 out nocopy JTF_DATE_TABLE
117     , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
118     , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
119     , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
120     , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300
121     , p7_a8 out nocopy JTF_VARCHAR2_TABLE_2000
122     , p7_a9 out nocopy JTF_VARCHAR2_TABLE_300
123     , p7_a10 out nocopy JTF_NUMBER_TABLE
124     , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
125     , p7_a12 out nocopy JTF_VARCHAR2_TABLE_300
126   );
127   procedure get_citem_meta(p_api_version  NUMBER
128     , p_init_msg_list  VARCHAR2
129     , p_content_item_id  NUMBER
130     , p_label_code  VARCHAR2
131     , x_return_status out nocopy  VARCHAR2
132     , x_msg_count out nocopy  NUMBER
133     , x_msg_data out nocopy  VARCHAR2
134     , p7_a0 out nocopy  NUMBER
135     , p7_a1 out nocopy  NUMBER
136     , p7_a2 out nocopy  DATE
137     , p7_a3 out nocopy  DATE
138     , p7_a4 out nocopy  VARCHAR2
139     , p7_a5 out nocopy  VARCHAR2
140     , p7_a6 out nocopy  VARCHAR2
141     , p7_a7 out nocopy  VARCHAR2
142     , p7_a8 out nocopy  VARCHAR2
143     , p7_a9 out nocopy  VARCHAR2
144     , p7_a10 out nocopy  NUMBER
145     , p7_a11 out nocopy  VARCHAR2
146     , p7_a12 out nocopy  VARCHAR2
147   );
148   procedure get_citem_basic(p_api_version  NUMBER
149     , p_init_msg_list  VARCHAR2
150     , p_content_item_id  NUMBER
151     , p_label_code  VARCHAR2
152     , x_return_status out nocopy  VARCHAR2
153     , x_msg_count out nocopy  NUMBER
154     , x_msg_data out nocopy  VARCHAR2
155     , p7_a0 out nocopy  NUMBER
156     , p7_a1 out nocopy  NUMBER
157     , p7_a2 out nocopy  DATE
158     , p7_a3 out nocopy  DATE
159     , p7_a4 out nocopy  VARCHAR2
160     , p7_a5 out nocopy  VARCHAR2
161     , p7_a6 out nocopy  VARCHAR2
162     , p7_a7 out nocopy  VARCHAR2
163     , p7_a8 out nocopy  VARCHAR2
164     , p7_a9 out nocopy  VARCHAR2
165     , p7_a10 out nocopy  NUMBER
166     , p7_a11 out nocopy  JTF_VARCHAR2_TABLE_300
167     , p7_a12 out nocopy  JTF_NUMBER_TABLE
168     , p7_a13 out nocopy  JTF_VARCHAR2_TABLE_100
169     , p7_a14 out nocopy  JTF_VARCHAR2_TABLE_300
170     , p7_a15 out nocopy  VARCHAR2
171     , p7_a16 out nocopy  VARCHAR2
172     , p7_a17 out nocopy  CLOB
173     , p7_a18 out nocopy  JTF_VARCHAR2_TABLE_100
174     , p7_a19 out nocopy  JTF_NUMBER_TABLE
175   );
176 end ibc_citem_runtime_pub_w;