1: PACKAGE CN_SEASONALITIES_pkg AUTHID CURRENT_USER AS
2: /*$Header: cntseass.pls 115.3 2002/01/28 20:06:03 pkm ship $*/
3:
4: PROCEDURE insert_row
5: (P_SEASONALITY_ID IN cn_seasonalities.SEASONALITY_ID%TYPE,
1: PACKAGE CN_SEASONALITIES_pkg AUTHID CURRENT_USER AS
2: /*$Header: cntseass.pls 115.3 2002/01/28 20:06:03 pkm ship $*/
3:
4: PROCEDURE insert_row
5: (P_SEASONALITY_ID IN cn_seasonalities.SEASONALITY_ID%TYPE,
6: P_SEAS_SCHEDULE_ID IN cn_seasonalities.SEAS_SCHEDULE_ID%TYPE,
7: P_CAL_PER_INT_TYPE_ID IN cn_seasonalities.CAL_PER_INT_TYPE_ID%TYPE,
8: P_PERIOD_ID IN cn_seasonalities.PERIOD_ID%TYPE,
9: P_PCT_SEASONALITY IN cn_seasonalities.PCT_SEASONALITY%TYPE,
2: /*$Header: cntseass.pls 115.3 2002/01/28 20:06:03 pkm ship $*/
3:
4: PROCEDURE insert_row
5: (P_SEASONALITY_ID IN cn_seasonalities.SEASONALITY_ID%TYPE,
6: P_SEAS_SCHEDULE_ID IN cn_seasonalities.SEAS_SCHEDULE_ID%TYPE,
7: P_CAL_PER_INT_TYPE_ID IN cn_seasonalities.CAL_PER_INT_TYPE_ID%TYPE,
8: P_PERIOD_ID IN cn_seasonalities.PERIOD_ID%TYPE,
9: P_PCT_SEASONALITY IN cn_seasonalities.PCT_SEASONALITY%TYPE,
10: p_attribute_category IN cn_seasonalities.attribute_category%TYPE := NULL,
3:
4: PROCEDURE insert_row
5: (P_SEASONALITY_ID IN cn_seasonalities.SEASONALITY_ID%TYPE,
6: P_SEAS_SCHEDULE_ID IN cn_seasonalities.SEAS_SCHEDULE_ID%TYPE,
7: P_CAL_PER_INT_TYPE_ID IN cn_seasonalities.CAL_PER_INT_TYPE_ID%TYPE,
8: P_PERIOD_ID IN cn_seasonalities.PERIOD_ID%TYPE,
9: P_PCT_SEASONALITY IN cn_seasonalities.PCT_SEASONALITY%TYPE,
10: p_attribute_category IN cn_seasonalities.attribute_category%TYPE := NULL,
11: p_attribute1 IN cn_seasonalities.attribute1%TYPE := NULL,
4: PROCEDURE insert_row
5: (P_SEASONALITY_ID IN cn_seasonalities.SEASONALITY_ID%TYPE,
6: P_SEAS_SCHEDULE_ID IN cn_seasonalities.SEAS_SCHEDULE_ID%TYPE,
7: P_CAL_PER_INT_TYPE_ID IN cn_seasonalities.CAL_PER_INT_TYPE_ID%TYPE,
8: P_PERIOD_ID IN cn_seasonalities.PERIOD_ID%TYPE,
9: P_PCT_SEASONALITY IN cn_seasonalities.PCT_SEASONALITY%TYPE,
10: p_attribute_category IN cn_seasonalities.attribute_category%TYPE := NULL,
11: p_attribute1 IN cn_seasonalities.attribute1%TYPE := NULL,
12: p_attribute2 IN cn_seasonalities.attribute2%TYPE := NULL,
5: (P_SEASONALITY_ID IN cn_seasonalities.SEASONALITY_ID%TYPE,
6: P_SEAS_SCHEDULE_ID IN cn_seasonalities.SEAS_SCHEDULE_ID%TYPE,
7: P_CAL_PER_INT_TYPE_ID IN cn_seasonalities.CAL_PER_INT_TYPE_ID%TYPE,
8: P_PERIOD_ID IN cn_seasonalities.PERIOD_ID%TYPE,
9: P_PCT_SEASONALITY IN cn_seasonalities.PCT_SEASONALITY%TYPE,
10: p_attribute_category IN cn_seasonalities.attribute_category%TYPE := NULL,
11: p_attribute1 IN cn_seasonalities.attribute1%TYPE := NULL,
12: p_attribute2 IN cn_seasonalities.attribute2%TYPE := NULL,
13: p_attribute3 IN cn_seasonalities.attribute3%TYPE := NULL,
6: P_SEAS_SCHEDULE_ID IN cn_seasonalities.SEAS_SCHEDULE_ID%TYPE,
7: P_CAL_PER_INT_TYPE_ID IN cn_seasonalities.CAL_PER_INT_TYPE_ID%TYPE,
8: P_PERIOD_ID IN cn_seasonalities.PERIOD_ID%TYPE,
9: P_PCT_SEASONALITY IN cn_seasonalities.PCT_SEASONALITY%TYPE,
10: p_attribute_category IN cn_seasonalities.attribute_category%TYPE := NULL,
11: p_attribute1 IN cn_seasonalities.attribute1%TYPE := NULL,
12: p_attribute2 IN cn_seasonalities.attribute2%TYPE := NULL,
13: p_attribute3 IN cn_seasonalities.attribute3%TYPE := NULL,
14: p_attribute4 IN cn_seasonalities.attribute4%TYPE := NULL,
7: P_CAL_PER_INT_TYPE_ID IN cn_seasonalities.CAL_PER_INT_TYPE_ID%TYPE,
8: P_PERIOD_ID IN cn_seasonalities.PERIOD_ID%TYPE,
9: P_PCT_SEASONALITY IN cn_seasonalities.PCT_SEASONALITY%TYPE,
10: p_attribute_category IN cn_seasonalities.attribute_category%TYPE := NULL,
11: p_attribute1 IN cn_seasonalities.attribute1%TYPE := NULL,
12: p_attribute2 IN cn_seasonalities.attribute2%TYPE := NULL,
13: p_attribute3 IN cn_seasonalities.attribute3%TYPE := NULL,
14: p_attribute4 IN cn_seasonalities.attribute4%TYPE := NULL,
15: p_attribute5 IN cn_seasonalities.attribute5%TYPE := NULL,
8: P_PERIOD_ID IN cn_seasonalities.PERIOD_ID%TYPE,
9: P_PCT_SEASONALITY IN cn_seasonalities.PCT_SEASONALITY%TYPE,
10: p_attribute_category IN cn_seasonalities.attribute_category%TYPE := NULL,
11: p_attribute1 IN cn_seasonalities.attribute1%TYPE := NULL,
12: p_attribute2 IN cn_seasonalities.attribute2%TYPE := NULL,
13: p_attribute3 IN cn_seasonalities.attribute3%TYPE := NULL,
14: p_attribute4 IN cn_seasonalities.attribute4%TYPE := NULL,
15: p_attribute5 IN cn_seasonalities.attribute5%TYPE := NULL,
16: p_attribute6 IN cn_seasonalities.attribute6%TYPE := NULL,
9: P_PCT_SEASONALITY IN cn_seasonalities.PCT_SEASONALITY%TYPE,
10: p_attribute_category IN cn_seasonalities.attribute_category%TYPE := NULL,
11: p_attribute1 IN cn_seasonalities.attribute1%TYPE := NULL,
12: p_attribute2 IN cn_seasonalities.attribute2%TYPE := NULL,
13: p_attribute3 IN cn_seasonalities.attribute3%TYPE := NULL,
14: p_attribute4 IN cn_seasonalities.attribute4%TYPE := NULL,
15: p_attribute5 IN cn_seasonalities.attribute5%TYPE := NULL,
16: p_attribute6 IN cn_seasonalities.attribute6%TYPE := NULL,
17: p_attribute7 IN cn_seasonalities.attribute7%TYPE := NULL,
10: p_attribute_category IN cn_seasonalities.attribute_category%TYPE := NULL,
11: p_attribute1 IN cn_seasonalities.attribute1%TYPE := NULL,
12: p_attribute2 IN cn_seasonalities.attribute2%TYPE := NULL,
13: p_attribute3 IN cn_seasonalities.attribute3%TYPE := NULL,
14: p_attribute4 IN cn_seasonalities.attribute4%TYPE := NULL,
15: p_attribute5 IN cn_seasonalities.attribute5%TYPE := NULL,
16: p_attribute6 IN cn_seasonalities.attribute6%TYPE := NULL,
17: p_attribute7 IN cn_seasonalities.attribute7%TYPE := NULL,
18: p_attribute8 IN cn_seasonalities.attribute8%TYPE := NULL,
11: p_attribute1 IN cn_seasonalities.attribute1%TYPE := NULL,
12: p_attribute2 IN cn_seasonalities.attribute2%TYPE := NULL,
13: p_attribute3 IN cn_seasonalities.attribute3%TYPE := NULL,
14: p_attribute4 IN cn_seasonalities.attribute4%TYPE := NULL,
15: p_attribute5 IN cn_seasonalities.attribute5%TYPE := NULL,
16: p_attribute6 IN cn_seasonalities.attribute6%TYPE := NULL,
17: p_attribute7 IN cn_seasonalities.attribute7%TYPE := NULL,
18: p_attribute8 IN cn_seasonalities.attribute8%TYPE := NULL,
19: p_attribute9 IN cn_seasonalities.attribute9%TYPE := NULL,
12: p_attribute2 IN cn_seasonalities.attribute2%TYPE := NULL,
13: p_attribute3 IN cn_seasonalities.attribute3%TYPE := NULL,
14: p_attribute4 IN cn_seasonalities.attribute4%TYPE := NULL,
15: p_attribute5 IN cn_seasonalities.attribute5%TYPE := NULL,
16: p_attribute6 IN cn_seasonalities.attribute6%TYPE := NULL,
17: p_attribute7 IN cn_seasonalities.attribute7%TYPE := NULL,
18: p_attribute8 IN cn_seasonalities.attribute8%TYPE := NULL,
19: p_attribute9 IN cn_seasonalities.attribute9%TYPE := NULL,
20: p_attribute10 IN cn_seasonalities.attribute10%TYPE := NULL,
13: p_attribute3 IN cn_seasonalities.attribute3%TYPE := NULL,
14: p_attribute4 IN cn_seasonalities.attribute4%TYPE := NULL,
15: p_attribute5 IN cn_seasonalities.attribute5%TYPE := NULL,
16: p_attribute6 IN cn_seasonalities.attribute6%TYPE := NULL,
17: p_attribute7 IN cn_seasonalities.attribute7%TYPE := NULL,
18: p_attribute8 IN cn_seasonalities.attribute8%TYPE := NULL,
19: p_attribute9 IN cn_seasonalities.attribute9%TYPE := NULL,
20: p_attribute10 IN cn_seasonalities.attribute10%TYPE := NULL,
21: p_attribute11 IN cn_seasonalities.attribute11%TYPE := NULL,
14: p_attribute4 IN cn_seasonalities.attribute4%TYPE := NULL,
15: p_attribute5 IN cn_seasonalities.attribute5%TYPE := NULL,
16: p_attribute6 IN cn_seasonalities.attribute6%TYPE := NULL,
17: p_attribute7 IN cn_seasonalities.attribute7%TYPE := NULL,
18: p_attribute8 IN cn_seasonalities.attribute8%TYPE := NULL,
19: p_attribute9 IN cn_seasonalities.attribute9%TYPE := NULL,
20: p_attribute10 IN cn_seasonalities.attribute10%TYPE := NULL,
21: p_attribute11 IN cn_seasonalities.attribute11%TYPE := NULL,
22: p_attribute12 IN cn_seasonalities.attribute12%TYPE := NULL,
15: p_attribute5 IN cn_seasonalities.attribute5%TYPE := NULL,
16: p_attribute6 IN cn_seasonalities.attribute6%TYPE := NULL,
17: p_attribute7 IN cn_seasonalities.attribute7%TYPE := NULL,
18: p_attribute8 IN cn_seasonalities.attribute8%TYPE := NULL,
19: p_attribute9 IN cn_seasonalities.attribute9%TYPE := NULL,
20: p_attribute10 IN cn_seasonalities.attribute10%TYPE := NULL,
21: p_attribute11 IN cn_seasonalities.attribute11%TYPE := NULL,
22: p_attribute12 IN cn_seasonalities.attribute12%TYPE := NULL,
23: p_attribute13 IN cn_seasonalities.attribute13%TYPE := NULL,
16: p_attribute6 IN cn_seasonalities.attribute6%TYPE := NULL,
17: p_attribute7 IN cn_seasonalities.attribute7%TYPE := NULL,
18: p_attribute8 IN cn_seasonalities.attribute8%TYPE := NULL,
19: p_attribute9 IN cn_seasonalities.attribute9%TYPE := NULL,
20: p_attribute10 IN cn_seasonalities.attribute10%TYPE := NULL,
21: p_attribute11 IN cn_seasonalities.attribute11%TYPE := NULL,
22: p_attribute12 IN cn_seasonalities.attribute12%TYPE := NULL,
23: p_attribute13 IN cn_seasonalities.attribute13%TYPE := NULL,
24: p_attribute14 IN cn_seasonalities.attribute14%TYPE := NULL,
17: p_attribute7 IN cn_seasonalities.attribute7%TYPE := NULL,
18: p_attribute8 IN cn_seasonalities.attribute8%TYPE := NULL,
19: p_attribute9 IN cn_seasonalities.attribute9%TYPE := NULL,
20: p_attribute10 IN cn_seasonalities.attribute10%TYPE := NULL,
21: p_attribute11 IN cn_seasonalities.attribute11%TYPE := NULL,
22: p_attribute12 IN cn_seasonalities.attribute12%TYPE := NULL,
23: p_attribute13 IN cn_seasonalities.attribute13%TYPE := NULL,
24: p_attribute14 IN cn_seasonalities.attribute14%TYPE := NULL,
25: p_attribute15 IN cn_seasonalities.attribute15%TYPE := NULL,
18: p_attribute8 IN cn_seasonalities.attribute8%TYPE := NULL,
19: p_attribute9 IN cn_seasonalities.attribute9%TYPE := NULL,
20: p_attribute10 IN cn_seasonalities.attribute10%TYPE := NULL,
21: p_attribute11 IN cn_seasonalities.attribute11%TYPE := NULL,
22: p_attribute12 IN cn_seasonalities.attribute12%TYPE := NULL,
23: p_attribute13 IN cn_seasonalities.attribute13%TYPE := NULL,
24: p_attribute14 IN cn_seasonalities.attribute14%TYPE := NULL,
25: p_attribute15 IN cn_seasonalities.attribute15%TYPE := NULL,
26: p_created_by IN cn_seasonalities.created_by%TYPE := NULL,
19: p_attribute9 IN cn_seasonalities.attribute9%TYPE := NULL,
20: p_attribute10 IN cn_seasonalities.attribute10%TYPE := NULL,
21: p_attribute11 IN cn_seasonalities.attribute11%TYPE := NULL,
22: p_attribute12 IN cn_seasonalities.attribute12%TYPE := NULL,
23: p_attribute13 IN cn_seasonalities.attribute13%TYPE := NULL,
24: p_attribute14 IN cn_seasonalities.attribute14%TYPE := NULL,
25: p_attribute15 IN cn_seasonalities.attribute15%TYPE := NULL,
26: p_created_by IN cn_seasonalities.created_by%TYPE := NULL,
27: p_creation_date IN cn_seasonalities.creation_date%TYPE := NULL,
20: p_attribute10 IN cn_seasonalities.attribute10%TYPE := NULL,
21: p_attribute11 IN cn_seasonalities.attribute11%TYPE := NULL,
22: p_attribute12 IN cn_seasonalities.attribute12%TYPE := NULL,
23: p_attribute13 IN cn_seasonalities.attribute13%TYPE := NULL,
24: p_attribute14 IN cn_seasonalities.attribute14%TYPE := NULL,
25: p_attribute15 IN cn_seasonalities.attribute15%TYPE := NULL,
26: p_created_by IN cn_seasonalities.created_by%TYPE := NULL,
27: p_creation_date IN cn_seasonalities.creation_date%TYPE := NULL,
28: p_last_update_login IN cn_seasonalities.last_update_login%TYPE := NULL,
21: p_attribute11 IN cn_seasonalities.attribute11%TYPE := NULL,
22: p_attribute12 IN cn_seasonalities.attribute12%TYPE := NULL,
23: p_attribute13 IN cn_seasonalities.attribute13%TYPE := NULL,
24: p_attribute14 IN cn_seasonalities.attribute14%TYPE := NULL,
25: p_attribute15 IN cn_seasonalities.attribute15%TYPE := NULL,
26: p_created_by IN cn_seasonalities.created_by%TYPE := NULL,
27: p_creation_date IN cn_seasonalities.creation_date%TYPE := NULL,
28: p_last_update_login IN cn_seasonalities.last_update_login%TYPE := NULL,
29: p_last_update_date IN cn_seasonalities.last_update_date%TYPE := NULL,
22: p_attribute12 IN cn_seasonalities.attribute12%TYPE := NULL,
23: p_attribute13 IN cn_seasonalities.attribute13%TYPE := NULL,
24: p_attribute14 IN cn_seasonalities.attribute14%TYPE := NULL,
25: p_attribute15 IN cn_seasonalities.attribute15%TYPE := NULL,
26: p_created_by IN cn_seasonalities.created_by%TYPE := NULL,
27: p_creation_date IN cn_seasonalities.creation_date%TYPE := NULL,
28: p_last_update_login IN cn_seasonalities.last_update_login%TYPE := NULL,
29: p_last_update_date IN cn_seasonalities.last_update_date%TYPE := NULL,
30: p_last_updated_by IN cn_seasonalities.last_updated_by%TYPE := NULL,
23: p_attribute13 IN cn_seasonalities.attribute13%TYPE := NULL,
24: p_attribute14 IN cn_seasonalities.attribute14%TYPE := NULL,
25: p_attribute15 IN cn_seasonalities.attribute15%TYPE := NULL,
26: p_created_by IN cn_seasonalities.created_by%TYPE := NULL,
27: p_creation_date IN cn_seasonalities.creation_date%TYPE := NULL,
28: p_last_update_login IN cn_seasonalities.last_update_login%TYPE := NULL,
29: p_last_update_date IN cn_seasonalities.last_update_date%TYPE := NULL,
30: p_last_updated_by IN cn_seasonalities.last_updated_by%TYPE := NULL,
31: p_OBJECT_VERSION_NUMBER IN cn_seasonalities.OBJECT_VERSION_NUMBER%TYPE := NULL);
24: p_attribute14 IN cn_seasonalities.attribute14%TYPE := NULL,
25: p_attribute15 IN cn_seasonalities.attribute15%TYPE := NULL,
26: p_created_by IN cn_seasonalities.created_by%TYPE := NULL,
27: p_creation_date IN cn_seasonalities.creation_date%TYPE := NULL,
28: p_last_update_login IN cn_seasonalities.last_update_login%TYPE := NULL,
29: p_last_update_date IN cn_seasonalities.last_update_date%TYPE := NULL,
30: p_last_updated_by IN cn_seasonalities.last_updated_by%TYPE := NULL,
31: p_OBJECT_VERSION_NUMBER IN cn_seasonalities.OBJECT_VERSION_NUMBER%TYPE := NULL);
32:
25: p_attribute15 IN cn_seasonalities.attribute15%TYPE := NULL,
26: p_created_by IN cn_seasonalities.created_by%TYPE := NULL,
27: p_creation_date IN cn_seasonalities.creation_date%TYPE := NULL,
28: p_last_update_login IN cn_seasonalities.last_update_login%TYPE := NULL,
29: p_last_update_date IN cn_seasonalities.last_update_date%TYPE := NULL,
30: p_last_updated_by IN cn_seasonalities.last_updated_by%TYPE := NULL,
31: p_OBJECT_VERSION_NUMBER IN cn_seasonalities.OBJECT_VERSION_NUMBER%TYPE := NULL);
32:
33: PROCEDURE update_row
26: p_created_by IN cn_seasonalities.created_by%TYPE := NULL,
27: p_creation_date IN cn_seasonalities.creation_date%TYPE := NULL,
28: p_last_update_login IN cn_seasonalities.last_update_login%TYPE := NULL,
29: p_last_update_date IN cn_seasonalities.last_update_date%TYPE := NULL,
30: p_last_updated_by IN cn_seasonalities.last_updated_by%TYPE := NULL,
31: p_OBJECT_VERSION_NUMBER IN cn_seasonalities.OBJECT_VERSION_NUMBER%TYPE := NULL);
32:
33: PROCEDURE update_row
34: (P_SEASONALITY_ID IN cn_seasonalities.SEASONALITY_ID%TYPE,
27: p_creation_date IN cn_seasonalities.creation_date%TYPE := NULL,
28: p_last_update_login IN cn_seasonalities.last_update_login%TYPE := NULL,
29: p_last_update_date IN cn_seasonalities.last_update_date%TYPE := NULL,
30: p_last_updated_by IN cn_seasonalities.last_updated_by%TYPE := NULL,
31: p_OBJECT_VERSION_NUMBER IN cn_seasonalities.OBJECT_VERSION_NUMBER%TYPE := NULL);
32:
33: PROCEDURE update_row
34: (P_SEASONALITY_ID IN cn_seasonalities.SEASONALITY_ID%TYPE,
35: P_SEAS_SCHEDULE_ID IN cn_seasonalities.SEAS_SCHEDULE_ID%TYPE,
30: p_last_updated_by IN cn_seasonalities.last_updated_by%TYPE := NULL,
31: p_OBJECT_VERSION_NUMBER IN cn_seasonalities.OBJECT_VERSION_NUMBER%TYPE := NULL);
32:
33: PROCEDURE update_row
34: (P_SEASONALITY_ID IN cn_seasonalities.SEASONALITY_ID%TYPE,
35: P_SEAS_SCHEDULE_ID IN cn_seasonalities.SEAS_SCHEDULE_ID%TYPE,
36: P_CAL_PER_INT_TYPE_ID IN cn_seasonalities.CAL_PER_INT_TYPE_ID%TYPE,
37: P_PERIOD_ID IN cn_seasonalities.PERIOD_ID%TYPE,
38: P_PCT_SEASONALITY IN cn_seasonalities.PCT_SEASONALITY%TYPE,
31: p_OBJECT_VERSION_NUMBER IN cn_seasonalities.OBJECT_VERSION_NUMBER%TYPE := NULL);
32:
33: PROCEDURE update_row
34: (P_SEASONALITY_ID IN cn_seasonalities.SEASONALITY_ID%TYPE,
35: P_SEAS_SCHEDULE_ID IN cn_seasonalities.SEAS_SCHEDULE_ID%TYPE,
36: P_CAL_PER_INT_TYPE_ID IN cn_seasonalities.CAL_PER_INT_TYPE_ID%TYPE,
37: P_PERIOD_ID IN cn_seasonalities.PERIOD_ID%TYPE,
38: P_PCT_SEASONALITY IN cn_seasonalities.PCT_SEASONALITY%TYPE,
39: p_attribute_category IN cn_seasonalities.attribute_category%TYPE := NULL,
32:
33: PROCEDURE update_row
34: (P_SEASONALITY_ID IN cn_seasonalities.SEASONALITY_ID%TYPE,
35: P_SEAS_SCHEDULE_ID IN cn_seasonalities.SEAS_SCHEDULE_ID%TYPE,
36: P_CAL_PER_INT_TYPE_ID IN cn_seasonalities.CAL_PER_INT_TYPE_ID%TYPE,
37: P_PERIOD_ID IN cn_seasonalities.PERIOD_ID%TYPE,
38: P_PCT_SEASONALITY IN cn_seasonalities.PCT_SEASONALITY%TYPE,
39: p_attribute_category IN cn_seasonalities.attribute_category%TYPE := NULL,
40: p_attribute1 IN cn_seasonalities.attribute1%TYPE := NULL,
33: PROCEDURE update_row
34: (P_SEASONALITY_ID IN cn_seasonalities.SEASONALITY_ID%TYPE,
35: P_SEAS_SCHEDULE_ID IN cn_seasonalities.SEAS_SCHEDULE_ID%TYPE,
36: P_CAL_PER_INT_TYPE_ID IN cn_seasonalities.CAL_PER_INT_TYPE_ID%TYPE,
37: P_PERIOD_ID IN cn_seasonalities.PERIOD_ID%TYPE,
38: P_PCT_SEASONALITY IN cn_seasonalities.PCT_SEASONALITY%TYPE,
39: p_attribute_category IN cn_seasonalities.attribute_category%TYPE := NULL,
40: p_attribute1 IN cn_seasonalities.attribute1%TYPE := NULL,
41: p_attribute2 IN cn_seasonalities.attribute2%TYPE := NULL,
34: (P_SEASONALITY_ID IN cn_seasonalities.SEASONALITY_ID%TYPE,
35: P_SEAS_SCHEDULE_ID IN cn_seasonalities.SEAS_SCHEDULE_ID%TYPE,
36: P_CAL_PER_INT_TYPE_ID IN cn_seasonalities.CAL_PER_INT_TYPE_ID%TYPE,
37: P_PERIOD_ID IN cn_seasonalities.PERIOD_ID%TYPE,
38: P_PCT_SEASONALITY IN cn_seasonalities.PCT_SEASONALITY%TYPE,
39: p_attribute_category IN cn_seasonalities.attribute_category%TYPE := NULL,
40: p_attribute1 IN cn_seasonalities.attribute1%TYPE := NULL,
41: p_attribute2 IN cn_seasonalities.attribute2%TYPE := NULL,
42: p_attribute3 IN cn_seasonalities.attribute3%TYPE := NULL,
35: P_SEAS_SCHEDULE_ID IN cn_seasonalities.SEAS_SCHEDULE_ID%TYPE,
36: P_CAL_PER_INT_TYPE_ID IN cn_seasonalities.CAL_PER_INT_TYPE_ID%TYPE,
37: P_PERIOD_ID IN cn_seasonalities.PERIOD_ID%TYPE,
38: P_PCT_SEASONALITY IN cn_seasonalities.PCT_SEASONALITY%TYPE,
39: p_attribute_category IN cn_seasonalities.attribute_category%TYPE := NULL,
40: p_attribute1 IN cn_seasonalities.attribute1%TYPE := NULL,
41: p_attribute2 IN cn_seasonalities.attribute2%TYPE := NULL,
42: p_attribute3 IN cn_seasonalities.attribute3%TYPE := NULL,
43: p_attribute4 IN cn_seasonalities.attribute4%TYPE := NULL,
36: P_CAL_PER_INT_TYPE_ID IN cn_seasonalities.CAL_PER_INT_TYPE_ID%TYPE,
37: P_PERIOD_ID IN cn_seasonalities.PERIOD_ID%TYPE,
38: P_PCT_SEASONALITY IN cn_seasonalities.PCT_SEASONALITY%TYPE,
39: p_attribute_category IN cn_seasonalities.attribute_category%TYPE := NULL,
40: p_attribute1 IN cn_seasonalities.attribute1%TYPE := NULL,
41: p_attribute2 IN cn_seasonalities.attribute2%TYPE := NULL,
42: p_attribute3 IN cn_seasonalities.attribute3%TYPE := NULL,
43: p_attribute4 IN cn_seasonalities.attribute4%TYPE := NULL,
44: p_attribute5 IN cn_seasonalities.attribute5%TYPE := NULL,
37: P_PERIOD_ID IN cn_seasonalities.PERIOD_ID%TYPE,
38: P_PCT_SEASONALITY IN cn_seasonalities.PCT_SEASONALITY%TYPE,
39: p_attribute_category IN cn_seasonalities.attribute_category%TYPE := NULL,
40: p_attribute1 IN cn_seasonalities.attribute1%TYPE := NULL,
41: p_attribute2 IN cn_seasonalities.attribute2%TYPE := NULL,
42: p_attribute3 IN cn_seasonalities.attribute3%TYPE := NULL,
43: p_attribute4 IN cn_seasonalities.attribute4%TYPE := NULL,
44: p_attribute5 IN cn_seasonalities.attribute5%TYPE := NULL,
45: p_attribute6 IN cn_seasonalities.attribute6%TYPE := NULL,
38: P_PCT_SEASONALITY IN cn_seasonalities.PCT_SEASONALITY%TYPE,
39: p_attribute_category IN cn_seasonalities.attribute_category%TYPE := NULL,
40: p_attribute1 IN cn_seasonalities.attribute1%TYPE := NULL,
41: p_attribute2 IN cn_seasonalities.attribute2%TYPE := NULL,
42: p_attribute3 IN cn_seasonalities.attribute3%TYPE := NULL,
43: p_attribute4 IN cn_seasonalities.attribute4%TYPE := NULL,
44: p_attribute5 IN cn_seasonalities.attribute5%TYPE := NULL,
45: p_attribute6 IN cn_seasonalities.attribute6%TYPE := NULL,
46: p_attribute7 IN cn_seasonalities.attribute7%TYPE := NULL,
39: p_attribute_category IN cn_seasonalities.attribute_category%TYPE := NULL,
40: p_attribute1 IN cn_seasonalities.attribute1%TYPE := NULL,
41: p_attribute2 IN cn_seasonalities.attribute2%TYPE := NULL,
42: p_attribute3 IN cn_seasonalities.attribute3%TYPE := NULL,
43: p_attribute4 IN cn_seasonalities.attribute4%TYPE := NULL,
44: p_attribute5 IN cn_seasonalities.attribute5%TYPE := NULL,
45: p_attribute6 IN cn_seasonalities.attribute6%TYPE := NULL,
46: p_attribute7 IN cn_seasonalities.attribute7%TYPE := NULL,
47: p_attribute8 IN cn_seasonalities.attribute8%TYPE := NULL,
40: p_attribute1 IN cn_seasonalities.attribute1%TYPE := NULL,
41: p_attribute2 IN cn_seasonalities.attribute2%TYPE := NULL,
42: p_attribute3 IN cn_seasonalities.attribute3%TYPE := NULL,
43: p_attribute4 IN cn_seasonalities.attribute4%TYPE := NULL,
44: p_attribute5 IN cn_seasonalities.attribute5%TYPE := NULL,
45: p_attribute6 IN cn_seasonalities.attribute6%TYPE := NULL,
46: p_attribute7 IN cn_seasonalities.attribute7%TYPE := NULL,
47: p_attribute8 IN cn_seasonalities.attribute8%TYPE := NULL,
48: p_attribute9 IN cn_seasonalities.attribute9%TYPE := NULL,
41: p_attribute2 IN cn_seasonalities.attribute2%TYPE := NULL,
42: p_attribute3 IN cn_seasonalities.attribute3%TYPE := NULL,
43: p_attribute4 IN cn_seasonalities.attribute4%TYPE := NULL,
44: p_attribute5 IN cn_seasonalities.attribute5%TYPE := NULL,
45: p_attribute6 IN cn_seasonalities.attribute6%TYPE := NULL,
46: p_attribute7 IN cn_seasonalities.attribute7%TYPE := NULL,
47: p_attribute8 IN cn_seasonalities.attribute8%TYPE := NULL,
48: p_attribute9 IN cn_seasonalities.attribute9%TYPE := NULL,
49: p_attribute10 IN cn_seasonalities.attribute10%TYPE := NULL,
42: p_attribute3 IN cn_seasonalities.attribute3%TYPE := NULL,
43: p_attribute4 IN cn_seasonalities.attribute4%TYPE := NULL,
44: p_attribute5 IN cn_seasonalities.attribute5%TYPE := NULL,
45: p_attribute6 IN cn_seasonalities.attribute6%TYPE := NULL,
46: p_attribute7 IN cn_seasonalities.attribute7%TYPE := NULL,
47: p_attribute8 IN cn_seasonalities.attribute8%TYPE := NULL,
48: p_attribute9 IN cn_seasonalities.attribute9%TYPE := NULL,
49: p_attribute10 IN cn_seasonalities.attribute10%TYPE := NULL,
50: p_attribute11 IN cn_seasonalities.attribute11%TYPE := NULL,
43: p_attribute4 IN cn_seasonalities.attribute4%TYPE := NULL,
44: p_attribute5 IN cn_seasonalities.attribute5%TYPE := NULL,
45: p_attribute6 IN cn_seasonalities.attribute6%TYPE := NULL,
46: p_attribute7 IN cn_seasonalities.attribute7%TYPE := NULL,
47: p_attribute8 IN cn_seasonalities.attribute8%TYPE := NULL,
48: p_attribute9 IN cn_seasonalities.attribute9%TYPE := NULL,
49: p_attribute10 IN cn_seasonalities.attribute10%TYPE := NULL,
50: p_attribute11 IN cn_seasonalities.attribute11%TYPE := NULL,
51: p_attribute12 IN cn_seasonalities.attribute12%TYPE := NULL,
44: p_attribute5 IN cn_seasonalities.attribute5%TYPE := NULL,
45: p_attribute6 IN cn_seasonalities.attribute6%TYPE := NULL,
46: p_attribute7 IN cn_seasonalities.attribute7%TYPE := NULL,
47: p_attribute8 IN cn_seasonalities.attribute8%TYPE := NULL,
48: p_attribute9 IN cn_seasonalities.attribute9%TYPE := NULL,
49: p_attribute10 IN cn_seasonalities.attribute10%TYPE := NULL,
50: p_attribute11 IN cn_seasonalities.attribute11%TYPE := NULL,
51: p_attribute12 IN cn_seasonalities.attribute12%TYPE := NULL,
52: p_attribute13 IN cn_seasonalities.attribute13%TYPE := NULL,
45: p_attribute6 IN cn_seasonalities.attribute6%TYPE := NULL,
46: p_attribute7 IN cn_seasonalities.attribute7%TYPE := NULL,
47: p_attribute8 IN cn_seasonalities.attribute8%TYPE := NULL,
48: p_attribute9 IN cn_seasonalities.attribute9%TYPE := NULL,
49: p_attribute10 IN cn_seasonalities.attribute10%TYPE := NULL,
50: p_attribute11 IN cn_seasonalities.attribute11%TYPE := NULL,
51: p_attribute12 IN cn_seasonalities.attribute12%TYPE := NULL,
52: p_attribute13 IN cn_seasonalities.attribute13%TYPE := NULL,
53: p_attribute14 IN cn_seasonalities.attribute14%TYPE := NULL,
46: p_attribute7 IN cn_seasonalities.attribute7%TYPE := NULL,
47: p_attribute8 IN cn_seasonalities.attribute8%TYPE := NULL,
48: p_attribute9 IN cn_seasonalities.attribute9%TYPE := NULL,
49: p_attribute10 IN cn_seasonalities.attribute10%TYPE := NULL,
50: p_attribute11 IN cn_seasonalities.attribute11%TYPE := NULL,
51: p_attribute12 IN cn_seasonalities.attribute12%TYPE := NULL,
52: p_attribute13 IN cn_seasonalities.attribute13%TYPE := NULL,
53: p_attribute14 IN cn_seasonalities.attribute14%TYPE := NULL,
54: p_attribute15 IN cn_seasonalities.attribute15%TYPE := NULL,
47: p_attribute8 IN cn_seasonalities.attribute8%TYPE := NULL,
48: p_attribute9 IN cn_seasonalities.attribute9%TYPE := NULL,
49: p_attribute10 IN cn_seasonalities.attribute10%TYPE := NULL,
50: p_attribute11 IN cn_seasonalities.attribute11%TYPE := NULL,
51: p_attribute12 IN cn_seasonalities.attribute12%TYPE := NULL,
52: p_attribute13 IN cn_seasonalities.attribute13%TYPE := NULL,
53: p_attribute14 IN cn_seasonalities.attribute14%TYPE := NULL,
54: p_attribute15 IN cn_seasonalities.attribute15%TYPE := NULL,
55: p_created_by IN cn_seasonalities.created_by%TYPE := NULL,
48: p_attribute9 IN cn_seasonalities.attribute9%TYPE := NULL,
49: p_attribute10 IN cn_seasonalities.attribute10%TYPE := NULL,
50: p_attribute11 IN cn_seasonalities.attribute11%TYPE := NULL,
51: p_attribute12 IN cn_seasonalities.attribute12%TYPE := NULL,
52: p_attribute13 IN cn_seasonalities.attribute13%TYPE := NULL,
53: p_attribute14 IN cn_seasonalities.attribute14%TYPE := NULL,
54: p_attribute15 IN cn_seasonalities.attribute15%TYPE := NULL,
55: p_created_by IN cn_seasonalities.created_by%TYPE := NULL,
56: p_creation_date IN cn_seasonalities.creation_date%TYPE := NULL,
49: p_attribute10 IN cn_seasonalities.attribute10%TYPE := NULL,
50: p_attribute11 IN cn_seasonalities.attribute11%TYPE := NULL,
51: p_attribute12 IN cn_seasonalities.attribute12%TYPE := NULL,
52: p_attribute13 IN cn_seasonalities.attribute13%TYPE := NULL,
53: p_attribute14 IN cn_seasonalities.attribute14%TYPE := NULL,
54: p_attribute15 IN cn_seasonalities.attribute15%TYPE := NULL,
55: p_created_by IN cn_seasonalities.created_by%TYPE := NULL,
56: p_creation_date IN cn_seasonalities.creation_date%TYPE := NULL,
57: p_last_update_login IN cn_seasonalities.last_update_login%TYPE := NULL,
50: p_attribute11 IN cn_seasonalities.attribute11%TYPE := NULL,
51: p_attribute12 IN cn_seasonalities.attribute12%TYPE := NULL,
52: p_attribute13 IN cn_seasonalities.attribute13%TYPE := NULL,
53: p_attribute14 IN cn_seasonalities.attribute14%TYPE := NULL,
54: p_attribute15 IN cn_seasonalities.attribute15%TYPE := NULL,
55: p_created_by IN cn_seasonalities.created_by%TYPE := NULL,
56: p_creation_date IN cn_seasonalities.creation_date%TYPE := NULL,
57: p_last_update_login IN cn_seasonalities.last_update_login%TYPE := NULL,
58: p_last_update_date IN cn_seasonalities.last_update_date%TYPE := NULL,
51: p_attribute12 IN cn_seasonalities.attribute12%TYPE := NULL,
52: p_attribute13 IN cn_seasonalities.attribute13%TYPE := NULL,
53: p_attribute14 IN cn_seasonalities.attribute14%TYPE := NULL,
54: p_attribute15 IN cn_seasonalities.attribute15%TYPE := NULL,
55: p_created_by IN cn_seasonalities.created_by%TYPE := NULL,
56: p_creation_date IN cn_seasonalities.creation_date%TYPE := NULL,
57: p_last_update_login IN cn_seasonalities.last_update_login%TYPE := NULL,
58: p_last_update_date IN cn_seasonalities.last_update_date%TYPE := NULL,
59: p_last_updated_by IN cn_seasonalities.last_updated_by%TYPE := NULL,
52: p_attribute13 IN cn_seasonalities.attribute13%TYPE := NULL,
53: p_attribute14 IN cn_seasonalities.attribute14%TYPE := NULL,
54: p_attribute15 IN cn_seasonalities.attribute15%TYPE := NULL,
55: p_created_by IN cn_seasonalities.created_by%TYPE := NULL,
56: p_creation_date IN cn_seasonalities.creation_date%TYPE := NULL,
57: p_last_update_login IN cn_seasonalities.last_update_login%TYPE := NULL,
58: p_last_update_date IN cn_seasonalities.last_update_date%TYPE := NULL,
59: p_last_updated_by IN cn_seasonalities.last_updated_by%TYPE := NULL,
60: p_OBJECT_VERSION_NUMBER IN cn_seasonalities.OBJECT_VERSION_NUMBER%TYPE := NULL);
53: p_attribute14 IN cn_seasonalities.attribute14%TYPE := NULL,
54: p_attribute15 IN cn_seasonalities.attribute15%TYPE := NULL,
55: p_created_by IN cn_seasonalities.created_by%TYPE := NULL,
56: p_creation_date IN cn_seasonalities.creation_date%TYPE := NULL,
57: p_last_update_login IN cn_seasonalities.last_update_login%TYPE := NULL,
58: p_last_update_date IN cn_seasonalities.last_update_date%TYPE := NULL,
59: p_last_updated_by IN cn_seasonalities.last_updated_by%TYPE := NULL,
60: p_OBJECT_VERSION_NUMBER IN cn_seasonalities.OBJECT_VERSION_NUMBER%TYPE := NULL);
61:
54: p_attribute15 IN cn_seasonalities.attribute15%TYPE := NULL,
55: p_created_by IN cn_seasonalities.created_by%TYPE := NULL,
56: p_creation_date IN cn_seasonalities.creation_date%TYPE := NULL,
57: p_last_update_login IN cn_seasonalities.last_update_login%TYPE := NULL,
58: p_last_update_date IN cn_seasonalities.last_update_date%TYPE := NULL,
59: p_last_updated_by IN cn_seasonalities.last_updated_by%TYPE := NULL,
60: p_OBJECT_VERSION_NUMBER IN cn_seasonalities.OBJECT_VERSION_NUMBER%TYPE := NULL);
61:
62: PROCEDURE delete_row
55: p_created_by IN cn_seasonalities.created_by%TYPE := NULL,
56: p_creation_date IN cn_seasonalities.creation_date%TYPE := NULL,
57: p_last_update_login IN cn_seasonalities.last_update_login%TYPE := NULL,
58: p_last_update_date IN cn_seasonalities.last_update_date%TYPE := NULL,
59: p_last_updated_by IN cn_seasonalities.last_updated_by%TYPE := NULL,
60: p_OBJECT_VERSION_NUMBER IN cn_seasonalities.OBJECT_VERSION_NUMBER%TYPE := NULL);
61:
62: PROCEDURE delete_row
63: (P_SEAS_SCHEDULE_ID IN cn_seasonalities.SEAS_SCHEDULE_ID%TYPE);
56: p_creation_date IN cn_seasonalities.creation_date%TYPE := NULL,
57: p_last_update_login IN cn_seasonalities.last_update_login%TYPE := NULL,
58: p_last_update_date IN cn_seasonalities.last_update_date%TYPE := NULL,
59: p_last_updated_by IN cn_seasonalities.last_updated_by%TYPE := NULL,
60: p_OBJECT_VERSION_NUMBER IN cn_seasonalities.OBJECT_VERSION_NUMBER%TYPE := NULL);
61:
62: PROCEDURE delete_row
63: (P_SEAS_SCHEDULE_ID IN cn_seasonalities.SEAS_SCHEDULE_ID%TYPE);
64:
59: p_last_updated_by IN cn_seasonalities.last_updated_by%TYPE := NULL,
60: p_OBJECT_VERSION_NUMBER IN cn_seasonalities.OBJECT_VERSION_NUMBER%TYPE := NULL);
61:
62: PROCEDURE delete_row
63: (P_SEAS_SCHEDULE_ID IN cn_seasonalities.SEAS_SCHEDULE_ID%TYPE);
64:
65: END CN_SEASONALITIES_pkg;
61:
62: PROCEDURE delete_row
63: (P_SEAS_SCHEDULE_ID IN cn_seasonalities.SEAS_SCHEDULE_ID%TYPE);
64:
65: END CN_SEASONALITIES_pkg;