DBA Data[Home] [Help]

PACKAGE: APPS.JTF_CAL_AVLBLTY_PVT_W

Source


1 package jtf_cal_avlblty_pvt_w AUTHID CURRENT_USER as
2   /* $Header: jtfwavs.pls 120.2 2006/04/27 23:25 deeprao ship $ */
3   procedure rosetta_table_copy_in_p1(t out nocopy jtf_cal_avlblty_pvt.rstab, a0 JTF_NUMBER_TABLE
4     , a1 JTF_VARCHAR2_TABLE_100
5     , a2 JTF_VARCHAR2_TABLE_400
6     );
7   procedure rosetta_table_copy_out_p1(t jtf_cal_avlblty_pvt.rstab, a0 out nocopy JTF_NUMBER_TABLE
8     , a1 out nocopy JTF_VARCHAR2_TABLE_100
9     , a2 out nocopy JTF_VARCHAR2_TABLE_400
10     );
11 
12   procedure rosetta_table_copy_in_p3(t out nocopy jtf_cal_avlblty_pvt.avlbltb, a0 JTF_NUMBER_TABLE
13     , a1 JTF_VARCHAR2_TABLE_100
14     , a2 JTF_VARCHAR2_TABLE_400
15     , a3 JTF_NUMBER_TABLE
16     , a4 JTF_NUMBER_TABLE
17     );
18   procedure rosetta_table_copy_out_p3(t jtf_cal_avlblty_pvt.avlbltb, a0 out nocopy JTF_NUMBER_TABLE
19     , a1 out nocopy JTF_VARCHAR2_TABLE_100
20     , a2 out nocopy JTF_VARCHAR2_TABLE_400
21     , a3 out nocopy JTF_NUMBER_TABLE
22     , a4 out nocopy JTF_NUMBER_TABLE
23     );
24 
25   procedure availability(p_api_version  NUMBER
26     , p_init_msg_list  VARCHAR2
27     , x_return_status out nocopy  VARCHAR2
28     , x_msg_count out nocopy  NUMBER
29     , x_msg_data out nocopy  VARCHAR2
30     , p5_a0 JTF_NUMBER_TABLE
31     , p5_a1 JTF_VARCHAR2_TABLE_100
32     , p5_a2 JTF_VARCHAR2_TABLE_400
33     , p_startdatetime  date
34     , p_enddatetime  date
35     , p_slotsize  NUMBER
36     , x_numberofslots out nocopy  NUMBER
37     , p10_a0 out nocopy JTF_NUMBER_TABLE
38     , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
39     , p10_a2 out nocopy JTF_VARCHAR2_TABLE_400
40     , p10_a3 out nocopy JTF_NUMBER_TABLE
41     , p10_a4 out nocopy JTF_NUMBER_TABLE
42     , p11_a0 out nocopy JTF_NUMBER_TABLE
43     , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
44     , p11_a2 out nocopy JTF_VARCHAR2_TABLE_400
45     , p11_a3 out nocopy JTF_NUMBER_TABLE
46     , p11_a4 out nocopy JTF_NUMBER_TABLE
47   );
48 end jtf_cal_avlblty_pvt_w;