DBA Data[Home] [Help]

PACKAGE: APPS.PQH_SS_HISTORY

Source


1 Package pqh_ss_history AUTHID CURRENT_USER as
2 /* $Header: pqhstswi.pkh 120.0 2005/05/29 02:07:26 appldev noship $*/
3  -- Global Variables
4  G_ACTION  varchar2(25);
5 
6 
7 procedure transfer_to_history
8     ( p_ItemType             in varchar2
9     , p_itemKey              in varchar2
10     , p_action               in varchar2
11     , p_username             in varchar2
12     , p_transactionId        in number
13     , p_orig_system          in varchar2 default null
14     , p_orig_system_id       in number default null);
15 --
16 procedure track_original_value
17     ( p_ItemType             in varchar2
18     , p_itemKey              in varchar2
19     , p_action               in varchar2
20     , p_username             in varchar2
21     , p_transactionId        in number
22     , p_orig_system          in varchar2 default null
23     , p_orig_system_id       in number default null);
24 --
25  PROCEDURE transfer_submit_to_history (
26       itemtype        IN     VARCHAR2,
27       itemkey         IN     VARCHAR2,
28       actid           IN     NUMBER,
29       funmode         IN     VARCHAR2,
30       result          OUT NOCOPY VARCHAR2 );
31 --
32 --
33  PROCEDURE transfer_approval_to_history (
34       itemtype        IN     VARCHAR2,
35       itemkey         IN     VARCHAR2,
36       actid           IN     NUMBER,
37       funmode         IN     VARCHAR2,
38       result          OUT NOCOPY  VARCHAR2 );
39 --
40 --
41  PROCEDURE transfer_reject_to_history (
42       itemtype        IN     VARCHAR2,
43       itemkey         IN     VARCHAR2,
44       actid           IN     NUMBER,
45       funmode         IN     VARCHAR2,
46       result          OUT NOCOPY  VARCHAR2 );
47 --
48 --
49  PROCEDURE transfer_delete_to_history (
50       itemtype        IN     VARCHAR2,
51       itemkey         IN     VARCHAR2,
52       actid           IN     NUMBER,
53       funmode         IN     VARCHAR2,
54       result          OUT NOCOPY  VARCHAR2 );
55 --
56 --
57  PROCEDURE transfer_startover_to_history (
58       itemtype        IN     VARCHAR2,
59       itemkey         IN     VARCHAR2,
60       actid           IN     NUMBER,
61       funmode         IN     VARCHAR2,
62       result          OUT NOCOPY  VARCHAR2 );
63 --
64 --
65  PROCEDURE transfer_rfc_to_history (
66       itemtype        IN     VARCHAR2,
67       itemkey         IN     VARCHAR2,
68       actid           IN     NUMBER,
69       funmode         IN     VARCHAR2,
70       result          OUT NOCOPY  VARCHAR2 );
71 --
72 --
73 PROCEDURE copy_value_from_history (
74         p_txnId        IN NUMBER );
75 --
76 --
77 PROCEDURE copy_value_to_history (
78         p_txnId        IN NUMBER );
79 --
80 --
81 end;