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 722: p_pg_tbl IN OUT NOCOPY ego_metadata_pub.ego_pg_tbl,

718: /*This procedure is used to construct the records for page pl/sql table.
719: p_pg_tbl IN OUT NOCOPY Pages table
720: x_return_status OUT NOCOPY parameter that returns the status*/
721: PROCEDURE construct_page_tbl(
722: p_pg_tbl IN OUT NOCOPY ego_metadata_pub.ego_pg_tbl,
723: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
724: IS
725: lv_proc VARCHAR2(30) := 'construct_page_tbl';
726: BEGIN

Line 817: p_ent_tbl IN OUT NOCOPY ego_metadata_pub.ego_ent_tbl,

813: Used in the API flow.
814: p_ent_tbl IN OUT NOCOPY Page Entries table
815: x_return_status OUT NOCOPY parameter that returns the status*/
816: PROCEDURE construct_pg_entries_tbl(
817: p_ent_tbl IN OUT NOCOPY ego_metadata_pub.ego_ent_tbl,
818: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
819: IS
820: lv_proc VARCHAR2(30) := 'construct_pg_entries_tbl';
821: BEGIN

Line 1042: PROCEDURE value_to_id_page_tbl (p_pg_tbl IN OUT NOCOPY ego_metadata_pub.ego_pg_tbl,

1038: /*This procedure is used for value to ID conversion for pages.
1039: Used in the API flow.
1040: p_pg_tbl IN OUT NOCOPY Pages table
1041: x_return_status OUT NOCOPY parameter that returns the status*/
1042: PROCEDURE value_to_id_page_tbl (p_pg_tbl IN OUT NOCOPY ego_metadata_pub.ego_pg_tbl,
1043: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
1044: IS
1045: lv_proc VARCHAR2(30) := 'value_to_id_page_tbl';
1046: BEGIN

Line 1120: PROCEDURE value_to_id_pg_entries_tbl (p_ent_tbl IN OUT NOCOPY ego_metadata_pub.ego_ent_tbl,

1116: /*This procedure is used for value to ID conversion for page entries.
1117: Used in the API flow.
1118: p_ent_tbl IN OUT NOCOPY Page Entries table
1119: x_return_status OUT NOCOPY parameter that returns the status*/
1120: PROCEDURE value_to_id_pg_entries_tbl (p_ent_tbl IN OUT NOCOPY ego_metadata_pub.ego_ent_tbl,
1121: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
1122: IS
1123: lv_proc VARCHAR2(30) := 'value_to_id_pg_entries_tbl';
1124: lv_flag VARCHAR2(1);

Line 1856: PROCEDURE Additional_pg_validations (p_pg_tbl IN OUT NOCOPY ego_metadata_pub.ego_pg_tbl,

1852: /*This procedure is used to handle the additional validations for Pages.
1853: Used in the API flow.
1854: p_pg_tbl IN OUT NOCOPY Pages table
1855: x_return_status OUT NOCOPY parameter that returns the status*/
1856: PROCEDURE Additional_pg_validations (p_pg_tbl IN OUT NOCOPY ego_metadata_pub.ego_pg_tbl,
1857: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
1858: IS
1859: lv_smt NUMBER; --Statement counter
1860: lv_flag VARCHAR2(1);

Line 1962: PROCEDURE Additional_ent_validations (p_ent_tbl IN OUT NOCOPY ego_metadata_pub.ego_ent_tbl,

1958: /*This procedure is used to handle the additional validations for Page Entries
1959: Used in the API flow.
1960: p_ent_tbl IN OUT NOCOPY Page Entries table
1961: x_return_status OUT NOCOPY parameter that returns the status*/
1962: PROCEDURE Additional_ent_validations (p_ent_tbl IN OUT NOCOPY ego_metadata_pub.ego_ent_tbl,
1963: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
1964: IS
1965: lv_smt NUMBER; --Statement counter
1966: lv_flag VARCHAR2(1);

Line 2090: PROCEDURE Common_pg_validations (p_pg_tbl IN OUT NOCOPY ego_metadata_pub.ego_pg_tbl,

2086: /*This procedure is used to handle the common validations pertaining to Pages.
2087: Used in the both the flows.
2088: p_pg_tbl IN OUT NOCOPY Pages table
2089: x_return_status OUT NOCOPY parameter that returns the status*/
2090: PROCEDURE Common_pg_validations (p_pg_tbl IN OUT NOCOPY ego_metadata_pub.ego_pg_tbl,
2091: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
2092: IS
2093: lv_smt NUMBER; --Statement counter
2094: lv_proc VARCHAR2(30) := 'Common_pg_validations';

Line 2171: PROCEDURE Common_ent_validations (p_ent_tbl IN OUT NOCOPY ego_metadata_pub.ego_ent_tbl,

2167: /*This procedure is used to handle the common validations pertaining to page entries.
2168: Used in both flows.
2169: p_ent_tbl IN OUT NOCOPY Page Entries table
2170: x_return_status OUT NOCOPY parameter that returns the status*/
2171: PROCEDURE Common_ent_validations (p_ent_tbl IN OUT NOCOPY ego_metadata_pub.ego_ent_tbl,
2172: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
2173: IS
2174: lv_smt NUMBER; --Statement counter
2175: lv_proc VARCHAR2(30) := 'Common_ent_validations';

Line 2348: l_ego_pg_tbl ego_metadata_pub.ego_pg_tbl;

2344: WHERE process_status = G_PROCESS_RECORD
2345: AND (p_set_process_id IS NULL
2346: OR set_process_id = p_set_process_id);
2347:
2348: l_ego_pg_tbl ego_metadata_pub.ego_pg_tbl;
2349: l_ego_ent_tbl ego_metadata_pub.ego_ent_tbl;
2350: lv_proc VARCHAR2(30) := 'import_pg_intf';
2351: BEGIN
2352: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entered import_pg_intf.');

Line 2349: l_ego_ent_tbl ego_metadata_pub.ego_ent_tbl;

2345: AND (p_set_process_id IS NULL
2346: OR set_process_id = p_set_process_id);
2347:
2348: l_ego_pg_tbl ego_metadata_pub.ego_pg_tbl;
2349: l_ego_ent_tbl ego_metadata_pub.ego_ent_tbl;
2350: lv_proc VARCHAR2(30) := 'import_pg_intf';
2351: BEGIN
2352: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entered import_pg_intf.');
2353:

Line 2435: PROCEDURE Process_pages ( p_pg_tbl IN OUT NOCOPY ego_metadata_pub.ego_pg_tbl,

2431: p_pg_tbl IN OUT NOCOPY Pages table
2432: p_commit IN controls whether commit to be executed or not
2433: x_return_status OUT NOCOPY parameter that returns the status
2434: x_return_msg OUT NOCOPY parameter that returns the error message*/
2435: PROCEDURE Process_pages ( p_pg_tbl IN OUT NOCOPY ego_metadata_pub.ego_pg_tbl,
2436: p_commit IN BOOLEAN DEFAULT true,
2437: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
2438: IS
2439: lv_proc VARCHAR2(30) := 'Process_pages';

Line 2480: PROCEDURE Process_pg_entries (p_ent_tbl IN OUT NOCOPY ego_metadata_pub.ego_ent_tbl,

2476: p_ent_tbl IN OUT NOCOPY Pages Entries table
2477: p_commit IN controls whether commit to be executed or not
2478: x_return_status OUT NOCOPY parameter that returns the status
2479: x_return_msg OUT NOCOPY parameter that returns the error message*/
2480: PROCEDURE Process_pg_entries (p_ent_tbl IN OUT NOCOPY ego_metadata_pub.ego_ent_tbl,
2481: p_commit IN BOOLEAN DEFAULT true,
2482: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
2483: IS
2484: lv_proc VARCHAR2(30) := 'Process_pg_entries';

Line 2524: PROCEDURE Process_pg (p_pg_tbl IN OUT NOCOPY ego_metadata_pub.ego_pg_tbl,

2520: Used by both the flows.
2521: p_pg_tbl IN OUT NOCOPY Pages table
2522: x_return_status OUT NOCOPY parameter that returns the status
2523: x_return_msg OUT NOCOPY parameter that returns the error message*/
2524: PROCEDURE Process_pg (p_pg_tbl IN OUT NOCOPY ego_metadata_pub.ego_pg_tbl,
2525: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
2526: IS
2527: x_page_id NUMBER;
2528: x_errorcode NUMBER;

Line 2755: PROCEDURE Process_ent (p_ent_tbl IN OUT NOCOPY ego_metadata_pub.ego_ent_tbl,

2751: Used in both flows.
2752: p_ent_tbl IN OUT NOCOPY Page Entries table
2753: x_return_status OUT NOCOPY parameter that returns the status
2754: x_return_msg OUT NOCOPY parameter that returns the error message*/
2755: PROCEDURE Process_ent (p_ent_tbl IN OUT NOCOPY ego_metadata_pub.ego_ent_tbl,
2756: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
2757: IS
2758: x_page_id NUMBER;
2759: x_errorcode NUMBER;

Line 2999: PROCEDURE update_intf_pages (p_pg_tbl IN OUT NOCOPY ego_metadata_pub.ego_pg_tbl,

2995: Used in the interface flow.
2996: p_pg_tbl IN OUT NOCOPY Pages table
2997: x_return_status OUT NOCOPY parameter that returns the status
2998: x_return_msg OUT NOCOPY parameter that returns the error message*/
2999: PROCEDURE update_intf_pages (p_pg_tbl IN OUT NOCOPY ego_metadata_pub.ego_pg_tbl,
3000: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
3001: IS
3002: lv_proc VARCHAR2(30) := 'update_intf_pages';
3003: trans_id dbms_sql.number_table;

Line 3035: PROCEDURE update_intf_pg_entries (p_ent_tbl IN OUT NOCOPY ego_metadata_pub.ego_ent_tbl,

3031: Used in the interface flow.
3032: p_ent_tbl IN OUT NOCOPY Page Entries table
3033: x_return_status OUT NOCOPY parameter that returns the status
3034: x_return_msg OUT NOCOPY parameter that returns the error message*/
3035: PROCEDURE update_intf_pg_entries (p_ent_tbl IN OUT NOCOPY ego_metadata_pub.ego_ent_tbl,
3036: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
3037: IS
3038: lv_proc VARCHAR2(30) := 'update_intf_pg_entries';
3039: trans_id dbms_sql.number_table;

Line 3138: p_pg_tbl IN OUT NOCOPY ego_metadata_pub.ego_pg_tbl,

3134: p_pg_tbl IN OUT NOCOPY Pages plsql table
3135: x_return_status OUT NOCOPY parameter that returns the status
3136: x_return_msg OUT NOCOPY parameter that returns the error message*/
3137: PROCEDURE handle_null_pg(
3138: p_pg_tbl IN OUT NOCOPY ego_metadata_pub.ego_pg_tbl,
3139: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
3140: IS
3141: lv_sequence NUMBER;
3142: /* Fix for bug 12356534 - changed the width of below vars from 40chars to match their columns in EGO_PAGES_TL */

Line 3209: p_ent_tbl IN OUT NOCOPY ego_metadata_pub.ego_ent_tbl,

3205: p_ent_tbl IN OUT NOCOPY Page Entries plsql table
3206: x_return_status OUT NOCOPY parameter that returns the status
3207: x_return_msg OUT NOCOPY parameter that returns the error message*/
3208: PROCEDURE handle_null_pg_entries(
3209: p_ent_tbl IN OUT NOCOPY ego_metadata_pub.ego_ent_tbl,
3210: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
3211: IS
3212: lv_sequence NUMBER;
3213: lv_proc VARCHAR2(30) := 'handle_null_pg_entries';