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.AMS_USER_STATUSES_PVT dependencies on FND_API

Line 72: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.

68: -- Raise exception in case of duplicates.
69: -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
70: -- Raise exception for invalid flag.
71: -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
72: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
73: --------------------------------------------------------------------
74: PROCEDURE Create_User_Status (
75: p_api_version IN NUMBER,
76: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

Line 76: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

72: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
73: --------------------------------------------------------------------
74: PROCEDURE Create_User_Status (
75: p_api_version IN NUMBER,
76: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
77: p_commit IN VARCHAR2 := FND_API.g_false,
78: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
79:
80: x_return_status OUT NOCOPY VARCHAR2,

Line 77: p_commit IN VARCHAR2 := FND_API.g_false,

73: --------------------------------------------------------------------
74: PROCEDURE Create_User_Status (
75: p_api_version IN NUMBER,
76: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
77: p_commit IN VARCHAR2 := FND_API.g_false,
78: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
79:
80: x_return_status OUT NOCOPY VARCHAR2,
81: x_msg_count OUT NOCOPY NUMBER,

Line 78: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

74: PROCEDURE Create_User_Status (
75: p_api_version IN NUMBER,
76: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
77: p_commit IN VARCHAR2 := FND_API.g_false,
78: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
79:
80: x_return_status OUT NOCOPY VARCHAR2,
81: x_msg_count OUT NOCOPY NUMBER,
82: x_msg_data OUT NOCOPY VARCHAR2,

Line 100: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,

96: -- p_user_status_rec: the record representing AMS_USER_STATUSES_VL (without the ROW_ID column).
97: --
98: -- NOTES
99: -- 1. Raise exception if the object_version_number doesn't match.
100: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
101: -- that column won't be updated.
102: --------------------------------------------------------------------
103: PROCEDURE Update_User_Status (
104: p_api_version IN NUMBER,

Line 105: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

101: -- that column won't be updated.
102: --------------------------------------------------------------------
103: PROCEDURE Update_User_Status (
104: p_api_version IN NUMBER,
105: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
106: p_commit IN VARCHAR2 := FND_API.g_false,
107: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
108:
109: x_return_status OUT NOCOPY VARCHAR2,

Line 106: p_commit IN VARCHAR2 := FND_API.g_false,

102: --------------------------------------------------------------------
103: PROCEDURE Update_User_Status (
104: p_api_version IN NUMBER,
105: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
106: p_commit IN VARCHAR2 := FND_API.g_false,
107: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
108:
109: x_return_status OUT NOCOPY VARCHAR2,
110: x_msg_count OUT NOCOPY NUMBER,

Line 107: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

103: PROCEDURE Update_User_Status (
104: p_api_version IN NUMBER,
105: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
106: p_commit IN VARCHAR2 := FND_API.g_false,
107: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
108:
109: x_return_status OUT NOCOPY VARCHAR2,
110: x_msg_count OUT NOCOPY NUMBER,
111: x_msg_data OUT NOCOPY VARCHAR2,

Line 134: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

130: -- 1. Raise exception if the object_version_number doesn't match.
131: --------------------------------------------------------------------
132: PROCEDURE Delete_User_Status (
133: p_api_version IN NUMBER,
134: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
135: p_commit IN VARCHAR2 := FND_API.g_false,
136: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
137:
138: x_return_status OUT NOCOPY VARCHAR2,

Line 135: p_commit IN VARCHAR2 := FND_API.g_false,

131: --------------------------------------------------------------------
132: PROCEDURE Delete_User_Status (
133: p_api_version IN NUMBER,
134: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
135: p_commit IN VARCHAR2 := FND_API.g_false,
136: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
137:
138: x_return_status OUT NOCOPY VARCHAR2,
139: x_msg_count OUT NOCOPY NUMBER,

Line 136: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

132: PROCEDURE Delete_User_Status (
133: p_api_version IN NUMBER,
134: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
135: p_commit IN VARCHAR2 := FND_API.g_false,
136: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
137:
138: x_return_status OUT NOCOPY VARCHAR2,
139: x_msg_count OUT NOCOPY NUMBER,
140: x_msg_data OUT NOCOPY VARCHAR2,

Line 164: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

160: -- 1. Raise exception if the object_version_number doesn't match.
161: --------------------------------------------------------------------
162: PROCEDURE Lock_User_Status (
163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
165: p_commit IN VARCHAR2 := FND_API.g_false,
166: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
167:
168: x_return_status OUT NOCOPY VARCHAR2,

Line 165: p_commit IN VARCHAR2 := FND_API.g_false,

161: --------------------------------------------------------------------
162: PROCEDURE Lock_User_Status (
163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
165: p_commit IN VARCHAR2 := FND_API.g_false,
166: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
167:
168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,

Line 166: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

162: PROCEDURE Lock_User_Status (
163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
165: p_commit IN VARCHAR2 := FND_API.g_false,
166: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
167:
168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,
170: x_msg_data OUT NOCOPY VARCHAR2,

Line 188: -- should not be any FND_API.g_miss_char/num/date in it.

184: -- p_user_status_rec: the record representing AMS_USER_STATUSES_VL (without ROW_ID).
185: --
186: -- NOTES
187: -- 1. p_user_status_rec should be the complete user_status record. There
188: -- should not be any FND_API.g_miss_char/num/date in it.
189: -- 2. If FND_API.g_miss_char/num/date is in the record, then raise
190: -- an exception, as those values are not handled.
191: --------------------------------------------------------------------
192: PROCEDURE Validate_User_Status (

Line 189: -- 2. If FND_API.g_miss_char/num/date is in the record, then raise

185: --
186: -- NOTES
187: -- 1. p_user_status_rec should be the complete user_status record. There
188: -- should not be any FND_API.g_miss_char/num/date in it.
189: -- 2. If FND_API.g_miss_char/num/date is in the record, then raise
190: -- an exception, as those values are not handled.
191: --------------------------------------------------------------------
192: PROCEDURE Validate_User_Status (
193: p_api_version IN NUMBER,

Line 194: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

190: -- an exception, as those values are not handled.
191: --------------------------------------------------------------------
192: PROCEDURE Validate_User_Status (
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
195: p_commit IN VARCHAR2 := FND_API.g_false,
196: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
197:
198: x_return_status OUT NOCOPY VARCHAR2,

Line 195: p_commit IN VARCHAR2 := FND_API.g_false,

191: --------------------------------------------------------------------
192: PROCEDURE Validate_User_Status (
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
195: p_commit IN VARCHAR2 := FND_API.g_false,
196: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
197:
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,

Line 196: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

192: PROCEDURE Validate_User_Status (
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
195: p_commit IN VARCHAR2 := FND_API.g_false,
196: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
197:
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,
200: x_msg_data OUT NOCOPY VARCHAR2,

Line 232: -- as FND_API.g_miss_char/num/date

228: -- Check the record level business rules.
229: --
230: -- PARAMETERS
231: -- p_user_status_rec: the record to be validated; may contain attributes
232: -- as FND_API.g_miss_char/num/date
233: -- p_complete_rec: the complete record after all "g_miss" items
234: -- have been replaced by current database values
235: ---------------------------------------------------------------------
236: PROCEDURE Check_User_Status_Record (

Line 247: -- Initialize all attributes to be FND_API.g_miss_char/num/date.

243: -- PROCEDURE
244: -- Init_User_Status_Rec
245: --
246: -- PURPOSE
247: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
248: ---------------------------------------------------------------------
249: PROCEDURE Init_User_Status_Rec (
250: x_user_status_rec OUT NOCOPY User_Status_Rec_Type
251: );

Line 259: -- FND_API.g_miss_char/num/date if the user doesn't want to

255: -- Complete_User_Status_Rec
256: --
257: -- PURPOSE
258: -- For Update_User_Status, some attributes may be passed in as
259: -- FND_API.g_miss_char/num/date if the user doesn't want to
260: -- update those attributes. This procedure will replace the
261: -- "g_miss" attributes with current database values.
262: --
263: -- PARAMETERS

Line 265: -- FND_API.g_miss_char/num/date

261: -- "g_miss" attributes with current database values.
262: --
263: -- PARAMETERS
264: -- p_user_status_rec: the record which may contain attributes as
265: -- FND_API.g_miss_char/num/date
266: -- x_complete_rec: the complete record after all "g_miss" items
267: -- have been replaced by current database values
268: ---------------------------------------------------------------------
269: PROCEDURE Complete_User_Status_Rec (