APPS.CN_GET_SRP_DATA_PVT_W dependencies on CN_GET_SRP_DATA_PVT

Line 1: package body cn_get_srp_data_pvt_w as

1: package body cn_get_srp_data_pvt_w as
2: /* $Header: cnwsfgtb.pls 115.6 2002/11/25 22:30:34 nkodkani ship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:

Line 13: procedure rosetta_table_copy_in_p1(t out nocopy cn_get_srp_data_pvt.srp_data_tbl_type, a0 JTF_NUMBER_TABLE

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy cn_get_srp_data_pvt.srp_data_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_400
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_DATE_TABLE
17: , a4 JTF_DATE_TABLE

Line 56: procedure rosetta_table_copy_out_p1(t cn_get_srp_data_pvt.srp_data_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

52: end loop;
53: end if;
54: end if;
55: end rosetta_table_copy_in_p1;
56: procedure rosetta_table_copy_out_p1(t cn_get_srp_data_pvt.srp_data_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
57: , a1 out nocopy JTF_VARCHAR2_TABLE_400
58: , a2 out nocopy JTF_VARCHAR2_TABLE_100
59: , a3 out nocopy JTF_DATE_TABLE
60: , a4 out nocopy JTF_DATE_TABLE

Line 156: ddx_srp_data cn_get_srp_data_pvt.srp_data_tbl_type;

152: , p0_a12 out nocopy JTF_VARCHAR2_TABLE_100
153: )
154:
155: as
156: ddx_srp_data cn_get_srp_data_pvt.srp_data_tbl_type;
157: ddindx binary_integer; indx binary_integer;
158: begin
159:
160: -- copy data to the local IN or IN-OUT args, if any

Line 163: cn_get_srp_data_pvt.get_srp_list(ddx_srp_data);

159:
160: -- copy data to the local IN or IN-OUT args, if any
161:
162: -- here's the delegated call to the old PL/SQL routine
163: cn_get_srp_data_pvt.get_srp_list(ddx_srp_data);
164:
165: -- copy data back from the local variables to OUT or IN-OUT args, if any
166: cn_get_srp_data_pvt_w.rosetta_table_copy_out_p1(ddx_srp_data, p0_a0
167: , p0_a1

Line 166: cn_get_srp_data_pvt_w.rosetta_table_copy_out_p1(ddx_srp_data, p0_a0

162: -- here's the delegated call to the old PL/SQL routine
163: cn_get_srp_data_pvt.get_srp_list(ddx_srp_data);
164:
165: -- copy data back from the local variables to OUT or IN-OUT args, if any
166: cn_get_srp_data_pvt_w.rosetta_table_copy_out_p1(ddx_srp_data, p0_a0
167: , p0_a1
168: , p0_a2
169: , p0_a3
170: , p0_a4

Line 209: ddx_srp_data cn_get_srp_data_pvt.srp_data_tbl_type;

205: )
206:
207: as
208: ddp_date date;
209: ddx_srp_data cn_get_srp_data_pvt.srp_data_tbl_type;
210: ddindx binary_integer; indx binary_integer;
211: begin
212:
213: -- copy data to the local IN or IN-OUT args, if any

Line 227: cn_get_srp_data_pvt.search_srp_data(p_range_low,

223:
224:
225:
226: -- here's the delegated call to the old PL/SQL routine
227: cn_get_srp_data_pvt.search_srp_data(p_range_low,
228: p_range_high,
229: ddp_date,
230: p_search_name,
231: p_search_job,

Line 250: cn_get_srp_data_pvt_w.rosetta_table_copy_out_p1(ddx_srp_data, p10_a0

246:
247:
248:
249:
250: cn_get_srp_data_pvt_w.rosetta_table_copy_out_p1(ddx_srp_data, p10_a0
251: , p10_a1
252: , p10_a2
253: , p10_a3
254: , p10_a4

Line 283: ddx_srp_data cn_get_srp_data_pvt.srp_data_tbl_type;

279: , p1_a12 out nocopy JTF_VARCHAR2_TABLE_100
280: )
281:
282: as
283: ddx_srp_data cn_get_srp_data_pvt.srp_data_tbl_type;
284: ddindx binary_integer; indx binary_integer;
285: begin
286:
287: -- copy data to the local IN or IN-OUT args, if any

Line 291: cn_get_srp_data_pvt.get_srp_data(p_srp_id,

287: -- copy data to the local IN or IN-OUT args, if any
288:
289:
290: -- here's the delegated call to the old PL/SQL routine
291: cn_get_srp_data_pvt.get_srp_data(p_srp_id,
292: ddx_srp_data);
293:
294: -- copy data back from the local variables to OUT or IN-OUT args, if any
295:

Line 296: cn_get_srp_data_pvt_w.rosetta_table_copy_out_p1(ddx_srp_data, p1_a0

292: ddx_srp_data);
293:
294: -- copy data back from the local variables to OUT or IN-OUT args, if any
295:
296: cn_get_srp_data_pvt_w.rosetta_table_copy_out_p1(ddx_srp_data, p1_a0
297: , p1_a1
298: , p1_a2
299: , p1_a3
300: , p1_a4

Line 332: ddx_srp_data cn_get_srp_data_pvt.srp_data_tbl_type;

328: )
329:
330: as
331: ddp_date date;
332: ddx_srp_data cn_get_srp_data_pvt.srp_data_tbl_type;
333: ddindx binary_integer; indx binary_integer;
334: begin
335:
336: -- copy data to the local IN or IN-OUT args, if any

Line 343: cn_get_srp_data_pvt.get_managers(p_srp_id,

339:
340:
341:
342: -- here's the delegated call to the old PL/SQL routine
343: cn_get_srp_data_pvt.get_managers(p_srp_id,
344: ddp_date,
345: p_comp_group_id,
346: ddx_srp_data);
347:

Line 352: cn_get_srp_data_pvt_w.rosetta_table_copy_out_p1(ddx_srp_data, p3_a0

348: -- copy data back from the local variables to OUT or IN-OUT args, if any
349:
350:
351:
352: cn_get_srp_data_pvt_w.rosetta_table_copy_out_p1(ddx_srp_data, p3_a0
353: , p3_a1
354: , p3_a2
355: , p3_a3
356: , p3_a4

Line 368: end cn_get_srp_data_pvt_w;

364: , p3_a12
365: );
366: end;
367:
368: end cn_get_srp_data_pvt_w;