APPS.PA_CE_AR_NOTIFY_WF SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 27

PROCEDURE Select_Project_Manager (p_project_id          IN  NUMBER
                                , p_project_manager_id  OUT NOCOPY NUMBER
                                , p_return_status       IN OUT NOCOPY NUMBER)
IS
    /*
       You can use this procedure to add any additional rules to determine
       a person who should receive notifications for releasing hold on Invoices.
       This procedure is being used by the Workflow APIs and determine who
       should recieve notification when a receipt is applied to an AR Invoice.
       By default parent procedure fetches the Project Manager of the
       project which relates to the AR Invoice that receives cash when a
       receipt is applied.
    */
BEGIN
     /* Please update the Result status in accordance with the details below.
    Result Status : p_return_status
    =0  => NO Client Extention Implemented.
    >0  =>  Client Extention Implemented and successfully fetched the Project Manager ID.
    <0  =>  Client Extention Implemented and failed to fetch the Project Manager ID.
    */
     p_return_status := 0;

Line: 65

           WF_CORE.CONTEXT('PA_CE_AR_NOTIFY_WF','SELECT_PROJECT_MANAGER');

Line: 68

END Select_Project_Manager;