eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_FUNCTIONS_BULKLOAD_PVT dependencies on EGO_FUNC_PARAMS_B

Line 547: ego_func_params_b table. */

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);
551: END IF;

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 550: DELETE ego_func_params_b 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;
553: END IF;
554: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'||' Exiting from the procedure');

Line 1093: FROM ego_func_params_b

1089: invalid_func_param_id := 0;
1090:
1091: SELECT internal_name
1092: INTO func_param_rec.internal_name
1093: FROM ego_func_params_b
1094: WHERE ( function_id = func_param_rec.function_id
1095: AND func_param_id = func_param_rec.func_param_id );
1096: EXCEPTION
1097: WHEN no_data_found THEN

Line 1130: FROM ego_func_params_b

1126: invalid_internal_name := 0;
1127:
1128: SELECT func_param_id
1129: INTO func_param_rec.func_param_id
1130: FROM ego_func_params_b
1131: WHERE ( function_id = func_param_rec.function_id
1132: AND internal_name = func_param_rec.internal_name );
1133: EXCEPTION
1134: WHEN no_data_found THEN

Line 1197: temporary_record ego_func_params_b%ROWTYPE;

1193: valid_data_type NUMBER(1);
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');

Line 1296: FROM ego_func_params_b

1292: /* 3. Validation for Internal Name. */
1293: BEGIN
1294: SELECT 1
1295: INTO duplicate_internal_name
1296: FROM ego_func_params_b
1297: WHERE ( function_id = func_param_rec.function_id
1298: AND internal_name = func_param_rec.internal_name );
1299: EXCEPTION
1300: WHEN no_data_found THEN

Line 1325: FROM ego_func_params_b

1321: /* 4. Validation for Sequence. */
1322: BEGIN
1323: SELECT 1
1324: INTO duplicate_sequence
1325: FROM ego_func_params_b
1326: WHERE ( function_id = func_param_rec.function_id
1327: AND SEQUENCE = func_param_rec.SEQUENCE );
1328: EXCEPTION
1329: WHEN no_data_found THEN

Line 1376: FROM ego_func_params_b

1372: ELSIF ( func_param_rec.transaction_type = G_UPDATE_TRANSACTION
1373: AND func_param_rec.process_status <> G_ERROR_RECORD ) THEN
1374: SELECT *
1375: INTO temporary_record
1376: FROM ego_func_params_b
1377: WHERE ( func_param_id = func_param_rec.func_param_id );
1378:
1379: SELECT *
1380: INTO temporary_record_tl

Line 1444: FROM ego_func_params_b

1440: ELSIF ( func_param_rec.SEQUENCE <> temporary_record.SEQUENCE) THEN
1441: BEGIN
1442: SELECT 1
1443: INTO duplicate_sequence
1444: FROM ego_func_params_b
1445: WHERE ( function_id = func_param_rec.function_id
1446: AND SEQUENCE = func_param_rec.SEQUENCE );
1447: EXCEPTION
1448: WHEN no_data_found THEN

Line 1512: INSERT INTO ego_func_params_b

1508: IF (func_param_rec.transaction_type=G_CREATE_TRANSACTION) THEN
1509: SELECT ego_func_params_s.nextval
1510: INTO func_param_rec.func_param_id
1511: FROM dual;
1512: INSERT INTO ego_func_params_b
1513: (function_id,
1514: func_param_id,
1515: SEQUENCE,
1516: internal_name,

Line 1558: UPDATE ego_func_params_b

1554: FROM fnd_languages l
1555: WHERE installed_flag IN ( 'I', 'B' );
1556:
1557: ELSIF ( func_param_rec.transaction_type = G_UPDATE_TRANSACTION ) THEN
1558: UPDATE ego_func_params_b
1559: SET SEQUENCE = func_param_rec.SEQUENCE,
1560: data_type = func_param_rec.data_type,
1561: param_type = func_param_rec.param_type,
1562: last_updated_by = G_USER_ID,

Line 1577: DELETE ego_func_params_b

1573: AND Userenv('LANG') IN ( language, source_lang );
1574:
1575: ELSIF (func_param_rec.transaction_type = G_DELETE_TRANSACTION ) THEN
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 );

Line 2028: FROM ego_func_params_b b

2024: SYSDATE
2025: FROM ego_func_params_interface i
2026: WHERE transaction_type IN ( G_UPDATE_TRANSACTION, G_DELETE_TRANSACTION )
2027: AND NOT EXISTS (SELECT *
2028: FROM ego_func_params_b b
2029: WHERE ( b.func_param_id = i.func_param_id )
2030: AND ((b.function_id = i.function_id AND i.function_id IS NOT NULL) OR
2031: (b.function_id IN (SELECT function_id FROM ego_functions_b
2032: WHERE (internal_name=i.function_internal_name))

Line 2043: FROM ego_func_params_b b

2039: UPDATE ego_func_params_interface i
2040: SET process_status = G_ERROR_RECORD,last_update_date=sysdate, last_updated_by=G_USER_ID,program_update_date=SYSDATE
2041: WHERE transaction_type IN ( G_UPDATE_TRANSACTION, G_DELETE_TRANSACTION )
2042: AND NOT EXISTS (SELECT *
2043: FROM ego_func_params_b b
2044: WHERE ( b.func_param_id = i.func_param_id )
2045: AND ((b.function_id = i.function_id AND i.function_id IS NOT NULL) OR
2046: (b.function_id IN (SELECT function_id FROM ego_functions_b
2047: WHERE (internal_name=i.function_internal_name))

Line 2106: FROM ego_func_params_b b

2102: SYSDATE
2103: FROM ego_func_params_interface i
2104: WHERE transaction_type IN ( G_UPDATE_TRANSACTION, G_DELETE_TRANSACTION )
2105: AND NOT EXISTS (SELECT internal_name
2106: FROM ego_func_params_b b
2107: WHERE ( b.internal_name = i.internal_name )
2108: AND ((b.function_id = i.function_id AND i.function_id IS NOT NULL) OR
2109: (b.function_id IN (SELECT function_id FROM ego_functions_b
2110: WHERE (internal_name=i.function_internal_name))

Line 2134: FROM ego_func_params_b b

2130: UPDATE ego_func_params_interface i
2131: SET process_status = G_ERROR_RECORD,last_update_date=sysdate, last_updated_by=G_USER_ID,program_update_date=SYSDATE
2132: WHERE transaction_type IN ( G_UPDATE_TRANSACTION, G_DELETE_TRANSACTION )
2133: AND NOT EXISTS (SELECT internal_name
2134: FROM ego_func_params_b b
2135: WHERE ( b.internal_name = i.internal_name )
2136: AND ((b.function_id = i.function_id AND i.function_id IS NOT NULL) OR
2137: (b.function_id IN (SELECT function_id FROM ego_functions_b
2138: WHERE (internal_name=i.function_internal_name))