DBA Data[Home] [Help]

APPS.AMS_IBA_PL_SITES_PVT_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p3(t out nocopy ams_iba_pl_sites_pvt.iba_pl_sites_tbl_type, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p3(t out nocopy ams_iba_pl_sites_pvt.iba_pl_sites_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100

Line 25: , a3 JTF_NUMBER_TABLE

21:
22: procedure rosetta_table_copy_in_p3(t out nocopy ams_iba_pl_sites_pvt.iba_pl_sites_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_DATE_TABLE
29: , a7 JTF_NUMBER_TABLE

Line 27: , a5 JTF_NUMBER_TABLE

23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_DATE_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_DATE_TABLE
31: , a9 JTF_NUMBER_TABLE

Line 29: , a7 JTF_NUMBER_TABLE

25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_DATE_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_DATE_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_VARCHAR2_TABLE_300

Line 31: , a9 JTF_NUMBER_TABLE

27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_DATE_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_DATE_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_VARCHAR2_TABLE_300
34: , a12 JTF_VARCHAR2_TABLE_4000
35: ) as

Line 32: , a10 JTF_NUMBER_TABLE

28: , a6 JTF_DATE_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_DATE_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_VARCHAR2_TABLE_300
34: , a12 JTF_VARCHAR2_TABLE_4000
35: ) as
36: ddindx binary_integer; indx binary_integer;

Line 65: procedure rosetta_table_copy_out_p3(t ams_iba_pl_sites_pvt.iba_pl_sites_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

61: end loop;
62: end if;
63: end if;
64: end rosetta_table_copy_in_p3;
65: procedure rosetta_table_copy_out_p3(t ams_iba_pl_sites_pvt.iba_pl_sites_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
66: , a1 out nocopy JTF_VARCHAR2_TABLE_100
67: , a2 out nocopy JTF_VARCHAR2_TABLE_100
68: , a3 out nocopy JTF_NUMBER_TABLE
69: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 68: , a3 out nocopy JTF_NUMBER_TABLE

64: end rosetta_table_copy_in_p3;
65: procedure rosetta_table_copy_out_p3(t ams_iba_pl_sites_pvt.iba_pl_sites_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
66: , a1 out nocopy JTF_VARCHAR2_TABLE_100
67: , a2 out nocopy JTF_VARCHAR2_TABLE_100
68: , a3 out nocopy JTF_NUMBER_TABLE
69: , a4 out nocopy JTF_VARCHAR2_TABLE_100
70: , a5 out nocopy JTF_NUMBER_TABLE
71: , a6 out nocopy JTF_DATE_TABLE
72: , a7 out nocopy JTF_NUMBER_TABLE

Line 70: , a5 out nocopy JTF_NUMBER_TABLE

66: , a1 out nocopy JTF_VARCHAR2_TABLE_100
67: , a2 out nocopy JTF_VARCHAR2_TABLE_100
68: , a3 out nocopy JTF_NUMBER_TABLE
69: , a4 out nocopy JTF_VARCHAR2_TABLE_100
70: , a5 out nocopy JTF_NUMBER_TABLE
71: , a6 out nocopy JTF_DATE_TABLE
72: , a7 out nocopy JTF_NUMBER_TABLE
73: , a8 out nocopy JTF_DATE_TABLE
74: , a9 out nocopy JTF_NUMBER_TABLE

Line 72: , a7 out nocopy JTF_NUMBER_TABLE

68: , a3 out nocopy JTF_NUMBER_TABLE
69: , a4 out nocopy JTF_VARCHAR2_TABLE_100
70: , a5 out nocopy JTF_NUMBER_TABLE
71: , a6 out nocopy JTF_DATE_TABLE
72: , a7 out nocopy JTF_NUMBER_TABLE
73: , a8 out nocopy JTF_DATE_TABLE
74: , a9 out nocopy JTF_NUMBER_TABLE
75: , a10 out nocopy JTF_NUMBER_TABLE
76: , a11 out nocopy JTF_VARCHAR2_TABLE_300

Line 74: , a9 out nocopy JTF_NUMBER_TABLE

70: , a5 out nocopy JTF_NUMBER_TABLE
71: , a6 out nocopy JTF_DATE_TABLE
72: , a7 out nocopy JTF_NUMBER_TABLE
73: , a8 out nocopy JTF_DATE_TABLE
74: , a9 out nocopy JTF_NUMBER_TABLE
75: , a10 out nocopy JTF_NUMBER_TABLE
76: , a11 out nocopy JTF_VARCHAR2_TABLE_300
77: , a12 out nocopy JTF_VARCHAR2_TABLE_4000
78: ) as

Line 75: , a10 out nocopy JTF_NUMBER_TABLE

71: , a6 out nocopy JTF_DATE_TABLE
72: , a7 out nocopy JTF_NUMBER_TABLE
73: , a8 out nocopy JTF_DATE_TABLE
74: , a9 out nocopy JTF_NUMBER_TABLE
75: , a10 out nocopy JTF_NUMBER_TABLE
76: , a11 out nocopy JTF_VARCHAR2_TABLE_300
77: , a12 out nocopy JTF_VARCHAR2_TABLE_4000
78: ) as
79: ddindx binary_integer; indx binary_integer;

Line 82: a0 := JTF_NUMBER_TABLE();

78: ) as
79: ddindx binary_integer; indx binary_integer;
80: begin
81: if t is null or t.count = 0 then
82: a0 := JTF_NUMBER_TABLE();
83: a1 := JTF_VARCHAR2_TABLE_100();
84: a2 := JTF_VARCHAR2_TABLE_100();
85: a3 := JTF_NUMBER_TABLE();
86: a4 := JTF_VARCHAR2_TABLE_100();

Line 85: a3 := JTF_NUMBER_TABLE();

81: if t is null or t.count = 0 then
82: a0 := JTF_NUMBER_TABLE();
83: a1 := JTF_VARCHAR2_TABLE_100();
84: a2 := JTF_VARCHAR2_TABLE_100();
85: a3 := JTF_NUMBER_TABLE();
86: a4 := JTF_VARCHAR2_TABLE_100();
87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_DATE_TABLE();
89: a7 := JTF_NUMBER_TABLE();

Line 87: a5 := JTF_NUMBER_TABLE();

83: a1 := JTF_VARCHAR2_TABLE_100();
84: a2 := JTF_VARCHAR2_TABLE_100();
85: a3 := JTF_NUMBER_TABLE();
86: a4 := JTF_VARCHAR2_TABLE_100();
87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_DATE_TABLE();
89: a7 := JTF_NUMBER_TABLE();
90: a8 := JTF_DATE_TABLE();
91: a9 := JTF_NUMBER_TABLE();

Line 89: a7 := JTF_NUMBER_TABLE();

85: a3 := JTF_NUMBER_TABLE();
86: a4 := JTF_VARCHAR2_TABLE_100();
87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_DATE_TABLE();
89: a7 := JTF_NUMBER_TABLE();
90: a8 := JTF_DATE_TABLE();
91: a9 := JTF_NUMBER_TABLE();
92: a10 := JTF_NUMBER_TABLE();
93: a11 := JTF_VARCHAR2_TABLE_300();

Line 91: a9 := JTF_NUMBER_TABLE();

87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_DATE_TABLE();
89: a7 := JTF_NUMBER_TABLE();
90: a8 := JTF_DATE_TABLE();
91: a9 := JTF_NUMBER_TABLE();
92: a10 := JTF_NUMBER_TABLE();
93: a11 := JTF_VARCHAR2_TABLE_300();
94: a12 := JTF_VARCHAR2_TABLE_4000();
95: else

Line 92: a10 := JTF_NUMBER_TABLE();

88: a6 := JTF_DATE_TABLE();
89: a7 := JTF_NUMBER_TABLE();
90: a8 := JTF_DATE_TABLE();
91: a9 := JTF_NUMBER_TABLE();
92: a10 := JTF_NUMBER_TABLE();
93: a11 := JTF_VARCHAR2_TABLE_300();
94: a12 := JTF_VARCHAR2_TABLE_4000();
95: else
96: a0 := JTF_NUMBER_TABLE();

Line 96: a0 := JTF_NUMBER_TABLE();

92: a10 := JTF_NUMBER_TABLE();
93: a11 := JTF_VARCHAR2_TABLE_300();
94: a12 := JTF_VARCHAR2_TABLE_4000();
95: else
96: a0 := JTF_NUMBER_TABLE();
97: a1 := JTF_VARCHAR2_TABLE_100();
98: a2 := JTF_VARCHAR2_TABLE_100();
99: a3 := JTF_NUMBER_TABLE();
100: a4 := JTF_VARCHAR2_TABLE_100();

Line 99: a3 := JTF_NUMBER_TABLE();

95: else
96: a0 := JTF_NUMBER_TABLE();
97: a1 := JTF_VARCHAR2_TABLE_100();
98: a2 := JTF_VARCHAR2_TABLE_100();
99: a3 := JTF_NUMBER_TABLE();
100: a4 := JTF_VARCHAR2_TABLE_100();
101: a5 := JTF_NUMBER_TABLE();
102: a6 := JTF_DATE_TABLE();
103: a7 := JTF_NUMBER_TABLE();

Line 101: a5 := JTF_NUMBER_TABLE();

97: a1 := JTF_VARCHAR2_TABLE_100();
98: a2 := JTF_VARCHAR2_TABLE_100();
99: a3 := JTF_NUMBER_TABLE();
100: a4 := JTF_VARCHAR2_TABLE_100();
101: a5 := JTF_NUMBER_TABLE();
102: a6 := JTF_DATE_TABLE();
103: a7 := JTF_NUMBER_TABLE();
104: a8 := JTF_DATE_TABLE();
105: a9 := JTF_NUMBER_TABLE();

Line 103: a7 := JTF_NUMBER_TABLE();

99: a3 := JTF_NUMBER_TABLE();
100: a4 := JTF_VARCHAR2_TABLE_100();
101: a5 := JTF_NUMBER_TABLE();
102: a6 := JTF_DATE_TABLE();
103: a7 := JTF_NUMBER_TABLE();
104: a8 := JTF_DATE_TABLE();
105: a9 := JTF_NUMBER_TABLE();
106: a10 := JTF_NUMBER_TABLE();
107: a11 := JTF_VARCHAR2_TABLE_300();

Line 105: a9 := JTF_NUMBER_TABLE();

101: a5 := JTF_NUMBER_TABLE();
102: a6 := JTF_DATE_TABLE();
103: a7 := JTF_NUMBER_TABLE();
104: a8 := JTF_DATE_TABLE();
105: a9 := JTF_NUMBER_TABLE();
106: a10 := JTF_NUMBER_TABLE();
107: a11 := JTF_VARCHAR2_TABLE_300();
108: a12 := JTF_VARCHAR2_TABLE_4000();
109: if t.count > 0 then

Line 106: a10 := JTF_NUMBER_TABLE();

102: a6 := JTF_DATE_TABLE();
103: a7 := JTF_NUMBER_TABLE();
104: a8 := JTF_DATE_TABLE();
105: a9 := JTF_NUMBER_TABLE();
106: a10 := JTF_NUMBER_TABLE();
107: a11 := JTF_VARCHAR2_TABLE_300();
108: a12 := JTF_VARCHAR2_TABLE_4000();
109: if t.count > 0 then
110: a0.extend(t.count);