DBA Data[Home] [Help]

APPS.JTF_CAL_PVT_W dependencies on JTF_CAL_PVT

Line 1: package body jtf_cal_pvt_w as

1: package body jtf_cal_pvt_w as
2: /* $Header: jtfwhcb.pls 120.2 2006/04/28 01:33 deeprao 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: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 16: procedure rosetta_table_copy_in_p1(t out nocopy jtf_cal_pvt.callsttbltype, a0 JTF_NUMBER_TABLE

12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy jtf_cal_pvt.callsttbltype, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_400
19: , a3 JTF_VARCHAR2_TABLE_100
20: ) as

Line 41: procedure rosetta_table_copy_out_p1(t jtf_cal_pvt.callsttbltype, a0 out nocopy JTF_NUMBER_TABLE

37: end loop;
38: end if;
39: end if;
40: end rosetta_table_copy_in_p1;
41: procedure rosetta_table_copy_out_p1(t jtf_cal_pvt.callsttbltype, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_VARCHAR2_TABLE_100
43: , a2 out nocopy JTF_VARCHAR2_TABLE_400
44: , a3 out nocopy JTF_VARCHAR2_TABLE_100
45: ) as

Line 80: procedure rosetta_table_copy_in_p3(t out nocopy jtf_cal_pvt.weektimepreftbltype, a0 JTF_NUMBER_TABLE

76: end if;
77: end if;
78: end rosetta_table_copy_out_p1;
79:
80: procedure rosetta_table_copy_in_p3(t out nocopy jtf_cal_pvt.weektimepreftbltype, a0 JTF_NUMBER_TABLE
81: , a1 JTF_NUMBER_TABLE
82: ) as
83: ddindx binary_integer; indx binary_integer;
84: begin

Line 101: procedure rosetta_table_copy_out_p3(t jtf_cal_pvt.weektimepreftbltype, a0 out nocopy JTF_NUMBER_TABLE

97: end loop;
98: end if;
99: end if;
100: end rosetta_table_copy_in_p3;
101: procedure rosetta_table_copy_out_p3(t jtf_cal_pvt.weektimepreftbltype, a0 out nocopy JTF_NUMBER_TABLE
102: , a1 out nocopy JTF_NUMBER_TABLE
103: ) as
104: ddindx binary_integer; indx binary_integer;
105: begin

Line 130: procedure rosetta_table_copy_in_p7(t out nocopy jtf_cal_pvt.queryouttab, a0 JTF_NUMBER_TABLE

126: end if;
127: end if;
128: end rosetta_table_copy_out_p3;
129:
130: procedure rosetta_table_copy_in_p7(t out nocopy jtf_cal_pvt.queryouttab, a0 JTF_NUMBER_TABLE
131: , a1 JTF_NUMBER_TABLE
132: , a2 JTF_VARCHAR2_TABLE_100
133: , a3 JTF_VARCHAR2_TABLE_100
134: , a4 JTF_NUMBER_TABLE

Line 193: procedure rosetta_table_copy_out_p7(t jtf_cal_pvt.queryouttab, a0 out nocopy JTF_NUMBER_TABLE

189: end loop;
190: end if;
191: end if;
192: end rosetta_table_copy_in_p7;
193: procedure rosetta_table_copy_out_p7(t jtf_cal_pvt.queryouttab, a0 out nocopy JTF_NUMBER_TABLE
194: , a1 out nocopy JTF_NUMBER_TABLE
195: , a2 out nocopy JTF_VARCHAR2_TABLE_100
196: , a3 out nocopy JTF_VARCHAR2_TABLE_100
197: , a4 out nocopy JTF_NUMBER_TABLE

Line 343: ddx_calendarlist jtf_cal_pvt.callsttbltype;

339: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
340: )
341:
342: as
343: ddx_calendarlist jtf_cal_pvt.callsttbltype;
344: ddindx binary_integer; indx binary_integer;
345: begin
346:
347: -- copy data to the local IN or IN-OUT args, if any

Line 359: jtf_cal_pvt.getcalendarlist(p_api_version,

355:
356:
357:
358: -- here's the delegated call to the old PL/SQL routine
359: jtf_cal_pvt.getcalendarlist(p_api_version,
360: p_init_msg_list,
361: p_validation_level,
362: x_return_status,
363: x_msg_count,

Line 380: jtf_cal_pvt_w.rosetta_table_copy_out_p1(ddx_calendarlist, p9_a0

376:
377:
378:
379:
380: jtf_cal_pvt_w.rosetta_table_copy_out_p1(ddx_calendarlist, p9_a0
381: , p9_a1
382: , p9_a2
383: , p9_a3
384: );

Line 447: ddp_input jtf_cal_pvt.queryin;

443: , p8_a20 out nocopy VARCHAR2
444: )
445:
446: as
447: ddp_input jtf_cal_pvt.queryin;
448: ddx_displayitems jtf_cal_pvt.queryouttab;
449: ddx_preferences jtf_cal_pvt.preference;
450: ddindx binary_integer; indx binary_integer;
451: begin

Line 448: ddx_displayitems jtf_cal_pvt.queryouttab;

444: )
445:
446: as
447: ddp_input jtf_cal_pvt.queryin;
448: ddx_displayitems jtf_cal_pvt.queryouttab;
449: ddx_preferences jtf_cal_pvt.preference;
450: ddindx binary_integer; indx binary_integer;
451: begin
452:

Line 449: ddx_preferences jtf_cal_pvt.preference;

445:
446: as
447: ddp_input jtf_cal_pvt.queryin;
448: ddx_displayitems jtf_cal_pvt.queryouttab;
449: ddx_preferences jtf_cal_pvt.preference;
450: ddindx binary_integer; indx binary_integer;
451: begin
452:
453: -- copy data to the local IN or IN-OUT args, if any

Line 471: jtf_cal_pvt.getview(p_api_version,

467:
468:
469:
470: -- here's the delegated call to the old PL/SQL routine
471: jtf_cal_pvt.getview(p_api_version,
472: p_init_msg_list,
473: p_validation_level,
474: x_return_status,
475: x_msg_count,

Line 489: jtf_cal_pvt_w.rosetta_table_copy_out_p7(ddx_displayitems, p7_a0

485:
486:
487:
488:
489: jtf_cal_pvt_w.rosetta_table_copy_out_p7(ddx_displayitems, p7_a0
490: , p7_a1
491: , p7_a2
492: , p7_a3
493: , p7_a4

Line 537: end jtf_cal_pvt_w;

533: p8_a19 := ddx_preferences.itemprefix;
534: p8_a20 := ddx_preferences.taskcustomersource;
535: end;
536:
537: end jtf_cal_pvt_w;