59: l_status varchar2(1);
60: l_var2 number;
61:
62: BEGIN
63: -- Standard Start of API savepoint
64: SAVEPOINT EAM_ASSET_LOG_PVT_SV;
65:
66: -- Standard call to check for call compatibility.
67: IF NOT fnd_api.compatible_api_call(
62: BEGIN
63: -- Standard Start of API savepoint
64: SAVEPOINT EAM_ASSET_LOG_PVT_SV;
65:
66: -- Standard call to check for call compatibility.
67: IF NOT fnd_api.compatible_api_call(
68: l_api_version
69: ,p_api_version
70: ,l_api_name
234:
235: END IF;
236:
237: -- End of API body.
238: -- Standard check of p_commit.
239: IF fnd_api.to_boolean(p_commit) THEN
240: COMMIT WORK;
241: END IF;
242: fnd_msg_pub.count_and_get(
297: l_organization_id number;
298: l_dummy number;
299:
300: BEGIN
301: -- Standard Start of API savepoint
302: SAVEPOINT EAM_ASSET_LOG_PVT_SV;
303:
304: -- Standard call to check for call compatibility.
305: IF NOT fnd_api.compatible_api_call(
300: BEGIN
301: -- Standard Start of API savepoint
302: SAVEPOINT EAM_ASSET_LOG_PVT_SV;
303:
304: -- Standard call to check for call compatibility.
305: IF NOT fnd_api.compatible_api_call(
306: l_api_version
307: ,p_api_version
308: ,l_api_name
561: l_organization_id number;
562: BEGIN
563: retcode:=0;
564:
565: -- Standard Start of API savepoint
566: SAVEPOINT EAM_ASSET_LOG_PVT_SV;
567:
568: begin
569: select nvl(maint_organization_id, p_organization_id) into l_organization_id
669: l_date date;
670:
671: BEGIN
672:
673: /* Standard Start of API savepoint */
674: SAVEPOINT EAM_ASSET_LOG_PVT;
675:
676: /* Standard call to check for call compatibility. */
677: IF NOT FND_API.Compatible_API_Call
672:
673: /* Standard Start of API savepoint */
674: SAVEPOINT EAM_ASSET_LOG_PVT;
675:
676: /* Standard call to check for call compatibility. */
677: IF NOT FND_API.Compatible_API_Call
678: ( l_api_version ,
679: p_api_version ,
680: l_api_name ,
790: x_msg_data => x_msg_data
791: );
792: END IF;
793:
794: /* Standard check of p_commit. */
795:
796: IF FND_API.TO_BOOLEAN( P_COMMIT ) THEN
797: COMMIT WORK;
798: END IF;
796: IF FND_API.TO_BOOLEAN( P_COMMIT ) THEN
797: COMMIT WORK;
798: END IF;
799:
800: -- Standard call to get message count and if count is 1, get message info.
801:
802: fnd_msg_pub.get
803: ( p_msg_index_out => x_msg_count ,
804: p_data => x_msg_data
879: FROM csi_counter_associations caa, csi_item_instances cii
880: WHERE caa.counter_id = p_ref_id AND
881: cii.instance_id = caa.source_object_id;
882: BEGIN
883: -- Standard Start of API savepoint
884: SAVEPOINT EAM_ASSET_LOG_PVT_SV;
885:
886: -- Standard call to check for call compatibility.
887: IF NOT fnd_api.compatible_api_call(
882: BEGIN
883: -- Standard Start of API savepoint
884: SAVEPOINT EAM_ASSET_LOG_PVT_SV;
885:
886: -- Standard call to check for call compatibility.
887: IF NOT fnd_api.compatible_api_call(
888: l_api_version
889: ,p_api_version
890: ,l_api_name
981: END IF;
982: END LOOP;
983:
984: -- End of API body.
985: -- Standard check of p_commit.
986: IF fnd_api.to_boolean(p_commit) THEN
987: COMMIT WORK;
988: END IF;
989: