DBA Data[Home] [Help]

APPS.LNS_PAYOFF_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package lns_payoff_pub_w as
2: /* $Header: LNS_PAYOFFJ_S.pls 120.0 2005/05/31 17:57:19 appldev noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy lns_payoff_pub.invoice_details_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE

Line 7: , a4 JTF_VARCHAR2_TABLE_100

3: procedure rosetta_table_copy_in_p1(t out nocopy lns_payoff_pub.invoice_details_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100

Line 10: , a7 JTF_VARCHAR2_TABLE_100

6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: );
13: procedure rosetta_table_copy_out_p1(t lns_payoff_pub.invoice_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE

Line 11: , a8 JTF_VARCHAR2_TABLE_100

7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: );
13: procedure rosetta_table_copy_out_p1(t lns_payoff_pub.invoice_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 15: , a2 out nocopy JTF_VARCHAR2_TABLE_100

11: , a8 JTF_VARCHAR2_TABLE_100
12: );
13: procedure rosetta_table_copy_out_p1(t lns_payoff_pub.invoice_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_VARCHAR2_TABLE_100
16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_VARCHAR2_TABLE_100
18: , a5 out nocopy JTF_NUMBER_TABLE
19: , a6 out nocopy JTF_DATE_TABLE

Line 17: , a4 out nocopy JTF_VARCHAR2_TABLE_100

13: procedure rosetta_table_copy_out_p1(t lns_payoff_pub.invoice_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_VARCHAR2_TABLE_100
16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_VARCHAR2_TABLE_100
18: , a5 out nocopy JTF_NUMBER_TABLE
19: , a6 out nocopy JTF_DATE_TABLE
20: , a7 out nocopy JTF_VARCHAR2_TABLE_100
21: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 20: , a7 out nocopy JTF_VARCHAR2_TABLE_100

16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_VARCHAR2_TABLE_100
18: , a5 out nocopy JTF_NUMBER_TABLE
19: , a6 out nocopy JTF_DATE_TABLE
20: , a7 out nocopy JTF_VARCHAR2_TABLE_100
21: , a8 out nocopy JTF_VARCHAR2_TABLE_100
22: );
23:
24: procedure rosetta_table_copy_in_p3(t out nocopy lns_payoff_pub.cash_receipt_tbl, a0 JTF_NUMBER_TABLE

Line 21: , a8 out nocopy JTF_VARCHAR2_TABLE_100

17: , a4 out nocopy JTF_VARCHAR2_TABLE_100
18: , a5 out nocopy JTF_NUMBER_TABLE
19: , a6 out nocopy JTF_DATE_TABLE
20: , a7 out nocopy JTF_VARCHAR2_TABLE_100
21: , a8 out nocopy JTF_VARCHAR2_TABLE_100
22: );
23:
24: procedure rosetta_table_copy_in_p3(t out nocopy lns_payoff_pub.cash_receipt_tbl, a0 JTF_NUMBER_TABLE
25: , a1 JTF_NUMBER_TABLE

Line 26: , a2 JTF_VARCHAR2_TABLE_100

22: );
23:
24: procedure rosetta_table_copy_in_p3(t out nocopy lns_payoff_pub.cash_receipt_tbl, a0 JTF_NUMBER_TABLE
25: , a1 JTF_NUMBER_TABLE
26: , a2 JTF_VARCHAR2_TABLE_100
27: , a3 JTF_NUMBER_TABLE
28: , a4 JTF_DATE_TABLE
29: , a5 JTF_VARCHAR2_TABLE_100
30: , a6 JTF_VARCHAR2_TABLE_100

Line 29: , a5 JTF_VARCHAR2_TABLE_100

25: , a1 JTF_NUMBER_TABLE
26: , a2 JTF_VARCHAR2_TABLE_100
27: , a3 JTF_NUMBER_TABLE
28: , a4 JTF_DATE_TABLE
29: , a5 JTF_VARCHAR2_TABLE_100
30: , a6 JTF_VARCHAR2_TABLE_100
31: , a7 JTF_VARCHAR2_TABLE_100
32: );
33: procedure rosetta_table_copy_out_p3(t lns_payoff_pub.cash_receipt_tbl, a0 out nocopy JTF_NUMBER_TABLE

Line 30: , a6 JTF_VARCHAR2_TABLE_100

26: , a2 JTF_VARCHAR2_TABLE_100
27: , a3 JTF_NUMBER_TABLE
28: , a4 JTF_DATE_TABLE
29: , a5 JTF_VARCHAR2_TABLE_100
30: , a6 JTF_VARCHAR2_TABLE_100
31: , a7 JTF_VARCHAR2_TABLE_100
32: );
33: procedure rosetta_table_copy_out_p3(t lns_payoff_pub.cash_receipt_tbl, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE

Line 31: , a7 JTF_VARCHAR2_TABLE_100

27: , a3 JTF_NUMBER_TABLE
28: , a4 JTF_DATE_TABLE
29: , a5 JTF_VARCHAR2_TABLE_100
30: , a6 JTF_VARCHAR2_TABLE_100
31: , a7 JTF_VARCHAR2_TABLE_100
32: );
33: procedure rosetta_table_copy_out_p3(t lns_payoff_pub.cash_receipt_tbl, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 35: , a2 out nocopy JTF_VARCHAR2_TABLE_100

31: , a7 JTF_VARCHAR2_TABLE_100
32: );
33: procedure rosetta_table_copy_out_p3(t lns_payoff_pub.cash_receipt_tbl, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_VARCHAR2_TABLE_100
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_DATE_TABLE
38: , a5 out nocopy JTF_VARCHAR2_TABLE_100
39: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 38: , a5 out nocopy JTF_VARCHAR2_TABLE_100

34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_VARCHAR2_TABLE_100
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_DATE_TABLE
38: , a5 out nocopy JTF_VARCHAR2_TABLE_100
39: , a6 out nocopy JTF_VARCHAR2_TABLE_100
40: , a7 out nocopy JTF_VARCHAR2_TABLE_100
41: );
42:

Line 39: , a6 out nocopy JTF_VARCHAR2_TABLE_100

35: , a2 out nocopy JTF_VARCHAR2_TABLE_100
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_DATE_TABLE
38: , a5 out nocopy JTF_VARCHAR2_TABLE_100
39: , a6 out nocopy JTF_VARCHAR2_TABLE_100
40: , a7 out nocopy JTF_VARCHAR2_TABLE_100
41: );
42:
43: procedure processpayoff(p_api_version NUMBER

Line 40: , a7 out nocopy JTF_VARCHAR2_TABLE_100

36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_DATE_TABLE
38: , a5 out nocopy JTF_VARCHAR2_TABLE_100
39: , a6 out nocopy JTF_VARCHAR2_TABLE_100
40: , a7 out nocopy JTF_VARCHAR2_TABLE_100
41: );
42:
43: procedure processpayoff(p_api_version NUMBER
44: , p_init_msg_list VARCHAR2

Line 49: , p4_a2 JTF_VARCHAR2_TABLE_100

45: , p_loan_id NUMBER
46: , p_payoff_date DATE
47: , p4_a0 JTF_NUMBER_TABLE
48: , p4_a1 JTF_NUMBER_TABLE
49: , p4_a2 JTF_VARCHAR2_TABLE_100
50: , p4_a3 JTF_NUMBER_TABLE
51: , p4_a4 JTF_DATE_TABLE
52: , p4_a5 JTF_VARCHAR2_TABLE_100
53: , p4_a6 JTF_VARCHAR2_TABLE_100

Line 52: , p4_a5 JTF_VARCHAR2_TABLE_100

48: , p4_a1 JTF_NUMBER_TABLE
49: , p4_a2 JTF_VARCHAR2_TABLE_100
50: , p4_a3 JTF_NUMBER_TABLE
51: , p4_a4 JTF_DATE_TABLE
52: , p4_a5 JTF_VARCHAR2_TABLE_100
53: , p4_a6 JTF_VARCHAR2_TABLE_100
54: , p4_a7 JTF_VARCHAR2_TABLE_100
55: , x_return_status out nocopy VARCHAR2
56: , x_msg_count out nocopy NUMBER

Line 53: , p4_a6 JTF_VARCHAR2_TABLE_100

49: , p4_a2 JTF_VARCHAR2_TABLE_100
50: , p4_a3 JTF_NUMBER_TABLE
51: , p4_a4 JTF_DATE_TABLE
52: , p4_a5 JTF_VARCHAR2_TABLE_100
53: , p4_a6 JTF_VARCHAR2_TABLE_100
54: , p4_a7 JTF_VARCHAR2_TABLE_100
55: , x_return_status out nocopy VARCHAR2
56: , x_msg_count out nocopy NUMBER
57: , x_msg_data out nocopy VARCHAR2

Line 54: , p4_a7 JTF_VARCHAR2_TABLE_100

50: , p4_a3 JTF_NUMBER_TABLE
51: , p4_a4 JTF_DATE_TABLE
52: , p4_a5 JTF_VARCHAR2_TABLE_100
53: , p4_a6 JTF_VARCHAR2_TABLE_100
54: , p4_a7 JTF_VARCHAR2_TABLE_100
55: , x_return_status out nocopy VARCHAR2
56: , x_msg_count out nocopy NUMBER
57: , x_msg_data out nocopy VARCHAR2
58: );

Line 65: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100

61: , p_loan_id NUMBER
62: , p_payoff_date DATE
63: , p4_a0 out nocopy JTF_NUMBER_TABLE
64: , p4_a1 out nocopy JTF_NUMBER_TABLE
65: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
66: , p4_a3 out nocopy JTF_NUMBER_TABLE
67: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
68: , p4_a5 out nocopy JTF_NUMBER_TABLE
69: , p4_a6 out nocopy JTF_DATE_TABLE

Line 67: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100

63: , p4_a0 out nocopy JTF_NUMBER_TABLE
64: , p4_a1 out nocopy JTF_NUMBER_TABLE
65: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
66: , p4_a3 out nocopy JTF_NUMBER_TABLE
67: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
68: , p4_a5 out nocopy JTF_NUMBER_TABLE
69: , p4_a6 out nocopy JTF_DATE_TABLE
70: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
71: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 70: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100

66: , p4_a3 out nocopy JTF_NUMBER_TABLE
67: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
68: , p4_a5 out nocopy JTF_NUMBER_TABLE
69: , p4_a6 out nocopy JTF_DATE_TABLE
70: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
71: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
72: , x_return_status out nocopy VARCHAR2
73: , x_msg_count out nocopy NUMBER
74: , x_msg_data out nocopy VARCHAR2

Line 71: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100

67: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
68: , p4_a5 out nocopy JTF_NUMBER_TABLE
69: , p4_a6 out nocopy JTF_DATE_TABLE
70: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
71: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
72: , x_return_status out nocopy VARCHAR2
73: , x_msg_count out nocopy NUMBER
74: , x_msg_data out nocopy VARCHAR2
75: );