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.

APPS.JTF_TASKS_PUB_W dependencies on JTF_TASKS_PUB

Line 1: package body jtf_tasks_pub_w as

1: package body jtf_tasks_pub_w as
2: /* $Header: jtfbtktb.pls 120.7 2006/04/26 04:26 knayyar 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_p6(t out nocopy jtf_tasks_pub.task_assign_tbl, a0 JTF_VARCHAR2_TABLE_100

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_p6(t out nocopy jtf_tasks_pub.task_assign_tbl, a0 JTF_VARCHAR2_TABLE_100
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_DATE_TABLE
19: , a3 JTF_DATE_TABLE
20: , a4 JTF_NUMBER_TABLE

Line 85: procedure rosetta_table_copy_out_p6(t jtf_tasks_pub.task_assign_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100

81: end loop;
82: end if;
83: end if;
84: end rosetta_table_copy_in_p6;
85: procedure rosetta_table_copy_out_p6(t jtf_tasks_pub.task_assign_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
86: , a1 out nocopy JTF_NUMBER_TABLE
87: , a2 out nocopy JTF_DATE_TABLE
88: , a3 out nocopy JTF_DATE_TABLE
89: , a4 out nocopy JTF_NUMBER_TABLE

Line 234: procedure rosetta_table_copy_in_p9(t out nocopy jtf_tasks_pub.task_depends_tbl, a0 JTF_NUMBER_TABLE

230: end if;
231: end if;
232: end rosetta_table_copy_out_p6;
233:
234: procedure rosetta_table_copy_in_p9(t out nocopy jtf_tasks_pub.task_depends_tbl, a0 JTF_NUMBER_TABLE
235: , a1 JTF_NUMBER_TABLE
236: , a2 JTF_VARCHAR2_TABLE_100
237: , a3 JTF_NUMBER_TABLE
238: , a4 JTF_VARCHAR2_TABLE_100

Line 263: procedure rosetta_table_copy_out_p9(t jtf_tasks_pub.task_depends_tbl, a0 out nocopy JTF_NUMBER_TABLE

259: end loop;
260: end if;
261: end if;
262: end rosetta_table_copy_in_p9;
263: procedure rosetta_table_copy_out_p9(t jtf_tasks_pub.task_depends_tbl, a0 out nocopy JTF_NUMBER_TABLE
264: , a1 out nocopy JTF_NUMBER_TABLE
265: , a2 out nocopy JTF_VARCHAR2_TABLE_100
266: , a3 out nocopy JTF_NUMBER_TABLE
267: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 312: procedure rosetta_table_copy_in_p12(t out nocopy jtf_tasks_pub.task_rsrc_req_tbl, a0 JTF_VARCHAR2_TABLE_100

308: end if;
309: end if;
310: end rosetta_table_copy_out_p9;
311:
312: procedure rosetta_table_copy_in_p12(t out nocopy jtf_tasks_pub.task_rsrc_req_tbl, a0 JTF_VARCHAR2_TABLE_100
313: , a1 JTF_NUMBER_TABLE
314: , a2 JTF_VARCHAR2_TABLE_100
315: ) as
316: ddindx binary_integer; indx binary_integer;

Line 335: procedure rosetta_table_copy_out_p12(t jtf_tasks_pub.task_rsrc_req_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100

331: end loop;
332: end if;
333: end if;
334: end rosetta_table_copy_in_p12;
335: procedure rosetta_table_copy_out_p12(t jtf_tasks_pub.task_rsrc_req_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
336: , a1 out nocopy JTF_NUMBER_TABLE
337: , a2 out nocopy JTF_VARCHAR2_TABLE_100
338: ) as
339: ddindx binary_integer; indx binary_integer;

Line 369: procedure rosetta_table_copy_in_p15(t out nocopy jtf_tasks_pub.task_refer_tbl, a0 JTF_VARCHAR2_TABLE_100

365: end if;
366: end if;
367: end rosetta_table_copy_out_p12;
368:
369: procedure rosetta_table_copy_in_p15(t out nocopy jtf_tasks_pub.task_refer_tbl, a0 JTF_VARCHAR2_TABLE_100
370: , a1 JTF_VARCHAR2_TABLE_100
371: , a2 JTF_VARCHAR2_TABLE_100
372: , a3 JTF_NUMBER_TABLE
373: , a4 JTF_VARCHAR2_TABLE_2000

Line 400: procedure rosetta_table_copy_out_p15(t jtf_tasks_pub.task_refer_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100

396: end loop;
397: end if;
398: end if;
399: end rosetta_table_copy_in_p15;
400: procedure rosetta_table_copy_out_p15(t jtf_tasks_pub.task_refer_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
401: , a1 out nocopy JTF_VARCHAR2_TABLE_100
402: , a2 out nocopy JTF_VARCHAR2_TABLE_100
403: , a3 out nocopy JTF_NUMBER_TABLE
404: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 454: procedure rosetta_table_copy_in_p20(t out nocopy jtf_tasks_pub.task_dates_tbl, a0 JTF_NUMBER_TABLE

450: end if;
451: end if;
452: end rosetta_table_copy_out_p15;
453:
454: procedure rosetta_table_copy_in_p20(t out nocopy jtf_tasks_pub.task_dates_tbl, a0 JTF_NUMBER_TABLE
455: , a1 JTF_VARCHAR2_TABLE_100
456: , a2 JTF_VARCHAR2_TABLE_100
457: , a3 JTF_DATE_TABLE
458: ) as

Line 479: procedure rosetta_table_copy_out_p20(t jtf_tasks_pub.task_dates_tbl, a0 out nocopy JTF_NUMBER_TABLE

475: end loop;
476: end if;
477: end if;
478: end rosetta_table_copy_in_p20;
479: procedure rosetta_table_copy_out_p20(t jtf_tasks_pub.task_dates_tbl, a0 out nocopy JTF_NUMBER_TABLE
480: , a1 out nocopy JTF_VARCHAR2_TABLE_100
481: , a2 out nocopy JTF_VARCHAR2_TABLE_100
482: , a3 out nocopy JTF_DATE_TABLE
483: ) as

Line 518: procedure rosetta_table_copy_in_p23(t out nocopy jtf_tasks_pub.task_notes_tbl, a0 JTF_NUMBER_TABLE

514: end if;
515: end if;
516: end rosetta_table_copy_out_p20;
517:
518: procedure rosetta_table_copy_in_p23(t out nocopy jtf_tasks_pub.task_notes_tbl, a0 JTF_NUMBER_TABLE
519: , a1 JTF_NUMBER_TABLE
520: , a2 JTF_VARCHAR2_TABLE_4000
521: , a3 JTF_VARCHAR2_TABLE_32767
522: , a4 JTF_VARCHAR2_TABLE_100

Line 585: procedure rosetta_table_copy_out_p23(t jtf_tasks_pub.task_notes_tbl, a0 out nocopy JTF_NUMBER_TABLE

581: end loop;
582: end if;
583: end if;
584: end rosetta_table_copy_in_p23;
585: procedure rosetta_table_copy_out_p23(t jtf_tasks_pub.task_notes_tbl, a0 out nocopy JTF_NUMBER_TABLE
586: , a1 out nocopy JTF_NUMBER_TABLE
587: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
588: , a3 out nocopy JTF_VARCHAR2_TABLE_32767
589: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 729: procedure rosetta_table_copy_in_p26(t out nocopy jtf_tasks_pub.task_contacts_tbl, a0 JTF_NUMBER_TABLE

725: end if;
726: end if;
727: end rosetta_table_copy_out_p23;
728:
729: procedure rosetta_table_copy_in_p26(t out nocopy jtf_tasks_pub.task_contacts_tbl, a0 JTF_NUMBER_TABLE
730: , a1 JTF_VARCHAR2_TABLE_100
731: , a2 JTF_VARCHAR2_TABLE_100
732: , a3 JTF_VARCHAR2_TABLE_100
733: ) as

Line 754: procedure rosetta_table_copy_out_p26(t jtf_tasks_pub.task_contacts_tbl, a0 out nocopy JTF_NUMBER_TABLE

750: end loop;
751: end if;
752: end if;
753: end rosetta_table_copy_in_p26;
754: procedure rosetta_table_copy_out_p26(t jtf_tasks_pub.task_contacts_tbl, a0 out nocopy JTF_NUMBER_TABLE
755: , a1 out nocopy JTF_VARCHAR2_TABLE_100
756: , a2 out nocopy JTF_VARCHAR2_TABLE_100
757: , a3 out nocopy JTF_VARCHAR2_TABLE_100
758: ) as

Line 793: procedure rosetta_table_copy_in_p31(t out nocopy jtf_tasks_pub.task_table_type, a0 JTF_NUMBER_TABLE

789: end if;
790: end if;
791: end rosetta_table_copy_out_p26;
792:
793: procedure rosetta_table_copy_in_p31(t out nocopy jtf_tasks_pub.task_table_type, a0 JTF_NUMBER_TABLE
794: , a1 JTF_VARCHAR2_TABLE_100
795: , a2 JTF_VARCHAR2_TABLE_100
796: , a3 JTF_VARCHAR2_TABLE_4000
797: , a4 JTF_NUMBER_TABLE

Line 974: procedure rosetta_table_copy_out_p31(t jtf_tasks_pub.task_table_type, a0 out nocopy JTF_NUMBER_TABLE

970: end loop;
971: end if;
972: end if;
973: end rosetta_table_copy_in_p31;
974: procedure rosetta_table_copy_out_p31(t jtf_tasks_pub.task_table_type, a0 out nocopy JTF_NUMBER_TABLE
975: , a1 out nocopy JTF_VARCHAR2_TABLE_100
976: , a2 out nocopy JTF_VARCHAR2_TABLE_100
977: , a3 out nocopy JTF_VARCHAR2_TABLE_4000
978: , a4 out nocopy JTF_NUMBER_TABLE

Line 1403: procedure rosetta_table_copy_in_p34(t out nocopy jtf_tasks_pub.sort_data, a0 JTF_VARCHAR2_TABLE_100

1399: end if;
1400: end if;
1401: end rosetta_table_copy_out_p31;
1402:
1403: procedure rosetta_table_copy_in_p34(t out nocopy jtf_tasks_pub.sort_data, a0 JTF_VARCHAR2_TABLE_100
1404: , a1 JTF_VARCHAR2_TABLE_100
1405: ) as
1406: ddindx binary_integer; indx binary_integer;
1407: begin

Line 1424: procedure rosetta_table_copy_out_p34(t jtf_tasks_pub.sort_data, a0 out nocopy JTF_VARCHAR2_TABLE_100

1420: end loop;
1421: end if;
1422: end if;
1423: end rosetta_table_copy_in_p34;
1424: procedure rosetta_table_copy_out_p34(t jtf_tasks_pub.sort_data, a0 out nocopy JTF_VARCHAR2_TABLE_100
1425: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1426: ) as
1427: ddindx binary_integer; indx binary_integer;
1428: begin

Line 1453: procedure rosetta_table_copy_in_p53(t out nocopy jtf_tasks_pub.task_details_tbl, a0 JTF_NUMBER_TABLE

1449: end if;
1450: end if;
1451: end rosetta_table_copy_out_p34;
1452:
1453: procedure rosetta_table_copy_in_p53(t out nocopy jtf_tasks_pub.task_details_tbl, a0 JTF_NUMBER_TABLE
1454: , a1 JTF_NUMBER_TABLE
1455: ) as
1456: ddindx binary_integer; indx binary_integer;
1457: begin

Line 1474: procedure rosetta_table_copy_out_p53(t jtf_tasks_pub.task_details_tbl, a0 out nocopy JTF_NUMBER_TABLE

1470: end loop;
1471: end if;
1472: end if;
1473: end rosetta_table_copy_in_p53;
1474: procedure rosetta_table_copy_out_p53(t jtf_tasks_pub.task_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
1475: , a1 out nocopy JTF_NUMBER_TABLE
1476: ) as
1477: ddindx binary_integer; indx binary_integer;
1478: begin

Line 1702: ddp_task_assign_tbl jtf_tasks_pub.task_assign_tbl;

1698: ddp_scheduled_start_date date;
1699: ddp_scheduled_end_date date;
1700: ddp_actual_start_date date;
1701: ddp_actual_end_date date;
1702: ddp_task_assign_tbl jtf_tasks_pub.task_assign_tbl;
1703: ddp_task_depends_tbl jtf_tasks_pub.task_depends_tbl;
1704: ddp_task_rsrc_req_tbl jtf_tasks_pub.task_rsrc_req_tbl;
1705: ddp_task_refer_tbl jtf_tasks_pub.task_refer_tbl;
1706: ddp_task_dates_tbl jtf_tasks_pub.task_dates_tbl;

Line 1703: ddp_task_depends_tbl jtf_tasks_pub.task_depends_tbl;

1699: ddp_scheduled_end_date date;
1700: ddp_actual_start_date date;
1701: ddp_actual_end_date date;
1702: ddp_task_assign_tbl jtf_tasks_pub.task_assign_tbl;
1703: ddp_task_depends_tbl jtf_tasks_pub.task_depends_tbl;
1704: ddp_task_rsrc_req_tbl jtf_tasks_pub.task_rsrc_req_tbl;
1705: ddp_task_refer_tbl jtf_tasks_pub.task_refer_tbl;
1706: ddp_task_dates_tbl jtf_tasks_pub.task_dates_tbl;
1707: ddp_task_notes_tbl jtf_tasks_pub.task_notes_tbl;

Line 1704: ddp_task_rsrc_req_tbl jtf_tasks_pub.task_rsrc_req_tbl;

1700: ddp_actual_start_date date;
1701: ddp_actual_end_date date;
1702: ddp_task_assign_tbl jtf_tasks_pub.task_assign_tbl;
1703: ddp_task_depends_tbl jtf_tasks_pub.task_depends_tbl;
1704: ddp_task_rsrc_req_tbl jtf_tasks_pub.task_rsrc_req_tbl;
1705: ddp_task_refer_tbl jtf_tasks_pub.task_refer_tbl;
1706: ddp_task_dates_tbl jtf_tasks_pub.task_dates_tbl;
1707: ddp_task_notes_tbl jtf_tasks_pub.task_notes_tbl;
1708: ddp_task_recur_rec jtf_tasks_pub.task_recur_rec;

Line 1705: ddp_task_refer_tbl jtf_tasks_pub.task_refer_tbl;

1701: ddp_actual_end_date date;
1702: ddp_task_assign_tbl jtf_tasks_pub.task_assign_tbl;
1703: ddp_task_depends_tbl jtf_tasks_pub.task_depends_tbl;
1704: ddp_task_rsrc_req_tbl jtf_tasks_pub.task_rsrc_req_tbl;
1705: ddp_task_refer_tbl jtf_tasks_pub.task_refer_tbl;
1706: ddp_task_dates_tbl jtf_tasks_pub.task_dates_tbl;
1707: ddp_task_notes_tbl jtf_tasks_pub.task_notes_tbl;
1708: ddp_task_recur_rec jtf_tasks_pub.task_recur_rec;
1709: ddp_task_contacts_tbl jtf_tasks_pub.task_contacts_tbl;

Line 1706: ddp_task_dates_tbl jtf_tasks_pub.task_dates_tbl;

1702: ddp_task_assign_tbl jtf_tasks_pub.task_assign_tbl;
1703: ddp_task_depends_tbl jtf_tasks_pub.task_depends_tbl;
1704: ddp_task_rsrc_req_tbl jtf_tasks_pub.task_rsrc_req_tbl;
1705: ddp_task_refer_tbl jtf_tasks_pub.task_refer_tbl;
1706: ddp_task_dates_tbl jtf_tasks_pub.task_dates_tbl;
1707: ddp_task_notes_tbl jtf_tasks_pub.task_notes_tbl;
1708: ddp_task_recur_rec jtf_tasks_pub.task_recur_rec;
1709: ddp_task_contacts_tbl jtf_tasks_pub.task_contacts_tbl;
1710: ddindx binary_integer; indx binary_integer;

Line 1707: ddp_task_notes_tbl jtf_tasks_pub.task_notes_tbl;

1703: ddp_task_depends_tbl jtf_tasks_pub.task_depends_tbl;
1704: ddp_task_rsrc_req_tbl jtf_tasks_pub.task_rsrc_req_tbl;
1705: ddp_task_refer_tbl jtf_tasks_pub.task_refer_tbl;
1706: ddp_task_dates_tbl jtf_tasks_pub.task_dates_tbl;
1707: ddp_task_notes_tbl jtf_tasks_pub.task_notes_tbl;
1708: ddp_task_recur_rec jtf_tasks_pub.task_recur_rec;
1709: ddp_task_contacts_tbl jtf_tasks_pub.task_contacts_tbl;
1710: ddindx binary_integer; indx binary_integer;
1711: begin

Line 1708: ddp_task_recur_rec jtf_tasks_pub.task_recur_rec;

1704: ddp_task_rsrc_req_tbl jtf_tasks_pub.task_rsrc_req_tbl;
1705: ddp_task_refer_tbl jtf_tasks_pub.task_refer_tbl;
1706: ddp_task_dates_tbl jtf_tasks_pub.task_dates_tbl;
1707: ddp_task_notes_tbl jtf_tasks_pub.task_notes_tbl;
1708: ddp_task_recur_rec jtf_tasks_pub.task_recur_rec;
1709: ddp_task_contacts_tbl jtf_tasks_pub.task_contacts_tbl;
1710: ddindx binary_integer; indx binary_integer;
1711: begin
1712:

Line 1709: ddp_task_contacts_tbl jtf_tasks_pub.task_contacts_tbl;

1705: ddp_task_refer_tbl jtf_tasks_pub.task_refer_tbl;
1706: ddp_task_dates_tbl jtf_tasks_pub.task_dates_tbl;
1707: ddp_task_notes_tbl jtf_tasks_pub.task_notes_tbl;
1708: ddp_task_recur_rec jtf_tasks_pub.task_recur_rec;
1709: ddp_task_contacts_tbl jtf_tasks_pub.task_contacts_tbl;
1710: ddindx binary_integer; indx binary_integer;
1711: begin
1712:
1713: -- copy data to the local IN or IN-OUT args, if any

Line 1793: jtf_tasks_pub_w.rosetta_table_copy_in_p6(ddp_task_assign_tbl, p73_a0

1789:
1790:
1791:
1792:
1793: jtf_tasks_pub_w.rosetta_table_copy_in_p6(ddp_task_assign_tbl, p73_a0
1794: , p73_a1
1795: , p73_a2
1796: , p73_a3
1797: , p73_a4

Line 1821: jtf_tasks_pub_w.rosetta_table_copy_in_p9(ddp_task_depends_tbl, p74_a0

1817: , p73_a24
1818: , p73_a25
1819: );
1820:
1821: jtf_tasks_pub_w.rosetta_table_copy_in_p9(ddp_task_depends_tbl, p74_a0
1822: , p74_a1
1823: , p74_a2
1824: , p74_a3
1825: , p74_a4

Line 1829: jtf_tasks_pub_w.rosetta_table_copy_in_p12(ddp_task_rsrc_req_tbl, p75_a0

1825: , p74_a4
1826: , p74_a5
1827: );
1828:
1829: jtf_tasks_pub_w.rosetta_table_copy_in_p12(ddp_task_rsrc_req_tbl, p75_a0
1830: , p75_a1
1831: , p75_a2
1832: );
1833:

Line 1834: jtf_tasks_pub_w.rosetta_table_copy_in_p15(ddp_task_refer_tbl, p76_a0

1830: , p75_a1
1831: , p75_a2
1832: );
1833:
1834: jtf_tasks_pub_w.rosetta_table_copy_in_p15(ddp_task_refer_tbl, p76_a0
1835: , p76_a1
1836: , p76_a2
1837: , p76_a3
1838: , p76_a4

Line 1843: jtf_tasks_pub_w.rosetta_table_copy_in_p20(ddp_task_dates_tbl, p77_a0

1839: , p76_a5
1840: , p76_a6
1841: );
1842:
1843: jtf_tasks_pub_w.rosetta_table_copy_in_p20(ddp_task_dates_tbl, p77_a0
1844: , p77_a1
1845: , p77_a2
1846: , p77_a3
1847: );

Line 1849: jtf_tasks_pub_w.rosetta_table_copy_in_p23(ddp_task_notes_tbl, p78_a0

1845: , p77_a2
1846: , p77_a3
1847: );
1848:
1849: jtf_tasks_pub_w.rosetta_table_copy_in_p23(ddp_task_notes_tbl, p78_a0
1850: , p78_a1
1851: , p78_a2
1852: , p78_a3
1853: , p78_a4

Line 1886: jtf_tasks_pub_w.rosetta_table_copy_in_p26(ddp_task_contacts_tbl, p80_a0

1882: ddp_task_recur_rec.occurs_number := p79_a6;
1883: ddp_task_recur_rec.start_date_active := rosetta_g_miss_date_in_map(p79_a7);
1884: ddp_task_recur_rec.end_date_active := rosetta_g_miss_date_in_map(p79_a8);
1885:
1886: jtf_tasks_pub_w.rosetta_table_copy_in_p26(ddp_task_contacts_tbl, p80_a0
1887: , p80_a1
1888: , p80_a2
1889: , p80_a3
1890: );

Line 1926: jtf_tasks_pub.create_task(p_api_version,

1922:
1923:
1924:
1925: -- here's the delegated call to the old PL/SQL routine
1926: jtf_tasks_pub.create_task(p_api_version,
1927: p_init_msg_list,
1928: p_commit,
1929: p_task_id,
1930: p_task_name,

Line 2387: jtf_tasks_pub.create_task(p_api_version,

2383:
2384:
2385:
2386: -- here's the delegated call to the old PL/SQL routine
2387: jtf_tasks_pub.create_task(p_api_version,
2388: p_init_msg_list,
2389: p_commit,
2390: p_task_id,
2391: p_task_name,

Line 2822: jtf_tasks_pub.create_task(p_api_version,

2818:
2819:
2820:
2821: -- here's the delegated call to the old PL/SQL routine
2822: jtf_tasks_pub.create_task(p_api_version,
2823: p_init_msg_list,
2824: p_commit,
2825: p_task_id,
2826: p_task_name,

Line 3219: ddp_task_assign_tbl jtf_tasks_pub.task_assign_tbl;

3215: ddp_scheduled_start_date date;
3216: ddp_scheduled_end_date date;
3217: ddp_actual_start_date date;
3218: ddp_actual_end_date date;
3219: ddp_task_assign_tbl jtf_tasks_pub.task_assign_tbl;
3220: ddp_task_depends_tbl jtf_tasks_pub.task_depends_tbl;
3221: ddp_task_rsrc_req_tbl jtf_tasks_pub.task_rsrc_req_tbl;
3222: ddp_task_refer_tbl jtf_tasks_pub.task_refer_tbl;
3223: ddp_task_dates_tbl jtf_tasks_pub.task_dates_tbl;

Line 3220: ddp_task_depends_tbl jtf_tasks_pub.task_depends_tbl;

3216: ddp_scheduled_end_date date;
3217: ddp_actual_start_date date;
3218: ddp_actual_end_date date;
3219: ddp_task_assign_tbl jtf_tasks_pub.task_assign_tbl;
3220: ddp_task_depends_tbl jtf_tasks_pub.task_depends_tbl;
3221: ddp_task_rsrc_req_tbl jtf_tasks_pub.task_rsrc_req_tbl;
3222: ddp_task_refer_tbl jtf_tasks_pub.task_refer_tbl;
3223: ddp_task_dates_tbl jtf_tasks_pub.task_dates_tbl;
3224: ddp_task_notes_tbl jtf_tasks_pub.task_notes_tbl;

Line 3221: ddp_task_rsrc_req_tbl jtf_tasks_pub.task_rsrc_req_tbl;

3217: ddp_actual_start_date date;
3218: ddp_actual_end_date date;
3219: ddp_task_assign_tbl jtf_tasks_pub.task_assign_tbl;
3220: ddp_task_depends_tbl jtf_tasks_pub.task_depends_tbl;
3221: ddp_task_rsrc_req_tbl jtf_tasks_pub.task_rsrc_req_tbl;
3222: ddp_task_refer_tbl jtf_tasks_pub.task_refer_tbl;
3223: ddp_task_dates_tbl jtf_tasks_pub.task_dates_tbl;
3224: ddp_task_notes_tbl jtf_tasks_pub.task_notes_tbl;
3225: ddp_task_recur_rec jtf_tasks_pub.task_recur_rec;

Line 3222: ddp_task_refer_tbl jtf_tasks_pub.task_refer_tbl;

3218: ddp_actual_end_date date;
3219: ddp_task_assign_tbl jtf_tasks_pub.task_assign_tbl;
3220: ddp_task_depends_tbl jtf_tasks_pub.task_depends_tbl;
3221: ddp_task_rsrc_req_tbl jtf_tasks_pub.task_rsrc_req_tbl;
3222: ddp_task_refer_tbl jtf_tasks_pub.task_refer_tbl;
3223: ddp_task_dates_tbl jtf_tasks_pub.task_dates_tbl;
3224: ddp_task_notes_tbl jtf_tasks_pub.task_notes_tbl;
3225: ddp_task_recur_rec jtf_tasks_pub.task_recur_rec;
3226: ddp_task_contacts_tbl jtf_tasks_pub.task_contacts_tbl;

Line 3223: ddp_task_dates_tbl jtf_tasks_pub.task_dates_tbl;

3219: ddp_task_assign_tbl jtf_tasks_pub.task_assign_tbl;
3220: ddp_task_depends_tbl jtf_tasks_pub.task_depends_tbl;
3221: ddp_task_rsrc_req_tbl jtf_tasks_pub.task_rsrc_req_tbl;
3222: ddp_task_refer_tbl jtf_tasks_pub.task_refer_tbl;
3223: ddp_task_dates_tbl jtf_tasks_pub.task_dates_tbl;
3224: ddp_task_notes_tbl jtf_tasks_pub.task_notes_tbl;
3225: ddp_task_recur_rec jtf_tasks_pub.task_recur_rec;
3226: ddp_task_contacts_tbl jtf_tasks_pub.task_contacts_tbl;
3227: ddindx binary_integer; indx binary_integer;

Line 3224: ddp_task_notes_tbl jtf_tasks_pub.task_notes_tbl;

3220: ddp_task_depends_tbl jtf_tasks_pub.task_depends_tbl;
3221: ddp_task_rsrc_req_tbl jtf_tasks_pub.task_rsrc_req_tbl;
3222: ddp_task_refer_tbl jtf_tasks_pub.task_refer_tbl;
3223: ddp_task_dates_tbl jtf_tasks_pub.task_dates_tbl;
3224: ddp_task_notes_tbl jtf_tasks_pub.task_notes_tbl;
3225: ddp_task_recur_rec jtf_tasks_pub.task_recur_rec;
3226: ddp_task_contacts_tbl jtf_tasks_pub.task_contacts_tbl;
3227: ddindx binary_integer; indx binary_integer;
3228: begin

Line 3225: ddp_task_recur_rec jtf_tasks_pub.task_recur_rec;

3221: ddp_task_rsrc_req_tbl jtf_tasks_pub.task_rsrc_req_tbl;
3222: ddp_task_refer_tbl jtf_tasks_pub.task_refer_tbl;
3223: ddp_task_dates_tbl jtf_tasks_pub.task_dates_tbl;
3224: ddp_task_notes_tbl jtf_tasks_pub.task_notes_tbl;
3225: ddp_task_recur_rec jtf_tasks_pub.task_recur_rec;
3226: ddp_task_contacts_tbl jtf_tasks_pub.task_contacts_tbl;
3227: ddindx binary_integer; indx binary_integer;
3228: begin
3229:

Line 3226: ddp_task_contacts_tbl jtf_tasks_pub.task_contacts_tbl;

3222: ddp_task_refer_tbl jtf_tasks_pub.task_refer_tbl;
3223: ddp_task_dates_tbl jtf_tasks_pub.task_dates_tbl;
3224: ddp_task_notes_tbl jtf_tasks_pub.task_notes_tbl;
3225: ddp_task_recur_rec jtf_tasks_pub.task_recur_rec;
3226: ddp_task_contacts_tbl jtf_tasks_pub.task_contacts_tbl;
3227: ddindx binary_integer; indx binary_integer;
3228: begin
3229:
3230: -- copy data to the local IN or IN-OUT args, if any

Line 3310: jtf_tasks_pub_w.rosetta_table_copy_in_p6(ddp_task_assign_tbl, p73_a0

3306:
3307:
3308:
3309:
3310: jtf_tasks_pub_w.rosetta_table_copy_in_p6(ddp_task_assign_tbl, p73_a0
3311: , p73_a1
3312: , p73_a2
3313: , p73_a3
3314: , p73_a4

Line 3338: jtf_tasks_pub_w.rosetta_table_copy_in_p9(ddp_task_depends_tbl, p74_a0

3334: , p73_a24
3335: , p73_a25
3336: );
3337:
3338: jtf_tasks_pub_w.rosetta_table_copy_in_p9(ddp_task_depends_tbl, p74_a0
3339: , p74_a1
3340: , p74_a2
3341: , p74_a3
3342: , p74_a4

Line 3346: jtf_tasks_pub_w.rosetta_table_copy_in_p12(ddp_task_rsrc_req_tbl, p75_a0

3342: , p74_a4
3343: , p74_a5
3344: );
3345:
3346: jtf_tasks_pub_w.rosetta_table_copy_in_p12(ddp_task_rsrc_req_tbl, p75_a0
3347: , p75_a1
3348: , p75_a2
3349: );
3350:

Line 3351: jtf_tasks_pub_w.rosetta_table_copy_in_p15(ddp_task_refer_tbl, p76_a0

3347: , p75_a1
3348: , p75_a2
3349: );
3350:
3351: jtf_tasks_pub_w.rosetta_table_copy_in_p15(ddp_task_refer_tbl, p76_a0
3352: , p76_a1
3353: , p76_a2
3354: , p76_a3
3355: , p76_a4

Line 3360: jtf_tasks_pub_w.rosetta_table_copy_in_p20(ddp_task_dates_tbl, p77_a0

3356: , p76_a5
3357: , p76_a6
3358: );
3359:
3360: jtf_tasks_pub_w.rosetta_table_copy_in_p20(ddp_task_dates_tbl, p77_a0
3361: , p77_a1
3362: , p77_a2
3363: , p77_a3
3364: );

Line 3366: jtf_tasks_pub_w.rosetta_table_copy_in_p23(ddp_task_notes_tbl, p78_a0

3362: , p77_a2
3363: , p77_a3
3364: );
3365:
3366: jtf_tasks_pub_w.rosetta_table_copy_in_p23(ddp_task_notes_tbl, p78_a0
3367: , p78_a1
3368: , p78_a2
3369: , p78_a3
3370: , p78_a4

Line 3403: jtf_tasks_pub_w.rosetta_table_copy_in_p26(ddp_task_contacts_tbl, p80_a0

3399: ddp_task_recur_rec.occurs_number := p79_a6;
3400: ddp_task_recur_rec.start_date_active := rosetta_g_miss_date_in_map(p79_a7);
3401: ddp_task_recur_rec.end_date_active := rosetta_g_miss_date_in_map(p79_a8);
3402:
3403: jtf_tasks_pub_w.rosetta_table_copy_in_p26(ddp_task_contacts_tbl, p80_a0
3404: , p80_a1
3405: , p80_a2
3406: , p80_a3
3407: );

Line 3436: jtf_tasks_pub.create_task(p_api_version,

3432:
3433:
3434:
3435: -- here's the delegated call to the old PL/SQL routine
3436: jtf_tasks_pub.create_task(p_api_version,
3437: p_init_msg_list,
3438: p_commit,
3439: p_task_id,
3440: p_task_name,

Line 3883: jtf_tasks_pub.update_task(p_api_version,

3879:
3880:
3881:
3882: -- here's the delegated call to the old PL/SQL routine
3883: jtf_tasks_pub.update_task(p_api_version,
3884: p_init_msg_list,
3885: p_commit,
3886: p_object_version_number,
3887: p_task_id,

Line 4324: jtf_tasks_pub.update_task(p_api_version,

4320:
4321:
4322:
4323: -- here's the delegated call to the old PL/SQL routine
4324: jtf_tasks_pub.update_task(p_api_version,
4325: p_init_msg_list,
4326: p_commit,
4327: p_object_version_number,
4328: p_task_id,

Line 4757: jtf_tasks_pub.update_task(p_api_version,

4753:
4754:
4755:
4756: -- here's the delegated call to the old PL/SQL routine
4757: jtf_tasks_pub.update_task(p_api_version,
4758: p_init_msg_list,
4759: p_commit,
4760: p_object_version_number,
4761: p_task_id,

Line 5180: jtf_tasks_pub.update_task(p_api_version,

5176:
5177:
5178:
5179: -- here's the delegated call to the old PL/SQL routine
5180: jtf_tasks_pub.update_task(p_api_version,
5181: p_init_msg_list,
5182: p_commit,
5183: p_object_version_number,
5184: p_task_id,

Line 5534: ddp_sort_data jtf_tasks_pub.sort_data;

5530: ddp_scheduled_start_date date;
5531: ddp_scheduled_end_date date;
5532: ddp_actual_start_date date;
5533: ddp_actual_end_date date;
5534: ddp_sort_data jtf_tasks_pub.sort_data;
5535: ddx_task_table jtf_tasks_pub.task_table_type;
5536: ddindx binary_integer; indx binary_integer;
5537: begin
5538:

Line 5535: ddx_task_table jtf_tasks_pub.task_table_type;

5531: ddp_scheduled_end_date date;
5532: ddp_actual_start_date date;
5533: ddp_actual_end_date date;
5534: ddp_sort_data jtf_tasks_pub.sort_data;
5535: ddx_task_table jtf_tasks_pub.task_table_type;
5536: ddindx binary_integer; indx binary_integer;
5537: begin
5538:
5539: -- copy data to the local IN or IN-OUT args, if any

Line 5595: jtf_tasks_pub_w.rosetta_table_copy_in_p34(ddp_sort_data, p49_a0

5591:
5592:
5593:
5594:
5595: jtf_tasks_pub_w.rosetta_table_copy_in_p34(ddp_sort_data, p49_a0
5596: , p49_a1
5597: );
5598:
5599:

Line 5612: jtf_tasks_pub.export_query_task(p_api_version,

5608:
5609:
5610:
5611: -- here's the delegated call to the old PL/SQL routine
5612: jtf_tasks_pub.export_query_task(p_api_version,
5613: p_init_msg_list,
5614: p_validate_level,
5615: p_file_name,
5616: p_task_number,

Line 5730: jtf_tasks_pub_w.rosetta_table_copy_out_p31(ddx_task_table, p54_a0

5726:
5727:
5728:
5729:
5730: jtf_tasks_pub_w.rosetta_table_copy_out_p31(ddx_task_table, p54_a0
5731: , p54_a1
5732: , p54_a2
5733: , p54_a3
5734: , p54_a4

Line 5974: ddp_sort_data jtf_tasks_pub.sort_data;

5970: ddp_scheduled_start_date date;
5971: ddp_scheduled_end_date date;
5972: ddp_actual_start_date date;
5973: ddp_actual_end_date date;
5974: ddp_sort_data jtf_tasks_pub.sort_data;
5975: ddx_task_table jtf_tasks_pub.task_table_type;
5976: ddindx binary_integer; indx binary_integer;
5977: begin
5978:

Line 5975: ddx_task_table jtf_tasks_pub.task_table_type;

5971: ddp_scheduled_end_date date;
5972: ddp_actual_start_date date;
5973: ddp_actual_end_date date;
5974: ddp_sort_data jtf_tasks_pub.sort_data;
5975: ddx_task_table jtf_tasks_pub.task_table_type;
5976: ddindx binary_integer; indx binary_integer;
5977: begin
5978:
5979: -- copy data to the local IN or IN-OUT args, if any

Line 6035: jtf_tasks_pub_w.rosetta_table_copy_in_p34(ddp_sort_data, p49_a0

6031:
6032:
6033:
6034:
6035: jtf_tasks_pub_w.rosetta_table_copy_in_p34(ddp_sort_data, p49_a0
6036: , p49_a1
6037: );
6038:
6039:

Line 6051: jtf_tasks_pub.export_query_task(p_api_version,

6047:
6048:
6049:
6050: -- here's the delegated call to the old PL/SQL routine
6051: jtf_tasks_pub.export_query_task(p_api_version,
6052: p_init_msg_list,
6053: p_validate_level,
6054: p_file_name,
6055: p_task_number,

Line 6168: jtf_tasks_pub_w.rosetta_table_copy_out_p31(ddx_task_table, p54_a0

6164:
6165:
6166:
6167:
6168: jtf_tasks_pub_w.rosetta_table_copy_out_p31(ddx_task_table, p54_a0
6169: , p54_a1
6170: , p54_a2
6171: , p54_a3
6172: , p54_a4

Line 6411: ddp_sort_data jtf_tasks_pub.sort_data;

6407: ddp_scheduled_start_date date;
6408: ddp_scheduled_end_date date;
6409: ddp_actual_start_date date;
6410: ddp_actual_end_date date;
6411: ddp_sort_data jtf_tasks_pub.sort_data;
6412: ddx_task_table jtf_tasks_pub.task_table_type;
6413: ddindx binary_integer; indx binary_integer;
6414: begin
6415:

Line 6412: ddx_task_table jtf_tasks_pub.task_table_type;

6408: ddp_scheduled_end_date date;
6409: ddp_actual_start_date date;
6410: ddp_actual_end_date date;
6411: ddp_sort_data jtf_tasks_pub.sort_data;
6412: ddx_task_table jtf_tasks_pub.task_table_type;
6413: ddindx binary_integer; indx binary_integer;
6414: begin
6415:
6416: -- copy data to the local IN or IN-OUT args, if any

Line 6471: jtf_tasks_pub_w.rosetta_table_copy_in_p34(ddp_sort_data, p48_a0

6467:
6468:
6469:
6470:
6471: jtf_tasks_pub_w.rosetta_table_copy_in_p34(ddp_sort_data, p48_a0
6472: , p48_a1
6473: );
6474:
6475:

Line 6488: jtf_tasks_pub.query_task(p_api_version,

6484:
6485:
6486:
6487: -- here's the delegated call to the old PL/SQL routine
6488: jtf_tasks_pub.query_task(p_api_version,
6489: p_init_msg_list,
6490: p_validate_level,
6491: p_task_number,
6492: p_task_id,

Line 6604: jtf_tasks_pub_w.rosetta_table_copy_out_p31(ddx_task_table, p53_a0

6600:
6601:
6602:
6603:
6604: jtf_tasks_pub_w.rosetta_table_copy_out_p31(ddx_task_table, p53_a0
6605: , p53_a1
6606: , p53_a2
6607: , p53_a3
6608: , p53_a4

Line 6847: ddp_sort_data jtf_tasks_pub.sort_data;

6843: ddp_scheduled_start_date date;
6844: ddp_scheduled_end_date date;
6845: ddp_actual_start_date date;
6846: ddp_actual_end_date date;
6847: ddp_sort_data jtf_tasks_pub.sort_data;
6848: ddx_task_table jtf_tasks_pub.task_table_type;
6849: ddindx binary_integer; indx binary_integer;
6850: begin
6851:

Line 6848: ddx_task_table jtf_tasks_pub.task_table_type;

6844: ddp_scheduled_end_date date;
6845: ddp_actual_start_date date;
6846: ddp_actual_end_date date;
6847: ddp_sort_data jtf_tasks_pub.sort_data;
6848: ddx_task_table jtf_tasks_pub.task_table_type;
6849: ddindx binary_integer; indx binary_integer;
6850: begin
6851:
6852: -- copy data to the local IN or IN-OUT args, if any

Line 6907: jtf_tasks_pub_w.rosetta_table_copy_in_p34(ddp_sort_data, p48_a0

6903:
6904:
6905:
6906:
6907: jtf_tasks_pub_w.rosetta_table_copy_in_p34(ddp_sort_data, p48_a0
6908: , p48_a1
6909: );
6910:
6911:

Line 6923: jtf_tasks_pub.query_task(p_api_version,

6919:
6920:
6921:
6922: -- here's the delegated call to the old PL/SQL routine
6923: jtf_tasks_pub.query_task(p_api_version,
6924: p_init_msg_list,
6925: p_validate_level,
6926: p_task_number,
6927: p_task_id,

Line 7038: jtf_tasks_pub_w.rosetta_table_copy_out_p31(ddx_task_table, p53_a0

7034:
7035:
7036:
7037:
7038: jtf_tasks_pub_w.rosetta_table_copy_out_p31(ddx_task_table, p53_a0
7039: , p53_a1
7040: , p53_a2
7041: , p53_a3
7042: , p53_a4

Line 7236: ddp_sort_data jtf_tasks_pub.sort_data;

7232: , x_object_version_number in out nocopy NUMBER
7233: )
7234:
7235: as
7236: ddp_sort_data jtf_tasks_pub.sort_data;
7237: ddx_task_table jtf_tasks_pub.task_table_type;
7238: ddindx binary_integer; indx binary_integer;
7239: begin
7240:

Line 7237: ddx_task_table jtf_tasks_pub.task_table_type;

7233: )
7234:
7235: as
7236: ddp_sort_data jtf_tasks_pub.sort_data;
7237: ddx_task_table jtf_tasks_pub.task_table_type;
7238: ddindx binary_integer; indx binary_integer;
7239: begin
7240:
7241: -- copy data to the local IN or IN-OUT args, if any

Line 7252: jtf_tasks_pub_w.rosetta_table_copy_in_p34(ddp_sort_data, p10_a0

7248:
7249:
7250:
7251:
7252: jtf_tasks_pub_w.rosetta_table_copy_in_p34(ddp_sort_data, p10_a0
7253: , p10_a1
7254: );
7255:
7256:

Line 7268: jtf_tasks_pub.query_next_task(p_api_version,

7264:
7265:
7266:
7267: -- here's the delegated call to the old PL/SQL routine
7268: jtf_tasks_pub.query_next_task(p_api_version,
7269: p_init_msg_list,
7270: p_validate_level,
7271: p_task_id,
7272: p_query_type,

Line 7307: jtf_tasks_pub_w.rosetta_table_copy_out_p31(ddx_task_table, p15_a0

7303:
7304:
7305:
7306:
7307: jtf_tasks_pub_w.rosetta_table_copy_out_p31(ddx_task_table, p15_a0
7308: , p15_a1
7309: , p15_a2
7310: , p15_a3
7311: , p15_a4

Line 7491: ddp_task_table jtf_tasks_pub.task_table_type;

7487: , x_object_version_number in out nocopy NUMBER
7488: )
7489:
7490: as
7491: ddp_task_table jtf_tasks_pub.task_table_type;
7492: ddindx binary_integer; indx binary_integer;
7493: begin
7494:
7495: -- copy data to the local IN or IN-OUT args, if any

Line 7500: jtf_tasks_pub_w.rosetta_table_copy_in_p31(ddp_task_table, p4_a0

7496:
7497:
7498:
7499:
7500: jtf_tasks_pub_w.rosetta_table_copy_in_p31(ddp_task_table, p4_a0
7501: , p4_a1
7502: , p4_a2
7503: , p4_a3
7504: , p4_a4

Line 7589: jtf_tasks_pub.export_file(p_api_version,

7585:
7586:
7587:
7588: -- here's the delegated call to the old PL/SQL routine
7589: jtf_tasks_pub.export_file(p_api_version,
7590: p_init_msg_list,
7591: p_validate_level,
7592: p_file_name,
7593: ddp_task_table,

Line 7673: ddx_task_details_tbl jtf_tasks_pub.task_details_tbl;

7669: , p_location_id NUMBER
7670: )
7671:
7672: as
7673: ddx_task_details_tbl jtf_tasks_pub.task_details_tbl;
7674: ddp_actual_start_date date;
7675: ddp_actual_end_date date;
7676: ddp_planned_start_date date;
7677: ddp_planned_end_date date;

Line 7750: jtf_tasks_pub.create_task_from_template(p_api_version,

7746:
7747:
7748:
7749: -- here's the delegated call to the old PL/SQL routine
7750: jtf_tasks_pub.create_task_from_template(p_api_version,
7751: p_init_msg_list,
7752: p_commit,
7753: p_task_template_group_id,
7754: p_task_template_group_name,

Line 7823: jtf_tasks_pub_w.rosetta_table_copy_out_p53(ddx_task_details_tbl, p12_a0

7819:
7820:
7821:
7822:
7823: jtf_tasks_pub_w.rosetta_table_copy_out_p53(ddx_task_details_tbl, p12_a0
7824: , p12_a1
7825: );
7826:
7827:

Line 7936: ddx_task_details_tbl jtf_tasks_pub.task_details_tbl;

7932: , p_date_selected VARCHAR2
7933: )
7934:
7935: as
7936: ddx_task_details_tbl jtf_tasks_pub.task_details_tbl;
7937: ddp_actual_start_date date;
7938: ddp_actual_end_date date;
7939: ddp_planned_start_date date;
7940: ddp_planned_end_date date;

Line 8012: jtf_tasks_pub.create_task_from_template(p_api_version,

8008:
8009:
8010:
8011: -- here's the delegated call to the old PL/SQL routine
8012: jtf_tasks_pub.create_task_from_template(p_api_version,
8013: p_init_msg_list,
8014: p_commit,
8015: p_task_template_group_id,
8016: p_task_template_group_name,

Line 8084: jtf_tasks_pub_w.rosetta_table_copy_out_p53(ddx_task_details_tbl, p12_a0

8080:
8081:
8082:
8083:
8084: jtf_tasks_pub_w.rosetta_table_copy_out_p53(ddx_task_details_tbl, p12_a0
8085: , p12_a1
8086: );
8087:
8088:

Line 8134: end jtf_tasks_pub_w;

8130:
8131:
8132: end;
8133:
8134: end jtf_tasks_pub_w;