DBA Data[Home] [Help]

APPS.IBY_FACTOR_PKG_WRAP dependencies on JTF_VARCHAR2_TABLE_100

Line 22: i_amountranges_score JTF_VARCHAR2_TABLE_100)

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;
26: ddindx binary_integer; indx binary_integer;

Line 78: o_amountranges_score out nocopy JTF_VARCHAR2_TABLE_100)

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;
82: ddindx binary_integer; indx binary_integer;

Line 97: o_amountranges_score := JTF_VARCHAR2_TABLE_100();

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();
101: o_amountranges_seq := JTF_NUMBER_TABLE();

Line 102: 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);
106: o_amountranges_seq.extend(ddo_amountranges.count);

Line 141: i_timeranges_score JTF_VARCHAR2_TABLE_100)

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;
145: ddindx binary_integer; indx binary_integer;

Line 192: o_timeranges_score out nocopy JTF_VARCHAR2_TABLE_100)

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;
196: ddindx binary_integer; indx binary_integer;

Line 213: o_timeranges_score := JTF_VARCHAR2_TABLE_100();

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();
217: o_timeranges_seq := JTF_NUMBER_TABLE();

Line 218: 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);
222: o_timeranges_seq.extend(ddo_timeranges.count);

Line 257: i_freqranges_score JTF_VARCHAR2_TABLE_100)

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;
261: ddindx binary_integer; indx binary_integer;

Line 312: o_freqranges_score out nocopy JTF_VARCHAR2_TABLE_100)

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;
316: ddindx binary_integer; indx binary_integer;

Line 335: o_freqranges_score := JTF_VARCHAR2_TABLE_100();

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();
339: o_freqranges_seq := JTF_NUMBER_TABLE();

Line 340: 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);
344: o_freqranges_seq.extend(ddo_freqranges.count);

Line 374: i_codes_code JTF_VARCHAR2_TABLE_100,

370: procedure save_avscodes(i_payeeid varchar2,
371: i_name varchar2,
372: i_description varchar2,
373: i_count integer,
374: i_codes_code JTF_VARCHAR2_TABLE_100,
375: i_codes_score JTF_VARCHAR2_TABLE_100)
376:
377: is
378: ddi_codes iby_factor_pkg.codes_table;

Line 375: i_codes_score JTF_VARCHAR2_TABLE_100)

371: i_name varchar2,
372: i_description varchar2,
373: i_count integer,
374: i_codes_code JTF_VARCHAR2_TABLE_100,
375: i_codes_score JTF_VARCHAR2_TABLE_100)
376:
377: is
378: ddi_codes iby_factor_pkg.codes_table;
379: ddindx binary_integer; indx binary_integer;

Line 420: o_codes_code out nocopy JTF_VARCHAR2_TABLE_100,

416: */
417: procedure load_avscodes(i_payeeid varchar2,
418: o_name out nocopy varchar2,
419: o_description out nocopy varchar2,
420: o_codes_code out nocopy JTF_VARCHAR2_TABLE_100,
421: o_codes_score out nocopy JTF_VARCHAR2_TABLE_100)
422:
423: is
424: ddo_codes iby_factor_pkg.codes_table;

Line 421: o_codes_score out nocopy JTF_VARCHAR2_TABLE_100)

417: procedure load_avscodes(i_payeeid varchar2,
418: o_name out nocopy varchar2,
419: o_description out nocopy varchar2,
420: o_codes_code out nocopy JTF_VARCHAR2_TABLE_100,
421: o_codes_score out nocopy JTF_VARCHAR2_TABLE_100)
422:
423: is
424: ddo_codes iby_factor_pkg.codes_table;
425: ddindx binary_integer; indx binary_integer;

Line 439: o_codes_code := JTF_VARCHAR2_TABLE_100();

435: -- copy data back from the local OUT or IN-OUT args, if any
436:
437:
438: if ddo_codes is null or ddo_codes.count = 0 then
439: o_codes_code := JTF_VARCHAR2_TABLE_100();
440: o_codes_score := JTF_VARCHAR2_TABLE_100();
441: else
442: o_codes_code := JTF_VARCHAR2_TABLE_100();
443: o_codes_score := JTF_VARCHAR2_TABLE_100();

Line 440: o_codes_score := JTF_VARCHAR2_TABLE_100();

436:
437:
438: if ddo_codes is null or ddo_codes.count = 0 then
439: o_codes_code := JTF_VARCHAR2_TABLE_100();
440: o_codes_score := JTF_VARCHAR2_TABLE_100();
441: else
442: o_codes_code := JTF_VARCHAR2_TABLE_100();
443: o_codes_score := JTF_VARCHAR2_TABLE_100();
444: if ddo_codes.count > 0 then

Line 442: o_codes_code := JTF_VARCHAR2_TABLE_100();

438: if ddo_codes is null or ddo_codes.count = 0 then
439: o_codes_code := JTF_VARCHAR2_TABLE_100();
440: o_codes_score := JTF_VARCHAR2_TABLE_100();
441: else
442: o_codes_code := JTF_VARCHAR2_TABLE_100();
443: o_codes_score := JTF_VARCHAR2_TABLE_100();
444: if ddo_codes.count > 0 then
445: o_codes_code.extend(ddo_codes.count);
446: o_codes_score.extend(ddo_codes.count);

Line 443: o_codes_score := JTF_VARCHAR2_TABLE_100();

439: o_codes_code := JTF_VARCHAR2_TABLE_100();
440: o_codes_score := JTF_VARCHAR2_TABLE_100();
441: else
442: o_codes_code := JTF_VARCHAR2_TABLE_100();
443: o_codes_score := JTF_VARCHAR2_TABLE_100();
444: if ddo_codes.count > 0 then
445: o_codes_code.extend(ddo_codes.count);
446: o_codes_score.extend(ddo_codes.count);
447: ddindx := ddo_codes.first;

Line 473: i_codes_code JTF_VARCHAR2_TABLE_100,

469: procedure save_riskcodes(i_payeeid varchar2,
470: i_name varchar2,
471: i_description varchar2,
472: i_count integer,
473: i_codes_code JTF_VARCHAR2_TABLE_100,
474: i_codes_score JTF_VARCHAR2_TABLE_100)
475:
476: is
477: ddi_codes iby_factor_pkg.codes_table;

Line 474: i_codes_score JTF_VARCHAR2_TABLE_100)

470: i_name varchar2,
471: i_description varchar2,
472: i_count integer,
473: i_codes_code JTF_VARCHAR2_TABLE_100,
474: i_codes_score JTF_VARCHAR2_TABLE_100)
475:
476: is
477: ddi_codes iby_factor_pkg.codes_table;
478: ddindx binary_integer; indx binary_integer;

Line 519: o_codes_code out nocopy JTF_VARCHAR2_TABLE_100,

515: */
516: procedure load_riskcodes(i_payeeid varchar2,
517: o_name out nocopy varchar2,
518: o_description out nocopy varchar2,
519: o_codes_code out nocopy JTF_VARCHAR2_TABLE_100,
520: o_codes_score out nocopy JTF_VARCHAR2_TABLE_100)
521:
522: is
523: ddo_codes iby_factor_pkg.codes_table;

Line 520: o_codes_score out nocopy JTF_VARCHAR2_TABLE_100)

516: procedure load_riskcodes(i_payeeid varchar2,
517: o_name out nocopy varchar2,
518: o_description out nocopy varchar2,
519: o_codes_code out nocopy JTF_VARCHAR2_TABLE_100,
520: o_codes_score out nocopy JTF_VARCHAR2_TABLE_100)
521:
522: is
523: ddo_codes iby_factor_pkg.codes_table;
524: ddindx binary_integer; indx binary_integer;

Line 538: o_codes_code := JTF_VARCHAR2_TABLE_100();

534: -- copy data back from the local OUT or IN-OUT args, if any
535:
536:
537: if ddo_codes is null or ddo_codes.count = 0 then
538: o_codes_code := JTF_VARCHAR2_TABLE_100();
539: o_codes_score := JTF_VARCHAR2_TABLE_100();
540: else
541: o_codes_code := JTF_VARCHAR2_TABLE_100();
542: o_codes_score := JTF_VARCHAR2_TABLE_100();

Line 539: o_codes_score := JTF_VARCHAR2_TABLE_100();

535:
536:
537: if ddo_codes is null or ddo_codes.count = 0 then
538: o_codes_code := JTF_VARCHAR2_TABLE_100();
539: o_codes_score := JTF_VARCHAR2_TABLE_100();
540: else
541: o_codes_code := JTF_VARCHAR2_TABLE_100();
542: o_codes_score := JTF_VARCHAR2_TABLE_100();
543: if ddo_codes.count > 0 then

Line 541: o_codes_code := JTF_VARCHAR2_TABLE_100();

537: if ddo_codes is null or ddo_codes.count = 0 then
538: o_codes_code := JTF_VARCHAR2_TABLE_100();
539: o_codes_score := JTF_VARCHAR2_TABLE_100();
540: else
541: o_codes_code := JTF_VARCHAR2_TABLE_100();
542: o_codes_score := JTF_VARCHAR2_TABLE_100();
543: if ddo_codes.count > 0 then
544: o_codes_code.extend(ddo_codes.count);
545: o_codes_score.extend(ddo_codes.count);

Line 542: o_codes_score := JTF_VARCHAR2_TABLE_100();

538: o_codes_code := JTF_VARCHAR2_TABLE_100();
539: o_codes_score := JTF_VARCHAR2_TABLE_100();
540: else
541: o_codes_code := JTF_VARCHAR2_TABLE_100();
542: o_codes_score := JTF_VARCHAR2_TABLE_100();
543: if ddo_codes.count > 0 then
544: o_codes_code.extend(ddo_codes.count);
545: o_codes_score.extend(ddo_codes.count);
546: ddindx := ddo_codes.first;

Line 572: i_codes_code JTF_VARCHAR2_TABLE_100,

568: procedure save_creditratingcodes(i_payeeid varchar2,
569: i_name varchar2,
570: i_description varchar2,
571: i_count integer,
572: i_codes_code JTF_VARCHAR2_TABLE_100,
573: i_codes_score JTF_VARCHAR2_TABLE_100)
574:
575: is
576: ddi_codes iby_factor_pkg.codes_table;

Line 573: i_codes_score JTF_VARCHAR2_TABLE_100)

569: i_name varchar2,
570: i_description varchar2,
571: i_count integer,
572: i_codes_code JTF_VARCHAR2_TABLE_100,
573: i_codes_score JTF_VARCHAR2_TABLE_100)
574:
575: is
576: ddi_codes iby_factor_pkg.codes_table;
577: ddindx binary_integer; indx binary_integer;

Line 618: o_codes_code out nocopy JTF_VARCHAR2_TABLE_100,

614: */
615: procedure load_creditratingcodes(i_payeeid varchar2,
616: o_name out nocopy varchar2,
617: o_description out nocopy varchar2,
618: o_codes_code out nocopy JTF_VARCHAR2_TABLE_100,
619: o_codes_score out nocopy JTF_VARCHAR2_TABLE_100)
620:
621: is
622: ddo_codes iby_factor_pkg.codes_table;

Line 619: o_codes_score out nocopy JTF_VARCHAR2_TABLE_100)

615: procedure load_creditratingcodes(i_payeeid varchar2,
616: o_name out nocopy varchar2,
617: o_description out nocopy varchar2,
618: o_codes_code out nocopy JTF_VARCHAR2_TABLE_100,
619: o_codes_score out nocopy JTF_VARCHAR2_TABLE_100)
620:
621: is
622: ddo_codes iby_factor_pkg.codes_table;
623: ddindx binary_integer; indx binary_integer;

Line 637: o_codes_code := JTF_VARCHAR2_TABLE_100();

633: -- copy data back from the local OUT or IN-OUT args, if any
634:
635:
636: if ddo_codes is null or ddo_codes.count = 0 then
637: o_codes_code := JTF_VARCHAR2_TABLE_100();
638: o_codes_score := JTF_VARCHAR2_TABLE_100();
639: else
640: o_codes_code := JTF_VARCHAR2_TABLE_100();
641: o_codes_score := JTF_VARCHAR2_TABLE_100();

Line 638: o_codes_score := JTF_VARCHAR2_TABLE_100();

634:
635:
636: if ddo_codes is null or ddo_codes.count = 0 then
637: o_codes_code := JTF_VARCHAR2_TABLE_100();
638: o_codes_score := JTF_VARCHAR2_TABLE_100();
639: else
640: o_codes_code := JTF_VARCHAR2_TABLE_100();
641: o_codes_score := JTF_VARCHAR2_TABLE_100();
642: if ddo_codes.count > 0 then

Line 640: o_codes_code := JTF_VARCHAR2_TABLE_100();

636: if ddo_codes is null or ddo_codes.count = 0 then
637: o_codes_code := JTF_VARCHAR2_TABLE_100();
638: o_codes_score := JTF_VARCHAR2_TABLE_100();
639: else
640: o_codes_code := JTF_VARCHAR2_TABLE_100();
641: o_codes_score := JTF_VARCHAR2_TABLE_100();
642: if ddo_codes.count > 0 then
643: o_codes_code.extend(ddo_codes.count);
644: o_codes_score.extend(ddo_codes.count);

Line 641: o_codes_score := JTF_VARCHAR2_TABLE_100();

637: o_codes_code := JTF_VARCHAR2_TABLE_100();
638: o_codes_score := JTF_VARCHAR2_TABLE_100();
639: else
640: o_codes_code := JTF_VARCHAR2_TABLE_100();
641: o_codes_score := JTF_VARCHAR2_TABLE_100();
642: if ddo_codes.count > 0 then
643: o_codes_code.extend(ddo_codes.count);
644: o_codes_score.extend(ddo_codes.count);
645: ddindx := ddo_codes.first;