DBA Data[Home] [Help]

APPS.OKL_CREDIT_PUB_W dependencies on JTF_VARCHAR2_TABLE_200

Line 25: , a3 JTF_VARCHAR2_TABLE_200

21:
22: procedure rosetta_table_copy_in_p5(t out nocopy okl_credit_pub.clev_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_200
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_2000

Line 29: , a7 JTF_VARCHAR2_TABLE_2000

25: , a3 JTF_VARCHAR2_TABLE_200
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_2000
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_DATE_TABLE
32: ) as
33: ddindx binary_integer; indx binary_integer;

Line 62: , a3 out nocopy JTF_VARCHAR2_TABLE_200

58: end rosetta_table_copy_in_p5;
59: procedure rosetta_table_copy_out_p5(t okl_credit_pub.clev_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
60: , a1 out nocopy JTF_NUMBER_TABLE
61: , a2 out nocopy JTF_NUMBER_TABLE
62: , a3 out nocopy JTF_VARCHAR2_TABLE_200
63: , a4 out nocopy JTF_VARCHAR2_TABLE_100
64: , a5 out nocopy JTF_NUMBER_TABLE
65: , a6 out nocopy JTF_NUMBER_TABLE
66: , a7 out nocopy JTF_VARCHAR2_TABLE_2000

Line 66: , a7 out nocopy JTF_VARCHAR2_TABLE_2000

62: , a3 out nocopy JTF_VARCHAR2_TABLE_200
63: , a4 out nocopy JTF_VARCHAR2_TABLE_100
64: , a5 out nocopy JTF_NUMBER_TABLE
65: , a6 out nocopy JTF_NUMBER_TABLE
66: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
67: , a8 out nocopy JTF_VARCHAR2_TABLE_100
68: , a9 out nocopy JTF_DATE_TABLE
69: ) as
70: ddindx binary_integer; indx binary_integer;

Line 76: a3 := JTF_VARCHAR2_TABLE_200();

72: if t is null or t.count = 0 then
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_NUMBER_TABLE();
76: a3 := JTF_VARCHAR2_TABLE_200();
77: a4 := JTF_VARCHAR2_TABLE_100();
78: a5 := JTF_NUMBER_TABLE();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_VARCHAR2_TABLE_2000();

Line 80: a7 := JTF_VARCHAR2_TABLE_2000();

76: a3 := JTF_VARCHAR2_TABLE_200();
77: a4 := JTF_VARCHAR2_TABLE_100();
78: a5 := JTF_NUMBER_TABLE();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_VARCHAR2_TABLE_2000();
81: a8 := JTF_VARCHAR2_TABLE_100();
82: a9 := JTF_DATE_TABLE();
83: else
84: a0 := JTF_NUMBER_TABLE();

Line 87: a3 := JTF_VARCHAR2_TABLE_200();

83: else
84: a0 := JTF_NUMBER_TABLE();
85: a1 := JTF_NUMBER_TABLE();
86: a2 := JTF_NUMBER_TABLE();
87: a3 := JTF_VARCHAR2_TABLE_200();
88: a4 := JTF_VARCHAR2_TABLE_100();
89: a5 := JTF_NUMBER_TABLE();
90: a6 := JTF_NUMBER_TABLE();
91: a7 := JTF_VARCHAR2_TABLE_2000();

Line 91: a7 := JTF_VARCHAR2_TABLE_2000();

87: a3 := JTF_VARCHAR2_TABLE_200();
88: a4 := JTF_VARCHAR2_TABLE_100();
89: a5 := JTF_NUMBER_TABLE();
90: a6 := JTF_NUMBER_TABLE();
91: a7 := JTF_VARCHAR2_TABLE_2000();
92: a8 := JTF_VARCHAR2_TABLE_100();
93: a9 := JTF_DATE_TABLE();
94: if t.count > 0 then
95: a0.extend(t.count);

Line 2357: , p6_a8 JTF_VARCHAR2_TABLE_200

2353: , p6_a4 JTF_NUMBER_TABLE
2354: , p6_a5 JTF_NUMBER_TABLE
2355: , p6_a6 JTF_NUMBER_TABLE
2356: , p6_a7 JTF_NUMBER_TABLE
2357: , p6_a8 JTF_VARCHAR2_TABLE_200
2358: , p6_a9 JTF_VARCHAR2_TABLE_100
2359: , p6_a10 JTF_NUMBER_TABLE
2360: , p6_a11 JTF_VARCHAR2_TABLE_100
2361: , p6_a12 JTF_NUMBER_TABLE

Line 2362: , p6_a13 JTF_VARCHAR2_TABLE_2000

2358: , p6_a9 JTF_VARCHAR2_TABLE_100
2359: , p6_a10 JTF_NUMBER_TABLE
2360: , p6_a11 JTF_VARCHAR2_TABLE_100
2361: , p6_a12 JTF_NUMBER_TABLE
2362: , p6_a13 JTF_VARCHAR2_TABLE_2000
2363: , p6_a14 JTF_VARCHAR2_TABLE_2000
2364: , p6_a15 JTF_VARCHAR2_TABLE_2000
2365: , p6_a16 JTF_VARCHAR2_TABLE_300
2366: , p6_a17 JTF_VARCHAR2_TABLE_100

Line 2363: , p6_a14 JTF_VARCHAR2_TABLE_2000

2359: , p6_a10 JTF_NUMBER_TABLE
2360: , p6_a11 JTF_VARCHAR2_TABLE_100
2361: , p6_a12 JTF_NUMBER_TABLE
2362: , p6_a13 JTF_VARCHAR2_TABLE_2000
2363: , p6_a14 JTF_VARCHAR2_TABLE_2000
2364: , p6_a15 JTF_VARCHAR2_TABLE_2000
2365: , p6_a16 JTF_VARCHAR2_TABLE_300
2366: , p6_a17 JTF_VARCHAR2_TABLE_100
2367: , p6_a18 JTF_NUMBER_TABLE

Line 2364: , p6_a15 JTF_VARCHAR2_TABLE_2000

2360: , p6_a11 JTF_VARCHAR2_TABLE_100
2361: , p6_a12 JTF_NUMBER_TABLE
2362: , p6_a13 JTF_VARCHAR2_TABLE_2000
2363: , p6_a14 JTF_VARCHAR2_TABLE_2000
2364: , p6_a15 JTF_VARCHAR2_TABLE_2000
2365: , p6_a16 JTF_VARCHAR2_TABLE_300
2366: , p6_a17 JTF_VARCHAR2_TABLE_100
2367: , p6_a18 JTF_NUMBER_TABLE
2368: , p6_a19 JTF_NUMBER_TABLE

Line 2374: , p6_a25 JTF_VARCHAR2_TABLE_2000

2370: , p6_a21 JTF_NUMBER_TABLE
2371: , p6_a22 JTF_VARCHAR2_TABLE_100
2372: , p6_a23 JTF_VARCHAR2_TABLE_100
2373: , p6_a24 JTF_VARCHAR2_TABLE_100
2374: , p6_a25 JTF_VARCHAR2_TABLE_2000
2375: , p6_a26 JTF_VARCHAR2_TABLE_100
2376: , p6_a27 JTF_VARCHAR2_TABLE_200
2377: , p6_a28 JTF_DATE_TABLE
2378: , p6_a29 JTF_VARCHAR2_TABLE_200

Line 2376: , p6_a27 JTF_VARCHAR2_TABLE_200

2372: , p6_a23 JTF_VARCHAR2_TABLE_100
2373: , p6_a24 JTF_VARCHAR2_TABLE_100
2374: , p6_a25 JTF_VARCHAR2_TABLE_2000
2375: , p6_a26 JTF_VARCHAR2_TABLE_100
2376: , p6_a27 JTF_VARCHAR2_TABLE_200
2377: , p6_a28 JTF_DATE_TABLE
2378: , p6_a29 JTF_VARCHAR2_TABLE_200
2379: , p6_a30 JTF_DATE_TABLE
2380: , p6_a31 JTF_DATE_TABLE

Line 2378: , p6_a29 JTF_VARCHAR2_TABLE_200

2374: , p6_a25 JTF_VARCHAR2_TABLE_2000
2375: , p6_a26 JTF_VARCHAR2_TABLE_100
2376: , p6_a27 JTF_VARCHAR2_TABLE_200
2377: , p6_a28 JTF_DATE_TABLE
2378: , p6_a29 JTF_VARCHAR2_TABLE_200
2379: , p6_a30 JTF_DATE_TABLE
2380: , p6_a31 JTF_DATE_TABLE
2381: , p6_a32 JTF_DATE_TABLE
2382: , p6_a33 JTF_VARCHAR2_TABLE_100

Line 2774: , p5_a3 JTF_VARCHAR2_TABLE_200

2770: , x_msg_data out nocopy VARCHAR2
2771: , p5_a0 JTF_NUMBER_TABLE
2772: , p5_a1 JTF_NUMBER_TABLE
2773: , p5_a2 JTF_NUMBER_TABLE
2774: , p5_a3 JTF_VARCHAR2_TABLE_200
2775: , p5_a4 JTF_VARCHAR2_TABLE_100
2776: , p5_a5 JTF_NUMBER_TABLE
2777: , p5_a6 JTF_NUMBER_TABLE
2778: , p5_a7 JTF_VARCHAR2_TABLE_2000

Line 2778: , p5_a7 JTF_VARCHAR2_TABLE_2000

2774: , p5_a3 JTF_VARCHAR2_TABLE_200
2775: , p5_a4 JTF_VARCHAR2_TABLE_100
2776: , p5_a5 JTF_NUMBER_TABLE
2777: , p5_a6 JTF_NUMBER_TABLE
2778: , p5_a7 JTF_VARCHAR2_TABLE_2000
2779: , p5_a8 JTF_VARCHAR2_TABLE_100
2780: , p5_a9 JTF_DATE_TABLE
2781: , p6_a0 JTF_NUMBER_TABLE
2782: , p6_a1 JTF_NUMBER_TABLE

Line 2883: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200

2879: , p6_a98 JTF_NUMBER_TABLE
2880: , p7_a0 out nocopy JTF_NUMBER_TABLE
2881: , p7_a1 out nocopy JTF_NUMBER_TABLE
2882: , p7_a2 out nocopy JTF_NUMBER_TABLE
2883: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
2884: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
2885: , p7_a5 out nocopy JTF_NUMBER_TABLE
2886: , p7_a6 out nocopy JTF_NUMBER_TABLE
2887: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_2000

Line 2887: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_2000

2883: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
2884: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
2885: , p7_a5 out nocopy JTF_NUMBER_TABLE
2886: , p7_a6 out nocopy JTF_NUMBER_TABLE
2887: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_2000
2888: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
2889: , p7_a9 out nocopy JTF_DATE_TABLE
2890: , p8_a0 out nocopy JTF_NUMBER_TABLE
2891: , p8_a1 out nocopy JTF_NUMBER_TABLE

Line 3262: , p5_a3 JTF_VARCHAR2_TABLE_200

3258: , x_msg_data out nocopy VARCHAR2
3259: , p5_a0 JTF_NUMBER_TABLE
3260: , p5_a1 JTF_NUMBER_TABLE
3261: , p5_a2 JTF_NUMBER_TABLE
3262: , p5_a3 JTF_VARCHAR2_TABLE_200
3263: , p5_a4 JTF_VARCHAR2_TABLE_100
3264: , p5_a5 JTF_NUMBER_TABLE
3265: , p5_a6 JTF_NUMBER_TABLE
3266: , p5_a7 JTF_VARCHAR2_TABLE_2000

Line 3266: , p5_a7 JTF_VARCHAR2_TABLE_2000

3262: , p5_a3 JTF_VARCHAR2_TABLE_200
3263: , p5_a4 JTF_VARCHAR2_TABLE_100
3264: , p5_a5 JTF_NUMBER_TABLE
3265: , p5_a6 JTF_NUMBER_TABLE
3266: , p5_a7 JTF_VARCHAR2_TABLE_2000
3267: , p5_a8 JTF_VARCHAR2_TABLE_100
3268: , p5_a9 JTF_DATE_TABLE
3269: , p6_a0 JTF_NUMBER_TABLE
3270: , p6_a1 JTF_NUMBER_TABLE

Line 3371: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200

3367: , p6_a98 JTF_NUMBER_TABLE
3368: , p7_a0 out nocopy JTF_NUMBER_TABLE
3369: , p7_a1 out nocopy JTF_NUMBER_TABLE
3370: , p7_a2 out nocopy JTF_NUMBER_TABLE
3371: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
3372: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
3373: , p7_a5 out nocopy JTF_NUMBER_TABLE
3374: , p7_a6 out nocopy JTF_NUMBER_TABLE
3375: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_2000

Line 3375: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_2000

3371: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
3372: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
3373: , p7_a5 out nocopy JTF_NUMBER_TABLE
3374: , p7_a6 out nocopy JTF_NUMBER_TABLE
3375: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_2000
3376: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
3377: , p7_a9 out nocopy JTF_DATE_TABLE
3378: , p8_a0 out nocopy JTF_NUMBER_TABLE
3379: , p8_a1 out nocopy JTF_NUMBER_TABLE

Line 3750: , p5_a3 JTF_VARCHAR2_TABLE_200

3746: , x_msg_data out nocopy VARCHAR2
3747: , p5_a0 JTF_NUMBER_TABLE
3748: , p5_a1 JTF_NUMBER_TABLE
3749: , p5_a2 JTF_NUMBER_TABLE
3750: , p5_a3 JTF_VARCHAR2_TABLE_200
3751: , p5_a4 JTF_VARCHAR2_TABLE_100
3752: , p5_a5 JTF_NUMBER_TABLE
3753: , p5_a6 JTF_NUMBER_TABLE
3754: , p5_a7 JTF_VARCHAR2_TABLE_2000

Line 3754: , p5_a7 JTF_VARCHAR2_TABLE_2000

3750: , p5_a3 JTF_VARCHAR2_TABLE_200
3751: , p5_a4 JTF_VARCHAR2_TABLE_100
3752: , p5_a5 JTF_NUMBER_TABLE
3753: , p5_a6 JTF_NUMBER_TABLE
3754: , p5_a7 JTF_VARCHAR2_TABLE_2000
3755: , p5_a8 JTF_VARCHAR2_TABLE_100
3756: , p5_a9 JTF_DATE_TABLE
3757: , p6_a0 JTF_NUMBER_TABLE
3758: , p6_a1 JTF_NUMBER_TABLE