DBA Data[Home] [Help]

APPS.JTF_DPF_W dependencies on JTF_DPF

Line 1: package body jtf_dpf_w as

1: package body jtf_dpf_w as
2: /* $Header: jtfdpwb.pls 120.2 2005/10/25 05:19:14 psanyal 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 22: procedure rosetta_table_copy_in_p9(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.new_rule_param_tbl, a0 JTF_VARCHAR2_TABLE_100

18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p9(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.new_rule_param_tbl, a0 JTF_VARCHAR2_TABLE_100
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_100
25: ) as
26: ddindx binary_integer; indx binary_integer;

Line 45: procedure rosetta_table_copy_out_p9(t jtf_dpf.new_rule_param_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

41: end loop;
42: end if;
43: end if;
44: end rosetta_table_copy_in_p9;
45: procedure rosetta_table_copy_out_p9(t jtf_dpf.new_rule_param_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
46: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
47: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
48: ) as
49: ddindx binary_integer; indx binary_integer;

Line 79: procedure rosetta_table_copy_in_p11(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.new_phys_non_def_tbl, a0 JTF_NUMBER_TABLE

75: end if;
76: end if;
77: end rosetta_table_copy_out_p9;
78:
79: procedure rosetta_table_copy_in_p11(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.new_phys_non_def_tbl, a0 JTF_NUMBER_TABLE
80: , a1 JTF_NUMBER_TABLE
81: ) as
82: ddindx binary_integer; indx binary_integer;
83: begin

Line 100: procedure rosetta_table_copy_out_p11(t jtf_dpf.new_phys_non_def_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

96: end loop;
97: end if;
98: end if;
99: end rosetta_table_copy_in_p11;
100: procedure rosetta_table_copy_out_p11(t jtf_dpf.new_phys_non_def_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
101: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
102: ) as
103: ddindx binary_integer; indx binary_integer;
104: begin

Line 129: procedure rosetta_table_copy_in_p13(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.new_next_log_non_def_tbl, a0 JTF_NUMBER_TABLE

125: end if;
126: end if;
127: end rosetta_table_copy_out_p11;
128:
129: procedure rosetta_table_copy_in_p13(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.new_next_log_non_def_tbl, a0 JTF_NUMBER_TABLE
130: , a1 JTF_NUMBER_TABLE
131: ) as
132: ddindx binary_integer; indx binary_integer;
133: begin

Line 150: procedure rosetta_table_copy_out_p13(t jtf_dpf.new_next_log_non_def_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

146: end loop;
147: end if;
148: end if;
149: end rosetta_table_copy_in_p13;
150: procedure rosetta_table_copy_out_p13(t jtf_dpf.new_next_log_non_def_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
151: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
152: ) as
153: ddindx binary_integer; indx binary_integer;
154: begin

Line 179: procedure rosetta_table_copy_in_p15(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.new_phys_attribs_tbl, a0 JTF_VARCHAR2_TABLE_100

175: end if;
176: end if;
177: end rosetta_table_copy_out_p13;
178:
179: procedure rosetta_table_copy_in_p15(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.new_phys_attribs_tbl, a0 JTF_VARCHAR2_TABLE_100
180: , a1 JTF_VARCHAR2_TABLE_300
181: ) as
182: ddindx binary_integer; indx binary_integer;
183: begin

Line 200: procedure rosetta_table_copy_out_p15(t jtf_dpf.new_phys_attribs_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

196: end loop;
197: end if;
198: end if;
199: end rosetta_table_copy_in_p15;
200: procedure rosetta_table_copy_out_p15(t jtf_dpf.new_phys_attribs_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
201: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
202: ) as
203: ddindx binary_integer; indx binary_integer;
204: begin

Line 229: procedure rosetta_table_copy_in_p16(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.dpf_tbl, a0 JTF_NUMBER_TABLE

225: end if;
226: end if;
227: end rosetta_table_copy_out_p15;
228:
229: procedure rosetta_table_copy_in_p16(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.dpf_tbl, a0 JTF_NUMBER_TABLE
230: , a1 JTF_VARCHAR2_TABLE_100
231: , a2 JTF_VARCHAR2_TABLE_100
232: , a3 JTF_VARCHAR2_TABLE_100
233: , a4 JTF_VARCHAR2_TABLE_100

Line 270: procedure rosetta_table_copy_out_p16(t jtf_dpf.dpf_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

266: end loop;
267: end if;
268: end if;
269: end rosetta_table_copy_in_p16;
270: procedure rosetta_table_copy_out_p16(t jtf_dpf.dpf_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
271: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
272: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
273: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
274: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 349: procedure rosetta_table_copy_in_p17(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.logical_tbl, a0 JTF_NUMBER_TABLE

345: end if;
346: end if;
347: end rosetta_table_copy_out_p16;
348:
349: procedure rosetta_table_copy_in_p17(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.logical_tbl, a0 JTF_NUMBER_TABLE
350: , a1 JTF_VARCHAR2_TABLE_100
351: , a2 JTF_VARCHAR2_TABLE_100
352: , a3 JTF_VARCHAR2_TABLE_100
353: , a4 JTF_VARCHAR2_TABLE_200

Line 384: procedure rosetta_table_copy_out_p17(t jtf_dpf.logical_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

380: end loop;
381: end if;
382: end if;
383: end rosetta_table_copy_in_p17;
384: procedure rosetta_table_copy_out_p17(t jtf_dpf.logical_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
385: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
386: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
387: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
388: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200

Line 448: procedure rosetta_table_copy_in_p18(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.physical_tbl, a0 JTF_NUMBER_TABLE

444: end if;
445: end if;
446: end rosetta_table_copy_out_p17;
447:
448: procedure rosetta_table_copy_in_p18(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.physical_tbl, a0 JTF_NUMBER_TABLE
449: , a1 JTF_VARCHAR2_TABLE_100
450: , a2 JTF_VARCHAR2_TABLE_100
451: ) as
452: ddindx binary_integer; indx binary_integer;

Line 471: procedure rosetta_table_copy_out_p18(t jtf_dpf.physical_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

467: end loop;
468: end if;
469: end if;
470: end rosetta_table_copy_in_p18;
471: procedure rosetta_table_copy_out_p18(t jtf_dpf.physical_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
472: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
473: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
474: ) as
475: ddindx binary_integer; indx binary_integer;

Line 505: procedure rosetta_table_copy_in_p19(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.physical_non_default_tbl, a0 JTF_VARCHAR2_TABLE_100

501: end if;
502: end if;
503: end rosetta_table_copy_out_p18;
504:
505: procedure rosetta_table_copy_in_p19(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.physical_non_default_tbl, a0 JTF_VARCHAR2_TABLE_100
506: , a1 JTF_NUMBER_TABLE
507: , a2 JTF_VARCHAR2_TABLE_100
508: , a3 JTF_VARCHAR2_TABLE_100
509: , a4 JTF_VARCHAR2_TABLE_100

Line 536: procedure rosetta_table_copy_out_p19(t jtf_dpf.physical_non_default_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

532: end loop;
533: end if;
534: end if;
535: end rosetta_table_copy_in_p19;
536: procedure rosetta_table_copy_out_p19(t jtf_dpf.physical_non_default_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
537: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
538: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
539: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
540: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 590: procedure rosetta_table_copy_in_p20(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.rule_tbl, a0 JTF_NUMBER_TABLE

586: end if;
587: end if;
588: end rosetta_table_copy_out_p19;
589:
590: procedure rosetta_table_copy_in_p20(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.rule_tbl, a0 JTF_NUMBER_TABLE
591: , a1 JTF_VARCHAR2_TABLE_100
592: , a2 JTF_VARCHAR2_TABLE_100
593: , a3 JTF_VARCHAR2_TABLE_100
594: , a4 JTF_VARCHAR2_TABLE_100

Line 619: procedure rosetta_table_copy_out_p20(t jtf_dpf.rule_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

615: end loop;
616: end if;
617: end if;
618: end rosetta_table_copy_in_p20;
619: procedure rosetta_table_copy_out_p20(t jtf_dpf.rule_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
620: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
621: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
622: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
623: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 668: procedure rosetta_table_copy_in_p21(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.next_logical_default_tbl, a0 JTF_VARCHAR2_TABLE_100

664: end if;
665: end if;
666: end rosetta_table_copy_out_p20;
667:
668: procedure rosetta_table_copy_in_p21(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.next_logical_default_tbl, a0 JTF_VARCHAR2_TABLE_100
669: , a1 JTF_NUMBER_TABLE
670: , a2 JTF_VARCHAR2_TABLE_100
671: , a3 JTF_VARCHAR2_TABLE_100
672: , a4 JTF_VARCHAR2_TABLE_100

Line 697: procedure rosetta_table_copy_out_p21(t jtf_dpf.next_logical_default_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

693: end loop;
694: end if;
695: end if;
696: end rosetta_table_copy_in_p21;
697: procedure rosetta_table_copy_out_p21(t jtf_dpf.next_logical_default_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
698: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
699: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
700: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
701: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 746: procedure rosetta_table_copy_in_p22(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.next_logical_non_default_tbl, a0 JTF_VARCHAR2_TABLE_100

742: end if;
743: end if;
744: end rosetta_table_copy_out_p21;
745:
746: procedure rosetta_table_copy_in_p22(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.next_logical_non_default_tbl, a0 JTF_VARCHAR2_TABLE_100
747: , a1 JTF_NUMBER_TABLE
748: , a2 JTF_VARCHAR2_TABLE_100
749: , a3 JTF_VARCHAR2_TABLE_100
750: , a4 JTF_VARCHAR2_TABLE_100

Line 779: procedure rosetta_table_copy_out_p22(t jtf_dpf.next_logical_non_default_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

775: end loop;
776: end if;
777: end if;
778: end rosetta_table_copy_in_p22;
779: procedure rosetta_table_copy_out_p22(t jtf_dpf.next_logical_non_default_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
780: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
781: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
782: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
783: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 838: procedure rosetta_table_copy_in_p23(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.physical_attribs_tbl, a0 JTF_NUMBER_TABLE

834: end if;
835: end if;
836: end rosetta_table_copy_out_p22;
837:
838: procedure rosetta_table_copy_in_p23(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.physical_attribs_tbl, a0 JTF_NUMBER_TABLE
839: , a1 JTF_VARCHAR2_TABLE_100
840: , a2 JTF_VARCHAR2_TABLE_300
841: ) as
842: ddindx binary_integer; indx binary_integer;

Line 861: procedure rosetta_table_copy_out_p23(t jtf_dpf.physical_attribs_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

857: end loop;
858: end if;
859: end if;
860: end rosetta_table_copy_in_p23;
861: procedure rosetta_table_copy_out_p23(t jtf_dpf.physical_attribs_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
862: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
863: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
864: ) as
865: ddindx binary_integer; indx binary_integer;

Line 955: dddpf jtf_dpf.dpf_tbl;

951: , p10_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
952: )
953: as
954: dddescrs_only boolean;
955: dddpf jtf_dpf.dpf_tbl;
956: ddlog jtf_dpf.logical_tbl;
957: ddphys jtf_dpf.physical_tbl;
958: ddphys_non_def jtf_dpf.physical_non_default_tbl;
959: ddrule jtf_dpf.rule_tbl;

Line 956: ddlog jtf_dpf.logical_tbl;

952: )
953: as
954: dddescrs_only boolean;
955: dddpf jtf_dpf.dpf_tbl;
956: ddlog jtf_dpf.logical_tbl;
957: ddphys jtf_dpf.physical_tbl;
958: ddphys_non_def jtf_dpf.physical_non_default_tbl;
959: ddrule jtf_dpf.rule_tbl;
960: ddnext_log_def jtf_dpf.next_logical_default_tbl;

Line 957: ddphys jtf_dpf.physical_tbl;

953: as
954: dddescrs_only boolean;
955: dddpf jtf_dpf.dpf_tbl;
956: ddlog jtf_dpf.logical_tbl;
957: ddphys jtf_dpf.physical_tbl;
958: ddphys_non_def jtf_dpf.physical_non_default_tbl;
959: ddrule jtf_dpf.rule_tbl;
960: ddnext_log_def jtf_dpf.next_logical_default_tbl;
961: ddnext_log_non_def jtf_dpf.next_logical_non_default_tbl;

Line 958: ddphys_non_def jtf_dpf.physical_non_default_tbl;

954: dddescrs_only boolean;
955: dddpf jtf_dpf.dpf_tbl;
956: ddlog jtf_dpf.logical_tbl;
957: ddphys jtf_dpf.physical_tbl;
958: ddphys_non_def jtf_dpf.physical_non_default_tbl;
959: ddrule jtf_dpf.rule_tbl;
960: ddnext_log_def jtf_dpf.next_logical_default_tbl;
961: ddnext_log_non_def jtf_dpf.next_logical_non_default_tbl;
962: ddphys_atts jtf_dpf.physical_attribs_tbl;

Line 959: ddrule jtf_dpf.rule_tbl;

955: dddpf jtf_dpf.dpf_tbl;
956: ddlog jtf_dpf.logical_tbl;
957: ddphys jtf_dpf.physical_tbl;
958: ddphys_non_def jtf_dpf.physical_non_default_tbl;
959: ddrule jtf_dpf.rule_tbl;
960: ddnext_log_def jtf_dpf.next_logical_default_tbl;
961: ddnext_log_non_def jtf_dpf.next_logical_non_default_tbl;
962: ddphys_atts jtf_dpf.physical_attribs_tbl;
963: ddindx binary_integer; indx binary_integer;

Line 960: ddnext_log_def jtf_dpf.next_logical_default_tbl;

956: ddlog jtf_dpf.logical_tbl;
957: ddphys jtf_dpf.physical_tbl;
958: ddphys_non_def jtf_dpf.physical_non_default_tbl;
959: ddrule jtf_dpf.rule_tbl;
960: ddnext_log_def jtf_dpf.next_logical_default_tbl;
961: ddnext_log_non_def jtf_dpf.next_logical_non_default_tbl;
962: ddphys_atts jtf_dpf.physical_attribs_tbl;
963: ddindx binary_integer; indx binary_integer;
964: begin

Line 961: ddnext_log_non_def jtf_dpf.next_logical_non_default_tbl;

957: ddphys jtf_dpf.physical_tbl;
958: ddphys_non_def jtf_dpf.physical_non_default_tbl;
959: ddrule jtf_dpf.rule_tbl;
960: ddnext_log_def jtf_dpf.next_logical_default_tbl;
961: ddnext_log_non_def jtf_dpf.next_logical_non_default_tbl;
962: ddphys_atts jtf_dpf.physical_attribs_tbl;
963: ddindx binary_integer; indx binary_integer;
964: begin
965:

Line 962: ddphys_atts jtf_dpf.physical_attribs_tbl;

958: ddphys_non_def jtf_dpf.physical_non_default_tbl;
959: ddrule jtf_dpf.rule_tbl;
960: ddnext_log_def jtf_dpf.next_logical_default_tbl;
961: ddnext_log_non_def jtf_dpf.next_logical_non_default_tbl;
962: ddphys_atts jtf_dpf.physical_attribs_tbl;
963: ddindx binary_integer; indx binary_integer;
964: begin
965:
966: -- copy data to the local IN or IN-OUT args, if any

Line 985: jtf_dpf.get(asn,

981:
982:
983:
984: -- here's the delegated call to the old PL/SQL routine
985: jtf_dpf.get(asn,
986: p_lang,
987: dddescrs_only,
988: dddpf,
989: ddlog,

Line 1001: jtf_dpf_w.rosetta_table_copy_out_p16(dddpf, p3_a0

997: -- copy data back from the local OUT or IN-OUT args, if any
998:
999:
1000:
1001: jtf_dpf_w.rosetta_table_copy_out_p16(dddpf, p3_a0
1002: , p3_a1
1003: , p3_a2
1004: , p3_a3
1005: , p3_a4

Line 1015: jtf_dpf_w.rosetta_table_copy_out_p17(ddlog, p4_a0

1011: , p3_a10
1012: , p3_a11
1013: );
1014:
1015: jtf_dpf_w.rosetta_table_copy_out_p17(ddlog, p4_a0
1016: , p4_a1
1017: , p4_a2
1018: , p4_a3
1019: , p4_a4

Line 1026: jtf_dpf_w.rosetta_table_copy_out_p18(ddphys, p5_a0

1022: , p4_a7
1023: , p4_a8
1024: );
1025:
1026: jtf_dpf_w.rosetta_table_copy_out_p18(ddphys, p5_a0
1027: , p5_a1
1028: , p5_a2
1029: );
1030:

Line 1031: jtf_dpf_w.rosetta_table_copy_out_p19(ddphys_non_def, p6_a0

1027: , p5_a1
1028: , p5_a2
1029: );
1030:
1031: jtf_dpf_w.rosetta_table_copy_out_p19(ddphys_non_def, p6_a0
1032: , p6_a1
1033: , p6_a2
1034: , p6_a3
1035: , p6_a4

Line 1040: jtf_dpf_w.rosetta_table_copy_out_p20(ddrule, p7_a0

1036: , p6_a5
1037: , p6_a6
1038: );
1039:
1040: jtf_dpf_w.rosetta_table_copy_out_p20(ddrule, p7_a0
1041: , p7_a1
1042: , p7_a2
1043: , p7_a3
1044: , p7_a4

Line 1048: jtf_dpf_w.rosetta_table_copy_out_p21(ddnext_log_def, p8_a0

1044: , p7_a4
1045: , p7_a5
1046: );
1047:
1048: jtf_dpf_w.rosetta_table_copy_out_p21(ddnext_log_def, p8_a0
1049: , p8_a1
1050: , p8_a2
1051: , p8_a3
1052: , p8_a4

Line 1056: jtf_dpf_w.rosetta_table_copy_out_p22(ddnext_log_non_def, p9_a0

1052: , p8_a4
1053: , p8_a5
1054: );
1055:
1056: jtf_dpf_w.rosetta_table_copy_out_p22(ddnext_log_non_def, p9_a0
1057: , p9_a1
1058: , p9_a2
1059: , p9_a3
1060: , p9_a4

Line 1066: jtf_dpf_w.rosetta_table_copy_out_p23(ddphys_atts, p10_a0

1062: , p9_a6
1063: , p9_a7
1064: );
1065:
1066: jtf_dpf_w.rosetta_table_copy_out_p23(ddphys_atts, p10_a0
1067: , p10_a1
1068: , p10_a2
1069: );
1070: end;

Line 1078: ddupd jtf_dpf.rule_update_rec;

1074: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
1075: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
1076: ) return number
1077: as
1078: ddupd jtf_dpf.rule_update_rec;
1079: ddindx binary_integer; indx binary_integer;
1080: ddrosetta_retval number;
1081: begin
1082:

Line 1090: ddrosetta_retval := jtf_dpf.rule_update(p_rule_id,

1086: ddupd.p_new_name := p1_a1;
1087: ddupd.p_new_descr := p1_a2;
1088:
1089: -- here's the delegated call to the old PL/SQL routine
1090: ddrosetta_retval := jtf_dpf.rule_update(p_rule_id,
1091: ddupd);
1092:
1093: -- copy data back from the local OUT or IN-OUT args, if any
1094:

Line 1107: ddrules jtf_dpf.new_rule_param_tbl;

1103: , p3_a1 JTF_VARCHAR2_TABLE_100
1104: , p3_a2 JTF_VARCHAR2_TABLE_100
1105: ) return number
1106: as
1107: ddrules jtf_dpf.new_rule_param_tbl;
1108: ddindx binary_integer; indx binary_integer;
1109: ddrosetta_retval number;
1110: begin
1111:

Line 1116: jtf_dpf_w.rosetta_table_copy_in_p9(ddrules, p3_a0

1112: -- copy data to the local IN or IN-OUT args, if any
1113:
1114:
1115:
1116: jtf_dpf_w.rosetta_table_copy_in_p9(ddrules, p3_a0
1117: , p3_a1
1118: , p3_a2
1119: );
1120:

Line 1122: ddrosetta_retval := jtf_dpf.rule_new(p_asn,

1118: , p3_a2
1119: );
1120:
1121: -- here's the delegated call to the old PL/SQL routine
1122: ddrosetta_retval := jtf_dpf.rule_new(p_asn,
1123: p_name,
1124: p_descr,
1125: ddrules);
1126:

Line 1141: ddrules jtf_dpf.new_rule_param_tbl;

1137: , p1_a1 JTF_VARCHAR2_TABLE_100
1138: , p1_a2 JTF_VARCHAR2_TABLE_100
1139: )
1140: as
1141: ddrules jtf_dpf.new_rule_param_tbl;
1142: ddindx binary_integer; indx binary_integer;
1143: begin
1144:
1145: -- copy data to the local IN or IN-OUT args, if any

Line 1147: jtf_dpf_w.rosetta_table_copy_in_p9(ddrules, p1_a0

1143: begin
1144:
1145: -- copy data to the local IN or IN-OUT args, if any
1146:
1147: jtf_dpf_w.rosetta_table_copy_in_p9(ddrules, p1_a0
1148: , p1_a1
1149: , p1_a2
1150: );
1151:

Line 1153: jtf_dpf.rule_set_params(p_rule_id,

1149: , p1_a2
1150: );
1151:
1152: -- here's the delegated call to the old PL/SQL routine
1153: jtf_dpf.rule_set_params(p_rule_id,
1154: ddrules);
1155:
1156: -- copy data back from the local OUT or IN-OUT args, if any
1157:

Line 1166: ddupd jtf_dpf.phys_update_rec;

1162: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
1163: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
1164: ) return number
1165: as
1166: ddupd jtf_dpf.phys_update_rec;
1167: ddindx binary_integer; indx binary_integer;
1168: ddrosetta_retval number;
1169: begin
1170:

Line 1178: ddrosetta_retval := jtf_dpf.phys_update(p_ppid,

1174: ddupd.p_name := p1_a1;
1175: ddupd.p_descr := p1_a2;
1176:
1177: -- here's the delegated call to the old PL/SQL routine
1178: ddrosetta_retval := jtf_dpf.phys_update(p_ppid,
1179: ddupd);
1180:
1181: -- copy data back from the local OUT or IN-OUT args, if any
1182:

Line 1192: ddp_new_ones jtf_dpf.new_phys_attribs_tbl;

1188: , p1_a0 JTF_VARCHAR2_TABLE_100
1189: , p1_a1 JTF_VARCHAR2_TABLE_300
1190: )
1191: as
1192: ddp_new_ones jtf_dpf.new_phys_attribs_tbl;
1193: ddindx binary_integer; indx binary_integer;
1194: begin
1195:
1196: -- copy data to the local IN or IN-OUT args, if any

Line 1198: jtf_dpf_w.rosetta_table_copy_in_p15(ddp_new_ones, p1_a0

1194: begin
1195:
1196: -- copy data to the local IN or IN-OUT args, if any
1197:
1198: jtf_dpf_w.rosetta_table_copy_in_p15(ddp_new_ones, p1_a0
1199: , p1_a1
1200: );
1201:
1202: -- here's the delegated call to the old PL/SQL routine

Line 1203: jtf_dpf.phys_attribs_update(p_ppid,

1199: , p1_a1
1200: );
1201:
1202: -- here's the delegated call to the old PL/SQL routine
1203: jtf_dpf.phys_attribs_update(p_ppid,
1204: ddp_new_ones);
1205:
1206: -- copy data back from the local OUT or IN-OUT args, if any
1207:

Line 1221: ddupd jtf_dpf.flow_update_rec;

1217: , p1_a6 NUMBER := 0-1962.0724
1218: , p1_a7 NUMBER := 0-1962.0724
1219: ) return number
1220: as
1221: ddupd jtf_dpf.flow_update_rec;
1222: ddindx binary_integer; indx binary_integer;
1223: ddrosetta_retval number;
1224: begin
1225:

Line 1238: ddrosetta_retval := jtf_dpf.flow_update(p_logical_flow_id,

1234: ddupd.p_new_header_logical_page_id := rosetta_g_miss_num_map(p1_a6);
1235: ddupd.p_rtn_to_logical_page_id := rosetta_g_miss_num_map(p1_a7);
1236:
1237: -- here's the delegated call to the old PL/SQL routine
1238: ddrosetta_retval := jtf_dpf.flow_update(p_logical_flow_id,
1239: ddupd);
1240:
1241: -- copy data back from the local OUT or IN-OUT args, if any
1242:

Line 1257: ddupd jtf_dpf.logical_update_rec;

1253: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
1254: , p1_a6 NUMBER := 0-1962.0724
1255: ) return number
1256: as
1257: ddupd jtf_dpf.logical_update_rec;
1258: ddindx binary_integer; indx binary_integer;
1259: ddrosetta_retval number;
1260: begin
1261:

Line 1273: ddrosetta_retval := jtf_dpf.logical_update(p_logical_page_id,

1269: ddupd.p_new_page_permission_name := p1_a5;
1270: ddupd.p_default_physical_id := rosetta_g_miss_num_map(p1_a6);
1271:
1272: -- here's the delegated call to the old PL/SQL routine
1273: ddrosetta_retval := jtf_dpf.logical_update(p_logical_page_id,
1274: ddupd);
1275:
1276: -- copy data back from the local OUT or IN-OUT args, if any
1277:

Line 1287: ddp_new_ones jtf_dpf.new_phys_non_def_tbl;

1283: , p1_a0 JTF_NUMBER_TABLE
1284: , p1_a1 JTF_NUMBER_TABLE
1285: )
1286: as
1287: ddp_new_ones jtf_dpf.new_phys_non_def_tbl;
1288: ddindx binary_integer; indx binary_integer;
1289: begin
1290:
1291: -- copy data to the local IN or IN-OUT args, if any

Line 1293: jtf_dpf_w.rosetta_table_copy_in_p11(ddp_new_ones, p1_a0

1289: begin
1290:
1291: -- copy data to the local IN or IN-OUT args, if any
1292:
1293: jtf_dpf_w.rosetta_table_copy_in_p11(ddp_new_ones, p1_a0
1294: , p1_a1
1295: );
1296:
1297: -- here's the delegated call to the old PL/SQL routine

Line 1298: jtf_dpf.logical_set_non_default_phys(p_logical_page_id,

1294: , p1_a1
1295: );
1296:
1297: -- here's the delegated call to the old PL/SQL routine
1298: jtf_dpf.logical_set_non_default_phys(p_logical_page_id,
1299: ddp_new_ones);
1300:
1301: -- copy data back from the local OUT or IN-OUT args, if any
1302:

Line 1311: ddp_new_ones jtf_dpf.new_next_log_non_def_tbl;

1307: , p2_a0 JTF_NUMBER_TABLE
1308: , p2_a1 JTF_NUMBER_TABLE
1309: )
1310: as
1311: ddp_new_ones jtf_dpf.new_next_log_non_def_tbl;
1312: ddindx binary_integer; indx binary_integer;
1313: begin
1314:
1315: -- copy data to the local IN or IN-OUT args, if any

Line 1318: jtf_dpf_w.rosetta_table_copy_in_p13(ddp_new_ones, p2_a0

1314:
1315: -- copy data to the local IN or IN-OUT args, if any
1316:
1317:
1318: jtf_dpf_w.rosetta_table_copy_in_p13(ddp_new_ones, p2_a0
1319: , p2_a1
1320: );
1321:
1322: -- here's the delegated call to the old PL/SQL routine

Line 1323: jtf_dpf.next_logical_set_non_default(p_flow_id,

1319: , p2_a1
1320: );
1321:
1322: -- here's the delegated call to the old PL/SQL routine
1323: jtf_dpf.next_logical_set_non_default(p_flow_id,
1324: p_log_page_id,
1325: ddp_new_ones);
1326:
1327: -- copy data back from the local OUT or IN-OUT args, if any

Line 1332: end jtf_dpf_w;

1328:
1329:
1330: end;
1331:
1332: end jtf_dpf_w;