DBA Data[Home] [Help]

APPS.CN_SEAS_SCHEDULES_PVT dependencies on CN_SEASONALITIES_PKG

Line 31: -- and CN_SEASONALITIES_PKG to insert rows into CN_SEAS_SCHEDULES

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
35:

Line 168: CN_SEASONALITIES_pkg.insert_row(

164: -- Create a CURSOR OF VALUES FOR the Period and use table handler
165: -- to insert rows into the CN_SEASONALITIES.
166: FOR l_seas_sch IN cn_seasonalities_cur(p_seas_schedules_rec_type.period_year) LOOP
167: --DBMS_OUTPUT.PUT_LINE('In the Loop');
168: CN_SEASONALITIES_pkg.insert_row(
169: P_SEASONALITY_ID => -99,
170: P_SEAS_SCHEDULE_ID => l_seas_schedule_id,
171: P_CAL_PER_INT_TYPE_ID => l_seas_sch.CAL_PER_INT_TYPE_ID,
172: P_PERIOD_ID => l_seas_sch.PERIOD_ID,

Line 475: -- and CN_SEASONALITIES_PKG to delete rows into CN_SEAS_SCHEDULES

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
479:

Line 534: CN_SEASONALITIES_pkg.delete_row (P_SEAS_SCHEDULE_ID => l_seas_sch_id);

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:
536: -- End of API body.
537: << end_Delete_Seas_Schedule >>
538: NULL;