DBA Data[Home] [Help]

APPS.CN_SEASONALITIES_PVT dependencies on FND_API

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 19: OBJECT_VERSION_NUMBER cn_seasonalities.OBJECT_VERSION_NUMBER%TYPE:= FND_API.G_MISS_NUM

15: TYPE seasonalities_rec_type IS RECORD
16: ( SEAS_SCHEDULE_ID cn_seasonalities.SEAS_SCHEDULE_ID%TYPE := NULL,
17: SEASONALITY_ID cn_seasonalities.SEASONALITY_ID%TYPE := NULL,
18: PCT_SEASONALITY cn_seasonalities.PCT_SEASONALITY%TYPE := NULL,
19: OBJECT_VERSION_NUMBER cn_seasonalities.OBJECT_VERSION_NUMBER%TYPE:= FND_API.G_MISS_NUM
20: ) ;
21:
22: TYPE seasonalities_tbl_type IS TABLE OF seasonalities_rec_type INDEX BY BINARY_INTEGER;
23:

Line 32: -- Default = FND_API.G_FALSE

28: -- Pre-reqs : None.
29: -- Parameters :
30: -- IN : p_api_version IN NUMBER Required
31: -- p_init_msg_list IN VARCHAR2 Optional
32: -- Default = FND_API.G_FALSE
33: -- p_commit IN VARCHAR2 Optional
34: -- Default = FND_API.G_FALSE
35: -- p_validation_level IN NUMBER Optional
36: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 34: -- Default = FND_API.G_FALSE

30: -- IN : p_api_version IN NUMBER Required
31: -- p_init_msg_list IN VARCHAR2 Optional
32: -- Default = FND_API.G_FALSE
33: -- p_commit IN VARCHAR2 Optional
34: -- Default = FND_API.G_FALSE
35: -- p_validation_level IN NUMBER Optional
36: -- Default = FND_API.G_VALID_LEVEL_FULL
37: -- p_seasonalities_rec_type IN seasonalities_rec_type
38: -- OUT : x_return_status OUT VARCHAR2(1)

Line 36: -- Default = FND_API.G_VALID_LEVEL_FULL

32: -- Default = FND_API.G_FALSE
33: -- p_commit IN VARCHAR2 Optional
34: -- Default = FND_API.G_FALSE
35: -- p_validation_level IN NUMBER Optional
36: -- Default = FND_API.G_VALID_LEVEL_FULL
37: -- p_seasonalities_rec_type IN seasonalities_rec_type
38: -- OUT : x_return_status OUT VARCHAR2(1)
39: -- x_msg_count OUT NUMBER
40: -- x_msg_data OUT VARCHAR2(2000)

Line 53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

49: -- End of comments
50:
51: PROCEDURE Update_Seasonalities
52: ( p_api_version IN NUMBER ,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54: p_commit IN VARCHAR2 := FND_API.G_FALSE,
55: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56: p_seasonalities_rec_type IN seasonalities_rec_type,
57: x_return_status OUT NOCOPY VARCHAR2,

Line 54: p_commit IN VARCHAR2 := FND_API.G_FALSE,

50:
51: PROCEDURE Update_Seasonalities
52: ( p_api_version IN NUMBER ,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54: p_commit IN VARCHAR2 := FND_API.G_FALSE,
55: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56: p_seasonalities_rec_type IN seasonalities_rec_type,
57: x_return_status OUT NOCOPY VARCHAR2,
58: x_msg_count OUT NOCOPY NUMBER,

Line 55: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

51: PROCEDURE Update_Seasonalities
52: ( p_api_version IN NUMBER ,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54: p_commit IN VARCHAR2 := FND_API.G_FALSE,
55: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56: p_seasonalities_rec_type IN seasonalities_rec_type,
57: x_return_status OUT NOCOPY VARCHAR2,
58: x_msg_count OUT NOCOPY NUMBER,
59: x_msg_data OUT NOCOPY VARCHAR2

Line 71: -- Default = FND_API.G_FALSE

67: -- Pre-reqs : None.
68: -- Parameters :
69: -- IN : p_api_version IN NUMBER Required
70: -- p_init_msg_list IN VARCHAR2 Optional
71: -- Default = FND_API.G_FALSE
72: -- p_commit IN VARCHAR2 Optional
73: -- Default = FND_API.G_FALSE
74: -- p_validation_level IN NUMBER Optional
75: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 73: -- Default = FND_API.G_FALSE

69: -- IN : p_api_version IN NUMBER Required
70: -- p_init_msg_list IN VARCHAR2 Optional
71: -- Default = FND_API.G_FALSE
72: -- p_commit IN VARCHAR2 Optional
73: -- Default = FND_API.G_FALSE
74: -- p_validation_level IN NUMBER Optional
75: -- Default = FND_API.G_VALID_LEVEL_FULL
76: -- p_seas_schedule_id IN NUMBER
77: -- OUT : x_return_status OUT VARCHAR2(1)

Line 75: -- Default = FND_API.G_VALID_LEVEL_FULL

71: -- Default = FND_API.G_FALSE
72: -- p_commit IN VARCHAR2 Optional
73: -- Default = FND_API.G_FALSE
74: -- p_validation_level IN NUMBER Optional
75: -- Default = FND_API.G_VALID_LEVEL_FULL
76: -- p_seas_schedule_id IN NUMBER
77: -- OUT : x_return_status OUT VARCHAR2(1)
78: -- x_msg_count OUT NUMBER
79: -- x_msg_data OUT VARCHAR2(2000)

Line 92: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

88: -- End of comments
89:
90: PROCEDURE Validate_Seasonalities
91: ( p_api_version IN NUMBER ,
92: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
93: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
94: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
95: p_seas_schedule_rec_type IN cp_seas_schedules_rec_type,
96: x_return_status OUT NOCOPY VARCHAR2 ,

Line 93: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

89:
90: PROCEDURE Validate_Seasonalities
91: ( p_api_version IN NUMBER ,
92: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
93: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
94: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
95: p_seas_schedule_rec_type IN cp_seas_schedules_rec_type,
96: x_return_status OUT NOCOPY VARCHAR2 ,
97: x_msg_count OUT NOCOPY NUMBER ,

Line 94: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

90: PROCEDURE Validate_Seasonalities
91: ( p_api_version IN NUMBER ,
92: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
93: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
94: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
95: p_seas_schedule_rec_type IN cp_seas_schedules_rec_type,
96: x_return_status OUT NOCOPY VARCHAR2 ,
97: x_msg_count OUT NOCOPY NUMBER ,
98: x_msg_data OUT NOCOPY VARCHAR2