DBA Data[Home] [Help]

APPS.PA_TASK_WORKFLOW_PKG dependencies on PA_PAGE_CONTENTS

Line 563: -- Creating new page content in pa_page_contents.

559: x_content_id := 0;
560:
561: log_message('Creating the page content' ,3);
562:
563: -- Creating new page content in pa_page_contents.
564: log_message('Before calling PA_PAGE_CONTENTS_PUB.create_page_contents' ,3);
565: PA_PAGE_CONTENTS_PUB.Create_Page_Contents(p_init_msg_list => fnd_api.g_false
566: ,p_validate_only => fnd_api.g_false
567: ,p_object_type => 'PA_TASK_APPROVAL_WF'

Line 564: log_message('Before calling PA_PAGE_CONTENTS_PUB.create_page_contents' ,3);

560:
561: log_message('Creating the page content' ,3);
562:
563: -- Creating new page content in pa_page_contents.
564: log_message('Before calling PA_PAGE_CONTENTS_PUB.create_page_contents' ,3);
565: PA_PAGE_CONTENTS_PUB.Create_Page_Contents(p_init_msg_list => fnd_api.g_false
566: ,p_validate_only => fnd_api.g_false
567: ,p_object_type => 'PA_TASK_APPROVAL_WF'
568: ,p_pk1_value => p_task_id

Line 565: PA_PAGE_CONTENTS_PUB.Create_Page_Contents(p_init_msg_list => fnd_api.g_false

561: log_message('Creating the page content' ,3);
562:
563: -- Creating new page content in pa_page_contents.
564: log_message('Before calling PA_PAGE_CONTENTS_PUB.create_page_contents' ,3);
565: PA_PAGE_CONTENTS_PUB.Create_Page_Contents(p_init_msg_list => fnd_api.g_false
566: ,p_validate_only => fnd_api.g_false
567: ,p_object_type => 'PA_TASK_APPROVAL_WF'
568: ,p_pk1_value => p_task_id
569: ,p_pk2_value => NULL

Line 580: FROM PA_PAGE_CONTENTS

576:
577: BEGIN
578: SELECT page_content
579: INTO l_clob
580: FROM PA_PAGE_CONTENTS
581: WHERE page_content_id = l_page_content_id FOR UPDATE NOWAIT;
582: EXCEPTION
583: WHEN NO_DATA_FOUND THEN
584: RAISE;

Line 799: FROM PA_PAGE_CONTENTS

795: l_content CLOB;
796:
797: CURSOR c_pwp_preview_info IS
798: SELECT page_content
799: FROM PA_PAGE_CONTENTS
800: WHERE page_content_id =document_id
801: AND object_type = 'PA_TASK_APPROVAL_WF'
802: AND pk2_value IS NULL;
803: