DBA Data[Home] [Help]

APPS.PV_ATTR_PRINCIPAL_PVT dependencies on FND_API

Line 46: Attr_Principal_id NUMBER := FND_API.G_MISS_NUM

42: --===================================================================
43:
44: TYPE Attr_Principal_rec_type IS RECORD
45: (
46: Attr_Principal_id NUMBER := FND_API.G_MISS_NUM
47: ,last_update_date DATE := FND_API.G_MISS_DATE
48: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
49: ,creation_date DATE := FND_API.G_MISS_DATE
50: ,created_by NUMBER := FND_API.G_MISS_NUM

Line 47: ,last_update_date DATE := FND_API.G_MISS_DATE

43:
44: TYPE Attr_Principal_rec_type IS RECORD
45: (
46: Attr_Principal_id NUMBER := FND_API.G_MISS_NUM
47: ,last_update_date DATE := FND_API.G_MISS_DATE
48: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
49: ,creation_date DATE := FND_API.G_MISS_DATE
50: ,created_by NUMBER := FND_API.G_MISS_NUM
51: ,last_update_login NUMBER := FND_API.G_MISS_NUM

Line 48: ,last_updated_by NUMBER := FND_API.G_MISS_NUM

44: TYPE Attr_Principal_rec_type IS RECORD
45: (
46: Attr_Principal_id NUMBER := FND_API.G_MISS_NUM
47: ,last_update_date DATE := FND_API.G_MISS_DATE
48: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
49: ,creation_date DATE := FND_API.G_MISS_DATE
50: ,created_by NUMBER := FND_API.G_MISS_NUM
51: ,last_update_login NUMBER := FND_API.G_MISS_NUM
52: ,object_version_number NUMBER := FND_API.G_MISS_NUM

Line 49: ,creation_date DATE := FND_API.G_MISS_DATE

45: (
46: Attr_Principal_id NUMBER := FND_API.G_MISS_NUM
47: ,last_update_date DATE := FND_API.G_MISS_DATE
48: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
49: ,creation_date DATE := FND_API.G_MISS_DATE
50: ,created_by NUMBER := FND_API.G_MISS_NUM
51: ,last_update_login NUMBER := FND_API.G_MISS_NUM
52: ,object_version_number NUMBER := FND_API.G_MISS_NUM
53: ,attribute_id NUMBER := FND_API.G_MISS_NUM

Line 50: ,created_by NUMBER := FND_API.G_MISS_NUM

46: Attr_Principal_id NUMBER := FND_API.G_MISS_NUM
47: ,last_update_date DATE := FND_API.G_MISS_DATE
48: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
49: ,creation_date DATE := FND_API.G_MISS_DATE
50: ,created_by NUMBER := FND_API.G_MISS_NUM
51: ,last_update_login NUMBER := FND_API.G_MISS_NUM
52: ,object_version_number NUMBER := FND_API.G_MISS_NUM
53: ,attribute_id NUMBER := FND_API.G_MISS_NUM
54: ,jtf_auth_principal_id NUMBER := FND_API.G_MISS_NUM

Line 51: ,last_update_login NUMBER := FND_API.G_MISS_NUM

47: ,last_update_date DATE := FND_API.G_MISS_DATE
48: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
49: ,creation_date DATE := FND_API.G_MISS_DATE
50: ,created_by NUMBER := FND_API.G_MISS_NUM
51: ,last_update_login NUMBER := FND_API.G_MISS_NUM
52: ,object_version_number NUMBER := FND_API.G_MISS_NUM
53: ,attribute_id NUMBER := FND_API.G_MISS_NUM
54: ,jtf_auth_principal_id NUMBER := FND_API.G_MISS_NUM
55: );

Line 52: ,object_version_number NUMBER := FND_API.G_MISS_NUM

48: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
49: ,creation_date DATE := FND_API.G_MISS_DATE
50: ,created_by NUMBER := FND_API.G_MISS_NUM
51: ,last_update_login NUMBER := FND_API.G_MISS_NUM
52: ,object_version_number NUMBER := FND_API.G_MISS_NUM
53: ,attribute_id NUMBER := FND_API.G_MISS_NUM
54: ,jtf_auth_principal_id NUMBER := FND_API.G_MISS_NUM
55: );
56:

Line 53: ,attribute_id NUMBER := FND_API.G_MISS_NUM

49: ,creation_date DATE := FND_API.G_MISS_DATE
50: ,created_by NUMBER := FND_API.G_MISS_NUM
51: ,last_update_login NUMBER := FND_API.G_MISS_NUM
52: ,object_version_number NUMBER := FND_API.G_MISS_NUM
53: ,attribute_id NUMBER := FND_API.G_MISS_NUM
54: ,jtf_auth_principal_id NUMBER := FND_API.G_MISS_NUM
55: );
56:
57:

Line 54: ,jtf_auth_principal_id NUMBER := FND_API.G_MISS_NUM

50: ,created_by NUMBER := FND_API.G_MISS_NUM
51: ,last_update_login NUMBER := FND_API.G_MISS_NUM
52: ,object_version_number NUMBER := FND_API.G_MISS_NUM
53: ,attribute_id NUMBER := FND_API.G_MISS_NUM
54: ,jtf_auth_principal_id NUMBER := FND_API.G_MISS_NUM
55: );
56:
57:
58: g_miss_Attr_Principal_rec Attr_Principal_rec_type;

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

71: -- Parameters
72: --
73: -- IN
74: -- p_api_version_number IN NUMBER Required
75: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
76: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
77: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
78: -- p_Attribute_Principal_rec IN Attribute_Principal_rec_type Required
79: --

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

72: --
73: -- IN
74: -- p_api_version_number IN NUMBER Required
75: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
76: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
77: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
78: -- p_Attribute_Principal_rec IN Attribute_Principal_rec_type Required
79: --
80: -- OUT

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

73: -- IN
74: -- p_api_version_number IN NUMBER Required
75: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
76: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
77: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
78: -- p_Attribute_Principal_rec IN Attribute_Principal_rec_type Required
79: --
80: -- OUT
81: -- x_return_status OUT VARCHAR2

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

88: --
89:
90: PROCEDURE Create_Attr_Principal(
91: p_api_version_number IN NUMBER
92: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
93: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
94: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
95:
96: ,x_return_status OUT NOCOPY VARCHAR2

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

89:
90: PROCEDURE Create_Attr_Principal(
91: p_api_version_number IN NUMBER
92: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
93: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
94: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
95:
96: ,x_return_status OUT NOCOPY VARCHAR2
97: ,x_msg_count OUT NOCOPY NUMBER

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

90: PROCEDURE Create_Attr_Principal(
91: p_api_version_number IN NUMBER
92: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
93: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
94: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
95:
96: ,x_return_status OUT NOCOPY VARCHAR2
97: ,x_msg_count OUT NOCOPY NUMBER
98: ,x_msg_data OUT NOCOPY VARCHAR2

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

113: -- Parameters
114: --
115: -- IN
116: -- p_api_version_number IN NUMBER Required
117: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
118: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
119: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
120: -- p_Attribute_Principal_rec IN Attribute_Principal_rec_type Required
121: --

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

114: --
115: -- IN
116: -- p_api_version_number IN NUMBER Required
117: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
118: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
119: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
120: -- p_Attribute_Principal_rec IN Attribute_Principal_rec_type Required
121: --
122: -- OUT

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

115: -- IN
116: -- p_api_version_number IN NUMBER Required
117: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
118: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
119: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
120: -- p_Attribute_Principal_rec IN Attribute_Principal_rec_type Required
121: --
122: -- OUT
123: -- x_return_status OUT VARCHAR2

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

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

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

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

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

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

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

154: -- Parameters
155: --
156: -- IN
157: -- p_api_version_number IN NUMBER Required
158: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
159: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
160: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
161: -- p_Attribute_Principal_ID IN NUMBER
162: -- p_object_version_number IN NUMBER Optional Default = NULL

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

155: --
156: -- IN
157: -- p_api_version_number IN NUMBER Required
158: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
159: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
160: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
161: -- p_Attribute_Principal_ID IN NUMBER
162: -- p_object_version_number IN NUMBER Optional Default = NULL
163: --

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

156: -- IN
157: -- p_api_version_number IN NUMBER Required
158: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
159: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
160: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
161: -- p_Attribute_Principal_ID IN NUMBER
162: -- p_object_version_number IN NUMBER Optional Default = NULL
163: --
164: -- OUT

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

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

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

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

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

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

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

196: -- Parameters
197: --
198: -- IN
199: -- p_api_version_number IN NUMBER Required
200: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
201: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
202: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
203: -- p_Attribute_Principal_rec IN Attribute_Principal_rec_type Required
204: --

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

197: --
198: -- IN
199: -- p_api_version_number IN NUMBER Required
200: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
201: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
202: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
203: -- p_Attribute_Principal_rec IN Attribute_Principal_rec_type Required
204: --
205: -- OUT

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

198: -- IN
199: -- p_api_version_number IN NUMBER Required
200: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
201: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
202: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
203: -- p_Attribute_Principal_rec IN Attribute_Principal_rec_type Required
204: --
205: -- OUT
206: -- x_return_status OUT VARCHAR2

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

215: --
216:
217: PROCEDURE Lock_Attr_Principal(
218: p_api_version_number IN NUMBER
219: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
220:
221: ,x_return_status OUT NOCOPY VARCHAR2
222: ,x_msg_count OUT NOCOPY NUMBER
223: ,x_msg_data OUT NOCOPY VARCHAR2

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

236: -- End of Comments
237:
238: PROCEDURE Validate_Attr_Principal(
239: p_api_version_number IN NUMBER
240: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
241: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
242: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
243: ,p_Attr_Principal_rec IN Attr_Principal_rec_type
244: ,x_return_status OUT NOCOPY VARCHAR2

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

237:
238: PROCEDURE Validate_Attr_Principal(
239: p_api_version_number IN NUMBER
240: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
241: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
242: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
243: ,p_Attr_Principal_rec IN Attr_Principal_rec_type
244: ,x_return_status OUT NOCOPY VARCHAR2
245: ,x_msg_count OUT NOCOPY NUMBER

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

258: -- End of Comments
259:
260: PROCEDURE Validate_Attr_Principal_Rec(
261: p_api_version_number IN NUMBER
262: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
263: ,x_return_status OUT NOCOPY VARCHAR2
264: ,x_msg_count OUT NOCOPY NUMBER
265: ,x_msg_data OUT NOCOPY VARCHAR2
266: ,p_Attr_Principal_rec IN Attr_Principal_rec_type