DBA Data[Home] [Help]

APPS.JTF_TASK_INST_TEMPLATES_PUB_W dependencies on JTF_TASK_INST_TEMPLATES_PUB

Line 1: package body jtf_task_inst_templates_pub_w as

1: package body jtf_task_inst_templates_pub_w as
2: /* $Header: jtfpttwb.pls 120.3 2006/04/26 04:35 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_p1(t out nocopy jtf_task_inst_templates_pub.task_details_tbl, 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_task_inst_templates_pub.task_details_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: ) as
19: ddindx binary_integer; indx binary_integer;
20: begin

Line 37: procedure rosetta_table_copy_out_p1(t jtf_task_inst_templates_pub.task_details_tbl, a0 out nocopy JTF_NUMBER_TABLE

33: end loop;
34: end if;
35: end if;
36: end rosetta_table_copy_in_p1;
37: procedure rosetta_table_copy_out_p1(t jtf_task_inst_templates_pub.task_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
38: , a1 out nocopy JTF_NUMBER_TABLE
39: ) as
40: ddindx binary_integer; indx binary_integer;
41: begin

Line 66: procedure rosetta_table_copy_in_p3(t out nocopy jtf_task_inst_templates_pub.task_contact_points_tbl, a0 JTF_NUMBER_TABLE

62: end if;
63: end if;
64: end rosetta_table_copy_out_p1;
65:
66: procedure rosetta_table_copy_in_p3(t out nocopy jtf_task_inst_templates_pub.task_contact_points_tbl, a0 JTF_NUMBER_TABLE
67: , a1 JTF_NUMBER_TABLE
68: , a2 JTF_VARCHAR2_TABLE_100
69: ) as
70: ddindx binary_integer; indx binary_integer;

Line 89: procedure rosetta_table_copy_out_p3(t jtf_task_inst_templates_pub.task_contact_points_tbl, a0 out nocopy JTF_NUMBER_TABLE

85: end loop;
86: end if;
87: end if;
88: end rosetta_table_copy_in_p3;
89: procedure rosetta_table_copy_out_p3(t jtf_task_inst_templates_pub.task_contact_points_tbl, a0 out nocopy JTF_NUMBER_TABLE
90: , a1 out nocopy JTF_NUMBER_TABLE
91: , a2 out nocopy JTF_VARCHAR2_TABLE_100
92: ) as
93: ddindx binary_integer; indx binary_integer;

Line 123: procedure rosetta_table_copy_in_p6(t out nocopy jtf_task_inst_templates_pub.task_template_info_tbl, a0 JTF_NUMBER_TABLE

119: end if;
120: end if;
121: end rosetta_table_copy_out_p3;
122:
123: procedure rosetta_table_copy_in_p6(t out nocopy jtf_task_inst_templates_pub.task_template_info_tbl, a0 JTF_NUMBER_TABLE
124: , a1 JTF_VARCHAR2_TABLE_100
125: , a2 JTF_VARCHAR2_TABLE_4000
126: , a3 JTF_NUMBER_TABLE
127: , a4 JTF_NUMBER_TABLE

Line 234: procedure rosetta_table_copy_out_p6(t jtf_task_inst_templates_pub.task_template_info_tbl, a0 out nocopy JTF_NUMBER_TABLE

230: end loop;
231: end if;
232: end if;
233: end rosetta_table_copy_in_p6;
234: procedure rosetta_table_copy_out_p6(t jtf_task_inst_templates_pub.task_template_info_tbl, a0 out nocopy JTF_NUMBER_TABLE
235: , a1 out nocopy JTF_VARCHAR2_TABLE_100
236: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
237: , a3 out nocopy JTF_NUMBER_TABLE
238: , a4 out nocopy JTF_NUMBER_TABLE

Line 601: ddp_task_template_group_info jtf_task_inst_templates_pub.task_template_group_info;

597: , p9_a1 out nocopy JTF_NUMBER_TABLE
598: )
599:
600: as
601: ddp_task_template_group_info jtf_task_inst_templates_pub.task_template_group_info;
602: ddp_task_templates_tbl jtf_task_inst_templates_pub.task_template_info_tbl;
603: ddp_task_contact_points_tbl jtf_task_inst_templates_pub.task_contact_points_tbl;
604: ddx_task_details_tbl jtf_task_inst_templates_pub.task_details_tbl;
605: ddindx binary_integer; indx binary_integer;

Line 602: ddp_task_templates_tbl jtf_task_inst_templates_pub.task_template_info_tbl;

598: )
599:
600: as
601: ddp_task_template_group_info jtf_task_inst_templates_pub.task_template_group_info;
602: ddp_task_templates_tbl jtf_task_inst_templates_pub.task_template_info_tbl;
603: ddp_task_contact_points_tbl jtf_task_inst_templates_pub.task_contact_points_tbl;
604: ddx_task_details_tbl jtf_task_inst_templates_pub.task_details_tbl;
605: ddindx binary_integer; indx binary_integer;
606: begin

Line 603: ddp_task_contact_points_tbl jtf_task_inst_templates_pub.task_contact_points_tbl;

599:
600: as
601: ddp_task_template_group_info jtf_task_inst_templates_pub.task_template_group_info;
602: ddp_task_templates_tbl jtf_task_inst_templates_pub.task_template_info_tbl;
603: ddp_task_contact_points_tbl jtf_task_inst_templates_pub.task_contact_points_tbl;
604: ddx_task_details_tbl jtf_task_inst_templates_pub.task_details_tbl;
605: ddindx binary_integer; indx binary_integer;
606: begin
607:

Line 604: ddx_task_details_tbl jtf_task_inst_templates_pub.task_details_tbl;

600: as
601: ddp_task_template_group_info jtf_task_inst_templates_pub.task_template_group_info;
602: ddp_task_templates_tbl jtf_task_inst_templates_pub.task_template_info_tbl;
603: ddp_task_contact_points_tbl jtf_task_inst_templates_pub.task_contact_points_tbl;
604: ddx_task_details_tbl jtf_task_inst_templates_pub.task_details_tbl;
605: ddindx binary_integer; indx binary_integer;
606: begin
607:
608: -- copy data to the local IN or IN-OUT args, if any

Line 665: jtf_task_inst_templates_pub_w.rosetta_table_copy_in_p6(ddp_task_templates_tbl, p4_a0

661: ddp_task_template_group_info.date_selected := p3_a49;
662: ddp_task_template_group_info.show_on_calendar := p3_a50;
663: ddp_task_template_group_info.location_id := p3_a51;
664:
665: jtf_task_inst_templates_pub_w.rosetta_table_copy_in_p6(ddp_task_templates_tbl, p4_a0
666: , p4_a1
667: , p4_a2
668: , p4_a3
669: , p4_a4

Line 714: jtf_task_inst_templates_pub_w.rosetta_table_copy_in_p3(ddp_task_contact_points_tbl, p5_a0

710: , p4_a45
711: , p4_a46
712: );
713:
714: jtf_task_inst_templates_pub_w.rosetta_table_copy_in_p3(ddp_task_contact_points_tbl, p5_a0
715: , p5_a1
716: , p5_a2
717: );
718:

Line 724: jtf_task_inst_templates_pub.create_task_from_template(p_api_version,

720:
721:
722:
723: -- here's the delegated call to the old PL/SQL routine
724: jtf_task_inst_templates_pub.create_task_from_template(p_api_version,
725: p_init_msg_list,
726: p_commit,
727: ddp_task_template_group_info,
728: ddp_task_templates_tbl,

Line 745: jtf_task_inst_templates_pub_w.rosetta_table_copy_out_p1(ddx_task_details_tbl, p9_a0

741:
742:
743:
744:
745: jtf_task_inst_templates_pub_w.rosetta_table_copy_out_p1(ddx_task_details_tbl, p9_a0
746: , p9_a1
747: );
748: end;
749:

Line 750: end jtf_task_inst_templates_pub_w;

746: , p9_a1
747: );
748: end;
749:
750: end jtf_task_inst_templates_pub_w;