1: PACKAGE CN_SEASONALITIES_PVT AUTHID CURRENT_USER AS
2: -- $Header: cnvseass.pls 115.4 2002/11/21 21:18:19 hlchen ship $
3:
4: TYPE cp_seas_schedules_rec_type IS RECORD
5: ( SEAS_SCHEDULE_ID cn_seas_schedules.SEAS_SCHEDULE_ID%TYPE := NULL,
6: NAME cn_seas_schedules.NAME%TYPE := FND_API.G_MISS_CHAR,
7: DESCRIPTION cn_seas_schedules.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
8: PERIOD_YEAR cn_seas_schedules.PERIOD_YEAR%TYPE := FND_API.G_MISS_NUM,
9: START_DATE cn_seas_schedules.START_DATE%TYPE := FND_API.G_MISS_DATE,
2: -- $Header: cnvseass.pls 115.4 2002/11/21 21:18:19 hlchen ship $
3:
4: TYPE cp_seas_schedules_rec_type IS RECORD
5: ( SEAS_SCHEDULE_ID cn_seas_schedules.SEAS_SCHEDULE_ID%TYPE := NULL,
6: NAME cn_seas_schedules.NAME%TYPE := FND_API.G_MISS_CHAR,
7: DESCRIPTION cn_seas_schedules.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
8: PERIOD_YEAR cn_seas_schedules.PERIOD_YEAR%TYPE := FND_API.G_MISS_NUM,
9: START_DATE cn_seas_schedules.START_DATE%TYPE := FND_API.G_MISS_DATE,
10: END_DATE cn_seas_schedules.END_DATE%TYPE := FND_API.G_MISS_DATE,
3:
4: TYPE cp_seas_schedules_rec_type IS RECORD
5: ( SEAS_SCHEDULE_ID cn_seas_schedules.SEAS_SCHEDULE_ID%TYPE := NULL,
6: NAME cn_seas_schedules.NAME%TYPE := FND_API.G_MISS_CHAR,
7: DESCRIPTION cn_seas_schedules.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
8: PERIOD_YEAR cn_seas_schedules.PERIOD_YEAR%TYPE := FND_API.G_MISS_NUM,
9: START_DATE cn_seas_schedules.START_DATE%TYPE := FND_API.G_MISS_DATE,
10: END_DATE cn_seas_schedules.END_DATE%TYPE := FND_API.G_MISS_DATE,
11: VALIDATION_STATUS cn_seas_schedules.VALIDATION_STATUS%TYPE := FND_API.G_MISS_CHAR,
4: TYPE cp_seas_schedules_rec_type IS RECORD
5: ( SEAS_SCHEDULE_ID cn_seas_schedules.SEAS_SCHEDULE_ID%TYPE := NULL,
6: NAME cn_seas_schedules.NAME%TYPE := FND_API.G_MISS_CHAR,
7: DESCRIPTION cn_seas_schedules.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
8: PERIOD_YEAR cn_seas_schedules.PERIOD_YEAR%TYPE := FND_API.G_MISS_NUM,
9: START_DATE cn_seas_schedules.START_DATE%TYPE := FND_API.G_MISS_DATE,
10: END_DATE cn_seas_schedules.END_DATE%TYPE := FND_API.G_MISS_DATE,
11: VALIDATION_STATUS cn_seas_schedules.VALIDATION_STATUS%TYPE := FND_API.G_MISS_CHAR,
12: OBJECT_VERSION_NUMBER cn_seas_schedules.OBJECT_VERSION_NUMBER%TYPE:= FND_API.G_MISS_NUM
5: ( SEAS_SCHEDULE_ID cn_seas_schedules.SEAS_SCHEDULE_ID%TYPE := NULL,
6: NAME cn_seas_schedules.NAME%TYPE := FND_API.G_MISS_CHAR,
7: DESCRIPTION cn_seas_schedules.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
8: PERIOD_YEAR cn_seas_schedules.PERIOD_YEAR%TYPE := FND_API.G_MISS_NUM,
9: START_DATE cn_seas_schedules.START_DATE%TYPE := FND_API.G_MISS_DATE,
10: END_DATE cn_seas_schedules.END_DATE%TYPE := FND_API.G_MISS_DATE,
11: VALIDATION_STATUS cn_seas_schedules.VALIDATION_STATUS%TYPE := FND_API.G_MISS_CHAR,
12: OBJECT_VERSION_NUMBER cn_seas_schedules.OBJECT_VERSION_NUMBER%TYPE:= FND_API.G_MISS_NUM
13: ) ;
6: NAME cn_seas_schedules.NAME%TYPE := FND_API.G_MISS_CHAR,
7: DESCRIPTION cn_seas_schedules.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
8: PERIOD_YEAR cn_seas_schedules.PERIOD_YEAR%TYPE := FND_API.G_MISS_NUM,
9: START_DATE cn_seas_schedules.START_DATE%TYPE := FND_API.G_MISS_DATE,
10: END_DATE cn_seas_schedules.END_DATE%TYPE := FND_API.G_MISS_DATE,
11: VALIDATION_STATUS cn_seas_schedules.VALIDATION_STATUS%TYPE := FND_API.G_MISS_CHAR,
12: OBJECT_VERSION_NUMBER cn_seas_schedules.OBJECT_VERSION_NUMBER%TYPE:= FND_API.G_MISS_NUM
13: ) ;
14:
7: DESCRIPTION cn_seas_schedules.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
8: PERIOD_YEAR cn_seas_schedules.PERIOD_YEAR%TYPE := FND_API.G_MISS_NUM,
9: START_DATE cn_seas_schedules.START_DATE%TYPE := FND_API.G_MISS_DATE,
10: END_DATE cn_seas_schedules.END_DATE%TYPE := FND_API.G_MISS_DATE,
11: VALIDATION_STATUS cn_seas_schedules.VALIDATION_STATUS%TYPE := FND_API.G_MISS_CHAR,
12: OBJECT_VERSION_NUMBER cn_seas_schedules.OBJECT_VERSION_NUMBER%TYPE:= FND_API.G_MISS_NUM
13: ) ;
14:
15: TYPE seasonalities_rec_type IS RECORD
8: PERIOD_YEAR cn_seas_schedules.PERIOD_YEAR%TYPE := FND_API.G_MISS_NUM,
9: START_DATE cn_seas_schedules.START_DATE%TYPE := FND_API.G_MISS_DATE,
10: END_DATE cn_seas_schedules.END_DATE%TYPE := FND_API.G_MISS_DATE,
11: VALIDATION_STATUS cn_seas_schedules.VALIDATION_STATUS%TYPE := FND_API.G_MISS_CHAR,
12: OBJECT_VERSION_NUMBER cn_seas_schedules.OBJECT_VERSION_NUMBER%TYPE:= FND_API.G_MISS_NUM
13: ) ;
14:
15: TYPE seasonalities_rec_type IS RECORD
16: ( SEAS_SCHEDULE_ID cn_seasonalities.SEAS_SCHEDULE_ID%TYPE := NULL,
42: -- Version : Current version 1.0
43: --
44: --
45: --
46: -- Notes : This procedure uses the table handler CN_SEAS_SCHEDULES_PKG
47: -- to update rows into CN_SEAS_SCHEDULES after some validations.
48: --
49: -- End of comments
50:
43: --
44: --
45: --
46: -- Notes : This procedure uses the table handler CN_SEAS_SCHEDULES_PKG
47: -- to update rows into CN_SEAS_SCHEDULES after some validations.
48: --
49: -- End of comments
50:
51: PROCEDURE Update_Seasonalities
81: -- Version : Current version 1.0
82: --
83: --
84: --
85: -- Notes : This procedure uses the table handler CN_SEAS_SCHEDULES_PKG
86: -- to update rows into CN_SEAS_SCHEDULES after some validations.
87: --
88: -- End of comments
89:
82: --
83: --
84: --
85: -- Notes : This procedure uses the table handler CN_SEAS_SCHEDULES_PKG
86: -- to update rows into CN_SEAS_SCHEDULES after some validations.
87: --
88: -- End of comments
89:
90: PROCEDURE Validate_Seasonalities