APPS.CSF_MAP_ACC_HRS_PKG dependencies on CSF_MAP_ACCESS_HOURS_B

Line 53: insert into CSF_MAP_ACCESS_HOURS_B (

49: l_object_version_number NUMBER := 1;
50:
51: begin
52:
53: insert into CSF_MAP_ACCESS_HOURS_B (
54: ACCESS_HOUR_MAP_ID,
55: CUSTOMER_ID,
56: CUSTOMER_SITE_ID,
57: CUSTOMER_LOCATION_ID,

Line 219: update CSF_MAP_ACCESS_HOURS_B set

215:
216: l_object_Version_number number;
217:
218: begin
219: update CSF_MAP_ACCESS_HOURS_B set
220: CUSTOMER_ID = p_CUSTOMER_ID,
221: CUSTOMER_SITE_ID = p_CUSTOMER_SITE_ID,
222: CUSTOMER_LOCATION_ID = p_CUSTOMER_LOCATION_ID,
223: ACCESSHOUR_REQUIRED = p_ACCESSHOUR_REQUIRED,

Line 329: delete from CSF_MAP_ACCESS_HOURS_B

325: if (sql%notfound) then
326: raise no_data_found;
327: end if;
328:
329: delete from CSF_MAP_ACCESS_HOURS_B
330: where ACCESS_HOUR_MAP_ID = p_ACCESS_HOUR_MAP_ID;
331:
332: if (sql%notfound) then
333: raise no_data_found;

Line 344: from CSF_MAP_ACCESS_HOURS_B B

340: begin
341: delete from CSF_MAP_ACCESS_HOURS_TL T
342: where not exists
343: (select NULL
344: from CSF_MAP_ACCESS_HOURS_B B
345: where B.ACCESS_HOUR_MAP_ID = T.ACCESS_HOUR_MAP_ID
346: );
347:
348: update CSF_MAP_ACCESS_HOURS_TL T set (