DBA Data[Home] [Help]

APPS.PVX_PRTNR_PRFLS_PVT dependencies on FND_API

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

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

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

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

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

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

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

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

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

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

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

96: --------------------------------------------------------------------
97: PROCEDURE Delete_Prtnr_Prfls(
98: p_api_version IN NUMBER
99: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
100: ,p_commit IN VARCHAR2 := FND_API.g_false
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_Prtnr_Prfls(
126: p_api_version IN NUMBER
127: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
128:
129: ,x_return_status OUT NOCOPY VARCHAR2
130: ,x_msg_count OUT NOCOPY NUMBER
131: ,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_mode : determines what sort of validation is to be performed during update.
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_Prtnr_Prfls(
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_Prtnr_Prfls(
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_Prtnr_Prfls(
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_Prtnr_Prfls(
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 179: -- should not be any FND_API.g_miss_char/num/date in it.

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

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

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

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

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

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

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

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

235: -- PROCEDURE
236: -- Init_Prtnr_Prfls_rec
237: --
238: -- PURPOSE
239: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
240: ---------------------------------------------------------------------
241: PROCEDURE Init_Prtnr_Prfls_Rec(
242: x_prtnr_prfls_rec OUT NOCOPY prtnr_prfls_rec_type
243: );

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

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

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

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