APPS.EGO_GTIN_PVT dependencies on EGO_PAGES_B

Line 3261: FROM EGO_PAGES_B

3257: -- get the sequence for this page
3258: l_page_sequence := 0;
3259: BEGIN
3260: SELECT max(sequence) INTO l_page_sequence
3261: FROM EGO_PAGES_B
3262: WHERE object_id = l_object_id
3263: AND classification_code = l_classification_code;
3264:
3265: IF( l_page_sequence IS NULL ) THEN

Line 3276: INSERT INTO EGO_PAGES_B

3272:
3273: -- We have to create all 5 pages for this catalog group.
3274: -- Perform bulk insert for these 5 pages.
3275: FORALL i IN l_PageNames.FIRST..l_PageNames.LAST
3276: INSERT INTO EGO_PAGES_B
3277: (
3278: PAGE_ID
3279: ,OBJECT_ID
3280: ,CLASSIFICATION_CODE

Line 3315: FROM EGO_PAGES_B

3311: -- TL table requires Page_Id, so perform bulk collect to get page ids for
3312: -- the inserted pages.
3313: SELECT page_id, internal_name
3314: BULK COLLECT INTO l_TmpPageIds, l_TmpPageNames
3315: FROM EGO_PAGES_B
3316: WHERE OBJECT_ID = l_object_id
3317: AND CLASSIFICATION_CODE = l_classification_code
3318: AND SEQUENCE > l_page_sequence -- Need to get only newly inserted rows
3319: ORDER BY SEQUENCE; -- Make sure to get it in the order in which have been inserted