APPS.EGO_FUNCTIONS_BULKLOAD_PVT dependencies on EGO_FUNC_PARAMS_TL

Line 546: /* Bug 9647937. Delete rows from ego_func_params_tl table, before deleting rows from

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));
550: DELETE ego_func_params_b WHERE (function_id=func_header_rec.function_id);

Line 548: DELETE ego_func_params_tl WHERE func_param_id IN (SELECT func_param_id FROM ego_func_params_b

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));
550: DELETE ego_func_params_b WHERE (function_id=func_header_rec.function_id);
551: END IF;
552: func_header_rec.process_status := G_SUCCESS_RECORD;

Line 1198: temporary_record_tl ego_func_params_tl%ROWTYPE;

1194: valid_param_type NUMBER(1);
1195: duplicate_internal_name NUMBER(1);
1196: duplicate_sequence NUMBER(1);
1197: temporary_record ego_func_params_b%ROWTYPE;
1198: temporary_record_tl ego_func_params_tl%ROWTYPE;
1199: l_proc_name VARCHAR2(30) := 'validate_func_param';
1200: BEGIN
1201: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'||' Entered into the procedure');
1202: /* Validations for CREATE transaction type. */

Line 1381: FROM ego_func_params_tl

1377: WHERE ( func_param_id = func_param_rec.func_param_id );
1378:
1379: SELECT *
1380: INTO temporary_record_tl
1381: FROM ego_func_params_tl
1382: WHERE ( func_param_id = func_param_rec.func_param_id )
1383: AND language = Userenv('LANG');
1384:
1385: /* 1. Validating Data Type. */

Line 1535: INSERT INTO ego_func_params_tl

1531: SYSDATE,
1532: G_USER_ID,
1533: G_LOGIN_ID,
1534: SYSDATE);
1535: INSERT INTO ego_func_params_tl
1536: (func_param_id,
1537: display_name,
1538: language,
1539: source_lang,

Line 1567: UPDATE ego_func_params_tl

1563: last_update_login = G_LOGIN_ID,
1564: last_update_date = SYSDATE
1565: WHERE ( func_param_id = func_param_rec.func_param_id );
1566:
1567: UPDATE ego_func_params_tl
1568: SET display_name = func_param_rec.display_name,
1569: last_updated_by = G_USER_ID,
1570: last_update_login = G_LOGIN_ID,
1571: last_update_date = SYSDATE

Line 1580: DELETE ego_func_params_tl

1576: /* No validations for DELETE transaction. */
1577: DELETE ego_func_params_b
1578: WHERE ( func_param_id = func_param_rec.func_param_id );
1579:
1580: DELETE ego_func_params_tl
1581: WHERE ( func_param_id = func_param_rec.func_param_id );
1582:
1583: DELETE ego_mappings_b
1584: WHERE ( func_param_id = func_param_rec.func_param_id );