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_INTERFACE

Line 86: DELETE FROM ego_func_params_interface WHERE (p_set_process_id IS NULL OR set_process_id=p_set_process_id)

82: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'||' Entered into the procedure');
83: x_return_status := fnd_api.G_RET_STS_SUCCESS;
84: DELETE FROM ego_functions_interface WHERE (p_set_process_id IS NULL OR set_process_id=p_set_process_id)
85: AND process_status=G_SUCCESS_RECORD;
86: DELETE FROM ego_func_params_interface WHERE (p_set_process_id IS NULL OR set_process_id=p_set_process_id)
87: AND process_status=G_SUCCESS_RECORD;
88: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'||' Exiting from the procedure');
89: EXCEPTION
90: WHEN OTHERS THEN

Line 976: -- func_param_rec - Represents a row of type ego_func_params_interface%ROWTYPE. --

972: -- a function parameter and also converts SYNC transaction to either CREATE or UPDATE, --
973: -- if the validation succeeds. --
974: -- Parameters: --
975: -- IN OUT --
976: -- func_param_rec - Represents a row of type ego_func_params_interface%ROWTYPE. --
977: ---------------------------------------------------------------------------------------------
978: PROCEDURE construct_func_param(func_param_rec IN OUT NOCOPY ego_func_params_interface%ROWTYPE)
979: IS
980: invalid_function_id NUMBER(1);

Line 978: PROCEDURE construct_func_param(func_param_rec IN OUT NOCOPY ego_func_params_interface%ROWTYPE)

974: -- Parameters: --
975: -- IN OUT --
976: -- func_param_rec - Represents a row of type ego_func_params_interface%ROWTYPE. --
977: ---------------------------------------------------------------------------------------------
978: PROCEDURE construct_func_param(func_param_rec IN OUT NOCOPY ego_func_params_interface%ROWTYPE)
979: IS
980: invalid_function_id NUMBER(1);
981: invalid_func_param_id NUMBER(1);
982: invalid_function_internal_name NUMBER(1);

Line 1187: -- func_param_rec - Represents a row of type ego_func_params_interface%ROWTYPE. --

1183: -- This procedure will perform the remaining validations (excluding the validations done --
1184: -- on key columns in construct_func_param) based on the transaction type. --
1185: -- Parameters: --
1186: -- IN OUT --
1187: -- func_param_rec - Represents a row of type ego_func_params_interface%ROWTYPE. --
1188: ---------------------------------------------------------------------------------------------
1189: PROCEDURE validate_func_param(func_param_rec IN OUT NOCOPY ego_func_params_interface%ROWTYPE)
1190: IS
1191: x_function_type ego_functions_b.function_type%TYPE;

Line 1189: PROCEDURE validate_func_param(func_param_rec IN OUT NOCOPY ego_func_params_interface%ROWTYPE)

1185: -- Parameters: --
1186: -- IN OUT --
1187: -- func_param_rec - Represents a row of type ego_func_params_interface%ROWTYPE. --
1188: ---------------------------------------------------------------------------------------------
1189: PROCEDURE validate_func_param(func_param_rec IN OUT NOCOPY ego_func_params_interface%ROWTYPE)
1190: IS
1191: x_function_type ego_functions_b.function_type%TYPE;
1192: x_lookup_code fnd_lookup_values.lookup_code%TYPE;
1193: valid_data_type NUMBER(1);

Line 1501: -- func_param_rec - Represents a row of type ego_func_params_interface%ROWTYPE. --

1497: -- This procedure will update the base table, with the data in func_param_rec, only if --
1498: -- there are no validation errors (process_status<>3), based on transaction type. --
1499: -- Parameters: --
1500: -- IN OUT --
1501: -- func_param_rec - Represents a row of type ego_func_params_interface%ROWTYPE. --
1502: ---------------------------------------------------------------------------------------------
1503: PROCEDURE transact_func_param(func_param_rec IN OUT NOCOPY ego_func_params_interface%ROWTYPE) IS
1504: l_proc_name VARCHAR2(30) := 'transact_func_param';
1505: BEGIN

Line 1503: PROCEDURE transact_func_param(func_param_rec IN OUT NOCOPY ego_func_params_interface%ROWTYPE) IS

1499: -- Parameters: --
1500: -- IN OUT --
1501: -- func_param_rec - Represents a row of type ego_func_params_interface%ROWTYPE. --
1502: ---------------------------------------------------------------------------------------------
1503: PROCEDURE transact_func_param(func_param_rec IN OUT NOCOPY ego_func_params_interface%ROWTYPE) IS
1504: l_proc_name VARCHAR2(30) := 'transact_func_param';
1505: BEGIN
1506: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'||' Entered into the procedure');
1507: IF ( func_param_rec.process_status <> G_ERROR_RECORD ) THEN

Line 1598: -- ego_func_params_interface%ROWTYPE. --

1594: -- This procedure will update the interface table back after processing the records. --
1595: -- Parameters: --
1596: -- IN OUT --
1597: -- ego_func_param_tbl_values - Represents a table of type --
1598: -- ego_func_params_interface%ROWTYPE. --
1599: ---------------------------------------------------------------------------------------------
1600: /* Bug 9701271. Changing the implementation, as reference like table(bulk_index).field in FORALL statement
1601: are not supported, before 11g release.*/
1602: PROCEDURE update_intfc_func_params(ego_func_param_tbl_values IN OUT NOCOPY ego_metadata_pub.ego_func_param_tbl_type)

Line 1617: UPDATE ego_func_params_interface

1613: END LOOP;
1614:
1615: /* Update the interface table back */
1616: FORALL i IN 1 .. ego_func_param_tbl_values.COUNT
1617: UPDATE ego_func_params_interface
1618: SET ROW = ego_func_param_tbl_values(i)
1619: WHERE ( transaction_id = transaction_id_table(i) );
1620: /* Commit after updating the interface table back. */
1621: COMMIT;

Line 1632: -- ego_func_params_interface%ROWTYPE. --

1628: -- will call the previous three functions. --
1629: -- Parameters: --
1630: -- IN OUT --
1631: -- ego_func_param_tbl_values - Represents a table of type --
1632: -- ego_func_params_interface%ROWTYPE. --
1633: -- p_commit - Indicates whether to commit the work or not. This parameter --
1634: -- has significance only in public API flow. --
1635: ---------------------------------------------------------------------------------------------
1636: PROCEDURE process_func_params(ego_func_param_tbl_values IN OUT NOCOPY ego_metadata_pub.ego_func_param_tbl_type,

Line 1679: UPDATE ego_func_params_interface

1675: IS
1676: l_proc_name VARCHAR2(30) := 'initialize_func_params';
1677: BEGIN
1678: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'||' Entered into the procedure');
1679: UPDATE ego_func_params_interface
1680: SET transaction_id = mtl_system_items_interface_s.nextval,
1681: transaction_type = Upper(transaction_type),
1682: last_update_date = SYSDATE,
1683: last_updated_by = G_USER_ID,

Line 1696: -- This procedure will read the data in chunks from ego_func_params_interface table, --

1692:
1693: ---------------------------------------------------------------------------------------------
1694: -- Procedure Name: process_func_params_conc_flow --
1695: -- This will be invoked in Concurrent Request flow. --
1696: -- This procedure will read the data in chunks from ego_func_params_interface table, --
1697: -- processes them by calling process_func_params() and then updates interface table --
1698: -- back by calling update_intfc_func_params(). --
1699: -- Parameters: --
1700: -- IN --

Line 1701: -- p_set_process_id: ID to identify the rows (in ego_func_params_interface table) to be --

1697: -- processes them by calling process_func_params() and then updates interface table --
1698: -- back by calling update_intfc_func_params(). --
1699: -- Parameters: --
1700: -- IN --
1701: -- p_set_process_id: ID to identify the rows (in ego_func_params_interface table) to be --
1702: -- processed in a batch. --
1703: ---------------------------------------------------------------------------------------------
1704: PROCEDURE process_func_params_conc_flow(p_set_process_id IN NUMBER)
1705: IS

Line 1714: FROM ego_func_params_interface

1710: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'||' Entered into the procedure');
1711:
1712: /* Bug 9671972. Return if there are no rows to process. */
1713: SELECT Count(*) INTO record_count
1714: FROM ego_func_params_interface
1715: WHERE ( (p_set_process_id IS NULL OR set_process_id = p_set_process_id)
1716: AND process_status = G_PROCESS_RECORD );
1717:
1718: IF (record_count=0) THEN

Line 1749: -- p_set_process_id: ID to identify the rows (in ego_func_params_interface table) to be --

1745: -- This will be invoked in Concurrent Request flow. --
1746: -- This procedure will do bulk validations. --
1747: -- Parameters: --
1748: -- IN --
1749: -- p_set_process_id: ID to identify the rows (in ego_func_params_interface table) to be --
1750: -- processed in a batch. --
1751: ----------------------------------------------------------------------------------------------
1752: PROCEDURE bulk_validate_func_params(p_set_process_id IN NUMBER) IS
1753: message_name fnd_new_messages.message_name%TYPE;

Line 1798: FROM ego_func_params_interface

1794: G_REQUEST_ID,
1795: G_PROGRAM_APPLICATION_ID,
1796: G_PROGRAM_ID,
1797: SYSDATE
1798: FROM ego_func_params_interface
1799: WHERE ( transaction_type NOT IN ( G_CREATE_TRANSACTION, G_UPDATE_TRANSACTION, G_SYNC_TRANSACTION, G_DELETE_TRANSACTION )
1800: OR transaction_type IS NULL )
1801: AND (p_set_process_id IS NULL OR set_process_id = p_set_process_id)
1802: AND process_status = G_PROCESS_RECORD;

Line 1804: UPDATE ego_func_params_interface

1800: OR transaction_type IS NULL )
1801: AND (p_set_process_id IS NULL OR set_process_id = p_set_process_id)
1802: AND process_status = G_PROCESS_RECORD;
1803:
1804: UPDATE ego_func_params_interface
1805: SET process_status = G_ERROR_RECORD, last_update_date=sysdate, last_updated_by=G_USER_ID,program_update_date=SYSDATE
1806: WHERE ( transaction_type NOT IN ( G_CREATE_TRANSACTION, G_UPDATE_TRANSACTION, G_SYNC_TRANSACTION, G_DELETE_TRANSACTION )
1807: OR transaction_type IS NULL )
1808: AND (p_set_process_id IS NULL OR set_process_id = p_set_process_id)

Line 1851: FROM ego_func_params_interface i

1847: G_REQUEST_ID,
1848: G_PROGRAM_APPLICATION_ID,
1849: G_PROGRAM_ID,
1850: SYSDATE
1851: FROM ego_func_params_interface i
1852: WHERE NOT EXISTS (SELECT *
1853: FROM ego_functions_b b
1854: WHERE ( b.function_id = i.function_id ))
1855: AND function_id IS NOT NULL

Line 1859: UPDATE ego_func_params_interface i

1855: AND function_id IS NOT NULL
1856: AND (p_set_process_id IS NULL OR set_process_id = p_set_process_id)
1857: AND process_status = G_PROCESS_RECORD;
1858:
1859: UPDATE ego_func_params_interface i
1860: SET process_status = G_ERROR_RECORD,last_update_date=sysdate, last_updated_by=G_USER_ID,program_update_date=SYSDATE
1861: WHERE NOT EXISTS (SELECT *
1862: FROM ego_functions_b b
1863: WHERE ( b.function_id = i.function_id ))

Line 1910: FROM ego_func_params_interface i

1906: G_REQUEST_ID,
1907: G_PROGRAM_APPLICATION_ID,
1908: G_PROGRAM_ID,
1909: SYSDATE
1910: FROM ego_func_params_interface i
1911: WHERE NOT EXISTS (SELECT internal_name
1912: FROM ego_functions_b b
1913: WHERE ( b.internal_name = i.function_internal_name )
1914: )

Line 1920: UPDATE ego_func_params_interface i

1916: AND function_internal_name IS NOT NULL
1917: AND (p_set_process_id IS NULL OR set_process_id = p_set_process_id)
1918: AND process_status = G_PROCESS_RECORD;
1919:
1920: UPDATE ego_func_params_interface i
1921: SET process_status = G_ERROR_RECORD, last_update_date=sysdate, last_updated_by=G_USER_ID,program_update_date=SYSDATE
1922: WHERE NOT EXISTS (SELECT internal_name
1923: FROM ego_functions_b b
1924: WHERE ( b.internal_name = i.function_internal_name )

Line 1971: FROM ego_func_params_interface

1967: G_REQUEST_ID,
1968: G_PROGRAM_APPLICATION_ID,
1969: G_PROGRAM_ID,
1970: SYSDATE
1971: FROM ego_func_params_interface
1972: WHERE function_id IS NULL
1973: AND function_internal_name IS NULL
1974: AND (p_set_process_id IS NULL OR set_process_id = p_set_process_id)
1975: AND process_status = G_PROCESS_RECORD;

Line 1977: UPDATE ego_func_params_interface i

1973: AND function_internal_name IS NULL
1974: AND (p_set_process_id IS NULL OR set_process_id = p_set_process_id)
1975: AND process_status = G_PROCESS_RECORD;
1976:
1977: UPDATE ego_func_params_interface i
1978: SET process_status = G_ERROR_RECORD, last_update_date=sysdate, last_updated_by=G_USER_ID,program_update_date=SYSDATE
1979: WHERE function_id IS NULL
1980: AND function_internal_name IS NULL
1981: AND (p_set_process_id IS NULL OR set_process_id = p_set_process_id)

Line 2025: FROM ego_func_params_interface i

2021: G_REQUEST_ID,
2022: G_PROGRAM_APPLICATION_ID,
2023: G_PROGRAM_ID,
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 )

Line 2039: UPDATE ego_func_params_interface i

2035: AND func_param_id IS NOT NULL
2036: AND (p_set_process_id IS NULL OR set_process_id = p_set_process_id)
2037: AND process_status = G_PROCESS_RECORD;
2038:
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

Line 2063: against ego_func_params_interface_table also. */

2059: message_text := FND_MESSAGE.GET;
2060:
2061: /* Bug 9647937. Modified the condition to validate Parameter Internal Name if it is not null
2062: and Parameter Id is null. Also, added logic to validate Parameter Internal Name
2063: against ego_func_params_interface_table also. */
2064:
2065: /* Bug 9671972. Changing the Where clause to directly compare function_internal_name
2066: instead of function_id, while validating against ego_func_params_interface_table. */
2067:

Line 2066: instead of function_id, while validating against ego_func_params_interface_table. */

2062: and Parameter Id is null. Also, added logic to validate Parameter Internal Name
2063: against ego_func_params_interface_table also. */
2064:
2065: /* Bug 9671972. Changing the Where clause to directly compare function_internal_name
2066: instead of function_id, while validating against ego_func_params_interface_table. */
2067:
2068: INSERT INTO mtl_interface_errors
2069: (unique_id,
2070: transaction_id,

Line 2103: FROM ego_func_params_interface i

2099: G_REQUEST_ID,
2100: G_PROGRAM_APPLICATION_ID,
2101: G_PROGRAM_ID,
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 )

Line 2115: FROM ego_func_params_interface ii

2111: AND i.function_id IS NULL AND i.function_internal_name IS NOT NULL)
2112: )
2113: UNION
2114: SELECT internal_name
2115: FROM ego_func_params_interface ii
2116: WHERE (ii.internal_name = i.internal_name)
2117: AND ((ii.function_id = i.function_id AND i.function_id IS NOT NULL) OR
2118: (ii.function_internal_name = i.function_internal_name
2119: AND i.function_id IS NULL AND i.function_internal_name IS NOT NULL)

Line 2130: UPDATE ego_func_params_interface i

2126: AND internal_name IS NOT NULL
2127: AND (p_set_process_id IS NULL OR set_process_id = p_set_process_id)
2128: AND process_status = G_PROCESS_RECORD;
2129:
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

Line 2143: FROM ego_func_params_interface ii

2139: AND i.function_id IS NULL AND i.function_internal_name IS NOT NULL)
2140: )
2141: UNION
2142: SELECT internal_name
2143: FROM ego_func_params_interface ii
2144: WHERE (ii.internal_name = i.internal_name)
2145: AND ((ii.function_id = i.function_id AND i.function_id IS NOT NULL) OR
2146: (ii.function_internal_name = i.function_internal_name
2147: AND i.function_id IS NULL AND i.function_internal_name IS NOT NULL)

Line 2198: FROM ego_func_params_interface

2194: G_REQUEST_ID,
2195: G_PROGRAM_APPLICATION_ID,
2196: G_PROGRAM_ID,
2197: SYSDATE
2198: FROM ego_func_params_interface
2199: WHERE transaction_type IN ( G_UPDATE_TRANSACTION, G_DELETE_TRANSACTION )
2200: AND func_param_id IS NULL
2201: AND internal_name IS NULL
2202: AND (p_set_process_id IS NULL OR set_process_id = p_set_process_id)

Line 2205: UPDATE ego_func_params_interface

2201: AND internal_name IS NULL
2202: AND (p_set_process_id IS NULL OR set_process_id = p_set_process_id)
2203: AND process_status = G_PROCESS_RECORD;
2204:
2205: UPDATE ego_func_params_interface
2206: SET process_status = G_ERROR_RECORD,last_update_date=sysdate, last_updated_by=G_USER_ID,program_update_date=SYSDATE
2207: WHERE transaction_type IN ( G_UPDATE_TRANSACTION, G_DELETE_TRANSACTION )
2208: AND func_param_id IS NULL
2209: AND internal_name IS NULL