DBA Data[Home] [Help]

APPS.EGO_GTIN_PVT dependencies on EGO_PAGES_TL

Line 2909: TYPE t_PageNameTbl IS TABLE OF EGO_PAGES_TL.DISPLAY_NAME%TYPE INDEX BY BINARY_INTEGER;

2905:
2906: IS
2907:
2908: TYPE t_NumberTbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2909: TYPE t_PageNameTbl IS TABLE OF EGO_PAGES_TL.DISPLAY_NAME%TYPE INDEX BY BINARY_INTEGER;
2910: TYPE t_AttrGroupNameTbl IS TABLE OF EGO_FND_DSC_FLX_CTX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE INDEX BY BINARY_INTEGER;
2911: TYPE t_AttrGroupTypeTbl IS TABLE OF EGO_FND_DSC_FLX_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME%TYPE INDEX BY BINARY_INTEGER;
2912:
2913: -- CONSTANTS

Line 3348: INSERT INTO EGO_PAGES_TL

3344: WHERE message_name = l_PageNames(i)
3345: AND application_id = G_EGO_APP_ID
3346: AND language_code = USERENV('LANG');
3347: --dbms_output.put_line('inserting...');
3348: INSERT INTO EGO_PAGES_TL
3349: (
3350: PAGE_ID
3351: ,DISPLAY_NAME
3352: ,LANGUAGE

Line 3642: FROM EGO_FND_DSC_FLX_CTX_EXT EXT, EGO_OBJ_AG_ASSOCS_B ASOC, EGO_PAGE_ENTRIES_B PGE, EGO_PAGES_TL PT

3638: l_page_disp_name VARCHAR2(4000);
3639: BEGIN
3640: SELECT PT.PAGE_ID, PT.DISPLAY_NAME
3641: INTO l_page_id, l_page_disp_name
3642: FROM EGO_FND_DSC_FLX_CTX_EXT EXT, EGO_OBJ_AG_ASSOCS_B ASOC, EGO_PAGE_ENTRIES_B PGE, EGO_PAGES_TL PT
3643: WHERE EXT.ATTR_GROUP_ID = ASOC.ATTR_GROUP_ID
3644: AND EXT.APPLICATION_ID = 431
3645: AND EXT.DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
3646: AND EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name