DBA Data[Home] [Help]

APPS.CN_SEASONALITIES_PVT dependencies on CN_SEAS_SCHEDULES

Line 5: ( SEAS_SCHEDULE_ID cn_seas_schedules.SEAS_SCHEDULE_ID%TYPE := NULL,

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,

Line 6: NAME cn_seas_schedules.NAME%TYPE := FND_API.G_MISS_CHAR,

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,

Line 7: DESCRIPTION cn_seas_schedules.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,

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,

Line 8: PERIOD_YEAR cn_seas_schedules.PERIOD_YEAR%TYPE := FND_API.G_MISS_NUM,

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

Line 9: START_DATE cn_seas_schedules.START_DATE%TYPE := FND_API.G_MISS_DATE,

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: ) ;

Line 10: END_DATE cn_seas_schedules.END_DATE%TYPE := FND_API.G_MISS_DATE,

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:

Line 11: VALIDATION_STATUS cn_seas_schedules.VALIDATION_STATUS%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:
15: TYPE seasonalities_rec_type IS RECORD

Line 12: OBJECT_VERSION_NUMBER cn_seas_schedules.OBJECT_VERSION_NUMBER%TYPE:= FND_API.G_MISS_NUM

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,

Line 46: -- Notes : This procedure uses the table handler CN_SEAS_SCHEDULES_PKG

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:

Line 47: -- to update rows into CN_SEAS_SCHEDULES after some validations.

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

Line 85: -- Notes : This procedure uses the table handler CN_SEAS_SCHEDULES_PKG

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:

Line 86: -- to update rows into CN_SEAS_SCHEDULES after some validations.

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