423: ** Clear out any existing data for this range of records
424: **
425: ** Don't delete just yet.
426: **
427: delete from ota_suppliable_resources_tl
428: where supplied_resource_id between p_start_pkid
429: and p_end_pkid;
430: */
431:
444:
445: /*
446: ** Insert the TL rows.
447: */
448: Insert into OTA_SUPPLIABLE_RESOURCES_TL
449: (Supplied_Resource_Id,
450: Language,
451: Name,
452: Special_Instruction,
468: M.Creation_date,
469: M.Last_Updated_By,
470: M.Last_Update_Date,
471: M.Last_Update_Login
472: From OTA_SUPPLIABLE_RESOURCES M, OTA_RESOURCE_DEFINITIONS RD
473: Where M.Resource_definition_id = Rd.Resource_definition_id
474: And M.Supplied_resource_id Between P_start_pkid and P_end_pkid
475: And Not Exists (Select '1'
476: From OTA_SUPPLIABLE_RESOURCES_TL T
472: From OTA_SUPPLIABLE_RESOURCES M, OTA_RESOURCE_DEFINITIONS RD
473: Where M.Resource_definition_id = Rd.Resource_definition_id
474: And M.Supplied_resource_id Between P_start_pkid and P_end_pkid
475: And Not Exists (Select '1'
476: From OTA_SUPPLIABLE_RESOURCES_TL T
477: Where T.Supplied_resource_id = M.Supplied_resource_id
478: And T.Language = L_Current_Language ) ;
479:
480: l_rows_processed := l_rows_processed + SQL%ROWCOUNT;