DBA Data[Home] [Help]

APPS.CN_SF_PARAMS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 13: procedure rosetta_table_copy_in_p1(t out nocopy cn_sf_params_pvt.sf_repositories_tbl_type, a0 JTF_NUMBER_TABLE

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy cn_sf_params_pvt.sf_repositories_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_100
15: , a2 JTF_VARCHAR2_TABLE_2000
16: , a3 JTF_VARCHAR2_TABLE_1000
17: , a4 JTF_VARCHAR2_TABLE_100

Line 20: , a7 JTF_NUMBER_TABLE

16: , a3 JTF_VARCHAR2_TABLE_1000
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_NUMBER_TABLE
24: ) as

Line 22: , a9 JTF_NUMBER_TABLE

18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_NUMBER_TABLE
24: ) as
25: ddindx binary_integer; indx binary_integer;
26: begin

Line 23: , a10 JTF_NUMBER_TABLE

19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_NUMBER_TABLE
24: ) as
25: ddindx binary_integer; indx binary_integer;
26: begin
27: if a0 is not null and a0.count > 0 then

Line 52: procedure rosetta_table_copy_out_p1(t cn_sf_params_pvt.sf_repositories_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

48: end loop;
49: end if;
50: end if;
51: end rosetta_table_copy_in_p1;
52: procedure rosetta_table_copy_out_p1(t cn_sf_params_pvt.sf_repositories_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
53: , a1 out nocopy JTF_VARCHAR2_TABLE_100
54: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
55: , a3 out nocopy JTF_VARCHAR2_TABLE_1000
56: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 59: , a7 out nocopy JTF_NUMBER_TABLE

55: , a3 out nocopy JTF_VARCHAR2_TABLE_1000
56: , a4 out nocopy JTF_VARCHAR2_TABLE_100
57: , a5 out nocopy JTF_VARCHAR2_TABLE_100
58: , a6 out nocopy JTF_VARCHAR2_TABLE_100
59: , a7 out nocopy JTF_NUMBER_TABLE
60: , a8 out nocopy JTF_VARCHAR2_TABLE_100
61: , a9 out nocopy JTF_NUMBER_TABLE
62: , a10 out nocopy JTF_NUMBER_TABLE
63: ) as

Line 61: , a9 out nocopy JTF_NUMBER_TABLE

57: , a5 out nocopy JTF_VARCHAR2_TABLE_100
58: , a6 out nocopy JTF_VARCHAR2_TABLE_100
59: , a7 out nocopy JTF_NUMBER_TABLE
60: , a8 out nocopy JTF_VARCHAR2_TABLE_100
61: , a9 out nocopy JTF_NUMBER_TABLE
62: , a10 out nocopy JTF_NUMBER_TABLE
63: ) as
64: ddindx binary_integer; indx binary_integer;
65: begin

Line 62: , a10 out nocopy JTF_NUMBER_TABLE

58: , a6 out nocopy JTF_VARCHAR2_TABLE_100
59: , a7 out nocopy JTF_NUMBER_TABLE
60: , a8 out nocopy JTF_VARCHAR2_TABLE_100
61: , a9 out nocopy JTF_NUMBER_TABLE
62: , a10 out nocopy JTF_NUMBER_TABLE
63: ) as
64: ddindx binary_integer; indx binary_integer;
65: begin
66: if t is null or t.count = 0 then

Line 67: a0 := JTF_NUMBER_TABLE();

63: ) as
64: ddindx binary_integer; indx binary_integer;
65: begin
66: if t is null or t.count = 0 then
67: a0 := JTF_NUMBER_TABLE();
68: a1 := JTF_VARCHAR2_TABLE_100();
69: a2 := JTF_VARCHAR2_TABLE_2000();
70: a3 := JTF_VARCHAR2_TABLE_1000();
71: a4 := JTF_VARCHAR2_TABLE_100();

Line 74: a7 := JTF_NUMBER_TABLE();

70: a3 := JTF_VARCHAR2_TABLE_1000();
71: a4 := JTF_VARCHAR2_TABLE_100();
72: a5 := JTF_VARCHAR2_TABLE_100();
73: a6 := JTF_VARCHAR2_TABLE_100();
74: a7 := JTF_NUMBER_TABLE();
75: a8 := JTF_VARCHAR2_TABLE_100();
76: a9 := JTF_NUMBER_TABLE();
77: a10 := JTF_NUMBER_TABLE();
78: else

Line 76: a9 := JTF_NUMBER_TABLE();

72: a5 := JTF_VARCHAR2_TABLE_100();
73: a6 := JTF_VARCHAR2_TABLE_100();
74: a7 := JTF_NUMBER_TABLE();
75: a8 := JTF_VARCHAR2_TABLE_100();
76: a9 := JTF_NUMBER_TABLE();
77: a10 := JTF_NUMBER_TABLE();
78: else
79: a0 := JTF_NUMBER_TABLE();
80: a1 := JTF_VARCHAR2_TABLE_100();

Line 77: a10 := JTF_NUMBER_TABLE();

73: a6 := JTF_VARCHAR2_TABLE_100();
74: a7 := JTF_NUMBER_TABLE();
75: a8 := JTF_VARCHAR2_TABLE_100();
76: a9 := JTF_NUMBER_TABLE();
77: a10 := JTF_NUMBER_TABLE();
78: else
79: a0 := JTF_NUMBER_TABLE();
80: a1 := JTF_VARCHAR2_TABLE_100();
81: a2 := JTF_VARCHAR2_TABLE_2000();

Line 79: a0 := JTF_NUMBER_TABLE();

75: a8 := JTF_VARCHAR2_TABLE_100();
76: a9 := JTF_NUMBER_TABLE();
77: a10 := JTF_NUMBER_TABLE();
78: else
79: a0 := JTF_NUMBER_TABLE();
80: a1 := JTF_VARCHAR2_TABLE_100();
81: a2 := JTF_VARCHAR2_TABLE_2000();
82: a3 := JTF_VARCHAR2_TABLE_1000();
83: a4 := JTF_VARCHAR2_TABLE_100();

Line 86: a7 := JTF_NUMBER_TABLE();

82: a3 := JTF_VARCHAR2_TABLE_1000();
83: a4 := JTF_VARCHAR2_TABLE_100();
84: a5 := JTF_VARCHAR2_TABLE_100();
85: a6 := JTF_VARCHAR2_TABLE_100();
86: a7 := JTF_NUMBER_TABLE();
87: a8 := JTF_VARCHAR2_TABLE_100();
88: a9 := JTF_NUMBER_TABLE();
89: a10 := JTF_NUMBER_TABLE();
90: if t.count > 0 then

Line 88: a9 := JTF_NUMBER_TABLE();

84: a5 := JTF_VARCHAR2_TABLE_100();
85: a6 := JTF_VARCHAR2_TABLE_100();
86: a7 := JTF_NUMBER_TABLE();
87: a8 := JTF_VARCHAR2_TABLE_100();
88: a9 := JTF_NUMBER_TABLE();
89: a10 := JTF_NUMBER_TABLE();
90: if t.count > 0 then
91: a0.extend(t.count);
92: a1.extend(t.count);

Line 89: a10 := JTF_NUMBER_TABLE();

85: a6 := JTF_VARCHAR2_TABLE_100();
86: a7 := JTF_NUMBER_TABLE();
87: a8 := JTF_VARCHAR2_TABLE_100();
88: a9 := JTF_NUMBER_TABLE();
89: a10 := JTF_NUMBER_TABLE();
90: if t.count > 0 then
91: a0.extend(t.count);
92: a1.extend(t.count);
93: a2.extend(t.count);