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 19: FROM ego_func_params_interface

15:
16: CURSOR ego_func_param_tbl(
17: c_set_process_id NUMBER) IS
18: SELECT *
19: FROM ego_func_params_interface
20: WHERE ( (c_set_process_id IS NULL OR set_process_id = c_set_process_id)
21: AND process_status = G_PROCESS_RECORD );
22:
23: /* Constants for transaction types. */

Line 45: G_FUNC_PARAMS_TAB CONSTANT VARCHAR2(50) := 'EGO_FUNC_PARAMS_INTERFACE';

41: G_NULL_CHAR CONSTANT VARCHAR2(1) := fnd_api.G_NULL_CHAR;
42:
43: /* Constants for error handling. */
44: G_FUNCTIONS_TAB CONSTANT VARCHAR2(50) := 'EGO_FUNCTIONS_INTERFACE';
45: G_FUNC_PARAMS_TAB CONSTANT VARCHAR2(50) := 'EGO_FUNC_PARAMS_INTERFACE';
46: G_BO_IDENTIFIER_ICC CONSTANT VARCHAR2(30) := 'ICC';
47: G_ENTITY_ICC_FN CONSTANT VARCHAR2(30) := 'ICC_FUNCTION';
48: G_ENTITY_ICC_FN_PARAM CONSTANT VARCHAR2(30) := 'ICC_FN_PARAM';
49:

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

186: -- a function parameter and also converts SYNC transaction to either CREATE or UPDATE, --
187: -- if the validation succeeds. --
188: -- Parameters: --
189: -- IN OUT --
190: -- func_param_rec - Represents a row of type ego_func_params_interface%ROWTYPE. --
191: ---------------------------------------------------------------------------------------------
192: PROCEDURE construct_func_param(func_param_rec IN OUT NOCOPY ego_func_params_interface%ROWTYPE);
193:
194: ---------------------------------------------------------------------------------------------

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

188: -- Parameters: --
189: -- IN OUT --
190: -- func_param_rec - Represents a row of type ego_func_params_interface%ROWTYPE. --
191: ---------------------------------------------------------------------------------------------
192: PROCEDURE construct_func_param(func_param_rec IN OUT NOCOPY ego_func_params_interface%ROWTYPE);
193:
194: ---------------------------------------------------------------------------------------------
195: -- Procedure Name: validate_func_param --
196: -- This procedure will perform the remaining validations (excluding the validations done --

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

196: -- This procedure will perform the remaining validations (excluding the validations done --
197: -- on key columns in construct_func_param) based on the transaction type. --
198: -- Parameters: --
199: -- IN OUT --
200: -- func_param_rec - Represents a row of type ego_func_params_interface%ROWTYPE. --
201: ---------------------------------------------------------------------------------------------
202: PROCEDURE validate_func_param(func_param_rec IN OUT NOCOPY ego_func_params_interface%ROWTYPE);
203:
204: ---------------------------------------------------------------------------------------------

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

198: -- Parameters: --
199: -- IN OUT --
200: -- func_param_rec - Represents a row of type ego_func_params_interface%ROWTYPE. --
201: ---------------------------------------------------------------------------------------------
202: PROCEDURE validate_func_param(func_param_rec IN OUT NOCOPY ego_func_params_interface%ROWTYPE);
203:
204: ---------------------------------------------------------------------------------------------
205: -- Procedure Name: transact_func_param --
206: -- This procedure will update the base table, with the data in func_param_rec, only if --

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

206: -- This procedure will update the base table, with the data in func_param_rec, only if --
207: -- there are no validation errors (process_status<>3), based on transaction type. --
208: -- Parameters: --
209: -- IN OUT --
210: -- func_param_rec - Represents a row of type ego_func_params_interface%ROWTYPE. --
211: ---------------------------------------------------------------------------------------------
212: PROCEDURE transact_func_param(func_param_rec IN OUT NOCOPY ego_func_params_interface%ROWTYPE);
213:
214: ---------------------------------------------------------------------------------------------

Line 212: PROCEDURE transact_func_param(func_param_rec IN OUT NOCOPY ego_func_params_interface%ROWTYPE);

208: -- Parameters: --
209: -- IN OUT --
210: -- func_param_rec - Represents a row of type ego_func_params_interface%ROWTYPE. --
211: ---------------------------------------------------------------------------------------------
212: PROCEDURE transact_func_param(func_param_rec IN OUT NOCOPY ego_func_params_interface%ROWTYPE);
213:
214: ---------------------------------------------------------------------------------------------
215: -- Procedure Name: process_func_params --
216: -- This procedure will process all the function parameters one by one. Technically, it --

Line 221: -- ego_func_params_interface%ROWTYPE. --

217: -- will call the previous three functions. --
218: -- Parameters: --
219: -- IN OUT --
220: -- ego_func_param_tbl_values - Represents a table of type --
221: -- ego_func_params_interface%ROWTYPE. --
222: -- p_commit - Indicates whether to commit the work or not. This parameter --
223: -- has significance only in public API flow. --
224: ---------------------------------------------------------------------------------------------
225: PROCEDURE process_func_params(ego_func_param_tbl_values IN OUT NOCOPY ego_metadata_pub.ego_func_param_tbl_type,

Line 235: -- ego_func_params_interface%ROWTYPE. --

231: -- This procedure will update the interface table back after processing the records. --
232: -- Parameters: --
233: -- IN OUT --
234: -- ego_func_param_tbl_values - Represents a table of type --
235: -- ego_func_params_interface%ROWTYPE. --
236: ---------------------------------------------------------------------------------------------
237: PROCEDURE update_intfc_func_params(ego_func_param_tbl_values IN OUT NOCOPY ego_metadata_pub.ego_func_param_tbl_type); /* Bug 9701271. */
238:
239: ---------------------------------------------------------------------------------------------

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

238:
239: ---------------------------------------------------------------------------------------------
240: -- Procedure Name: process_func_params_conc_flow --
241: -- This will be invoked in Concurrent Request flow. --
242: -- This procedure will read the data in chunks from ego_func_params_interface table, --
243: -- processes them by calling process_func_params() and then updates interface table --
244: -- back by calling update_intfc_func_params(). --
245: -- Parameters: --
246: -- IN --

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

243: -- processes them by calling process_func_params() and then updates interface table --
244: -- back by calling update_intfc_func_params(). --
245: -- Parameters: --
246: -- IN --
247: -- p_set_process_id: ID to identify the rows (in ego_func_params_interface table) to be --
248: -- processed in a batch. --
249: ---------------------------------------------------------------------------------------------
250: PROCEDURE process_func_params_conc_flow(p_set_process_id IN NUMBER);
251:

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

254: -- This will be invoked in Concurrent Request flow. --
255: -- This procedure will do bulk validations. --
256: -- Parameters: --
257: -- IN --
258: -- p_set_process_id: ID to identify the rows (in ego_func_params_interface table) to be --
259: -- processed in a batch. --
260: ----------------------------------------------------------------------------------------------
261: PROCEDURE bulk_validate_func_params(p_set_process_id IN NUMBER);
262: END EGO_FUNCTIONS_BULKLOAD_PVT;