61: END IF;
62:
63: --get the unique page content id from the Oracle Sequence
64: /* Commented for bug 3866224 to remove hard coded schema reference and modified as below
65: SELECT pa.pa_page_contents_s.nextval */
66: SELECT pa_page_contents_s.nextval
67: INTO l_content_id
68: FROM DUAL;
69:
62:
63: --get the unique page content id from the Oracle Sequence
64: /* Commented for bug 3866224 to remove hard coded schema reference and modified as below
65: SELECT pa.pa_page_contents_s.nextval */
66: SELECT pa_page_contents_s.nextval
67: INTO l_content_id
68: FROM DUAL;
69:
70: PA_PAGE_CONTENTS_PKG.INSERT_PAGE_CONTENTS_ROW (