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_PAGES_BULKLOAD_PVT dependencies on EGO_METADATA_PUB

Line 111: p_pg_tbl IN OUT NOCOPY ego_metadata_pub.ego_pg_tbl,

107: p_pg_tbl IN OUT NOCOPY Pages table
108: x_return_status OUT NOCOPY parameter that returns the status
109: x_return_msg OUT NOCOPY parameter that returns the error message*/
110: PROCEDURE construct_page_tbl(
111: p_pg_tbl IN OUT NOCOPY ego_metadata_pub.ego_pg_tbl,
112: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
113:
114: /*This procedure is used sed to construct the records for page entries pl/sql table.
115: Used in the API flow.

Line 120: p_ent_tbl IN OUT NOCOPY ego_metadata_pub.ego_ent_tbl,

116: p_ent_tbl IN OUT NOCOPY Page Entries table
117: x_return_status OUT NOCOPY parameter that returns the status
118: x_return_msg OUT NOCOPY parameter that returns the error message*/
119: PROCEDURE construct_pg_entries_tbl(
120: p_ent_tbl IN OUT NOCOPY ego_metadata_pub.ego_ent_tbl,
121: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
122:
123:
124: /*This procedure is used for value to ID conversion for pages.

Line 130: p_pg_tbl IN OUT NOCOPY ego_metadata_pub.ego_pg_tbl,

126: p_pg_tbl IN OUT NOCOPY Pages table
127: x_return_status OUT NOCOPY parameter that returns the status
128: x_return_msg OUT NOCOPY parameter that returns the error message*/
129: PROCEDURE value_to_id_page_tbl(
130: p_pg_tbl IN OUT NOCOPY ego_metadata_pub.ego_pg_tbl,
131: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
132:
133: /*This procedure is used for value to ID conversion for page entries.
134: Used in the API flow.

Line 139: p_ent_tbl IN OUT NOCOPY ego_metadata_pub.ego_ent_tbl,

135: p_ent_tbl IN OUT NOCOPY Page Entries table
136: x_return_status OUT NOCOPY parameter that returns the status
137: x_return_msg OUT NOCOPY parameter that returns the error message*/
138: PROCEDURE value_to_id_pg_entries_tbl(
139: p_ent_tbl IN OUT NOCOPY ego_metadata_pub.ego_ent_tbl,
140: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
141:
142: /*This procedure is used for bulk validation of the pages.
143: Used in the interface flow.

Line 163: p_pg_tbl IN OUT NOCOPY ego_metadata_pub.ego_pg_tbl,

159: p_pg_tbl IN OUT NOCOPY Pages table
160: x_return_status OUT NOCOPY parameter that returns the status
161: x_return_msg OUT NOCOPY parameter that returns the error message*/
162: PROCEDURE additional_pg_validations(
163: p_pg_tbl IN OUT NOCOPY ego_metadata_pub.ego_pg_tbl,
164: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
165:
166:
167: /*This procedure is used to handle the additional validations for Page Entries

Line 173: p_ent_tbl IN OUT NOCOPY ego_metadata_pub.ego_ent_tbl,

169: p_ent_tbl IN OUT NOCOPY Page Entries table
170: x_return_status OUT NOCOPY parameter that returns the status
171: x_return_msg OUT NOCOPY parameter that returns the error message*/
172: PROCEDURE additional_ent_validations(
173: p_ent_tbl IN OUT NOCOPY ego_metadata_pub.ego_ent_tbl,
174: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
175:
176:
177: /*This procedure is used to handle the common validations pertaining to Pages.

Line 183: p_pg_tbl IN OUT NOCOPY ego_metadata_pub.ego_pg_tbl,

179: p_pg_tbl IN OUT NOCOPY Pages table
180: x_return_status OUT NOCOPY parameter that returns the status
181: x_return_msg OUT NOCOPY parameter that returns the error message*/
182: PROCEDURE common_pg_validations(
183: p_pg_tbl IN OUT NOCOPY ego_metadata_pub.ego_pg_tbl,
184: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
185:
186:
187: /*This procedure is used to handle the common validations pertaining to page entries.

Line 193: p_ent_tbl IN OUT NOCOPY ego_metadata_pub.ego_ent_tbl,

189: p_ent_tbl IN OUT NOCOPY Page Entries table
190: x_return_status OUT NOCOPY parameter that returns the status
191: x_return_msg OUT NOCOPY parameter that returns the error message*/
192: PROCEDURE common_ent_validations(
193: p_ent_tbl IN OUT NOCOPY ego_metadata_pub.ego_ent_tbl,
194: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
195:
196:
197: /*This is the main procedure that is called by the interface flow.

Line 213: p_pg_tbl IN OUT NOCOPY ego_metadata_pub.ego_pg_tbl,

209: p_commit IN controls whether commit to be executed or not
210: x_return_status OUT NOCOPY parameter that returns the status
211: x_return_msg OUT NOCOPY parameter that returns the error message*/
212: PROCEDURE Process_pages(
213: p_pg_tbl IN OUT NOCOPY ego_metadata_pub.ego_pg_tbl,
214: p_commit IN BOOLEAN DEFAULT true,
215: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
216:
217:

Line 224: p_ent_tbl IN OUT NOCOPY ego_metadata_pub.ego_ent_tbl,

220: p_commit IN controls whether commit to be executed or not
221: x_return_status OUT NOCOPY parameter that returns the status
222: x_return_msg OUT NOCOPY parameter that returns the error message*/
223: PROCEDURE Process_pg_entries(
224: p_ent_tbl IN OUT NOCOPY ego_metadata_pub.ego_ent_tbl,
225: p_commit IN BOOLEAN DEFAULT true,
226: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
227:
228:

Line 235: p_pg_tbl IN OUT NOCOPY ego_metadata_pub.ego_pg_tbl,

231: p_pg_tbl IN OUT NOCOPY Pages table
232: x_return_status OUT NOCOPY parameter that returns the status
233: x_return_msg OUT NOCOPY parameter that returns the error message*/
234: PROCEDURE process_pg(
235: p_pg_tbl IN OUT NOCOPY ego_metadata_pub.ego_pg_tbl,
236: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
237:
238:
239: /*This procedure is used to process the page entries.

Line 245: p_ent_tbl IN OUT NOCOPY ego_metadata_pub.ego_ent_tbl,

241: p_ent_tbl IN OUT NOCOPY Page Entries table
242: x_return_status OUT NOCOPY parameter that returns the status
243: x_return_msg OUT NOCOPY parameter that returns the error message*/
244: PROCEDURE process_ent(
245: p_ent_tbl IN OUT NOCOPY ego_metadata_pub.ego_ent_tbl,
246: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
247:
248: /*This procedure is used to update the Pages interface table.
249: Used in the interface flow.

Line 254: p_pg_tbl IN OUT NOCOPY ego_metadata_pub.ego_pg_tbl,

250: p_pg_tbl IN OUT NOCOPY Pages table
251: x_return_status OUT NOCOPY parameter that returns the status
252: x_return_msg OUT NOCOPY parameter that returns the error message*/
253: PROCEDURE update_intf_pages(
254: p_pg_tbl IN OUT NOCOPY ego_metadata_pub.ego_pg_tbl,
255: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
256:
257:
258: /*This procedure is used to update the page entries interface table.

Line 264: p_ent_tbl IN OUT NOCOPY ego_metadata_pub.ego_ent_tbl,

260: p_ent_tbl IN OUT NOCOPY Page Entries table
261: x_return_status OUT NOCOPY parameter that returns the status
262: x_return_msg OUT NOCOPY parameter that returns the error message*/
263: PROCEDURE update_intf_pg_entries(
264: p_ent_tbl IN OUT NOCOPY ego_metadata_pub.ego_ent_tbl,
265: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
266:
267: /*This procedure is used to delete processed records from the pages interface
268: Used in the interface flow.

Line 292: p_pg_tbl IN OUT NOCOPY ego_metadata_pub.ego_pg_tbl,

288: p_pg_tbl IN OUT NOCOPY Pages plsql table
289: x_return_status OUT NOCOPY parameter that returns the status
290: x_return_msg OUT NOCOPY parameter that returns the error message*/
291: PROCEDURE handle_null_pg(
292: p_pg_tbl IN OUT NOCOPY ego_metadata_pub.ego_pg_tbl,
293: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
294:
295: /*This procedure is used in the update flow to handle null values for PG Entries
296: Used in the interface and API flow.

Line 301: p_ent_tbl IN OUT NOCOPY ego_metadata_pub.ego_ent_tbl,

297: p_ent_tbl IN OUT NOCOPY Page Entries plsql table
298: x_return_status OUT NOCOPY parameter that returns the status
299: x_return_msg OUT NOCOPY parameter that returns the error message*/
300: PROCEDURE handle_null_pg_entries(
301: p_ent_tbl IN OUT NOCOPY ego_metadata_pub.ego_ent_tbl,
302: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
303:
304: /*This procedure will log debug messages
305: x_msg IN Input message name*/