DBA Data[Home] [Help]

APPS.OKL_K_RATE_PARAMS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 23: , a1 JTF_VARCHAR2_TABLE_100

19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out nocopy okl_k_rate_params_pvt.krpdel_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_DATE_TABLE
25: ) as
26: ddindx binary_integer; indx binary_integer;
27: begin

Line 46: , a1 out nocopy JTF_VARCHAR2_TABLE_100

42: end if;
43: end if;
44: end rosetta_table_copy_in_p1;
45: procedure rosetta_table_copy_out_p1(t okl_k_rate_params_pvt.krpdel_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
46: , a1 out nocopy JTF_VARCHAR2_TABLE_100
47: , a2 out nocopy JTF_DATE_TABLE
48: ) as
49: ddindx binary_integer; indx binary_integer;
50: begin

Line 53: a1 := JTF_VARCHAR2_TABLE_100();

49: ddindx binary_integer; indx binary_integer;
50: begin
51: if t is null or t.count = 0 then
52: a0 := JTF_NUMBER_TABLE();
53: a1 := JTF_VARCHAR2_TABLE_100();
54: a2 := JTF_DATE_TABLE();
55: else
56: a0 := JTF_NUMBER_TABLE();
57: a1 := JTF_VARCHAR2_TABLE_100();

Line 57: a1 := JTF_VARCHAR2_TABLE_100();

53: a1 := JTF_VARCHAR2_TABLE_100();
54: a2 := JTF_DATE_TABLE();
55: else
56: a0 := JTF_NUMBER_TABLE();
57: a1 := JTF_VARCHAR2_TABLE_100();
58: a2 := JTF_DATE_TABLE();
59: if t.count > 0 then
60: a0.extend(t.count);
61: a1.extend(t.count);

Line 79: procedure rosetta_table_copy_in_p6(t out nocopy okl_k_rate_params_pvt.var_prm_tbl_type, a0 JTF_VARCHAR2_TABLE_100

75: end if;
76: end if;
77: end rosetta_table_copy_out_p1;
78:
79: procedure rosetta_table_copy_in_p6(t out nocopy okl_k_rate_params_pvt.var_prm_tbl_type, a0 JTF_VARCHAR2_TABLE_100
80: , a1 JTF_VARCHAR2_TABLE_100
81: , a2 JTF_VARCHAR2_TABLE_100
82: , a3 JTF_NUMBER_TABLE
83: , a4 JTF_DATE_TABLE

Line 80: , a1 JTF_VARCHAR2_TABLE_100

76: end if;
77: end rosetta_table_copy_out_p1;
78:
79: procedure rosetta_table_copy_in_p6(t out nocopy okl_k_rate_params_pvt.var_prm_tbl_type, a0 JTF_VARCHAR2_TABLE_100
80: , a1 JTF_VARCHAR2_TABLE_100
81: , a2 JTF_VARCHAR2_TABLE_100
82: , a3 JTF_NUMBER_TABLE
83: , a4 JTF_DATE_TABLE
84: , a5 JTF_DATE_TABLE

Line 81: , a2 JTF_VARCHAR2_TABLE_100

77: end rosetta_table_copy_out_p1;
78:
79: procedure rosetta_table_copy_in_p6(t out nocopy okl_k_rate_params_pvt.var_prm_tbl_type, a0 JTF_VARCHAR2_TABLE_100
80: , a1 JTF_VARCHAR2_TABLE_100
81: , a2 JTF_VARCHAR2_TABLE_100
82: , a3 JTF_NUMBER_TABLE
83: , a4 JTF_DATE_TABLE
84: , a5 JTF_DATE_TABLE
85: ) as

Line 108: procedure rosetta_table_copy_out_p6(t okl_k_rate_params_pvt.var_prm_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

104: end loop;
105: end if;
106: end if;
107: end rosetta_table_copy_in_p6;
108: procedure rosetta_table_copy_out_p6(t okl_k_rate_params_pvt.var_prm_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
109: , a1 out nocopy JTF_VARCHAR2_TABLE_100
110: , a2 out nocopy JTF_VARCHAR2_TABLE_100
111: , a3 out nocopy JTF_NUMBER_TABLE
112: , a4 out nocopy JTF_DATE_TABLE

Line 109: , a1 out nocopy JTF_VARCHAR2_TABLE_100

105: end if;
106: end if;
107: end rosetta_table_copy_in_p6;
108: procedure rosetta_table_copy_out_p6(t okl_k_rate_params_pvt.var_prm_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
109: , a1 out nocopy JTF_VARCHAR2_TABLE_100
110: , a2 out nocopy JTF_VARCHAR2_TABLE_100
111: , a3 out nocopy JTF_NUMBER_TABLE
112: , a4 out nocopy JTF_DATE_TABLE
113: , a5 out nocopy JTF_DATE_TABLE

Line 110: , a2 out nocopy JTF_VARCHAR2_TABLE_100

106: end if;
107: end rosetta_table_copy_in_p6;
108: procedure rosetta_table_copy_out_p6(t okl_k_rate_params_pvt.var_prm_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
109: , a1 out nocopy JTF_VARCHAR2_TABLE_100
110: , a2 out nocopy JTF_VARCHAR2_TABLE_100
111: , a3 out nocopy JTF_NUMBER_TABLE
112: , a4 out nocopy JTF_DATE_TABLE
113: , a5 out nocopy JTF_DATE_TABLE
114: ) as

Line 118: a0 := JTF_VARCHAR2_TABLE_100();

114: ) as
115: ddindx binary_integer; indx binary_integer;
116: begin
117: if t is null or t.count = 0 then
118: a0 := JTF_VARCHAR2_TABLE_100();
119: a1 := JTF_VARCHAR2_TABLE_100();
120: a2 := JTF_VARCHAR2_TABLE_100();
121: a3 := JTF_NUMBER_TABLE();
122: a4 := JTF_DATE_TABLE();

Line 119: a1 := JTF_VARCHAR2_TABLE_100();

115: ddindx binary_integer; indx binary_integer;
116: begin
117: if t is null or t.count = 0 then
118: a0 := JTF_VARCHAR2_TABLE_100();
119: a1 := JTF_VARCHAR2_TABLE_100();
120: a2 := JTF_VARCHAR2_TABLE_100();
121: a3 := JTF_NUMBER_TABLE();
122: a4 := JTF_DATE_TABLE();
123: a5 := JTF_DATE_TABLE();

Line 120: a2 := JTF_VARCHAR2_TABLE_100();

116: begin
117: if t is null or t.count = 0 then
118: a0 := JTF_VARCHAR2_TABLE_100();
119: a1 := JTF_VARCHAR2_TABLE_100();
120: a2 := JTF_VARCHAR2_TABLE_100();
121: a3 := JTF_NUMBER_TABLE();
122: a4 := JTF_DATE_TABLE();
123: a5 := JTF_DATE_TABLE();
124: else

Line 125: a0 := JTF_VARCHAR2_TABLE_100();

121: a3 := JTF_NUMBER_TABLE();
122: a4 := JTF_DATE_TABLE();
123: a5 := JTF_DATE_TABLE();
124: else
125: a0 := JTF_VARCHAR2_TABLE_100();
126: a1 := JTF_VARCHAR2_TABLE_100();
127: a2 := JTF_VARCHAR2_TABLE_100();
128: a3 := JTF_NUMBER_TABLE();
129: a4 := JTF_DATE_TABLE();

Line 126: a1 := JTF_VARCHAR2_TABLE_100();

122: a4 := JTF_DATE_TABLE();
123: a5 := JTF_DATE_TABLE();
124: else
125: a0 := JTF_VARCHAR2_TABLE_100();
126: a1 := JTF_VARCHAR2_TABLE_100();
127: a2 := JTF_VARCHAR2_TABLE_100();
128: a3 := JTF_NUMBER_TABLE();
129: a4 := JTF_DATE_TABLE();
130: a5 := JTF_DATE_TABLE();

Line 127: a2 := JTF_VARCHAR2_TABLE_100();

123: a5 := JTF_DATE_TABLE();
124: else
125: a0 := JTF_VARCHAR2_TABLE_100();
126: a1 := JTF_VARCHAR2_TABLE_100();
127: a2 := JTF_VARCHAR2_TABLE_100();
128: a3 := JTF_NUMBER_TABLE();
129: a4 := JTF_DATE_TABLE();
130: a5 := JTF_DATE_TABLE();
131: if t.count > 0 then

Line 1254: , p5_a1 JTF_VARCHAR2_TABLE_100

1250: , x_return_status out nocopy VARCHAR2
1251: , x_msg_count out nocopy NUMBER
1252: , x_msg_data out nocopy VARCHAR2
1253: , p5_a0 JTF_NUMBER_TABLE
1254: , p5_a1 JTF_VARCHAR2_TABLE_100
1255: , p5_a2 JTF_DATE_TABLE
1256: )
1257:
1258: as

Line 1297: , p6_a1 JTF_VARCHAR2_TABLE_100

1293: , x_msg_count out nocopy NUMBER
1294: , x_msg_data out nocopy VARCHAR2
1295: , p_product_id NUMBER
1296: , p6_a0 JTF_NUMBER_TABLE
1297: , p6_a1 JTF_VARCHAR2_TABLE_100
1298: , p6_a2 JTF_DATE_TABLE
1299: , p6_a3 JTF_DATE_TABLE
1300: , p6_a4 JTF_NUMBER_TABLE
1301: , p6_a5 JTF_NUMBER_TABLE

Line 1306: , p6_a10 JTF_VARCHAR2_TABLE_100

1302: , p6_a6 JTF_DATE_TABLE
1303: , p6_a7 JTF_NUMBER_TABLE
1304: , p6_a8 JTF_NUMBER_TABLE
1305: , p6_a9 JTF_NUMBER_TABLE
1306: , p6_a10 JTF_VARCHAR2_TABLE_100
1307: , p6_a11 JTF_VARCHAR2_TABLE_100
1308: , p6_a12 JTF_VARCHAR2_TABLE_100
1309: , p6_a13 JTF_VARCHAR2_TABLE_100
1310: , p6_a14 JTF_VARCHAR2_TABLE_100

Line 1307: , p6_a11 JTF_VARCHAR2_TABLE_100

1303: , p6_a7 JTF_NUMBER_TABLE
1304: , p6_a8 JTF_NUMBER_TABLE
1305: , p6_a9 JTF_NUMBER_TABLE
1306: , p6_a10 JTF_VARCHAR2_TABLE_100
1307: , p6_a11 JTF_VARCHAR2_TABLE_100
1308: , p6_a12 JTF_VARCHAR2_TABLE_100
1309: , p6_a13 JTF_VARCHAR2_TABLE_100
1310: , p6_a14 JTF_VARCHAR2_TABLE_100
1311: , p6_a15 JTF_NUMBER_TABLE

Line 1308: , p6_a12 JTF_VARCHAR2_TABLE_100

1304: , p6_a8 JTF_NUMBER_TABLE
1305: , p6_a9 JTF_NUMBER_TABLE
1306: , p6_a10 JTF_VARCHAR2_TABLE_100
1307: , p6_a11 JTF_VARCHAR2_TABLE_100
1308: , p6_a12 JTF_VARCHAR2_TABLE_100
1309: , p6_a13 JTF_VARCHAR2_TABLE_100
1310: , p6_a14 JTF_VARCHAR2_TABLE_100
1311: , p6_a15 JTF_NUMBER_TABLE
1312: , p6_a16 JTF_VARCHAR2_TABLE_100

Line 1309: , p6_a13 JTF_VARCHAR2_TABLE_100

1305: , p6_a9 JTF_NUMBER_TABLE
1306: , p6_a10 JTF_VARCHAR2_TABLE_100
1307: , p6_a11 JTF_VARCHAR2_TABLE_100
1308: , p6_a12 JTF_VARCHAR2_TABLE_100
1309: , p6_a13 JTF_VARCHAR2_TABLE_100
1310: , p6_a14 JTF_VARCHAR2_TABLE_100
1311: , p6_a15 JTF_NUMBER_TABLE
1312: , p6_a16 JTF_VARCHAR2_TABLE_100
1313: , p6_a17 JTF_NUMBER_TABLE

Line 1310: , p6_a14 JTF_VARCHAR2_TABLE_100

1306: , p6_a10 JTF_VARCHAR2_TABLE_100
1307: , p6_a11 JTF_VARCHAR2_TABLE_100
1308: , p6_a12 JTF_VARCHAR2_TABLE_100
1309: , p6_a13 JTF_VARCHAR2_TABLE_100
1310: , p6_a14 JTF_VARCHAR2_TABLE_100
1311: , p6_a15 JTF_NUMBER_TABLE
1312: , p6_a16 JTF_VARCHAR2_TABLE_100
1313: , p6_a17 JTF_NUMBER_TABLE
1314: , p6_a18 JTF_VARCHAR2_TABLE_100

Line 1312: , p6_a16 JTF_VARCHAR2_TABLE_100

1308: , p6_a12 JTF_VARCHAR2_TABLE_100
1309: , p6_a13 JTF_VARCHAR2_TABLE_100
1310: , p6_a14 JTF_VARCHAR2_TABLE_100
1311: , p6_a15 JTF_NUMBER_TABLE
1312: , p6_a16 JTF_VARCHAR2_TABLE_100
1313: , p6_a17 JTF_NUMBER_TABLE
1314: , p6_a18 JTF_VARCHAR2_TABLE_100
1315: , p6_a19 JTF_DATE_TABLE
1316: , p6_a20 JTF_VARCHAR2_TABLE_100

Line 1314: , p6_a18 JTF_VARCHAR2_TABLE_100

1310: , p6_a14 JTF_VARCHAR2_TABLE_100
1311: , p6_a15 JTF_NUMBER_TABLE
1312: , p6_a16 JTF_VARCHAR2_TABLE_100
1313: , p6_a17 JTF_NUMBER_TABLE
1314: , p6_a18 JTF_VARCHAR2_TABLE_100
1315: , p6_a19 JTF_DATE_TABLE
1316: , p6_a20 JTF_VARCHAR2_TABLE_100
1317: , p6_a21 JTF_DATE_TABLE
1318: , p6_a22 JTF_VARCHAR2_TABLE_100

Line 1316: , p6_a20 JTF_VARCHAR2_TABLE_100

1312: , p6_a16 JTF_VARCHAR2_TABLE_100
1313: , p6_a17 JTF_NUMBER_TABLE
1314: , p6_a18 JTF_VARCHAR2_TABLE_100
1315: , p6_a19 JTF_DATE_TABLE
1316: , p6_a20 JTF_VARCHAR2_TABLE_100
1317: , p6_a21 JTF_DATE_TABLE
1318: , p6_a22 JTF_VARCHAR2_TABLE_100
1319: , p6_a23 JTF_NUMBER_TABLE
1320: , p6_a24 JTF_VARCHAR2_TABLE_100

Line 1318: , p6_a22 JTF_VARCHAR2_TABLE_100

1314: , p6_a18 JTF_VARCHAR2_TABLE_100
1315: , p6_a19 JTF_DATE_TABLE
1316: , p6_a20 JTF_VARCHAR2_TABLE_100
1317: , p6_a21 JTF_DATE_TABLE
1318: , p6_a22 JTF_VARCHAR2_TABLE_100
1319: , p6_a23 JTF_NUMBER_TABLE
1320: , p6_a24 JTF_VARCHAR2_TABLE_100
1321: , p6_a25 JTF_DATE_TABLE
1322: , p6_a26 JTF_VARCHAR2_TABLE_100

Line 1320: , p6_a24 JTF_VARCHAR2_TABLE_100

1316: , p6_a20 JTF_VARCHAR2_TABLE_100
1317: , p6_a21 JTF_DATE_TABLE
1318: , p6_a22 JTF_VARCHAR2_TABLE_100
1319: , p6_a23 JTF_NUMBER_TABLE
1320: , p6_a24 JTF_VARCHAR2_TABLE_100
1321: , p6_a25 JTF_DATE_TABLE
1322: , p6_a26 JTF_VARCHAR2_TABLE_100
1323: , p6_a27 JTF_VARCHAR2_TABLE_100
1324: , p6_a28 JTF_VARCHAR2_TABLE_500

Line 1322: , p6_a26 JTF_VARCHAR2_TABLE_100

1318: , p6_a22 JTF_VARCHAR2_TABLE_100
1319: , p6_a23 JTF_NUMBER_TABLE
1320: , p6_a24 JTF_VARCHAR2_TABLE_100
1321: , p6_a25 JTF_DATE_TABLE
1322: , p6_a26 JTF_VARCHAR2_TABLE_100
1323: , p6_a27 JTF_VARCHAR2_TABLE_100
1324: , p6_a28 JTF_VARCHAR2_TABLE_500
1325: , p6_a29 JTF_VARCHAR2_TABLE_500
1326: , p6_a30 JTF_VARCHAR2_TABLE_500

Line 1323: , p6_a27 JTF_VARCHAR2_TABLE_100

1319: , p6_a23 JTF_NUMBER_TABLE
1320: , p6_a24 JTF_VARCHAR2_TABLE_100
1321: , p6_a25 JTF_DATE_TABLE
1322: , p6_a26 JTF_VARCHAR2_TABLE_100
1323: , p6_a27 JTF_VARCHAR2_TABLE_100
1324: , p6_a28 JTF_VARCHAR2_TABLE_500
1325: , p6_a29 JTF_VARCHAR2_TABLE_500
1326: , p6_a30 JTF_VARCHAR2_TABLE_500
1327: , p6_a31 JTF_VARCHAR2_TABLE_500

Line 1344: , p6_a48 JTF_VARCHAR2_TABLE_100

1340: , p6_a44 JTF_DATE_TABLE
1341: , p6_a45 JTF_NUMBER_TABLE
1342: , p6_a46 JTF_DATE_TABLE
1343: , p6_a47 JTF_NUMBER_TABLE
1344: , p6_a48 JTF_VARCHAR2_TABLE_100
1345: )
1346:
1347: as
1348: ddp_k_rate_tbl okl_k_rate_params_pvt.krpv_tbl_type;

Line 1434: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100

1430: , x_return_status out nocopy VARCHAR2
1431: , x_msg_count out nocopy NUMBER
1432: , x_msg_data out nocopy VARCHAR2
1433: , p_chr_id NUMBER
1434: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
1435: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1436: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1437: , p6_a3 out nocopy JTF_NUMBER_TABLE
1438: , p6_a4 out nocopy JTF_DATE_TABLE

Line 1435: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

1431: , x_msg_count out nocopy NUMBER
1432: , x_msg_data out nocopy VARCHAR2
1433: , p_chr_id NUMBER
1434: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
1435: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1436: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1437: , p6_a3 out nocopy JTF_NUMBER_TABLE
1438: , p6_a4 out nocopy JTF_DATE_TABLE
1439: , p6_a5 out nocopy JTF_DATE_TABLE

Line 1436: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

1432: , x_msg_data out nocopy VARCHAR2
1433: , p_chr_id NUMBER
1434: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
1435: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1436: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1437: , p6_a3 out nocopy JTF_NUMBER_TABLE
1438: , p6_a4 out nocopy JTF_DATE_TABLE
1439: , p6_a5 out nocopy JTF_DATE_TABLE
1440: )