DBA Data[Home] [Help]

APPS.EGO_GTIN_PVT dependencies on EGO_PAGE_ENTRIES_B

Line 3481: INSERT INTO EGO_PAGE_ENTRIES_B

3477: --dbms_output.put_line('after getting page ids');
3478: -- Perform Bulk insert and create page entries for each association.
3479: --dbms_output.put_line('assoc cound -' || l_AssocIds.count);
3480: FORALL i IN l_AssocIds.FIRST..l_AssocIds.LAST
3481: INSERT INTO EGO_PAGE_ENTRIES_B
3482: (
3483: PAGE_ID
3484: ,ASSOCIATION_ID
3485: ,SEQUENCE

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