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_ENTY_ATTR_VALUE_PUB dependencies on FND_API

Line 42: attr_value VARCHAR2(2000) := FND_API.G_MISS_CHAR

38: -- ===================================================================
39:
40: TYPE attr_val_rec_type IS RECORD
41: (
42: attr_value VARCHAR2(2000) := FND_API.G_MISS_CHAR
43: ,attr_value_extn VARCHAR2(4000) := FND_API.G_MISS_CHAR
44:
45: );
46:

Line 43: ,attr_value_extn VARCHAR2(4000) := FND_API.G_MISS_CHAR

39:
40: TYPE attr_val_rec_type IS RECORD
41: (
42: attr_value VARCHAR2(2000) := FND_API.G_MISS_CHAR
43: ,attr_value_extn VARCHAR2(4000) := FND_API.G_MISS_CHAR
44:
45: );
46:
47: g_miss_attr_val_rec attr_val_rec_type;

Line 63: attribute_id NUMBER := FND_API.G_MISS_NUM

59:
60: TYPE attr_val_rec_group_type IS RECORD
61:
62: (
63: attribute_id NUMBER := FND_API.G_MISS_NUM
64: ,entity VARCHAR2(50) := FND_API.G_MISS_CHAR
65: ,entity_id NUMBER := FND_API.G_MISS_NUM
66: ,version NUMBER := FND_API.G_MISS_NUM
67: ,attr_val_tbl attr_value_table_type := g_miss_attr_value_table_type

Line 64: ,entity VARCHAR2(50) := FND_API.G_MISS_CHAR

60: TYPE attr_val_rec_group_type IS RECORD
61:
62: (
63: attribute_id NUMBER := FND_API.G_MISS_NUM
64: ,entity VARCHAR2(50) := FND_API.G_MISS_CHAR
65: ,entity_id NUMBER := FND_API.G_MISS_NUM
66: ,version NUMBER := FND_API.G_MISS_NUM
67: ,attr_val_tbl attr_value_table_type := g_miss_attr_value_table_type
68: --,attr_value_extn_tbl attr_value_extn_table_type := g_miss_attr_value_extn_table

Line 65: ,entity_id NUMBER := FND_API.G_MISS_NUM

61:
62: (
63: attribute_id NUMBER := FND_API.G_MISS_NUM
64: ,entity VARCHAR2(50) := FND_API.G_MISS_CHAR
65: ,entity_id NUMBER := FND_API.G_MISS_NUM
66: ,version NUMBER := FND_API.G_MISS_NUM
67: ,attr_val_tbl attr_value_table_type := g_miss_attr_value_table_type
68: --,attr_value_extn_tbl attr_value_extn_table_type := g_miss_attr_value_extn_table
69:

Line 66: ,version NUMBER := FND_API.G_MISS_NUM

62: (
63: attribute_id NUMBER := FND_API.G_MISS_NUM
64: ,entity VARCHAR2(50) := FND_API.G_MISS_CHAR
65: ,entity_id NUMBER := FND_API.G_MISS_NUM
66: ,version NUMBER := FND_API.G_MISS_NUM
67: ,attr_val_tbl attr_value_table_type := g_miss_attr_value_table_type
68: --,attr_value_extn_tbl attr_value_extn_table_type := g_miss_attr_value_extn_table
69:
70: );

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

85: -- Parameters
86: --
87: -- IN
88: -- p_api_version_number IN NUMBER Required
89: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
90: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
91: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
92: -- p_attribute_id IN NUMBER Required
93: -- entity IN VARCHAR2 Required

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

86: --
87: -- IN
88: -- p_api_version_number IN NUMBER Required
89: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
90: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
91: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
92: -- p_attribute_id IN NUMBER Required
93: -- entity IN VARCHAR2 Required
94: -- entity_id IN NUMBER Required

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

87: -- IN
88: -- p_api_version_number IN NUMBER Required
89: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
90: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
91: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
92: -- p_attribute_id IN NUMBER Required
93: -- entity IN VARCHAR2 Required
94: -- entity_id IN NUMBER Required
95: -- version IN NUMBER Required

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

108: --
109:
110: PROCEDURE Upsert_Attr_Value(
111: p_api_version_number IN NUMBER
112: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
113: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
114: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
115:
116: ,x_return_status OUT NOCOPY VARCHAR2

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

109:
110: PROCEDURE Upsert_Attr_Value(
111: p_api_version_number IN NUMBER
112: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
113: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
114: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
115:
116: ,x_return_status OUT NOCOPY VARCHAR2
117: ,x_msg_count OUT NOCOPY NUMBER

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

110: PROCEDURE Upsert_Attr_Value(
111: p_api_version_number IN NUMBER
112: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
113: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
114: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
115:
116: ,x_return_status OUT NOCOPY VARCHAR2
117: ,x_msg_count OUT NOCOPY NUMBER
118: ,x_msg_data OUT NOCOPY VARCHAR2

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

136: -- Parameters
137: --
138: -- IN
139: -- p_api_version_number IN NUMBER Required
140: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
141: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
142: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
143: -- p_attr_val_group_tbl IN attr_value_tbl_type Optional Default= g_miss_attr_value_group_tbl
144: --

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

137: --
138: -- IN
139: -- p_api_version_number IN NUMBER Required
140: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
141: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
142: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
143: -- p_attr_val_group_tbl IN attr_value_tbl_type Optional Default= g_miss_attr_value_group_tbl
144: --
145: -- OUT

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

138: -- IN
139: -- p_api_version_number IN NUMBER Required
140: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
141: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
142: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
143: -- p_attr_val_group_tbl IN attr_value_tbl_type Optional Default= g_miss_attr_value_group_tbl
144: --
145: -- OUT
146: -- x_return_status OUT VARCHAR2

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

155: --
156: /*
157: PROCEDURE Upsert_Attr_Value_in_groups(
158: p_api_version_number IN NUMBER
159: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
160: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
161: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
162:
163: ,x_return_status OUT NOCOPY VARCHAR2

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

156: /*
157: PROCEDURE Upsert_Attr_Value_in_groups(
158: p_api_version_number IN NUMBER
159: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
160: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
161: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
162:
163: ,x_return_status OUT NOCOPY VARCHAR2
164: ,x_msg_count OUT NOCOPY NUMBER

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

157: PROCEDURE Upsert_Attr_Value_in_groups(
158: p_api_version_number IN NUMBER
159: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
160: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
161: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
162:
163: ,x_return_status OUT NOCOPY VARCHAR2
164: ,x_msg_count OUT NOCOPY NUMBER
165: ,x_msg_data OUT NOCOPY VARCHAR2

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

180: -- Parameters
181: --
182: -- IN
183: -- p_api_version_number IN NUMBER Required
184: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
185: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
186: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
187: -- p_attr_id_tbl IN JTF_NUMBER_TABLE Required
188: -- entity IN VARCHAR2 Required

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

181: --
182: -- IN
183: -- p_api_version_number IN NUMBER Required
184: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
185: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
186: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
187: -- p_attr_id_tbl IN JTF_NUMBER_TABLE Required
188: -- entity IN VARCHAR2 Required
189: -- entity_id IN NUMBER Required

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

182: -- IN
183: -- p_api_version_number IN NUMBER Required
184: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
185: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
186: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
187: -- p_attr_id_tbl IN JTF_NUMBER_TABLE Required
188: -- entity IN VARCHAR2 Required
189: -- entity_id IN NUMBER Required
190: -- p_partner_id IN NUMBER Required

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

203: --
204:
205: PROCEDURE Copy_Partner_Attr_Values(
206: p_api_version_number IN NUMBER
207: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
208: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
209: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
210:
211: ,x_return_status OUT NOCOPY VARCHAR2

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

204:
205: PROCEDURE Copy_Partner_Attr_Values(
206: p_api_version_number IN NUMBER
207: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
208: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
209: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
210:
211: ,x_return_status OUT NOCOPY VARCHAR2
212: ,x_msg_count OUT NOCOPY NUMBER

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

205: PROCEDURE Copy_Partner_Attr_Values(
206: p_api_version_number IN NUMBER
207: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
208: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
209: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
210:
211: ,x_return_status OUT NOCOPY VARCHAR2
212: ,x_msg_count OUT NOCOPY NUMBER
213: ,x_msg_data OUT NOCOPY VARCHAR2

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

231: -- Parameters
232: --
233: -- IN
234: -- p_api_version_number IN NUMBER Required
235: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
236: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
237: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
238: -- p_entity_id IN NUMBER Required
239: -- p_version IN NUMBER Required

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

232: --
233: -- IN
234: -- p_api_version_number IN NUMBER Required
235: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
236: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
237: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
238: -- p_entity_id IN NUMBER Required
239: -- p_version IN NUMBER Required
240: -- p_attr_val_tbl IN attr_value_tbl_type Required

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

233: -- IN
234: -- p_api_version_number IN NUMBER Required
235: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
236: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
237: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
238: -- p_entity_id IN NUMBER Required
239: -- p_version IN NUMBER Required
240: -- p_attr_val_tbl IN attr_value_tbl_type Required
241:

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

252: -- ==============================================================================
253: --
254: PROCEDURE Upsert_Partner_Types (
255: p_api_version_number IN NUMBER
256: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
257: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
258: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
259: ,x_return_status OUT NOCOPY VARCHAR2
260: ,x_msg_count OUT NOCOPY NUMBER

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

253: --
254: PROCEDURE Upsert_Partner_Types (
255: p_api_version_number IN NUMBER
256: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
257: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
258: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
259: ,x_return_status OUT NOCOPY VARCHAR2
260: ,x_msg_count OUT NOCOPY NUMBER
261: ,x_msg_data OUT NOCOPY VARCHAR2

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

254: PROCEDURE Upsert_Partner_Types (
255: p_api_version_number IN NUMBER
256: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
257: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
258: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
259: ,x_return_status OUT NOCOPY VARCHAR2
260: ,x_msg_count OUT NOCOPY NUMBER
261: ,x_msg_data OUT NOCOPY VARCHAR2
262: ,p_entity_id IN NUMBER