eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_ATTRIBUTE_CODE_PVT dependencies on FND_API

Line 52: attr_code_id NUMBER := FND_API.G_MISS_NUM

48: 22-JAN-2002 shitij.vatsa Created
49: --===================================================================*/
50: TYPE attribute_code_rec_type IS RECORD
51: (
52: attr_code_id NUMBER := FND_API.G_MISS_NUM
53: ,attr_code VARCHAR2(30) := FND_API.G_MISS_CHAR
54: ,last_update_date DATE := FND_API.G_MISS_DATE
55: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
56: ,creation_date DATE := FND_API.G_MISS_DATE

Line 53: ,attr_code VARCHAR2(30) := FND_API.G_MISS_CHAR

49: --===================================================================*/
50: TYPE attribute_code_rec_type IS RECORD
51: (
52: attr_code_id NUMBER := FND_API.G_MISS_NUM
53: ,attr_code VARCHAR2(30) := FND_API.G_MISS_CHAR
54: ,last_update_date DATE := FND_API.G_MISS_DATE
55: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
56: ,creation_date DATE := FND_API.G_MISS_DATE
57: ,created_by NUMBER := FND_API.G_MISS_NUM

Line 54: ,last_update_date DATE := FND_API.G_MISS_DATE

50: TYPE attribute_code_rec_type IS RECORD
51: (
52: attr_code_id NUMBER := FND_API.G_MISS_NUM
53: ,attr_code VARCHAR2(30) := FND_API.G_MISS_CHAR
54: ,last_update_date DATE := FND_API.G_MISS_DATE
55: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
56: ,creation_date DATE := FND_API.G_MISS_DATE
57: ,created_by NUMBER := FND_API.G_MISS_NUM
58: ,last_update_login NUMBER := FND_API.G_MISS_NUM

Line 55: ,last_updated_by NUMBER := FND_API.G_MISS_NUM

51: (
52: attr_code_id NUMBER := FND_API.G_MISS_NUM
53: ,attr_code VARCHAR2(30) := FND_API.G_MISS_CHAR
54: ,last_update_date DATE := FND_API.G_MISS_DATE
55: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
56: ,creation_date DATE := FND_API.G_MISS_DATE
57: ,created_by NUMBER := FND_API.G_MISS_NUM
58: ,last_update_login NUMBER := FND_API.G_MISS_NUM
59: ,object_version_number NUMBER := FND_API.G_MISS_NUM

Line 56: ,creation_date DATE := FND_API.G_MISS_DATE

52: attr_code_id NUMBER := FND_API.G_MISS_NUM
53: ,attr_code VARCHAR2(30) := FND_API.G_MISS_CHAR
54: ,last_update_date DATE := FND_API.G_MISS_DATE
55: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
56: ,creation_date DATE := FND_API.G_MISS_DATE
57: ,created_by NUMBER := FND_API.G_MISS_NUM
58: ,last_update_login NUMBER := FND_API.G_MISS_NUM
59: ,object_version_number NUMBER := FND_API.G_MISS_NUM
60: ,attribute_id NUMBER := FND_API.G_MISS_NUM

Line 57: ,created_by NUMBER := FND_API.G_MISS_NUM

53: ,attr_code VARCHAR2(30) := FND_API.G_MISS_CHAR
54: ,last_update_date DATE := FND_API.G_MISS_DATE
55: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
56: ,creation_date DATE := FND_API.G_MISS_DATE
57: ,created_by NUMBER := FND_API.G_MISS_NUM
58: ,last_update_login NUMBER := FND_API.G_MISS_NUM
59: ,object_version_number NUMBER := FND_API.G_MISS_NUM
60: ,attribute_id NUMBER := FND_API.G_MISS_NUM
61: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 58: ,last_update_login NUMBER := FND_API.G_MISS_NUM

54: ,last_update_date DATE := FND_API.G_MISS_DATE
55: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
56: ,creation_date DATE := FND_API.G_MISS_DATE
57: ,created_by NUMBER := FND_API.G_MISS_NUM
58: ,last_update_login NUMBER := FND_API.G_MISS_NUM
59: ,object_version_number NUMBER := FND_API.G_MISS_NUM
60: ,attribute_id NUMBER := FND_API.G_MISS_NUM
61: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
62: ,description VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 59: ,object_version_number NUMBER := FND_API.G_MISS_NUM

55: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
56: ,creation_date DATE := FND_API.G_MISS_DATE
57: ,created_by NUMBER := FND_API.G_MISS_NUM
58: ,last_update_login NUMBER := FND_API.G_MISS_NUM
59: ,object_version_number NUMBER := FND_API.G_MISS_NUM
60: ,attribute_id NUMBER := FND_API.G_MISS_NUM
61: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
62: ,description VARCHAR2(240) := FND_API.G_MISS_CHAR
63: --,security_group_id NUMBER := FND_API.G_MISS_NUM

Line 60: ,attribute_id NUMBER := FND_API.G_MISS_NUM

56: ,creation_date DATE := FND_API.G_MISS_DATE
57: ,created_by NUMBER := FND_API.G_MISS_NUM
58: ,last_update_login NUMBER := FND_API.G_MISS_NUM
59: ,object_version_number NUMBER := FND_API.G_MISS_NUM
60: ,attribute_id NUMBER := FND_API.G_MISS_NUM
61: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
62: ,description VARCHAR2(240) := FND_API.G_MISS_CHAR
63: --,security_group_id NUMBER := FND_API.G_MISS_NUM
64: );

Line 61: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

57: ,created_by NUMBER := FND_API.G_MISS_NUM
58: ,last_update_login NUMBER := FND_API.G_MISS_NUM
59: ,object_version_number NUMBER := FND_API.G_MISS_NUM
60: ,attribute_id NUMBER := FND_API.G_MISS_NUM
61: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
62: ,description VARCHAR2(240) := FND_API.G_MISS_CHAR
63: --,security_group_id NUMBER := FND_API.G_MISS_NUM
64: );
65:

Line 62: ,description VARCHAR2(240) := FND_API.G_MISS_CHAR

58: ,last_update_login NUMBER := FND_API.G_MISS_NUM
59: ,object_version_number NUMBER := FND_API.G_MISS_NUM
60: ,attribute_id NUMBER := FND_API.G_MISS_NUM
61: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
62: ,description VARCHAR2(240) := FND_API.G_MISS_CHAR
63: --,security_group_id NUMBER := FND_API.G_MISS_NUM
64: );
65:
66:

Line 63: --,security_group_id NUMBER := FND_API.G_MISS_NUM

59: ,object_version_number NUMBER := FND_API.G_MISS_NUM
60: ,attribute_id NUMBER := FND_API.G_MISS_NUM
61: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
62: ,description VARCHAR2(240) := FND_API.G_MISS_CHAR
63: --,security_group_id NUMBER := FND_API.G_MISS_NUM
64: );
65:
66:
67: g_miss_attribute_code_rec attribute_code_rec_type;

Line 84: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

80: -- Parameters
81: --
82: -- IN
83: -- p_api_version_number IN NUMBER Required
84: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
85: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
86: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
87: -- p_attribute_code_rec IN attribute_code_rec_type Required
88: --

Line 85: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

81: --
82: -- IN
83: -- p_api_version_number IN NUMBER Required
84: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
85: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
86: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
87: -- p_attribute_code_rec IN attribute_code_rec_type Required
88: --
89: -- OUT

Line 86: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

82: -- IN
83: -- p_api_version_number IN NUMBER Required
84: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
85: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
86: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
87: -- p_attribute_code_rec IN attribute_code_rec_type Required
88: --
89: -- OUT
90: -- x_return_status OUT VARCHAR2

Line 103: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

99: --
100:
101: PROCEDURE Create_Attribute_Code(
102: p_api_version_number IN NUMBER
103: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
104: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
105: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
106:
107: ,x_return_status OUT NOCOPY VARCHAR2

Line 104: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

100:
101: PROCEDURE Create_Attribute_Code(
102: p_api_version_number IN NUMBER
103: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
104: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
105: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
106:
107: ,x_return_status OUT NOCOPY VARCHAR2
108: ,x_msg_count OUT NOCOPY NUMBER

Line 105: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

101: PROCEDURE Create_Attribute_Code(
102: p_api_version_number IN NUMBER
103: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
104: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
105: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
106:
107: ,x_return_status OUT NOCOPY VARCHAR2
108: ,x_msg_count OUT NOCOPY NUMBER
109: ,x_msg_data OUT NOCOPY VARCHAR2

Line 128: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

124: -- Parameters
125: --
126: -- IN
127: -- p_api_version_number IN NUMBER Required
128: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
129: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
130: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
131: -- p_attribute_code_rec IN attribute_code_rec_type Required
132: --

Line 129: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

125: --
126: -- IN
127: -- p_api_version_number IN NUMBER Required
128: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
129: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
130: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
131: -- p_attribute_code_rec IN attribute_code_rec_type Required
132: --
133: -- OUT

Line 130: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

126: -- IN
127: -- p_api_version_number IN NUMBER Required
128: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
129: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
130: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
131: -- p_attribute_code_rec IN attribute_code_rec_type Required
132: --
133: -- OUT
134: -- x_return_status OUT VARCHAR2

Line 147: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

143: --
144:
145: PROCEDURE Update_Attribute_Code(
146: p_api_version_number IN NUMBER
147: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
148: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
149: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
150:
151: ,x_return_status OUT NOCOPY VARCHAR2

Line 148: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

144:
145: PROCEDURE Update_Attribute_Code(
146: p_api_version_number IN NUMBER
147: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
148: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
149: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
150:
151: ,x_return_status OUT NOCOPY VARCHAR2
152: ,x_msg_count OUT NOCOPY NUMBER

Line 149: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

145: PROCEDURE Update_Attribute_Code(
146: p_api_version_number IN NUMBER
147: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
148: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
149: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
150:
151: ,x_return_status OUT NOCOPY VARCHAR2
152: ,x_msg_count OUT NOCOPY NUMBER
153: ,x_msg_data OUT NOCOPY VARCHAR2

Line 172: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

168: -- Parameters
169: --
170: -- IN
171: -- p_api_version_number IN NUMBER Required
172: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
173: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
174: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
175: -- p_ATTRIBUTE_USAGE_ID IN NUMBER
176: -- p_object_version_number IN NUMBER Optional Default = NULL

Line 173: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

169: --
170: -- IN
171: -- p_api_version_number IN NUMBER Required
172: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
173: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
174: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
175: -- p_ATTRIBUTE_USAGE_ID IN NUMBER
176: -- p_object_version_number IN NUMBER Optional Default = NULL
177: --

Line 174: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

170: -- IN
171: -- p_api_version_number IN NUMBER Required
172: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
173: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
174: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
175: -- p_ATTRIBUTE_USAGE_ID IN NUMBER
176: -- p_object_version_number IN NUMBER Optional Default = NULL
177: --
178: -- OUT

Line 192: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

188: --
189:
190: PROCEDURE Delete_Attribute_Code(
191: p_api_version_number IN NUMBER
192: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
193: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
194: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
195:
196: ,x_return_status OUT NOCOPY VARCHAR2

Line 193: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

189:
190: PROCEDURE Delete_Attribute_Code(
191: p_api_version_number IN NUMBER
192: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
193: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
194: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
195:
196: ,x_return_status OUT NOCOPY VARCHAR2
197: ,x_msg_count OUT NOCOPY NUMBER

Line 194: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

190: PROCEDURE Delete_Attribute_Code(
191: p_api_version_number IN NUMBER
192: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
193: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
194: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
195:
196: ,x_return_status OUT NOCOPY VARCHAR2
197: ,x_msg_count OUT NOCOPY NUMBER
198: ,x_msg_data OUT NOCOPY VARCHAR2

Line 217: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

213: -- Parameters
214: --
215: -- IN
216: -- p_api_version_number IN NUMBER Required
217: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
218: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
219: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
220: --
221: -- OUT

Line 218: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

214: --
215: -- IN
216: -- p_api_version_number IN NUMBER Required
217: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
218: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
219: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
220: --
221: -- OUT
222: -- x_return_status OUT VARCHAR2

Line 219: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

215: -- IN
216: -- p_api_version_number IN NUMBER Required
217: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
218: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
219: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
220: --
221: -- OUT
222: -- x_return_status OUT VARCHAR2
223: -- x_msg_count OUT NUMBER

Line 235: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

231: --
232:
233: PROCEDURE Lock_Attribute_Code(
234: p_api_version_number IN NUMBER
235: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
236:
237: ,x_return_status OUT NOCOPY VARCHAR2
238: ,x_msg_count OUT NOCOPY NUMBER
239: ,x_msg_data OUT NOCOPY VARCHAR2

Line 259: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

255: -- End of Comments
256:
257: PROCEDURE Validate_Attribute_Code(
258: p_api_version_number IN NUMBER
259: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
260: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
261: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
262: ,p_attribute_code_rec IN attribute_code_rec_type
263: ,x_return_status OUT NOCOPY VARCHAR2

Line 260: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

256:
257: PROCEDURE Validate_Attribute_Code(
258: p_api_version_number IN NUMBER
259: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
260: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
261: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
262: ,p_attribute_code_rec IN attribute_code_rec_type
263: ,x_return_status OUT NOCOPY VARCHAR2
264: ,x_msg_count OUT NOCOPY NUMBER

Line 298: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

294: -- End of Comments
295:
296: PROCEDURE Validate_Attr_Code_Rec(
297: p_api_version_number IN NUMBER
298: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
299: ,x_return_status OUT NOCOPY VARCHAR2
300: ,x_msg_count OUT NOCOPY NUMBER
301: ,x_msg_data OUT NOCOPY VARCHAR2
302: ,p_attribute_code_rec IN attribute_code_rec_type