DBA Data[Home] [Help]

APPS.OKL_CONTRACT_PVT_W dependencies on JTF_VARCHAR2_TABLE_300

Line 22: procedure rosetta_table_copy_in_p4(t out nocopy okl_contract_pvt.hdr_tbl_type, a0 JTF_VARCHAR2_TABLE_300) as

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p4(t out nocopy okl_contract_pvt.hdr_tbl_type, a0 JTF_VARCHAR2_TABLE_300) as
23: ddindx binary_integer; indx binary_integer;
24: begin
25: if a0 is not null and a0.count > 0 then
26: if a0.count > 0 then

Line 40: procedure rosetta_table_copy_out_p4(t okl_contract_pvt.hdr_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300) as

36: end loop;
37: end if;
38: end if;
39: end rosetta_table_copy_in_p4;
40: procedure rosetta_table_copy_out_p4(t okl_contract_pvt.hdr_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300) as
41: ddindx binary_integer; indx binary_integer;
42: begin
43: if t is null or t.count = 0 then
44: a0 := JTF_VARCHAR2_TABLE_300();

Line 44: a0 := JTF_VARCHAR2_TABLE_300();

40: procedure rosetta_table_copy_out_p4(t okl_contract_pvt.hdr_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300) as
41: ddindx binary_integer; indx binary_integer;
42: begin
43: if t is null or t.count = 0 then
44: a0 := JTF_VARCHAR2_TABLE_300();
45: else
46: a0 := JTF_VARCHAR2_TABLE_300();
47: if t.count > 0 then
48: a0.extend(t.count);

Line 46: a0 := JTF_VARCHAR2_TABLE_300();

42: begin
43: if t is null or t.count = 0 then
44: a0 := JTF_VARCHAR2_TABLE_300();
45: else
46: a0 := JTF_VARCHAR2_TABLE_300();
47: if t.count > 0 then
48: a0.extend(t.count);
49: ddindx := t.first;
50: indx := 1;

Line 821: , p5_a22 JTF_VARCHAR2_TABLE_300

817: , p5_a18 JTF_VARCHAR2_TABLE_600
818: , p5_a19 JTF_VARCHAR2_TABLE_2000
819: , p5_a20 JTF_VARCHAR2_TABLE_2000
820: , p5_a21 JTF_VARCHAR2_TABLE_100
821: , p5_a22 JTF_VARCHAR2_TABLE_300
822: , p5_a23 JTF_VARCHAR2_TABLE_100
823: , p5_a24 JTF_VARCHAR2_TABLE_200
824: , p5_a25 JTF_DATE_TABLE
825: , p5_a26 JTF_DATE_TABLE

Line 992: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_300

988: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_600
989: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_2000
990: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_2000
991: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100
992: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_300
993: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_100
994: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_200
995: , p7_a25 out nocopy JTF_DATE_TABLE
996: , p7_a26 out nocopy JTF_DATE_TABLE

Line 2292: , p6_a22 JTF_VARCHAR2_TABLE_300

2288: , p6_a18 JTF_VARCHAR2_TABLE_600
2289: , p6_a19 JTF_VARCHAR2_TABLE_2000
2290: , p6_a20 JTF_VARCHAR2_TABLE_2000
2291: , p6_a21 JTF_VARCHAR2_TABLE_100
2292: , p6_a22 JTF_VARCHAR2_TABLE_300
2293: , p6_a23 JTF_VARCHAR2_TABLE_100
2294: , p6_a24 JTF_VARCHAR2_TABLE_200
2295: , p6_a25 JTF_DATE_TABLE
2296: , p6_a26 JTF_DATE_TABLE

Line 2463: , p8_a22 out nocopy JTF_VARCHAR2_TABLE_300

2459: , p8_a18 out nocopy JTF_VARCHAR2_TABLE_600
2460: , p8_a19 out nocopy JTF_VARCHAR2_TABLE_2000
2461: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_2000
2462: , p8_a21 out nocopy JTF_VARCHAR2_TABLE_100
2463: , p8_a22 out nocopy JTF_VARCHAR2_TABLE_300
2464: , p8_a23 out nocopy JTF_VARCHAR2_TABLE_100
2465: , p8_a24 out nocopy JTF_VARCHAR2_TABLE_200
2466: , p8_a25 out nocopy JTF_DATE_TABLE
2467: , p8_a26 out nocopy JTF_DATE_TABLE

Line 4150: , p5_a22 JTF_VARCHAR2_TABLE_300

4146: , p5_a18 JTF_VARCHAR2_TABLE_600
4147: , p5_a19 JTF_VARCHAR2_TABLE_2000
4148: , p5_a20 JTF_VARCHAR2_TABLE_2000
4149: , p5_a21 JTF_VARCHAR2_TABLE_100
4150: , p5_a22 JTF_VARCHAR2_TABLE_300
4151: , p5_a23 JTF_VARCHAR2_TABLE_100
4152: , p5_a24 JTF_VARCHAR2_TABLE_200
4153: , p5_a25 JTF_DATE_TABLE
4154: , p5_a26 JTF_DATE_TABLE

Line 4914: , p5_a22 JTF_VARCHAR2_TABLE_300

4910: , p5_a18 JTF_VARCHAR2_TABLE_600
4911: , p5_a19 JTF_VARCHAR2_TABLE_2000
4912: , p5_a20 JTF_VARCHAR2_TABLE_2000
4913: , p5_a21 JTF_VARCHAR2_TABLE_100
4914: , p5_a22 JTF_VARCHAR2_TABLE_300
4915: , p5_a23 JTF_VARCHAR2_TABLE_100
4916: , p5_a24 JTF_VARCHAR2_TABLE_200
4917: , p5_a25 JTF_DATE_TABLE
4918: , p5_a26 JTF_DATE_TABLE

Line 5678: , p5_a22 JTF_VARCHAR2_TABLE_300

5674: , p5_a18 JTF_VARCHAR2_TABLE_600
5675: , p5_a19 JTF_VARCHAR2_TABLE_2000
5676: , p5_a20 JTF_VARCHAR2_TABLE_2000
5677: , p5_a21 JTF_VARCHAR2_TABLE_100
5678: , p5_a22 JTF_VARCHAR2_TABLE_300
5679: , p5_a23 JTF_VARCHAR2_TABLE_100
5680: , p5_a24 JTF_VARCHAR2_TABLE_200
5681: , p5_a25 JTF_DATE_TABLE
5682: , p5_a26 JTF_DATE_TABLE

Line 6858: , p5_a16 JTF_VARCHAR2_TABLE_300

6854: , p5_a12 JTF_NUMBER_TABLE
6855: , p5_a13 JTF_VARCHAR2_TABLE_2000
6856: , p5_a14 JTF_VARCHAR2_TABLE_2000
6857: , p5_a15 JTF_VARCHAR2_TABLE_2000
6858: , p5_a16 JTF_VARCHAR2_TABLE_300
6859: , p5_a17 JTF_VARCHAR2_TABLE_100
6860: , p5_a18 JTF_NUMBER_TABLE
6861: , p5_a19 JTF_NUMBER_TABLE
6862: , p5_a20 JTF_NUMBER_TABLE

Line 6969: , p6_a37 JTF_VARCHAR2_TABLE_300

6965: , p6_a33 JTF_NUMBER_TABLE
6966: , p6_a34 JTF_DATE_TABLE
6967: , p6_a35 JTF_VARCHAR2_TABLE_100
6968: , p6_a36 JTF_DATE_TABLE
6969: , p6_a37 JTF_VARCHAR2_TABLE_300
6970: , p6_a38 JTF_NUMBER_TABLE
6971: , p6_a39 JTF_NUMBER_TABLE
6972: , p6_a40 JTF_NUMBER_TABLE
6973: , p6_a41 JTF_VARCHAR2_TABLE_100

Line 7047: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_300

7043: , p7_a12 out nocopy JTF_NUMBER_TABLE
7044: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_2000
7045: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_2000
7046: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_2000
7047: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_300
7048: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100
7049: , p7_a18 out nocopy JTF_NUMBER_TABLE
7050: , p7_a19 out nocopy JTF_NUMBER_TABLE
7051: , p7_a20 out nocopy JTF_NUMBER_TABLE

Line 7158: , p8_a37 out nocopy JTF_VARCHAR2_TABLE_300

7154: , p8_a33 out nocopy JTF_NUMBER_TABLE
7155: , p8_a34 out nocopy JTF_DATE_TABLE
7156: , p8_a35 out nocopy JTF_VARCHAR2_TABLE_100
7157: , p8_a36 out nocopy JTF_DATE_TABLE
7158: , p8_a37 out nocopy JTF_VARCHAR2_TABLE_300
7159: , p8_a38 out nocopy JTF_NUMBER_TABLE
7160: , p8_a39 out nocopy JTF_NUMBER_TABLE
7161: , p8_a40 out nocopy JTF_NUMBER_TABLE
7162: , p8_a41 out nocopy JTF_VARCHAR2_TABLE_100

Line 8468: , p5_a16 JTF_VARCHAR2_TABLE_300

8464: , p5_a12 JTF_NUMBER_TABLE
8465: , p5_a13 JTF_VARCHAR2_TABLE_2000
8466: , p5_a14 JTF_VARCHAR2_TABLE_2000
8467: , p5_a15 JTF_VARCHAR2_TABLE_2000
8468: , p5_a16 JTF_VARCHAR2_TABLE_300
8469: , p5_a17 JTF_VARCHAR2_TABLE_100
8470: , p5_a18 JTF_NUMBER_TABLE
8471: , p5_a19 JTF_NUMBER_TABLE
8472: , p5_a20 JTF_NUMBER_TABLE

Line 8579: , p6_a37 JTF_VARCHAR2_TABLE_300

8575: , p6_a33 JTF_NUMBER_TABLE
8576: , p6_a34 JTF_DATE_TABLE
8577: , p6_a35 JTF_VARCHAR2_TABLE_100
8578: , p6_a36 JTF_DATE_TABLE
8579: , p6_a37 JTF_VARCHAR2_TABLE_300
8580: , p6_a38 JTF_NUMBER_TABLE
8581: , p6_a39 JTF_NUMBER_TABLE
8582: , p6_a40 JTF_NUMBER_TABLE
8583: , p6_a41 JTF_VARCHAR2_TABLE_100

Line 8657: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_300

8653: , p7_a12 out nocopy JTF_NUMBER_TABLE
8654: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_2000
8655: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_2000
8656: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_2000
8657: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_300
8658: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100
8659: , p7_a18 out nocopy JTF_NUMBER_TABLE
8660: , p7_a19 out nocopy JTF_NUMBER_TABLE
8661: , p7_a20 out nocopy JTF_NUMBER_TABLE

Line 8768: , p8_a37 out nocopy JTF_VARCHAR2_TABLE_300

8764: , p8_a33 out nocopy JTF_NUMBER_TABLE
8765: , p8_a34 out nocopy JTF_DATE_TABLE
8766: , p8_a35 out nocopy JTF_VARCHAR2_TABLE_100
8767: , p8_a36 out nocopy JTF_DATE_TABLE
8768: , p8_a37 out nocopy JTF_VARCHAR2_TABLE_300
8769: , p8_a38 out nocopy JTF_NUMBER_TABLE
8770: , p8_a39 out nocopy JTF_NUMBER_TABLE
8771: , p8_a40 out nocopy JTF_NUMBER_TABLE
8772: , p8_a41 out nocopy JTF_VARCHAR2_TABLE_100

Line 10082: , p5_a16 JTF_VARCHAR2_TABLE_300

10078: , p5_a12 JTF_NUMBER_TABLE
10079: , p5_a13 JTF_VARCHAR2_TABLE_2000
10080: , p5_a14 JTF_VARCHAR2_TABLE_2000
10081: , p5_a15 JTF_VARCHAR2_TABLE_2000
10082: , p5_a16 JTF_VARCHAR2_TABLE_300
10083: , p5_a17 JTF_VARCHAR2_TABLE_100
10084: , p5_a18 JTF_NUMBER_TABLE
10085: , p5_a19 JTF_NUMBER_TABLE
10086: , p5_a20 JTF_NUMBER_TABLE

Line 10193: , p6_a37 JTF_VARCHAR2_TABLE_300

10189: , p6_a33 JTF_NUMBER_TABLE
10190: , p6_a34 JTF_DATE_TABLE
10191: , p6_a35 JTF_VARCHAR2_TABLE_100
10192: , p6_a36 JTF_DATE_TABLE
10193: , p6_a37 JTF_VARCHAR2_TABLE_300
10194: , p6_a38 JTF_NUMBER_TABLE
10195: , p6_a39 JTF_NUMBER_TABLE
10196: , p6_a40 JTF_NUMBER_TABLE
10197: , p6_a41 JTF_VARCHAR2_TABLE_100

Line 10272: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_300

10268: , p8_a12 out nocopy JTF_NUMBER_TABLE
10269: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_2000
10270: , p8_a14 out nocopy JTF_VARCHAR2_TABLE_2000
10271: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_2000
10272: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_300
10273: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100
10274: , p8_a18 out nocopy JTF_NUMBER_TABLE
10275: , p8_a19 out nocopy JTF_NUMBER_TABLE
10276: , p8_a20 out nocopy JTF_NUMBER_TABLE

Line 10383: , p9_a37 out nocopy JTF_VARCHAR2_TABLE_300

10379: , p9_a33 out nocopy JTF_NUMBER_TABLE
10380: , p9_a34 out nocopy JTF_DATE_TABLE
10381: , p9_a35 out nocopy JTF_VARCHAR2_TABLE_100
10382: , p9_a36 out nocopy JTF_DATE_TABLE
10383: , p9_a37 out nocopy JTF_VARCHAR2_TABLE_300
10384: , p9_a38 out nocopy JTF_NUMBER_TABLE
10385: , p9_a39 out nocopy JTF_NUMBER_TABLE
10386: , p9_a40 out nocopy JTF_NUMBER_TABLE
10387: , p9_a41 out nocopy JTF_VARCHAR2_TABLE_100

Line 11310: , p5_a16 JTF_VARCHAR2_TABLE_300

11306: , p5_a12 JTF_NUMBER_TABLE
11307: , p5_a13 JTF_VARCHAR2_TABLE_2000
11308: , p5_a14 JTF_VARCHAR2_TABLE_2000
11309: , p5_a15 JTF_VARCHAR2_TABLE_2000
11310: , p5_a16 JTF_VARCHAR2_TABLE_300
11311: , p5_a17 JTF_VARCHAR2_TABLE_100
11312: , p5_a18 JTF_NUMBER_TABLE
11313: , p5_a19 JTF_NUMBER_TABLE
11314: , p5_a20 JTF_NUMBER_TABLE

Line 11421: , p6_a37 JTF_VARCHAR2_TABLE_300

11417: , p6_a33 JTF_NUMBER_TABLE
11418: , p6_a34 JTF_DATE_TABLE
11419: , p6_a35 JTF_VARCHAR2_TABLE_100
11420: , p6_a36 JTF_DATE_TABLE
11421: , p6_a37 JTF_VARCHAR2_TABLE_300
11422: , p6_a38 JTF_NUMBER_TABLE
11423: , p6_a39 JTF_NUMBER_TABLE
11424: , p6_a40 JTF_NUMBER_TABLE
11425: , p6_a41 JTF_VARCHAR2_TABLE_100

Line 12150: , p5_a16 JTF_VARCHAR2_TABLE_300

12146: , p5_a12 JTF_NUMBER_TABLE
12147: , p5_a13 JTF_VARCHAR2_TABLE_2000
12148: , p5_a14 JTF_VARCHAR2_TABLE_2000
12149: , p5_a15 JTF_VARCHAR2_TABLE_2000
12150: , p5_a16 JTF_VARCHAR2_TABLE_300
12151: , p5_a17 JTF_VARCHAR2_TABLE_100
12152: , p5_a18 JTF_NUMBER_TABLE
12153: , p5_a19 JTF_NUMBER_TABLE
12154: , p5_a20 JTF_NUMBER_TABLE

Line 12261: , p6_a37 JTF_VARCHAR2_TABLE_300

12257: , p6_a33 JTF_NUMBER_TABLE
12258: , p6_a34 JTF_DATE_TABLE
12259: , p6_a35 JTF_VARCHAR2_TABLE_100
12260: , p6_a36 JTF_DATE_TABLE
12261: , p6_a37 JTF_VARCHAR2_TABLE_300
12262: , p6_a38 JTF_NUMBER_TABLE
12263: , p6_a39 JTF_NUMBER_TABLE
12264: , p6_a40 JTF_NUMBER_TABLE
12265: , p6_a41 JTF_VARCHAR2_TABLE_100

Line 12990: , p5_a16 JTF_VARCHAR2_TABLE_300

12986: , p5_a12 JTF_NUMBER_TABLE
12987: , p5_a13 JTF_VARCHAR2_TABLE_2000
12988: , p5_a14 JTF_VARCHAR2_TABLE_2000
12989: , p5_a15 JTF_VARCHAR2_TABLE_2000
12990: , p5_a16 JTF_VARCHAR2_TABLE_300
12991: , p5_a17 JTF_VARCHAR2_TABLE_100
12992: , p5_a18 JTF_NUMBER_TABLE
12993: , p5_a19 JTF_NUMBER_TABLE
12994: , p5_a20 JTF_NUMBER_TABLE

Line 13101: , p6_a37 JTF_VARCHAR2_TABLE_300

13097: , p6_a33 JTF_NUMBER_TABLE
13098: , p6_a34 JTF_DATE_TABLE
13099: , p6_a35 JTF_VARCHAR2_TABLE_100
13100: , p6_a36 JTF_DATE_TABLE
13101: , p6_a37 JTF_VARCHAR2_TABLE_300
13102: , p6_a38 JTF_NUMBER_TABLE
13103: , p6_a39 JTF_NUMBER_TABLE
13104: , p6_a40 JTF_NUMBER_TABLE
13105: , p6_a41 JTF_VARCHAR2_TABLE_100

Line 13826: , p5_a16 JTF_VARCHAR2_TABLE_300

13822: , p5_a12 JTF_NUMBER_TABLE
13823: , p5_a13 JTF_VARCHAR2_TABLE_2000
13824: , p5_a14 JTF_VARCHAR2_TABLE_2000
13825: , p5_a15 JTF_VARCHAR2_TABLE_2000
13826: , p5_a16 JTF_VARCHAR2_TABLE_300
13827: , p5_a17 JTF_VARCHAR2_TABLE_100
13828: , p5_a18 JTF_NUMBER_TABLE
13829: , p5_a19 JTF_NUMBER_TABLE
13830: , p5_a20 JTF_NUMBER_TABLE

Line 13937: , p6_a37 JTF_VARCHAR2_TABLE_300

13933: , p6_a33 JTF_NUMBER_TABLE
13934: , p6_a34 JTF_DATE_TABLE
13935: , p6_a35 JTF_VARCHAR2_TABLE_100
13936: , p6_a36 JTF_DATE_TABLE
13937: , p6_a37 JTF_VARCHAR2_TABLE_300
13938: , p6_a38 JTF_NUMBER_TABLE
13939: , p6_a39 JTF_NUMBER_TABLE
13940: , p6_a40 JTF_NUMBER_TABLE
13941: , p6_a41 JTF_VARCHAR2_TABLE_100

Line 15001: , x_hdr_tbl out nocopy JTF_VARCHAR2_TABLE_300

14997: , p_custid NUMBER
14998: , p_invorgid NUMBER
14999: , p_oldokl_status VARCHAR2
15000: , p_oldokc_status VARCHAR2
15001: , x_hdr_tbl out nocopy JTF_VARCHAR2_TABLE_300
15002: )
15003:
15004: as
15005: ddx_hdr_tbl okl_contract_pvt.hdr_tbl_type;