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

Source


1 package ahl_ltp_reqst_matrl_pub_w AUTHID CURRENT_USER as
2   /* $Header: AHLWRMTS.pls 115.10 2003/10/29 22:24:33 ssurapan noship $ */
3   procedure rosetta_table_copy_in_p3(t out nocopy ahl_ltp_reqst_matrl_pub.schedule_mr_tbl, a0 JTF_NUMBER_TABLE
4     , a1 JTF_NUMBER_TABLE
5     , a2 JTF_NUMBER_TABLE
6     , a3 JTF_NUMBER_TABLE
7     , a4 JTF_VARCHAR2_TABLE_100
8     , a5 JTF_NUMBER_TABLE
9     , a6 JTF_NUMBER_TABLE
10     , a7 JTF_VARCHAR2_TABLE_100
11     , a8 JTF_NUMBER_TABLE
12     , a9 JTF_DATE_TABLE
13     , a10 JTF_NUMBER_TABLE
14     , a11 JTF_NUMBER_TABLE
15     , a12 JTF_NUMBER_TABLE
16     , a13 JTF_NUMBER_TABLE
17     , a14 JTF_NUMBER_TABLE
18     , a15 JTF_VARCHAR2_TABLE_100
19     , a16 JTF_DATE_TABLE
20     , a17 JTF_NUMBER_TABLE
21     , a18 JTF_VARCHAR2_TABLE_100
22     , a19 JTF_NUMBER_TABLE
23     , a20 JTF_VARCHAR2_TABLE_100
24     , a21 JTF_NUMBER_TABLE
25     , a22 JTF_NUMBER_TABLE
26     , a23 JTF_VARCHAR2_TABLE_4000
27     , a24 JTF_NUMBER_TABLE
28     , a25 JTF_NUMBER_TABLE
29     , a26 JTF_VARCHAR2_TABLE_100
30     , a27 JTF_NUMBER_TABLE
31     , a28 JTF_NUMBER_TABLE
32     , a29 JTF_VARCHAR2_TABLE_100
33     );
34   procedure rosetta_table_copy_out_p3(t ahl_ltp_reqst_matrl_pub.schedule_mr_tbl, a0 out nocopy JTF_NUMBER_TABLE
35     , a1 out nocopy JTF_NUMBER_TABLE
36     , a2 out nocopy JTF_NUMBER_TABLE
37     , a3 out nocopy JTF_NUMBER_TABLE
38     , a4 out nocopy JTF_VARCHAR2_TABLE_100
39     , a5 out nocopy JTF_NUMBER_TABLE
40     , a6 out nocopy JTF_NUMBER_TABLE
41     , a7 out nocopy JTF_VARCHAR2_TABLE_100
42     , a8 out nocopy JTF_NUMBER_TABLE
43     , a9 out nocopy JTF_DATE_TABLE
44     , a10 out nocopy JTF_NUMBER_TABLE
45     , a11 out nocopy JTF_NUMBER_TABLE
46     , a12 out nocopy JTF_NUMBER_TABLE
47     , a13 out nocopy JTF_NUMBER_TABLE
48     , a14 out nocopy JTF_NUMBER_TABLE
49     , a15 out nocopy JTF_VARCHAR2_TABLE_100
50     , a16 out nocopy JTF_DATE_TABLE
51     , a17 out nocopy JTF_NUMBER_TABLE
52     , a18 out nocopy JTF_VARCHAR2_TABLE_100
53     , a19 out nocopy JTF_NUMBER_TABLE
54     , a20 out nocopy JTF_VARCHAR2_TABLE_100
55     , a21 out nocopy JTF_NUMBER_TABLE
56     , a22 out nocopy JTF_NUMBER_TABLE
57     , a23 out nocopy JTF_VARCHAR2_TABLE_4000
58     , a24 out nocopy JTF_NUMBER_TABLE
59     , a25 out nocopy JTF_NUMBER_TABLE
60     , a26 out nocopy JTF_VARCHAR2_TABLE_100
61     , a27 out nocopy JTF_NUMBER_TABLE
62     , a28 out nocopy JTF_NUMBER_TABLE
63     , a29 out nocopy JTF_VARCHAR2_TABLE_100
64     );
65 
66   procedure rosetta_table_copy_in_p4(t out nocopy ahl_ltp_reqst_matrl_pub.task_details_tbl, a0 JTF_NUMBER_TABLE
67     , a1 JTF_NUMBER_TABLE
68     , a2 JTF_NUMBER_TABLE
69     , a3 JTF_VARCHAR2_TABLE_100
70     , a4 JTF_NUMBER_TABLE
71     , a5 JTF_NUMBER_TABLE
72     , a6 JTF_NUMBER_TABLE
73     , a7 JTF_VARCHAR2_TABLE_100
74     , a8 JTF_DATE_TABLE
75     , a9 JTF_NUMBER_TABLE
76     , a10 JTF_NUMBER_TABLE
77     , a11 JTF_NUMBER_TABLE
78     , a12 JTF_VARCHAR2_TABLE_100
79     , a13 JTF_DATE_TABLE
80     , a14 JTF_NUMBER_TABLE
81     );
82   procedure rosetta_table_copy_out_p4(t ahl_ltp_reqst_matrl_pub.task_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
83     , a1 out nocopy JTF_NUMBER_TABLE
84     , a2 out nocopy JTF_NUMBER_TABLE
85     , a3 out nocopy JTF_VARCHAR2_TABLE_100
86     , a4 out nocopy JTF_NUMBER_TABLE
87     , a5 out nocopy JTF_NUMBER_TABLE
88     , a6 out nocopy JTF_NUMBER_TABLE
89     , a7 out nocopy JTF_VARCHAR2_TABLE_100
90     , a8 out nocopy JTF_DATE_TABLE
91     , a9 out nocopy JTF_NUMBER_TABLE
92     , a10 out nocopy JTF_NUMBER_TABLE
93     , a11 out nocopy JTF_NUMBER_TABLE
94     , a12 out nocopy JTF_VARCHAR2_TABLE_100
95     , a13 out nocopy JTF_DATE_TABLE
96     , a14 out nocopy JTF_NUMBER_TABLE
97     );
98 
99   procedure rosetta_table_copy_in_p5(t out nocopy ahl_ltp_reqst_matrl_pub.planned_materials_tbl, a0 JTF_NUMBER_TABLE
100     , a1 JTF_NUMBER_TABLE
101     , a2 JTF_NUMBER_TABLE
102     , a3 JTF_NUMBER_TABLE
103     , a4 JTF_VARCHAR2_TABLE_100
104     , a5 JTF_NUMBER_TABLE
105     , a6 JTF_VARCHAR2_TABLE_100
106     , a7 JTF_DATE_TABLE
107     , a8 JTF_NUMBER_TABLE
108     , a9 JTF_NUMBER_TABLE
109     , a10 JTF_NUMBER_TABLE
110     );
111   procedure rosetta_table_copy_out_p5(t ahl_ltp_reqst_matrl_pub.planned_materials_tbl, a0 out nocopy JTF_NUMBER_TABLE
112     , a1 out nocopy JTF_NUMBER_TABLE
113     , a2 out nocopy JTF_NUMBER_TABLE
114     , a3 out nocopy JTF_NUMBER_TABLE
115     , a4 out nocopy JTF_VARCHAR2_TABLE_100
116     , a5 out nocopy JTF_NUMBER_TABLE
117     , a6 out nocopy JTF_VARCHAR2_TABLE_100
118     , a7 out nocopy JTF_DATE_TABLE
119     , a8 out nocopy JTF_NUMBER_TABLE
120     , a9 out nocopy JTF_NUMBER_TABLE
121     , a10 out nocopy JTF_NUMBER_TABLE
122     );
123 
124   procedure update_planned_materials(p_api_version  NUMBER
125     , p_init_msg_list  VARCHAR2
126     , p_commit  VARCHAR2
127     , p_validation_level  NUMBER
128     , p_module_type  VARCHAR2
129     , p5_a0 JTF_NUMBER_TABLE
130     , p5_a1 JTF_NUMBER_TABLE
131     , p5_a2 JTF_NUMBER_TABLE
132     , p5_a3 JTF_NUMBER_TABLE
133     , p5_a4 JTF_VARCHAR2_TABLE_100
134     , p5_a5 JTF_NUMBER_TABLE
135     , p5_a6 JTF_VARCHAR2_TABLE_100
136     , p5_a7 JTF_DATE_TABLE
137     , p5_a8 JTF_NUMBER_TABLE
138     , p5_a9 JTF_NUMBER_TABLE
139     , p5_a10 JTF_NUMBER_TABLE
140     , x_return_status out nocopy  VARCHAR2
141     , x_msg_count out nocopy  NUMBER
142     , x_msg_data out nocopy  VARCHAR2
143   );
144 end ahl_ltp_reqst_matrl_pub_w;