APPS.EGO_FUNCTIONS_BULKLOAD_PVT dependencies on EGO_FUNCTIONS_TL

Line 232: temporary_record_tl ego_functions_tl%ROWTYPE;

228: -- func_header_rec - Represents a row of type ego_functions_interface%ROWTYPE. --
229: ---------------------------------------------------------------------------------------------
230: PROCEDURE validate_function(func_header_rec IN OUT NOCOPY ego_functions_interface%ROWTYPE) IS
231: temporary_record ego_functions_b%ROWTYPE;
232: temporary_record_tl ego_functions_tl%ROWTYPE;
233: valid_function_type NUMBER(1);
234: duplicate_internal_name NUMBER(1);
235: function_is_used NUMBER(1);
236: error_count NUMBER;

Line 337: FROM ego_functions_tl

333: WHERE ( function_id = func_header_rec.function_id );
334:
335: SELECT *
336: INTO temporary_record_tl
337: FROM ego_functions_tl
338: WHERE ( function_id = func_header_rec.function_id )
339: AND language = Userenv('LANG');
340:
341: /* 1. Validating Function Type. */

Line 500: INSERT INTO ego_functions_tl

496: G_USER_ID,
497: SYSDATE,
498: G_LOGIN_ID);
499:
500: INSERT INTO ego_functions_tl
501: (function_id,
502: display_name,
503: description,
504: language,

Line 534: UPDATE ego_functions_tl

530: last_update_date = SYSDATE,
531: last_update_login = G_LOGIN_ID
532: WHERE ( function_id = func_header_rec.function_id );
533:
534: UPDATE ego_functions_tl
535: SET display_name = func_header_rec.display_name,
536: description = func_header_rec.description,
537: last_updated_by = G_USER_ID,
538: last_update_date = SYSDATE,

Line 545: DELETE ego_functions_tl WHERE (function_id=func_header_rec.function_id);

541: AND Userenv('LANG') IN ( language, source_lang );
542:
543: ELSIF (func_header_rec.transaction_type = G_DELETE_TRANSACTION) THEN
544: DELETE ego_functions_b WHERE (function_id=func_header_rec.function_id);
545: DELETE ego_functions_tl WHERE (function_id=func_header_rec.function_id);
546: /* Bug 9647937. Delete rows from ego_func_params_tl table, before deleting rows from
547: ego_func_params_b table. */
548: DELETE ego_func_params_tl WHERE func_param_id IN (SELECT func_param_id FROM ego_func_params_b
549: WHERE (function_id=func_header_rec.function_id));