DBA Data[Home] [Help]

APPS.AMS_ASSOCIATIONS_PVT dependencies on FND_API

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

61: -- the sequence.
62: -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
63: -- Raise exception for invalid flag.
64: -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
65: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
66: ---------------------------------------------------------------------
67: PROCEDURE create_association(
68: p_api_version IN NUMBER,
69: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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

65: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
66: ---------------------------------------------------------------------
67: PROCEDURE create_association(
68: p_api_version IN NUMBER,
69: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
70: p_commit IN VARCHAR2 := FND_API.g_false,
71: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
72:
73: x_return_status OUT NOCOPY VARCHAR2,

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

66: ---------------------------------------------------------------------
67: PROCEDURE create_association(
68: p_api_version IN NUMBER,
69: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
70: p_commit IN VARCHAR2 := FND_API.g_false,
71: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
72:
73: x_return_status OUT NOCOPY VARCHAR2,
74: x_msg_count OUT NOCOPY NUMBER,

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

67: PROCEDURE create_association(
68: p_api_version IN NUMBER,
69: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
70: p_commit IN VARCHAR2 := FND_API.g_false,
71: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
72:
73: x_return_status OUT NOCOPY VARCHAR2,
74: x_msg_count OUT NOCOPY NUMBER,
75: x_msg_data OUT NOCOPY VARCHAR2,

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

94: -- 1. Raise exception if the object_version_number doesn't match.
95: --------------------------------------------------------------------
96: PROCEDURE delete_association(
97: p_api_version IN NUMBER,
98: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
99: p_commit IN VARCHAR2 := FND_API.g_false,
100: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
101:
102: x_return_status OUT NOCOPY VARCHAR2,

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

95: --------------------------------------------------------------------
96: PROCEDURE delete_association(
97: p_api_version IN NUMBER,
98: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
99: p_commit IN VARCHAR2 := FND_API.g_false,
100: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
101:
102: x_return_status OUT NOCOPY VARCHAR2,
103: x_msg_count OUT NOCOPY NUMBER,

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

96: PROCEDURE delete_association(
97: p_api_version IN NUMBER,
98: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
99: p_commit IN VARCHAR2 := FND_API.g_false,
100: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
101:
102: x_return_status OUT NOCOPY VARCHAR2,
103: x_msg_count OUT NOCOPY NUMBER,
104: x_msg_data OUT NOCOPY VARCHAR2,

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

123: -- 1. Raise exception if the object_version_number doesn't match.
124: --------------------------------------------------------------------
125: PROCEDURE lock_association(
126: p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
128: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
129:
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,

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

124: --------------------------------------------------------------------
125: PROCEDURE lock_association(
126: p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
128: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
129:
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2,

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

147: -- p_association_rec: the record with new items
148: --
149: -- NOTES
150: -- 1. Raise exception if the object_version_number doesn't match.
151: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
152: -- that column won't be updated.
153: ----------------------------------------------------------------------
154: PROCEDURE update_association(
155: p_api_version IN NUMBER,

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

152: -- that column won't be updated.
153: ----------------------------------------------------------------------
154: PROCEDURE update_association(
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
157: p_commit IN VARCHAR2 := FND_API.g_false,
158: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
159:
160: x_return_status OUT NOCOPY VARCHAR2,

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

153: ----------------------------------------------------------------------
154: PROCEDURE update_association(
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
157: p_commit IN VARCHAR2 := FND_API.g_false,
158: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
159:
160: x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,

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

154: PROCEDURE update_association(
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
157: p_commit IN VARCHAR2 := FND_API.g_false,
158: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
159:
160: x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
162: x_msg_data OUT NOCOPY VARCHAR2,

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

174: -- p_association_rec: the association record to be validated
175: --
176: -- NOTES
177: -- 1. p_association_rec should be the complete association record. There
178: -- should not be any FND_API.g_miss_char/num/date in it.
179: ----------------------------------------------------------------------
180: PROCEDURE validate_association(
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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

178: -- should not be any FND_API.g_miss_char/num/date in it.
179: ----------------------------------------------------------------------
180: PROCEDURE validate_association(
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
183: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
184:
185: x_return_status OUT NOCOPY VARCHAR2,
186: x_msg_count OUT NOCOPY NUMBER,

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

179: ----------------------------------------------------------------------
180: PROCEDURE validate_association(
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
183: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
184:
185: x_return_status OUT NOCOPY VARCHAR2,
186: x_msg_count OUT NOCOPY NUMBER,
187: x_msg_data OUT NOCOPY VARCHAR2,

Line 220: -- as FND_API.g_miss_char/num/date completed

216: -- Check the record level business rules.
217: --
218: -- PARAMETERS
219: -- p_association_rec: the record to be validated; attributes
220: -- as FND_API.g_miss_char/num/date completed
221: ---------------------------------------------------------------------
222: PROCEDURE check_association_record(
223: p_association_rec IN association_rec_type,
224: x_return_status OUT NOCOPY VARCHAR2

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

229: -- complete_association_rec
230: --
231: -- PURPOSE
232: -- For update_association, some attributes may be passed in as
233: -- FND_API.g_miss_char/num/date if the user doesn't want to
234: -- update those attributes. This procedure will replace the
235: -- "g_miss" attributes with current database values.
236: --
237: -- PARAMETERS

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

235: -- "g_miss" attributes with current database values.
236: --
237: -- PARAMETERS
238: -- p_association_rec: the record which may contain attributes as
239: -- FND_API.g_miss_char/num/date
240: -- x_complete_rec: the complete record after all "g_miss" items
241: -- have been replaced by current database values
242: ---------------------------------------------------------------------
243: PROCEDURE complete_association_rec(