PACKAGE: APPS.PQH_DOCUMENTS_WRAPPER

Source

1 Package pqh_documents_wrapper AUTHID CURRENT_USER As
2 /* $Header: pqdocwrp.pkh 115.2 2003/04/14 12:28:31 svorugan noship $*/
3 -- ----------------------------------------------------------------------------
4 -- |----------------------------< delete_document >---------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 --  This procedure is the self-service wrapper procedure to the following
10 --  API: pqh_documents_api.delete_document
11 --
12 -- Pre-requisites
13 --  All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 --  p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 --  p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 --  Internal Development use only.
23 --
24 -- The delete_document delets all child records then deletes Master record
25 -- {End of comments}
26 -- ----------------------------------------------------------------------------
27 PROCEDURE delete_document
28   (p_validate                     in     number    default hr_api.g_false_num
29   ,p_effective_date               in     date      default trunc(sysdate)
30   ,p_datetrack_mode               in     varchar2
31   ,p_document_id                  in     number
32   ,p_object_version_number        in out NOCOPY number
33   ,p_effective_start_date            out NOCOPY date
34   ,p_effective_end_date              out NOCOPY date
35   ,p_return_status                   out NOCOPY varchar2
36   );
37 end pqh_documents_wrapper;