APPS.CSF_MAP_ACC_HRS_PKG dependencies on CSF_MAP_ACCESS_HOURS_B

Line 141: insert into CSF_MAP_ACCESS_HOURS_B (

137: l_object_version_number NUMBER := 1;
138:
139: begin
140:
141: insert into CSF_MAP_ACCESS_HOURS_B (
142: ACCESS_HOUR_MAP_ID,
143: CUSTOMER_ID,
144: CUSTOMER_SITE_ID,
145: CUSTOMER_LOCATION_ID,

Line 307: update CSF_MAP_ACCESS_HOURS_B set

303:
304: l_object_Version_number number;
305:
306: begin
307: update CSF_MAP_ACCESS_HOURS_B set
308: CUSTOMER_ID = p_CUSTOMER_ID,
309: CUSTOMER_SITE_ID = p_CUSTOMER_SITE_ID,
310: CUSTOMER_LOCATION_ID = p_CUSTOMER_LOCATION_ID,
311: ACCESSHOUR_REQUIRED = p_ACCESSHOUR_REQUIRED,

Line 417: delete from CSF_MAP_ACCESS_HOURS_B

413: if (sql%notfound) then
414: raise no_data_found;
415: end if;
416:
417: delete from CSF_MAP_ACCESS_HOURS_B
418: where ACCESS_HOUR_MAP_ID = p_ACCESS_HOUR_MAP_ID;
419:
420: if (sql%notfound) then
421: raise no_data_found;

Line 432: from CSF_MAP_ACCESS_HOURS_B B

428: begin
429: delete from CSF_MAP_ACCESS_HOURS_TL T
430: where not exists
431: (select NULL
432: from CSF_MAP_ACCESS_HOURS_B B
433: where B.ACCESS_HOUR_MAP_ID = T.ACCESS_HOUR_MAP_ID
434: );
435:
436: update CSF_MAP_ACCESS_HOURS_TL T set (