APPS.OKL_ITEM_RESIDUALS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p5(t out nocopy okl_item_residuals_pvt.lrs_ref_tbl, a0 JTF_NUMBER_TABLE

1: package body okl_item_residuals_pvt_w as
2: /* $Header: OKLEIRSB.pls 120.2 2005/07/22 10:10:33 smadhava noship $ */
3: procedure rosetta_table_copy_in_p5(t out nocopy okl_item_residuals_pvt.lrs_ref_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: ) as

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: OKLEIRSB.pls 120.2 2005/07/22 10:10:33 smadhava noship $ */
3: procedure rosetta_table_copy_in_p5(t out nocopy okl_item_residuals_pvt.lrs_ref_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: ) as
8: ddindx binary_integer; indx binary_integer;
9: begin
10: if a0 is not null and a0.count > 0 then

Line 28: procedure rosetta_table_copy_out_p5(t okl_item_residuals_pvt.lrs_ref_tbl, a0 out nocopy JTF_NUMBER_TABLE

24: end loop;
25: end if;
26: end if;
27: end rosetta_table_copy_in_p5;
28: procedure rosetta_table_copy_out_p5(t okl_item_residuals_pvt.lrs_ref_tbl, a0 out nocopy JTF_NUMBER_TABLE
29: , a1 out nocopy JTF_VARCHAR2_TABLE_200
30: , a2 out nocopy JTF_VARCHAR2_TABLE_100
31: , a3 out nocopy JTF_NUMBER_TABLE
32: ) as

Line 31: , a3 out nocopy JTF_NUMBER_TABLE

27: end rosetta_table_copy_in_p5;
28: procedure rosetta_table_copy_out_p5(t okl_item_residuals_pvt.lrs_ref_tbl, a0 out nocopy JTF_NUMBER_TABLE
29: , a1 out nocopy JTF_VARCHAR2_TABLE_200
30: , a2 out nocopy JTF_VARCHAR2_TABLE_100
31: , a3 out nocopy JTF_NUMBER_TABLE
32: ) as
33: ddindx binary_integer; indx binary_integer;
34: begin
35: if t is null or t.count = 0 then

Line 36: a0 := JTF_NUMBER_TABLE();

32: ) as
33: ddindx binary_integer; indx binary_integer;
34: begin
35: if t is null or t.count = 0 then
36: a0 := JTF_NUMBER_TABLE();
37: a1 := JTF_VARCHAR2_TABLE_200();
38: a2 := JTF_VARCHAR2_TABLE_100();
39: a3 := JTF_NUMBER_TABLE();
40: else

Line 39: a3 := JTF_NUMBER_TABLE();

35: if t is null or t.count = 0 then
36: a0 := JTF_NUMBER_TABLE();
37: a1 := JTF_VARCHAR2_TABLE_200();
38: a2 := JTF_VARCHAR2_TABLE_100();
39: a3 := JTF_NUMBER_TABLE();
40: else
41: a0 := JTF_NUMBER_TABLE();
42: a1 := JTF_VARCHAR2_TABLE_200();
43: a2 := JTF_VARCHAR2_TABLE_100();

Line 41: a0 := JTF_NUMBER_TABLE();

37: a1 := JTF_VARCHAR2_TABLE_200();
38: a2 := JTF_VARCHAR2_TABLE_100();
39: a3 := JTF_NUMBER_TABLE();
40: else
41: a0 := JTF_NUMBER_TABLE();
42: a1 := JTF_VARCHAR2_TABLE_200();
43: a2 := JTF_VARCHAR2_TABLE_100();
44: a3 := JTF_NUMBER_TABLE();
45: if t.count > 0 then

Line 44: a3 := JTF_NUMBER_TABLE();

40: else
41: a0 := JTF_NUMBER_TABLE();
42: a1 := JTF_VARCHAR2_TABLE_200();
43: a2 := JTF_VARCHAR2_TABLE_100();
44: a3 := JTF_NUMBER_TABLE();
45: if t.count > 0 then
46: a0.extend(t.count);
47: a1.extend(t.count);
48: a2.extend(t.count);

Line 124: , p7_a0 JTF_NUMBER_TABLE

120: , p6_a28 VARCHAR2
121: , p6_a29 VARCHAR2
122: , p6_a30 VARCHAR2
123: , p6_a31 VARCHAR2
124: , p7_a0 JTF_NUMBER_TABLE
125: , p7_a1 JTF_NUMBER_TABLE
126: , p7_a2 JTF_NUMBER_TABLE
127: , p7_a3 JTF_NUMBER_TABLE
128: , p7_a4 JTF_NUMBER_TABLE

Line 125: , p7_a1 JTF_NUMBER_TABLE

121: , p6_a29 VARCHAR2
122: , p6_a30 VARCHAR2
123: , p6_a31 VARCHAR2
124: , p7_a0 JTF_NUMBER_TABLE
125: , p7_a1 JTF_NUMBER_TABLE
126: , p7_a2 JTF_NUMBER_TABLE
127: , p7_a3 JTF_NUMBER_TABLE
128: , p7_a4 JTF_NUMBER_TABLE
129: , p7_a5 JTF_NUMBER_TABLE

Line 126: , p7_a2 JTF_NUMBER_TABLE

122: , p6_a30 VARCHAR2
123: , p6_a31 VARCHAR2
124: , p7_a0 JTF_NUMBER_TABLE
125: , p7_a1 JTF_NUMBER_TABLE
126: , p7_a2 JTF_NUMBER_TABLE
127: , p7_a3 JTF_NUMBER_TABLE
128: , p7_a4 JTF_NUMBER_TABLE
129: , p7_a5 JTF_NUMBER_TABLE
130: , p7_a6 JTF_NUMBER_TABLE

Line 127: , p7_a3 JTF_NUMBER_TABLE

123: , p6_a31 VARCHAR2
124: , p7_a0 JTF_NUMBER_TABLE
125: , p7_a1 JTF_NUMBER_TABLE
126: , p7_a2 JTF_NUMBER_TABLE
127: , p7_a3 JTF_NUMBER_TABLE
128: , p7_a4 JTF_NUMBER_TABLE
129: , p7_a5 JTF_NUMBER_TABLE
130: , p7_a6 JTF_NUMBER_TABLE
131: , p7_a7 JTF_DATE_TABLE

Line 128: , p7_a4 JTF_NUMBER_TABLE

124: , p7_a0 JTF_NUMBER_TABLE
125: , p7_a1 JTF_NUMBER_TABLE
126: , p7_a2 JTF_NUMBER_TABLE
127: , p7_a3 JTF_NUMBER_TABLE
128: , p7_a4 JTF_NUMBER_TABLE
129: , p7_a5 JTF_NUMBER_TABLE
130: , p7_a6 JTF_NUMBER_TABLE
131: , p7_a7 JTF_DATE_TABLE
132: , p7_a8 JTF_NUMBER_TABLE

Line 129: , p7_a5 JTF_NUMBER_TABLE

125: , p7_a1 JTF_NUMBER_TABLE
126: , p7_a2 JTF_NUMBER_TABLE
127: , p7_a3 JTF_NUMBER_TABLE
128: , p7_a4 JTF_NUMBER_TABLE
129: , p7_a5 JTF_NUMBER_TABLE
130: , p7_a6 JTF_NUMBER_TABLE
131: , p7_a7 JTF_DATE_TABLE
132: , p7_a8 JTF_NUMBER_TABLE
133: , p7_a9 JTF_DATE_TABLE

Line 130: , p7_a6 JTF_NUMBER_TABLE

126: , p7_a2 JTF_NUMBER_TABLE
127: , p7_a3 JTF_NUMBER_TABLE
128: , p7_a4 JTF_NUMBER_TABLE
129: , p7_a5 JTF_NUMBER_TABLE
130: , p7_a6 JTF_NUMBER_TABLE
131: , p7_a7 JTF_DATE_TABLE
132: , p7_a8 JTF_NUMBER_TABLE
133: , p7_a9 JTF_DATE_TABLE
134: , p7_a10 JTF_NUMBER_TABLE

Line 132: , p7_a8 JTF_NUMBER_TABLE

128: , p7_a4 JTF_NUMBER_TABLE
129: , p7_a5 JTF_NUMBER_TABLE
130: , p7_a6 JTF_NUMBER_TABLE
131: , p7_a7 JTF_DATE_TABLE
132: , p7_a8 JTF_NUMBER_TABLE
133: , p7_a9 JTF_DATE_TABLE
134: , p7_a10 JTF_NUMBER_TABLE
135: , p8_a0 out nocopy NUMBER
136: , p8_a1 out nocopy NUMBER

Line 134: , p7_a10 JTF_NUMBER_TABLE

130: , p7_a6 JTF_NUMBER_TABLE
131: , p7_a7 JTF_DATE_TABLE
132: , p7_a8 JTF_NUMBER_TABLE
133: , p7_a9 JTF_DATE_TABLE
134: , p7_a10 JTF_NUMBER_TABLE
135: , p8_a0 out nocopy NUMBER
136: , p8_a1 out nocopy NUMBER
137: , p8_a2 out nocopy NUMBER
138: , p8_a3 out nocopy NUMBER

Line 406: , p7_a0 JTF_NUMBER_TABLE

402: , p6_a28 VARCHAR2
403: , p6_a29 VARCHAR2
404: , p6_a30 VARCHAR2
405: , p6_a31 VARCHAR2
406: , p7_a0 JTF_NUMBER_TABLE
407: , p7_a1 JTF_NUMBER_TABLE
408: , p7_a2 JTF_NUMBER_TABLE
409: , p7_a3 JTF_NUMBER_TABLE
410: , p7_a4 JTF_NUMBER_TABLE

Line 407: , p7_a1 JTF_NUMBER_TABLE

403: , p6_a29 VARCHAR2
404: , p6_a30 VARCHAR2
405: , p6_a31 VARCHAR2
406: , p7_a0 JTF_NUMBER_TABLE
407: , p7_a1 JTF_NUMBER_TABLE
408: , p7_a2 JTF_NUMBER_TABLE
409: , p7_a3 JTF_NUMBER_TABLE
410: , p7_a4 JTF_NUMBER_TABLE
411: , p7_a5 JTF_NUMBER_TABLE

Line 408: , p7_a2 JTF_NUMBER_TABLE

404: , p6_a30 VARCHAR2
405: , p6_a31 VARCHAR2
406: , p7_a0 JTF_NUMBER_TABLE
407: , p7_a1 JTF_NUMBER_TABLE
408: , p7_a2 JTF_NUMBER_TABLE
409: , p7_a3 JTF_NUMBER_TABLE
410: , p7_a4 JTF_NUMBER_TABLE
411: , p7_a5 JTF_NUMBER_TABLE
412: , p7_a6 JTF_NUMBER_TABLE

Line 409: , p7_a3 JTF_NUMBER_TABLE

405: , p6_a31 VARCHAR2
406: , p7_a0 JTF_NUMBER_TABLE
407: , p7_a1 JTF_NUMBER_TABLE
408: , p7_a2 JTF_NUMBER_TABLE
409: , p7_a3 JTF_NUMBER_TABLE
410: , p7_a4 JTF_NUMBER_TABLE
411: , p7_a5 JTF_NUMBER_TABLE
412: , p7_a6 JTF_NUMBER_TABLE
413: , p7_a7 JTF_DATE_TABLE

Line 410: , p7_a4 JTF_NUMBER_TABLE

406: , p7_a0 JTF_NUMBER_TABLE
407: , p7_a1 JTF_NUMBER_TABLE
408: , p7_a2 JTF_NUMBER_TABLE
409: , p7_a3 JTF_NUMBER_TABLE
410: , p7_a4 JTF_NUMBER_TABLE
411: , p7_a5 JTF_NUMBER_TABLE
412: , p7_a6 JTF_NUMBER_TABLE
413: , p7_a7 JTF_DATE_TABLE
414: , p7_a8 JTF_NUMBER_TABLE

Line 411: , p7_a5 JTF_NUMBER_TABLE

407: , p7_a1 JTF_NUMBER_TABLE
408: , p7_a2 JTF_NUMBER_TABLE
409: , p7_a3 JTF_NUMBER_TABLE
410: , p7_a4 JTF_NUMBER_TABLE
411: , p7_a5 JTF_NUMBER_TABLE
412: , p7_a6 JTF_NUMBER_TABLE
413: , p7_a7 JTF_DATE_TABLE
414: , p7_a8 JTF_NUMBER_TABLE
415: , p7_a9 JTF_DATE_TABLE

Line 412: , p7_a6 JTF_NUMBER_TABLE

408: , p7_a2 JTF_NUMBER_TABLE
409: , p7_a3 JTF_NUMBER_TABLE
410: , p7_a4 JTF_NUMBER_TABLE
411: , p7_a5 JTF_NUMBER_TABLE
412: , p7_a6 JTF_NUMBER_TABLE
413: , p7_a7 JTF_DATE_TABLE
414: , p7_a8 JTF_NUMBER_TABLE
415: , p7_a9 JTF_DATE_TABLE
416: , p7_a10 JTF_NUMBER_TABLE

Line 414: , p7_a8 JTF_NUMBER_TABLE

410: , p7_a4 JTF_NUMBER_TABLE
411: , p7_a5 JTF_NUMBER_TABLE
412: , p7_a6 JTF_NUMBER_TABLE
413: , p7_a7 JTF_DATE_TABLE
414: , p7_a8 JTF_NUMBER_TABLE
415: , p7_a9 JTF_DATE_TABLE
416: , p7_a10 JTF_NUMBER_TABLE
417: , p8_a0 out nocopy NUMBER
418: , p8_a1 out nocopy NUMBER

Line 416: , p7_a10 JTF_NUMBER_TABLE

412: , p7_a6 JTF_NUMBER_TABLE
413: , p7_a7 JTF_DATE_TABLE
414: , p7_a8 JTF_NUMBER_TABLE
415: , p7_a9 JTF_DATE_TABLE
416: , p7_a10 JTF_NUMBER_TABLE
417: , p8_a0 out nocopy NUMBER
418: , p8_a1 out nocopy NUMBER
419: , p8_a2 out nocopy NUMBER
420: , p8_a3 out nocopy NUMBER

Line 688: , p7_a0 JTF_NUMBER_TABLE

684: , p6_a28 VARCHAR2
685: , p6_a29 VARCHAR2
686: , p6_a30 VARCHAR2
687: , p6_a31 VARCHAR2
688: , p7_a0 JTF_NUMBER_TABLE
689: , p7_a1 JTF_NUMBER_TABLE
690: , p7_a2 JTF_NUMBER_TABLE
691: , p7_a3 JTF_NUMBER_TABLE
692: , p7_a4 JTF_NUMBER_TABLE

Line 689: , p7_a1 JTF_NUMBER_TABLE

685: , p6_a29 VARCHAR2
686: , p6_a30 VARCHAR2
687: , p6_a31 VARCHAR2
688: , p7_a0 JTF_NUMBER_TABLE
689: , p7_a1 JTF_NUMBER_TABLE
690: , p7_a2 JTF_NUMBER_TABLE
691: , p7_a3 JTF_NUMBER_TABLE
692: , p7_a4 JTF_NUMBER_TABLE
693: , p7_a5 JTF_NUMBER_TABLE

Line 690: , p7_a2 JTF_NUMBER_TABLE

686: , p6_a30 VARCHAR2
687: , p6_a31 VARCHAR2
688: , p7_a0 JTF_NUMBER_TABLE
689: , p7_a1 JTF_NUMBER_TABLE
690: , p7_a2 JTF_NUMBER_TABLE
691: , p7_a3 JTF_NUMBER_TABLE
692: , p7_a4 JTF_NUMBER_TABLE
693: , p7_a5 JTF_NUMBER_TABLE
694: , p7_a6 JTF_NUMBER_TABLE

Line 691: , p7_a3 JTF_NUMBER_TABLE

687: , p6_a31 VARCHAR2
688: , p7_a0 JTF_NUMBER_TABLE
689: , p7_a1 JTF_NUMBER_TABLE
690: , p7_a2 JTF_NUMBER_TABLE
691: , p7_a3 JTF_NUMBER_TABLE
692: , p7_a4 JTF_NUMBER_TABLE
693: , p7_a5 JTF_NUMBER_TABLE
694: , p7_a6 JTF_NUMBER_TABLE
695: , p7_a7 JTF_DATE_TABLE

Line 692: , p7_a4 JTF_NUMBER_TABLE

688: , p7_a0 JTF_NUMBER_TABLE
689: , p7_a1 JTF_NUMBER_TABLE
690: , p7_a2 JTF_NUMBER_TABLE
691: , p7_a3 JTF_NUMBER_TABLE
692: , p7_a4 JTF_NUMBER_TABLE
693: , p7_a5 JTF_NUMBER_TABLE
694: , p7_a6 JTF_NUMBER_TABLE
695: , p7_a7 JTF_DATE_TABLE
696: , p7_a8 JTF_NUMBER_TABLE

Line 693: , p7_a5 JTF_NUMBER_TABLE

689: , p7_a1 JTF_NUMBER_TABLE
690: , p7_a2 JTF_NUMBER_TABLE
691: , p7_a3 JTF_NUMBER_TABLE
692: , p7_a4 JTF_NUMBER_TABLE
693: , p7_a5 JTF_NUMBER_TABLE
694: , p7_a6 JTF_NUMBER_TABLE
695: , p7_a7 JTF_DATE_TABLE
696: , p7_a8 JTF_NUMBER_TABLE
697: , p7_a9 JTF_DATE_TABLE

Line 694: , p7_a6 JTF_NUMBER_TABLE

690: , p7_a2 JTF_NUMBER_TABLE
691: , p7_a3 JTF_NUMBER_TABLE
692: , p7_a4 JTF_NUMBER_TABLE
693: , p7_a5 JTF_NUMBER_TABLE
694: , p7_a6 JTF_NUMBER_TABLE
695: , p7_a7 JTF_DATE_TABLE
696: , p7_a8 JTF_NUMBER_TABLE
697: , p7_a9 JTF_DATE_TABLE
698: , p7_a10 JTF_NUMBER_TABLE

Line 696: , p7_a8 JTF_NUMBER_TABLE

692: , p7_a4 JTF_NUMBER_TABLE
693: , p7_a5 JTF_NUMBER_TABLE
694: , p7_a6 JTF_NUMBER_TABLE
695: , p7_a7 JTF_DATE_TABLE
696: , p7_a8 JTF_NUMBER_TABLE
697: , p7_a9 JTF_DATE_TABLE
698: , p7_a10 JTF_NUMBER_TABLE
699: , p8_a0 out nocopy NUMBER
700: , p8_a1 out nocopy NUMBER

Line 698: , p7_a10 JTF_NUMBER_TABLE

694: , p7_a6 JTF_NUMBER_TABLE
695: , p7_a7 JTF_DATE_TABLE
696: , p7_a8 JTF_NUMBER_TABLE
697: , p7_a9 JTF_DATE_TABLE
698: , p7_a10 JTF_NUMBER_TABLE
699: , p8_a0 out nocopy NUMBER
700: , p8_a1 out nocopy NUMBER
701: , p8_a2 out nocopy NUMBER
702: , p8_a3 out nocopy NUMBER

Line 951: , p7_a0 out nocopy JTF_NUMBER_TABLE

947: , p6_a28 VARCHAR2
948: , p6_a29 VARCHAR2
949: , p6_a30 VARCHAR2
950: , p6_a31 VARCHAR2
951: , p7_a0 out nocopy JTF_NUMBER_TABLE
952: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
953: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
954: , p7_a3 out nocopy JTF_NUMBER_TABLE
955: , x_change_sts out nocopy VARCHAR2

Line 954: , p7_a3 out nocopy JTF_NUMBER_TABLE

950: , p6_a31 VARCHAR2
951: , p7_a0 out nocopy JTF_NUMBER_TABLE
952: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
953: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
954: , p7_a3 out nocopy JTF_NUMBER_TABLE
955: , x_change_sts out nocopy VARCHAR2
956: )
957:
958: as

Line 1038: , p5_a0 JTF_NUMBER_TABLE

1034: , p_init_msg_list VARCHAR2
1035: , x_return_status out nocopy VARCHAR2
1036: , x_msg_count out nocopy NUMBER
1037: , x_msg_data out nocopy VARCHAR2
1038: , p5_a0 JTF_NUMBER_TABLE
1039: , p5_a1 JTF_NUMBER_TABLE
1040: , p5_a2 JTF_NUMBER_TABLE
1041: , p5_a3 JTF_NUMBER_TABLE
1042: , p5_a4 JTF_NUMBER_TABLE

Line 1039: , p5_a1 JTF_NUMBER_TABLE

1035: , x_return_status out nocopy VARCHAR2
1036: , x_msg_count out nocopy NUMBER
1037: , x_msg_data out nocopy VARCHAR2
1038: , p5_a0 JTF_NUMBER_TABLE
1039: , p5_a1 JTF_NUMBER_TABLE
1040: , p5_a2 JTF_NUMBER_TABLE
1041: , p5_a3 JTF_NUMBER_TABLE
1042: , p5_a4 JTF_NUMBER_TABLE
1043: , p5_a5 JTF_NUMBER_TABLE

Line 1040: , p5_a2 JTF_NUMBER_TABLE

1036: , x_msg_count out nocopy NUMBER
1037: , x_msg_data out nocopy VARCHAR2
1038: , p5_a0 JTF_NUMBER_TABLE
1039: , p5_a1 JTF_NUMBER_TABLE
1040: , p5_a2 JTF_NUMBER_TABLE
1041: , p5_a3 JTF_NUMBER_TABLE
1042: , p5_a4 JTF_NUMBER_TABLE
1043: , p5_a5 JTF_NUMBER_TABLE
1044: , p5_a6 JTF_NUMBER_TABLE

Line 1041: , p5_a3 JTF_NUMBER_TABLE

1037: , x_msg_data out nocopy VARCHAR2
1038: , p5_a0 JTF_NUMBER_TABLE
1039: , p5_a1 JTF_NUMBER_TABLE
1040: , p5_a2 JTF_NUMBER_TABLE
1041: , p5_a3 JTF_NUMBER_TABLE
1042: , p5_a4 JTF_NUMBER_TABLE
1043: , p5_a5 JTF_NUMBER_TABLE
1044: , p5_a6 JTF_NUMBER_TABLE
1045: , p5_a7 JTF_DATE_TABLE

Line 1042: , p5_a4 JTF_NUMBER_TABLE

1038: , p5_a0 JTF_NUMBER_TABLE
1039: , p5_a1 JTF_NUMBER_TABLE
1040: , p5_a2 JTF_NUMBER_TABLE
1041: , p5_a3 JTF_NUMBER_TABLE
1042: , p5_a4 JTF_NUMBER_TABLE
1043: , p5_a5 JTF_NUMBER_TABLE
1044: , p5_a6 JTF_NUMBER_TABLE
1045: , p5_a7 JTF_DATE_TABLE
1046: , p5_a8 JTF_NUMBER_TABLE

Line 1043: , p5_a5 JTF_NUMBER_TABLE

1039: , p5_a1 JTF_NUMBER_TABLE
1040: , p5_a2 JTF_NUMBER_TABLE
1041: , p5_a3 JTF_NUMBER_TABLE
1042: , p5_a4 JTF_NUMBER_TABLE
1043: , p5_a5 JTF_NUMBER_TABLE
1044: , p5_a6 JTF_NUMBER_TABLE
1045: , p5_a7 JTF_DATE_TABLE
1046: , p5_a8 JTF_NUMBER_TABLE
1047: , p5_a9 JTF_DATE_TABLE

Line 1044: , p5_a6 JTF_NUMBER_TABLE

1040: , p5_a2 JTF_NUMBER_TABLE
1041: , p5_a3 JTF_NUMBER_TABLE
1042: , p5_a4 JTF_NUMBER_TABLE
1043: , p5_a5 JTF_NUMBER_TABLE
1044: , p5_a6 JTF_NUMBER_TABLE
1045: , p5_a7 JTF_DATE_TABLE
1046: , p5_a8 JTF_NUMBER_TABLE
1047: , p5_a9 JTF_DATE_TABLE
1048: , p5_a10 JTF_NUMBER_TABLE

Line 1046: , p5_a8 JTF_NUMBER_TABLE

1042: , p5_a4 JTF_NUMBER_TABLE
1043: , p5_a5 JTF_NUMBER_TABLE
1044: , p5_a6 JTF_NUMBER_TABLE
1045: , p5_a7 JTF_DATE_TABLE
1046: , p5_a8 JTF_NUMBER_TABLE
1047: , p5_a9 JTF_DATE_TABLE
1048: , p5_a10 JTF_NUMBER_TABLE
1049: )
1050:

Line 1048: , p5_a10 JTF_NUMBER_TABLE

1044: , p5_a6 JTF_NUMBER_TABLE
1045: , p5_a7 JTF_DATE_TABLE
1046: , p5_a8 JTF_NUMBER_TABLE
1047: , p5_a9 JTF_DATE_TABLE
1048: , p5_a10 JTF_NUMBER_TABLE
1049: )
1050:
1051: as
1052: ddp_irv_tbl okl_item_residuals_pvt.okl_irv_tbl;

Line 1148: , p7_a0 JTF_NUMBER_TABLE

1144: , p6_a28 VARCHAR2
1145: , p6_a29 VARCHAR2
1146: , p6_a30 VARCHAR2
1147: , p6_a31 VARCHAR2
1148: , p7_a0 JTF_NUMBER_TABLE
1149: , p7_a1 JTF_NUMBER_TABLE
1150: , p7_a2 JTF_NUMBER_TABLE
1151: , p7_a3 JTF_NUMBER_TABLE
1152: , p7_a4 JTF_NUMBER_TABLE

Line 1149: , p7_a1 JTF_NUMBER_TABLE

1145: , p6_a29 VARCHAR2
1146: , p6_a30 VARCHAR2
1147: , p6_a31 VARCHAR2
1148: , p7_a0 JTF_NUMBER_TABLE
1149: , p7_a1 JTF_NUMBER_TABLE
1150: , p7_a2 JTF_NUMBER_TABLE
1151: , p7_a3 JTF_NUMBER_TABLE
1152: , p7_a4 JTF_NUMBER_TABLE
1153: , p7_a5 JTF_NUMBER_TABLE

Line 1150: , p7_a2 JTF_NUMBER_TABLE

1146: , p6_a30 VARCHAR2
1147: , p6_a31 VARCHAR2
1148: , p7_a0 JTF_NUMBER_TABLE
1149: , p7_a1 JTF_NUMBER_TABLE
1150: , p7_a2 JTF_NUMBER_TABLE
1151: , p7_a3 JTF_NUMBER_TABLE
1152: , p7_a4 JTF_NUMBER_TABLE
1153: , p7_a5 JTF_NUMBER_TABLE
1154: , p7_a6 JTF_NUMBER_TABLE

Line 1151: , p7_a3 JTF_NUMBER_TABLE

1147: , p6_a31 VARCHAR2
1148: , p7_a0 JTF_NUMBER_TABLE
1149: , p7_a1 JTF_NUMBER_TABLE
1150: , p7_a2 JTF_NUMBER_TABLE
1151: , p7_a3 JTF_NUMBER_TABLE
1152: , p7_a4 JTF_NUMBER_TABLE
1153: , p7_a5 JTF_NUMBER_TABLE
1154: , p7_a6 JTF_NUMBER_TABLE
1155: , p7_a7 JTF_DATE_TABLE

Line 1152: , p7_a4 JTF_NUMBER_TABLE

1148: , p7_a0 JTF_NUMBER_TABLE
1149: , p7_a1 JTF_NUMBER_TABLE
1150: , p7_a2 JTF_NUMBER_TABLE
1151: , p7_a3 JTF_NUMBER_TABLE
1152: , p7_a4 JTF_NUMBER_TABLE
1153: , p7_a5 JTF_NUMBER_TABLE
1154: , p7_a6 JTF_NUMBER_TABLE
1155: , p7_a7 JTF_DATE_TABLE
1156: , p7_a8 JTF_NUMBER_TABLE

Line 1153: , p7_a5 JTF_NUMBER_TABLE

1149: , p7_a1 JTF_NUMBER_TABLE
1150: , p7_a2 JTF_NUMBER_TABLE
1151: , p7_a3 JTF_NUMBER_TABLE
1152: , p7_a4 JTF_NUMBER_TABLE
1153: , p7_a5 JTF_NUMBER_TABLE
1154: , p7_a6 JTF_NUMBER_TABLE
1155: , p7_a7 JTF_DATE_TABLE
1156: , p7_a8 JTF_NUMBER_TABLE
1157: , p7_a9 JTF_DATE_TABLE

Line 1154: , p7_a6 JTF_NUMBER_TABLE

1150: , p7_a2 JTF_NUMBER_TABLE
1151: , p7_a3 JTF_NUMBER_TABLE
1152: , p7_a4 JTF_NUMBER_TABLE
1153: , p7_a5 JTF_NUMBER_TABLE
1154: , p7_a6 JTF_NUMBER_TABLE
1155: , p7_a7 JTF_DATE_TABLE
1156: , p7_a8 JTF_NUMBER_TABLE
1157: , p7_a9 JTF_DATE_TABLE
1158: , p7_a10 JTF_NUMBER_TABLE

Line 1156: , p7_a8 JTF_NUMBER_TABLE

1152: , p7_a4 JTF_NUMBER_TABLE
1153: , p7_a5 JTF_NUMBER_TABLE
1154: , p7_a6 JTF_NUMBER_TABLE
1155: , p7_a7 JTF_DATE_TABLE
1156: , p7_a8 JTF_NUMBER_TABLE
1157: , p7_a9 JTF_DATE_TABLE
1158: , p7_a10 JTF_NUMBER_TABLE
1159: , p8_a0 out nocopy NUMBER
1160: , p8_a1 out nocopy NUMBER

Line 1158: , p7_a10 JTF_NUMBER_TABLE

1154: , p7_a6 JTF_NUMBER_TABLE
1155: , p7_a7 JTF_DATE_TABLE
1156: , p7_a8 JTF_NUMBER_TABLE
1157: , p7_a9 JTF_DATE_TABLE
1158: , p7_a10 JTF_NUMBER_TABLE
1159: , p8_a0 out nocopy NUMBER
1160: , p8_a1 out nocopy NUMBER
1161: , p8_a2 out nocopy NUMBER
1162: , p8_a3 out nocopy NUMBER

Line 1430: , p7_a0 JTF_NUMBER_TABLE

1426: , p6_a28 VARCHAR2
1427: , p6_a29 VARCHAR2
1428: , p6_a30 VARCHAR2
1429: , p6_a31 VARCHAR2
1430: , p7_a0 JTF_NUMBER_TABLE
1431: , p7_a1 JTF_NUMBER_TABLE
1432: , p7_a2 JTF_NUMBER_TABLE
1433: , p7_a3 JTF_NUMBER_TABLE
1434: , p7_a4 JTF_NUMBER_TABLE

Line 1431: , p7_a1 JTF_NUMBER_TABLE

1427: , p6_a29 VARCHAR2
1428: , p6_a30 VARCHAR2
1429: , p6_a31 VARCHAR2
1430: , p7_a0 JTF_NUMBER_TABLE
1431: , p7_a1 JTF_NUMBER_TABLE
1432: , p7_a2 JTF_NUMBER_TABLE
1433: , p7_a3 JTF_NUMBER_TABLE
1434: , p7_a4 JTF_NUMBER_TABLE
1435: , p7_a5 JTF_NUMBER_TABLE

Line 1432: , p7_a2 JTF_NUMBER_TABLE

1428: , p6_a30 VARCHAR2
1429: , p6_a31 VARCHAR2
1430: , p7_a0 JTF_NUMBER_TABLE
1431: , p7_a1 JTF_NUMBER_TABLE
1432: , p7_a2 JTF_NUMBER_TABLE
1433: , p7_a3 JTF_NUMBER_TABLE
1434: , p7_a4 JTF_NUMBER_TABLE
1435: , p7_a5 JTF_NUMBER_TABLE
1436: , p7_a6 JTF_NUMBER_TABLE

Line 1433: , p7_a3 JTF_NUMBER_TABLE

1429: , p6_a31 VARCHAR2
1430: , p7_a0 JTF_NUMBER_TABLE
1431: , p7_a1 JTF_NUMBER_TABLE
1432: , p7_a2 JTF_NUMBER_TABLE
1433: , p7_a3 JTF_NUMBER_TABLE
1434: , p7_a4 JTF_NUMBER_TABLE
1435: , p7_a5 JTF_NUMBER_TABLE
1436: , p7_a6 JTF_NUMBER_TABLE
1437: , p7_a7 JTF_DATE_TABLE

Line 1434: , p7_a4 JTF_NUMBER_TABLE

1430: , p7_a0 JTF_NUMBER_TABLE
1431: , p7_a1 JTF_NUMBER_TABLE
1432: , p7_a2 JTF_NUMBER_TABLE
1433: , p7_a3 JTF_NUMBER_TABLE
1434: , p7_a4 JTF_NUMBER_TABLE
1435: , p7_a5 JTF_NUMBER_TABLE
1436: , p7_a6 JTF_NUMBER_TABLE
1437: , p7_a7 JTF_DATE_TABLE
1438: , p7_a8 JTF_NUMBER_TABLE

Line 1435: , p7_a5 JTF_NUMBER_TABLE

1431: , p7_a1 JTF_NUMBER_TABLE
1432: , p7_a2 JTF_NUMBER_TABLE
1433: , p7_a3 JTF_NUMBER_TABLE
1434: , p7_a4 JTF_NUMBER_TABLE
1435: , p7_a5 JTF_NUMBER_TABLE
1436: , p7_a6 JTF_NUMBER_TABLE
1437: , p7_a7 JTF_DATE_TABLE
1438: , p7_a8 JTF_NUMBER_TABLE
1439: , p7_a9 JTF_DATE_TABLE

Line 1436: , p7_a6 JTF_NUMBER_TABLE

1432: , p7_a2 JTF_NUMBER_TABLE
1433: , p7_a3 JTF_NUMBER_TABLE
1434: , p7_a4 JTF_NUMBER_TABLE
1435: , p7_a5 JTF_NUMBER_TABLE
1436: , p7_a6 JTF_NUMBER_TABLE
1437: , p7_a7 JTF_DATE_TABLE
1438: , p7_a8 JTF_NUMBER_TABLE
1439: , p7_a9 JTF_DATE_TABLE
1440: , p7_a10 JTF_NUMBER_TABLE

Line 1438: , p7_a8 JTF_NUMBER_TABLE

1434: , p7_a4 JTF_NUMBER_TABLE
1435: , p7_a5 JTF_NUMBER_TABLE
1436: , p7_a6 JTF_NUMBER_TABLE
1437: , p7_a7 JTF_DATE_TABLE
1438: , p7_a8 JTF_NUMBER_TABLE
1439: , p7_a9 JTF_DATE_TABLE
1440: , p7_a10 JTF_NUMBER_TABLE
1441: , p8_a0 out nocopy NUMBER
1442: , p8_a1 out nocopy NUMBER

Line 1440: , p7_a10 JTF_NUMBER_TABLE

1436: , p7_a6 JTF_NUMBER_TABLE
1437: , p7_a7 JTF_DATE_TABLE
1438: , p7_a8 JTF_NUMBER_TABLE
1439: , p7_a9 JTF_DATE_TABLE
1440: , p7_a10 JTF_NUMBER_TABLE
1441: , p8_a0 out nocopy NUMBER
1442: , p8_a1 out nocopy NUMBER
1443: , p8_a2 out nocopy NUMBER
1444: , p8_a3 out nocopy NUMBER

Line 1712: , p7_a0 JTF_NUMBER_TABLE

1708: , p6_a28 VARCHAR2
1709: , p6_a29 VARCHAR2
1710: , p6_a30 VARCHAR2
1711: , p6_a31 VARCHAR2
1712: , p7_a0 JTF_NUMBER_TABLE
1713: , p7_a1 JTF_NUMBER_TABLE
1714: , p7_a2 JTF_NUMBER_TABLE
1715: , p7_a3 JTF_NUMBER_TABLE
1716: , p7_a4 JTF_NUMBER_TABLE

Line 1713: , p7_a1 JTF_NUMBER_TABLE

1709: , p6_a29 VARCHAR2
1710: , p6_a30 VARCHAR2
1711: , p6_a31 VARCHAR2
1712: , p7_a0 JTF_NUMBER_TABLE
1713: , p7_a1 JTF_NUMBER_TABLE
1714: , p7_a2 JTF_NUMBER_TABLE
1715: , p7_a3 JTF_NUMBER_TABLE
1716: , p7_a4 JTF_NUMBER_TABLE
1717: , p7_a5 JTF_NUMBER_TABLE

Line 1714: , p7_a2 JTF_NUMBER_TABLE

1710: , p6_a30 VARCHAR2
1711: , p6_a31 VARCHAR2
1712: , p7_a0 JTF_NUMBER_TABLE
1713: , p7_a1 JTF_NUMBER_TABLE
1714: , p7_a2 JTF_NUMBER_TABLE
1715: , p7_a3 JTF_NUMBER_TABLE
1716: , p7_a4 JTF_NUMBER_TABLE
1717: , p7_a5 JTF_NUMBER_TABLE
1718: , p7_a6 JTF_NUMBER_TABLE

Line 1715: , p7_a3 JTF_NUMBER_TABLE

1711: , p6_a31 VARCHAR2
1712: , p7_a0 JTF_NUMBER_TABLE
1713: , p7_a1 JTF_NUMBER_TABLE
1714: , p7_a2 JTF_NUMBER_TABLE
1715: , p7_a3 JTF_NUMBER_TABLE
1716: , p7_a4 JTF_NUMBER_TABLE
1717: , p7_a5 JTF_NUMBER_TABLE
1718: , p7_a6 JTF_NUMBER_TABLE
1719: , p7_a7 JTF_DATE_TABLE

Line 1716: , p7_a4 JTF_NUMBER_TABLE

1712: , p7_a0 JTF_NUMBER_TABLE
1713: , p7_a1 JTF_NUMBER_TABLE
1714: , p7_a2 JTF_NUMBER_TABLE
1715: , p7_a3 JTF_NUMBER_TABLE
1716: , p7_a4 JTF_NUMBER_TABLE
1717: , p7_a5 JTF_NUMBER_TABLE
1718: , p7_a6 JTF_NUMBER_TABLE
1719: , p7_a7 JTF_DATE_TABLE
1720: , p7_a8 JTF_NUMBER_TABLE

Line 1717: , p7_a5 JTF_NUMBER_TABLE

1713: , p7_a1 JTF_NUMBER_TABLE
1714: , p7_a2 JTF_NUMBER_TABLE
1715: , p7_a3 JTF_NUMBER_TABLE
1716: , p7_a4 JTF_NUMBER_TABLE
1717: , p7_a5 JTF_NUMBER_TABLE
1718: , p7_a6 JTF_NUMBER_TABLE
1719: , p7_a7 JTF_DATE_TABLE
1720: , p7_a8 JTF_NUMBER_TABLE
1721: , p7_a9 JTF_DATE_TABLE

Line 1718: , p7_a6 JTF_NUMBER_TABLE

1714: , p7_a2 JTF_NUMBER_TABLE
1715: , p7_a3 JTF_NUMBER_TABLE
1716: , p7_a4 JTF_NUMBER_TABLE
1717: , p7_a5 JTF_NUMBER_TABLE
1718: , p7_a6 JTF_NUMBER_TABLE
1719: , p7_a7 JTF_DATE_TABLE
1720: , p7_a8 JTF_NUMBER_TABLE
1721: , p7_a9 JTF_DATE_TABLE
1722: , p7_a10 JTF_NUMBER_TABLE

Line 1720: , p7_a8 JTF_NUMBER_TABLE

1716: , p7_a4 JTF_NUMBER_TABLE
1717: , p7_a5 JTF_NUMBER_TABLE
1718: , p7_a6 JTF_NUMBER_TABLE
1719: , p7_a7 JTF_DATE_TABLE
1720: , p7_a8 JTF_NUMBER_TABLE
1721: , p7_a9 JTF_DATE_TABLE
1722: , p7_a10 JTF_NUMBER_TABLE
1723: , p8_a0 out nocopy NUMBER
1724: , p8_a1 out nocopy NUMBER

Line 1722: , p7_a10 JTF_NUMBER_TABLE

1718: , p7_a6 JTF_NUMBER_TABLE
1719: , p7_a7 JTF_DATE_TABLE
1720: , p7_a8 JTF_NUMBER_TABLE
1721: , p7_a9 JTF_DATE_TABLE
1722: , p7_a10 JTF_NUMBER_TABLE
1723: , p8_a0 out nocopy NUMBER
1724: , p8_a1 out nocopy NUMBER
1725: , p8_a2 out nocopy NUMBER
1726: , p8_a3 out nocopy NUMBER