DBA Data[Home] [Help]

APPS.OZF_OFFER_BACKDATE_PVT_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ozf_offer_backdate_pvt.offer_backdate_tbl_type, a0 JTF_NUMBER_TABLE

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_p3(t OUT NOCOPY ozf_offer_backdate_pvt.offer_backdate_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_DATE_TABLE
24: , a2 JTF_DATE_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100

Line 27: , a5 JTF_NUMBER_TABLE

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

Line 28: , a6 JTF_NUMBER_TABLE

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

Line 32: , a10 JTF_NUMBER_TABLE

28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_2000
31: , a9 JTF_DATE_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_DATE_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE

Line 34: , a12 JTF_NUMBER_TABLE

30: , a8 JTF_VARCHAR2_TABLE_2000
31: , a9 JTF_DATE_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_DATE_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: ) as

Line 35: , a13 JTF_NUMBER_TABLE

31: , a9 JTF_DATE_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_DATE_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: ) as
39: ddindx binary_integer; indx binary_integer;

Line 36: , a14 JTF_NUMBER_TABLE

32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_DATE_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: ) as
39: ddindx binary_integer; indx binary_integer;
40: begin

Line 37: , a15 JTF_NUMBER_TABLE

33: , a11 JTF_DATE_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: ) as
39: ddindx binary_integer; indx binary_integer;
40: begin
41: if a0 is not null and a0.count > 0 then

Line 71: procedure rosetta_table_copy_out_p3(t ozf_offer_backdate_pvt.offer_backdate_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE

67: end loop;
68: end if;
69: end if;
70: end rosetta_table_copy_in_p3;
71: procedure rosetta_table_copy_out_p3(t ozf_offer_backdate_pvt.offer_backdate_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
72: , a1 OUT NOCOPY JTF_DATE_TABLE
73: , a2 OUT NOCOPY JTF_DATE_TABLE
74: , a3 OUT NOCOPY JTF_VARCHAR2_TABLE_100
75: , a4 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 76: , a5 OUT NOCOPY JTF_NUMBER_TABLE

72: , a1 OUT NOCOPY JTF_DATE_TABLE
73: , a2 OUT NOCOPY JTF_DATE_TABLE
74: , a3 OUT NOCOPY JTF_VARCHAR2_TABLE_100
75: , a4 OUT NOCOPY JTF_VARCHAR2_TABLE_100
76: , a5 OUT NOCOPY JTF_NUMBER_TABLE
77: , a6 OUT NOCOPY JTF_NUMBER_TABLE
78: , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
79: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
80: , a9 OUT NOCOPY JTF_DATE_TABLE

Line 77: , a6 OUT NOCOPY JTF_NUMBER_TABLE

73: , a2 OUT NOCOPY JTF_DATE_TABLE
74: , a3 OUT NOCOPY JTF_VARCHAR2_TABLE_100
75: , a4 OUT NOCOPY JTF_VARCHAR2_TABLE_100
76: , a5 OUT NOCOPY JTF_NUMBER_TABLE
77: , a6 OUT NOCOPY JTF_NUMBER_TABLE
78: , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
79: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
80: , a9 OUT NOCOPY JTF_DATE_TABLE
81: , a10 OUT NOCOPY JTF_NUMBER_TABLE

Line 81: , a10 OUT NOCOPY JTF_NUMBER_TABLE

77: , a6 OUT NOCOPY JTF_NUMBER_TABLE
78: , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
79: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
80: , a9 OUT NOCOPY JTF_DATE_TABLE
81: , a10 OUT NOCOPY JTF_NUMBER_TABLE
82: , a11 OUT NOCOPY JTF_DATE_TABLE
83: , a12 OUT NOCOPY JTF_NUMBER_TABLE
84: , a13 OUT NOCOPY JTF_NUMBER_TABLE
85: , a14 OUT NOCOPY JTF_NUMBER_TABLE

Line 83: , a12 OUT NOCOPY JTF_NUMBER_TABLE

79: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
80: , a9 OUT NOCOPY JTF_DATE_TABLE
81: , a10 OUT NOCOPY JTF_NUMBER_TABLE
82: , a11 OUT NOCOPY JTF_DATE_TABLE
83: , a12 OUT NOCOPY JTF_NUMBER_TABLE
84: , a13 OUT NOCOPY JTF_NUMBER_TABLE
85: , a14 OUT NOCOPY JTF_NUMBER_TABLE
86: , a15 OUT NOCOPY JTF_NUMBER_TABLE
87: ) as

Line 84: , a13 OUT NOCOPY JTF_NUMBER_TABLE

80: , a9 OUT NOCOPY JTF_DATE_TABLE
81: , a10 OUT NOCOPY JTF_NUMBER_TABLE
82: , a11 OUT NOCOPY JTF_DATE_TABLE
83: , a12 OUT NOCOPY JTF_NUMBER_TABLE
84: , a13 OUT NOCOPY JTF_NUMBER_TABLE
85: , a14 OUT NOCOPY JTF_NUMBER_TABLE
86: , a15 OUT NOCOPY JTF_NUMBER_TABLE
87: ) as
88: ddindx binary_integer; indx binary_integer;

Line 85: , a14 OUT NOCOPY JTF_NUMBER_TABLE

81: , a10 OUT NOCOPY JTF_NUMBER_TABLE
82: , a11 OUT NOCOPY JTF_DATE_TABLE
83: , a12 OUT NOCOPY JTF_NUMBER_TABLE
84: , a13 OUT NOCOPY JTF_NUMBER_TABLE
85: , a14 OUT NOCOPY JTF_NUMBER_TABLE
86: , a15 OUT NOCOPY JTF_NUMBER_TABLE
87: ) as
88: ddindx binary_integer; indx binary_integer;
89: begin

Line 86: , a15 OUT NOCOPY JTF_NUMBER_TABLE

82: , a11 OUT NOCOPY JTF_DATE_TABLE
83: , a12 OUT NOCOPY JTF_NUMBER_TABLE
84: , a13 OUT NOCOPY JTF_NUMBER_TABLE
85: , a14 OUT NOCOPY JTF_NUMBER_TABLE
86: , a15 OUT NOCOPY JTF_NUMBER_TABLE
87: ) as
88: ddindx binary_integer; indx binary_integer;
89: begin
90: if t is null or t.count = 0 then

Line 91: a0 := JTF_NUMBER_TABLE();

87: ) as
88: ddindx binary_integer; indx binary_integer;
89: begin
90: if t is null or t.count = 0 then
91: a0 := JTF_NUMBER_TABLE();
92: a1 := JTF_DATE_TABLE();
93: a2 := JTF_DATE_TABLE();
94: a3 := JTF_VARCHAR2_TABLE_100();
95: a4 := JTF_VARCHAR2_TABLE_100();

Line 96: a5 := JTF_NUMBER_TABLE();

92: a1 := JTF_DATE_TABLE();
93: a2 := JTF_DATE_TABLE();
94: a3 := JTF_VARCHAR2_TABLE_100();
95: a4 := JTF_VARCHAR2_TABLE_100();
96: a5 := JTF_NUMBER_TABLE();
97: a6 := JTF_NUMBER_TABLE();
98: a7 := JTF_VARCHAR2_TABLE_100();
99: a8 := JTF_VARCHAR2_TABLE_2000();
100: a9 := JTF_DATE_TABLE();

Line 97: a6 := JTF_NUMBER_TABLE();

93: a2 := JTF_DATE_TABLE();
94: a3 := JTF_VARCHAR2_TABLE_100();
95: a4 := JTF_VARCHAR2_TABLE_100();
96: a5 := JTF_NUMBER_TABLE();
97: a6 := JTF_NUMBER_TABLE();
98: a7 := JTF_VARCHAR2_TABLE_100();
99: a8 := JTF_VARCHAR2_TABLE_2000();
100: a9 := JTF_DATE_TABLE();
101: a10 := JTF_NUMBER_TABLE();

Line 101: a10 := JTF_NUMBER_TABLE();

97: a6 := JTF_NUMBER_TABLE();
98: a7 := JTF_VARCHAR2_TABLE_100();
99: a8 := JTF_VARCHAR2_TABLE_2000();
100: a9 := JTF_DATE_TABLE();
101: a10 := JTF_NUMBER_TABLE();
102: a11 := JTF_DATE_TABLE();
103: a12 := JTF_NUMBER_TABLE();
104: a13 := JTF_NUMBER_TABLE();
105: a14 := JTF_NUMBER_TABLE();

Line 103: a12 := JTF_NUMBER_TABLE();

99: a8 := JTF_VARCHAR2_TABLE_2000();
100: a9 := JTF_DATE_TABLE();
101: a10 := JTF_NUMBER_TABLE();
102: a11 := JTF_DATE_TABLE();
103: a12 := JTF_NUMBER_TABLE();
104: a13 := JTF_NUMBER_TABLE();
105: a14 := JTF_NUMBER_TABLE();
106: a15 := JTF_NUMBER_TABLE();
107: else

Line 104: a13 := JTF_NUMBER_TABLE();

100: a9 := JTF_DATE_TABLE();
101: a10 := JTF_NUMBER_TABLE();
102: a11 := JTF_DATE_TABLE();
103: a12 := JTF_NUMBER_TABLE();
104: a13 := JTF_NUMBER_TABLE();
105: a14 := JTF_NUMBER_TABLE();
106: a15 := JTF_NUMBER_TABLE();
107: else
108: a0 := JTF_NUMBER_TABLE();

Line 105: a14 := JTF_NUMBER_TABLE();

101: a10 := JTF_NUMBER_TABLE();
102: a11 := JTF_DATE_TABLE();
103: a12 := JTF_NUMBER_TABLE();
104: a13 := JTF_NUMBER_TABLE();
105: a14 := JTF_NUMBER_TABLE();
106: a15 := JTF_NUMBER_TABLE();
107: else
108: a0 := JTF_NUMBER_TABLE();
109: a1 := JTF_DATE_TABLE();

Line 106: a15 := JTF_NUMBER_TABLE();

102: a11 := JTF_DATE_TABLE();
103: a12 := JTF_NUMBER_TABLE();
104: a13 := JTF_NUMBER_TABLE();
105: a14 := JTF_NUMBER_TABLE();
106: a15 := JTF_NUMBER_TABLE();
107: else
108: a0 := JTF_NUMBER_TABLE();
109: a1 := JTF_DATE_TABLE();
110: a2 := JTF_DATE_TABLE();

Line 108: a0 := JTF_NUMBER_TABLE();

104: a13 := JTF_NUMBER_TABLE();
105: a14 := JTF_NUMBER_TABLE();
106: a15 := JTF_NUMBER_TABLE();
107: else
108: a0 := JTF_NUMBER_TABLE();
109: a1 := JTF_DATE_TABLE();
110: a2 := JTF_DATE_TABLE();
111: a3 := JTF_VARCHAR2_TABLE_100();
112: a4 := JTF_VARCHAR2_TABLE_100();

Line 113: a5 := JTF_NUMBER_TABLE();

109: a1 := JTF_DATE_TABLE();
110: a2 := JTF_DATE_TABLE();
111: a3 := JTF_VARCHAR2_TABLE_100();
112: a4 := JTF_VARCHAR2_TABLE_100();
113: a5 := JTF_NUMBER_TABLE();
114: a6 := JTF_NUMBER_TABLE();
115: a7 := JTF_VARCHAR2_TABLE_100();
116: a8 := JTF_VARCHAR2_TABLE_2000();
117: a9 := JTF_DATE_TABLE();

Line 114: a6 := JTF_NUMBER_TABLE();

110: a2 := JTF_DATE_TABLE();
111: a3 := JTF_VARCHAR2_TABLE_100();
112: a4 := JTF_VARCHAR2_TABLE_100();
113: a5 := JTF_NUMBER_TABLE();
114: a6 := JTF_NUMBER_TABLE();
115: a7 := JTF_VARCHAR2_TABLE_100();
116: a8 := JTF_VARCHAR2_TABLE_2000();
117: a9 := JTF_DATE_TABLE();
118: a10 := JTF_NUMBER_TABLE();

Line 118: a10 := JTF_NUMBER_TABLE();

114: a6 := JTF_NUMBER_TABLE();
115: a7 := JTF_VARCHAR2_TABLE_100();
116: a8 := JTF_VARCHAR2_TABLE_2000();
117: a9 := JTF_DATE_TABLE();
118: a10 := JTF_NUMBER_TABLE();
119: a11 := JTF_DATE_TABLE();
120: a12 := JTF_NUMBER_TABLE();
121: a13 := JTF_NUMBER_TABLE();
122: a14 := JTF_NUMBER_TABLE();

Line 120: a12 := JTF_NUMBER_TABLE();

116: a8 := JTF_VARCHAR2_TABLE_2000();
117: a9 := JTF_DATE_TABLE();
118: a10 := JTF_NUMBER_TABLE();
119: a11 := JTF_DATE_TABLE();
120: a12 := JTF_NUMBER_TABLE();
121: a13 := JTF_NUMBER_TABLE();
122: a14 := JTF_NUMBER_TABLE();
123: a15 := JTF_NUMBER_TABLE();
124: if t.count > 0 then

Line 121: a13 := JTF_NUMBER_TABLE();

117: a9 := JTF_DATE_TABLE();
118: a10 := JTF_NUMBER_TABLE();
119: a11 := JTF_DATE_TABLE();
120: a12 := JTF_NUMBER_TABLE();
121: a13 := JTF_NUMBER_TABLE();
122: a14 := JTF_NUMBER_TABLE();
123: a15 := JTF_NUMBER_TABLE();
124: if t.count > 0 then
125: a0.extend(t.count);

Line 122: a14 := JTF_NUMBER_TABLE();

118: a10 := JTF_NUMBER_TABLE();
119: a11 := JTF_DATE_TABLE();
120: a12 := JTF_NUMBER_TABLE();
121: a13 := JTF_NUMBER_TABLE();
122: a14 := JTF_NUMBER_TABLE();
123: a15 := JTF_NUMBER_TABLE();
124: if t.count > 0 then
125: a0.extend(t.count);
126: a1.extend(t.count);

Line 123: a15 := JTF_NUMBER_TABLE();

119: a11 := JTF_DATE_TABLE();
120: a12 := JTF_NUMBER_TABLE();
121: a13 := JTF_NUMBER_TABLE();
122: a14 := JTF_NUMBER_TABLE();
123: a15 := JTF_NUMBER_TABLE();
124: if t.count > 0 then
125: a0.extend(t.count);
126: a1.extend(t.count);
127: a2.extend(t.count);