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:
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
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;
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:
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
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;
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
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();
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();
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
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);
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);
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:
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
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;
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:
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
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;
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
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();
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();
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
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);
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);
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:
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
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;
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:
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
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;
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
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();
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();
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
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);
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);