APPS.CN_SEAS_SCHEDULES_PVT dependencies on CN_SEAS_SCHEDULES_PKG

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

26: -- Version : Current version 1.0
27: --
28: --
29: --
30: -- Notes : This procedure uses the table handler CN_SEAS_SCHEDULES_PKG
31: -- and CN_SEASONALITIES_PKG to insert rows into CN_SEAS_SCHEDULES
32: -- and CN_SEASONALITIES after some validations.
33: --
34: -- End of comments

Line 131: CN_SEAS_SCHEDULES_pkg.insert_row (

127: group by period_year;
128:
129: -- We can put some more error conditon checks for Start Date and End Date.
130: -- Call the table handler to insert the row into CN_SEAS_SCHEDULES Table.
131: CN_SEAS_SCHEDULES_pkg.insert_row (
132: P_SEAS_SCHEDULE_ID => p_seas_schedules_rec_type.seas_schedule_id,
133: P_NAME => p_seas_schedules_rec_type.name,
134: P_DESCRIPTION => p_seas_schedules_rec_type.description,
135: P_PERIOD_YEAR => p_seas_schedules_rec_type.period_year,

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

258: -- Version : Current version 1.0
259: --
260: --
261: --
262: -- Notes : This procedure uses the table handler CN_SEAS_SCHEDULES_PKG
263: -- to update rows into CN_SEAS_SCHEDULES after some validations.
264: --
265: -- End of comments
266:

Line 375: CN_SEAS_SCHEDULES_pkg.update_row

371: --DBMS_OUTPUT.PUT_LINE('END DATE : ' || p_seas_schedules_rec_type.end_date);
372: --DBMS_OUTPUT.PUT_LINE('OVN : ' || p_seas_schedules_rec_type.object_version_number);
373: --DBMS_OUTPUT.PUT_LINE('VALIDATION STATUS : ' || l_validation_status);
374:
375: CN_SEAS_SCHEDULES_pkg.update_row
376: (
377: P_SEAS_SCHEDULE_ID => p_seas_schedules_rec_type.seas_schedule_id,
378: P_NAME => p_seas_schedules_rec_type.name,
379: P_DESCRIPTION => p_seas_schedules_rec_type.description,

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

470: -- Version : Current version 1.0
471: --
472: --
473: --
474: -- Notes : This procedure uses the table handler CN_SEAS_SCHEDULES_PKG
475: -- and CN_SEASONALITIES_PKG to delete rows into CN_SEAS_SCHEDULES
476: -- and CN_SEASONALITIES after the validations are done.
477: --
478: -- End of comments

Line 531: CN_SEAS_SCHEDULES_pkg.delete_row (P_SEAS_SCHEDULE_ID => l_seas_sch_id);

527: RAISE FND_API.G_EXC_ERROR ;
528: END IF;
529:
530: -- Delete entries from CN_SEAS_SCHEDULES
531: CN_SEAS_SCHEDULES_pkg.delete_row (P_SEAS_SCHEDULE_ID => l_seas_sch_id);
532:
533: -- Delete entries from CN_SEASONALITIES.
534: CN_SEASONALITIES_pkg.delete_row (P_SEAS_SCHEDULE_ID => l_seas_sch_id);
535: