DBA Data[Home] [Help]

APPS.JTF_NOTES_PUB_W dependencies on JTF_NOTES_PUB

Line 1: package body jtf_notes_pub_w as

1: package body jtf_notes_pub_w as
2: /* $Header: jtfntswb.pls 120.2 2006/04/26 23:08 mpadhiar 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_notes_pub.jtf_note_contexts_tbl_type, 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_notes_pub.jtf_note_contexts_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_300
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE

Line 51: procedure rosetta_table_copy_out_p1(t jtf_notes_pub.jtf_note_contexts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

47: end loop;
48: end if;
49: end if;
50: end rosetta_table_copy_in_p1;
51: procedure rosetta_table_copy_out_p1(t jtf_notes_pub.jtf_note_contexts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
52: , a1 out nocopy JTF_NUMBER_TABLE
53: , a2 out nocopy JTF_VARCHAR2_TABLE_300
54: , a3 out nocopy JTF_NUMBER_TABLE
55: , a4 out nocopy JTF_DATE_TABLE

Line 170: ddp_jtf_note_contexts_tab jtf_notes_pub.jtf_note_contexts_tbl_type;

166: as
167: ddp_entered_date date;
168: ddp_last_update_date date;
169: ddp_creation_date date;
170: ddp_jtf_note_contexts_tab jtf_notes_pub.jtf_note_contexts_tbl_type;
171: ddindx binary_integer; indx binary_integer;
172: begin
173:
174: -- copy data to the local IN or IN-OUT args, if any

Line 218: jtf_notes_pub_w.rosetta_table_copy_in_p1(ddp_jtf_note_contexts_tab, p40_a0

214:
215:
216:
217:
218: jtf_notes_pub_w.rosetta_table_copy_in_p1(ddp_jtf_note_contexts_tab, p40_a0
219: , p40_a1
220: , p40_a2
221: , p40_a3
222: , p40_a4

Line 230: jtf_notes_pub.create_note(p_parent_note_id,

226: , p40_a8
227: );
228:
229: -- here's the delegated call to the old PL/SQL routine
230: jtf_notes_pub.create_note(p_parent_note_id,
231: p_jtf_note_id,
232: p_api_version,
233: p_init_msg_list,
234: p_commit,

Line 345: ddp_jtf_note_contexts_tab jtf_notes_pub.jtf_note_contexts_tbl_type;

341: )
342:
343: as
344: ddp_last_update_date date;
345: ddp_jtf_note_contexts_tab jtf_notes_pub.jtf_note_contexts_tbl_type;
346: ddindx binary_integer; indx binary_integer;
347: begin
348:
349: -- copy data to the local IN or IN-OUT args, if any

Line 368: jtf_notes_pub_w.rosetta_table_copy_in_p1(ddp_jtf_note_contexts_tab, p17_a0

364:
365:
366:
367:
368: jtf_notes_pub_w.rosetta_table_copy_in_p1(ddp_jtf_note_contexts_tab, p17_a0
369: , p17_a1
370: , p17_a2
371: , p17_a3
372: , p17_a4

Line 380: jtf_notes_pub.update_note(p_api_version,

376: , p17_a8
377: );
378:
379: -- here's the delegated call to the old PL/SQL routine
380: jtf_notes_pub.update_note(p_api_version,
381: p_init_msg_list,
382: p_commit,
383: p_validation_level,
384: x_return_status,

Line 453: jtf_notes_pub.create_note_context(p_validation_level,

449:
450:
451:
452: -- here's the delegated call to the old PL/SQL routine
453: jtf_notes_pub.create_note_context(p_validation_level,
454: x_return_status,
455: p_jtf_note_id,
456: ddp_last_update_date,
457: p_last_updated_by,

Line 506: jtf_notes_pub.update_note_context(p_validation_level,

502: ddp_last_update_date := rosetta_g_miss_date_in_map(p_last_update_date);
503:
504:
505: -- here's the delegated call to the old PL/SQL routine
506: jtf_notes_pub.update_note_context(p_validation_level,
507: x_return_status,
508: p_note_context_id,
509: p_jtf_note_id,
510: p_note_context_type_id,

Line 583: ddp_jtf_note_contexts_tab jtf_notes_pub.jtf_note_contexts_tbl_type;

579: as
580: ddp_entered_date date;
581: ddp_last_update_date date;
582: ddp_creation_date date;
583: ddp_jtf_note_contexts_tab jtf_notes_pub.jtf_note_contexts_tbl_type;
584: ddindx binary_integer; indx binary_integer;
585: begin
586:
587: -- copy data to the local IN or IN-OUT args, if any

Line 631: jtf_notes_pub_w.rosetta_table_copy_in_p1(ddp_jtf_note_contexts_tab, p40_a0

627:
628:
629:
630:
631: jtf_notes_pub_w.rosetta_table_copy_in_p1(ddp_jtf_note_contexts_tab, p40_a0
632: , p40_a1
633: , p40_a2
634: , p40_a3
635: , p40_a4

Line 644: jtf_notes_pub.secure_create_note(p_parent_note_id,

640: );
641:
642:
643: -- here's the delegated call to the old PL/SQL routine
644: jtf_notes_pub.secure_create_note(p_parent_note_id,
645: p_jtf_note_id,
646: p_api_version,
647: p_init_msg_list,
648: p_commit,

Line 778: ddp_jtf_note_contexts_tab jtf_notes_pub.jtf_note_contexts_tbl_type;

774: )
775:
776: as
777: ddp_last_update_date date;
778: ddp_jtf_note_contexts_tab jtf_notes_pub.jtf_note_contexts_tbl_type;
779: ddindx binary_integer; indx binary_integer;
780: begin
781:
782: -- copy data to the local IN or IN-OUT args, if any

Line 801: jtf_notes_pub_w.rosetta_table_copy_in_p1(ddp_jtf_note_contexts_tab, p17_a0

797:
798:
799:
800:
801: jtf_notes_pub_w.rosetta_table_copy_in_p1(ddp_jtf_note_contexts_tab, p17_a0
802: , p17_a1
803: , p17_a2
804: , p17_a3
805: , p17_a4

Line 830: jtf_notes_pub.secure_update_note(p_api_version,

826:
827:
828:
829: -- here's the delegated call to the old PL/SQL routine
830: jtf_notes_pub.secure_update_note(p_api_version,
831: p_init_msg_list,
832: p_commit,
833: p_validation_level,
834: x_return_status,

Line 903: end jtf_notes_pub_w;

899:
900:
901: end;
902:
903: end jtf_notes_pub_w;