PACKAGE: APPS.PV_TAP_ACCESS_TERRS_PKG

Source

1 PACKAGE PV_TAP_ACCESS_TERRS_PKG AUTHID CURRENT_USER AS
2 /* $Header: pvxttras.pls 115.0 2003/10/15 04:19:38 rdsharma noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --          PV_TAP_ACCESS_TERRS_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 --  NAME
22 --  Insert_Row
23 --
24 --  PURPOSE
25 --
26 --  NOTES
27 --
28 --  HISTORY
29 --
30 --  ========================================================
31 PROCEDURE Insert_Row(
32           p_partner_access_id    NUMBER,
33           p_terr_id              NUMBER,
34           p_last_update_date     DATE,
35           p_last_updated_by      NUMBER,
36           p_creation_date        DATE,
37           p_created_by           NUMBER,
38           p_last_update_login    NUMBER,
39           p_object_version_number NUMBER,
40           p_request_id           NUMBER,
41           p_program_application_id    NUMBER,
42           p_program_id           NUMBER,
43           p_program_update_date  DATE,
44 	  x_return_status IN OUT NOCOPY VARCHAR2);
45 
46 --  ========================================================
47 --
48 --  NAME
49 --  Update_Row
50 --
51 --  PURPOSE
52 --
53 --  NOTES
54 --
55 --  HISTORY
56 --
57 --  ========================================================
58 PROCEDURE Update_Row(
59           p_partner_access_id     NUMBER,
60           p_terr_id               NUMBER,
61           p_last_update_date      DATE,
62           p_last_updated_by       NUMBER,
63           p_last_update_login     NUMBER,
64           p_object_version_number NUMBER,
65           p_request_id            NUMBER,
66           p_program_application_id NUMBER,
67           p_program_id            NUMBER,
68           p_program_update_date   DATE,
69 	  x_return_status IN OUT NOCOPY VARCHAR2);
70 
71 
72 
73 
74 
75 --  ========================================================
76 --
77 --  NAME
78 --  Delete_Row
79 --
80 --  PURPOSE
81 --
82 --  NOTES
83 --
84 --  HISTORY
85 --
86 --  ========================================================
87 PROCEDURE Delete_Row(
88     p_partner_access_id      NUMBER,
89     p_terr_id                NUMBER,
90     p_object_version_number  NUMBER,
91     x_return_status          IN OUT NOCOPY VARCHAR2);
92 
93 
94 
95 
96 --  ========================================================
97 --
98 --  NAME
99 --  Lock_Row
100 --
101 --  PURPOSE
102 --
103 --  NOTES
104 --
105 --  HISTORY
106 --
107 --  ========================================================
108 PROCEDURE Lock_Row(
109     p_partner_access_id      NUMBER,
110     p_terr_id                NUMBER,
111     p_object_version_number  NUMBER,
112     x_return_status  IN OUT NOCOPY VARCHAR2);
113 
114 
115 END PV_TAP_ACCESS_TERRS_PKG;