PACKAGE: APPS.LNS_PAYOFF_PUB_W

Source

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
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
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
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
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 
43   procedure processpayoff(p_api_version  NUMBER
44     , p_init_msg_list  VARCHAR2
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
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   );
59   procedure getloaninvoices(p_api_version  NUMBER
60     , p_init_msg_list  VARCHAR2
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
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   );
76 end lns_payoff_pub_w;