DBA Data[Home] [Help]

PACKAGE: APPS.AMS_APPR_HIST_PKG

Source


1 PACKAGE AMS_Appr_Hist_PKG AUTHID CURRENT_USER AS
2 /* $Header: amstaphs.pls 115.0 2002/12/01 12:10:51 vmodur noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --          AMS_Appr_Hist_PKG
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- This Api is generated with Latest version of
14 -- Rosetta, where g_miss indicates NULL and
15 -- NULL indicates missing value. Rosetta Version 1.55
16 -- End of Comments
17 -- ===============================================================
18 
19 
20 
21 
22 --  ========================================================
23 --
24 --  NAME
25 --  Insert_Row
26 --
27 --  PURPOSE
28 --
29 --  NOTES
30 --
31 --  HISTORY
32 --
33 --  ========================================================
34 PROCEDURE Insert_Row(
35           p_object_id   IN OUT NOCOPY NUMBER,
36           p_object_type_code    VARCHAR2,
37           p_sequence_num    NUMBER,
38           p_object_version_num    NUMBER,
39           p_last_update_date    DATE,
40           p_last_updated_by    NUMBER,
41           p_creation_date    DATE,
42           p_created_by    NUMBER,
43           p_action_code    VARCHAR2,
44           p_action_date    DATE,
45           p_approver_id    NUMBER,
46           p_approval_detail_id    NUMBER,
47           p_note    VARCHAR2,
48           p_last_update_login    NUMBER,
49           p_approval_type    VARCHAR2,
50           p_approver_type    VARCHAR2,
51           p_custom_setup_id    NUMBER,
52 	  p_log_message  VARCHAR2);
53 
54 
55 
56 
57 
58 --  ========================================================
59 --
60 --  NAME
61 --  Update_Row
62 --
63 --  PURPOSE
64 --
65 --  NOTES
66 --
67 --  HISTORY
68 --
69 --  ========================================================
70 PROCEDURE Update_Row(
71           p_object_id    NUMBER,
72           p_object_type_code    VARCHAR2,
73           p_sequence_num    NUMBER,
74           p_object_version_num    NUMBER,
75           p_last_update_date    DATE,
76           p_last_updated_by    NUMBER,
77           p_action_code    VARCHAR2,
78           p_action_date    DATE,
79           p_approver_id    NUMBER,
80           p_approval_detail_id    NUMBER,
81           p_note    VARCHAR2,
82           p_last_update_login    NUMBER,
83           p_approval_type    VARCHAR2,
84           p_approver_type    VARCHAR2,
85           p_custom_setup_id    NUMBER,
86 	  p_log_message VARCHAR2);
87 
88 
89 
90 
91 
92 --  ========================================================
93 --
94 --  NAME
95 --  Delete_Row
96 --
97 --  PURPOSE
98 --
99 --  NOTES
100 --
101 --  HISTORY
102 --
103 --  ========================================================
104 PROCEDURE Delete_Row(
105     p_object_id  NUMBER,
106     p_object_type_code    VARCHAR2,
107     p_sequence_num    NUMBER,
108     p_action_code     VARCHAR2,
109     p_object_version_num    NUMBER,
110     p_approval_type VARCHAR2);
111 
112 
113 END AMS_Appr_Hist_PKG;