PACKAGE: APPS.CN_SEAS_SCHEDULES_PVT_W

Source

1 package cn_seas_schedules_pvt_w AUTHID CURRENT_USER as
2   /* $Header: cnwsschs.pls 115.4 2002/11/25 22:32:15 nkodkani ship $ */
3   procedure rosetta_table_copy_in_p1(t out nocopy cn_seas_schedules_pvt.seas_schedules_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_VARCHAR2_TABLE_100
5     , a2 JTF_VARCHAR2_TABLE_100
6     , a3 JTF_NUMBER_TABLE
7     , a4 JTF_DATE_TABLE
8     , a5 JTF_DATE_TABLE
9     , a6 JTF_VARCHAR2_TABLE_100
10     , a7 JTF_NUMBER_TABLE
11     );
12   procedure rosetta_table_copy_out_p1(t cn_seas_schedules_pvt.seas_schedules_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
13     , a1 out nocopy JTF_VARCHAR2_TABLE_100
14     , a2 out nocopy JTF_VARCHAR2_TABLE_100
15     , a3 out nocopy JTF_NUMBER_TABLE
16     , a4 out nocopy JTF_DATE_TABLE
17     , a5 out nocopy JTF_DATE_TABLE
18     , a6 out nocopy JTF_VARCHAR2_TABLE_100
19     , a7 out nocopy JTF_NUMBER_TABLE
20     );
21 
22   procedure create_seas_schedule(p_api_version  NUMBER
23     , p_init_msg_list  VARCHAR2
24     , p_commit  VARCHAR2
25     , p_validation_level  NUMBER
26     , p4_a0  NUMBER
27     , p4_a1  VARCHAR2
28     , p4_a2  VARCHAR2
29     , p4_a3  NUMBER
30     , p4_a4  DATE
31     , p4_a5  DATE
32     , p4_a6  VARCHAR2
33     , p4_a7  NUMBER
34     , x_seas_schedule_id out nocopy  NUMBER
35     , x_return_status out nocopy  VARCHAR2
36     , x_msg_count out nocopy  NUMBER
37     , x_msg_data out nocopy  VARCHAR2
38   );
39   procedure update_seas_schedule(p_api_version  NUMBER
40     , p_init_msg_list  VARCHAR2
41     , p_commit  VARCHAR2
42     , p_validation_level  NUMBER
43     , p4_a0  NUMBER
44     , p4_a1  VARCHAR2
45     , p4_a2  VARCHAR2
46     , p4_a3  NUMBER
47     , p4_a4  DATE
48     , p4_a5  DATE
49     , p4_a6  VARCHAR2
50     , p4_a7  NUMBER
51     , x_return_status out nocopy  VARCHAR2
52     , x_msg_count out nocopy  NUMBER
53     , x_msg_data out nocopy  VARCHAR2
54   );
55 end cn_seas_schedules_pvt_w;