APPS.EGO_PAGES_BULKLOAD_PVT dependencies on EGO_PAGES_V

Line 542: FROM ego_pages_v

538: x_return_status := G_RET_STS_SUCCESS;
539:
540: UPDATE ego_pages_interface epi
541: SET (internal_name, classification_code) = (SELECT internal_name, classification_code
542: FROM ego_pages_v
543: WHERE page_id = epi.page_id),
544: last_updated_by = G_USER_ID,
545: last_update_date = SYSDATE,
546: last_update_login = G_LOGIN_ID

Line 737: FROM ego_pages_v

733: /*Set the Page internal name when the page id is given*/
734: IF (p_pg_tbl(i).page_id IS NOT NULL) THEN
735: BEGIN
736: SELECT internal_name, classification_code INTO p_pg_tbl(i).internal_name, p_pg_tbl(i).classification_code
737: FROM ego_pages_v
738: WHERE page_id = p_pg_tbl(i).page_id;
739: EXCEPTION
740: WHEN NO_DATA_FOUND THEN
741: x_return_status := G_RET_STS_ERROR;

Line 832: FROM ego_pages_v

828: /*Set the Page internal name when the page id is given*/
829: IF (p_ent_tbl(i).page_id IS NOT NULL) THEN
830: BEGIN
831: SELECT internal_name, classification_code INTO p_ent_tbl(i).internal_name, p_ent_tbl(i).classification_code
832: FROM ego_pages_v
833: WHERE page_id = p_ent_tbl(i).page_id;
834: EXCEPTION
835: WHEN NO_DATA_FOUND THEN
836: x_return_status := G_RET_STS_ERROR;