1 Package pqh_txn_cat_documents_swi AUTHID CURRENT_USER As
2 /* $Header: pqtcdswi.pkh 115.0 2003/05/11 12:45:27 svorugan noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |------------------------< create_txn_cat_document >-----------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: pqh_txn_cat_documents_api.create_txn_cat_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 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE create_txn_cat_document
27 (p_validate in number default hr_api.g_false_num
28 ,p_effective_date in date
29 ,p_document_id in number
30 ,p_transaction_category_id in number
31 ,p_type_code in varchar2
32 ,p_object_version_number out nocopy number
33 ,p_return_status out nocopy varchar2
34 );
35 -- ----------------------------------------------------------------------------
36 -- |------------------------< delete_txn_cat_document >-----------------------|
37 -- ----------------------------------------------------------------------------
38 -- {Start of comments}
39 --
40 -- Description:
41 -- This procedure is the self-service wrapper procedure to the following
42 -- API: pqh_txn_cat_documents_api.delete_txn_cat_document
43 --
44 -- Pre-requisites
45 -- All 'IN' parameters to this procedure have been appropriately derived.
46 --
47 -- Post Success:
48 -- p_return_status will return value indicating success.
49 --
50 -- Post Failure:
51 -- p_return_status will return value indication failure.
52 --
53 -- Access Status:
54 -- Internal Development use only.
55 --
56 -- {End of comments}
57 -- ----------------------------------------------------------------------------
58 PROCEDURE delete_txn_cat_document
59 (p_validate in number default hr_api.g_false_num
60 ,p_document_id in number
61 ,p_transaction_category_id in number
62 ,p_object_version_number in number
63 ,p_return_status out nocopy varchar2
64 );
65
66 PROCEDURE delete_group
67 (p_validate in number default hr_api.g_false_num
68 ,p_transaction_category_id in number
69 ,p_object_version_number in number
70 ,p_effective_date in date default sysdate
71 ,p_return_status out nocopy varchar2
72 );
73
74
75 -- ----------------------------------------------------------------------------
76 -- |------------------------< update_txn_cat_document >-----------------------|
77 -- ----------------------------------------------------------------------------
78 -- {Start of comments}
79 --
80 -- Description:
81 -- This procedure is the self-service wrapper procedure to the following
82 -- API: pqh_txn_cat_documents_api.update_txn_cat_document
83 --
84 -- Pre-requisites
85 -- All 'IN' parameters to this procedure have been appropriately derived.
86 --
87 -- Post Success:
88 -- p_return_status will return value indicating success.
89 --
90 -- Post Failure:
91 -- p_return_status will return value indication failure.
92 --
93 -- Access Status:
94 -- Internal Development use only.
95 --
96 -- {End of comments}
97 -- ----------------------------------------------------------------------------
98 PROCEDURE update_txn_cat_document
99 (p_validate in number default hr_api.g_false_num
100 ,p_effective_date in date
101 ,p_document_id in number
102 ,p_transaction_category_id in number
103 ,p_type_code in varchar2 default hr_api.g_varchar2
104 ,p_object_version_number in out nocopy number
105 ,p_return_status out nocopy varchar2
106 );
107
108 end pqh_txn_cat_documents_swi;