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_FUNCTIONS_INTERFACE

Line 12: FROM ego_functions_interface

8:
9: CURSOR ego_func_tbl(
10: c_set_process_id NUMBER) IS
11: SELECT *
12: FROM ego_functions_interface
13: WHERE ( (c_set_process_id IS NULL OR set_process_id = c_set_process_id)
14: AND process_status = G_PROCESS_RECORD );
15:
16: CURSOR ego_func_param_tbl(

Line 44: G_FUNCTIONS_TAB CONSTANT VARCHAR2(50) := 'EGO_FUNCTIONS_INTERFACE';

40: G_NULL_NUM CONSTANT NUMBER := fnd_api.G_NULL_NUM;
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';

Line 59: -- p_set_process_id: ID to identify the rows (in ego_functions_interface table) to be --

55: -- This is the main procedure that will be called while running Matadata Import Concurrent --
56: -- Program, to process Functions and Function Parameters. --
57: -- Parameters: --
58: -- IN --
59: -- p_set_process_id: ID to identify the rows (in ego_functions_interface table) to be --
60: -- processed in a batch. --
61: -- OUT --
62: -- x_return_status: Return status. Can be S or U (Unexpected Error). --
63: -- x_return_msg: Stores the error message, if unexpected error occurs. --

Line 75: -- p_set_process_id: ID to identify the rows (in ego_functions_interface table) that --

71: -- This procedure will be called at end by Matadata Import Concurrent Program, --
72: -- to delete processed rows from Functions and Function Parameters interface tables. --
73: -- Parameters: --
74: -- IN --
75: -- p_set_process_id: ID to identify the rows (in ego_functions_interface table) that --
76: -- belongs to a particular batch. --
77: -- OUT --
78: -- x_return_status: Return status. Can be S or U (Unexpected Error). --
79: -- x_return_msg: Stores the error message, if unexpected error occurs. --

Line 90: -- p_set_process_id: ID to identify the rows (in ego_functions_interface table) that --

86: -- Procedure Name: initialize_functions --
87: -- This procedure will intialize functions interface table with by updating the --
88: -- "WHO" columns, transaction_id and convering the transction_type to upper case. --
89: -- IN --
90: -- p_set_process_id: ID to identify the rows (in ego_functions_interface table) that --
91: -- belongs to a particular batch. --
92: ---------------------------------------------------------------------------------------------
93: PROCEDURE initialize_functions(p_set_process_id IN NUMBER);
94:

Line 102: -- func_header_rec - Represents a row of type ego_functions_interface%ROWTYPE. --

98: -- a function and also converts SYNC transaction to either CREATE or UPDATE, --
99: -- if the validation succeeds. --
100: -- Parameters: --
101: -- IN OUT --
102: -- func_header_rec - Represents a row of type ego_functions_interface%ROWTYPE. --
103: ---------------------------------------------------------------------------------------------
104: PROCEDURE construct_function(func_header_rec IN OUT NOCOPY ego_functions_interface%ROWTYPE);
105:
106: ---------------------------------------------------------------------------------------------

Line 104: PROCEDURE construct_function(func_header_rec IN OUT NOCOPY ego_functions_interface%ROWTYPE);

100: -- Parameters: --
101: -- IN OUT --
102: -- func_header_rec - Represents a row of type ego_functions_interface%ROWTYPE. --
103: ---------------------------------------------------------------------------------------------
104: PROCEDURE construct_function(func_header_rec IN OUT NOCOPY ego_functions_interface%ROWTYPE);
105:
106: ---------------------------------------------------------------------------------------------
107: -- Procedure Name: validate_function --
108: -- This procedure will perform the remaining validations (excluding the validations done --

Line 112: -- func_header_rec - Represents a row of type ego_functions_interface%ROWTYPE. --

108: -- This procedure will perform the remaining validations (excluding the validations done --
109: -- on key columns in construct_function) based on the transaction type. --
110: -- Parameters: --
111: -- IN OUT --
112: -- func_header_rec - Represents a row of type ego_functions_interface%ROWTYPE. --
113: ---------------------------------------------------------------------------------------------
114: PROCEDURE validate_function(func_header_rec IN OUT NOCOPY ego_functions_interface%ROWTYPE);
115:
116: ---------------------------------------------------------------------------------------------

Line 114: PROCEDURE validate_function(func_header_rec IN OUT NOCOPY ego_functions_interface%ROWTYPE);

110: -- Parameters: --
111: -- IN OUT --
112: -- func_header_rec - Represents a row of type ego_functions_interface%ROWTYPE. --
113: ---------------------------------------------------------------------------------------------
114: PROCEDURE validate_function(func_header_rec IN OUT NOCOPY ego_functions_interface%ROWTYPE);
115:
116: ---------------------------------------------------------------------------------------------
117: -- Procedure Name: transact_function --
118: -- This procedure will update the base table, with the data in func_header_rec, only if --

Line 122: -- func_header_rec - Represents a row of type ego_functions_interface%ROWTYPE. --

118: -- This procedure will update the base table, with the data in func_header_rec, only if --
119: -- there are no validation errors (process_status<>3), based on transaction type. --
120: -- Parameters: --
121: -- IN OUT --
122: -- func_header_rec - Represents a row of type ego_functions_interface%ROWTYPE. --
123: ---------------------------------------------------------------------------------------------
124: PROCEDURE transact_function(func_header_rec IN OUT NOCOPY ego_functions_interface%ROWTYPE);
125:
126: ---------------------------------------------------------------------------------------------

Line 124: PROCEDURE transact_function(func_header_rec IN OUT NOCOPY ego_functions_interface%ROWTYPE);

120: -- Parameters: --
121: -- IN OUT --
122: -- func_header_rec - Represents a row of type ego_functions_interface%ROWTYPE. --
123: ---------------------------------------------------------------------------------------------
124: PROCEDURE transact_function(func_header_rec IN OUT NOCOPY ego_functions_interface%ROWTYPE);
125:
126: ---------------------------------------------------------------------------------------------
127: -- Procedure Name: process_functions --
128: -- This procedure will process all the functions one by one. Technically, it will call the --

Line 132: -- ego_func_tbl_values - Represents a table of type ego_functions_interface%ROWTYPE. --

128: -- This procedure will process all the functions one by one. Technically, it will call the --
129: -- previous three functions. --
130: -- Parameters: --
131: -- IN OUT --
132: -- ego_func_tbl_values - Represents a table of type ego_functions_interface%ROWTYPE. --
133: -- p_commit - Indicates whether to commit the work or not. This parameter --
134: -- has significance only in public API flow. --
135: ---------------------------------------------------------------------------------------------
136: PROCEDURE process_functions(ego_func_tbl_values IN OUT NOCOPY ego_metadata_pub.ego_function_tbl_type,

Line 145: -- ego_func_tbl_values - Represents a table of type ego_functions_interface%ROWTYPE. --

141: -- This will be invoked in Concurrent Request flow. --
142: -- This procedure will update the interface table back after processing the records. --
143: -- Parameters: --
144: -- IN OUT --
145: -- ego_func_tbl_values - Represents a table of type ego_functions_interface%ROWTYPE. --
146: ---------------------------------------------------------------------------------------------
147: PROCEDURE update_intfc_functions(ego_func_tbl_values IN OUT NOCOPY ego_metadata_pub.ego_function_tbl_type); /* Bug 9701271. */
148:
149: ---------------------------------------------------------------------------------------------

Line 152: -- This procedure will read the data in chunks from ego_functions_interface table, --

148:
149: ---------------------------------------------------------------------------------------------
150: -- Procedure Name: process_functions_conc_flow --
151: -- This will be invoked in Concurrent Request flow. --
152: -- This procedure will read the data in chunks from ego_functions_interface table, --
153: -- processes them by calling process_functions() and then updates interface table --
154: -- back by calling update_intfc_functions(). --
155: -- Parameters: --
156: -- IN --

Line 157: -- p_set_process_id: ID to identify the rows (in ego_functions_interface table) to be --

153: -- processes them by calling process_functions() and then updates interface table --
154: -- back by calling update_intfc_functions(). --
155: -- Parameters: --
156: -- IN --
157: -- p_set_process_id: ID to identify the rows (in ego_functions_interface table) to be --
158: -- processed in a batch. --
159: ---------------------------------------------------------------------------------------------
160: PROCEDURE process_functions_conc_flow(p_set_process_id IN NUMBER);
161:

Line 168: -- p_set_process_id: ID to identify the rows (in ego_functions_interface table) to be --

164: -- This will be invoked in Concurrent Request flow. --
165: -- This procedure will do bulk validations. --
166: -- Parameters: --
167: -- IN --
168: -- p_set_process_id: ID to identify the rows (in ego_functions_interface table) to be --
169: -- processed in a batch. --
170: ----------------------------------------------------------------------------------------------
171: PROCEDURE bulk_validate_functions(p_set_process_id IN NUMBER);
172:

Line 178: -- p_set_process_id: ID to identify the rows (in ego_functions_interface table) that --

174: -- Procedure Name: initialize_func_params --
175: -- This procedure will intialize function parameters interface table with by updating the --
176: -- "WHO" columns, transaction_id and convering the transction_type to upper case. --
177: -- IN --
178: -- p_set_process_id: ID to identify the rows (in ego_functions_interface table) that --
179: -- belongs to a particular batch. --
180: ---------------------------------------------------------------------------------------------
181: PROCEDURE initialize_func_params(p_set_process_id IN NUMBER);
182: