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

Line 54: entity_attr_id NUMBER := Fnd_Api.G_MISS_NUM

50: --===================================================================
51:
52: TYPE entity_attr_rec_type IS RECORD
53: (
54: entity_attr_id NUMBER := Fnd_Api.G_MISS_NUM
55: ,last_update_date DATE := Fnd_Api.G_MISS_DATE
56: ,last_updated_by NUMBER := Fnd_Api.G_MISS_NUM
57: ,creation_date DATE := Fnd_Api.G_MISS_DATE
58: ,created_by NUMBER := Fnd_Api.G_MISS_NUM

Line 55: ,last_update_date DATE := Fnd_Api.G_MISS_DATE

51:
52: TYPE entity_attr_rec_type IS RECORD
53: (
54: entity_attr_id NUMBER := Fnd_Api.G_MISS_NUM
55: ,last_update_date DATE := Fnd_Api.G_MISS_DATE
56: ,last_updated_by NUMBER := Fnd_Api.G_MISS_NUM
57: ,creation_date DATE := Fnd_Api.G_MISS_DATE
58: ,created_by NUMBER := Fnd_Api.G_MISS_NUM
59: ,last_update_login NUMBER := Fnd_Api.G_MISS_NUM

Line 56: ,last_updated_by NUMBER := Fnd_Api.G_MISS_NUM

52: TYPE entity_attr_rec_type IS RECORD
53: (
54: entity_attr_id NUMBER := Fnd_Api.G_MISS_NUM
55: ,last_update_date DATE := Fnd_Api.G_MISS_DATE
56: ,last_updated_by NUMBER := Fnd_Api.G_MISS_NUM
57: ,creation_date DATE := Fnd_Api.G_MISS_DATE
58: ,created_by NUMBER := Fnd_Api.G_MISS_NUM
59: ,last_update_login NUMBER := Fnd_Api.G_MISS_NUM
60: ,object_version_number NUMBER := Fnd_Api.G_MISS_NUM

Line 57: ,creation_date DATE := Fnd_Api.G_MISS_DATE

53: (
54: entity_attr_id NUMBER := Fnd_Api.G_MISS_NUM
55: ,last_update_date DATE := Fnd_Api.G_MISS_DATE
56: ,last_updated_by NUMBER := Fnd_Api.G_MISS_NUM
57: ,creation_date DATE := Fnd_Api.G_MISS_DATE
58: ,created_by NUMBER := Fnd_Api.G_MISS_NUM
59: ,last_update_login NUMBER := Fnd_Api.G_MISS_NUM
60: ,object_version_number NUMBER := Fnd_Api.G_MISS_NUM
61: ,attribute_id NUMBER := Fnd_Api.G_MISS_NUM

Line 58: ,created_by NUMBER := Fnd_Api.G_MISS_NUM

54: entity_attr_id NUMBER := Fnd_Api.G_MISS_NUM
55: ,last_update_date DATE := Fnd_Api.G_MISS_DATE
56: ,last_updated_by NUMBER := Fnd_Api.G_MISS_NUM
57: ,creation_date DATE := Fnd_Api.G_MISS_DATE
58: ,created_by NUMBER := Fnd_Api.G_MISS_NUM
59: ,last_update_login NUMBER := Fnd_Api.G_MISS_NUM
60: ,object_version_number NUMBER := Fnd_Api.G_MISS_NUM
61: ,attribute_id NUMBER := Fnd_Api.G_MISS_NUM
62: ,entity VARCHAR2(30) := Fnd_Api.G_MISS_CHAR

Line 59: ,last_update_login NUMBER := Fnd_Api.G_MISS_NUM

55: ,last_update_date DATE := Fnd_Api.G_MISS_DATE
56: ,last_updated_by NUMBER := Fnd_Api.G_MISS_NUM
57: ,creation_date DATE := Fnd_Api.G_MISS_DATE
58: ,created_by NUMBER := Fnd_Api.G_MISS_NUM
59: ,last_update_login NUMBER := Fnd_Api.G_MISS_NUM
60: ,object_version_number NUMBER := Fnd_Api.G_MISS_NUM
61: ,attribute_id NUMBER := Fnd_Api.G_MISS_NUM
62: ,entity VARCHAR2(30) := Fnd_Api.G_MISS_CHAR
63: ,entity_type VARCHAR2(30) := Fnd_Api.G_MISS_CHAR

Line 60: ,object_version_number NUMBER := Fnd_Api.G_MISS_NUM

56: ,last_updated_by NUMBER := Fnd_Api.G_MISS_NUM
57: ,creation_date DATE := Fnd_Api.G_MISS_DATE
58: ,created_by NUMBER := Fnd_Api.G_MISS_NUM
59: ,last_update_login NUMBER := Fnd_Api.G_MISS_NUM
60: ,object_version_number NUMBER := Fnd_Api.G_MISS_NUM
61: ,attribute_id NUMBER := Fnd_Api.G_MISS_NUM
62: ,entity VARCHAR2(30) := Fnd_Api.G_MISS_CHAR
63: ,entity_type VARCHAR2(30) := Fnd_Api.G_MISS_CHAR
64: ,sql_text VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR

Line 61: ,attribute_id NUMBER := Fnd_Api.G_MISS_NUM

57: ,creation_date DATE := Fnd_Api.G_MISS_DATE
58: ,created_by NUMBER := Fnd_Api.G_MISS_NUM
59: ,last_update_login NUMBER := Fnd_Api.G_MISS_NUM
60: ,object_version_number NUMBER := Fnd_Api.G_MISS_NUM
61: ,attribute_id NUMBER := Fnd_Api.G_MISS_NUM
62: ,entity VARCHAR2(30) := Fnd_Api.G_MISS_CHAR
63: ,entity_type VARCHAR2(30) := Fnd_Api.G_MISS_CHAR
64: ,sql_text VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
65: ,attr_data_type VARCHAR2(30) := Fnd_Api.G_MISS_CHAR

Line 62: ,entity VARCHAR2(30) := Fnd_Api.G_MISS_CHAR

58: ,created_by NUMBER := Fnd_Api.G_MISS_NUM
59: ,last_update_login NUMBER := Fnd_Api.G_MISS_NUM
60: ,object_version_number NUMBER := Fnd_Api.G_MISS_NUM
61: ,attribute_id NUMBER := Fnd_Api.G_MISS_NUM
62: ,entity VARCHAR2(30) := Fnd_Api.G_MISS_CHAR
63: ,entity_type VARCHAR2(30) := Fnd_Api.G_MISS_CHAR
64: ,sql_text VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
65: ,attr_data_type VARCHAR2(30) := Fnd_Api.G_MISS_CHAR
66: ,lov_string VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR

Line 63: ,entity_type VARCHAR2(30) := Fnd_Api.G_MISS_CHAR

59: ,last_update_login NUMBER := Fnd_Api.G_MISS_NUM
60: ,object_version_number NUMBER := Fnd_Api.G_MISS_NUM
61: ,attribute_id NUMBER := Fnd_Api.G_MISS_NUM
62: ,entity VARCHAR2(30) := Fnd_Api.G_MISS_CHAR
63: ,entity_type VARCHAR2(30) := Fnd_Api.G_MISS_CHAR
64: ,sql_text VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
65: ,attr_data_type VARCHAR2(30) := Fnd_Api.G_MISS_CHAR
66: ,lov_string VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
67: ,enabled_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR

Line 64: ,sql_text VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR

60: ,object_version_number NUMBER := Fnd_Api.G_MISS_NUM
61: ,attribute_id NUMBER := Fnd_Api.G_MISS_NUM
62: ,entity VARCHAR2(30) := Fnd_Api.G_MISS_CHAR
63: ,entity_type VARCHAR2(30) := Fnd_Api.G_MISS_CHAR
64: ,sql_text VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
65: ,attr_data_type VARCHAR2(30) := Fnd_Api.G_MISS_CHAR
66: ,lov_string VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
67: ,enabled_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
68: ,display_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR

Line 65: ,attr_data_type VARCHAR2(30) := Fnd_Api.G_MISS_CHAR

61: ,attribute_id NUMBER := Fnd_Api.G_MISS_NUM
62: ,entity VARCHAR2(30) := Fnd_Api.G_MISS_CHAR
63: ,entity_type VARCHAR2(30) := Fnd_Api.G_MISS_CHAR
64: ,sql_text VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
65: ,attr_data_type VARCHAR2(30) := Fnd_Api.G_MISS_CHAR
66: ,lov_string VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
67: ,enabled_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
68: ,display_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
69: ,locator_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR

Line 66: ,lov_string VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR

62: ,entity VARCHAR2(30) := Fnd_Api.G_MISS_CHAR
63: ,entity_type VARCHAR2(30) := Fnd_Api.G_MISS_CHAR
64: ,sql_text VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
65: ,attr_data_type VARCHAR2(30) := Fnd_Api.G_MISS_CHAR
66: ,lov_string VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
67: ,enabled_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
68: ,display_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
69: ,locator_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
70: ,require_validation_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR

Line 67: ,enabled_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR

63: ,entity_type VARCHAR2(30) := Fnd_Api.G_MISS_CHAR
64: ,sql_text VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
65: ,attr_data_type VARCHAR2(30) := Fnd_Api.G_MISS_CHAR
66: ,lov_string VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
67: ,enabled_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
68: ,display_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
69: ,locator_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
70: ,require_validation_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
71: ,external_update_text VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR

Line 68: ,display_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR

64: ,sql_text VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
65: ,attr_data_type VARCHAR2(30) := Fnd_Api.G_MISS_CHAR
66: ,lov_string VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
67: ,enabled_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
68: ,display_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
69: ,locator_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
70: ,require_validation_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
71: ,external_update_text VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
72: ,refresh_frequency NUMBER := Fnd_Api.G_MISS_NUM

Line 69: ,locator_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR

65: ,attr_data_type VARCHAR2(30) := Fnd_Api.G_MISS_CHAR
66: ,lov_string VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
67: ,enabled_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
68: ,display_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
69: ,locator_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
70: ,require_validation_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
71: ,external_update_text VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
72: ,refresh_frequency NUMBER := Fnd_Api.G_MISS_NUM
73: ,refresh_frequency_uom VARCHAR2(20) := Fnd_Api.G_MISS_CHAR

Line 70: ,require_validation_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR

66: ,lov_string VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
67: ,enabled_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
68: ,display_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
69: ,locator_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
70: ,require_validation_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
71: ,external_update_text VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
72: ,refresh_frequency NUMBER := Fnd_Api.G_MISS_NUM
73: ,refresh_frequency_uom VARCHAR2(20) := Fnd_Api.G_MISS_CHAR
74: ,batch_sql_text VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR

Line 71: ,external_update_text VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR

67: ,enabled_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
68: ,display_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
69: ,locator_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
70: ,require_validation_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
71: ,external_update_text VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
72: ,refresh_frequency NUMBER := Fnd_Api.G_MISS_NUM
73: ,refresh_frequency_uom VARCHAR2(20) := Fnd_Api.G_MISS_CHAR
74: ,batch_sql_text VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
75: ,last_refresh_date DATE := Fnd_Api.G_MISS_DATE

Line 72: ,refresh_frequency NUMBER := Fnd_Api.G_MISS_NUM

68: ,display_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
69: ,locator_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
70: ,require_validation_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
71: ,external_update_text VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
72: ,refresh_frequency NUMBER := Fnd_Api.G_MISS_NUM
73: ,refresh_frequency_uom VARCHAR2(20) := Fnd_Api.G_MISS_CHAR
74: ,batch_sql_text VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
75: ,last_refresh_date DATE := Fnd_Api.G_MISS_DATE
76: ,display_external_value_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR);

Line 73: ,refresh_frequency_uom VARCHAR2(20) := Fnd_Api.G_MISS_CHAR

69: ,locator_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
70: ,require_validation_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
71: ,external_update_text VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
72: ,refresh_frequency NUMBER := Fnd_Api.G_MISS_NUM
73: ,refresh_frequency_uom VARCHAR2(20) := Fnd_Api.G_MISS_CHAR
74: ,batch_sql_text VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
75: ,last_refresh_date DATE := Fnd_Api.G_MISS_DATE
76: ,display_external_value_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR);
77:

Line 74: ,batch_sql_text VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR

70: ,require_validation_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
71: ,external_update_text VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
72: ,refresh_frequency NUMBER := Fnd_Api.G_MISS_NUM
73: ,refresh_frequency_uom VARCHAR2(20) := Fnd_Api.G_MISS_CHAR
74: ,batch_sql_text VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
75: ,last_refresh_date DATE := Fnd_Api.G_MISS_DATE
76: ,display_external_value_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR);
77:
78: g_miss_entity_attr_rec entity_attr_rec_type;

Line 75: ,last_refresh_date DATE := Fnd_Api.G_MISS_DATE

71: ,external_update_text VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
72: ,refresh_frequency NUMBER := Fnd_Api.G_MISS_NUM
73: ,refresh_frequency_uom VARCHAR2(20) := Fnd_Api.G_MISS_CHAR
74: ,batch_sql_text VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
75: ,last_refresh_date DATE := Fnd_Api.G_MISS_DATE
76: ,display_external_value_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR);
77:
78: g_miss_entity_attr_rec entity_attr_rec_type;
79:

Line 76: ,display_external_value_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR);

72: ,refresh_frequency NUMBER := Fnd_Api.G_MISS_NUM
73: ,refresh_frequency_uom VARCHAR2(20) := Fnd_Api.G_MISS_CHAR
74: ,batch_sql_text VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
75: ,last_refresh_date DATE := Fnd_Api.G_MISS_DATE
76: ,display_external_value_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR);
77:
78: g_miss_entity_attr_rec entity_attr_rec_type;
79:
80: TYPE pv_entity_attr_tbl_type IS TABLE OF entity_attr_rec_type INDEX BY BINARY_INTEGER;

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

93: -- Parameters
94: --
95: -- IN
96: -- p_api_version_number IN NUMBER Required
97: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
98: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
99: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
100: -- p_entity_attr_rec IN entity_attr_rec_type Required
101: --

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

94: --
95: -- IN
96: -- p_api_version_number IN NUMBER Required
97: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
98: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
99: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
100: -- p_entity_attr_rec IN entity_attr_rec_type Required
101: --
102: -- OUT

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

95: -- IN
96: -- p_api_version_number IN NUMBER Required
97: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
98: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
99: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
100: -- p_entity_attr_rec IN entity_attr_rec_type Required
101: --
102: -- OUT
103: -- x_return_status OUT VARCHAR2

Line 115: ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE

111: -- ==============================================================================
112: --
113: Procedure Create_Entity_Attr(
114: p_api_version_number IN NUMBER
115: ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE
116: ,p_commit IN VARCHAR2 := Fnd_Api.G_FALSE
117: ,p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL
118:
119: ,x_return_status OUT NOCOPY VARCHAR2

Line 116: ,p_commit IN VARCHAR2 := Fnd_Api.G_FALSE

112: --
113: Procedure Create_Entity_Attr(
114: p_api_version_number IN NUMBER
115: ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE
116: ,p_commit IN VARCHAR2 := Fnd_Api.G_FALSE
117: ,p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL
118:
119: ,x_return_status OUT NOCOPY VARCHAR2
120: ,x_msg_count OUT NOCOPY NUMBER

Line 117: ,p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL

113: Procedure Create_Entity_Attr(
114: p_api_version_number IN NUMBER
115: ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE
116: ,p_commit IN VARCHAR2 := Fnd_Api.G_FALSE
117: ,p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL
118:
119: ,x_return_status OUT NOCOPY VARCHAR2
120: ,x_msg_count OUT NOCOPY NUMBER
121: ,x_msg_data OUT NOCOPY VARCHAR2

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

137: -- Parameters
138: --
139: -- IN
140: -- p_api_version_number IN NUMBER Required
141: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
142: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
143: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
144: -- p_entity_attr_rec IN entity_attr_rec_type Required
145: --

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

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

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

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

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

155: -- ==============================================================================
156: --
157: PROCEDURE Update_Entity_Attr(
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 Update_Entity_Attr(
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 Update_Entity_Attr(
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 185: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

181: -- Parameters
182: --
183: -- IN
184: -- p_api_version_number IN NUMBER Required
185: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
186: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
187: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
188: -- p_ENTITY_ATTR_ID IN NUMBER
189: -- p_object_version_number IN NUMBER Optional Default = NULL

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

182: --
183: -- IN
184: -- p_api_version_number IN NUMBER Required
185: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
186: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
187: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
188: -- p_ENTITY_ATTR_ID IN NUMBER
189: -- p_object_version_number IN NUMBER Optional Default = NULL
190: --

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

183: -- IN
184: -- p_api_version_number IN NUMBER Required
185: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
186: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
187: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
188: -- p_ENTITY_ATTR_ID IN NUMBER
189: -- p_object_version_number IN NUMBER Optional Default = NULL
190: --
191: -- OUT

Line 204: ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE

200: -- ==============================================================================
201: --
202: PROCEDURE Delete_Entity_Attr(
203: p_api_version_number IN NUMBER
204: ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE
205: ,p_commit IN VARCHAR2 := Fnd_Api.G_FALSE
206: ,p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL
207: ,x_return_status OUT NOCOPY VARCHAR2
208: ,x_msg_count OUT NOCOPY NUMBER

Line 205: ,p_commit IN VARCHAR2 := Fnd_Api.G_FALSE

201: --
202: PROCEDURE Delete_Entity_Attr(
203: p_api_version_number IN NUMBER
204: ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE
205: ,p_commit IN VARCHAR2 := Fnd_Api.G_FALSE
206: ,p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL
207: ,x_return_status OUT NOCOPY VARCHAR2
208: ,x_msg_count OUT NOCOPY NUMBER
209: ,x_msg_data OUT NOCOPY VARCHAR2

Line 206: ,p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL

202: PROCEDURE Delete_Entity_Attr(
203: p_api_version_number IN NUMBER
204: ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE
205: ,p_commit IN VARCHAR2 := Fnd_Api.G_FALSE
206: ,p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL
207: ,x_return_status OUT NOCOPY VARCHAR2
208: ,x_msg_count OUT NOCOPY NUMBER
209: ,x_msg_data OUT NOCOPY VARCHAR2
210: ,p_entity_attr_id IN NUMBER

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

224: -- Parameters
225: --
226: -- IN
227: -- p_api_version_number IN NUMBER Required
228: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
229: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
230: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
231: -- p_entity_attr_rec IN entity_attr_rec_type Required
232: --

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

225: --
226: -- IN
227: -- p_api_version_number IN NUMBER Required
228: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
229: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
230: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
231: -- p_entity_attr_rec IN entity_attr_rec_type Required
232: --
233: -- OUT

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

226: -- IN
227: -- p_api_version_number IN NUMBER Required
228: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
229: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
230: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
231: -- p_entity_attr_rec IN entity_attr_rec_type Required
232: --
233: -- OUT
234: -- x_return_status OUT VARCHAR2

Line 246: ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE

242: -- ==============================================================================
243: --
244: PROCEDURE Lock_Entity_Attr(
245: p_api_version_number IN NUMBER
246: ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE
247: ,x_return_status OUT NOCOPY VARCHAR2
248: ,x_msg_count OUT NOCOPY NUMBER
249: ,x_msg_data OUT NOCOPY VARCHAR2
250: ,p_entity_attr_id IN NUMBER

Line 268: ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE

264: -- End of Comments
265:
266: PROCEDURE Validate_Entity_Attr(
267: p_api_version_number IN NUMBER
268: ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE
269: ,p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL
270: ,p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.G_UPDATE
271: ,p_entity_attr_rec IN entity_attr_rec_type
272: ,x_return_status OUT NOCOPY VARCHAR2

Line 269: ,p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL

265:
266: PROCEDURE Validate_Entity_Attr(
267: p_api_version_number IN NUMBER
268: ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE
269: ,p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL
270: ,p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.G_UPDATE
271: ,p_entity_attr_rec IN entity_attr_rec_type
272: ,x_return_status OUT NOCOPY VARCHAR2
273: ,x_msg_count OUT NOCOPY NUMBER

Line 309: ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE

305: -- End of Comments
306:
307: PROCEDURE Validate_Entity_Attr_Rec(
308: p_api_version_number IN NUMBER
309: ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE
310: ,x_return_status OUT NOCOPY VARCHAR2
311: ,x_msg_count OUT NOCOPY NUMBER
312: ,x_msg_data OUT NOCOPY VARCHAR2
313: ,p_entity_attr_rec IN entity_attr_rec_type

Line 320: ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE

316:
317:
318: PROCEDURE Validate_sql_text(
319: p_api_version_number IN NUMBER
320: ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE
321: ,p_commit IN VARCHAR2 := Fnd_Api.G_FALSE
322: ,p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL
323: ,x_return_status OUT NOCOPY VARCHAR2
324: ,x_msg_count OUT NOCOPY NUMBER

Line 321: ,p_commit IN VARCHAR2 := Fnd_Api.G_FALSE

317:
318: PROCEDURE Validate_sql_text(
319: p_api_version_number IN NUMBER
320: ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE
321: ,p_commit IN VARCHAR2 := Fnd_Api.G_FALSE
322: ,p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL
323: ,x_return_status OUT NOCOPY VARCHAR2
324: ,x_msg_count OUT NOCOPY NUMBER
325: ,x_msg_data OUT NOCOPY VARCHAR2

Line 322: ,p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL

318: PROCEDURE Validate_sql_text(
319: p_api_version_number IN NUMBER
320: ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE
321: ,p_commit IN VARCHAR2 := Fnd_Api.G_FALSE
322: ,p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL
323: ,x_return_status OUT NOCOPY VARCHAR2
324: ,x_msg_count OUT NOCOPY NUMBER
325: ,x_msg_data OUT NOCOPY VARCHAR2
326:

Line 334: ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE

330: );
331:
332: PROCEDURE Validate_Lov_String(
333: p_api_version_number IN NUMBER
334: ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE
335: ,p_commit IN VARCHAR2 := Fnd_Api.G_FALSE
336: ,p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL
337: ,x_return_status OUT NOCOPY VARCHAR2
338: ,x_msg_count OUT NOCOPY NUMBER

Line 335: ,p_commit IN VARCHAR2 := Fnd_Api.G_FALSE

331:
332: PROCEDURE Validate_Lov_String(
333: p_api_version_number IN NUMBER
334: ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE
335: ,p_commit IN VARCHAR2 := Fnd_Api.G_FALSE
336: ,p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL
337: ,x_return_status OUT NOCOPY VARCHAR2
338: ,x_msg_count OUT NOCOPY NUMBER
339: ,x_msg_data OUT NOCOPY VARCHAR2

Line 336: ,p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL

332: PROCEDURE Validate_Lov_String(
333: p_api_version_number IN NUMBER
334: ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE
335: ,p_commit IN VARCHAR2 := Fnd_Api.G_FALSE
336: ,p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL
337: ,x_return_status OUT NOCOPY VARCHAR2
338: ,x_msg_count OUT NOCOPY NUMBER
339: ,x_msg_data OUT NOCOPY VARCHAR2
340: