APPS.CN_SEASONALITIES_PVT dependencies on CN_SEASONALITIES

Line 1: PACKAGE BODY cn_seasonalities_pvt AS

1: PACKAGE BODY cn_seasonalities_pvt AS
2: -- $Header: cnvseasb.pls 115.4 2002/11/21 21:18:17 hlchen ship $
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'cn_seasonalities_pvt';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnvseasb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'cn_seasonalities_pvt';

1: PACKAGE BODY cn_seasonalities_pvt AS
2: -- $Header: cnvseasb.pls 115.4 2002/11/21 21:18:17 hlchen ship $
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'cn_seasonalities_pvt';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnvseasb.pls';
6:
7:
8: -- Start of comments

Line 105: CN_SEASONALITIES_pkg.update_row

101: END IF;
102: RAISE FND_API.G_EXC_ERROR ;
103: END IF;
104:
105: CN_SEASONALITIES_pkg.update_row
106: (
107: P_SEASONALITY_ID => p_seasonalities_rec_type.seasonality_id,
108: P_SEAS_SCHEDULE_ID => p_seasonalities_rec_type.SEAS_SCHEDULE_ID,
109: p_CAL_PER_INT_TYPE_ID => FND_API.G_MISS_NUM,

Line 227: SELECT PCT_SEASONALITY FROM CN_SEASONALITIES

223: l_msg_data VARCHAR2(2000);
224: l_sum NUMBER;
225:
226: CURSOR pct_seasonality_cur(p_seas_sch_id NUMBER) IS
227: SELECT PCT_SEASONALITY FROM CN_SEASONALITIES
228: WHERE seas_schedule_id = p_seas_sch_id;
229: BEGIN
230: --DBMS_OUTPUT.PUT_LINE('Delete in progress');
231: -- Standard Start of API savepoint

Line 343: END cn_seasonalities_pvt;

339: );
340: END Validate_Seasonalities;
341:
342:
343: END cn_seasonalities_pvt;