[Home] [Help]
PACKAGE: APPS.CN_SEAS_SCHEDULES_PKG
Source
1 PACKAGE CN_SEAS_SCHEDULES_pkg AUTHID CURRENT_USER AS
2 /*$Header: cntsschs.pls 115.3 2002/01/28 20:06:24 pkm ship $*/
3
4 PROCEDURE insert_row
5 (P_SEAS_SCHEDULE_ID IN cn_seas_schedules.SEAS_SCHEDULE_ID%TYPE,
6 P_NAME IN cn_seas_schedules.NAME%TYPE,
7 P_DESCRIPTION IN cn_seas_schedules.DESCRIPTION%TYPE := NULL,
8 P_PERIOD_YEAR IN cn_seas_schedules.PERIOD_YEAR%TYPE,
9 P_START_DATE IN cn_seas_schedules.START_DATE%TYPE,
10 P_END_DATE IN cn_seas_schedules.END_DATE%TYPE,
11 P_VALIDATION_STATUS IN cn_seas_schedules.VALIDATION_STATUS%TYPE,
12 p_attribute_category IN cn_seas_schedules.attribute_category%TYPE := NULL,
13 p_attribute1 IN cn_seas_schedules.attribute1%TYPE := NULL,
14 p_attribute2 IN cn_seas_schedules.attribute2%TYPE := NULL,
15 p_attribute3 IN cn_seas_schedules.attribute3%TYPE := NULL,
16 p_attribute4 IN cn_seas_schedules.attribute4%TYPE := NULL,
17 p_attribute5 IN cn_seas_schedules.attribute5%TYPE := NULL,
18 p_attribute6 IN cn_seas_schedules.attribute6%TYPE := NULL,
19 p_attribute7 IN cn_seas_schedules.attribute7%TYPE := NULL,
20 p_attribute8 IN cn_seas_schedules.attribute8%TYPE := NULL,
21 p_attribute9 IN cn_seas_schedules.attribute9%TYPE := NULL,
22 p_attribute10 IN cn_seas_schedules.attribute10%TYPE := NULL,
23 p_attribute11 IN cn_seas_schedules.attribute11%TYPE := NULL,
24 p_attribute12 IN cn_seas_schedules.attribute12%TYPE := NULL,
25 p_attribute13 IN cn_seas_schedules.attribute13%TYPE := NULL,
26 p_attribute14 IN cn_seas_schedules.attribute14%TYPE := NULL,
27 p_attribute15 IN cn_seas_schedules.attribute15%TYPE := NULL,
28 p_created_by IN cn_seas_schedules.created_by%TYPE := NULL,
29 p_creation_date IN cn_seas_schedules.creation_date%TYPE := NULL,
30 p_last_update_login IN cn_seas_schedules.last_update_login%TYPE := NULL,
31 p_last_update_date IN cn_seas_schedules.last_update_date%TYPE := NULL,
32 p_last_updated_by IN cn_seas_schedules.last_updated_by%TYPE := NULL,
33 p_OBJECT_VERSION_NUMBER IN cn_seas_schedules.OBJECT_VERSION_NUMBER%TYPE := NULL);
34
35 PROCEDURE update_row
36 (P_SEAS_SCHEDULE_ID IN cn_seas_schedules.SEAS_SCHEDULE_ID%TYPE,
37 P_NAME IN cn_seas_schedules.NAME%TYPE,
38 P_DESCRIPTION IN cn_seas_schedules.DESCRIPTION%TYPE := NULL,
39 P_PERIOD_YEAR IN cn_seas_schedules.PERIOD_YEAR%TYPE,
40 P_START_DATE IN cn_seas_schedules.START_DATE%TYPE,
41 P_END_DATE IN cn_seas_schedules.END_DATE%TYPE,
42 P_VALIDATION_STATUS IN cn_seas_schedules.VALIDATION_STATUS%TYPE,
43 p_attribute_category IN cn_seas_schedules.attribute_category%TYPE := NULL,
44 p_attribute1 IN cn_seas_schedules.attribute1%TYPE := NULL,
45 p_attribute2 IN cn_seas_schedules.attribute2%TYPE := NULL,
46 p_attribute3 IN cn_seas_schedules.attribute3%TYPE := NULL,
47 p_attribute4 IN cn_seas_schedules.attribute4%TYPE := NULL,
48 p_attribute5 IN cn_seas_schedules.attribute5%TYPE := NULL,
49 p_attribute6 IN cn_seas_schedules.attribute6%TYPE := NULL,
50 p_attribute7 IN cn_seas_schedules.attribute7%TYPE := NULL,
51 p_attribute8 IN cn_seas_schedules.attribute8%TYPE := NULL,
52 p_attribute9 IN cn_seas_schedules.attribute9%TYPE := NULL,
53 p_attribute10 IN cn_seas_schedules.attribute10%TYPE := NULL,
54 p_attribute11 IN cn_seas_schedules.attribute11%TYPE := NULL,
55 p_attribute12 IN cn_seas_schedules.attribute12%TYPE := NULL,
56 p_attribute13 IN cn_seas_schedules.attribute13%TYPE := NULL,
57 p_attribute14 IN cn_seas_schedules.attribute14%TYPE := NULL,
58 p_attribute15 IN cn_seas_schedules.attribute15%TYPE := NULL,
59 p_last_update_login IN cn_seas_schedules.last_update_login%TYPE := NULL,
60 p_last_update_date IN cn_seas_schedules.last_update_date%TYPE := NULL,
61 p_last_updated_by IN cn_seas_schedules.last_updated_by%TYPE := NULL,
62 p_object_version_number IN cn_seas_schedules.object_version_number%TYPE);
63
64 PROCEDURE delete_row
65 (P_SEAS_SCHEDULE_ID IN cn_seas_schedules.SEAS_SCHEDULE_ID%TYPE);
66
67 END cn_seas_schedules_pkg;