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
22: ddo_riskformula iby_formula_pkg.formula_table;
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();
42: o_riskformula_name := JTF_VARCHAR2_TABLE_100();
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
47: o_riskformula_id.extend(ddo_riskformula.count);