[Home] [Help]
PACKAGE: APPS.CS_TM_LABOR_SCHEDULE_PVT_W
Source
1 package cs_tm_labor_schedule_pvt_w AUTHID CURRENT_USER as
2 /* $Header: cstmlbwshs.pls 120.0 2012/01/03 07:40:08 shachoud noship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy cs_tm_labor_schedule_pvt.tm_schedule_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_DATE_TABLE
6 , a3 JTF_DATE_TABLE
7 , a4 JTF_VARCHAR2_TABLE_100
8 , a5 JTF_VARCHAR2_TABLE_100
9 , a6 JTF_VARCHAR2_TABLE_100
10 , a7 JTF_VARCHAR2_TABLE_100
11 , a8 JTF_VARCHAR2_TABLE_100
12 , a9 JTF_VARCHAR2_TABLE_100
13 , a10 JTF_VARCHAR2_TABLE_100
14 , a11 JTF_VARCHAR2_TABLE_100
15 , a12 JTF_NUMBER_TABLE
16 , a13 JTF_VARCHAR2_TABLE_100
17 , a14 JTF_VARCHAR2_TABLE_300
18 , a15 JTF_VARCHAR2_TABLE_300
19 , a16 JTF_VARCHAR2_TABLE_300
20 , a17 JTF_VARCHAR2_TABLE_300
21 , a18 JTF_VARCHAR2_TABLE_300
22 , a19 JTF_VARCHAR2_TABLE_300
23 , a20 JTF_VARCHAR2_TABLE_300
24 , a21 JTF_VARCHAR2_TABLE_300
25 , a22 JTF_VARCHAR2_TABLE_300
26 , a23 JTF_VARCHAR2_TABLE_300
27 , a24 JTF_VARCHAR2_TABLE_300
28 , a25 JTF_VARCHAR2_TABLE_300
29 , a26 JTF_VARCHAR2_TABLE_300
30 , a27 JTF_VARCHAR2_TABLE_300
31 , a28 JTF_VARCHAR2_TABLE_300
32 );
33 procedure rosetta_table_copy_out_p1(t cs_tm_labor_schedule_pvt.tm_schedule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34 , a1 out nocopy JTF_NUMBER_TABLE
35 , a2 out nocopy JTF_DATE_TABLE
36 , a3 out nocopy JTF_DATE_TABLE
37 , a4 out nocopy JTF_VARCHAR2_TABLE_100
38 , a5 out nocopy JTF_VARCHAR2_TABLE_100
39 , a6 out nocopy JTF_VARCHAR2_TABLE_100
40 , a7 out nocopy JTF_VARCHAR2_TABLE_100
41 , a8 out nocopy JTF_VARCHAR2_TABLE_100
42 , a9 out nocopy JTF_VARCHAR2_TABLE_100
43 , a10 out nocopy JTF_VARCHAR2_TABLE_100
44 , a11 out nocopy JTF_VARCHAR2_TABLE_100
45 , a12 out nocopy JTF_NUMBER_TABLE
46 , a13 out nocopy JTF_VARCHAR2_TABLE_100
47 , a14 out nocopy JTF_VARCHAR2_TABLE_300
48 , a15 out nocopy JTF_VARCHAR2_TABLE_300
49 , a16 out nocopy JTF_VARCHAR2_TABLE_300
50 , a17 out nocopy JTF_VARCHAR2_TABLE_300
51 , a18 out nocopy JTF_VARCHAR2_TABLE_300
52 , a19 out nocopy JTF_VARCHAR2_TABLE_300
53 , a20 out nocopy JTF_VARCHAR2_TABLE_300
54 , a21 out nocopy JTF_VARCHAR2_TABLE_300
55 , a22 out nocopy JTF_VARCHAR2_TABLE_300
56 , a23 out nocopy JTF_VARCHAR2_TABLE_300
57 , a24 out nocopy JTF_VARCHAR2_TABLE_300
58 , a25 out nocopy JTF_VARCHAR2_TABLE_300
59 , a26 out nocopy JTF_VARCHAR2_TABLE_300
60 , a27 out nocopy JTF_VARCHAR2_TABLE_300
61 , a28 out nocopy JTF_VARCHAR2_TABLE_300
62 );
63
64 procedure rosetta_table_copy_in_p3(t out nocopy cs_tm_labor_schedule_pvt.tm_coverage_tbl_type, a0 JTF_DATE_TABLE
65 , a1 JTF_DATE_TABLE
66 , a2 JTF_NUMBER_TABLE
67 );
68 procedure rosetta_table_copy_out_p3(t cs_tm_labor_schedule_pvt.tm_coverage_tbl_type, a0 out nocopy JTF_DATE_TABLE
69 , a1 out nocopy JTF_DATE_TABLE
70 , a2 out nocopy JTF_NUMBER_TABLE
71 );
72
73 procedure validate_schedule_overlap(p0_a0 JTF_NUMBER_TABLE
74 , p0_a1 JTF_NUMBER_TABLE
75 , p0_a2 JTF_DATE_TABLE
76 , p0_a3 JTF_DATE_TABLE
77 , p0_a4 JTF_VARCHAR2_TABLE_100
78 , p0_a5 JTF_VARCHAR2_TABLE_100
79 , p0_a6 JTF_VARCHAR2_TABLE_100
80 , p0_a7 JTF_VARCHAR2_TABLE_100
81 , p0_a8 JTF_VARCHAR2_TABLE_100
82 , p0_a9 JTF_VARCHAR2_TABLE_100
83 , p0_a10 JTF_VARCHAR2_TABLE_100
84 , p0_a11 JTF_VARCHAR2_TABLE_100
85 , p0_a12 JTF_NUMBER_TABLE
86 , p0_a13 JTF_VARCHAR2_TABLE_100
87 , p0_a14 JTF_VARCHAR2_TABLE_300
88 , p0_a15 JTF_VARCHAR2_TABLE_300
89 , p0_a16 JTF_VARCHAR2_TABLE_300
90 , p0_a17 JTF_VARCHAR2_TABLE_300
91 , p0_a18 JTF_VARCHAR2_TABLE_300
92 , p0_a19 JTF_VARCHAR2_TABLE_300
93 , p0_a20 JTF_VARCHAR2_TABLE_300
94 , p0_a21 JTF_VARCHAR2_TABLE_300
95 , p0_a22 JTF_VARCHAR2_TABLE_300
96 , p0_a23 JTF_VARCHAR2_TABLE_300
97 , p0_a24 JTF_VARCHAR2_TABLE_300
98 , p0_a25 JTF_VARCHAR2_TABLE_300
99 , p0_a26 JTF_VARCHAR2_TABLE_300
100 , p0_a27 JTF_VARCHAR2_TABLE_300
101 , p0_a28 JTF_VARCHAR2_TABLE_300
102 , x_return_status out nocopy VARCHAR2
103 , x_msg_count out nocopy NUMBER
104 , x_msg_data out nocopy VARCHAR2
105 , p_api_version NUMBER
106 , p_init_msg_list VARCHAR2
107 );
108 procedure validate_schedule_missing(p0_a0 JTF_NUMBER_TABLE
109 , p0_a1 JTF_NUMBER_TABLE
110 , p0_a2 JTF_DATE_TABLE
111 , p0_a3 JTF_DATE_TABLE
112 , p0_a4 JTF_VARCHAR2_TABLE_100
113 , p0_a5 JTF_VARCHAR2_TABLE_100
114 , p0_a6 JTF_VARCHAR2_TABLE_100
115 , p0_a7 JTF_VARCHAR2_TABLE_100
116 , p0_a8 JTF_VARCHAR2_TABLE_100
117 , p0_a9 JTF_VARCHAR2_TABLE_100
118 , p0_a10 JTF_VARCHAR2_TABLE_100
119 , p0_a11 JTF_VARCHAR2_TABLE_100
120 , p0_a12 JTF_NUMBER_TABLE
121 , p0_a13 JTF_VARCHAR2_TABLE_100
122 , p0_a14 JTF_VARCHAR2_TABLE_300
123 , p0_a15 JTF_VARCHAR2_TABLE_300
124 , p0_a16 JTF_VARCHAR2_TABLE_300
125 , p0_a17 JTF_VARCHAR2_TABLE_300
126 , p0_a18 JTF_VARCHAR2_TABLE_300
127 , p0_a19 JTF_VARCHAR2_TABLE_300
128 , p0_a20 JTF_VARCHAR2_TABLE_300
129 , p0_a21 JTF_VARCHAR2_TABLE_300
130 , p0_a22 JTF_VARCHAR2_TABLE_300
131 , p0_a23 JTF_VARCHAR2_TABLE_300
132 , p0_a24 JTF_VARCHAR2_TABLE_300
133 , p0_a25 JTF_VARCHAR2_TABLE_300
134 , p0_a26 JTF_VARCHAR2_TABLE_300
135 , p0_a27 JTF_VARCHAR2_TABLE_300
136 , p0_a28 JTF_VARCHAR2_TABLE_300
137 , x_return_status out nocopy VARCHAR2
138 , x_msg_count out nocopy NUMBER
139 , x_msg_data out nocopy VARCHAR2
140 , p_api_version NUMBER
141 , p_init_msg_list VARCHAR2
142 );
143 procedure get_labor_coverages(p_business_process_id NUMBER
144 , p_activity_start_date_time date
145 , p_activity_end_date_time date
146 , p3_a0 out nocopy JTF_DATE_TABLE
147 , p3_a1 out nocopy JTF_DATE_TABLE
148 , p3_a2 out nocopy JTF_NUMBER_TABLE
149 , x_return_status out nocopy VARCHAR2
150 , x_msg_count out nocopy NUMBER
151 , x_msg_data out nocopy VARCHAR2
152 , p_api_version NUMBER
153 , p_init_msg_list VARCHAR2
154 );
155 end cs_tm_labor_schedule_pvt_w;