PACKAGE: APPS.OKL_CREDIT_DATAPOINTS_PVT_W

Source

1 package okl_credit_datapoints_pvt_w AUTHID CURRENT_USER as
2   /* $Header: OKLECDPS.pls 120.1 2011/04/07 21:20:14 rmunjulu ship $ */
3   procedure rosetta_table_copy_in_p4(t out nocopy okl_credit_datapoints_pvt.lap_dp_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_NUMBER_TABLE
5     , a2 JTF_NUMBER_TABLE
6     , a3 JTF_NUMBER_TABLE
7     , a4 JTF_VARCHAR2_TABLE_100
8     , a5 JTF_VARCHAR2_TABLE_200
9     , a6 JTF_VARCHAR2_TABLE_100
10     , a7 JTF_VARCHAR2_TABLE_200
11     );
12   procedure rosetta_table_copy_out_p4(t okl_credit_datapoints_pvt.lap_dp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
13     , a1 out nocopy JTF_NUMBER_TABLE
14     , a2 out nocopy JTF_NUMBER_TABLE
15     , a3 out nocopy JTF_NUMBER_TABLE
16     , a4 out nocopy JTF_VARCHAR2_TABLE_100
17     , a5 out nocopy JTF_VARCHAR2_TABLE_200
18     , a6 out nocopy JTF_VARCHAR2_TABLE_100
19     , a7 out nocopy JTF_VARCHAR2_TABLE_200
20     );
21 
22   procedure fetch_leaseapp_datapoints(p_api_version  NUMBER
23     , p_init_msg_list  VARCHAR2
24     , p_leaseapp_id  NUMBER
25     , p3_a0 out nocopy JTF_NUMBER_TABLE
26     , p3_a1 out nocopy JTF_NUMBER_TABLE
27     , p3_a2 out nocopy JTF_NUMBER_TABLE
28     , p3_a3 out nocopy JTF_NUMBER_TABLE
29     , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
30     , p3_a5 out nocopy JTF_VARCHAR2_TABLE_200
31     , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100
32     , p3_a7 out nocopy JTF_VARCHAR2_TABLE_200
33     , x_return_status out nocopy  VARCHAR2
34     , x_msg_count out nocopy  NUMBER
35     , x_msg_data out nocopy  VARCHAR2
36   );
37   procedure store_leaseapp_datapoints(p_api_version  NUMBER
38     , p_init_msg_list  VARCHAR2
39     , p2_a0 JTF_NUMBER_TABLE
40     , p2_a1 JTF_NUMBER_TABLE
41     , p2_a2 JTF_NUMBER_TABLE
42     , p2_a3 JTF_NUMBER_TABLE
43     , p2_a4 JTF_VARCHAR2_TABLE_100
44     , p2_a5 JTF_VARCHAR2_TABLE_200
45     , p2_a6 JTF_VARCHAR2_TABLE_100
46     , p2_a7 JTF_VARCHAR2_TABLE_200
47     , x_return_status out nocopy  VARCHAR2
48     , x_msg_count out nocopy  NUMBER
49     , x_msg_data out nocopy  VARCHAR2
50   );
51   procedure leaseapp_datapoints_exists(p_leaseapp_id  NUMBER
52     , ddrosetta_retval_bool OUT NOCOPY NUMBER
53   );
54 end okl_credit_datapoints_pvt_w;