DBA Data[Home] [Help]

APPS.PV_ATTRIBUTE_PVT dependencies on FND_API

Line 66: attribute_id NUMBER := FND_API.G_MISS_NUM

62:
63: --===================================================================
64: TYPE attribute_rec_type IS RECORD
65: (
66: attribute_id NUMBER := FND_API.G_MISS_NUM
67: ,last_update_date DATE := FND_API.G_MISS_DATE
68: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
69: ,creation_date DATE := FND_API.G_MISS_DATE
70: ,created_by NUMBER := FND_API.G_MISS_NUM

Line 67: ,last_update_date DATE := FND_API.G_MISS_DATE

63: --===================================================================
64: TYPE attribute_rec_type IS RECORD
65: (
66: attribute_id NUMBER := FND_API.G_MISS_NUM
67: ,last_update_date DATE := FND_API.G_MISS_DATE
68: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
69: ,creation_date DATE := FND_API.G_MISS_DATE
70: ,created_by NUMBER := FND_API.G_MISS_NUM
71: ,last_update_login NUMBER := FND_API.G_MISS_NUM

Line 68: ,last_updated_by NUMBER := FND_API.G_MISS_NUM

64: TYPE attribute_rec_type IS RECORD
65: (
66: attribute_id NUMBER := FND_API.G_MISS_NUM
67: ,last_update_date DATE := FND_API.G_MISS_DATE
68: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
69: ,creation_date DATE := FND_API.G_MISS_DATE
70: ,created_by NUMBER := FND_API.G_MISS_NUM
71: ,last_update_login NUMBER := FND_API.G_MISS_NUM
72: ,object_version_number NUMBER := FND_API.G_MISS_NUM

Line 69: ,creation_date DATE := FND_API.G_MISS_DATE

65: (
66: attribute_id NUMBER := FND_API.G_MISS_NUM
67: ,last_update_date DATE := FND_API.G_MISS_DATE
68: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
69: ,creation_date DATE := FND_API.G_MISS_DATE
70: ,created_by NUMBER := FND_API.G_MISS_NUM
71: ,last_update_login NUMBER := FND_API.G_MISS_NUM
72: ,object_version_number NUMBER := FND_API.G_MISS_NUM
73: --,security_group_id NUMBER := FND_API.G_MISS_NUM

Line 70: ,created_by NUMBER := FND_API.G_MISS_NUM

66: attribute_id NUMBER := FND_API.G_MISS_NUM
67: ,last_update_date DATE := FND_API.G_MISS_DATE
68: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
69: ,creation_date DATE := FND_API.G_MISS_DATE
70: ,created_by NUMBER := FND_API.G_MISS_NUM
71: ,last_update_login NUMBER := FND_API.G_MISS_NUM
72: ,object_version_number NUMBER := FND_API.G_MISS_NUM
73: --,security_group_id NUMBER := FND_API.G_MISS_NUM
74: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 71: ,last_update_login NUMBER := FND_API.G_MISS_NUM

67: ,last_update_date DATE := FND_API.G_MISS_DATE
68: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
69: ,creation_date DATE := FND_API.G_MISS_DATE
70: ,created_by NUMBER := FND_API.G_MISS_NUM
71: ,last_update_login NUMBER := FND_API.G_MISS_NUM
72: ,object_version_number NUMBER := FND_API.G_MISS_NUM
73: --,security_group_id NUMBER := FND_API.G_MISS_NUM
74: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
75: ,attribute_type VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 72: ,object_version_number NUMBER := FND_API.G_MISS_NUM

68: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
69: ,creation_date DATE := FND_API.G_MISS_DATE
70: ,created_by NUMBER := FND_API.G_MISS_NUM
71: ,last_update_login NUMBER := FND_API.G_MISS_NUM
72: ,object_version_number NUMBER := FND_API.G_MISS_NUM
73: --,security_group_id NUMBER := FND_API.G_MISS_NUM
74: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
75: ,attribute_type VARCHAR2(30) := FND_API.G_MISS_CHAR
76: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR

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

69: ,creation_date DATE := FND_API.G_MISS_DATE
70: ,created_by NUMBER := FND_API.G_MISS_NUM
71: ,last_update_login NUMBER := FND_API.G_MISS_NUM
72: ,object_version_number NUMBER := FND_API.G_MISS_NUM
73: --,security_group_id NUMBER := FND_API.G_MISS_NUM
74: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
75: ,attribute_type VARCHAR2(30) := FND_API.G_MISS_CHAR
76: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
77: ,seeded_flag VARCHAR2(30) := FND_API.G_MISS_CHAR

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

70: ,created_by NUMBER := FND_API.G_MISS_NUM
71: ,last_update_login NUMBER := FND_API.G_MISS_NUM
72: ,object_version_number NUMBER := FND_API.G_MISS_NUM
73: --,security_group_id NUMBER := FND_API.G_MISS_NUM
74: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
75: ,attribute_type VARCHAR2(30) := FND_API.G_MISS_CHAR
76: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
77: ,seeded_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
78: ,lov_function_name VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 75: ,attribute_type VARCHAR2(30) := FND_API.G_MISS_CHAR

71: ,last_update_login NUMBER := FND_API.G_MISS_NUM
72: ,object_version_number NUMBER := FND_API.G_MISS_NUM
73: --,security_group_id NUMBER := FND_API.G_MISS_NUM
74: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
75: ,attribute_type VARCHAR2(30) := FND_API.G_MISS_CHAR
76: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
77: ,seeded_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
78: ,lov_function_name VARCHAR2(30) := FND_API.G_MISS_CHAR
79: ,return_type VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 76: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR

72: ,object_version_number NUMBER := FND_API.G_MISS_NUM
73: --,security_group_id NUMBER := FND_API.G_MISS_NUM
74: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
75: ,attribute_type VARCHAR2(30) := FND_API.G_MISS_CHAR
76: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
77: ,seeded_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
78: ,lov_function_name VARCHAR2(30) := FND_API.G_MISS_CHAR
79: ,return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
80: ,max_value_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 77: ,seeded_flag VARCHAR2(30) := FND_API.G_MISS_CHAR

73: --,security_group_id NUMBER := FND_API.G_MISS_NUM
74: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
75: ,attribute_type VARCHAR2(30) := FND_API.G_MISS_CHAR
76: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
77: ,seeded_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
78: ,lov_function_name VARCHAR2(30) := FND_API.G_MISS_CHAR
79: ,return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
80: ,max_value_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
81: ,name VARCHAR2(60) := FND_API.G_MISS_CHAR

Line 78: ,lov_function_name VARCHAR2(30) := FND_API.G_MISS_CHAR

74: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
75: ,attribute_type VARCHAR2(30) := FND_API.G_MISS_CHAR
76: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
77: ,seeded_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
78: ,lov_function_name VARCHAR2(30) := FND_API.G_MISS_CHAR
79: ,return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
80: ,max_value_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
81: ,name VARCHAR2(60) := FND_API.G_MISS_CHAR
82: ,description VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 79: ,return_type VARCHAR2(30) := FND_API.G_MISS_CHAR

75: ,attribute_type VARCHAR2(30) := FND_API.G_MISS_CHAR
76: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
77: ,seeded_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
78: ,lov_function_name VARCHAR2(30) := FND_API.G_MISS_CHAR
79: ,return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
80: ,max_value_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
81: ,name VARCHAR2(60) := FND_API.G_MISS_CHAR
82: ,description VARCHAR2(240) := FND_API.G_MISS_CHAR
83: ,short_name VARCHAR2(60) := FND_API.G_MISS_CHAR

Line 80: ,max_value_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

76: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
77: ,seeded_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
78: ,lov_function_name VARCHAR2(30) := FND_API.G_MISS_CHAR
79: ,return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
80: ,max_value_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
81: ,name VARCHAR2(60) := FND_API.G_MISS_CHAR
82: ,description VARCHAR2(240) := FND_API.G_MISS_CHAR
83: ,short_name VARCHAR2(60) := FND_API.G_MISS_CHAR
84: ,display_style VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 81: ,name VARCHAR2(60) := FND_API.G_MISS_CHAR

77: ,seeded_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
78: ,lov_function_name VARCHAR2(30) := FND_API.G_MISS_CHAR
79: ,return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
80: ,max_value_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
81: ,name VARCHAR2(60) := FND_API.G_MISS_CHAR
82: ,description VARCHAR2(240) := FND_API.G_MISS_CHAR
83: ,short_name VARCHAR2(60) := FND_API.G_MISS_CHAR
84: ,display_style VARCHAR2(30) := FND_API.G_MISS_CHAR
85: ,character_width NUMBER := FND_API.G_MISS_NUM

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

78: ,lov_function_name VARCHAR2(30) := FND_API.G_MISS_CHAR
79: ,return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
80: ,max_value_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
81: ,name VARCHAR2(60) := FND_API.G_MISS_CHAR
82: ,description VARCHAR2(240) := FND_API.G_MISS_CHAR
83: ,short_name VARCHAR2(60) := FND_API.G_MISS_CHAR
84: ,display_style VARCHAR2(30) := FND_API.G_MISS_CHAR
85: ,character_width NUMBER := FND_API.G_MISS_NUM
86: ,decimal_points NUMBER := FND_API.G_MISS_NUM

Line 83: ,short_name VARCHAR2(60) := FND_API.G_MISS_CHAR

79: ,return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
80: ,max_value_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
81: ,name VARCHAR2(60) := FND_API.G_MISS_CHAR
82: ,description VARCHAR2(240) := FND_API.G_MISS_CHAR
83: ,short_name VARCHAR2(60) := FND_API.G_MISS_CHAR
84: ,display_style VARCHAR2(30) := FND_API.G_MISS_CHAR
85: ,character_width NUMBER := FND_API.G_MISS_NUM
86: ,decimal_points NUMBER := FND_API.G_MISS_NUM
87: ,no_of_lines NUMBER := FND_API.G_MISS_NUM

Line 84: ,display_style VARCHAR2(30) := FND_API.G_MISS_CHAR

80: ,max_value_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
81: ,name VARCHAR2(60) := FND_API.G_MISS_CHAR
82: ,description VARCHAR2(240) := FND_API.G_MISS_CHAR
83: ,short_name VARCHAR2(60) := FND_API.G_MISS_CHAR
84: ,display_style VARCHAR2(30) := FND_API.G_MISS_CHAR
85: ,character_width NUMBER := FND_API.G_MISS_NUM
86: ,decimal_points NUMBER := FND_API.G_MISS_NUM
87: ,no_of_lines NUMBER := FND_API.G_MISS_NUM
88: ,expose_to_partner_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 85: ,character_width NUMBER := FND_API.G_MISS_NUM

81: ,name VARCHAR2(60) := FND_API.G_MISS_CHAR
82: ,description VARCHAR2(240) := FND_API.G_MISS_CHAR
83: ,short_name VARCHAR2(60) := FND_API.G_MISS_CHAR
84: ,display_style VARCHAR2(30) := FND_API.G_MISS_CHAR
85: ,character_width NUMBER := FND_API.G_MISS_NUM
86: ,decimal_points NUMBER := FND_API.G_MISS_NUM
87: ,no_of_lines NUMBER := FND_API.G_MISS_NUM
88: ,expose_to_partner_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
89: ,value_extn_return_type VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 86: ,decimal_points NUMBER := FND_API.G_MISS_NUM

82: ,description VARCHAR2(240) := FND_API.G_MISS_CHAR
83: ,short_name VARCHAR2(60) := FND_API.G_MISS_CHAR
84: ,display_style VARCHAR2(30) := FND_API.G_MISS_CHAR
85: ,character_width NUMBER := FND_API.G_MISS_NUM
86: ,decimal_points NUMBER := FND_API.G_MISS_NUM
87: ,no_of_lines NUMBER := FND_API.G_MISS_NUM
88: ,expose_to_partner_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
89: ,value_extn_return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
90: ,enable_matching_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 87: ,no_of_lines NUMBER := FND_API.G_MISS_NUM

83: ,short_name VARCHAR2(60) := FND_API.G_MISS_CHAR
84: ,display_style VARCHAR2(30) := FND_API.G_MISS_CHAR
85: ,character_width NUMBER := FND_API.G_MISS_NUM
86: ,decimal_points NUMBER := FND_API.G_MISS_NUM
87: ,no_of_lines NUMBER := FND_API.G_MISS_NUM
88: ,expose_to_partner_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
89: ,value_extn_return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
90: ,enable_matching_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
91: ,performance_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 88: ,expose_to_partner_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

84: ,display_style VARCHAR2(30) := FND_API.G_MISS_CHAR
85: ,character_width NUMBER := FND_API.G_MISS_NUM
86: ,decimal_points NUMBER := FND_API.G_MISS_NUM
87: ,no_of_lines NUMBER := FND_API.G_MISS_NUM
88: ,expose_to_partner_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
89: ,value_extn_return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
90: ,enable_matching_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
91: ,performance_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
92: ,additive_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 89: ,value_extn_return_type VARCHAR2(30) := FND_API.G_MISS_CHAR

85: ,character_width NUMBER := FND_API.G_MISS_NUM
86: ,decimal_points NUMBER := FND_API.G_MISS_NUM
87: ,no_of_lines NUMBER := FND_API.G_MISS_NUM
88: ,expose_to_partner_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
89: ,value_extn_return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
90: ,enable_matching_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
91: ,performance_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
92: ,additive_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
93: ,sequence_number NUMBER := FND_API.G_MISS_NUM

Line 90: ,enable_matching_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

86: ,decimal_points NUMBER := FND_API.G_MISS_NUM
87: ,no_of_lines NUMBER := FND_API.G_MISS_NUM
88: ,expose_to_partner_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
89: ,value_extn_return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
90: ,enable_matching_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
91: ,performance_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
92: ,additive_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
93: ,sequence_number NUMBER := FND_API.G_MISS_NUM
94: );

Line 91: ,performance_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

87: ,no_of_lines NUMBER := FND_API.G_MISS_NUM
88: ,expose_to_partner_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
89: ,value_extn_return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
90: ,enable_matching_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
91: ,performance_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
92: ,additive_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
93: ,sequence_number NUMBER := FND_API.G_MISS_NUM
94: );
95:

Line 92: ,additive_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

88: ,expose_to_partner_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
89: ,value_extn_return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
90: ,enable_matching_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
91: ,performance_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
92: ,additive_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
93: ,sequence_number NUMBER := FND_API.G_MISS_NUM
94: );
95:
96: g_miss_attribute_rec attribute_rec_type;

Line 93: ,sequence_number NUMBER := FND_API.G_MISS_NUM

89: ,value_extn_return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
90: ,enable_matching_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
91: ,performance_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
92: ,additive_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
93: ,sequence_number NUMBER := FND_API.G_MISS_NUM
94: );
95:
96: g_miss_attribute_rec attribute_rec_type;
97: TYPE attribute_tbl_type IS TABLE OF attribute_rec_type INDEX BY BINARY_INTEGER;

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

109: -- Parameters
110: --
111: -- IN
112: -- p_api_version_number IN NUMBER Required
113: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
114: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
115: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
116: -- p_attribute_rec IN attribute_rec_type Required
117: --

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

110: --
111: -- IN
112: -- p_api_version_number IN NUMBER Required
113: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
114: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
115: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
116: -- p_attribute_rec IN attribute_rec_type Required
117: --
118: -- OUT

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

111: -- IN
112: -- p_api_version_number IN NUMBER Required
113: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
114: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
115: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
116: -- p_attribute_rec IN attribute_rec_type Required
117: --
118: -- OUT
119: -- x_return_status OUT VARCHAR2

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

128: --
129:
130: PROCEDURE Create_Attribute(
131: p_api_version_number IN NUMBER
132: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
133: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
134: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
135:
136: ,x_return_status OUT NOCOPY VARCHAR2

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

129:
130: PROCEDURE Create_Attribute(
131: p_api_version_number IN NUMBER
132: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
133: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
134: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
135:
136: ,x_return_status OUT NOCOPY VARCHAR2
137: ,x_msg_count OUT NOCOPY NUMBER

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

130: PROCEDURE Create_Attribute(
131: p_api_version_number IN NUMBER
132: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
133: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
134: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
135:
136: ,x_return_status OUT NOCOPY VARCHAR2
137: ,x_msg_count OUT NOCOPY NUMBER
138: ,x_msg_data OUT NOCOPY VARCHAR2

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

153: -- Parameters
154: --
155: -- IN
156: -- p_api_version_number IN NUMBER Required
157: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
158: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
159: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
160: -- p_attribute_rec IN attribute_rec_type Required
161: --

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

154: --
155: -- IN
156: -- p_api_version_number IN NUMBER Required
157: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
158: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
159: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
160: -- p_attribute_rec IN attribute_rec_type Required
161: --
162: -- OUT

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

155: -- IN
156: -- p_api_version_number IN NUMBER Required
157: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
158: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
159: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
160: -- p_attribute_rec IN attribute_rec_type Required
161: --
162: -- OUT
163: -- x_return_status OUT VARCHAR2

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

172: --
173:
174: PROCEDURE Update_Attribute(
175: p_api_version_number IN NUMBER
176: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
177: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
178: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
179:
180: ,x_return_status OUT NOCOPY VARCHAR2

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

173:
174: PROCEDURE Update_Attribute(
175: p_api_version_number IN NUMBER
176: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
177: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
178: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
179:
180: ,x_return_status OUT NOCOPY VARCHAR2
181: ,x_msg_count OUT NOCOPY NUMBER

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

174: PROCEDURE Update_Attribute(
175: p_api_version_number IN NUMBER
176: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
177: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
178: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
179:
180: ,x_return_status OUT NOCOPY VARCHAR2
181: ,x_msg_count OUT NOCOPY NUMBER
182: ,x_msg_data OUT NOCOPY VARCHAR2

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

197: -- Parameters
198: --
199: -- IN
200: -- p_api_version_number IN NUMBER Required
201: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
202: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
203: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
204: -- p_ATTRIBUTE_ID IN NUMBER
205: -- p_object_version_number IN NUMBER Optional Default = NULL

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

198: --
199: -- IN
200: -- p_api_version_number IN NUMBER Required
201: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
202: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
203: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
204: -- p_ATTRIBUTE_ID IN NUMBER
205: -- p_object_version_number IN NUMBER Optional Default = NULL
206: --

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

199: -- IN
200: -- p_api_version_number IN NUMBER Required
201: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
202: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
203: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
204: -- p_ATTRIBUTE_ID IN NUMBER
205: -- p_object_version_number IN NUMBER Optional Default = NULL
206: --
207: -- OUT

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

217: --
218:
219: PROCEDURE Delete_Attribute(
220: p_api_version_number IN NUMBER
221: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
222: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
223: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
224: ,x_return_status OUT NOCOPY VARCHAR2
225: ,x_msg_count OUT NOCOPY NUMBER

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

218:
219: PROCEDURE Delete_Attribute(
220: p_api_version_number IN NUMBER
221: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
222: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
223: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
224: ,x_return_status OUT NOCOPY VARCHAR2
225: ,x_msg_count OUT NOCOPY NUMBER
226: ,x_msg_data OUT NOCOPY VARCHAR2

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

219: PROCEDURE Delete_Attribute(
220: p_api_version_number IN NUMBER
221: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
222: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
223: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
224: ,x_return_status OUT NOCOPY VARCHAR2
225: ,x_msg_count OUT NOCOPY NUMBER
226: ,x_msg_data OUT NOCOPY VARCHAR2
227: ,p_attribute_id IN NUMBER

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

240: -- Parameters
241: --
242: -- IN
243: -- p_api_version_number IN NUMBER Required
244: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
245: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
246: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
247: -- p_attribute_rec IN attribute_rec_type Required
248: --

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

241: --
242: -- IN
243: -- p_api_version_number IN NUMBER Required
244: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
245: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
246: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
247: -- p_attribute_rec IN attribute_rec_type Required
248: --
249: -- OUT

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

242: -- IN
243: -- p_api_version_number IN NUMBER Required
244: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
245: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
246: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
247: -- p_attribute_rec IN attribute_rec_type Required
248: --
249: -- OUT
250: -- x_return_status OUT VARCHAR2

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

259: --
260:
261: PROCEDURE Lock_Attribute(
262: p_api_version_number IN NUMBER
263: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
264:
265: ,x_return_status OUT NOCOPY VARCHAR2
266: ,x_msg_count OUT NOCOPY NUMBER
267: ,x_msg_data OUT NOCOPY VARCHAR2

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

283: -- End of Comments
284:
285: PROCEDURE Validate_attribute(
286: p_api_version_number IN NUMBER
287: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
288: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
289: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_UPDATE
290: ,p_attribute_rec IN attribute_rec_type
291: ,x_return_status OUT NOCOPY VARCHAR2

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

284:
285: PROCEDURE Validate_attribute(
286: p_api_version_number IN NUMBER
287: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
288: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
289: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_UPDATE
290: ,p_attribute_rec IN attribute_rec_type
291: ,x_return_status OUT NOCOPY VARCHAR2
292: ,x_msg_count OUT NOCOPY NUMBER

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

322: -- End of Comments
323:
324: PROCEDURE Validate_attribute_rec(
325: p_api_version_number IN NUMBER
326: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
327: ,x_return_status OUT NOCOPY VARCHAR2
328: ,x_msg_count OUT NOCOPY NUMBER
329: ,x_msg_data OUT NOCOPY VARCHAR2
330: ,p_attribute_rec IN attribute_rec_type