PACKAGE: APPS.PV_ATTRIBUTE_CODE_PKG

Source

1 PACKAGE PV_ATTRIBUTE_CODE_PKG AS
2  /* $Header: pvxtatcs.pls 120.2 2005/07/05 16:42:10 appldev ship $ */
3  -- ===============================================================
4  -- Start of Comments
5  -- Package name
6  --          PV_ATTRIBUTE_CODES_B_PKG
7  -- Purpose
8  --
9  -- History
10  --
11  -- NOTE
12  --
13  -- End of Comments
14  -- ===============================================================
15 
16  PROCEDURE Insert_Row(
17            px_attr_code_id   IN OUT NOCOPY NUMBER,
18            p_attr_code    VARCHAR2,
19            p_last_update_date    DATE,
20            p_last_updated_by    NUMBER,
21            p_creation_date    DATE,
22            p_created_by    NUMBER,
23            p_last_update_login    NUMBER,
24            px_object_version_number   IN OUT NOCOPY NUMBER,
25            p_attribute_id    NUMBER,
26            p_enabled_flag    VARCHAR2,
27            p_description    VARCHAR2 );
28 
29  PROCEDURE Update_Row(
30            p_attr_code_id    NUMBER,
31            p_attr_code    VARCHAR2,
32            p_last_update_date    DATE,
33            p_last_updated_by    NUMBER,
34            p_creation_date    DATE := FND_API.g_miss_date ,
35            p_created_by    NUMBER := FND_API.g_miss_num ,
36            p_last_update_login    NUMBER,
37            p_object_version_number    NUMBER,
38            p_attribute_id    NUMBER,
39            p_enabled_flag    VARCHAR2,
40            p_description    VARCHAR2 );
41 
42 PROCEDURE Update_Row_Seed(
43            p_attr_code_id    NUMBER,
44            p_attr_code    VARCHAR2,
45            p_last_update_date    DATE,
46            p_last_updated_by    NUMBER,
47            p_creation_date    DATE := FND_API.g_miss_date ,
48            p_created_by    NUMBER := FND_API.g_miss_num ,
49            p_last_update_login    NUMBER,
50            p_object_version_number    NUMBER,
51            p_attribute_id    NUMBER,
52            p_enabled_flag    VARCHAR2,
53            p_description    VARCHAR2 );
54 
55 
56  PROCEDURE Delete_Row(
57      p_ATTR_CODE_ID  NUMBER);
58  PROCEDURE Lock_Row(
59            p_attr_code_id    NUMBER,
60            p_attr_code    VARCHAR2,
61            p_last_update_date    DATE,
62            p_last_updated_by    NUMBER,
63            p_creation_date    DATE,
64            p_created_by    NUMBER,
65            p_last_update_login    NUMBER,
66            p_object_version_number    NUMBER,
67            p_attribute_id    NUMBER,
68            p_enabled_flag    VARCHAR2,
69            p_description    VARCHAR2 );
70 
71 procedure ADD_LANGUAGE;
72 
73 procedure TRANSLATE_ROW(
74   p_attr_code_id      in VARCHAR2
75 , p_description       in VARCHAR2
76 , p_owner             in VARCHAR2
77 );
78 
79 procedure  LOAD_ROW(
80   p_ATTR_CODE_ID          IN VARCHAR2,
81   p_ATTRIBUTE_ID	  IN VARCHAR2,
82   p_ENABLED_FLAG          in VARCHAR2,
83   p_ATTR_CODE		  IN VARCHAR2,
84   p_DESCRIPTION           in VARCHAR2  DEFAULT NULL ,
85   p_Owner                 in VARCHAR2
86 );
87 
88 procedure  LOAD_SEED_ROW (
89   P_UPLOAD_MODE           IN VARCHAR2,
90   p_ATTR_CODE_ID          IN VARCHAR2,
91   p_ATTRIBUTE_ID	  IN VARCHAR2,
92   p_ENABLED_FLAG          in VARCHAR2,
93   p_ATTR_CODE		  IN VARCHAR2,
94   p_DESCRIPTION           in VARCHAR2  DEFAULT NULL ,
95   p_Owner                 in VARCHAR2
96 );
97 
98 
99 
100  END PV_ATTRIBUTE_CODE_PKG;