DBA Data[Home] [Help]

APPS.PVX_LEAD_PSS_LINES_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_lead_pss_line(
68: p_api_version_number 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_lead_pss_line(
68: p_api_version_number 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_lead_pss_line(
68: p_api_version_number 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_lead_pss_line(
68: p_api_version_number 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_lead_pss_line(
97: p_api_version_number IN NUMBER
98: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
99: ,p_commit IN VARCHAR2 := FND_API.g_false
100:
101: ,x_return_status OUT NOCOPY VARCHAR2
102: ,x_msg_count OUT NOCOPY NUMBER

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

95: --------------------------------------------------------------------
96: PROCEDURE Delete_lead_pss_line(
97: p_api_version_number IN NUMBER
98: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
99: ,p_commit IN VARCHAR2 := FND_API.g_false
100:
101: ,x_return_status OUT NOCOPY VARCHAR2
102: ,x_msg_count OUT NOCOPY NUMBER
103: ,x_msg_data OUT NOCOPY VARCHAR2

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

122: -- 1. Raise exception if the object_version_number doesn't match.
123: --------------------------------------------------------------------
124: PROCEDURE Lock_lead_pss_line(
125: p_api_version_number IN NUMBER
126: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
127:
128: ,x_return_status OUT NOCOPY VARCHAR2
129: ,x_msg_count OUT NOCOPY NUMBER
130: ,x_msg_data OUT NOCOPY VARCHAR2

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

146: -- p_mode : determines what sort of validation is to be performed during update.
147: --
148: -- NOTES
149: -- 1. Raise exception if the object_version_number doesn't match.
150: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
151: -- that column won't be updated.
152: ----------------------------------------------------------------------
153: PROCEDURE Update_lead_pss_line(
154: p_api_version_number IN NUMBER

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

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

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

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

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

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

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

174: -- p_lead_pss_lines_rec: the record to be validated
175: --
176: -- NOTES
177: -- 1. p_lead_pss_lines_rec should be the complete record. There
178: -- should not be any FND_API.g_miss_char/num/date in it.
179: ----------------------------------------------------------------------
180: PROCEDURE Validate_lead_pss_line(
181: p_api_version_number 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_lead_pss_line(
181: p_api_version_number 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_lead_pss_line(
181: p_api_version_number 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 221: -- as FND_API.g_miss_char/num/date

217: -- Check the record level business rules.
218: --
219: -- PARAMETERS
220: -- p_lead_pss_line_rec: the record to be validated; may contain attributes
221: -- as FND_API.g_miss_char/num/date
222: -- p_complete_rec: the complete record after all "g_miss" items
223: -- have been replaced by current database values
224: ---------------------------------------------------------------------
225: PROCEDURE Check_lead_pss_line_Record(

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

234: -- PROCEDURE
235: -- Init_lead_pss_line_rec
236: --
237: -- PURPOSE
238: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
239: ---------------------------------------------------------------------
240: PROCEDURE Init_lead_pss_line_rec(
241: x_lead_pss_lines_rec OUT NOCOPY lead_pss_lines_rec_type
242: );

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

247: -- Complete_lead_pss_line_rec
248: --
249: -- PURPOSE
250: -- For update, some attributes may be passed in as
251: -- FND_API.g_miss_char/num/date if the user doesn't want to
252: -- update those attributes. This procedure will replace the
253: -- "g_miss" attributes with current database values.
254: --
255: -- PARAMETERS

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

253: -- "g_miss" attributes with current database values.
254: --
255: -- PARAMETERS
256: -- p_lead_pss_line_rec: the record which may contain attributes as
257: -- FND_API.g_miss_char/num/date
258: -- x_complete_rec: the complete record after all "g_miss" items
259: -- have been replaced by current database values
260: ---------------------------------------------------------------------
261: PROCEDURE Complete_lead_pss_line_rec(