PACKAGE: APPS.PV_ATTRIBUTE_USAGES_PKG

Source

1 PACKAGE PV_ATTRIBUTE_USAGES_PKG AUTHID CURRENT_USER AS
2  /* $Header: pvxtatus.pls 115.3 2002/12/10 19:39:11 amaram ship $ */
3  -- ===============================================================
4  -- Start of Comments
5  -- Package name
6  --          PV_ATTRIBUTE_USAGES_PKG
7  -- Purpose
8  --
9  -- History
10  --
11  -- NOTE
12  --
13  -- End of Comments
14  -- ===============================================================
15 
16  PROCEDURE Insert_Row(
17            px_attribute_usage_id   IN OUT  NOCOPY NUMBER,
18            p_last_update_date    DATE,
19            p_last_updated_by    NUMBER,
20            p_creation_date    DATE,
21            p_created_by    NUMBER,
22            p_last_update_login    NUMBER,
23            p_request_id    NUMBER,
24            p_program_application_id    NUMBER,
25            p_program_id    NUMBER,
26            p_program_update_date    DATE,
27            px_object_version_number   IN OUT  NOCOPY NUMBER,
28            p_attribute_usage_type    VARCHAR2,
29            p_attribute_usage_code    VARCHAR2,
30            p_attribute_id    NUMBER,
31            p_enabled_flag    VARCHAR2
32            --p_security_group_id    NUMBER
33            );
34 
35  PROCEDURE Update_Row(
36            p_attribute_usage_id    NUMBER,
37            p_last_update_date    DATE,
38            p_last_updated_by    NUMBER,
39            p_creation_date    DATE := FND_API.g_miss_date ,
40            p_created_by    NUMBER := FND_API.g_miss_num ,
41            p_last_update_login    NUMBER,
42            p_request_id    NUMBER,
43            p_program_application_id    NUMBER,
44            p_program_id    NUMBER,
45            p_program_update_date    DATE,
46            p_object_version_number    NUMBER,
47            p_attribute_usage_type    VARCHAR2,
48            p_attribute_usage_code    VARCHAR2,
49            p_attribute_id    NUMBER,
50            p_enabled_flag    VARCHAR2
51            --p_security_group_id    NUMBER
52            );
53 
54  PROCEDURE Delete_Row(
55      p_ATTRIBUTE_USAGE_ID  NUMBER);
56  PROCEDURE Lock_Row(
57            p_attribute_usage_id    NUMBER,
58            p_last_update_date    DATE,
59            p_last_updated_by    NUMBER,
60            p_creation_date    DATE,
61            p_created_by    NUMBER,
62            p_last_update_login    NUMBER,
63            p_request_id    NUMBER,
64            p_program_application_id    NUMBER,
65            p_program_id    NUMBER,
66            p_program_update_date    DATE,
67            p_object_version_number    NUMBER,
68            p_attribute_usage_type    VARCHAR2,
69            p_attribute_usage_code    VARCHAR2,
70            p_attribute_id    NUMBER,
71            p_enabled_flag    VARCHAR2
72            --p_security_group_id    NUMBER
73            );
74 
75  END PV_ATTRIBUTE_USAGES_PKG;
76