DBA Data[Home] [Help]

PACKAGE: APPS.OKL_TERMS_AND_CONDS_PVT_W

Source


1 package okl_terms_and_conds_pvt_w as
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
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
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     );
27 
28   procedure get_terms_conditions(p_api_version  NUMBER
29     , p_init_msg_list  VARCHAR2
30     , x_return_status out nocopy  VARCHAR2
31     , x_msg_count out nocopy  NUMBER
32     , x_msg_data out nocopy  VARCHAR2
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
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;