DBA Data[Home] [Help]

APPS.IBY_FORMULA_PKG_WRAP dependencies on JTF_NUMBER_TABLE

Line 16: o_riskformula_id out nocopy JTF_NUMBER_TABLE,

12: ** to the actual procedure in iby_formula_pkg for Java
13: ** programs to be able to call it.
14: */
15: procedure getpayeeformulas(i_payeeid varchar2,
16: o_riskformula_id out nocopy JTF_NUMBER_TABLE,
17: o_riskformula_name out nocopy JTF_VARCHAR2_TABLE_100,
18: o_riskformula_description out nocopy JTF_VARCHAR2_TABLE_300,
19: o_riskformula_flag out nocopy JTF_NUMBER_TABLE)
20:

Line 19: o_riskformula_flag out nocopy JTF_NUMBER_TABLE)

15: procedure getpayeeformulas(i_payeeid varchar2,
16: o_riskformula_id out nocopy JTF_NUMBER_TABLE,
17: o_riskformula_name out nocopy JTF_VARCHAR2_TABLE_100,
18: o_riskformula_description out nocopy JTF_VARCHAR2_TABLE_300,
19: o_riskformula_flag out nocopy JTF_NUMBER_TABLE)
20:
21: is
22: ddo_riskformula iby_formula_pkg.formula_table;
23: ddindx binary_integer; indx binary_integer;

Line 36: o_riskformula_id := JTF_NUMBER_TABLE();

32:
33: -- copy data back from the local OUT or IN-OUT args, if any
34:
35: if ddo_riskformula is null or ddo_riskformula.count = 0 then
36: o_riskformula_id := JTF_NUMBER_TABLE();
37: o_riskformula_name := JTF_VARCHAR2_TABLE_100();
38: o_riskformula_description := JTF_VARCHAR2_TABLE_300();
39: o_riskformula_flag := JTF_NUMBER_TABLE();
40: else

Line 39: o_riskformula_flag := JTF_NUMBER_TABLE();

35: if ddo_riskformula is null or ddo_riskformula.count = 0 then
36: o_riskformula_id := JTF_NUMBER_TABLE();
37: o_riskformula_name := JTF_VARCHAR2_TABLE_100();
38: o_riskformula_description := JTF_VARCHAR2_TABLE_300();
39: o_riskformula_flag := JTF_NUMBER_TABLE();
40: else
41: o_riskformula_id := JTF_NUMBER_TABLE();
42: o_riskformula_name := JTF_VARCHAR2_TABLE_100();
43: o_riskformula_description := JTF_VARCHAR2_TABLE_300();

Line 41: o_riskformula_id := JTF_NUMBER_TABLE();

37: o_riskformula_name := JTF_VARCHAR2_TABLE_100();
38: o_riskformula_description := JTF_VARCHAR2_TABLE_300();
39: o_riskformula_flag := JTF_NUMBER_TABLE();
40: else
41: o_riskformula_id := JTF_NUMBER_TABLE();
42: o_riskformula_name := JTF_VARCHAR2_TABLE_100();
43: o_riskformula_description := JTF_VARCHAR2_TABLE_300();
44: o_riskformula_flag := JTF_NUMBER_TABLE();
45: -- if ddo_riskformula is not null or ddo_riskformula.count > 0 then

Line 44: o_riskformula_flag := JTF_NUMBER_TABLE();

40: else
41: o_riskformula_id := JTF_NUMBER_TABLE();
42: o_riskformula_name := JTF_VARCHAR2_TABLE_100();
43: o_riskformula_description := JTF_VARCHAR2_TABLE_300();
44: o_riskformula_flag := JTF_NUMBER_TABLE();
45: -- if ddo_riskformula is not null or ddo_riskformula.count > 0 then
46: if ddo_riskformula.count > 0 then
47: o_riskformula_id.extend(ddo_riskformula.count);
48: o_riskformula_name.extend(ddo_riskformula.count);

Line 80: i_factors_weight JTF_NUMBER_TABLE,

76: i_description varchar2,
77: i_flag integer,
78: i_count integer,
79: i_factors_name JTF_VARCHAR2_TABLE_100,
80: i_factors_weight JTF_NUMBER_TABLE,
81: o_id out nocopy number)
82:
83: is
84: ddi_factors iby_formula_pkg.factor_table;

Line 133: i_factors_weight JTF_NUMBER_TABLE)

129: i_description varchar2,
130: i_flag integer,
131: i_count integer,
132: i_factors_name JTF_VARCHAR2_TABLE_100,
133: i_factors_weight JTF_NUMBER_TABLE)
134:
135: is
136: ddi_factors iby_formula_pkg.factor_table;
137: ddindx binary_integer; indx binary_integer;

Line 184: o_factors_weight out nocopy JTF_NUMBER_TABLE)

180: o_name out nocopy varchar2,
181: o_description out nocopy varchar2,
182: o_flag out nocopy integer,
183: o_factors_name out nocopy JTF_VARCHAR2_TABLE_100,
184: o_factors_weight out nocopy JTF_NUMBER_TABLE)
185:
186: is
187: ddo_factors iby_formula_pkg.factor_table;
188: ddindx binary_integer; indx binary_integer;

Line 202: o_factors_weight := JTF_NUMBER_TABLE();

198: -- copy data back from the local OUT or IN-OUT args, if any
199:
200: if ddo_factors is null or ddo_factors.count = 0 then
201: o_factors_name := JTF_VARCHAR2_TABLE_100();
202: o_factors_weight := JTF_NUMBER_TABLE();
203: else
204: o_factors_name := JTF_VARCHAR2_TABLE_100();
205: o_factors_weight := JTF_NUMBER_TABLE();
206: -- if ddo_factors is not null or ddo_factors.count > 0 then

Line 205: o_factors_weight := JTF_NUMBER_TABLE();

201: o_factors_name := JTF_VARCHAR2_TABLE_100();
202: o_factors_weight := JTF_NUMBER_TABLE();
203: else
204: o_factors_name := JTF_VARCHAR2_TABLE_100();
205: o_factors_weight := JTF_NUMBER_TABLE();
206: -- if ddo_factors is not null or ddo_factors.count > 0 then
207: if ddo_factors.count > 0 then
208: o_factors_name.extend(ddo_factors.count);
209: o_factors_weight.extend(ddo_factors.count);