DBA Data[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;