DBA Data[Home] [Help]

PACKAGE: APPS.PV_GE_PTNR_RESPS_PKG

Source


1 PACKAGE PV_Ge_Ptnr_Resps_PKG AUTHID CURRENT_USER AS
2 /* $Header: pvxtgprs.pls 115.2 2003/11/18 22:51:22 ktsao noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --          PV_Ge_Ptnr_Resps_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         px_ptnr_resp_id   IN OUT NOCOPY NUMBER,
36         p_partner_id    NUMBER,
37         p_user_role_code    VARCHAR2,
38         p_program_id    NUMBER,
39         p_responsibility_id    NUMBER,
40         p_source_resp_map_rule_id    NUMBER,
41         p_resp_type_code VARCHAR2,
42         px_object_version_number   IN OUT NOCOPY NUMBER,
43         p_created_by    NUMBER,
44         p_creation_date    DATE,
45         p_last_updated_by    NUMBER,
46         p_last_update_date    DATE,
47         p_last_update_login    NUMBER);
48 
49 
50 
51 
52 
53 --  ========================================================
54 --
55 --  NAME
56 --  Update_Row
57 --
58 --  PURPOSE
59 --
60 --  NOTES
61 --
62 --  HISTORY
63 --
64 --  ========================================================
65 PROCEDURE Update_Row(
66         p_ptnr_resp_id    NUMBER,
67         p_partner_id    NUMBER,
68         p_user_role_code    VARCHAR2,
69         p_program_id    NUMBER,
70         p_responsibility_id    NUMBER,
71         p_source_resp_map_rule_id    NUMBER,
72         p_resp_type_code VARCHAR2,
73         p_object_version_number   IN NUMBER,
74         p_last_updated_by    NUMBER,
75         p_last_update_date    DATE,
76         p_last_update_login    NUMBER);
77 
78 
79 
80 
81 
82 --  ========================================================
83 --
84 --  NAME
85 --  Delete_Row
86 --
87 --  PURPOSE
88 --
89 --  NOTES
90 --
91 --  HISTORY
92 --
93 --  ========================================================
94 PROCEDURE Delete_Row(
95   p_ptnr_resp_id  NUMBER,
96   p_object_version_number  NUMBER);
97 
98 
99 
100 
101 --  ========================================================
102 --
103 --  NAME
104 --  Lock_Row
105 --
106 --  PURPOSE
107 --
108 --  NOTES
109 --
110 --  HISTORY
111 --
112 --  ========================================================
113 PROCEDURE Lock_Row(
114   p_ptnr_resp_id  NUMBER,
115   p_object_version_number  NUMBER);
116 
117 
118 END PV_Ge_Ptnr_Resps_PKG;