DBA Data[Home] [Help]

APPS.IBY_RISKYINSTR_PKG_WRAP dependencies on JTF_VARCHAR2_TABLE_100

Line 5: i_riskyinstr_payeeid JTF_VARCHAR2_TABLE_100,

1: package body iby_riskyinstr_pkg_wrap as
2: /*$Header: ibyrkwrb.pls 115.4 2002/11/20 00:00:26 jleybovi ship $*/
3:
4: procedure add_riskyinstr(i_count integer,
5: i_riskyinstr_payeeid JTF_VARCHAR2_TABLE_100,
6: i_riskyinstr_instrtype JTF_VARCHAR2_TABLE_100,
7: i_riskyinstr_routing_num JTF_VARCHAR2_TABLE_100,
8: i_riskyinstr_account_num JTF_VARCHAR2_TABLE_100,
9: i_riskyinstr_creditcard_num JTF_VARCHAR2_TABLE_100,

Line 6: i_riskyinstr_instrtype JTF_VARCHAR2_TABLE_100,

2: /*$Header: ibyrkwrb.pls 115.4 2002/11/20 00:00:26 jleybovi ship $*/
3:
4: procedure add_riskyinstr(i_count integer,
5: i_riskyinstr_payeeid JTF_VARCHAR2_TABLE_100,
6: i_riskyinstr_instrtype JTF_VARCHAR2_TABLE_100,
7: i_riskyinstr_routing_num JTF_VARCHAR2_TABLE_100,
8: i_riskyinstr_account_num JTF_VARCHAR2_TABLE_100,
9: i_riskyinstr_creditcard_num JTF_VARCHAR2_TABLE_100,
10: o_results_success out nocopy JTF_NUMBER_TABLE,

Line 7: i_riskyinstr_routing_num JTF_VARCHAR2_TABLE_100,

3:
4: procedure add_riskyinstr(i_count integer,
5: i_riskyinstr_payeeid JTF_VARCHAR2_TABLE_100,
6: i_riskyinstr_instrtype JTF_VARCHAR2_TABLE_100,
7: i_riskyinstr_routing_num JTF_VARCHAR2_TABLE_100,
8: i_riskyinstr_account_num JTF_VARCHAR2_TABLE_100,
9: i_riskyinstr_creditcard_num JTF_VARCHAR2_TABLE_100,
10: o_results_success out nocopy JTF_NUMBER_TABLE,
11: o_results_errmsg out nocopy JTF_VARCHAR2_TABLE_100)

Line 8: i_riskyinstr_account_num JTF_VARCHAR2_TABLE_100,

4: procedure add_riskyinstr(i_count integer,
5: i_riskyinstr_payeeid JTF_VARCHAR2_TABLE_100,
6: i_riskyinstr_instrtype JTF_VARCHAR2_TABLE_100,
7: i_riskyinstr_routing_num JTF_VARCHAR2_TABLE_100,
8: i_riskyinstr_account_num JTF_VARCHAR2_TABLE_100,
9: i_riskyinstr_creditcard_num JTF_VARCHAR2_TABLE_100,
10: o_results_success out nocopy JTF_NUMBER_TABLE,
11: o_results_errmsg out nocopy JTF_VARCHAR2_TABLE_100)
12:

Line 9: i_riskyinstr_creditcard_num JTF_VARCHAR2_TABLE_100,

5: i_riskyinstr_payeeid JTF_VARCHAR2_TABLE_100,
6: i_riskyinstr_instrtype JTF_VARCHAR2_TABLE_100,
7: i_riskyinstr_routing_num JTF_VARCHAR2_TABLE_100,
8: i_riskyinstr_account_num JTF_VARCHAR2_TABLE_100,
9: i_riskyinstr_creditcard_num JTF_VARCHAR2_TABLE_100,
10: o_results_success out nocopy JTF_NUMBER_TABLE,
11: o_results_errmsg out nocopy JTF_VARCHAR2_TABLE_100)
12:
13: is

Line 11: o_results_errmsg out nocopy JTF_VARCHAR2_TABLE_100)

7: i_riskyinstr_routing_num JTF_VARCHAR2_TABLE_100,
8: i_riskyinstr_account_num JTF_VARCHAR2_TABLE_100,
9: i_riskyinstr_creditcard_num JTF_VARCHAR2_TABLE_100,
10: o_results_success out nocopy JTF_NUMBER_TABLE,
11: o_results_errmsg out nocopy JTF_VARCHAR2_TABLE_100)
12:
13: is
14:
15: ddi_riskyinstr iby_riskyinstr_pkg.riskyinstr_table;

Line 54: o_results_errmsg := JTF_VARCHAR2_TABLE_100();

50:
51:
52: if ddo_results is null or ddo_results.count = 0 then
53: o_results_success := JTF_NUMBER_TABLE();
54: o_results_errmsg := JTF_VARCHAR2_TABLE_100();
55: else
56: o_results_success := JTF_NUMBER_TABLE();
57: o_results_errmsg := JTF_VARCHAR2_TABLE_100();
58: if ddo_results.count > 0 then

Line 57: o_results_errmsg := JTF_VARCHAR2_TABLE_100();

53: o_results_success := JTF_NUMBER_TABLE();
54: o_results_errmsg := JTF_VARCHAR2_TABLE_100();
55: else
56: o_results_success := JTF_NUMBER_TABLE();
57: o_results_errmsg := JTF_VARCHAR2_TABLE_100();
58: if ddo_results.count > 0 then
59: o_results_success.extend(ddo_results.count);
60: o_results_errmsg.extend(ddo_results.count);
61: ddindx := ddo_results.first;

Line 77: i_riskyinstr_payeeid JTF_VARCHAR2_TABLE_100,

73: end if;
74: end;
75:
76: procedure delete_riskyinstr(i_count integer,
77: i_riskyinstr_payeeid JTF_VARCHAR2_TABLE_100,
78: i_riskyinstr_instrtype JTF_VARCHAR2_TABLE_100,
79: i_riskyinstr_routing_num JTF_VARCHAR2_TABLE_100,
80: i_riskyinstr_account_num JTF_VARCHAR2_TABLE_100,
81: i_riskyinstr_creditcard_num JTF_VARCHAR2_TABLE_100,

Line 78: i_riskyinstr_instrtype JTF_VARCHAR2_TABLE_100,

74: end;
75:
76: procedure delete_riskyinstr(i_count integer,
77: i_riskyinstr_payeeid JTF_VARCHAR2_TABLE_100,
78: i_riskyinstr_instrtype JTF_VARCHAR2_TABLE_100,
79: i_riskyinstr_routing_num JTF_VARCHAR2_TABLE_100,
80: i_riskyinstr_account_num JTF_VARCHAR2_TABLE_100,
81: i_riskyinstr_creditcard_num JTF_VARCHAR2_TABLE_100,
82: o_results_success out nocopy JTF_NUMBER_TABLE,

Line 79: i_riskyinstr_routing_num JTF_VARCHAR2_TABLE_100,

75:
76: procedure delete_riskyinstr(i_count integer,
77: i_riskyinstr_payeeid JTF_VARCHAR2_TABLE_100,
78: i_riskyinstr_instrtype JTF_VARCHAR2_TABLE_100,
79: i_riskyinstr_routing_num JTF_VARCHAR2_TABLE_100,
80: i_riskyinstr_account_num JTF_VARCHAR2_TABLE_100,
81: i_riskyinstr_creditcard_num JTF_VARCHAR2_TABLE_100,
82: o_results_success out nocopy JTF_NUMBER_TABLE,
83: o_results_errmsg out nocopy JTF_VARCHAR2_TABLE_100)

Line 80: i_riskyinstr_account_num JTF_VARCHAR2_TABLE_100,

76: procedure delete_riskyinstr(i_count integer,
77: i_riskyinstr_payeeid JTF_VARCHAR2_TABLE_100,
78: i_riskyinstr_instrtype JTF_VARCHAR2_TABLE_100,
79: i_riskyinstr_routing_num JTF_VARCHAR2_TABLE_100,
80: i_riskyinstr_account_num JTF_VARCHAR2_TABLE_100,
81: i_riskyinstr_creditcard_num JTF_VARCHAR2_TABLE_100,
82: o_results_success out nocopy JTF_NUMBER_TABLE,
83: o_results_errmsg out nocopy JTF_VARCHAR2_TABLE_100)
84:

Line 81: i_riskyinstr_creditcard_num JTF_VARCHAR2_TABLE_100,

77: i_riskyinstr_payeeid JTF_VARCHAR2_TABLE_100,
78: i_riskyinstr_instrtype JTF_VARCHAR2_TABLE_100,
79: i_riskyinstr_routing_num JTF_VARCHAR2_TABLE_100,
80: i_riskyinstr_account_num JTF_VARCHAR2_TABLE_100,
81: i_riskyinstr_creditcard_num JTF_VARCHAR2_TABLE_100,
82: o_results_success out nocopy JTF_NUMBER_TABLE,
83: o_results_errmsg out nocopy JTF_VARCHAR2_TABLE_100)
84:
85: is

Line 83: o_results_errmsg out nocopy JTF_VARCHAR2_TABLE_100)

79: i_riskyinstr_routing_num JTF_VARCHAR2_TABLE_100,
80: i_riskyinstr_account_num JTF_VARCHAR2_TABLE_100,
81: i_riskyinstr_creditcard_num JTF_VARCHAR2_TABLE_100,
82: o_results_success out nocopy JTF_NUMBER_TABLE,
83: o_results_errmsg out nocopy JTF_VARCHAR2_TABLE_100)
84:
85: is
86: ddi_riskyinstr iby_riskyinstr_pkg.riskyinstr_table;
87: ddo_results iby_riskyinstr_pkg.result_table;

Line 123: o_results_errmsg := JTF_VARCHAR2_TABLE_100();

119:
120:
121: if ddo_results is null or ddo_results.count = 0 then
122: o_results_success := JTF_NUMBER_TABLE();
123: o_results_errmsg := JTF_VARCHAR2_TABLE_100();
124: else
125: o_results_success := JTF_NUMBER_TABLE();
126: o_results_errmsg := JTF_VARCHAR2_TABLE_100();
127: if ddo_results.count > 0 then

Line 126: o_results_errmsg := JTF_VARCHAR2_TABLE_100();

122: o_results_success := JTF_NUMBER_TABLE();
123: o_results_errmsg := JTF_VARCHAR2_TABLE_100();
124: else
125: o_results_success := JTF_NUMBER_TABLE();
126: o_results_errmsg := JTF_VARCHAR2_TABLE_100();
127: if ddo_results.count > 0 then
128: o_results_success.extend(ddo_results.count);
129: o_results_errmsg.extend(ddo_results.count);
130: ddindx := ddo_results.first;