DBA Data[Home] [Help]

APPS.IBY_FACTOR_PKG_WRAP dependencies on JTF_NUMBER_TABLE

Line 19: i_amountranges_lowamtlmt JTF_NUMBER_TABLE,

15: procedure save_paymentamount(i_payeeid varchar2,
16: i_name varchar2,
17: i_description varchar2,
18: i_count integer,
19: i_amountranges_lowamtlmt JTF_NUMBER_TABLE,
20: i_amountranges_upramtlmt JTF_NUMBER_TABLE,
21: i_amountranges_seq JTF_NUMBER_TABLE,
22: i_amountranges_score JTF_VARCHAR2_TABLE_100)
23:

Line 20: i_amountranges_upramtlmt JTF_NUMBER_TABLE,

16: i_name varchar2,
17: i_description varchar2,
18: i_count integer,
19: i_amountranges_lowamtlmt JTF_NUMBER_TABLE,
20: i_amountranges_upramtlmt JTF_NUMBER_TABLE,
21: i_amountranges_seq JTF_NUMBER_TABLE,
22: i_amountranges_score JTF_VARCHAR2_TABLE_100)
23:
24: is

Line 21: i_amountranges_seq JTF_NUMBER_TABLE,

17: i_description varchar2,
18: i_count integer,
19: i_amountranges_lowamtlmt JTF_NUMBER_TABLE,
20: i_amountranges_upramtlmt JTF_NUMBER_TABLE,
21: i_amountranges_seq JTF_NUMBER_TABLE,
22: i_amountranges_score JTF_VARCHAR2_TABLE_100)
23:
24: is
25: ddi_amountranges iby_factor_pkg.amountrange_table;

Line 75: o_amountranges_lowamtlmt out nocopy JTF_NUMBER_TABLE,

71: */
72: procedure load_paymentamount(i_payeeid varchar2,
73: o_name out nocopy varchar2,
74: o_description out nocopy varchar2,
75: o_amountranges_lowamtlmt out nocopy JTF_NUMBER_TABLE,
76: o_amountranges_upramtlmt out nocopy JTF_NUMBER_TABLE,
77: o_amountranges_seq out nocopy JTF_NUMBER_TABLE,
78: o_amountranges_score out nocopy JTF_VARCHAR2_TABLE_100)
79:

Line 76: o_amountranges_upramtlmt out nocopy JTF_NUMBER_TABLE,

72: procedure load_paymentamount(i_payeeid varchar2,
73: o_name out nocopy varchar2,
74: o_description out nocopy varchar2,
75: o_amountranges_lowamtlmt out nocopy JTF_NUMBER_TABLE,
76: o_amountranges_upramtlmt out nocopy JTF_NUMBER_TABLE,
77: o_amountranges_seq out nocopy JTF_NUMBER_TABLE,
78: o_amountranges_score out nocopy JTF_VARCHAR2_TABLE_100)
79:
80: is

Line 77: o_amountranges_seq out nocopy JTF_NUMBER_TABLE,

73: o_name out nocopy varchar2,
74: o_description out nocopy varchar2,
75: o_amountranges_lowamtlmt out nocopy JTF_NUMBER_TABLE,
76: o_amountranges_upramtlmt out nocopy JTF_NUMBER_TABLE,
77: o_amountranges_seq out nocopy JTF_NUMBER_TABLE,
78: o_amountranges_score out nocopy JTF_VARCHAR2_TABLE_100)
79:
80: is
81: ddo_amountranges iby_factor_pkg.amountrange_table;

Line 94: o_amountranges_lowamtlmt := JTF_NUMBER_TABLE();

90:
91: -- copy data back from the local OUT or IN-OUT args, if any
92:
93: if ddo_amountranges is null or ddo_amountranges.count = 0 then
94: o_amountranges_lowamtlmt := JTF_NUMBER_TABLE();
95: o_amountranges_upramtlmt := JTF_NUMBER_TABLE();
96: o_amountranges_seq := JTF_NUMBER_TABLE();
97: o_amountranges_score := JTF_VARCHAR2_TABLE_100();
98: else

Line 95: o_amountranges_upramtlmt := JTF_NUMBER_TABLE();

91: -- copy data back from the local OUT or IN-OUT args, if any
92:
93: if ddo_amountranges is null or ddo_amountranges.count = 0 then
94: o_amountranges_lowamtlmt := JTF_NUMBER_TABLE();
95: o_amountranges_upramtlmt := JTF_NUMBER_TABLE();
96: o_amountranges_seq := JTF_NUMBER_TABLE();
97: o_amountranges_score := JTF_VARCHAR2_TABLE_100();
98: else
99: o_amountranges_lowamtlmt := JTF_NUMBER_TABLE();

Line 96: o_amountranges_seq := JTF_NUMBER_TABLE();

92:
93: if ddo_amountranges is null or ddo_amountranges.count = 0 then
94: o_amountranges_lowamtlmt := JTF_NUMBER_TABLE();
95: o_amountranges_upramtlmt := JTF_NUMBER_TABLE();
96: o_amountranges_seq := JTF_NUMBER_TABLE();
97: o_amountranges_score := JTF_VARCHAR2_TABLE_100();
98: else
99: o_amountranges_lowamtlmt := JTF_NUMBER_TABLE();
100: o_amountranges_upramtlmt := JTF_NUMBER_TABLE();

Line 99: o_amountranges_lowamtlmt := JTF_NUMBER_TABLE();

95: o_amountranges_upramtlmt := JTF_NUMBER_TABLE();
96: o_amountranges_seq := JTF_NUMBER_TABLE();
97: o_amountranges_score := JTF_VARCHAR2_TABLE_100();
98: else
99: o_amountranges_lowamtlmt := JTF_NUMBER_TABLE();
100: o_amountranges_upramtlmt := JTF_NUMBER_TABLE();
101: o_amountranges_seq := JTF_NUMBER_TABLE();
102: o_amountranges_score := JTF_VARCHAR2_TABLE_100();
103: if ddo_amountranges.count > 0 then

Line 100: o_amountranges_upramtlmt := JTF_NUMBER_TABLE();

96: o_amountranges_seq := JTF_NUMBER_TABLE();
97: o_amountranges_score := JTF_VARCHAR2_TABLE_100();
98: else
99: o_amountranges_lowamtlmt := JTF_NUMBER_TABLE();
100: o_amountranges_upramtlmt := JTF_NUMBER_TABLE();
101: o_amountranges_seq := JTF_NUMBER_TABLE();
102: o_amountranges_score := JTF_VARCHAR2_TABLE_100();
103: if ddo_amountranges.count > 0 then
104: o_amountranges_lowamtlmt.extend(ddo_amountranges.count);

Line 101: o_amountranges_seq := JTF_NUMBER_TABLE();

97: o_amountranges_score := JTF_VARCHAR2_TABLE_100();
98: else
99: o_amountranges_lowamtlmt := JTF_NUMBER_TABLE();
100: o_amountranges_upramtlmt := JTF_NUMBER_TABLE();
101: o_amountranges_seq := JTF_NUMBER_TABLE();
102: o_amountranges_score := JTF_VARCHAR2_TABLE_100();
103: if ddo_amountranges.count > 0 then
104: o_amountranges_lowamtlmt.extend(ddo_amountranges.count);
105: o_amountranges_upramtlmt.extend(ddo_amountranges.count);

Line 138: i_timeranges_lowtimelmt JTF_NUMBER_TABLE,

134: procedure save_timeofpurchase(i_payeeid varchar2,
135: i_name varchar2,
136: i_description varchar2,
137: i_count integer,
138: i_timeranges_lowtimelmt JTF_NUMBER_TABLE,
139: i_timeranges_uprtimelmt JTF_NUMBER_TABLE,
140: i_timeranges_seq JTF_NUMBER_TABLE,
141: i_timeranges_score JTF_VARCHAR2_TABLE_100)
142:

Line 139: i_timeranges_uprtimelmt JTF_NUMBER_TABLE,

135: i_name varchar2,
136: i_description varchar2,
137: i_count integer,
138: i_timeranges_lowtimelmt JTF_NUMBER_TABLE,
139: i_timeranges_uprtimelmt JTF_NUMBER_TABLE,
140: i_timeranges_seq JTF_NUMBER_TABLE,
141: i_timeranges_score JTF_VARCHAR2_TABLE_100)
142:
143: is

Line 140: i_timeranges_seq JTF_NUMBER_TABLE,

136: i_description varchar2,
137: i_count integer,
138: i_timeranges_lowtimelmt JTF_NUMBER_TABLE,
139: i_timeranges_uprtimelmt JTF_NUMBER_TABLE,
140: i_timeranges_seq JTF_NUMBER_TABLE,
141: i_timeranges_score JTF_VARCHAR2_TABLE_100)
142:
143: is
144: ddi_timeranges iby_factor_pkg.timerange_table;

Line 189: o_timeranges_lowtimelmt out nocopy JTF_NUMBER_TABLE,

185: */
186: procedure load_timeofpurchase(i_payeeid varchar2,
187: o_name out nocopy varchar2,
188: o_description out nocopy varchar2,
189: o_timeranges_lowtimelmt out nocopy JTF_NUMBER_TABLE,
190: o_timeranges_uprtimelmt out nocopy JTF_NUMBER_TABLE,
191: o_timeranges_seq out nocopy JTF_NUMBER_TABLE,
192: o_timeranges_score out nocopy JTF_VARCHAR2_TABLE_100)
193:

Line 190: o_timeranges_uprtimelmt out nocopy JTF_NUMBER_TABLE,

186: procedure load_timeofpurchase(i_payeeid varchar2,
187: o_name out nocopy varchar2,
188: o_description out nocopy varchar2,
189: o_timeranges_lowtimelmt out nocopy JTF_NUMBER_TABLE,
190: o_timeranges_uprtimelmt out nocopy JTF_NUMBER_TABLE,
191: o_timeranges_seq out nocopy JTF_NUMBER_TABLE,
192: o_timeranges_score out nocopy JTF_VARCHAR2_TABLE_100)
193:
194: is

Line 191: o_timeranges_seq out nocopy JTF_NUMBER_TABLE,

187: o_name out nocopy varchar2,
188: o_description out nocopy varchar2,
189: o_timeranges_lowtimelmt out nocopy JTF_NUMBER_TABLE,
190: o_timeranges_uprtimelmt out nocopy JTF_NUMBER_TABLE,
191: o_timeranges_seq out nocopy JTF_NUMBER_TABLE,
192: o_timeranges_score out nocopy JTF_VARCHAR2_TABLE_100)
193:
194: is
195: ddo_timeranges iby_factor_pkg.timerange_table;

Line 210: o_timeranges_lowtimelmt := JTF_NUMBER_TABLE();

206: -- copy data back from the local OUT or IN-OUT args, if any
207:
208:
209: if ddo_timeranges is null or ddo_timeranges.count = 0 then
210: o_timeranges_lowtimelmt := JTF_NUMBER_TABLE();
211: o_timeranges_uprtimelmt := JTF_NUMBER_TABLE();
212: o_timeranges_seq := JTF_NUMBER_TABLE();
213: o_timeranges_score := JTF_VARCHAR2_TABLE_100();
214: else

Line 211: o_timeranges_uprtimelmt := JTF_NUMBER_TABLE();

207:
208:
209: if ddo_timeranges is null or ddo_timeranges.count = 0 then
210: o_timeranges_lowtimelmt := JTF_NUMBER_TABLE();
211: o_timeranges_uprtimelmt := JTF_NUMBER_TABLE();
212: o_timeranges_seq := JTF_NUMBER_TABLE();
213: o_timeranges_score := JTF_VARCHAR2_TABLE_100();
214: else
215: o_timeranges_lowtimelmt := JTF_NUMBER_TABLE();

Line 212: o_timeranges_seq := JTF_NUMBER_TABLE();

208:
209: if ddo_timeranges is null or ddo_timeranges.count = 0 then
210: o_timeranges_lowtimelmt := JTF_NUMBER_TABLE();
211: o_timeranges_uprtimelmt := JTF_NUMBER_TABLE();
212: o_timeranges_seq := JTF_NUMBER_TABLE();
213: o_timeranges_score := JTF_VARCHAR2_TABLE_100();
214: else
215: o_timeranges_lowtimelmt := JTF_NUMBER_TABLE();
216: o_timeranges_uprtimelmt := JTF_NUMBER_TABLE();

Line 215: o_timeranges_lowtimelmt := JTF_NUMBER_TABLE();

211: o_timeranges_uprtimelmt := JTF_NUMBER_TABLE();
212: o_timeranges_seq := JTF_NUMBER_TABLE();
213: o_timeranges_score := JTF_VARCHAR2_TABLE_100();
214: else
215: o_timeranges_lowtimelmt := JTF_NUMBER_TABLE();
216: o_timeranges_uprtimelmt := JTF_NUMBER_TABLE();
217: o_timeranges_seq := JTF_NUMBER_TABLE();
218: o_timeranges_score := JTF_VARCHAR2_TABLE_100();
219: if ddo_timeranges.count > 0 then

Line 216: o_timeranges_uprtimelmt := JTF_NUMBER_TABLE();

212: o_timeranges_seq := JTF_NUMBER_TABLE();
213: o_timeranges_score := JTF_VARCHAR2_TABLE_100();
214: else
215: o_timeranges_lowtimelmt := JTF_NUMBER_TABLE();
216: o_timeranges_uprtimelmt := JTF_NUMBER_TABLE();
217: o_timeranges_seq := JTF_NUMBER_TABLE();
218: o_timeranges_score := JTF_VARCHAR2_TABLE_100();
219: if ddo_timeranges.count > 0 then
220: o_timeranges_lowtimelmt.extend(ddo_timeranges.count);

Line 217: o_timeranges_seq := JTF_NUMBER_TABLE();

213: o_timeranges_score := JTF_VARCHAR2_TABLE_100();
214: else
215: o_timeranges_lowtimelmt := JTF_NUMBER_TABLE();
216: o_timeranges_uprtimelmt := JTF_NUMBER_TABLE();
217: o_timeranges_seq := JTF_NUMBER_TABLE();
218: o_timeranges_score := JTF_VARCHAR2_TABLE_100();
219: if ddo_timeranges.count > 0 then
220: o_timeranges_lowtimelmt.extend(ddo_timeranges.count);
221: o_timeranges_uprtimelmt.extend(ddo_timeranges.count);

Line 254: i_freqranges_lowfreqlmt JTF_NUMBER_TABLE,

250: i_description varchar2,
251: i_duration number,
252: i_durationtype varchar2,
253: i_count integer,
254: i_freqranges_lowfreqlmt JTF_NUMBER_TABLE,
255: i_freqranges_uprfreqlmt JTF_NUMBER_TABLE,
256: i_freqranges_seq JTF_NUMBER_TABLE,
257: i_freqranges_score JTF_VARCHAR2_TABLE_100)
258:

Line 255: i_freqranges_uprfreqlmt JTF_NUMBER_TABLE,

251: i_duration number,
252: i_durationtype varchar2,
253: i_count integer,
254: i_freqranges_lowfreqlmt JTF_NUMBER_TABLE,
255: i_freqranges_uprfreqlmt JTF_NUMBER_TABLE,
256: i_freqranges_seq JTF_NUMBER_TABLE,
257: i_freqranges_score JTF_VARCHAR2_TABLE_100)
258:
259: is

Line 256: i_freqranges_seq JTF_NUMBER_TABLE,

252: i_durationtype varchar2,
253: i_count integer,
254: i_freqranges_lowfreqlmt JTF_NUMBER_TABLE,
255: i_freqranges_uprfreqlmt JTF_NUMBER_TABLE,
256: i_freqranges_seq JTF_NUMBER_TABLE,
257: i_freqranges_score JTF_VARCHAR2_TABLE_100)
258:
259: is
260: ddi_freqranges iby_factor_pkg.freqrange_table;

Line 309: o_freqranges_lowfreqlmt out nocopy JTF_NUMBER_TABLE,

305: o_name out nocopy varchar2,
306: o_description out nocopy varchar2,
307: o_duration out nocopy number,
308: o_durationtype out nocopy varchar2,
309: o_freqranges_lowfreqlmt out nocopy JTF_NUMBER_TABLE,
310: o_freqranges_uprfreqlmt out nocopy JTF_NUMBER_TABLE,
311: o_freqranges_seq out nocopy JTF_NUMBER_TABLE,
312: o_freqranges_score out nocopy JTF_VARCHAR2_TABLE_100)
313:

Line 310: o_freqranges_uprfreqlmt out nocopy JTF_NUMBER_TABLE,

306: o_description out nocopy varchar2,
307: o_duration out nocopy number,
308: o_durationtype out nocopy varchar2,
309: o_freqranges_lowfreqlmt out nocopy JTF_NUMBER_TABLE,
310: o_freqranges_uprfreqlmt out nocopy JTF_NUMBER_TABLE,
311: o_freqranges_seq out nocopy JTF_NUMBER_TABLE,
312: o_freqranges_score out nocopy JTF_VARCHAR2_TABLE_100)
313:
314: is

Line 311: o_freqranges_seq out nocopy JTF_NUMBER_TABLE,

307: o_duration out nocopy number,
308: o_durationtype out nocopy varchar2,
309: o_freqranges_lowfreqlmt out nocopy JTF_NUMBER_TABLE,
310: o_freqranges_uprfreqlmt out nocopy JTF_NUMBER_TABLE,
311: o_freqranges_seq out nocopy JTF_NUMBER_TABLE,
312: o_freqranges_score out nocopy JTF_VARCHAR2_TABLE_100)
313:
314: is
315: ddo_freqranges iby_factor_pkg.freqrange_table;

Line 332: o_freqranges_lowfreqlmt := JTF_NUMBER_TABLE();

328:
329: -- copy data back from the local OUT or IN-OUT args, if any
330:
331: if ddo_freqranges is null or ddo_freqranges.count = 0 then
332: o_freqranges_lowfreqlmt := JTF_NUMBER_TABLE();
333: o_freqranges_uprfreqlmt := JTF_NUMBER_TABLE();
334: o_freqranges_seq := JTF_NUMBER_TABLE();
335: o_freqranges_score := JTF_VARCHAR2_TABLE_100();
336: else

Line 333: o_freqranges_uprfreqlmt := JTF_NUMBER_TABLE();

329: -- copy data back from the local OUT or IN-OUT args, if any
330:
331: if ddo_freqranges is null or ddo_freqranges.count = 0 then
332: o_freqranges_lowfreqlmt := JTF_NUMBER_TABLE();
333: o_freqranges_uprfreqlmt := JTF_NUMBER_TABLE();
334: o_freqranges_seq := JTF_NUMBER_TABLE();
335: o_freqranges_score := JTF_VARCHAR2_TABLE_100();
336: else
337: o_freqranges_lowfreqlmt := JTF_NUMBER_TABLE();

Line 334: o_freqranges_seq := JTF_NUMBER_TABLE();

330:
331: if ddo_freqranges is null or ddo_freqranges.count = 0 then
332: o_freqranges_lowfreqlmt := JTF_NUMBER_TABLE();
333: o_freqranges_uprfreqlmt := JTF_NUMBER_TABLE();
334: o_freqranges_seq := JTF_NUMBER_TABLE();
335: o_freqranges_score := JTF_VARCHAR2_TABLE_100();
336: else
337: o_freqranges_lowfreqlmt := JTF_NUMBER_TABLE();
338: o_freqranges_uprfreqlmt := JTF_NUMBER_TABLE();

Line 337: o_freqranges_lowfreqlmt := JTF_NUMBER_TABLE();

333: o_freqranges_uprfreqlmt := JTF_NUMBER_TABLE();
334: o_freqranges_seq := JTF_NUMBER_TABLE();
335: o_freqranges_score := JTF_VARCHAR2_TABLE_100();
336: else
337: o_freqranges_lowfreqlmt := JTF_NUMBER_TABLE();
338: o_freqranges_uprfreqlmt := JTF_NUMBER_TABLE();
339: o_freqranges_seq := JTF_NUMBER_TABLE();
340: o_freqranges_score := JTF_VARCHAR2_TABLE_100();
341: if ddo_freqranges.count > 0 then

Line 338: o_freqranges_uprfreqlmt := JTF_NUMBER_TABLE();

334: o_freqranges_seq := JTF_NUMBER_TABLE();
335: o_freqranges_score := JTF_VARCHAR2_TABLE_100();
336: else
337: o_freqranges_lowfreqlmt := JTF_NUMBER_TABLE();
338: o_freqranges_uprfreqlmt := JTF_NUMBER_TABLE();
339: o_freqranges_seq := JTF_NUMBER_TABLE();
340: o_freqranges_score := JTF_VARCHAR2_TABLE_100();
341: if ddo_freqranges.count > 0 then
342: o_freqranges_lowfreqlmt.extend(ddo_freqranges.count);

Line 339: o_freqranges_seq := JTF_NUMBER_TABLE();

335: o_freqranges_score := JTF_VARCHAR2_TABLE_100();
336: else
337: o_freqranges_lowfreqlmt := JTF_NUMBER_TABLE();
338: o_freqranges_uprfreqlmt := JTF_NUMBER_TABLE();
339: o_freqranges_seq := JTF_NUMBER_TABLE();
340: o_freqranges_score := JTF_VARCHAR2_TABLE_100();
341: if ddo_freqranges.count > 0 then
342: o_freqranges_lowfreqlmt.extend(ddo_freqranges.count);
343: o_freqranges_uprfreqlmt.extend(ddo_freqranges.count);