11: procedure save_paymentamount(i_payeeid varchar2,
12: i_name varchar2,
13: i_description varchar2,
14: i_count integer,
15: i_amountranges_lowamtlmt JTF_NUMBER_TABLE,
16: i_amountranges_upramtlmt JTF_NUMBER_TABLE,
17: i_amountranges_seq JTF_NUMBER_TABLE,
18: i_amountranges_score JTF_VARCHAR2_TABLE_100);
19:
12: i_name varchar2,
13: i_description varchar2,
14: i_count integer,
15: i_amountranges_lowamtlmt JTF_NUMBER_TABLE,
16: i_amountranges_upramtlmt JTF_NUMBER_TABLE,
17: i_amountranges_seq JTF_NUMBER_TABLE,
18: i_amountranges_score JTF_VARCHAR2_TABLE_100);
19:
20: /*
13: i_description varchar2,
14: i_count integer,
15: i_amountranges_lowamtlmt JTF_NUMBER_TABLE,
16: i_amountranges_upramtlmt JTF_NUMBER_TABLE,
17: i_amountranges_seq JTF_NUMBER_TABLE,
18: i_amountranges_score JTF_VARCHAR2_TABLE_100);
19:
20: /*
21: ** Name : load_paymentAmount
26: */
27: procedure load_paymentamount(i_payeeid varchar2,
28: o_name out nocopy varchar2,
29: o_description out nocopy varchar2,
30: o_amountranges_lowamtlmt out nocopy JTF_NUMBER_TABLE,
31: o_amountranges_upramtlmt out nocopy JTF_NUMBER_TABLE,
32: o_amountranges_seq out nocopy JTF_NUMBER_TABLE,
33: o_amountranges_score out nocopy JTF_VARCHAR2_TABLE_100);
34:
27: procedure load_paymentamount(i_payeeid varchar2,
28: o_name out nocopy varchar2,
29: o_description out nocopy varchar2,
30: o_amountranges_lowamtlmt out nocopy JTF_NUMBER_TABLE,
31: o_amountranges_upramtlmt out nocopy JTF_NUMBER_TABLE,
32: o_amountranges_seq out nocopy JTF_NUMBER_TABLE,
33: o_amountranges_score out nocopy JTF_VARCHAR2_TABLE_100);
34:
35: /*
28: o_name out nocopy varchar2,
29: o_description out nocopy varchar2,
30: o_amountranges_lowamtlmt out nocopy JTF_NUMBER_TABLE,
31: o_amountranges_upramtlmt out nocopy JTF_NUMBER_TABLE,
32: o_amountranges_seq out nocopy JTF_NUMBER_TABLE,
33: o_amountranges_score out nocopy JTF_VARCHAR2_TABLE_100);
34:
35: /*
36: ** Name : save_timeofpurchase
42: procedure save_timeofpurchase(i_payeeid varchar2,
43: i_name varchar2,
44: i_description varchar2,
45: i_count integer,
46: i_timeranges_lowtimelmt JTF_NUMBER_TABLE,
47: i_timeranges_uprtimelmt JTF_NUMBER_TABLE,
48: i_timeranges_seq JTF_NUMBER_TABLE,
49: i_timeranges_score JTF_VARCHAR2_TABLE_100);
50:
43: i_name varchar2,
44: i_description varchar2,
45: i_count integer,
46: i_timeranges_lowtimelmt JTF_NUMBER_TABLE,
47: i_timeranges_uprtimelmt JTF_NUMBER_TABLE,
48: i_timeranges_seq JTF_NUMBER_TABLE,
49: i_timeranges_score JTF_VARCHAR2_TABLE_100);
50:
51: /*
44: i_description varchar2,
45: i_count integer,
46: i_timeranges_lowtimelmt JTF_NUMBER_TABLE,
47: i_timeranges_uprtimelmt JTF_NUMBER_TABLE,
48: i_timeranges_seq JTF_NUMBER_TABLE,
49: i_timeranges_score JTF_VARCHAR2_TABLE_100);
50:
51: /*
52: ** Name : load_timeofpurchase
57: */
58: procedure load_timeofpurchase(i_payeeid varchar2,
59: o_name out nocopy varchar2,
60: o_description out nocopy varchar2,
61: o_timeranges_lowtimelmt out nocopy JTF_NUMBER_TABLE,
62: o_timeranges_uprtimelmt out nocopy JTF_NUMBER_TABLE,
63: o_timeranges_seq out nocopy JTF_NUMBER_TABLE,
64: o_timeranges_score out nocopy JTF_VARCHAR2_TABLE_100);
65:
58: procedure load_timeofpurchase(i_payeeid varchar2,
59: o_name out nocopy varchar2,
60: o_description out nocopy varchar2,
61: o_timeranges_lowtimelmt out nocopy JTF_NUMBER_TABLE,
62: o_timeranges_uprtimelmt out nocopy JTF_NUMBER_TABLE,
63: o_timeranges_seq out nocopy JTF_NUMBER_TABLE,
64: o_timeranges_score out nocopy JTF_VARCHAR2_TABLE_100);
65:
66: /*
59: o_name out nocopy varchar2,
60: o_description out nocopy varchar2,
61: o_timeranges_lowtimelmt out nocopy JTF_NUMBER_TABLE,
62: o_timeranges_uprtimelmt out nocopy JTF_NUMBER_TABLE,
63: o_timeranges_seq out nocopy JTF_NUMBER_TABLE,
64: o_timeranges_score out nocopy JTF_VARCHAR2_TABLE_100);
65:
66: /*
67: ** Name : save_paymenthistory
75: i_description varchar2,
76: i_duration number,
77: i_durationtype varchar2,
78: i_count integer,
79: i_freqranges_lowfreqlmt JTF_NUMBER_TABLE,
80: i_freqranges_uprfreqlmt JTF_NUMBER_TABLE,
81: i_freqranges_seq JTF_NUMBER_TABLE,
82: i_freqranges_score JTF_VARCHAR2_TABLE_100);
83:
76: i_duration number,
77: i_durationtype varchar2,
78: i_count integer,
79: i_freqranges_lowfreqlmt JTF_NUMBER_TABLE,
80: i_freqranges_uprfreqlmt JTF_NUMBER_TABLE,
81: i_freqranges_seq JTF_NUMBER_TABLE,
82: i_freqranges_score JTF_VARCHAR2_TABLE_100);
83:
84: /*
77: i_durationtype varchar2,
78: i_count integer,
79: i_freqranges_lowfreqlmt JTF_NUMBER_TABLE,
80: i_freqranges_uprfreqlmt JTF_NUMBER_TABLE,
81: i_freqranges_seq JTF_NUMBER_TABLE,
82: i_freqranges_score JTF_VARCHAR2_TABLE_100);
83:
84: /*
85: ** Name : load_paymenthistory
92: o_name out nocopy varchar2,
93: o_description out nocopy varchar2,
94: o_duration out nocopy number,
95: o_durationtype out nocopy varchar2,
96: o_freqranges_lowfreqlmt out nocopy JTF_NUMBER_TABLE,
97: o_freqranges_uprfreqlmt out nocopy JTF_NUMBER_TABLE,
98: o_freqranges_seq out nocopy JTF_NUMBER_TABLE,
99: o_freqranges_score out nocopy JTF_VARCHAR2_TABLE_100);
100:
93: o_description out nocopy varchar2,
94: o_duration out nocopy number,
95: o_durationtype out nocopy varchar2,
96: o_freqranges_lowfreqlmt out nocopy JTF_NUMBER_TABLE,
97: o_freqranges_uprfreqlmt out nocopy JTF_NUMBER_TABLE,
98: o_freqranges_seq out nocopy JTF_NUMBER_TABLE,
99: o_freqranges_score out nocopy JTF_VARCHAR2_TABLE_100);
100:
101: /*
94: o_duration out nocopy number,
95: o_durationtype out nocopy varchar2,
96: o_freqranges_lowfreqlmt out nocopy JTF_NUMBER_TABLE,
97: o_freqranges_uprfreqlmt out nocopy JTF_NUMBER_TABLE,
98: o_freqranges_seq out nocopy JTF_NUMBER_TABLE,
99: o_freqranges_score out nocopy JTF_VARCHAR2_TABLE_100);
100:
101: /*
102: ** Name : save_avsCodes