DBA Data[Home] [Help]

APPS.CSF_REMOTE_VIEWS_PUB dependencies on CSF_L_QUERYREQUESTS

Line 659: -- Place the results in a notification and table csf_l_queryrequests.

655: -- Executing of the query is finished here.
656: --
657: -- support for the subject has been dropped, as notifications will not
658: -- allow it. Place the subject as the first line in the body-text.
659: -- Place the results in a notification and table csf_l_queryrequests.
660:
661: t_not_id := wf_notification.send
662: ( role => t_user
663: , msg_type => 'CS_MSGS'

Line 680: select csf_l_queryrequests_s.nextval

676: -- Handle the PK.
677: if p_queryrequest_id is null
678: then
679: -- Generate one.
680: select csf_l_queryrequests_s.nextval
681: into t_request_id
682: from dual;
683: else
684: -- Reuse the one provided.

Line 687: insert into csf_l_queryrequests

683: else
684: -- Reuse the one provided.
685: t_request_id := p_queryrequest_id;
686: end if;
687: insert into csf_l_queryrequests
688: ( QUERYREQUEST_ID
689: , EMPLID
690: , REQUESTDATE
691: , QUERY_ID