APPS.EGO_PAGES_BULKLOAD_PVT dependencies on EGO_PAGES_TL

Line 3142: /* Fix for bug 12356534 - changed the width of below vars from 40chars to match their columns in EGO_PAGES_TL */

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 */
3143: lv_display_name EGO_PAGES_TL.DISPLAY_NAME%TYPE;
3144: lv_description EGO_PAGES_TL.DESCRIPTION%TYPE;
3145: lv_proc VARCHAR2(30) := 'handle_null_pg';
3146: BEGIN

Line 3143: lv_display_name EGO_PAGES_TL.DISPLAY_NAME%TYPE;

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 */
3143: lv_display_name EGO_PAGES_TL.DISPLAY_NAME%TYPE;
3144: lv_description EGO_PAGES_TL.DESCRIPTION%TYPE;
3145: lv_proc VARCHAR2(30) := 'handle_null_pg';
3146: BEGIN
3147: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entering handle_null_pg');

Line 3144: lv_description EGO_PAGES_TL.DESCRIPTION%TYPE;

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 */
3143: lv_display_name EGO_PAGES_TL.DISPLAY_NAME%TYPE;
3144: lv_description EGO_PAGES_TL.DESCRIPTION%TYPE;
3145: lv_proc VARCHAR2(30) := 'handle_null_pg';
3146: BEGIN
3147: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entering handle_null_pg');
3148:

Line 3164: FROM EGO_PAGES_TL

3160:
3161: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Smt 2');
3162:
3163: SELECT display_name, description INTO lv_display_name, lv_description
3164: FROM EGO_PAGES_TL
3165: WHERE page_id = p_pg_tbl(i).page_id
3166: AND USERENV('LANG') = LANGUAGE;
3167:
3168: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Smt 3');