498:
499: -- Added for Function Security Cache Invalidation Project.
500: fnd_function_security_cache.delete_function(form_function.function_id);
501:
502: DELETE FROM fnd_form_functions_tl
503: WHERE function_id = form_function.function_id;
504:
505: -- Cascade deletes to resp functions
506: DELETE FROM fnd_resp_functions rf
579: -- Added for Function Security Cache Invalidation Project.
580: fnd_function_security_cache.insert_function(form_function.function_id);
581:
582: -- Insert into _TL
583: INSERT INTO fnd_form_functions_tl (
584: LANGUAGE,
585: function_id,
586: user_function_name,
587: description,
623: -- Added for Function Security Cache Invalidation Project.
624: fnd_function_security_cache.update_function(form_function.function_id);
625:
626: -- Update TL
627: UPDATE fnd_form_functions_tl SET
628: user_function_name = form_function.namebuf,
629: description = form_function.description,
630: last_update_date = sysdate,
631: last_updated_by = 1,
1270:
1271: -- Added for Function Security Cache Invalidation Project.
1272: fnd_function_security_cache.update_function(newid);
1273:
1274: DELETE FROM FND_FORM_FUNCTIONS_TL
1275: WHERE FUNCTION_ID = newid;
1276:
1277: -- 3. Update oldname to newname in old row
1278: UPDATE FND_FORM_FUNCTIONS