DBA Data[Home] [Help]

APPS.OKL_TERMS_AND_CONDS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: OKLUSZTS.pls 120.1 2005/07/20 10:11:30 dkagrawa noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_terms_and_conds_pvt.trm_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_300
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100

Line 8: , a5 JTF_VARCHAR2_TABLE_100

4: , a1 JTF_VARCHAR2_TABLE_300
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100

Line 9: , a6 JTF_VARCHAR2_TABLE_100

5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100

Line 10: , a7 JTF_VARCHAR2_TABLE_100

6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: );

Line 11: , a8 JTF_VARCHAR2_TABLE_100

7: , a4 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: );
15: procedure rosetta_table_copy_out_p1(t okl_terms_and_conds_pvt.trm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 12: , a9 JTF_VARCHAR2_TABLE_100

8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: );
15: procedure rosetta_table_copy_out_p1(t okl_terms_and_conds_pvt.trm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_VARCHAR2_TABLE_300

Line 13: , a10 JTF_VARCHAR2_TABLE_100

9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: );
15: procedure rosetta_table_copy_out_p1(t okl_terms_and_conds_pvt.trm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_VARCHAR2_TABLE_300
17: , a2 out nocopy JTF_VARCHAR2_TABLE_300

Line 18: , a3 out nocopy JTF_VARCHAR2_TABLE_100

14: );
15: procedure rosetta_table_copy_out_p1(t okl_terms_and_conds_pvt.trm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_VARCHAR2_TABLE_300
17: , a2 out nocopy JTF_VARCHAR2_TABLE_300
18: , a3 out nocopy JTF_VARCHAR2_TABLE_100
19: , a4 out nocopy JTF_VARCHAR2_TABLE_300
20: , a5 out nocopy JTF_VARCHAR2_TABLE_100
21: , a6 out nocopy JTF_VARCHAR2_TABLE_100
22: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 20: , a5 out nocopy JTF_VARCHAR2_TABLE_100

16: , a1 out nocopy JTF_VARCHAR2_TABLE_300
17: , a2 out nocopy JTF_VARCHAR2_TABLE_300
18: , a3 out nocopy JTF_VARCHAR2_TABLE_100
19: , a4 out nocopy JTF_VARCHAR2_TABLE_300
20: , a5 out nocopy JTF_VARCHAR2_TABLE_100
21: , a6 out nocopy JTF_VARCHAR2_TABLE_100
22: , a7 out nocopy JTF_VARCHAR2_TABLE_100
23: , a8 out nocopy JTF_VARCHAR2_TABLE_100
24: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 21: , a6 out nocopy JTF_VARCHAR2_TABLE_100

17: , a2 out nocopy JTF_VARCHAR2_TABLE_300
18: , a3 out nocopy JTF_VARCHAR2_TABLE_100
19: , a4 out nocopy JTF_VARCHAR2_TABLE_300
20: , a5 out nocopy JTF_VARCHAR2_TABLE_100
21: , a6 out nocopy JTF_VARCHAR2_TABLE_100
22: , a7 out nocopy JTF_VARCHAR2_TABLE_100
23: , a8 out nocopy JTF_VARCHAR2_TABLE_100
24: , a9 out nocopy JTF_VARCHAR2_TABLE_100
25: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 22: , a7 out nocopy JTF_VARCHAR2_TABLE_100

18: , a3 out nocopy JTF_VARCHAR2_TABLE_100
19: , a4 out nocopy JTF_VARCHAR2_TABLE_300
20: , a5 out nocopy JTF_VARCHAR2_TABLE_100
21: , a6 out nocopy JTF_VARCHAR2_TABLE_100
22: , a7 out nocopy JTF_VARCHAR2_TABLE_100
23: , a8 out nocopy JTF_VARCHAR2_TABLE_100
24: , a9 out nocopy JTF_VARCHAR2_TABLE_100
25: , a10 out nocopy JTF_VARCHAR2_TABLE_100
26: );

Line 23: , a8 out nocopy JTF_VARCHAR2_TABLE_100

19: , a4 out nocopy JTF_VARCHAR2_TABLE_300
20: , a5 out nocopy JTF_VARCHAR2_TABLE_100
21: , a6 out nocopy JTF_VARCHAR2_TABLE_100
22: , a7 out nocopy JTF_VARCHAR2_TABLE_100
23: , a8 out nocopy JTF_VARCHAR2_TABLE_100
24: , a9 out nocopy JTF_VARCHAR2_TABLE_100
25: , a10 out nocopy JTF_VARCHAR2_TABLE_100
26: );
27:

Line 24: , a9 out nocopy JTF_VARCHAR2_TABLE_100

20: , a5 out nocopy JTF_VARCHAR2_TABLE_100
21: , a6 out nocopy JTF_VARCHAR2_TABLE_100
22: , a7 out nocopy JTF_VARCHAR2_TABLE_100
23: , a8 out nocopy JTF_VARCHAR2_TABLE_100
24: , a9 out nocopy JTF_VARCHAR2_TABLE_100
25: , a10 out nocopy JTF_VARCHAR2_TABLE_100
26: );
27:
28: procedure get_terms_conditions(p_api_version NUMBER

Line 25: , a10 out nocopy JTF_VARCHAR2_TABLE_100

21: , a6 out nocopy JTF_VARCHAR2_TABLE_100
22: , a7 out nocopy JTF_VARCHAR2_TABLE_100
23: , a8 out nocopy JTF_VARCHAR2_TABLE_100
24: , a9 out nocopy JTF_VARCHAR2_TABLE_100
25: , a10 out nocopy JTF_VARCHAR2_TABLE_100
26: );
27:
28: procedure get_terms_conditions(p_api_version NUMBER
29: , p_init_msg_list VARCHAR2

Line 37: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

33: , p_type VARCHAR2
34: , p6_a0 out nocopy JTF_NUMBER_TABLE
35: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
36: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
37: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
38: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
39: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
40: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
41: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 39: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

35: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
36: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
37: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
38: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
39: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
40: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
41: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
42: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
43: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 40: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

36: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
37: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
38: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
39: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
40: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
41: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
42: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
43: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
44: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 41: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

37: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
38: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
39: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
40: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
41: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
42: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
43: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
44: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
45: );

Line 42: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

38: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
39: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
40: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
41: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
42: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
43: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
44: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
45: );
46: end okl_terms_and_conds_pvt_w;

Line 43: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

39: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
40: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
41: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
42: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
43: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
44: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
45: );
46: end okl_terms_and_conds_pvt_w;

Line 44: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

40: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
41: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
42: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
43: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
44: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
45: );
46: end okl_terms_and_conds_pvt_w;