DBA Data[Home] [Help]

APPS.OKL_K_RATE_PARAMS_PVT_W dependencies on JTF_DATE_TABLE

Line 24: , a2 JTF_DATE_TABLE

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
28: if a0 is not null and a0.count > 0 then

Line 47: , a2 out nocopy JTF_DATE_TABLE

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
51: if t is null or t.count = 0 then

Line 54: a2 := JTF_DATE_TABLE();

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();
58: a2 := JTF_DATE_TABLE();

Line 58: a2 := JTF_DATE_TABLE();

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);
62: a2.extend(t.count);

Line 83: , a4 JTF_DATE_TABLE

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
86: ddindx binary_integer; indx binary_integer;
87: begin

Line 84: , a5 JTF_DATE_TABLE

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
86: ddindx binary_integer; indx binary_integer;
87: begin
88: if a0 is not null and a0.count > 0 then

Line 112: , a4 out nocopy JTF_DATE_TABLE

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
115: ddindx binary_integer; indx binary_integer;
116: begin

Line 113: , a5 out nocopy JTF_DATE_TABLE

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
115: ddindx binary_integer; indx binary_integer;
116: begin
117: if t is null or t.count = 0 then

Line 122: a4 := JTF_DATE_TABLE();

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
125: a0 := JTF_VARCHAR2_TABLE_100();
126: a1 := JTF_VARCHAR2_TABLE_100();

Line 123: a5 := JTF_DATE_TABLE();

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
125: a0 := JTF_VARCHAR2_TABLE_100();
126: a1 := JTF_VARCHAR2_TABLE_100();
127: a2 := JTF_VARCHAR2_TABLE_100();

Line 129: a4 := JTF_DATE_TABLE();

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
132: a0.extend(t.count);
133: a1.extend(t.count);

Line 130: a5 := JTF_DATE_TABLE();

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
132: a0.extend(t.count);
133: a1.extend(t.count);
134: a2.extend(t.count);

Line 1255: , p5_a2 JTF_DATE_TABLE

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
1259: ddp_krpdel_tbl okl_k_rate_params_pvt.krpdel_tbl_type;

Line 1298: , p6_a2 JTF_DATE_TABLE

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
1302: , p6_a6 JTF_DATE_TABLE

Line 1299: , p6_a3 JTF_DATE_TABLE

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
1302: , p6_a6 JTF_DATE_TABLE
1303: , p6_a7 JTF_NUMBER_TABLE

Line 1302: , p6_a6 JTF_DATE_TABLE

1298: , p6_a2 JTF_DATE_TABLE
1299: , p6_a3 JTF_DATE_TABLE
1300: , p6_a4 JTF_NUMBER_TABLE
1301: , p6_a5 JTF_NUMBER_TABLE
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

Line 1315: , p6_a19 JTF_DATE_TABLE

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
1319: , p6_a23 JTF_NUMBER_TABLE

Line 1317: , p6_a21 JTF_DATE_TABLE

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
1321: , p6_a25 JTF_DATE_TABLE

Line 1321: , p6_a25 JTF_DATE_TABLE

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
1325: , p6_a29 JTF_VARCHAR2_TABLE_500

Line 1340: , p6_a44 JTF_DATE_TABLE

1336: , p6_a40 JTF_VARCHAR2_TABLE_500
1337: , p6_a41 JTF_VARCHAR2_TABLE_500
1338: , p6_a42 JTF_VARCHAR2_TABLE_500
1339: , p6_a43 JTF_NUMBER_TABLE
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

Line 1342: , p6_a46 JTF_DATE_TABLE

1338: , p6_a42 JTF_VARCHAR2_TABLE_500
1339: , p6_a43 JTF_NUMBER_TABLE
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:

Line 1438: , p6_a4 out nocopy JTF_DATE_TABLE

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: )
1441:
1442: as

Line 1439: , p6_a5 out nocopy JTF_DATE_TABLE

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: )
1441:
1442: as
1443: ddx_var_par_tbl okl_k_rate_params_pvt.var_prm_tbl_type;