[Home] [Help]
PACKAGE: APPS.AHL_LTP_RESRC_LEVL_PUB_W
Source
1 package ahl_ltp_resrc_levl_pub_w as
2 /* $Header: AHLWRLGS.pls 120.1 2006/05/04 07:38 anraj noship $ */
3 procedure rosetta_table_copy_in_p3(t out nocopy ahl_ltp_resrc_levl_pub.aval_resources_tbl, a0 JTF_VARCHAR2_TABLE_100
4 , a1 JTF_DATE_TABLE
5 , a2 JTF_DATE_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_VARCHAR2_TABLE_100
12 , a9 JTF_VARCHAR2_TABLE_300
13 );
14 procedure rosetta_table_copy_out_p3(t ahl_ltp_resrc_levl_pub.aval_resources_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
15 , a1 out nocopy JTF_DATE_TABLE
16 , a2 out nocopy JTF_DATE_TABLE
17 , a3 out nocopy JTF_NUMBER_TABLE
18 , a4 out nocopy JTF_VARCHAR2_TABLE_100
19 , a5 out nocopy JTF_NUMBER_TABLE
20 , a6 out nocopy JTF_NUMBER_TABLE
21 , a7 out nocopy JTF_VARCHAR2_TABLE_100
22 , a8 out nocopy JTF_VARCHAR2_TABLE_100
23 , a9 out nocopy JTF_VARCHAR2_TABLE_300
24 );
25
26 procedure rosetta_table_copy_in_p4(t out nocopy ahl_ltp_resrc_levl_pub.resource_con_tbl, a0 JTF_NUMBER_TABLE
27 , a1 JTF_NUMBER_TABLE
28 , a2 JTF_VARCHAR2_TABLE_100
29 , a3 JTF_VARCHAR2_TABLE_100
30 , a4 JTF_VARCHAR2_TABLE_100
31 , a5 JTF_VARCHAR2_TABLE_100
32 , a6 JTF_NUMBER_TABLE
33 , a7 JTF_NUMBER_TABLE
34 , a8 JTF_NUMBER_TABLE
35 );
36 procedure rosetta_table_copy_out_p4(t ahl_ltp_resrc_levl_pub.resource_con_tbl, a0 out nocopy JTF_NUMBER_TABLE
37 , a1 out nocopy JTF_NUMBER_TABLE
38 , a2 out nocopy JTF_VARCHAR2_TABLE_100
39 , a3 out nocopy JTF_VARCHAR2_TABLE_100
40 , a4 out nocopy JTF_VARCHAR2_TABLE_100
41 , a5 out nocopy JTF_VARCHAR2_TABLE_100
42 , a6 out nocopy JTF_NUMBER_TABLE
43 , a7 out nocopy JTF_NUMBER_TABLE
44 , a8 out nocopy JTF_NUMBER_TABLE
45 );
46
47 procedure derive_resource_capacity(p_api_version NUMBER
48 , p_init_msg_list VARCHAR2
49 , p_commit VARCHAR2
50 , p_validation_level NUMBER
51 , p_module_type VARCHAR2
52 , p5_a0 VARCHAR2
53 , p5_a1 VARCHAR2
54 , p5_a2 NUMBER
55 , p5_a3 NUMBER
56 , p5_a4 DATE
57 , p5_a5 DATE
58 , p5_a6 DATE
59 , p5_a7 DATE
60 , p5_a8 VARCHAR2
61 , p5_a9 NUMBER
62 , p5_a10 NUMBER
63 , p5_a11 NUMBER
64 , p5_a12 VARCHAR2
65 , p5_a13 VARCHAR2
66 , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
67 , p6_a1 out nocopy JTF_DATE_TABLE
68 , p6_a2 out nocopy JTF_DATE_TABLE
69 , p6_a3 out nocopy JTF_NUMBER_TABLE
70 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
71 , p6_a5 out nocopy JTF_NUMBER_TABLE
72 , p6_a6 out nocopy JTF_NUMBER_TABLE
73 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
74 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
75 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_300
76 , x_return_status out nocopy VARCHAR2
77 , x_msg_count out nocopy NUMBER
78 , x_msg_data out nocopy VARCHAR2
79 );
80 procedure derive_resource_consum(p_api_version NUMBER
81 , p_init_msg_list VARCHAR2
82 , p_commit VARCHAR2
83 , p_validation_level NUMBER
84 , p_module_type VARCHAR2
85 , p5_a0 VARCHAR2
86 , p5_a1 VARCHAR2
87 , p5_a2 NUMBER
88 , p5_a3 NUMBER
89 , p5_a4 DATE
90 , p5_a5 DATE
91 , p5_a6 DATE
92 , p5_a7 DATE
93 , p5_a8 VARCHAR2
94 , p5_a9 NUMBER
95 , p5_a10 NUMBER
96 , p5_a11 NUMBER
97 , p5_a12 VARCHAR2
98 , p5_a13 VARCHAR2
99 , p6_a0 out nocopy JTF_NUMBER_TABLE
100 , p6_a1 out nocopy JTF_NUMBER_TABLE
101 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
102 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
103 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
104 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
105 , p6_a6 out nocopy JTF_NUMBER_TABLE
106 , p6_a7 out nocopy JTF_NUMBER_TABLE
107 , p6_a8 out nocopy JTF_NUMBER_TABLE
108 , x_return_status out nocopy VARCHAR2
109 , x_msg_count out nocopy NUMBER
110 , x_msg_data out nocopy VARCHAR2
111 );
112 end ahl_ltp_resrc_levl_pub_w;