84: x_error_segments NUMBER;
85: x_error_message VARCHAR2(5000);
86: BEGIN
87:
88: /* Standard Start of API savepoint */
89: SAVEPOINT Insert_ActivitySupn_PUB;
90:
91: /* Standard call to check for call compatibility. */
92: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
87:
88: /* Standard Start of API savepoint */
89: SAVEPOINT Insert_ActivitySupn_PUB;
90:
91: /* Standard call to check for call compatibility. */
92: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
93: p_api_version ,
94: l_api_name ,
95: G_PKG_NAME
250: p_attribute14 ,
251: p_attribute15
252: );
253:
254: /* Standard check of p_commit. */
255: IF FND_API.TO_BOOLEAN( P_COMMIT ) THEN
256: COMMIT WORK;
257: END IF;
258: -- Standard call to get message count and if count is 1, get message info.
254: /* Standard check of p_commit. */
255: IF FND_API.TO_BOOLEAN( P_COMMIT ) THEN
256: COMMIT WORK;
257: END IF;
258: -- Standard call to get message count and if count is 1, get message info.
259: FND_MSG_PUB.get
260: ( p_msg_index_out => x_msg_count ,
261: p_data => x_msg_data
262: );
374: x_error_segments NUMBER;
375: x_error_message VARCHAR2(5000);
376: BEGIN
377:
378: /* Standard Start of API savepoint */
379: SAVEPOINT Update_ActivitySupn_PUB;
380: /* Standard call to check for call compatibility. */
381: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
382: p_api_version ,
376: BEGIN
377:
378: /* Standard Start of API savepoint */
379: SAVEPOINT Update_ActivitySupn_PUB;
380: /* Standard call to check for call compatibility. */
381: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
382: p_api_version ,
383: l_api_name ,
384: G_PKG_NAME
468: WHERE
469: parent_association_id = p_parent_association_id
470: AND
471: child_association_id = p_child_association_id ;
472: /* Standard check of p_commit. */
473: IF FND_API.TO_BOOLEAN( P_COMMIT ) THEN
474: COMMIT WORK;
475: END IF;
476: -- Standard call to get message count and if count is 1, get message info.
472: /* Standard check of p_commit. */
473: IF FND_API.TO_BOOLEAN( P_COMMIT ) THEN
474: COMMIT WORK;
475: END IF;
476: -- Standard call to get message count and if count is 1, get message info.
477: FND_MSG_PUB.get
478: ( p_msg_index_out => x_msg_count ,
479: p_data => x_msg_data
480: );