APPS.OKL_DEAL_ASSET_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 16: , a13 JTF_VARCHAR2_TABLE_200

12: , a9 JTF_VARCHAR2_TABLE_300
13: , a10 JTF_VARCHAR2_TABLE_300
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_200
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_2000
19: );
20: procedure rosetta_table_copy_out_p2(t okl_deal_asset_pvt.addon_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 18: , a15 JTF_VARCHAR2_TABLE_2000

14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_200
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_2000
19: );
20: procedure rosetta_table_copy_out_p2(t okl_deal_asset_pvt.addon_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
21: , a1 out nocopy JTF_NUMBER_TABLE
22: , a2 out nocopy JTF_NUMBER_TABLE

Line 33: , a13 out nocopy JTF_VARCHAR2_TABLE_200

29: , a9 out nocopy JTF_VARCHAR2_TABLE_300
30: , a10 out nocopy JTF_VARCHAR2_TABLE_300
31: , a11 out nocopy JTF_NUMBER_TABLE
32: , a12 out nocopy JTF_VARCHAR2_TABLE_100
33: , a13 out nocopy JTF_VARCHAR2_TABLE_200
34: , a14 out nocopy JTF_VARCHAR2_TABLE_100
35: , a15 out nocopy JTF_VARCHAR2_TABLE_2000
36: );
37:

Line 35: , a15 out nocopy JTF_VARCHAR2_TABLE_2000

31: , a11 out nocopy JTF_NUMBER_TABLE
32: , a12 out nocopy JTF_VARCHAR2_TABLE_100
33: , a13 out nocopy JTF_VARCHAR2_TABLE_200
34: , a14 out nocopy JTF_VARCHAR2_TABLE_100
35: , a15 out nocopy JTF_VARCHAR2_TABLE_2000
36: );
37:
38: procedure rosetta_table_copy_in_p4(t out nocopy okl_deal_asset_pvt.down_payment_tbl_type, a0 JTF_NUMBER_TABLE
39: , a1 JTF_NUMBER_TABLE

Line 40: , a2 JTF_VARCHAR2_TABLE_200

36: );
37:
38: procedure rosetta_table_copy_in_p4(t out nocopy okl_deal_asset_pvt.down_payment_tbl_type, a0 JTF_NUMBER_TABLE
39: , a1 JTF_NUMBER_TABLE
40: , a2 JTF_VARCHAR2_TABLE_200
41: , a3 JTF_NUMBER_TABLE
42: , a4 JTF_VARCHAR2_TABLE_2000
43: , a5 JTF_VARCHAR2_TABLE_100
44: , a6 JTF_NUMBER_TABLE

Line 42: , a4 JTF_VARCHAR2_TABLE_2000

38: procedure rosetta_table_copy_in_p4(t out nocopy okl_deal_asset_pvt.down_payment_tbl_type, a0 JTF_NUMBER_TABLE
39: , a1 JTF_NUMBER_TABLE
40: , a2 JTF_VARCHAR2_TABLE_200
41: , a3 JTF_NUMBER_TABLE
42: , a4 JTF_VARCHAR2_TABLE_2000
43: , a5 JTF_VARCHAR2_TABLE_100
44: , a6 JTF_NUMBER_TABLE
45: , a7 JTF_VARCHAR2_TABLE_100
46: , a8 JTF_VARCHAR2_TABLE_100

Line 50: , a2 out nocopy JTF_VARCHAR2_TABLE_200

46: , a8 JTF_VARCHAR2_TABLE_100
47: );
48: procedure rosetta_table_copy_out_p4(t okl_deal_asset_pvt.down_payment_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
49: , a1 out nocopy JTF_NUMBER_TABLE
50: , a2 out nocopy JTF_VARCHAR2_TABLE_200
51: , a3 out nocopy JTF_NUMBER_TABLE
52: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
53: , a5 out nocopy JTF_VARCHAR2_TABLE_100
54: , a6 out nocopy JTF_NUMBER_TABLE

Line 52: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

48: procedure rosetta_table_copy_out_p4(t okl_deal_asset_pvt.down_payment_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
49: , a1 out nocopy JTF_NUMBER_TABLE
50: , a2 out nocopy JTF_VARCHAR2_TABLE_200
51: , a3 out nocopy JTF_NUMBER_TABLE
52: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
53: , a5 out nocopy JTF_VARCHAR2_TABLE_100
54: , a6 out nocopy JTF_NUMBER_TABLE
55: , a7 out nocopy JTF_VARCHAR2_TABLE_100
56: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 61: , a2 JTF_VARCHAR2_TABLE_200

57: );
58:
59: procedure rosetta_table_copy_in_p6(t out nocopy okl_deal_asset_pvt.tradein_tbl_type, a0 JTF_NUMBER_TABLE
60: , a1 JTF_NUMBER_TABLE
61: , a2 JTF_VARCHAR2_TABLE_200
62: , a3 JTF_NUMBER_TABLE
63: , a4 JTF_VARCHAR2_TABLE_2000
64: , a5 JTF_NUMBER_TABLE
65: );

Line 63: , a4 JTF_VARCHAR2_TABLE_2000

59: procedure rosetta_table_copy_in_p6(t out nocopy okl_deal_asset_pvt.tradein_tbl_type, a0 JTF_NUMBER_TABLE
60: , a1 JTF_NUMBER_TABLE
61: , a2 JTF_VARCHAR2_TABLE_200
62: , a3 JTF_NUMBER_TABLE
63: , a4 JTF_VARCHAR2_TABLE_2000
64: , a5 JTF_NUMBER_TABLE
65: );
66: procedure rosetta_table_copy_out_p6(t okl_deal_asset_pvt.tradein_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
67: , a1 out nocopy JTF_NUMBER_TABLE

Line 68: , a2 out nocopy JTF_VARCHAR2_TABLE_200

64: , a5 JTF_NUMBER_TABLE
65: );
66: procedure rosetta_table_copy_out_p6(t okl_deal_asset_pvt.tradein_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
67: , a1 out nocopy JTF_NUMBER_TABLE
68: , a2 out nocopy JTF_VARCHAR2_TABLE_200
69: , a3 out nocopy JTF_NUMBER_TABLE
70: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
71: , a5 out nocopy JTF_NUMBER_TABLE
72: );

Line 70: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

66: procedure rosetta_table_copy_out_p6(t okl_deal_asset_pvt.tradein_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
67: , a1 out nocopy JTF_NUMBER_TABLE
68: , a2 out nocopy JTF_VARCHAR2_TABLE_200
69: , a3 out nocopy JTF_NUMBER_TABLE
70: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
71: , a5 out nocopy JTF_NUMBER_TABLE
72: );
73:
74: procedure process_line_billing_setup(p_api_version NUMBER

Line 237: , p5_a13 JTF_VARCHAR2_TABLE_200

233: , p5_a9 JTF_VARCHAR2_TABLE_300
234: , p5_a10 JTF_VARCHAR2_TABLE_300
235: , p5_a11 JTF_NUMBER_TABLE
236: , p5_a12 JTF_VARCHAR2_TABLE_100
237: , p5_a13 JTF_VARCHAR2_TABLE_200
238: , p5_a14 JTF_VARCHAR2_TABLE_100
239: , p5_a15 JTF_VARCHAR2_TABLE_2000
240: , p6_a0 out nocopy JTF_NUMBER_TABLE
241: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 239: , p5_a15 JTF_VARCHAR2_TABLE_2000

235: , p5_a11 JTF_NUMBER_TABLE
236: , p5_a12 JTF_VARCHAR2_TABLE_100
237: , p5_a13 JTF_VARCHAR2_TABLE_200
238: , p5_a14 JTF_VARCHAR2_TABLE_100
239: , p5_a15 JTF_VARCHAR2_TABLE_2000
240: , p6_a0 out nocopy JTF_NUMBER_TABLE
241: , p6_a1 out nocopy JTF_NUMBER_TABLE
242: , p6_a2 out nocopy JTF_NUMBER_TABLE
243: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 253: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200

249: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_300
250: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
251: , p6_a11 out nocopy JTF_NUMBER_TABLE
252: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
253: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
254: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
255: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_2000
256: );
257: procedure update_assetaddon_line(p_api_version NUMBER

Line 255: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_2000

251: , p6_a11 out nocopy JTF_NUMBER_TABLE
252: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
253: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
254: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
255: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_2000
256: );
257: procedure update_assetaddon_line(p_api_version NUMBER
258: , p_init_msg_list VARCHAR2
259: , x_return_status out nocopy VARCHAR2

Line 313: , p5_a13 JTF_VARCHAR2_TABLE_200

309: , p5_a9 JTF_VARCHAR2_TABLE_300
310: , p5_a10 JTF_VARCHAR2_TABLE_300
311: , p5_a11 JTF_NUMBER_TABLE
312: , p5_a12 JTF_VARCHAR2_TABLE_100
313: , p5_a13 JTF_VARCHAR2_TABLE_200
314: , p5_a14 JTF_VARCHAR2_TABLE_100
315: , p5_a15 JTF_VARCHAR2_TABLE_2000
316: , p6_a0 out nocopy JTF_NUMBER_TABLE
317: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 315: , p5_a15 JTF_VARCHAR2_TABLE_2000

311: , p5_a11 JTF_NUMBER_TABLE
312: , p5_a12 JTF_VARCHAR2_TABLE_100
313: , p5_a13 JTF_VARCHAR2_TABLE_200
314: , p5_a14 JTF_VARCHAR2_TABLE_100
315: , p5_a15 JTF_VARCHAR2_TABLE_2000
316: , p6_a0 out nocopy JTF_NUMBER_TABLE
317: , p6_a1 out nocopy JTF_NUMBER_TABLE
318: , p6_a2 out nocopy JTF_NUMBER_TABLE
319: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 329: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200

325: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_300
326: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
327: , p6_a11 out nocopy JTF_NUMBER_TABLE
328: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
329: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
330: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
331: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_2000
332: );
333: procedure create_all_line(p_api_version NUMBER

Line 331: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_2000

327: , p6_a11 out nocopy JTF_NUMBER_TABLE
328: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
329: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
330: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
331: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_2000
332: );
333: procedure create_all_line(p_api_version NUMBER
334: , p_init_msg_list VARCHAR2
335: , x_return_status out nocopy VARCHAR2

Line 618: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_200

614: , p_tradein_amount NUMBER
615: , p_mode VARCHAR2
616: , p8_a0 out nocopy JTF_NUMBER_TABLE
617: , p8_a1 out nocopy JTF_NUMBER_TABLE
618: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_200
619: , p8_a3 out nocopy JTF_NUMBER_TABLE
620: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
621: , p8_a5 out nocopy JTF_NUMBER_TABLE
622: );

Line 620: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000

616: , p8_a0 out nocopy JTF_NUMBER_TABLE
617: , p8_a1 out nocopy JTF_NUMBER_TABLE
618: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_200
619: , p8_a3 out nocopy JTF_NUMBER_TABLE
620: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
621: , p8_a5 out nocopy JTF_NUMBER_TABLE
622: );
623: procedure allocate_amount_down_payment(p_api_version NUMBER
624: , p_init_msg_list VARCHAR2

Line 634: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200

630: , p_basis VARCHAR2
631: , p_mode VARCHAR2
632: , p9_a0 out nocopy JTF_NUMBER_TABLE
633: , p9_a1 out nocopy JTF_NUMBER_TABLE
634: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
635: , p9_a3 out nocopy JTF_NUMBER_TABLE
636: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_2000
637: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
638: , p9_a6 out nocopy JTF_NUMBER_TABLE

Line 636: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_2000

632: , p9_a0 out nocopy JTF_NUMBER_TABLE
633: , p9_a1 out nocopy JTF_NUMBER_TABLE
634: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
635: , p9_a3 out nocopy JTF_NUMBER_TABLE
636: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_2000
637: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
638: , p9_a6 out nocopy JTF_NUMBER_TABLE
639: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
640: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100