DBA Data[Home] [Help]

APPS.PA_DCTN_APRV_NOTIFICATION dependencies on PA_PAGE_CONTENTS

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

351: CLOSE c_vendor_info;
352:
353: x_content_id := 0;
354:
355: PA_PAGE_CONTENTS_PUB.Create_Page_Contents(p_init_msg_list => fnd_api.g_false
356: ,p_validate_only => fnd_api.g_false
357: ,p_object_type => 'PA_DCTN_APRV_NOTIFY'
358: ,p_pk1_value => p_dctn_hdr_rec.deduction_req_id
359: ,p_pk2_value => NULL

Line 369: FROM PA_PAGE_CONTENTS

365:
366: BEGIN
367: SELECT page_content
368: INTO l_clob
369: FROM PA_PAGE_CONTENTS
370: WHERE page_content_id = l_page_content_id FOR UPDATE NOWAIT;
371: EXCEPTION
372: WHEN NO_DATA_FOUND THEN
373: RAISE;

Line 756: FROM PA_PAGE_CONTENTS

752: l_content CLOB;
753:
754: CURSOR c_pwp_preview_info IS
755: SELECT page_content
756: FROM PA_PAGE_CONTENTS
757: WHERE page_content_id = document_id
758: AND object_type = 'PA_DCTN_APRV_NOTIFY'
759: AND pk2_value IS NULL;
760: