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

Source


1 package ibe_deliverable_grp_w AUTHID CURRENT_USER as
2   /* $Header: IBEGRDLS.pls 115.1 2002/12/18 07:08:26 schak ship $ */
3   procedure rosetta_table_copy_in_p1(t out nocopy ibe_deliverable_grp.deliverable_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_VARCHAR2_TABLE_100
5     , a2 JTF_VARCHAR2_TABLE_300
6     , a3 JTF_VARCHAR2_TABLE_100
7     , a4 JTF_VARCHAR2_TABLE_100
8     , a5 JTF_VARCHAR2_TABLE_300
9     , a6 JTF_VARCHAR2_TABLE_2000
10     , a7 JTF_NUMBER_TABLE
11     , a8 JTF_VARCHAR2_TABLE_100
12     );
13   procedure rosetta_table_copy_out_p1(t ibe_deliverable_grp.deliverable_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14     , a1 out nocopy JTF_VARCHAR2_TABLE_100
15     , a2 out nocopy JTF_VARCHAR2_TABLE_300
16     , a3 out nocopy JTF_VARCHAR2_TABLE_100
17     , a4 out nocopy JTF_VARCHAR2_TABLE_100
18     , a5 out nocopy JTF_VARCHAR2_TABLE_300
19     , a6 out nocopy JTF_VARCHAR2_TABLE_2000
20     , a7 out nocopy JTF_NUMBER_TABLE
21     , a8 out nocopy JTF_VARCHAR2_TABLE_100
22     );
23 
24   procedure rosetta_table_copy_in_p3(t out nocopy ibe_deliverable_grp.dlv_ath_tbl_type, a0 JTF_NUMBER_TABLE
25     , a1 JTF_VARCHAR2_TABLE_100
26     , a2 JTF_VARCHAR2_TABLE_300
27     , a3 JTF_VARCHAR2_TABLE_100
28     , a4 JTF_VARCHAR2_TABLE_100
29     , a5 JTF_VARCHAR2_TABLE_300
30     , a6 JTF_VARCHAR2_TABLE_2000
31     , a7 JTF_NUMBER_TABLE
32     , a8 JTF_VARCHAR2_TABLE_100
33     , a9 JTF_VARCHAR2_TABLE_300
34     , a10 JTF_NUMBER_TABLE
35     , a11 JTF_VARCHAR2_TABLE_100
36     );
37   procedure rosetta_table_copy_out_p3(t ibe_deliverable_grp.dlv_ath_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
38     , a1 out nocopy JTF_VARCHAR2_TABLE_100
39     , a2 out nocopy JTF_VARCHAR2_TABLE_300
40     , a3 out nocopy JTF_VARCHAR2_TABLE_100
41     , a4 out nocopy JTF_VARCHAR2_TABLE_100
42     , a5 out nocopy JTF_VARCHAR2_TABLE_300
43     , a6 out nocopy JTF_VARCHAR2_TABLE_2000
44     , a7 out nocopy JTF_NUMBER_TABLE
45     , a8 out nocopy JTF_VARCHAR2_TABLE_100
46     , a9 out nocopy JTF_VARCHAR2_TABLE_300
47     , a10 out nocopy JTF_NUMBER_TABLE
48     , a11 out nocopy JTF_VARCHAR2_TABLE_100
49     );
50 
51   procedure rosetta_table_copy_in_p5(t out nocopy ibe_deliverable_grp.dlv_id_ver_tbl_type, a0 JTF_NUMBER_TABLE
52     , a1 JTF_VARCHAR2_TABLE_300
53     , a2 JTF_NUMBER_TABLE
54     , a3 JTF_VARCHAR2_TABLE_100
55     );
56   procedure rosetta_table_copy_out_p5(t ibe_deliverable_grp.dlv_id_ver_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
57     , a1 out nocopy JTF_VARCHAR2_TABLE_300
58     , a2 out nocopy JTF_NUMBER_TABLE
59     , a3 out nocopy JTF_VARCHAR2_TABLE_100
60     );
61 
62   procedure rosetta_table_copy_in_p6(t out nocopy ibe_deliverable_grp.number_table, a0 JTF_NUMBER_TABLE);
63   procedure rosetta_table_copy_out_p6(t ibe_deliverable_grp.number_table, a0 out nocopy JTF_NUMBER_TABLE);
64 
65   procedure rosetta_table_copy_in_p7(t out nocopy ibe_deliverable_grp.varchar2_table_100, a0 JTF_VARCHAR2_TABLE_100);
66   procedure rosetta_table_copy_out_p7(t ibe_deliverable_grp.varchar2_table_100, a0 out nocopy JTF_VARCHAR2_TABLE_100);
67 
68   procedure rosetta_table_copy_in_p8(t out nocopy ibe_deliverable_grp.varchar2_table_300, a0 JTF_VARCHAR2_TABLE_300);
69   procedure rosetta_table_copy_out_p8(t ibe_deliverable_grp.varchar2_table_300, a0 out nocopy JTF_VARCHAR2_TABLE_300);
70 
71   procedure rosetta_table_copy_in_p9(t out nocopy ibe_deliverable_grp.varchar2_table_2000, a0 JTF_VARCHAR2_TABLE_2000);
72   procedure rosetta_table_copy_out_p9(t ibe_deliverable_grp.varchar2_table_2000, a0 out nocopy JTF_VARCHAR2_TABLE_2000);
73 
74   procedure list_deliverable(p_api_version  NUMBER
75     , p_init_msg_list  VARCHAR2
76     , x_return_status out nocopy  VARCHAR2
77     , x_msg_count out nocopy  NUMBER
78     , x_msg_data out nocopy  VARCHAR2
79     , p_item_type  VARCHAR2
80     , p_item_applicable_to  VARCHAR2
81     , p_search_type  VARCHAR2
82     , p_search_value  VARCHAR2
83     , p_start_id  NUMBER
84     , p_batch_size  NUMBER
85     , x_row_count out nocopy  NUMBER
86     , x_dlv_id_tbl out nocopy JTF_NUMBER_TABLE
87     , x_acc_name_tbl out nocopy JTF_VARCHAR2_TABLE_100
88     , x_dsp_name_tbl out nocopy JTF_VARCHAR2_TABLE_300
89     , x_item_type_tbl out nocopy JTF_VARCHAR2_TABLE_100
90     , x_appl_to_tbl out nocopy JTF_VARCHAR2_TABLE_100
91     , x_keyword_tbl out nocopy JTF_VARCHAR2_TABLE_300
92     , x_desc_tbl out nocopy JTF_VARCHAR2_TABLE_2000
93     , x_version_tbl out nocopy JTF_NUMBER_TABLE
94     , x_file_name_tbl out nocopy JTF_VARCHAR2_TABLE_300
95     , x_file_id_tbl out nocopy JTF_NUMBER_TABLE
96   );
97   procedure list_deliverable(p_api_version  NUMBER
98     , p_init_msg_list  VARCHAR2
99     , x_return_status out nocopy  VARCHAR2
100     , x_msg_count out nocopy  NUMBER
101     , x_msg_data out nocopy  VARCHAR2
102     , p_category_id  NUMBER
103     , p_item_type  VARCHAR2
104     , p_item_applicable_to  VARCHAR2
105     , p_search_type  VARCHAR2
106     , p_search_value  VARCHAR2
107     , p_start_id  NUMBER
108     , p_batch_size  NUMBER
109     , x_row_count out nocopy  NUMBER
110     , x_dlv_id_tbl out nocopy JTF_NUMBER_TABLE
111     , x_acc_name_tbl out nocopy JTF_VARCHAR2_TABLE_100
112     , x_dsp_name_tbl out nocopy JTF_VARCHAR2_TABLE_300
113     , x_item_type_tbl out nocopy JTF_VARCHAR2_TABLE_100
114     , x_appl_to_tbl out nocopy JTF_VARCHAR2_TABLE_100
115     , x_keyword_tbl out nocopy JTF_VARCHAR2_TABLE_300
116     , x_desc_tbl out nocopy JTF_VARCHAR2_TABLE_2000
117     , x_version_tbl out nocopy JTF_NUMBER_TABLE
118     , x_file_name_tbl out nocopy JTF_VARCHAR2_TABLE_300
119     , x_file_id_tbl out nocopy JTF_NUMBER_TABLE
120   );
121   procedure save_deliverable(p_api_version  NUMBER
122     , p_init_msg_list  VARCHAR2
123     , p_commit  VARCHAR2
124     , x_return_status out nocopy  VARCHAR2
125     , x_msg_count out nocopy  NUMBER
126     , x_msg_data out nocopy  VARCHAR2
127     , p6_a0 in out nocopy  NUMBER
128     , p6_a1 in out nocopy  VARCHAR2
129     , p6_a2 in out nocopy  VARCHAR2
130     , p6_a3 in out nocopy  VARCHAR2
131     , p6_a4 in out nocopy  VARCHAR2
132     , p6_a5 in out nocopy  VARCHAR2
133     , p6_a6 in out nocopy  VARCHAR2
134     , p6_a7 in out nocopy  NUMBER
135     , p6_a8 in out nocopy  VARCHAR2
136   );
137   procedure save_deliverable(p_api_version  NUMBER
138     , p_init_msg_list  VARCHAR2
139     , p_commit  VARCHAR2
140     , x_return_status out nocopy  VARCHAR2
141     , x_msg_count out nocopy  NUMBER
142     , x_msg_data out nocopy  VARCHAR2
143     , p6_a0 in out nocopy JTF_NUMBER_TABLE
144     , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
145     , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_300
146     , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_100
147     , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
148     , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_300
149     , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_2000
150     , p6_a7 in out nocopy JTF_NUMBER_TABLE
151     , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_100
152   );
153   procedure save_deliverable(p_api_version  NUMBER
154     , p_init_msg_list  VARCHAR2
155     , p_commit  VARCHAR2
156     , x_return_status out nocopy  VARCHAR2
157     , x_msg_count out nocopy  NUMBER
158     , x_msg_data out nocopy  VARCHAR2
159     , p6_a0 in out nocopy  NUMBER
160     , p6_a1 in out nocopy  VARCHAR2
161     , p6_a2 in out nocopy  VARCHAR2
162     , p6_a3 in out nocopy  VARCHAR2
163     , p6_a4 in out nocopy  VARCHAR2
164     , p6_a5 in out nocopy  VARCHAR2
165     , p6_a6 in out nocopy  VARCHAR2
166     , p6_a7 in out nocopy  NUMBER
167     , p6_a8 in out nocopy  VARCHAR2
168     , p6_a9 in out nocopy  VARCHAR2
169     , p6_a10 in out nocopy  NUMBER
170     , p6_a11 in out nocopy  VARCHAR2
171   );
172   procedure save_deliverable(p_api_version  NUMBER
173     , p_init_msg_list  VARCHAR2
174     , p_commit  VARCHAR2
175     , x_return_status out nocopy  VARCHAR2
176     , x_msg_count out nocopy  NUMBER
177     , x_msg_data out nocopy  VARCHAR2
178     , p6_a0 in out nocopy JTF_NUMBER_TABLE
179     , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
180     , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_300
181     , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_100
182     , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
183     , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_300
184     , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_2000
185     , p6_a7 in out nocopy JTF_NUMBER_TABLE
186     , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_100
187     , p6_a9 in out nocopy JTF_VARCHAR2_TABLE_300
188     , p6_a10 in out nocopy JTF_NUMBER_TABLE
189     , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_100
190   );
191   procedure delete_deliverable(p_api_version  NUMBER
192     , p_init_msg_list  VARCHAR2
193     , p_commit  VARCHAR2
194     , x_return_status out nocopy  VARCHAR2
195     , x_msg_count out nocopy  NUMBER
196     , x_msg_data out nocopy  VARCHAR2
197     , p6_a0 in out nocopy JTF_NUMBER_TABLE
198     , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_300
199     , p6_a2 in out nocopy JTF_NUMBER_TABLE
200     , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_100
201   );
202 end ibe_deliverable_grp_w;