DBA Data[Home] [Help]

APPS.IBY_FORMULA_PKG_WRAP dependencies on JTF_VARCHAR2_TABLE_100

Line 17: o_riskformula_name out nocopy JTF_VARCHAR2_TABLE_100,

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:
21: is

Line 37: o_riskformula_name := JTF_VARCHAR2_TABLE_100();

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
41: o_riskformula_id := JTF_NUMBER_TABLE();

Line 42: 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
46: if ddo_riskformula.count > 0 then

Line 79: i_factors_name JTF_VARCHAR2_TABLE_100,

75: procedure createformula(i_payeeid varchar2, i_name varchar2,
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

Line 132: i_factors_name JTF_VARCHAR2_TABLE_100,

128: i_name varchar2,
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;

Line 183: o_factors_name out nocopy JTF_VARCHAR2_TABLE_100,

179: procedure loadformula(i_factorid number,
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;

Line 201: o_factors_name := JTF_VARCHAR2_TABLE_100();

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

Line 204: o_factors_name := JTF_VARCHAR2_TABLE_100();

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
207: if ddo_factors.count > 0 then
208: o_factors_name.extend(ddo_factors.count);