APPS.PA_PWP_NOTIFICATION dependencies on PA_PAGE_CONTENTS

Line 557: PA_PAGE_CONTENTS_PUB.CREATE_PAGE_CONTENTS(p_init_msg_list => fnd_api.g_false

553:
554: x_content_id := 0;
555:
556: log_message('Generate_PWP_Notify_Page: Before Calling CREATE_PAGE_CONTENTS: p_inv_info_rec.ra_id=' || p_inv_info_rec.ra_id || '*', 3);
557: PA_PAGE_CONTENTS_PUB.CREATE_PAGE_CONTENTS(p_init_msg_list => fnd_api.g_false
558: ,p_validate_only => fnd_api.g_false
559: ,p_object_type => 'PA_PWP_AR_NOTIFY'
560: ,p_pk1_value => p_inv_info_rec.ra_id
561: ,p_pk2_value => NULL

Line 575: FROM pa_page_contents

571: BEGIN
572: --create notification page
573: SELECT page_content
574: INTO l_clob
575: FROM pa_page_contents
576: WHERE page_content_id = l_page_content_id FOR UPDATE NOWAIT;
577: EXCEPTION
578: WHEN NO_DATA_FOUND THEN
579: log_message('Generate_PWP_Notify_Page: Failed to Select CLOB with: l_page_content_id=' || l_page_content_id || '*', 5);

Line 1111: FROM PA_PAGE_CONTENTS

1107: l_content CLOB;
1108:
1109: CURSOR c_pwp_preview_info IS
1110: SELECT page_content
1111: FROM PA_PAGE_CONTENTS
1112: WHERE page_content_id = document_id
1113: AND object_type = 'PA_PWP_AR_NOTIFY'
1114: AND pk2_value IS NULL;
1115: