DBA Data[Home] [Help]

APPS.CN_SEASONALITIES_PVT dependencies on CN_SEAS_SCHEDULES_PVT

Line 50: l_rec cn_seas_schedules_PVT.seas_schedules_rec_type;

46: l_api_version CONSTANT NUMBER := 1.0;
47: l_error_code NUMBER;
48: l_count NUMBER;
49: l_validation_status VARCHAR2(30);
50: l_rec cn_seas_schedules_PVT.seas_schedules_rec_type;
51: l_return_status VARCHAR2(1);
52: l_msg_count NUMBER;
53: l_msg_data VARCHAR2(2000);
54:

Line 85: cn_seas_schedules_PVT.Update_Seas_Schedule

81: l_rec.seas_schedule_id := p_seasonalities_rec_type.SEAS_SCHEDULE_ID;
82: l_rec.validation_status := l_validation_status;
83:
84: --DBMS_OUTPUT.PUT_LINE('About to call CN_SEAS_SCHEDULES');
85: cn_seas_schedules_PVT.Update_Seas_Schedule
86: ( p_api_version => 1.0,
87: p_init_msg_list => FND_API.G_FALSE,
88: p_commit => FND_API.G_FALSE,
89: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 220: l_rec cn_seas_schedules_PVT.seas_schedules_rec_type;

216: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Seasonalities';
217: l_api_version CONSTANT NUMBER := 1.0;
218: l_error_code NUMBER;
219: l_seas_sch_id NUMBER;
220: l_rec cn_seas_schedules_PVT.seas_schedules_rec_type;
221: l_return_status VARCHAR2(1);
222: l_msg_count NUMBER;
223: l_msg_data VARCHAR2(2000);
224: l_sum NUMBER;

Line 266: cn_seas_schedules_PVT.Update_Seas_Schedule

262: SELECT NAME,DESCRIPTION,PERIOD_YEAR,START_DATE,END_DATE INTO l_rec.name,l_rec.description,
263: l_rec.period_year,l_rec.start_date,L_rec.end_date from cn_seas_schedules
264: where seas_schedule_id = p_seas_schedule_rec_type.SEAS_SCHEDULE_ID;
265:
266: cn_seas_schedules_PVT.Update_Seas_Schedule
267: ( p_api_version => 1.0,
268: p_init_msg_list => FND_API.G_FALSE,
269: p_commit => FND_API.G_FALSE,
270: p_validation_level => FND_API.G_VALID_LEVEL_FULL,